My installation is getting slow

[Adigun Samuel Akinwale]

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

Pls

[José Geraldo]

Hi,

https://wiki.duraspace.org/display/DSDOC6x/AIP+Backup+and+Restore#AIPBackupandRestore-CommonIssuesorErrorMessages 

http://blog.abraseucodigo.com.br/problemas-com-postgres-django-sequences.html 

--
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 dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/1743fbef-9076-465a-a0f4-a6bff0cfdd0e%40googlegroups.com.

--

At.te,

José Geraldo