org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in

Sakai JIRA | Pascal-Nicolas Becker | 2 years ago
  1. 0

    I tried to install DSpace with another schema than the default "public" schema. Nevertheless all necessary tables, sequences and the function getnextid where created in public schema. The ant build (I called fresh_install) fails with the following Exception: ================= load_registries: [java] 2014-07-21 16:40:07,480 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2014-07-21 16:40:07,493 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration. If unintended, check your dspace.cfg for (log.init.config) [java] 2014-07-21 16:40:07,908 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [java] Position: 39 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1725) [java] at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:655) [java] at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:446) [java] at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403) [java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138) [java] at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75) [java] Error: [java] - ERROR: syntax error at or near ")" [java] Position: 39 BUILD FAILED /home/pbecker/git/tuub/dspace/target/dspace-installer/build.xml:858: Java returned: 1 ================= If I remove the "public" schema from my database, DSpace installation already fails while trying to create the database tables: ================= [java] 2014-07-21 16:47:36,514 INFO org.dspace.servicemanager.DSpaceKernelImpl @ DSpace kernel startup completed in 1826 ms and registered as MBean: org.dspace:name=772d5a14-d9eb-459d-8430-d35355120306,type=DSpaceKernel [java] 2014-07-21 16:47:36,518 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2014-07-21 16:47:36,528 INFO net.sf.ehcache.util.UpdateChecker @ New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4] [java] 2014-07-21 16:47:36,605 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in [java] org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:961) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:50) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] at java.lang.reflect.Method.invoke(Method.java:606) [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225) [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77) ================= This Exception is repeated really often, followed by other Exceptions complaining missing relations, like "item".

    Sakai JIRA | 2 years ago | Pascal-Nicolas Becker
    org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
  2. 0

    I tried to install DSpace with another schema than the default "public" schema. Nevertheless all necessary tables, sequences and the function getnextid where created in public schema. The ant build (I called fresh_install) fails with the following Exception: ================= load_registries: [java] 2014-07-21 16:40:07,480 INFO org.dspace.core.ConfigurationManager @ Loading system provided config property (-Ddspace.configuration): config/dspace.cfg [java] 2014-07-21 16:40:07,493 INFO org.dspace.core.ConfigurationManager @ Using default log4j provided log configuration. If unintended, check your dspace.cfg for (log.init.config) [java] 2014-07-21 16:40:07,908 FATAL org.dspace.administer.RegistryLoader @ anonymous::error_loading_registries: [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [java] Position: 39 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [java] at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1725) [java] at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:655) [java] at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:446) [java] at org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403) [java] at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172) [java] at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138) [java] at org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75) [java] Error: [java] - ERROR: syntax error at or near ")" [java] Position: 39 BUILD FAILED /home/pbecker/git/tuub/dspace/target/dspace-installer/build.xml:858: Java returned: 1 ================= If I remove the "public" schema from my database, DSpace installation already fails while trying to create the database tables: ================= [java] 2014-07-21 16:47:36,514 INFO org.dspace.servicemanager.DSpaceKernelImpl @ DSpace kernel startup completed in 1826 ms and registered as MBean: org.dspace:name=772d5a14-d9eb-459d-8430-d35355120306,type=DSpaceKernel [java] 2014-07-21 16:47:36,518 INFO org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database [java] 2014-07-21 16:47:36,528 INFO net.sf.ehcache.util.UpdateChecker @ New update(s) found: 2.4.7 [http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4] [java] 2014-07-21 16:47:36,605 WARN org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in [java] org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) [java] at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:961) [java] at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:50) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] at java.lang.reflect.Method.invoke(Method.java:606) [java] at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225) [java] at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77) ================= This Exception is repeated really often, followed by other Exceptions complaining missing relations, like "item".

    Sakai JIRA | 2 years ago | Pascal-Nicolas Becker
    org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
  3. 0

    DSpace / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: Flyway migration error occurred
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DSpace-CRIS Database Update Failure

    Google Groups | 3 months ago | Sean Carte
    java.sql.SQLException: Flyway migration error occurred
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: no schema has been selected to create in

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    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.execute(AbstractJdbc2Statement.java:366)
    6 frames
  3. Commons DBCP
    DelegatingStatement.execute
    1. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    2. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    3. org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    3 frames
  4. DSpace Kernel :: API and Implementation
    InitializeDatabase.main
    1. org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:961)
    2. org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:50)
    2 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  6. DSpace Kernel :: API and Implementation
    ScriptLauncher.main
    1. org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225)
    2. org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77)
    2 frames