[Dspace-tech] Problem while submission using DSpace 1.4.2 (Internal Server Error)

[Anshuman Jaiswal]

Subject: Problem while submission using DSpace 1.4.2

While working alone I never got these errors, but when 4-5 users are logged
on an making submissions this error comes frequently.

Details of the Error
After click on Next for "The item consists of more than one file" and
filling the first page of Item Submission (General Tab), on clicking next,
submission fails. Everyone needs to fill the page again, with time this
increases.

System in use
OS - RHEL5
Web Server/container Apache Tomcat
Database Postgres

The DB and app server are separate


The error log for the stack is as below
2010-05-25 15:44:30,968 WARN
org.dspace.app.webui.servlet.InternalErrorServlet @
:session_id=BE77304175A56DC62301758A0839FF01:internal_error:-- URL Was:
http://192.168.4.13:8080/dhcal/submit
-- Method: POST
-- Parameters were:
-- dc_date_created_month: "5"
-- dc_identifier_accessionnumber: "278130"
-- submit_next: "Next >"
-- workspace_item_id: "8279"
-- dc_date_created_day: "25"
-- dc_identifier_barcode: "PAT83401111"
-- dc_contributor_enteredby: "DSpace DSpace"
-- dc_description_projects: ""
-- dc_plant_typequalifier: "Probably"
-- step: "2"
-- dc_date_created_year: "2010"

java.lang.NullPointerException
       at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:156)
       at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:170)
       at org.dspace.workflow.WorkflowItem.findAll(WorkflowItem.java:172)
       at
org.dspace.app.webui.servlet.SubmitServlet.readText(SubmitServlet.java:2756)
       at
org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitServlet.java:914)
       at
org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:396)
       at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:320)
       at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:222)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
       at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
       at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
       at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
       at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
       at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
       at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
       at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
       at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
       at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
       at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
       at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
       at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
       at java.lang.Thread.run(Thread.java:595)

After this failure I can see 5-6 "Idle Wait" process for postgres user(which
is way lower than . Now idle wait is know issue, but the max connection for
DSpace is 99 and on postgres side it is set as 100, checked kernel settings
it is way more to give connection refusal.

Any idea on resolution of this issue ??
--
View this message in context: http://old.nabble.com/Problem-while-submission-using-DSpace-1.4.2-tp28739112p28739112.html
Sent from the DSpace - Tech mailing list archive at Nabble.com.