Hi,
I am trying to run index-all and it is failing. This had worked a few months ago and still works on a development site, but not on the live site. Search and download of files still seem to be OK on the live site. For our system the postgres database resides on a different box from the DSPACE installation. Here are some properties of our system:

DSpace Version 1.4.1
PostgresSQL 7.4.19
Using JRE_HOME: /opt/jdk1.5.0_10
Server version: Apache Tomcat/5.5.20
Server number: 5.5.20.0
OS Name: Linux
OS Version: 2.6.9-78.0.1.ELsmp
Architecture: i386
JVM Version: 1.5.0_10-b03
JVM Vendor: Sun Microsystems Inc.

Server version: Apache/2.0.52
Server built: May 9 2008 05:54:40
mod_jk/1.2.25

Thanks for any help,

Jeff Silvis

Error Message:


[EMAIL PROTECTED] bin]$ sudo -u tomcat ./index-all
Creating browse index
Indexing all Items in DSpace....2008-10-21 21:33:22,771 INFO org.dspace.core.ConfigurationManager @ DSpace logging installed using log4j.properties 2008-10-21 21:33:26,313 INFO org.dspace.content.MetadataField @ Loading MetadataField elements into cache. 2008-10-21 21:33:26,391 INFO org.dspace.content.MetadataSchema @ Loading schema cache for fast finds
Error: Browse index NOT created
org.postgresql.util.PSQLException: An I/O error occured while reading from backend - Exception: java.net.SocketException: Connection reset
Stack Trace:

java.net.SocketException: Connection reset
        at java.net.SocketInputStream.read(SocketInputStream.java:168)
at java.io.BufferedInputStream.fill(BufferedInputStream.java: 218) at java.io.BufferedInputStream.read(BufferedInputStream.java: 235)
        at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:166)
at org.postgresql.core.QueryExecutor.executeV3 (QueryExecutor.java:127) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute (AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery (AbstractJdbc1Statement.java:233) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable (DatabaseManager.java:159) at org.dspace.storage.rdbms.DatabaseManager.queryTable (DatabaseManager.java:194) at org.dspace.content.Community.getParentCommunity (Community.java:549) at org.dspace.content.Community.getAllParents(Community.java: 589)
        at org.dspace.content.Item.getCommunities(Item.java:944)
        at org.dspace.browse.Browse.itemAdded(Browse.java:489)
        at org.dspace.browse.Browse.indexAll(Browse.java:606)
at org.dspace.browse.InitializeBrowse.main (InitializeBrowse.java:74)
End of Stack Trace

        at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:172)
at org.postgresql.core.QueryExecutor.executeV3 (QueryExecutor.java:127) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute (AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery (AbstractJdbc1Statement.java:233) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable (DatabaseManager.java:159) at org.dspace.storage.rdbms.DatabaseManager.queryTable (DatabaseManager.java:194) at org.dspace.content.Community.getParentCommunity (Community.java:549) at org.dspace.content.Community.getAllParents(Community.java: 589)
        at org.dspace.content.Item.getCommunities(Item.java:944)
        at org.dspace.browse.Browse.itemAdded(Browse.java:489)
        at org.dspace.browse.Browse.indexAll(Browse.java:606)
at org.dspace.browse.InitializeBrowse.main (InitializeBrowse.java:74)
Creating search index
2008-10-21 21:39:02,479 INFO org.dspace.core.ConfigurationManager @ DSpace logging installed using log4j.properties 2008-10-21 21:39:04,182 INFO org.dspace.content.MetadataField @ Loading MetadataField elements into cache. 2008-10-21 21:39:04,216 INFO org.dspace.content.MetadataSchema @ Loading schema cache for fast finds Exception in thread "main" org.postgresql.util.PSQLException: The backend has broken the connection. Possibly the action you have attempted has caused it to close.
        at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:168)
at org.postgresql.core.QueryExecutor.executeV3 (QueryExecutor.java:127) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute (QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute (AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:50) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery (AbstractJdbc1Statement.java:233) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery (DelegatingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.queryTable (DatabaseManager.java:159) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable (DatabaseManager.java:447) at org.dspace.storage.rdbms.DatabaseManager.querySingleTable (DatabaseManager.java:465) at org.dspace.storage.rdbms.DatabaseManager.findByUnique (DatabaseManager.java:647) at org.dspace.storage.rdbms.DatabaseManager.find (DatabaseManager.java:612) at org.dspace.storage.bitstore.BitstreamStorageManager.retrieve (BitstreamStorageManager.java:537)
        at org.dspace.content.Bitstream.retrieve(Bitstream.java:512)
at org.dspace.search.DSIndexer.writeItemIndex(DSIndexer.java: 690) at org.dspace.search.DSIndexer.indexAllItems(DSIndexer.java: 394)
        at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:191)
        at org.dspace.search.DSIndexer.main(DSIndexer.java:222)
[EMAIL PROTECTED] bin]$
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to