java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Atlassian JIRA | Gustavo Refosco [Atlassian] | 1 year ago
  1. 0

    h3. Summary FishEye/Crucible sends notification email reporting that the smart commits cannot be performed with the following content: {noformat} FishEye could not execute the smart commit because of an unexpected error: Active Objects failed to initalize for bundle com.atlassian.fecru.plugin.commithook.fecru-webhooks-plugin Please manually perform the required action within Crucible. {noformat} This problem is caused by the web hook related tables not being available in the database. The tables in question are: * {{AO_8219D4_COMMIT_HOOK_CONFIG}} * {{AO_A0B856_WEB_HOOK_LISTENER_AO}} * {{AO_B434B9_WEB_HOOK}} These tables have not been created as part of the migration to an Oracle database. The following sequences are present - notice the latest two being related to these tables - which seems to be preventing the tables from being created: {noformat} SEQUENCE NUMBER INFO -------------------------------------------------------------------------------- Owner: CRUCIBLE Sequence Name: AO_2913F5_COMMENT_ISSUE_ID_SEQ Calculated Last Number: 21 Increment by: 1 Min Value: 1 Max Value: 9999999999999999999999999999 Cycle Flag: NO CYCLE Cache Size: CACHE 20 Order Flag: NO ORDER Owner: CRUCIBLE Sequence Name: AO_38321B_CUSTOM_CO518521787 Calculated Last Number: 21 Increment by: 1 Min Value: 1 Max Value: 9999999999999999999999999999 Cycle Flag: NO CYCLE Cache Size: CACHE 20 Order Flag: NO ORDER Owner: CRUCIBLE Sequence Name: AO_A0B856_WEB_HOOK_625253910 Calculated Last Number: 21 Increment by: 1 Min Value: 1 Max Value: 9999999999999999999999999999 Cycle Flag: NO CYCLE Cache Size: CACHE 20 Order Flag: NO ORDER Owner: CRUCIBLE Sequence Name: AO_B434B9_WEB_HOOK_ID_SEQ Calculated Last Number: 21 Increment by: 1 Min Value: 1 Max Value: 9999999999999999999999999999 Cycle Flag: NO CYCLE Cache Size: CACHE 20 Order Flag: NO ORDER {noformat} h3. Environment * Oracle database. h3. Steps to Reproduce # The problem has not been reproduced yet. The causes mentioned in the summay may be leading to this condition. h3. Expected Results The smart commit feature works as expected, and no error message is reported in the log files. h3. Actual Results The below exception is thrown in the {{atlassian-fisheye-YYYY-MM-DD.log}} file: {noformat} ERROR [CommitNotifier1 ] com.atlassian.fecru.plugin.commithook.internal.DefaultCommitHookManager DefaultCommitHookManager-handleCommit - Error processing commit hook Web Hooks Processor com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.fecru.plugin.commithook.fecru-webhooks-plugin at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$5.apply(ActiveObjectsServiceFactory.java:207) ... Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle ... java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52) Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object {noformat} h3. Notes The smart commit feature does not need to be enabled for this problem to occur. h3. Workaround (!) Always back up your database before performing any modification to the database. If possible, try your modifications on a test server. # Stop FishEye/Crucible # Drop the {{AO_A0B856_WEB_HOOK_625253910}} and {{AO_B434B9_WEB_HOOK_ID_SEQ}} sequences # Start FishEye/Crucible

    Atlassian JIRA | 1 year ago | Gustavo Refosco [Atlassian]
    java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
  2. 0

    Unable to use changelogSchemaName/changelogCatalogName configuration parameters on Oracle DB. h3. Steps to reproduce: Testplan 1. # Configure Liquibase against Oracle DB instance, user A; # Set changelogSchemaName to B; # Launch update procedure; # Note that DATABASECHAGELOG* tables are created in A schema. Testplan 2. # Configure Liquibase against Oracle DB instance, user A; # Set changelogCatalogName to B; # Launch update procedure; # Note that DATABASECHAGELOG* tables are created in A schema. Testplan 3. # Perform steps outlined in Testplan 2. # Launch Liquibase again with the same configuration. # Notice an exception similar to this: {code} Error setting up or running Liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE <changelogCatalogName>.DATABASECHANGELOGLOCK (ID NUMBER(10) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)): ORA-00955: name is already used by an existing object at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:216) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:108) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:76) at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:116) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:361) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:155) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:584) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:213) at org.apache.maven.cli.MavenCli.main(MavenCli.java:157) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) Caused by: org.apache.maven.plugin.MojoExecutionException: Error setting up or running Liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE <changelogCatalogName>.DATABASECHANGELOGLOCK (ID NUMBER(10) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)): ORA-00955: name is already used by an existing object at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:371) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:133) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208) ... 19 more Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE <changelogCatalogName>.DATABASECHANGELOGLOCK (ID NUMBER(10) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)): ORA-00955: name is already used by an existing object at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:214) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:153) at liquibase.Liquibase.update(Liquibase.java:182) at liquibase.Liquibase.update(Liquibase.java:174) at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:31) at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:24) at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:367) ... 21 more Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE <changelogCatalogName>.DATABASECHANGELOGLOCK (ID NUMBER(10) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)): ORA-00955: name is already used by an existing object at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:88) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:187) ... 27 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1792) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:310) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 31 more {code} h2. Code analysis showed that: h3. Oracle does not support schemas "in Liquibase's opinion". I.e. {{liquibase.database.core.OracleDatabase.supportsSchemas()}} always return {{false}}, hence {{liquibase.database.AbstractJdbcDatabase.getDefaultSchemaName()}} always return default catalog (usually <jdbc_connection_username>). h3. Code, which creates DATABASECHANGELOG/DATABASECHANGELOGLOCK tables also affected. {{liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator.generateSql(CreateDatabaseChangeLogLockTableStatement, Database, SqlGeneratorChain)}} will create an SQL statement containing catalog only, whereas schema (set to <changelogSchemaName>) ignored by {{liquibase.database.AbstractJdbcDatabase.escapeObjectName(String, String, String, Class<? extends DatabaseObject>)}}. The same issue with {{liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGenerator.generateSql(CreateDatabaseChangeLogTableStatement, Database, SqlGeneratorChain)}}. h3. Note on DB metadata check when <changelogCatalogName> is set. In {{liquibase.snapshot.SnapshotGeneratorFactory.hasDatabaseChangeLogLockTable(Database)}} DATABASECHANGELOGLOCK table object recieves catalog = <changelogCatalogName>, schemaName = <jdbc_connection_username> (see note about {{AbstractJdbcDatabase.getDefaultSchemaName()}} above) upon creation. DB metadata loading code - {{liquibase.snapshot.JdbcDatabaseSnapshot.CachingDatabaseMetaData.getTables(String, String, String, String[])}} - called prior to the existance check, recieves catalogName = null, schemaName = <changelogCatalogName>, but eventually calls {{CatalogAndSchema catalogAndSchema = new CatalogAndSchema(catalogName, schemaName).customize(database);}}(JdbcDatabaseSnapshot.java:356, fastFetchQuery() method). customize(Database) method, in turn, calls {{liquibase.CatalogAndSchema.standardize(Database)}}, which nullifyes schema name: {code:title=CatalogAndSchema.java|borderStyle=solid} if (accordingTo.supportsSchemas()) { if (schemaName != null && schemaName.equalsIgnoreCase(accordingTo.getDefaultSchemaName())) { schemaName = null; } } else { schemaName = null; } {code} This effectively eliminates configured <changelogCatalogName> value and resets it to default schema (usually <jdbc_connection_username>). {{queryOracle(CatalogAndSchema, String)}} that called furhter creates a query of the form: {code:SQL} SELECT null as TABLE_CAT, a.OWNER as TABLE_SCHEM, a.TABLE_NAME as TABLE_NAME, 'TABLE' as TABLE_TYPE, c.COMMENTS as REMARKS from ALL_TABLES a join ALL_TAB_COMMENTS c on a.TABLE_NAME=c.table_name and a.owner=c.owner WHERE a.OWNER='<jdbc_connection_username>' AND a.TABLE_NAME not in (select mv.name from all_registered_mviews mv where mv.owner='<jdbc_connection_username>') {code} which will return information about tables from <jdbc_connection_username> schema only; table snapshot will retain this info and, hence, the DATABASECHANGELOGLOCK table object passed to {{liquibase.snapshot.SnapshotGeneratorFactory.has(DatabaseObject, Database)}} by {{liquibase.snapshot.SnapshotGeneratorFactory.hasDatabaseChangeLogLockTable(Database)}} will not be matched because schema names differ. Liquibase will decide that this table does not exist (even if it is not the case, and it existis within the default schema) and attempt to recreate a lock table.

    JIRA | 2 years ago | Alexander Kiselyov
    liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE <changelogCatalogName>.DATABASECHANGELOGLOCK (ID NUMBER(10) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)): ORA-00955: name is already used by an existing object
  3. 0

    SymmetricDS Issues

    symmetricds.org | 4 months ago
    java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Setup an XWiki server that uses PostgreSQL as the DB, then start the server and connect to it. You'll see a message similar to this one: {code} 2014-05-26 15:23:01,630 [XWiki initialization] INFO .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 2014-05-26 15:23:02,696 [XWiki initialization] ERROR .HibernateDataMigrationManager - The empty database xwiki seems to be not writable, please check your configuration! com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:181) ~[xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:141) ~[xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:434) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:534) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:517) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:722) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:898) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:830) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:829) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1357) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1405) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2081) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2113) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.loadPreferences(XWikiMacrosMappingRenderer.java:107) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.<init>(XWikiMacrosMappingRenderer.java:83) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.<init>(DefaultXWikiRenderingEngine.java:72) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.resetRenderingEngine(XWiki.java:1004) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:760) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:661) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:129) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:155) [xwiki-commons-job-6.1-milestone-1.jar:na] at org.xwiki.context.concurrent.ExecutionContextRunnable.run(ExecutionContextRunnable.java:70) [xwiki-commons-context-6.1-milestone-1.jar:na] at java.lang.Thread.run(Unknown Source) [na:1.8.0_05] Caused by: org.hibernate.HibernateException: Failed updating schema while executing query [create sequence public.hibernate_sequence] at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:613) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:371) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:196) ~[xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:178) ~[xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] ... 23 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" already exists at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:331) ~[postgresql-9.3-1101.jdbc41.jar:na] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.3.jar:1.3] at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:609) [xwiki-platform-legacy-oldcore-6.1-milestone-1.jar:na] ... 26 common frames omitted 2014-05-26 15:23:02,703 [XWiki initialization] INFO .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 2014-05-26 15:23:03,602 [XWiki initialization] INFO .HibernateDataMigrationManager - Storage schema updates and data migrations are enabled 2014-05-26 15:23:03,603 [XWiki initialization] INFO .HibernateDataMigrationManager - No data migration to apply for wiki [xwiki] currently in version [54300] 2014-05-26 15:23:03,603 [XWiki initialization] INFO .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 2014-05-26 15:23:07,809 [XWiki Solr index job thread] INFO o.x.s.s.i.j.IndexerJob - Starting job of type [solr.indexer] with identifier [[solr, indexer]] 2014-05-26 15:23:07,954 [XWiki Solr index job thread] INFO o.x.s.s.i.j.IndexerJob - 0 documents added, 28 deleted and 0 updated during the synchronization of the Solr index. 2014-05-26 15:23:07,955 [XWiki Solr index job thread] INFO o.x.s.s.i.j.IndexerJob - Finished job of type [solr.indexer] with identifier [[solr, indexer]] {code} The message says "The empty database xwiki seems to be not writable, please check your configuration!", but I am able to install the UI using DW. Doesn't reproduce on 3.5.1 & 4.5.4.

    XWiki.org JIRA | 3 years ago | Manuel Smeria
    com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
  6. 0

    *Steps to reproduce:* # Create an instance running against Oracle (see https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle) # Create a backup of this instance: {code}exp username/password file=file_name.dmp{code} (note: On versions of Oracle 11gR2 and newer, you will need to work through [this KB|https://confluence.atlassian.com/display/KB/Exporting+a+database+does+not+export+some+tables] to make sure that _all_ the tables are exported) # Create a new Oracle database # Import your backup into this database: {code}imp dba_username/dba_password file=file_name.dmp fromuser=old_database touser=new_database{code} # Create a clone of your existing Confluence instance and point it at this new database You'll see the following in your logs: {code}2015-05-19 11:42:07,070 ERROR [localhost-startStop-1] [atlassian.plugin.loaders.ScanningPluginLoader] deployPluginFromUnit Because of the following exception: java.lang.IllegalArgumentException: The artifact URI file:/Users/ldally/instances/confluences/5.5.3oracletest/webapps/../confluence/WEB-INF/atlassian-bundled-plugins/activeobjects-plugin-0.25.2/ is not a valid plugin artifact at com.atlassian.plugin.DefaultPluginArtifactFactory.create(DefaultPluginArtifactFactory.java:70) at com.atlassian.plugin.loaders.ScanningPluginLoader.deployPluginFromUnit(ScanningPluginLoader.java:151) at com.atlassian.plugin.loaders.ScanningPluginLoader.loadAllPlugins(ScanningPluginLoader.java:89) at com.atlassian.plugin.loaders.PermissionCheckingPluginLoader.loadAllPlugins(PermissionCheckingPluginLoader.java:24) at com.atlassian.plugin.manager.DefaultPluginManager.init(DefaultPluginManager.java:250) at com.atlassian.confluence.plugin.ConfluencePluginManager.init(ConfluencePluginManager.java:123) at com.atlassian.confluence.plugin.PluginFrameworkContextListener.contextInitialized(PluginFrameworkContextListener.java:54) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) 2015-05-19 11:42:13,465 WARN [ThreadPoolAsyncTaskExecutor::Thread 7] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,424 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,426 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,427 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,427 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,428 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,429 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:14,431 WARN [ThreadPoolAsyncTaskExecutor::Thread 9] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory! 2015-05-19 11:42:23,375 WARN [localhost-startStop-1] [atlassian.soy.renderer.SoyResourceModuleDescriptor] enabled soy-resource is deprecated. Please convert com.atlassian.confluence.plugins.soy:soy-core-functions to a web-resource and/or a soy-function 2015-05-19 11:42:25,309 ERROR [active-objects-ddl-0] [net.java.ao.sql] handleUpdateError Exception executing SQL update <CREATE TABLE "AO_DC98AE_AOHELP_TIP" ( "DISMISSED_HELP_TIP" VARCHAR(255), "ID" NUMBER(11) NOT NULL, "USER_KEY" VARCHAR(255), PRIMARY KEY("ID") )> java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2309) at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2379) at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2342) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99) at net.java.ao.EntityManager.migrate(EntityManager.java:128) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:48) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:65) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:59) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25) at com.atlassian.sal.spring.component.SpringHostContextAccessor$1.doInTransaction(SpringHostContextAccessor.java:88) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:82) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy217.doInTransaction(Unknown Source) at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) at com.sun.proxy.$Proxy217.doInTransaction(Unknown Source) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21) at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy941.execute(Unknown Source) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:58) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:40) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.createActiveObjects(ActiveObjectsServiceFactory.java:160) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.access$1100(ActiveObjectsServiceFactory.java:51) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:224) at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$6.call(ActiveObjectsServiceFactory.java:216) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745){code} Note this call: {{com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.createActiveObjects(ActiveObjectsServiceFactory.java:160)}}. It appears that Active Objects plugin is trying to create the Active Objects tables even though they already exist.

    Atlassian JIRA | 2 years ago | Lachlan Dally
    java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00955: name is already used by an existing object

      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate()
    2. com.atlassian.activeobjects
      EntityManagedActiveObjects.migrate
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52)
      1 frame