Faizur, Claudia's correct -- running that 'dspace index-init' command is necessary. Its purpose is to rebuild your Browse tables (which all begin "bi_" -- based on your Postgres logs, those tables may be missing). It's usually best practice to re-run that 'index-init' command after a restore (I overlooked that it wasn't in your restore steps).
If that still doesn't resolve things, you may want to take a closer look at your database tables to make sure the database is being restored properly. - Tim On 9/1/2010 1:46 AM, Claudia Jürgen wrote: > 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 > ------------------------------------------------------------------------------ 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
