Description

Issue creation fails with the following error:

org.hibernate.exception.SQLGrammarException:
JDBC exception executing SQL [SELECT NEXTVAL('global_issue_seq')]
ERROR: relation "global_issue_seq" does not exist

This prevents issue creation entirely.

Root Cause (Hypothesis)

The PostgreSQL sequence global_issue_seq is not created in the database.

Possible causes:

• Missing Flyway migration
• Migration ordering issue
• Sequence created manually in development but not included in schema migration

Expected Behavior

The sequence global_issue_seq must exist in the database before issue creation.

Required Fix

• Add Flyway migration to create sequence:

  CREATE SEQUENCE global_issue_seq START 1 INCREMENT 1;
  

• Validate that fresh database setup runs cleanly.

• Verify Flyway migration history consistency.

Acceptance Criteria

• Fresh DB initialization works
• Issue creation succeeds
• No SQLGrammarException thrown