Well good news. I carried out an upgrade on our Ubuntu server and had to reboot it due to a kernel update. When it came back up, I started the import again and it's working.
Not sure what has happened here but I'm wondering if simply restarting the postgres daemon is not enough and whether I need to restart it using something more than; sudo /etc/init.d/postgresql restart Thanks again for the help. mikan.d.dspace listmail wrote: > To me, it seems your postgres database is not running at all. Shutdown > and restart the database (etc/init.d/postqres restart, or similar), > then run importer. > > -Mika > > > 2008/10/8 Mr Havercamp <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> > > 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]> <mailto:[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=/> > <http://moblin-contest.org/redirect.php?banner_id=100&url=/ > <http://moblin-contest.org/redirect.php?banner_id=100&url=/>> > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > <mailto:DSpace-tech@lists.sourceforge.net> > <mailto:DSpace-tech@lists.sourceforge.net > <mailto:DSpace-tech@lists.sourceforge.net>> > > 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
