com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql

Atlassian JIRA | Gurleen Anand [Atlassian] | 5 years ago
  1. 0

    Migration from HSQLDB to Postgres may fail with the following exception: {noformat} 2011-10-20 13:56:29,581 ERROR [ThreadPool1 ] fisheye.app com.atlassian.crucible.actions.admin.database.DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:292) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:138) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id integer not null, cru_item_type varchar(80) not null, cru_string_key1 varchar(255), cru_string_key2 varchar(255), cru_string_key3 varchar(255), cru_string_key4 varchar(255), cru_string_key5 varchar(255), cru_int_key1 integer, cru_int_key2 integer, cru_int_key3 integer, cru_int_key4 integer, cru_int_key5 integer, cru_text_key1 longvarchar, cru_text_key2 longvarchar, cru_user_name varchar(255), cru_date_created bigint, cru_label varchar(255), primary key (cru_star_id));" (ERROR: type "longvarchar" does not exist Position: 375), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:483) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:414) at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:286) ... 10 more Caused by: org.postgresql.util.PSQLException: ERROR: type "longvarchar" does not exist Position: 375 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:455) ... 12 more {noformat} on some browsers as the "Database Type" field is blanked out in the UI, when updating the JDBC connection URL. The problem has been reported on IE9 and Chrome. But Chrome 14 appears to work correctly for a customer. Unsure about which version of Chrome is failing. FireFox appears to be working as expected. Postgres versions reported on 8.2.20 and 8.4

    Atlassian JIRA | 5 years ago | Gurleen Anand [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql
  2. 0

    Migration from HSQLDB to Postgres may fail with the following exception: {noformat} 2011-10-20 13:56:29,581 ERROR [ThreadPool1 ] fisheye.app com.atlassian.crucible.actions.admin.database.DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:292) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:138) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id integer not null, cru_item_type varchar(80) not null, cru_string_key1 varchar(255), cru_string_key2 varchar(255), cru_string_key3 varchar(255), cru_string_key4 varchar(255), cru_string_key5 varchar(255), cru_int_key1 integer, cru_int_key2 integer, cru_int_key3 integer, cru_int_key4 integer, cru_int_key5 integer, cru_text_key1 longvarchar, cru_text_key2 longvarchar, cru_user_name varchar(255), cru_date_created bigint, cru_label varchar(255), primary key (cru_star_id));" (ERROR: type "longvarchar" does not exist Position: 375), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:483) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:414) at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:286) ... 10 more Caused by: org.postgresql.util.PSQLException: ERROR: type "longvarchar" does not exist Position: 375 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:455) ... 12 more {noformat} on some browsers as the "Database Type" field is blanked out in the UI, when updating the JDBC connection URL. The problem has been reported on IE9 and Chrome. But Chrome 14 appears to work correctly for a customer. Unsure about which version of Chrome is failing. FireFox appears to be working as expected. Postgres versions reported on 8.2.20 and 8.4

    Atlassian JIRA | 5 years ago | Gurleen Anand [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script D:\Atlassian\Fisheye\sql\HSQL\schema\tables_75.sql
  3. 0

    It seems that the when migrating from HSQL to PSQL Crucible is trying to use the HSQL table scripts instead of psql. To reproduce: * go to {{localhost:6060/foo/admin/database.do}} * edit the database config * select a new db * test connection then migrate Problem seems to be related to the {{DatabaseConfig.java}} changes to set the {{dbType}} - doesn't seem to get set by the webwork action in {{dbConfig}} from {{MigrateDatabaseAction}} !https://img.skitch.com/20110203-pmapb4miqumxx6xuytkh6833q9.jpg! {noformat} [java] 14:37:59 ERROR - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql [java] com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql [java] at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:289) [java] at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:128) [java] at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:80) [java] at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:62) [java] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [java] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [java] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) [java] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [java] at java.lang.Thread.run(Thread.java:680) [java] Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id integer not null, cru_item_type varchar(80) not null, cru_string_key1 varchar(255), cru_string_key2 varchar(255), cru_string_key3 varchar(255), cru_string_key4 varchar(255), cru_string_key5 varchar(255), cru_int_key1 integer, cru_int_key2 integer, cru_int_key3 integer, cru_int_key4 integer, cru_int_key5 integer, cru_text_key1 longvarchar, cru_text_key2 longvarchar, cru_user_name varchar(255), cru_date_created bigint, cru_label varchar(255), primary key (cru_star_id));" [java] (ERROR: type "longvarchar" does not exist [java] Position: 375), please contact http://www.atlassian.com/support/ [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:468) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:411) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:283) [java] ... 10 more [java] Caused by: org.postgresql.util.PSQLException: ERROR: type "longvarchar" does not exist [java] Position: 375 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441) [java] ... 12 more {noformat}

    Atlassian JIRA | 6 years ago | Seb Ruiz
    com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    It seems that the when migrating from HSQL to PSQL Crucible is trying to use the HSQL table scripts instead of psql. To reproduce: * go to {{localhost:6060/foo/admin/database.do}} * edit the database config * select a new db * test connection then migrate Problem seems to be related to the {{DatabaseConfig.java}} changes to set the {{dbType}} - doesn't seem to get set by the webwork action in {{dbConfig}} from {{MigrateDatabaseAction}} !https://img.skitch.com/20110203-pmapb4miqumxx6xuytkh6833q9.jpg! {noformat} [java] 14:37:59 ERROR - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql [java] com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql [java] at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:289) [java] at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:128) [java] at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:80) [java] at com.cenqua.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:62) [java] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [java] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [java] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) [java] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [java] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [java] at java.lang.Thread.run(Thread.java:680) [java] Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cru_base_star_model (cru_star_id integer not null, cru_item_type varchar(80) not null, cru_string_key1 varchar(255), cru_string_key2 varchar(255), cru_string_key3 varchar(255), cru_string_key4 varchar(255), cru_string_key5 varchar(255), cru_int_key1 integer, cru_int_key2 integer, cru_int_key3 integer, cru_int_key4 integer, cru_int_key5 integer, cru_text_key1 longvarchar, cru_text_key2 longvarchar, cru_user_name varchar(255), cru_date_created bigint, cru_label varchar(255), primary key (cru_star_id));" [java] (ERROR: type "longvarchar" does not exist [java] Position: 375), please contact http://www.atlassian.com/support/ [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:468) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:411) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:283) [java] ... 10 more [java] Caused by: org.postgresql.util.PSQLException: ERROR: type "longvarchar" does not exist [java] Position: 375 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299) [java] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:441) [java] ... 12 more {noformat}

    Atlassian JIRA | 6 years ago | Seb Ruiz
    com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /Users/seb/dev/crucible/fe/output/dist/sql/HSQL/schema/tables_71.sql
  6. 0

    Stop Hibernate from trying to re-create indexes on every startup

    Stack Overflow | 2 years ago | Evgeny Chesnokov
    org.postgresql.util.PSQLException: ERROR: relation "statusindex" already exists

  1. silex 2 times, last 3 weeks ago
  2. silex 18 times, last 6 months ago
20 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. org.postgresql.util.PSQLException

    ERROR: type "longvarchar" does not exist Position: 375

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
    6 frames
  3. com.cenqua.crucible
    DefaultDBControl.createTables
    1. com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:455)
    2. com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:414)
    3. com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:286)
    3 frames
  4. com.atlassian.crucible
    DBEditHelper$ImportRunner.call
    1. com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:138)
    2. com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91)
    3. com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73)
    3 frames
  5. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
    3. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
    5. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    6. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    7. java.lang.Thread.run(Thread.java:662)
    7 frames