Yes, I've restarted the database a number of times but the problem still 
persists.

I've just restarted it again and tried a re-import and same problem.

During restart, the Postgresql logs report;

2008-10-08 08:22:21 UTC LOG:  incomplete startup packet

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

Reply via email to