java.sql.SQLException

Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web7935

  • via Atlassian JIRA by Dave Loeng [Atlassian], 1 year ago
    Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"
  • via Atlassian JIRA by Dave Loeng [Atlassian], 11 months ago
    Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'"
  • via Atlassian JIRA by Ross Mason, 11 months ago
    Invalid argument value, message from server: "Duplicate entry '0' for key 1"
  • Stack trace

    • java.sql.SQLException: Invalid argument value message from server: "Duplicate key name 'c_contenttype_idx'" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224) at com.mysql.jdbc.Connection.execSQL(Connection.java:2248) at com.mysql.jdbc.Connection.execSQL(Connection.java:2196) at com.mysql.jdbc.Statement.execute(Statement.java:906) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:896) at com.atlassian.confluence.setup.DefaultHibernateConfigurator.createAdditionalDatabaseIndexes(DefaultHibernateConfigurator.java:180) at com.atlassian.confluence.setup.DefaultHibernateConfigurator.createConfluenceSchema(DefaultHibernateConfigurator.java:143) at com.atlassian.confluence.importexport.impl.BackupImporter.deleteAllDatabaseContent(BackupImporter.java:434) at com.atlassian.confluence.importexport.impl.BackupImporter.importEntities(BackupImporter.java:226) at com.atlassian.confluence.importexport.impl.BackupImporter.importEverything(BackupImporter.java:155) at com.atlassian.confluence.importexport.impl.FileBackupImporter.importEverything(FileBackupImporter.java:84) at com.atlassian.confluence.importexport.impl.BackupImporter.doImport(BackupImporter.java:76) at com.atlassian.confluence.importexport.impl.FileBackupImporter.doImport(FileBackupImporter.java:34) at com.atlassian.confluence.importexport.DefaultImportExportManager.importAs(DefaultImportExportManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:116) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:152) at $Proxy43.importAs(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.run(ImportLongRunningTask.java:45) at java.lang.Thread.run(Thread.java:534)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 2 years ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    5 more bugmates