Hello Faizur, the error indicates that you forgot to run: [dspace]/bin/dspace index-init
Hope that helps Claudia Jürgen Am 01.09.2010 00:39, schrieb Rahman, Sm F: > Tim, > > I am sorry that I only hit "reply" instead of "reply all" which caused not to > send the email to "Dspace-tech". > >>> Here is the Cocoon log with Errors: > > Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is > aborted, commands ignored until end of transaction block > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) > >>> Here is the Postgres log with Errors: > > 2010-08-30 15:59:57 CDT ERROR: relation "bi_item" does not exist > 2010-08-30 15:59:57 CDT STATEMENT: SELECT COUNT(*) AS num FROM bi_item > 2010-08-30 16:00:00 CDT ERROR: relation "bi_2_dis" does not exist > 2010-08-30 16:00:00 CDT STATEMENT: SELECT COUNT(*) AS num FROM bi_2_dis > 2010-08-30 16:00:03 CDT ERROR: relation "bi_item" does not exist > 2010-08-30 16:00:03 CDT STATEMENT: SELECT COUNT(*) AS num FROM bi_item > 2010-08-30 16:00:09 CDT ERROR: relation "community" does not exist > 2010-08-30 16:00:09 CDT STATEMENT: SELECT * FROM community WHERE NOT > community_id IN (SELECT child_comm_id FROM community2community) ORDER BY name > 2010-08-30 16:00:09 CDT ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2010-08-30 16:00:09 CDT STATEMENT: SELECT * FROM community WHERE NOT > community_id IN (SELECT child_comm_id FROM community2community) ORDER BY name > 2010-08-30 16:00:11 CDT ERROR: relation "bi_item" does not exist > 2010-08-30 16:00:11 CDT STATEMENT: SELECT COUNT(*) AS num FROM bi_item > 2010-08-30 16:00:28 CDT ERROR: relation "bi_4_dis" does not exist > 2010-08-30 16:00:28 CDT STATEMENT: SELECT COUNT(*) AS num FROM bi_4_dis > 2010-08-30 20:02:01 CDT LOG: incomplete startup packet > 2010-08-31 00:02:01 CDT LOG: incomplete startup packet > 2010-08-31 05:02:01 CDT LOG: incomplete startup packet > 2010-08-31 10:02:01 CDT LOG: incomplete startup packet > 2010-08-31 13:53:53 CDT ERROR: relation "eperson" does not exist > 2010-08-31 13:53:53 CDT STATEMENT: select * from eperson where email = $1 > 2010-08-31 13:53:56 CDT ERROR: relation "community" does not exist > >>> Don't see any error in tomcat log > > I think the import didn't go through correctly, what do you think and how to > encouter this problem? > > Thanks, > > Faizur > > -----Original Message----- > From: Tim Donohue [mailto:[email protected]] > Sent: Tuesday, August 31, 2010 2:42 PM > To: Rahman, Sm F > Cc: dspace-tech > Subject: Re: [Dspace-tech] Dspace import/Replace error > > Faizur, > > I'm copying in 'dspace-tech' again on my response. We prefer to answer > questions on the listserv itself, as it is then a resource for others > who may end up experiencing the same issue. > > Your dspace.log file output looks normal. Those lines of the log that > you sent are just showing that you accessed the main homepage (or > possibly the Community listing), which ran queries to determine which > communities to display on that homepage. There are no ERROR lines in > that log (where it says "DEBUG" or "INFO", you should see "ERROR" when a > problem occurs). > > You may want to also check the Tomcat logs and PostgreSQL logs. > Especially look to see what is logged when you see that "An error has > occurred" message -- there should be a log file line somewhere with > "ERROR" in it. Again this webpage will detail the location of your > logs: https://wiki.duraspace.org/display/DSPACE/Troubleshoot+an+error > > - Tim > > On 8/31/2010 2:23 PM, Rahman, Sm F wrote: >> Tim, >> >> Thanks again for offering the help, I restored the DB from backup and >> replace the Assetstore but giving me the same error. I went through the >> Troubleshoot instructions that you sent me, changed the config file and here >> is what looks like in the Dspace log. Here is the instance at: >> http://10.110.33.25:8180/xmlui/password-login >> >> Dspace log: >> >> 2010-08-31 13:55:20,089 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> 2010-08-31 13:55:20,089 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> 2010-08-31 14:00:00,154 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> 2010-08-31 14:00:00,154 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> 2010-08-31 14:00:00,155 INFO >> org.dspace.app.xmlui.aspect.artifactbrowser.CommunityBrowser @ >> anonymous:session_id=E21866AE973E650DA0637719BE83BE00:ip_addr=10.110.33.126:view_community_list: >> 2010-08-31 14:00:00,157 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> 2010-08-31 14:00:00,157 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >> Running query "SELECT * FROM community WHERE NOT community_id IN (SELECT >> child_comm_id FROM community2community) ORDER BY name" with parameters: >> >> Thanks again, Faizur >> >> -----Original Message----- >> From: Tim Donohue [mailto:[email protected]] >> Sent: Tuesday, August 31, 2010 9:36 AM >> To: Rahman, Sm F >> Cc: [email protected] >> Subject: Re: [Dspace-tech] Dspace import/Replace error >> >> Faizur, >> >> Your steps sound correct. All you need to do is restore your complete >> database from backup, and replace your Assetstore directory with the one >> from backup. Assuming your Database backup and Assetstore backup are >> from around the same time (doesn't need to be exact), everything should >> work fine. >> >> Can you check your underlying log files to see if any other errors are >> reported there? Please see the "How to Troubleshoot an Error" page for >> information about finding the error in the log files: >> https://wiki.duraspace.org/display/DSPACE/Troubleshoot+an+error >> >> - Tim >> >> On 8/30/2010 3:52 PM, Rahman, Sm F wrote: >>> Respected all, >>> >>> I am new in Dspace and Postgres and I am having trouble importing and >>> replacing the existing dspace AssetStore and Postgress database using >>> the backups. The steps I am following are: >>> >>> 1) Stop tomcat >>> >>> 2) Drop and recreate the dspace database >>> >>> 3) Restore the data from the backup >>> >>> 4) Update dspace sequences: [dspace-source]/dspace/etc/update-sequences.sql >>> >>> 5) Delete existing AssetStore >>> >>> 6) Restore the AssetStore from the backup >>> >>> 7) Start tomcat. >>> >>> The error I am getting after clicking the communities are: >>> >>> *An error has occured* >>> >>> *org.postgresql.util.PSQLException: ERROR: current transaction is >>> aborted, commands ignored until end of transaction block* >>> >>> * * >>> >>> *Cocoon stacktrace* >>> >>> *Java stacktrace * >>> >>> *Java full stacktrace* >>> >>> Thanks, >>> >>> Faizur Rahman, Ph.D. >>> >>> UTD Library Systems >>> >>> 972-883-4100 >>> >>> [email protected] >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> This SF.net Dev2Dev email is sponsored by: >>> >>> Show off your parallel programming skills. >>> Enter the Intel(R) Threading Challenge 2010. >>> http://p.sf.net/sfu/intel-thread-sfd >>> >>> >>> >>> _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech > > ------------------------------------------------------------------------------ > This SF.net Dev2Dev email is sponsored by: > > Show off your parallel programming skills. > Enter the Intel(R) Threading Challenge 2010. > http://p.sf.net/sfu/intel-thread-sfd > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
