Hi, In these DSpace logs, I'm seeing this same error over and over again:
"2015-02-17 21:41:26,956 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL getDataSource Error - org.postgresql.util.PSQLException: FATAL: database "dspace" does not exist" This error states that your database named "dspace" doesn't even exist, which is odd. In any case, regarding this other error: "Error attempting to update Bitstream Format and/or Metadata Registries org.postgresql.util.PSQLException: ERROR: null value in column "bitstream_format_id" violates not-null constraint" This error implies that in your "bitstreamformatregistry" table, at least one row has a value of "null" in the "bitstream_format_id" column. "null" is not a valid "bitstream_format_id" value, so DSpace doesn't know how to continue. You may want to inspect the values in your "bitstream_format_registry" table to see if there are any null values in there: SELECT * FROM bitstreamformatregistry; Finally, another question. By any chance do you have multiple DSpace databases in the same PostgreSQL database (perhaps under different schemas?). The behavior in your logs seems very odd. At one moment, DSpace cannot locate the database (FATAL: database "dspace" does not exist"), and then later it seems like it can locate the database, but then the "bitstreamformatregistry" table has null values. I'm just trying to determine why this would be? - Tim On 2/18/2015 1:08 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 > > Again I restored dspace.sql after dropdb. but as per status of info > command it schema is not updating to to dspace 5. and also some error > are shown in tomcat running screen when accessed dspace url. > [dspace@sircdl root]$ 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) > ) > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > LOG: unexpected EOF on client connection > > For more details all logs from dspace and tomcat are attached herewith. > > Pls reply soon > > With regards > > Indu Bhushan > > On Tue, Feb 17, 2015 at 9:11 PM, Tim Donohue <[email protected] > <mailto:[email protected]>> 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 > [email protected].__net > <mailto:[email protected]> > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
