Tim/Claudia,
Here is what I am getting after running the index-init script, any suggestions?
Thanks, Faizur
dsp...@ubuntu:~/bin$ ./index-init
Creating browse index
Exception in thread "main" org.dspace.browse.BrowseException:
org.postgresql.util.PSQLException: ERROR: no schema has been selected to create
in
at
org.dspace.browse.BrowseCreateDAOPostgres.createSequence(BrowseCreateDAOPostgres.java:394)
at org.dspace.browse.IndexBrowse.createItemTables(IndexBrowse.java:952)
at org.dspace.browse.IndexBrowse.createItemTables(IndexBrowse.java:921)
at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:739)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1045)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:707)
Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been
selected to create in
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.executeUpdate(AbstractJdbc2Statement.java:308)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:390)
at
org.dspace.browse.BrowseCreateDAOPostgres.createSequence(BrowseCreateDAOPostgres.java:387)
... 5 more
Exception in thread "main" org.dspace.browse.ItemCountException:
org.postgresql.util.PSQLException: ERROR: relation "community" does not exist
at org.dspace.browse.ItemCounter.buildItemCounts(ItemCounter.java:124)
at org.dspace.browse.ItemCounter.main(ItemCounter.java:85)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "community" 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:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:169)
at org.dspace.content.Community.findAllTop(Community.java:286)
at org.dspace.browse.ItemCounter.buildItemCounts(ItemCounter.java:115)
... 1 more
Creating search index
Faizur Rahman, Ph.D.
UTD Library Systems
972-883-4100
sm.rah...@utdallas.edu
-----Original Message-----
From: Tim Donohue [mailto:tdono...@duraspace.org]
Sent: Wednesday, September 01, 2010 9:05 AM
To: claudia.juer...@ub.tu-dortmund.de
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Dspace import/Replace error
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:tdono...@duraspace.org]
>> 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:tdono...@duraspace.org]
>>> Sent: Tuesday, August 31, 2010 9:36 AM
>>> To: Rahman, Sm F
>>> Cc: dspace-tech@lists.sourceforge.net
>>> 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
>>>>
>>>> sm.rah...@utdallas.edu
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> 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
>>>> DSpace-tech@lists.sourceforge.net
>>>> 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
>> DSpace-tech@lists.sourceforge.net
>> 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
DSpace-tech@lists.sourceforge.net
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
