sql integrity constraint violation

0
I am getting the following error when I try to start my app in the Modeler. It had been running fine so must be something I changed but I can't figure out what.  Can anyone help me locate where/what the issue is?   Thanks, Tracy Opening JDBC connection to None failed with SQLState: S1000 Error code: -25 Message: error in script file line: 22067 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10785 table: "esat$taskline_request", giving up...(4/4)   com.mendix.m2ee.api.AdminException: An error occurred while initializing the Runtime     at com.mendix.core.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:403) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on initializing database connection.     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:40) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Error on initializing database connection.     at com.mendix.connectionbus.ConnectionBusInitializer.throwDefault$1(ConnectionBusInitializer.scala:61) Caused by: java.sql.SQLException: error in script file line: 22067 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10785 table: "esat$taskline_request"     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:44)     at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)     at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)     at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:55)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:52)     at java.security.AccessController.doPrivileged(Native Method)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:52)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:62)     at com.mendix.connectionbus.ConnectionBusInitializer.com$mendix$connectionbus$ConnectionBusInitializer$$createConnection(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply$mcV$sp(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.util.Runner$.runWithClassLoader(Runner.scala:12)     at com.mendix.connectionbus.util.Runner$.runWithOwnClassLoader(Runner.scala:4)     at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:44)     at com.mendix.connectionbus.ConnectionBusImpl.initializeConnection(ConnectionBusImpl.java:275)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:379)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:376)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:381)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:286)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:243)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:50)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:31)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745) Caused by: org.hsqldb.HsqlException: error in script file line: 22067 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10785 table: "esat$taskline_request"     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)     at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)     at org.hsqldb.persist.Log.processScript(Unknown Source)     at org.hsqldb.persist.Log.open(Unknown Source)     at org.hsqldb.persist.Logger.open(Unknown Source)     at org.hsqldb.Database.reopen(Unknown Source)     at org.hsqldb.Database.open(Unknown Source)     at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)     at org.hsqldb.DatabaseManager.newSession(Unknown Source)     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:44)     at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)     at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)     at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:55)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:52)     at java.security.AccessController.doPrivileged(Native Method)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:52)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:62)     at com.mendix.connectionbus.ConnectionBusInitializer.com$mendix$connectionbus$ConnectionBusInitializer$$createConnection(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply$mcV$sp(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.util.Runner$.runWithClassLoader(Runner.scala:12)     at com.mendix.connectionbus.util.Runner$.runWithOwnClassLoader(Runner.scala:4)     at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:44)     at com.mendix.connectionbus.ConnectionBusImpl.initializeConnection(ConnectionBusImpl.java:275)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:379)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:376)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:381)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:286)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:243)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:50)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:31)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745) Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10785 table: "esat$taskline_request"     at org.hsqldb.error.Error.error(Unknown Source)     at org.hsqldb.Constraint.getException(Unknown Source)     at org.hsqldb.index.IndexAVLMemory.insert(Unknown Source)     at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)     at org.hsqldb.Table.insertData(Unknown Source)     at org.hsqldb.Table.insertFromScript(Unknown Source)     at org.hsqldb.scriptio.ScriptReaderText.readExistingData(Unknown Source)     at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)     at org.hsqldb.persist.Log.processScript(Unknown Source)     at org.hsqldb.persist.Log.open(Unknown Source)     at org.hsqldb.persist.Logger.open(Unknown Source)     at org.hsqldb.Database.reopen(Unknown Source)     at org.hsqldb.Database.open(Unknown Source)     at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)     at org.hsqldb.DatabaseManager.newSession(Unknown Source)     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)     at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:44)     at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)     at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)     at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)     at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:55)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager$1.run(ConnectionManager.java:52)     at java.security.AccessController.doPrivileged(Native Method)     at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:52)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$com$mendix$connectionbus$ConnectionBusInitializer$$createConnection$1.apply(ConnectionBusInitializer.scala:55)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.connectionbus.ConnectionBusInitializer.retry(ConnectionBusInitializer.scala:62)     at com.mendix.connectionbus.ConnectionBusInitializer.com$mendix$connectionbus$ConnectionBusInitializer$$createConnection(ConnectionBusInitializer.scala:55)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply$mcV$sp(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.ConnectionBusInitializer$$anonfun$initialize$1.apply(ConnectionBusInitializer.scala:45)     at com.mendix.connectionbus.util.Runner$.runWithClassLoader(Runner.scala:12)     at com.mendix.connectionbus.util.Runner$.runWithOwnClassLoader(Runner.scala:4)     at com.mendix.connectionbus.ConnectionBusInitializer.initialize(ConnectionBusInitializer.scala:44)     at com.mendix.connectionbus.ConnectionBusImpl.initializeConnection(ConnectionBusImpl.java:275)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:379)     at com.mendix.core.impl.MxRuntimeImpl$2.execute(MxRuntimeImpl.java:376)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.impl.MxRuntimeImpl.initializeConnectionBus(MxRuntimeImpl.java:381)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:286)     at com.mendix.core.impl.MxRuntimeImpl.start(MxRuntimeImpl.java:243)     at com.mendix.m2ee.appcontainer.actions.StartAction.startRuntime(StartAction.java:50)     at com.mendix.m2ee.appcontainer.actions.StartAction.execute(StartAction.java:31)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745)  
asked
3 answers
0

I had this issue and it drove me nuts. Completely blew away the association and even the objects referred to in the error message. Nothing after hours. After beginning it turns out the problem was occuring on a change activity that had nothing to do with the association in the stack trace. 

 

Ultimately I was changing an object and setting the association TWICE in the same action

answered
-1

Hi Tracy,

It looks like this is happening in your local development HSQL database. I can't say how, but it looks like there's inconsistent data in the association called "taskline_request" in the "esat" module. Did you perhaps change this association from *-* to *-1 or 1-1 by chance?

One idea I have is to change this association to *-*, start the app, then change it back to whatever it should be. You might lose the data in this association (not 100% sure) but at least your other dev data will remain intact.

Another guaranteed solution is to wipe out your <project>/deployment directory and let Mendix rebuild it. That'll solve the error but you'll have to recreate any data you have in your development system.

answered
-1

Is the scenario that you use Java actions to commit large amounts of objects for performance reasons? In that scenario I had this before in some Mendix releases.

Mendix has fixed this issue in later Mx6 releases by adding some unique constraints on the id combinations columns of the association tables.

 

answered