java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]

Atlassian JIRA | Dariusz Kordonski | 5 years ago
  1. 0

    {noformat} 2011-09-05 12:22:23,443 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractStatementUpgradeTask] Unable to run ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID : Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) at com.atlassian.bamboo.upgrade.tasks.AbstractStatementUpgradeTask.doUpgrade(AbstractStatementUpgradeTask.java:42) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask$1.doInHibernateTransaction(AbstractInHibernateTransactionUpgradeTask.java:40) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1$1.doInHibernate(BambooConnectionTemplate.java:51) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1.doInTransactionWithoutResult(BambooConnectionTemplate.java:44) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooConnectionTemplate.execute(BambooConnectionTemplate.java:39) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask.doUpgrade(AbstractInHibernateTransactionUpgradeTask.java:36) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:619) {noformat}

    Atlassian JIRA | 5 years ago | Dariusz Kordonski [Atlassian]
    java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]
  2. 0

    {noformat} 2011-09-05 12:22:23,443 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractStatementUpgradeTask] Unable to run ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID : Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) at com.atlassian.bamboo.upgrade.tasks.AbstractStatementUpgradeTask.doUpgrade(AbstractStatementUpgradeTask.java:42) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask$1.doInHibernateTransaction(AbstractInHibernateTransactionUpgradeTask.java:40) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1$1.doInHibernate(BambooConnectionTemplate.java:51) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1.doInTransactionWithoutResult(BambooConnectionTemplate.java:44) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooConnectionTemplate.execute(BambooConnectionTemplate.java:39) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask.doUpgrade(AbstractInHibernateTransactionUpgradeTask.java:36) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:619) {noformat}

    Atlassian JIRA | 5 years ago | Dariusz Kordonski
    java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]
  3. 0

    HSQLDB and Liquibase, Table already exists: DATABASECHANGELOGLOCK

    Stack Overflow | 2 years ago | Gleeb
    java.sql.SQLException: Table already exists: DATABASECHANGELOGLOCK in statement [CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC config ignored

    Google Groups | 6 years ago | Matthew Smith
    java.sql.SQLException: Three part identifiers prohibited in statement [select * from portdb.dbo.]
  6. 0

    Deleting instances of old version of a class

    romaframework | 7 years ago | nobody
    java.sql.SQLException: Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\]

    3 unregistered visitors
    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.SQLException

      Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      3 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyStatement.execute
      1. com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
      1 frame
    4. com.atlassian.bamboo
      BambooConnectionTemplate$1$1.doInHibernate
      1. com.atlassian.bamboo.upgrade.tasks.AbstractStatementUpgradeTask.doUpgrade(AbstractStatementUpgradeTask.java:42)
      2. com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask$1.doInHibernateTransaction(AbstractInHibernateTransactionUpgradeTask.java:40)
      3. com.atlassian.bamboo.persistence.BambooConnectionTemplate$1$1.doInHibernate(BambooConnectionTemplate.java:51)
      3 frames
    5. Hibernate
      HibernateTemplate.execute
      1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
      1 frame
    6. com.atlassian.bamboo
      BambooConnectionTemplate$1.doInTransactionWithoutResult
      1. com.atlassian.bamboo.persistence.BambooConnectionTemplate$1.doInTransactionWithoutResult(BambooConnectionTemplate.java:44)
      1 frame
    7. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
      2. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
      2 frames
    8. com.atlassian.bamboo
      UpgradeLauncher$1.call
      1. com.atlassian.bamboo.persistence.BambooConnectionTemplate.execute(BambooConnectionTemplate.java:39)
      2. com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask.doUpgrade(AbstractInHibernateTransactionUpgradeTask.java:36)
      3. com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175)
      4. com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92)
      5. com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115)
      6. com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112)
      6 frames
    9. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      4. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      5. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      6. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      7. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      7 frames
    10. com.atlassian.bamboo
      NamedThreadFactory$2.run
      1. com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame