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
