Mantis - Resin
Viewing Issue Advanced Details
1718 minor always 04-27-07 08:18 06-19-07 09:34
sam  
ferg  
normal  
closed 3.1.0  
fixed  
none    
none 3.1.2  
0001718: jpa: tries to create sequence that already exists
The application has <create-database-schema> true, the tables already exist, the first attempt to do an update in a transaction fails because Amber tries to create the sequence that already exists.

[11:15:21.472] jdbc/recipes.1.9:createStatement()
[11:15:21.521] jdbc/recipes.1.9:exn-executeUpdate(CREATE SEQUENCE categories_cseq INCREMENT 50) -> org.postgresql.util.PSQLException: ERROR: relation "categories_cseq" already exists
[11:15:21.521] jdbc/recipes.1.9:close()
[11:15:21.521] jdbc/recipes.1.10:prepareStatement(SELECT Nextval('categories_cseq'))
[11:15:21.523] jdbc/recipes.1.10:executeQuery(SELECT Nextval('categories_cseq'))
[11:15:21.524] jdbc/recipes.1.10:exn-executeQuery(org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block)

There are no notes attached to this issue.