Hi Helix
Got debug mode working somehow. Used psi-probe:
http://psi-probe.googlecode.com
Here are the DB queries, just before the error in the logs.
>>>
2014-08-01 09:56:00,180 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "INSERT INTO webapp ( ) VALUES ( ) RETURNING null"
2014-08-01 09:56:12,420 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "INSERT INTO webapp ( ) VALUES ( ) RETURNING null"
2014-08-01 12:08:39,380 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "INSERT INTO webapp ( ) VALUES ( ) RETURNING null"
2014-08-01 12:08:49,930 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "INSERT INTO webapp ( ) VALUES ( ) RETURNING null"
>>>
And here is the full log of the latest attempt.
>>>
2014-08-01 12:08:49,930 DEBUG org.dspace.storage.rdbms.DatabaseManager @
Running query "INSERT INTO webapp ( ) VALUES ( ) RETURNING null"
2014-08-01 12:08:49,949 ERROR org.dspace.app.util.AbstractDSpaceWebapp @
Failed to record startup in Webapp table.
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 22
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.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1754)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:671)
at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:447)
at
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
at
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
>>>
Regards
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
http://scholar.sun.ac.za
http://bit.ly/goodir
http://library.sun.ac.za
http://za.linkedin.com/in/hiltongibson
On 31 July 2014 15:24, helix84 <[email protected]> wrote:
> Hi Hilton,
>
> above the error line [1] there's a branch that will print the
> offending query to the log. Please, turn up log level to DEBUG, which
> will give us the exact query that trows this SQL syntax error.
>
> [1]
> https://github.com/DSpace/DSpace/blob/dspace-4.2/dspace-api/src/main/java/org/dspace/storage/rdbms/DatabaseManager.java#L1754
>
>
> Regards,
> ~~helix84
>
> Compulsory reading: DSpace Mailing List Etiquette
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
