Dear Team
After various effort i am unable to upgrade DSPACE in system so i am
planning to install same version of dspace. My database back file is shared
with google if someone get any idea to help me.
[dspace@sircdl root]$ /opt/dspace/bin/dspace database test
Attempting to connect to database using these configurations:
- URL: jdbc:postgresql://localhost:5432/dspace
- Driver: org.postgresql.Driver
- Username: dspace
- Password: [hidden]
- Schema:
Testing connection...
Connected successfully!
On Wed, Feb 18, 2015 at 8:27 PM, Tim Donohue <tdono...@duraspace.org> wrote:
> 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 <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
