Hi, https://wiki.duraspace.org/display/DSDOC6x/AIP+Backup+and+Restore#AIPBackupandRestore-CommonIssuesorErrorMessages
http://blog.abraseucodigo.com.br/problemas-com-postgres-django-sequences.html Em qua, 9 de out de 2019 às 18:46, 'Adigun Samuel Akinwale' via DSpace Technical Support <[email protected]> escreveu: > Pls I install dspace 6.3 on debian 9 but i notice that the server is > getting slow when creating communities and other operations of the dspace. > It send this mail to the admin > > > An internal server error occurred on http://10.10.10.69:8080//jspui: > > Date: 10/8/19 7:16 AM > Session ID: 7A03FCCE99E6A3EDA6E3B2CC3AC7AD58 > User: Anonymous > IP address: 10.10.10.1 > > -- URL Was: http://dspace.run.edu.ng/jspui/register > -- Method: POST > -- Parameters were: > -- step: "1" > -- email: "godwinsrun.edu.ng" > -- submit: "Register" > > > Exception: > org.hibernate.exception.ConstraintViolationException: could not execute > batch > at > org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) > at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:122) > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) > at > org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161) > at > org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:207) > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:390) > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:304) > at > org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) > at > org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) > at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) > at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352) > at com.sun.proxy.$Proxy200.flush(Unknown Source) > at > org.dspace.core.HibernateDBConnection.commit(HibernateDBConnection.java:83) > at org.dspace.core.Context.commit(Context.java:435) > at org.dspace.core.Context.complete(Context.java:380) > at > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:187) > at > org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:80) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > at org.apache.tomcat.websocket.se > rver.WsFilter.doFilter(WsFilter.java:52) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) > at > org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) > at > org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) > at > org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) > at org.apache.tomcat.util.net > .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1458) > at org.apache.tomcat.util.net > .SocketProcessorBase.run(SocketProcessorBase.java:49) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.sql.BatchUpdateException: Batch entry 0 update > public.registrationdata set email='godwinsrun.edu.ng', expires=NULL, > token='d7ec2f9d17f4120505315b5d6a76e9c0' where registrationdata_id=14 was > aborted: ERROR: duplicate key value violates unique constraint > "registrationdata_email_key" > Detail: Key (email)=(godwinsrun.edu.ng) already exists. Call > getNextException to see other errors in the batch. > at > org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2168) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) > at > org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) > at > org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) > at > org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) > at > org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345) > at > org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:113) > ... 45 more > Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "registrationdata_email_key" > Detail: Key (email)=(godwinsrun.edu.ng) already exists. > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167) > ... 51 more > > Pls kindly help me out > > > > ReplyForward > > <https://drive.google.com/u/0/settings/storage?hl=en&utm_medium=web&utm_source=gmail&utm_campaign=manage_storage> > <https://www.google.com/gmail/about/policy/> > <https://www.google.com/> > Pls > > -- > All messages to this mailing list should adhere to the DuraSpace Code of > Conduct: https://duraspace.org/about/policies/code-of-conduct/ > --- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/1743fbef-9076-465a-a0f4-a6bff0cfdd0e%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-tech/1743fbef-9076-465a-a0f4-a6bff0cfdd0e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- At.te, José Geraldo -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CANP4ikRED5XP0qW%3DE4%2BQPhPt3xyjtwSgYXyQB6jtCB_yhg%3DMDQ%40mail.gmail.com.
