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
