org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 39

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: syntax error at or near ")" Position: 39
  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: syntax error at or near ")" Position: 39
  3. 0

    GitHub comment 413#162845402

    GitHub | 12 months ago | kosarko
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HTTP Status 500 - The absolute uri: http://www.dspace.org/dspace-tags.tld cannot be resolved

    Google Groups | 11 months ago | Mohamad CHAITOU
    org.postgresql.util.PSQLException: ERROR: relation "eperson" does not exist Position: 15
  6. 0

    We found a problem after upgrading from dspace 3.2 to dspace 5.0 rc2 (for testing purposes). We've tested running: /dspace/bin/dspace checker -lp the following error occurs when we tested with migrated itens or with new itens: dspace log -------------------------------------------------- Bitstream metadata could not be retrieved. ERROR: column bitstream.user_format_description does not exist Position: 141 org.postgresql.util.PSQLException: ERROR: column bitstream.user_format_description does not exist Position: 141 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:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.checker.BitstreamInfoDAO.findByBitstreamId(BitstreamInfoDAO.java:244) at org.dspace.checker.CheckerCommand.checkBitstream(CheckerCommand.java:142) at org.dspace.checker.CheckerCommand.process(CheckerCommand.java:119) at org.dspace.app.checker.ChecksumChecker.main(ChecksumChecker.java:233) 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) checksum checker log ------------------------------------------------- WET - STATEMENT: select bitstream.deleted, bitstream.store_number, bitstream.size_bytes, bitstreamformatregistry.short_description, bitstream.bitstream_id, bitstream.user_format_description, bitstream.internal_id, bitstream.source, bitstream.checksum_algorithm, bitstream.checksum, bitstream.name, most_recent_checksum.last_process_end_date,most_recent_checksum.to_be_processed from bitstream left outer join bitstreamformatregistry on bitstream.bitstream_format_id = bitstreamformatregistry.bitstream_format_id, most_recent_checksum where bitstream.bitstream_id = $1 and bitstream.bitstream_id = most_recent_checksum.bitstream_id 2015-01-08 00:00:00.299 WET - ERROR: column bitstream.user_format_description does not exist at character 141 ---------------------------------------------------------------- We know that some of the columns (one of them is the user_format_description) in the bitstream table are droped in this version of DSpace. We confirmed that after upgrading from 3.2 to 5.0 rc2, in the BD, the column bitstream.user_format_description no longer exists. We think the problem might be with the checker himself.

    Sakai JIRA | 2 years ago | Paulo Gra├ža
    org.postgresql.util.PSQLException: ERROR: column bitstream.user_format_description does not exist Position: 141
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: syntax error at or near ")" Position: 39

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    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:388)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3 frames
  4. DSpace Kernel :: API and Implementation
    RegistryLoader.main
    1. org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1725)
    2. org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:655)
    3. org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:446)
    4. org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
    5. org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
    6. org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
    7. org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
    7 frames