org.h2.jdbc.JdbcSQLException: Unable to create or alter sequence "xxx_SEQ" because of invalid attributes (start value "0", min value "1", max value "9223372036854775807", increment "1");

[Leo Martins]

Hi, 

  I've started getting the following issue when migrating from 1.7.3 to 1.7.5:

org.h2.jdbc.JdbcSQLException: Unable to create or alter sequence "SCHEDULE_TABLE_SEQ" because of invalid attributes (start value "0", min value "1", max value "9223372036854775807", increment "1"); SQL statement:
CREATE SEQUENCE PUBLIC.SCHEDULE_TABLE_SEQ START WITH 0 [90009-175]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
	at org.h2.message.DbException.get(DbException.java:172)
	at org.h2.schema.Sequence.<init>(Sequence.java:77)
	at org.h2.command.ddl.CreateSequence.update(CreateSequence.java:66)
	at org.h2.engine.MetaRecord.execute(MetaRecord.java:58)
	at org.h2.engine.Database.open(Database.java:686)
	at org.h2.engine.Database.openDatabase(Database.java:244)
	at org.h2.engine.Database.<init>(Database.java:239)
	at org.h2.engine.Engine.openSession(Engine.java:56)
	at org.h2.engine.Engine.openSession(Engine.java:160)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139)
	at org.h2.engine.Engine.createSession(Engine.java:122)
	at org.h2.engine.Engine.createSession(Engine.java:28)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90)
	at org.h2.Driver.connect(Driver.java:73)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:187)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173)
	at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164)
	at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
	at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
	at com.pontusnetworks.utils.MigrateDb.getLocalReferenceDb(MigrateDb.java:112)

I've put more details in the following bug: ID: https://code.google.com/p/h2database/issues/detail?id=547

[Noel Grandin]

On 2014-02-10 16:55, Leo Martins wrote:
> Hi,
>
>
> I've started getting the following issue when migrating from 1.7.3 to 1.7.5:
>

This bug has been fixed in SVN.