Hi Thomas,
Please find the below 3 different exceptions.
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Error opening
database: Lock file modification time is in the future; if required please
delete the file /opt/CSCOacs/view/data/h2/acsview_session.lock.db manually
and retry; dist=-12148536 [8000-114]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.store.FileLock.getExceptionFatal(FileLock.java:471)
at org.h2.store.FileLock.waitUntilOld(FileLock.java:283)
at org.h2.store.FileLock.lockFile(FileLock.java:330)
at org.h2.store.FileLock.lock(FileLock.java:130)
at org.h2.engine.Database.open(Database.java:555)
at org.h2.engine.Database.openDatabase(Database.java:219)
at org.h2.engine.Database.<init>(Database.java:214)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.getEmbbededH2(DbConnection.java:69)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.init(DbConnection.java:88)
at com.cisco.nm.acs.view.collector.Main.init(Main.java:60)
at com.cisco.nm.acs.view.collector.Main.main(Main.java:120)
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Unique index or
primary key violation: SYS_ID ON PUBLIC.SYS(ID) [23001-114]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.getSQLException(Message.java:116)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:154)
at org.h2.index.TreeIndex.add(TreeIndex.java:58)
at org.h2.table.TableData.addRowsToIndex(TableData.java:282)
at org.h2.table.TableData.addIndex(TableData.java:217)
at org.h2.engine.Database.open(Database.java:628)
at org.h2.engine.Database.openDatabase(Database.java:219)
at org.h2.engine.Database.<init>(Database.java:214)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.getEmbbededH2(DbConnection.java:69)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.init(DbConnection.java:88)
at com.cisco.nm.acs.view.collector.Main.init(Main.java:63)
at com.cisco.nm.acs.view.collector.Main.main(Main.java:130)
Exception in thread "main" org.h2.jdbc.JdbcSQLException: Sequence
SYSTEM_SEQUENCE_39CBE124_6F9A_44A9_981C_7E56D83420B2 not found; SQL
statement:
CREATE MEMORY TABLE PUBLIC.ACS_TACACS_ACTIVE_SESSION(
ID BIGINT DEFAULT (NEXT VALUE FOR
PUBLIC.SYSTEM_SEQUENCE_39CBE124_6F9A_44A9_981C_7E56D83420B2) NOT NULL
NULL_TO_DEFAULT SEQUENCE
PUBLIC.SYSTEM_SEQUENCE_39CBE124_6F9A_44A9_981C_7E56D83420B2,
ACSVIEW_TIMESTAMP TIMESTAMP NOT NULL,
LAST_UPDATED_TIMESTAMP TIMESTAMP,
ACS_SESSION_ID VARCHAR(100),
USER_NAME VARCHAR(255),
NAS_IP_ADDRESS VARCHAR(255),
TASK_ID VARCHAR(255),
PORT VARCHAR(255),
ACCT_TERMINATE_CAUSE VARCHAR(255),
ACCT_INPUT_PACKETS BIGINT,
ACCT_OUTPUT_PACKETS BIGINT
) [90036-114]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.getSQLException(Message.java:116)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.schema.Schema.getSequence(Schema.java:443)
at org.h2.command.Parser.readSequence(Parser.java:4265)
at org.h2.command.Parser.readTerm(Parser.java:2254)
at org.h2.command.Parser.readFactor(Parser.java:1844)
at org.h2.command.Parser.readSum(Parser.java:1831)
at org.h2.command.Parser.readConcat(Parser.java:1804)
at org.h2.command.Parser.readCondition(Parser.java:1672)
at org.h2.command.Parser.readAnd(Parser.java:1652)
at org.h2.command.Parser.readExpression(Parser.java:1644)
at org.h2.command.Parser.readTerm(Parser.java:2298)
at org.h2.command.Parser.readFactor(Parser.java:1844)
at org.h2.command.Parser.readSum(Parser.java:1831)
at org.h2.command.Parser.readConcat(Parser.java:1804)
at org.h2.command.Parser.readCondition(Parser.java:1672)
at org.h2.command.Parser.readAnd(Parser.java:1652)
at org.h2.command.Parser.readExpression(Parser.java:1644)
at org.h2.command.Parser.parseColumnForTable(Parser.java:3215)
at org.h2.command.Parser.parseCreateTable(Parser.java:4620)
at org.h2.command.Parser.parseCreate(Parser.java:3442)
at org.h2.command.Parser.parsePrepared(Parser.java:323)
at org.h2.command.Parser.parse(Parser.java:290)
at org.h2.command.Parser.parse(Parser.java:262)
at org.h2.command.Parser.prepare(Parser.java:204)
at org.h2.engine.Session.prepare(Session.java:394)
at org.h2.engine.Session.prepare(Session.java:381)
at org.h2.engine.MetaRecord.execute(MetaRecord.java:79)
at org.h2.engine.Database.open(Database.java:647)
at org.h2.engine.Database.openDatabase(Database.java:219)
at org.h2.engine.Database.<init>(Database.java:214)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.getEmbbededH2(DbConnection.java:69)
at
com.cisco.nm.acs.view.collector.syslog.DbConnection.init(DbConnection.java:88)
at com.cisco.nm.acs.view.collector.Main.init(Main.java:60)
at com.cisco.nm.acs.view.collector.Main.main(Main.java:120)
--
View this message in context:
http://h2-database.66688.n3.nabble.com/H2-DB-issues-tp3467263p3486114.html
Sent from the H2 Database mailing list archive at Nabble.com.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
