Hi, The log files you sent show a large number of database errors (at the beginning of the log) which look like this:
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. This seems to imply that your DSpace instance cannot connect with the database at all, which could cause all sorts of problems. Do either of these commands return errors (either in the results or in the log)? This tests the database connection: [dspace]/bin/dspace database test This provides info on the database contents: [dspace]/bin/dspace database info As for your questions, when restoring a database, you will need to recreate the database and possibly the 'dspace' database user (if it doesn't exist yet). Those are both needed prior to restoring the database. - Tim On 2/17/2015 10:58 PM, इन्दु भूषण Indu Bhushan wrote: > Dear Sir, > Thank for reply I was on leave yesterday. > I have the backup file from 1.8.2 version. I will retry to restore > database from that file. > -------------------------------------------------------------- > One more doubt if i have retoring database in new version & full fresh > intallation or in new machine the following two prcocess in needed or not. > Create a dspace database a postgres user, > $/opt/postgres/9.0/bin/createuser -U postgres -d -A -P dspace [Enter a > password for the DSpace database] > $/opt/postgres/9.0/bin/createdb -U dspace -E UNICODE dspace > ------------------------------------------------------------------------- > THEN > restore must be with as postgres user login > $ psql -d dspace -f dspace.sql THEN > to reset the primary key generation sequences (as dspace user) > $psql -U dspace -f/dspace/etc/update-sequences.sql > Then database schema migration as a dspace user. > -------------------------------------------------------- > > Please clear my doubt and process of restoring data and schema migration. > > Dspace log file is attached for your reference. > > Regrads > > Indu bhushan > > > On Tue, Feb 17, 2015 at 9:11 PM, Tim Donohue <tdono...@duraspace.org > <mailto:tdono...@duraspace.org>> wrote: > > > Could you also check to see what errors are reported in your DSpace > log files? Those files should be located at: > > [dspace.dir]/log/dspace.log.[__date] > > Where "dspace.dir" is configured in your dspace.cfg file. > > Based on what you've reported, it definitely looks like the database > migration process has gotten "confused". If it was halted > unexpectedly due to a harddrive crash, it's possible that part of a > migration was not completely successfully. But, the underlying > errors (in the logs) should give us more information. > > Another question: Do you have a backup of your database from before > you ran *any* migrations? According to your "dspace database info" > command, it looks like the "my-dspace-backup.sql" file already > included several migrations that were run on "2015-02-06 00:23:17" > (specifically a 1.7 and 1.8 migration). Do you have a backup from > prior to Feb 6, 2015 which had no migrations run on it yet? It > might be worth trying the migration again from an older backup (if > it is available). > > - Tim > > > On 2/16/2015 5:58 AM, इन्दु भूषण Indu Bhushan wrote: > > > > Apache Maven *3.0.5* , *Java version: 1.8.0_31, Apache Ant(TM) > version > 1.8.2*, postgres (PostgreSQL) 9.0.3, Linux RHEL 5 > Dear Sir > After sucessfully installing dspace when i restored backup. > dspace url > showing "HTTP Status 404 - /jspui" I am unable to update database > schema. I restored backup as a postgres user(psql dspace < > my-dspace-backup.sql) and updated database schema as dspace user) > Errors are attached below. Thanks in advance. > Please reply. > * [postgres*@sircdl root]$ psql -U dspace -f > > > /opt/dspace-5.0-src-release/__dspace/etc/postgres/update-__sequences.sql(as > postgres user) > > psql:/opt/dspace-5.0-src-__release/dspace/etc/postgres/__update-sequences.sql:87: > ERROR: relation "webapp" does not exist > LINE 1: SELECT setval('webapp_seq', max(webapp_id)) FROM webapp; > ^ > > psql:/opt/dspace-5.0-src-__release/dspace/etc/postgres/__update-sequences.sql:88: > ERROR: relation "requestitem" does not exist > LINE 1: ...tval('requestitem_seq', max(requestitem_id)) FROM > requestite... > [dspace@sircdl ~]$ /opt/dspace/bin/dspace database migrate > > Database URL: jdbc:postgresql://localhost:__5432/dspace > Migrating database to latest version... (Check logs for details) > Done. > [dspace@sircdl ~]$ /opt/dspace/bin/dspace database info > > Database URL: jdbc:postgresql://localhost:__5432/dspace > Database Schema: public > Database Software: PostgreSQL version 9.0.3 > Database Driver: PostgreSQL Native Driver version PostgreSQL 9.1 > JDBC4 > (build 901) > > > +----------------+------------__----------------+-------------__--------+---------+ > | Version | Description | Installed on > | > State | > > +----------------+------------__----------------+-------------__--------+---------+ > | 1.1 | Initial DSpace 1.1 databas | > | > PreInit | > | 1.2 | Upgrade to DSpace 1.2 sche | > | > PreInit | > | 1.3 | Upgrade to DSpace 1.3 sche | > | > PreInit | > | 1.3.9 | Drop constraint for DSpace | > | > PreInit | > | 1.4 | Upgrade to DSpace 1.4 sche | > | > PreInit | > | 1.5 | Upgrade to DSpace 1.5 sche | > | > PreInit | > | 1.5.9 | Drop constraint for DSpace | > | > PreInit | > | 1.6 | Upgrade to DSpace 1.6 sche | > | > PreInit | > | 1.7 | Initializing from DSpace 1 | 2015-02-06 > 00:23:17 | > Success | > | 1.8 | Upgrade to DSpace 1.8 sche | 2015-02-06 > 00:23:17 | > Success | > | 3.0 | Upgrade to DSpace 3.x sche | > | > Pending | > | 4.0 | Upgrade to DSpace 4.x sche | > | > Pending | > | 5.0.2014.08.08 | DS-1945 Helpdesk Request a | > | > Pending | > | 5.0.2014.09.25 | DS 1582 Metadata For All O | > | > Pending | > | 5.0.2014.09.26 | DS-1582 Metadata For All O | > | > Pending | > > +----------------+------------__----------------+-------------__--------+---------+ > > > +----------------+------------__----------------+-------------__--------+---------+ > > [dspace@sircdl ~]$ /opt/dspace/bin/dspace database migrate > > Database URL: jdbc:postgresql://localhost:__5432/dspace > Migrating database to latest version... (Check logs for details) > ERROR: null value in column "bitstream_format_id" violates not-null > constraint > STATEMENT: INSERT INTO bitstreamformatregistry ( > > short_description,internal,__description,bitstream_format___id,mimetype,support_level) > VALUES ( $1,$2,$3,$4,$5,$6) RETURNING null > ERROR: there is no unique constraint matching given keys for > referenced > table "item" > STATEMENT: CREATE TABLE versionitem > ( > versionitem_id INTEGER NOT NULL PRIMARY KEY, > item_id INTEGER REFERENCES Item(item_id), > version_number INTEGER, > eperson_id INTEGER REFERENCES EPerson(eperson_id), > version_date TIMESTAMP, > version_summary VARCHAR(255), > versionhistory_id INTEGER REFERENCES > VersionHistory(versionhistory___id) > ) > Done. > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > [dspace@sircdl ~]$ LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > > > > > > ------------------------------__------------------------------__------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and > Dashboards > with Interactivity, Sharing, Native Excel Exports, App > Integration & more > Get technology previously reserved for billion-dollar > corporations, FREE > > http://pubads.g.doubleclick.__net/gampad/clk?id=190641631&__iu=/4140/ostg.clktrk > > <http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk> > > > > _________________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.__net > <mailto:DSpace-tech@lists.sourceforge.net> > https://lists.sourceforge.net/__lists/listinfo/dspace-tech > <https://lists.sourceforge.net/lists/listinfo/dspace-tech> > List Etiquette: > https://wiki.duraspace.org/__display/DSPACE/Mailing+List+__Etiquette > <https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette> > > ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
