Hello,
I'm attempting to reindex our DSpace instance to fix the search and I am
unable to do so, given the below stack trace. The database and its
tables/sequences are owned by citidel, the dspace databse user, not the super
user, so the reindex should work. I ran the SQL queries below just to be sure
that the sequence in question had the right permissions. It's odd that this
sequence of all things is mentioned, however our db was ultimately upgraded to
DSpace 1.4 and this new sequence was created by running
database_schema_13-14.sql, which may have something to do with it.
citidel=# alter table itemsbysubject owner to citidel;
ALTER TABLE
citidel=# alter table itemsbysubject_seq owner to citidel;
ALTER TABLE
bash-2.05$ index-all
Creating browse index
Indexing all Items in DSpace....Error: Browse index NOT created
java.sql.SQLException: ERROR: permission denied for sequence
itemsbysubject_seq
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1482)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1267)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:782)
at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:587)
at org.dspace.browse.Browse.itemAdded(Browse.java:549)
at org.dspace.browse.Browse.indexAll(Browse.java:606)
at org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74)
Creating search index
Done with indexing
Thank you!
Will Cameron
---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
