org.postgresql.util.PSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • 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".
    via by Pascal-Nicolas Becker,
  • 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".
    via by Pascal-Nicolas Becker,
  • DSpace / Mailing Lists
    via by Unknown author,
  • DSpace-CRIS Database Update Failure
    via by Sean Carte,
  • SQL deadlock detected
    via by dave J,
  • Custom Variables problem
    via by A. S.,
  • GitHub comment 152#171726766
    via GitHub by trisberg
    ,
    • org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in 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.execute(AbstractJdbc2Statement.java:366) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:961) at org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:50) 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.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77)

    Users with the same issue

    Unknown User
    9 times, last one,
    Unknown visitor1 times, last one,
    silex
    6 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    90 more bugmates