Hello,
I'm attempting to reindex our DSpace instance 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
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.-------------------------------------------------------------------------
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
