org.jumpmind.db.sql.SqlException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Exception during upgrade in build #7888
    via by Unknown author,
  • SymmetricDS Issues
    via by Unknown author,
  • Looks like CORE-911 has re-emerged... the first time running LB against an empty sybase database, things are ok. However, the next time running, it'll throw an error: Liquibase update Failed: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DATABASECHANGELOGLOCK] ([ID] INT NOT NULL, [LOCKED] BIT NOT NULL, [LOCKGRANTED] datetime NULL, [LOCKEDBY] VARCHAR(255) NULL, CONSTRAINT [PK_DATABASECHANGELOGLOCK] PRIMARY KEY ([ID])): There is already an object named 'DATABASECHANGELOGLOCK' in the database. SEVERE 5/14/14 9:10 AM:liquibase: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DATABASECHANGELOGLOCK] ([ID] INT NOT NULL, [LOCKED] BIT NOT NULL, [LOCKGRANTED] datetime NULL, [LOCKEDBY] VARCHAR(255) NULL, CONSTRAINT [PK_DATABASECHANGELOGLOCK] PRIMARY KEY ([ID])): There is already an object named 'DATABASECHANGELOGLOCK' in the database. liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DATABASECHANGELOGLOCK] ([ID] INT NOT NULL, [LOCKED] BIT NOT NULL, [LOCKGRANTED] datetime NULL, [LOCKEDBY] VARCHAR(255) NULL, CONSTRAINT [PK_DATABASECHANGELOGLOCK] PRIMARY KEY ([ID])): There is already an object named 'DATABASECHANGELOGLOCK' in the database. at liquibase.lockservice.LockServiceImpl.acquireLock(LockServiceImpl.java:141) at liquibase.lockservice.LockServiceImpl.waitForLock(LockServiceImpl.java:80) at liquibase.Liquibase.update(Liquibase.java:125) at liquibase.integration.commandline.Main.doMigration(Main.java:864) at liquibase.integration.commandline.Main.main(Main.java:133) Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE [DATABASECHANGELOGLOCK] ([ID] INT NOT NULL, [LOCKED] BIT NOT NULL, [LOCKGRANTED] datetime NULL, [LOCKEDBY] VARCHAR(255) NULL, CONSTRAINT [PK_DATABASECHANGELOGLOCK] PRIMARY KEY ([ID])): There is already an object named 'DATABASECHANGELOGLOCK' in the database. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:97) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:87) at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogLockTable(AbstractJdbcDatabase.java:890) at liquibase.lockservice.LockServiceImpl.acquireLock(LockServiceImpl.java:114) ... 4 more Caused by: java.sql.SQLException: There is already an object named 'DATABASECHANGELOGLOCK' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:810) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1290) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:285) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:50) ... 8 more
    via by Kelly Firkins,
    • org.jumpmind.db.sql.SqlException: The object 'V@LID49V6_2016.FUNGSINIT' does not exist or is invalid for this operation. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:338) at org.jumpmind.db.sql.JdbcSqlTransaction.execute(JdbcSqlTransaction.java:262) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.java:339) at org.jumpmind.symmetric.service.impl.TriggerRouterService.rebuildTriggerIfNecessary(TriggerRouterService.java:1719) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1593) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:1475) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTrigger(TriggerRouterService.java:1516) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTrigger(TriggerRouterService.java:1489) at org.jumpmind.symmetric.route.ConfigurationChangedDataRouter.contextCommitted(ConfigurationChangedDataRouter.java:497) at org.jumpmind.symmetric.service.impl.RouterService.completeBatchesAndCommit(RouterService.java:578) at org.jumpmind.symmetric.service.impl.RouterService.routeDataForChannel(RouterService.java:515) at org.jumpmind.symmetric.service.impl.RouterService.routeDataForEachChannel(RouterService.java:336) at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:184) at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:40) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: The object 'V@LID49V6_2016.FUNGSINIT' does not exist or is invalid for this operation. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2894) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2334) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:643) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:810) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1290) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:269) at org.jumpmind.db.sql.JdbcSqlTransaction$3.execute(JdbcSqlTransaction.java:262) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:336) ... 23 more

    Users with the same issue

    Eric
    3 times, last one,
    abrazeneb
    8 times, last one,
    Unknown visitor1 times, last one,
    odd
    72 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates