Re: [Dspace-tech] Item Mapper and DSpace Upgrade/Indexing Problem

3 views

Skip to first unread message

Thornton, Susan M. (LARC-B702)[LITES]

unread,

Aug 25, 2015, 4:53:48 PM8/25/15

to aay...@aucegypt.edu, dspac...@lists.sourceforge.net, ko...@aucegypt.edu, am_m...@aucegypt.edu

We are in the process of upgrading from 1.5.1 to 1.7.1 and I do see column authority in table bi_2_dis. Try altering this table with the following ddl:

-- Column: authority

-- ALTER TABLE bi_2_dis DROP COLUMN authority;

ALTER TABLE bi_2_dis ADD COLUMN authority character varying(100);

I’m not quite sure how you ended up without this column, but hopefully this will correct your problem.

Sue

Sue Walker-Thornton

Software Developer/Database Administrator

NASA Langley Research Center|LITES Contract

(757) 224-4074

From: Asmaa Ayman [mailto:aay...@aucegypt.edu]
Sent: Monday, June 20, 2011 10:54 AM
To: dspac...@lists.sourceforge.net
Cc: Amira Shoukry; Maha El Koshairi
Subject: [Dspace-tech] Item Mapper and DSpace Upgrade/Indexing Problem

Hi, I upgraded recently from dspace 1.5.2 to dspace 1.7.1 -- I went through a 2-phases upgrade, from 1.5.x to 1.6.x and then from 1.6.x to 1.7.x

It worked fine with me but when I tried the item mapper I got the error:

[error details below]

org.dspace.browse.BrowseDAOPostgres @ caught exception:

org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not exist

I was searching for the cause of this error when I came through this: http://www.mail-archive.com/dspac...@lists.sourceforge.net/msg11125.html

so I deleted the tables that start with bi_ and tried generating the browse and search indexes, yet I get the following error, the tables are created with the authority column not containing any values. As a result, the search stopped working. Your help is highly appreciated.

E:\dspace\bin>dspace index-init

Using DSpace installation in: E:\dspace

Started: 1308578975296

Ended: 1308578990093

Elapsed time: 14 secs (14797 msecs)

Exception: null

java.lang.NullPointerException

at org.apache.lucene.index.DocumentsWriter.addDeleteTerm(DocumentsWriter

.java:1113)

at org.apache.lucene.index.DocumentsWriter.getThreadState(DocumentsWrite

r.java:765)

at org.apache.lucene.index.DocumentsWriter.updateDocument(DocumentsWrite

r.java:816)

at org.apache.lucene.index.DocumentsWriter.updateDocument(DocumentsWrite

r.java:809)

at org.apache.lucene.index.IndexWriter.updateDocument(IndexWriter.java:2

683)

at org.apache.lucene.index.IndexWriter.updateDocument(IndexWriter.java:2

655)

at org.dspace.search.DSIndexer.executeIndexingTask(DSIndexer.java:742)

at org.dspace.search.DSIndexer.flushIndexingTaskQueue(DSIndexer.java:799

)

at org.dspace.search.DSIndexer.flushIndexingTaskQueue(DSIndexer.java:770

)

at org.dspace.search.DSIndexer.setBatchProcessingMode(DSIndexer.java:233

)

at org.dspace.search.DSIndexer.main(DSIndexer.java:489)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)

Thanks a lot,

Asmaa

[org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not exist]

-----------------------------------------------------------------------------------------------------------------------------------------------

org.dspace.browse.BrowseDAOPostgres @ caught exception:

org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not exist

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:284)

at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:153)

at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:752)

at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:712)

at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:264)

at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:100)

at org.dspace.app.webui.servlet.admin.ItemMapServlet.doDSPost(ItemMapServlet.java:295)

at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)

at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)

at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:323)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1719)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2011-06-20 14:40:52,274 ERROR org.dspace.app.webui.servlet.admin.ItemMapServlet @ caught exception:

org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not exist

at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:168)