Bugs item #2526812, was opened at 2009-01-21 19:20 Message generated for change (Settings changed) made by nuncanada You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=119984&aid=2526812&group_id=19984
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: E-Person/Group Mgmt Group: None >Status: Closed >Resolution: Later Priority: 5 Private: No Submitted By: Flavio Botelho (nuncanada) Assigned to: Nobody/Anonymous (nobody) Summary: Second registration by user causes Exception Initial Comment: Whenever a user tries to register his email a second time an exception is thrown. Instead an appropriate message should be displayed. Exception: Um erro interno de sistema ocorreu em http://bdjur.stj.gov.br/jspuiData: 12/01/09 15:07 Identificador do erro: A390FCB4F4E30A63E38AC287624A76E7 -- URL Was: http://10.12.0.234/jspui//register-- Referer: http://bdjur.stj.gov.br/jspui/register-- Method: POST -- Parameters were: -- email: "[email protected]" -- step: "1" -- submit: "Registrar" Cookies -> Cookie: name=JSESSIONID value=A390FCB4F4E30A63E38AC287624A76E7 domain=null maxAge=-1 path=null Exception: org.postgresql.util.PSQLException: ERRO: duplicar chave viola a restrição de unicidade "registrationdata_email_key" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1559) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:193) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1355) at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:711) at org.dspace.eperson.AccountManager.sendInfo(AccountManager.java:240) at org.dspace.eperson.AccountManager.sendRegistrationInfo(AccountManager.java:101) at org.dspace.app.webui.servlet.RegisterServlet.processEnterEmail(RegisterServlet.java:287) at org.dspace.app.webui.servlet.RegisterServlet.doDSPost(RegisterServlet.java:202) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) 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.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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595) ---------------------------------------------------------------------- >Comment By: Flavio Botelho (nuncanada) Date: 2009-01-22 18:29 Message: I tried to reproduce the problem without success. But this problem is consistently happening from time to time. From the code i cannot see how it does, there is a check beforehand for the email. Could Postgres be failing from time to time? Or maybe some strange character is messing up the select but begin filtered during the insert? Anyways, i will close this bug until i find out more info. ---------------------------------------------------------------------- Comment By: Claudia Juergen (cjuergen) Date: 2009-01-22 14:42 Message: Hi Flavio, which version are you using? Checked it with a vanilla 1.5.1 jspui instance and the supposed already registered page was shown. Claudia ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=119984&aid=2526812&group_id=19984 ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
