Dear Stephano, I believe your problem is not specifically related to the index-discovery task. Most likely, other operations will be intermittently failing as well. If you connect to your postgres server and select from pg_stat_activity, you will likely see a lot of queries with a status of idle in transaction by the dspace user. The only solution I know is to restart tomcat.
Good Luck, James From: <[email protected]> on behalf of Stephano John <[email protected]> Date: Thursday, December 15, 2016 at 2:45 AM To: "[email protected]" <[email protected]> Subject: [dspace-tech] Exporting collection metadata error. Dear all, I moved items of one collection to another collection by exporting metadata and importing as an administrator which it has worked fine several time. But the same procedures it has failed to work yesterday and it gives me the following error when i try to index because what i exported are not displayed on the new collection. please help Stephano. /dspace# ./bin/dspace index-discovery Exception: FATAL: remaining connection slots are reserved for non-replication superuser connections org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) at org.postgresql.Driver.makeConnection(Driver.java:393) at org.postgresql.Driver.connect(Driver.java:267) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:584) at org.dspace.core.Context.init(Context.java:121) at org.dspace.core.Context.<init>(Context.java:95) at org.dspace.discovery.IndexClient.main(IndexClient.java:41) 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.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:225) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:77) -- 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]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at https://groups.google.com/group/dspace-tech<https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_group_dspace-2Dtech&d=CwMFaQ&c=ODFT-G5SujMiGrKuoJJjVg&r=V6tqD8ofDtKmseXi7TXu4l-_PxkyYWnoGE_B1XhiAjg&m=QD_yzeLHUahtr7d8uHL8cIk8ID08A3Lwmf1cQnml0CM&s=lmvm0cSnk5UDO6z5nEbY4GWDaVRROjITVX6LVPfKU2g&e=>. For more options, visit https://groups.google.com/d/optout<https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_optout&d=CwMFaQ&c=ODFT-G5SujMiGrKuoJJjVg&r=V6tqD8ofDtKmseXi7TXu4l-_PxkyYWnoGE_B1XhiAjg&m=QD_yzeLHUahtr7d8uHL8cIk8ID08A3Lwmf1cQnml0CM&s=1oftmHwg_ngsPAbwhEGymzWd_rxSCKJmZXjA4fXoVT0&e=>. -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
