It's an ongoing issue with DSpace that many of its connections to Postgres end up in an "idle in transaction" state, which sooner or later fill up the connection pool, regardless of the pool size. The error you got is a result of this - all the connections in the pool have been open, so the indexing command couldn't open a new connection.
There is only a temporary solution, but it's a simple one - restart either DSpace or Postgres. Then run the indexing command again. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Thu, Dec 15, 2016 at 9:45 AM, Stephano John <[email protected]> wrote: > 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]. > 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. > -- 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.
