java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; liquibase.exception.DatabaseException: Duplicate entry 'ccc-Drugs-CLASS-Human' for key 'PRIMARY' [Failed SQL: INSERT INTO `opal_tabular`.`categories` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]; nested exception is java.sql.SQLException: liquibase.exception.DatabaseException: Duplicate entry 'ccc-Drugs-CLASS-Human' for key 'PRIMARY' [Failed SQL: INSERT INTO `opal_tabular`.`categories` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,

Check whether privilege has the "not null" restriction. If so it always has to have a value and can never be null.

A different reason could be a wrong implementation of a foreign key. Check whether you always correctly insert/update in both tables.

Solutions on the web

via JIRA by Yannick Marcon, 1 year ago
SQL: INSERT INTO `opal_tabular`.`categories` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]; nested exception is java.sql.SQLException: liquibase.exception.DatabaseException: Duplicate
via JIRA by Carlos Silva, 1 year ago
org.apache.shiro.session.UnknownSessionException: There is no session with id [89d982c3-37f4-4356-84ad-d55cc5483215]
via JIRA by Carlos Silva, 1 year ago
org.apache.shiro.session.UnknownSessionException: There is no session with id [89d982c3-37f4-4356-84ad-d55cc5483215]
via JIRA by Carlos Silva, 1 year ago
org.apache.shiro.session.UnknownSessionException: There is no session with id [89d982c3-37f4-4356-84ad-d55cc5483215]
via JIRA by Carlos Silva, 1 year ago
org.apache.shiro.session.UnknownSessionException: There is no session with id [89d982c3-37f4-4356-84ad-d55cc5483215]
java.lang.RuntimeException: org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; liquibase.exception.DatabaseException: Duplicate entry 'ccc-Drugs-CLASS-Human' for key 'PRIMARY' [Failed SQL: INSERT INTO `opal_tabular`.`categories` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]; nested exception is java.sql.SQLException: liquibase.exception.DatabaseException: Duplicate entry 'ccc-Drugs-CLASS-Human' for key 'PRIMARY' [Failed SQL: INSERT INTO `opal_tabular`.`categories` (`datasource`, `value_table`, `variable`, `name`, `missing`) VALUES ('ccc', 'Drugs', 'CLASS', 'Human', 0)]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
at org.obiba.magma.datasource.jdbc.JdbcDatasource$ChangeDatabaseCallback.doInDatabase(JdbcDatasource.java:641)
at org.obiba.magma.datasource.jdbc.JdbcDatasource$6.doInConnection(JdbcDatasource.java:489)
at org.obiba.magma.datasource.jdbc.JdbcDatasource.doWithDatabase(JdbcDatasource.java:480)
at org.obiba.magma.datasource.jdbc.JdbcValueTableWriter$JdbcVariableWriter.close(JdbcValueTableWriter.java:265)
at org.obiba.magma.support.DatasourceCopier.copyMetadata(DatasourceCopier.java:266)
at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:227)
at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:217)
at org.obiba.magma.support.DatasourceCopier.copy(DatasourceCopier.java:200)
at org.obiba.opal.core.service.CopyValueTablesLockingAction$CopyAction.execute(CopyValueTablesLockingAction.java:150)
at org.obiba.opal.core.magma.concurrent.LockingActionTemplate$1.doInTransactionWithoutResult(LockingActionTemplate.java:47)
at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)
at org.obiba.opal.core.magma.concurrent.LockingActionTemplate.doInTransaction(LockingActionTemplate.java:42)
at org.obiba.opal.core.magma.concurrent.LockingActionTemplate.execute(LockingActionTemplate.java:31)
at org.obiba.opal.core.service.DataImportServiceImpl.copyValueTables(DataImportServiceImpl.java:134)
at org.obiba.opal.core.service.DataImportServiceImpl.importData(DataImportServiceImpl.java:105)
at org.obiba.opal.core.service.DataImportServiceImpl.importData(DataImportServiceImpl.java:87)
at org.obiba.opal.shell.commands.ImportCommand.importFromTables(ImportCommand.java:155)
at org.obiba.opal.shell.commands.ImportCommand.executeImports(ImportCommand.java:89)
at org.obiba.opal.shell.commands.ImportCommand.execute(ImportCommand.java:68)
at org.obiba.opal.shell.CommandJob.run(CommandJob.java:153)
at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Once, 4 months ago
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 times, 1 year ago
12 times, 11 months ago
70 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.