We recently implemented configurable browse in our test instance of DSpace, and
everything went swimmingly. When we tried to move the changes to production,
however, we got deadlocks (see error messages below) while running the required
index-init. These errors occur during the browse portion of the index, and pop
up whether the new browse configurations are in place or not. Has anybody else
had this problem?
--
Bill Anderson
Software Developer
Digital Library Development
Georgia Tech Library
<Error messages, copied from bin/index-init output>
Creating browse index
Exception in thread "main" org.dspace.browse.BrowseException:
org.postgresql.util.PSQLException: ERROR: deadlock detected
Detail: Process 20247 waits for AccessExclusiveLock on relation 20116917 of
database 14218788; blocked by process 19174.
Process 19174 waits for AccessShareLock on relation 20116964 of database
14218788; blocked by process 20247.
at
org.dspace.browse.BrowseCreateDAOPostgres.dropIndexAndRelated(BrowseCreateDAOPostgres.java:447)
at org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:890)
at org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:864)
at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:737)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1045)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:707)
Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
Detail: Process 20247 waits for AccessExclusiveLock on relation 20116917 of
database 14218788; blocked by process 19174.
Process 19174 waits for AccessShareLock on relation 20116964 of database
14218788; blocked by process 20247.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:354)
at
org.dspace.browse.BrowseCreateDAOPostgres.dropIndexAndRelated(BrowseCreateDAOPostgres.java:440)
-------------------------------------------------------------------------
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-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
