Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2070

Postgresql: DSpace ignores db.schema configuration property

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2
    • Fix Version/s: 5.0
    • Component/s: None
    • Environment:
      DSpace master branch from July 21st 2014, Postgresql, java 1.7, Ubuntu
    • Attachments:
      0
    • Comments:
      18
    • Documentation Status:
      Not Required

      Description

      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".

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pbecker Pascal-Nicolas Becker
                Reporter:
                pbecker Pascal-Nicolas Becker
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: