Thanks for the reply.
I tried your solution and something interesting has happened; the error
has changed to;
Exception in thread "main" org.postgresql.util.PSQLException: FATAL: the
database system is shutting down
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:514)
at org.dspace.core.Context.<init>(Context.java:117)
at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:336)
Does this mean my database is corrupted or am I able to recover from this?
mikan.d.dspace listmail wrote:
> Just a thought; try to run importer by changing to dspace/bin
> directory first.
>
> -Mika
>
>
> 2008/10/7 Mr Havercamp <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>
>
> I've recently been importing a few thousand records into dspace using
> the import tool that is supplied within the ./bin directory.
>
> Up until recently I have been importing collections without incident
> until last night when, during an import, I lost my remote
> connection to
> my DSpace server.
>
> When attempting to resume an import;
>
> # sudo /path/to/dspace/bin/import -c 123456789/8 -a -R -m
> /path/to/dspace/imports/photographs.log -e [EMAIL PROTECTED] -s
> /path/to/assets/photographs
>
> the following error is thrown;
>
> Exception in thread "main" java.sql.SQLException:
> java.lang.ClassNotFoundException:
> at
>
> org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1555)
> at
>
> org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:512)
> at org.dspace.core.Context.<init>(Context.java:117)
> at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:336)
>
> I've checked the logs and have not been able to find any other
> information except for when I restart postgresql I see;
>
> 2008-10-07 12:54:46 UTC LOG: received smart shutdown request
> 2008-10-07 12:54:46 UTC LOG: autovacuum launcher shutting down
> 2008-10-07 12:56:11 UTC LOG: incomplete startup packet
>
> Restarting the Postgresql server a number of times fixed the
> problem but
> unfortunately, during the second update I lost the connection
> again and
> this time I get the same outcome above but I cannot seem to
> resolve it.
> I've checked my import log file for incomplete data but it looks fine
> and checking the last record in DSpace show that it was imported
> successfully.
>
> Any help would be much appreciated as I do not fancy setting up the
> entire dspace database again.
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> <http://moblin-contest.org/redirect.php?banner_id=100&url=/>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> <mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech