[Dspace-tech] build/install dspace 1.7 fails with mvn 3.0, ant 1.8, java 1.6.0_22 or conf?
30 views
Skip to first unread message
Kocisky
Aug 25, 2015, 4:27:07 PM8/25/15
to dspac...@lists.sourceforge.net
Hi all, i've been struggling to build/install dspace. I've tried
different version of software and configurations. It seems that some
queries fails because of non existent relations and/or an empty INSERT
statement in the bitstreamformatregistry table (which is correctly
installed).
I've attached the log of the maven build, the ant fresh_install, the
postgres database and the configuration.
---------------------------------------------------------------------------------------------------------------------------
The versions actually used are:
dspace 1.7.0
postgres 9.0.2
user@dev:~/Desktop/dspace-1.7.0-src-release/dspace$ mvn -version
Apache Maven 3.0.1 (r1038046; 2010-11-23 05:58:32-0500)
Java version: 1.6.0_22
Java home: /usr/lib/jvm/java-6-sun-1.6.0.22/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux" version: "2.6.26-2-686" arch: "i386" Family: "unix"
user@dev:~/Desktop/dspace-1.7.0-src-release/dspace$ ant -version
Apache Ant(TM) version 1.8.2 compiled on December 20 2010
---------------------------------------------------------------------------------------------------------------------------
dspace configuration
#
# DSpace Configuration
#
# NOTE: The DSpace Configuration File is separated into several sections:
# * General Configurations
# * JSPUI & XMLUI Configurations
# * JSPUI Specific Configurations
# * XMLUI Specific Configurations
# * OAI-PMH Specific Configurations
# * SWORD Specific Configurations
# * OAI Harvesting Configurations
# * SOLR Statistics Configurations
#
# Revision: $Revision: 5874 $
#
# Date: $Date: 2010-11-17 14:52:46 -0600 (Wed, 17 Nov 2010) $
#
#---------------------------------------------------------------#
#------------------GENERAL CONFIGURATIONS-----------------------#
#---------------------------------------------------------------#
# These configs are used by underlying DSpace API, and are #
# therefore applicable to all interfaces #
#---------------------------------------------------------------#
##### Basic information ######
# DSpace installation directory
dspace.dir = /usr/local/dspace
# DSpace host name - should match base URL. Do not include port number
dspace.hostname = localhost
# DSpace base host URL. Include port number etc.
dspace.baseUrl = http://localhost:8280/dspace
# DSpace base URL. Include port number etc., but NOT trailing slash
# Change to xmlui if you wish to use the xmlui as the default, or remove
# "/jspui" and set webapp of your choice as the "ROOT" webapp in
# the servlet engine.
dspace.url = ${dspace.baseUrl}/xmlui
# The base URL of the OAI webapp (do not include /request).
dspace.oai.url = ${dspace.baseUrl}/oai
# Name of the site
dspace.name = DSpace at TF
##### Database settings #####
# Database name ("oracle", or "postgres")
#db.name = ${default.db.name}
db.name = postgres
#db.name = oracle
# URL for connecting to database
#db.url = ${default.db.url}
db.url = jdbc:postgresql://localhost:5433/dspace
# JDBC Driver
#db.driver = ${default.db.driver}
db.driver = org.postgresql.Driver
# Database username and password
#db.username = ${default.db.username}
#db.password = ${default.db.password}
db.username = postgres
db.password = zsx
# Schema name - if your database contains multiple schemas, you can
avoid problems with
# retrieving the definitions of duplicate object names by specifying
# the schema name here that is used for DSpace by uncommenting the
following entry
db.schema = dspace
# Connection pool parameters
# Maximum number of DB connections in pool
db.maxconnections = 30
# Maximum time to wait before giving up if all connections in pool are
busy (milliseconds)
db.maxwait = 5000
# Maximum number of idle connections in pool (-1 = unlimited)
db.maxidle = -1
# Determine if prepared statement should be cached. (default is true)
db.statementpool = true
# Specify a name for the connection pool (useful if you have multiple
applications sharing Tomcat's dbcp)
# If not specified, defaults to 'dspacepool'
# db.poolname = dspacepool
##### Email settings ######
# SMTP mail server
mail.server=smtp.myu.edu
# SMTP mail server authentication username and password (if required)
# mail.server.username = myusername
# mail.server.password = mypassword
# SMTP mail server alternate port (defaults to 25)
# mail.server.port = 25
# From address for mail
mail.from.address = dspace-...@myu.edu
# Currently limited to one recipient!
feedback.recipient = dspac...@myu.edu
# General site administration (Webmaster) e-mail
mail.admin = dspac...@myu.edu
# Recipient for server errors and alerts
# alert.recipient = email-address-here
# Recipient for new user registration emails
# registration.notify = email-address-here
# Set the default mail character set. This may be over ridden by
providing a line
# inside the email template "charset: <encoding>", otherwise this
default is used.
#mail.charset = UTF-8
# A comma separated list of hostnames that are allowed to refer
browsers to email forms.
# Default behaviour is to accept referrals only from dspace.hostname
#mail.allowed.referrers = localhost
# Pass extra settings to the Java mail library. Comma separated,
equals sign between
# the key and the value.
#mail.extraproperties = mail.smtp.socketFactory.port=465, \
#
mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory, \
# mail.smtp.socketFactory.fallback=false
# An option is added to disable the mailserver. By default, this
property is set to false
# By setting mail.server.disabled = true, DSpace will not send out emails.
# It will instead log the subject of the email which should have been sent
# This is especially useful for development and test environments
where production data is used when testing functionality.
#mail.server.disabled = false
# Default language for metadata values
default.language = en_US
[...]
---------------------------------------------------------------------------------------------------------------------------
maven build: at the beginning i have many WARNING but afterworlds it
downloads many packages...
mvn clean package
[INFO] Scanning for projects...
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:xmlui:war:1.7.0
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-compiler-plugin is missing. @
org.dspace:dspace-pom:8, line 41, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-surefire-plugin is missing. @
org.dspace:dspace-parent:1.7.0, line 36, column 18
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing. @
org.dspace:dspace-pom:8, line 93, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-jar-plugin is missing. @
org.dspace:dspace-pom:8, line 48, column 21
[WARNING] The expression ${artifactId} is deprecated. Please use
${project.artifactId} instead.
[WARNING] The expression ${version} is deprecated. Please use
${project.version} instead.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-checkstyle-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:cobertura-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-javadoc-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:jxr-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-jxr-plugin is missing.
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:lni:war:1.7.0
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-compiler-plugin is missing. @
org.dspace:dspace-pom:8, line 41, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-surefire-plugin is missing. @
org.dspace:dspace-parent:1.7.0, line 36, column 18
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing. @
org.dspace:dspace-pom:8, line 93, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-jar-plugin is missing. @
org.dspace:dspace-pom:8, line 48, column 21
[WARNING] The expression ${artifactId} is deprecated. Please use
${project.artifactId} instead.
[WARNING] The expression ${version} is deprecated. Please use
${project.version} instead.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-checkstyle-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:cobertura-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-javadoc-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:jxr-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-jxr-plugin is missing.
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:oai:war:1.7.0
[....]
[INFO] Expanding:
/home/user/Desktop/dspace-1.7.0-src-release/dspace/modules/jspui/target/jspui-1.7.0.war
into /tmp/archived-file-set.1453223868.tmp
[INFO] Expanding:
/home/user/Desktop/dspace-1.7.0-src-release/dspace/modules/lni/target/lni-1.7.0.war
into /tmp/archived-file-set.1450994982.tmp
[WARNING] NOTE: Currently, inclusion of module dependencies may
produce unpredictable results if a version conflict occurs.
[INFO] Initializing assembly filters...
[INFO] Copying 1394 files to
/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] DSpace Kernel :: API and Implementation ........... SUCCESS [22.697s]
[INFO] DSpace XML-UI (Manakin) ........................... SUCCESS [0.109s]
[INFO] DSpace XML-UI (Manakin) :: Wing-Framework ......... SUCCESS [7.761s]
[INFO] DSpace Solr Statistics Logging Client Library ..... SUCCESS [2.637s]
[INFO] DSpace XML-UI (Manakin) :: API and Core Aspects ... SUCCESS [12.107s]
[INFO] DSpace XML-UI (Manakin) :: Web Application Resources SUCCESS [25.382s]
[INFO] DSpace Discovery :: Modules ....................... SUCCESS [0.415s]
[INFO] DSpace Discovery :: Discovery Provider Library .... SUCCESS [3.011s]
[INFO] DSpace Discovery :: Discovery XMLUI API ........... SUCCESS [3.306s]
[INFO] DSpace Discovery :: Discovery XMLUI Webapp ........ SUCCESS [10.507s]
[INFO] DSpace Addon Modules .............................. SUCCESS [0.082s]
[INFO] DSpace XML-UI (Manakin) :: Web Application ........ SUCCESS [32.498s]
[INFO] DSpace LNI ........................................ SUCCESS [0.361s]
[INFO] DSpace LNI :: Core Implementation ................. SUCCESS [5.461s]
[INFO] DSpace LNI :: Web Application Resources ........... SUCCESS [8.927s]
[INFO] DSpace LNI :: Web Application ..................... SUCCESS [16.392s]
[INFO] DSpace OAI ........................................ SUCCESS [0.291s]
[INFO] DSpace OAI :: API and Implementation .............. SUCCESS [3.537s]
[INFO] DSpace OAI :: Web Application Resources ........... SUCCESS [3.144s]
[INFO] DSpace OAI :: Web Application ..................... SUCCESS [7.281s]
[INFO] DSpace JSP-UI ..................................... SUCCESS [0.038s]
[INFO] DSpace JSP-UI :: API and Implementation ........... SUCCESS [5.483s]
[INFO] DSpace JSP-UI :: Web Application Resources ........ SUCCESS [3.887s]
[INFO] DSpace JSP-UI :: Web Application .................. SUCCESS [8.014s]
[INFO] DSpace SWORD ...................................... SUCCESS [0.058s]
[INFO] DSpace SWORD :: API and Implementation ............ SUCCESS [3.444s]
[INFO] DSpace SWORD :: Web Application Resources ......... SUCCESS [1.934s]
[INFO] DSpace SWORD :: Web Application ................... SUCCESS [5.720s]
[INFO] DSpace SOLR :: Web Application .................... SUCCESS [10.957s]
[INFO] DSpace LNI :: CLI Client Application .............. SUCCESS [9.871s]
[INFO] DSpace Assembly and Configuration ................. SUCCESS [1:51.074s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 5:27.412s
[INFO] Finished at: Fri Jan 14 12:23:08 EST 2011
[INFO] Final Memory: 39M/135M
[INFO] ------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------
ant fresh_install
dev:/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir#
ant fresh_install
Buildfile: /home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml
init_installation:
init_configs:
test_database:
[java] 2011-01-14 11:38:24,832 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:24,838 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java]
[java] Attempting to connect to database:
[java] - URL: jdbc:postgresql://localhost:5433/dspace
[java] - Driver: org.postgresql.Driver
[java] - Username: postgres
[java] - Password: zsx
[java] - Schema: dspace
[java]
[java] Testing connection...
[java] Connected successfully!
[java]
setup_database:
[java] 2011-01-14 11:38:25,861 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:25,870 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] 2011-01-14 11:38:25,870 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2011-01-14 11:38:27,317 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:27,323 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] Started: 1295023107309
[java] Ended: 1295023107586
[java] Elapsed time: 0 secs (277 msecs)
load_registries:
[java] 2011-01-14 11:38:28,425 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:28,433 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] Error:
[java] - ERROR: syntax error at or near ")"
[java] 2011-01-14 11:38:28,984 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] org.postgresql.util.PSQLException: ERROR: syntax error at
or near ")"
[java] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
BUILD FAILED
/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
Java returned: 1
Total time: 5 seconds
---------------------------------------------------------------------------------------------------------------------------
Postgres logs: there are many errors before the fatal one:
STATEMENT: INSERT INTO bitstreamformatregistry ( ) VALUES ( ) RETURNING null
as you can see it seems an empty statement...
DEBUG: autovacuum: processing database "template1"
LOG: connection received: host=127.0.0.1 port=45063
LOG: connection authorized: user=postgres database=dspace
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.132 user=postgres
database=dspace host=127.0.0.1 port=45063
LOG: connection received: host=127.0.0.1 port=45065
LOG: connection authorized: user=postgres database=dspace
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bitstreamformatregistry_pkey" for table "bitstreamformatregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"bitstreamformatregistry_short_description_key" for table
"bitstreamformatregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"fileextension_pkey" for table "fileextension"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bitstream_pkey" for table "bitstream"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"eperson_pkey" for table "eperson"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"eperson_email_key" for table "eperson"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup_pkey" for table "epersongroup"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"epersongroup_name_key" for table "epersongroup"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"group2group_pkey" for table "group2group"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"group2groupcache_pkey" for table "group2groupcache"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"item_pkey" for table "item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bundle_pkey" for table "bundle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"item2bundle_pkey" for table "item2bundle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bundle2bitstream_pkey" for table "bundle2bitstream"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadataschemaregistry_pkey" for table "metadataschemaregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"metadataschemaregistry_namespace_key" for table
"metadataschemaregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"metadataschemaregistry_short_id_key" for table
"metadataschemaregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadatafieldregistry_pkey" for table "metadatafieldregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadatavalue_pkey" for table "metadatavalue"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community_pkey" for table "community"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection_pkey" for table "collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community2community_pkey" for table "community2community"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community2collection_pkey" for table "community2collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection2item_pkey" for table "collection2item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"resourcepolicy_pkey" for table "resourcepolicy"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup2eperson_pkey" for table "epersongroup2eperson"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"handle_pkey" for table "handle"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"handle_handle_key" for table "handle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"workspaceitem_pkey" for table "workspaceitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"workflowitem_pkey" for table "workflowitem"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"workflowitem_item_id_key" for table "workflowitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"tasklistitem_pkey" for table "tasklistitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"registrationdata_pkey" for table "registrationdata"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"registrationdata_email_key" for table "registrationdata"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"subscription_pkey" for table "subscription"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup2item_pkey" for table "epersongroup2workspaceitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"communities2item_pkey" for table "communities2item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection_item_count_pkey" for table "collection_item_count"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community_item_count_pkey" for table "community_item_count"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checksum_results_pkey" for table "checksum_results"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"most_recent_checksum_pkey" for table "most_recent_checksum"
NOTICE: CREATE TABLE will create implicit sequence
"checksum_history_check_id_seq" for serial column
"checksum_history.check_id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checksum_history_pkey" for table "checksum_history"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"harvested_collection_pkey" for table "harvested_collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"harvested_item_pkey" for table "harvested_item"
LOG: connection received: host=127.0.0.1 port=45066
LOG: connection authorized: user=postgres database=dspace
ERROR: relation "bi_1" does not exist at character 15
STATEMENT: SELECT * FROM bi_1 LIMIT 1
ERROR: relation "bi_1_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_1_dis LIMIT 1
ERROR: relation "bi_2" does not exist at character 15
STATEMENT: SELECT * FROM bi_2 LIMIT 1
ERROR: relation "bi_2_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_2_dis LIMIT 1
ERROR: relation "bi_3" does not exist at character 15
STATEMENT: SELECT * FROM bi_3 LIMIT 1
ERROR: relation "bi_3_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_3_dis LIMIT 1
ERROR: relation "bi_4" does not exist at character 15
STATEMENT: SELECT * FROM bi_4 LIMIT 1
ERROR: relation "bi_4_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_4_dis LIMIT 1
ERROR: relation "bi_5" does not exist at character 15
STATEMENT: SELECT * FROM bi_5 LIMIT 1
ERROR: relation "bi_5_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_5_dis LIMIT 1
ERROR: relation "bi_6" does not exist at character 15
STATEMENT: SELECT * FROM bi_6 LIMIT 1
ERROR: relation "bi_6_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_6_dis LIMIT 1
ERROR: relation "bi_7" does not exist at character 15
STATEMENT: SELECT * FROM bi_7 LIMIT 1
ERROR: relation "bi_7_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_7_dis LIMIT 1
ERROR: relation "bi_8" does not exist at character 15
STATEMENT: SELECT * FROM bi_8 LIMIT 1
ERROR: relation "bi_8_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_8_dis LIMIT 1
ERROR: relation "bi_9" does not exist at character 15
STATEMENT: SELECT * FROM bi_9 LIMIT 1
ERROR: relation "bi_9_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_9_dis LIMIT 1
ERROR: relation "bi_10" does not exist at character 15
STATEMENT: SELECT * FROM bi_10 LIMIT 1
ERROR: relation "bi_10_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_10_dis LIMIT 1
ERROR: relation "bi_item" does not exist at character 15
STATEMENT: SELECT * FROM bi_item LIMIT 1
ERROR: relation "bi_withdrawn" does not exist at character 15
STATEMENT: SELECT * FROM bi_withdrawn LIMIT 1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_item_pkey" for table "bi_item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_withdrawn_pkey" for table "bi_withdrawn"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dis_pkey" for table "bi_2_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dmap_pkey" for table "bi_2_dmap"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dis_pkey" for table "bi_4_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dmap_pkey" for table "bi_4_dmap"
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.112 user=postgres
database=dspace host=127.0.0.1 port=45066
LOG: disconnection: session time: 0:00:00.601 user=postgres
database=dspace host=127.0.0.1 port=45065
LOG: connection received: host=127.0.0.1 port=45068
LOG: connection authorized: user=postgres database=dspace
LOG: connection received: host=127.0.0.1 port=45069
LOG: connection authorized: user=postgres database=dspace
ERROR: relation "bi_1" does not exist at character 15
STATEMENT: SELECT * FROM bi_1 LIMIT 1
ERROR: relation "bi_1_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_1_dis LIMIT 1
ERROR: relation "bi_2" does not exist at character 15
STATEMENT: SELECT * FROM bi_2 LIMIT 1
NOTICE: drop cascades to constraint bi_2_dmap_distinct_id_fkey on
table bi_2_dmap
ERROR: relation "bi_3" does not exist at character 15
STATEMENT: SELECT * FROM bi_3 LIMIT 1
ERROR: relation "bi_3_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_3_dis LIMIT 1
ERROR: relation "bi_4" does not exist at character 15
STATEMENT: SELECT * FROM bi_4 LIMIT 1
NOTICE: drop cascades to constraint bi_4_dmap_distinct_id_fkey on
table bi_4_dmap
ERROR: relation "bi_5" does not exist at character 15
STATEMENT: SELECT * FROM bi_5 LIMIT 1
ERROR: relation "bi_5_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_5_dis LIMIT 1
ERROR: relation "bi_6" does not exist at character 15
STATEMENT: SELECT * FROM bi_6 LIMIT 1
ERROR: relation "bi_6_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_6_dis LIMIT 1
ERROR: relation "bi_7" does not exist at character 15
STATEMENT: SELECT * FROM bi_7 LIMIT 1
ERROR: relation "bi_7_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_7_dis LIMIT 1
ERROR: relation "bi_8" does not exist at character 15
STATEMENT: SELECT * FROM bi_8 LIMIT 1
ERROR: relation "bi_8_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_8_dis LIMIT 1
ERROR: relation "bi_9" does not exist at character 15
STATEMENT: SELECT * FROM bi_9 LIMIT 1
ERROR: relation "bi_9_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_9_dis LIMIT 1
ERROR: relation "bi_10" does not exist at character 15
STATEMENT: SELECT * FROM bi_10 LIMIT 1
ERROR: relation "bi_10_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_10_dis LIMIT 1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_item_pkey" for table "bi_item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_withdrawn_pkey" for table "bi_withdrawn"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dis_pkey" for table "bi_2_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dmap_pkey" for table "bi_2_dmap"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dis_pkey" for table "bi_4_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dmap_pkey" for table "bi_4_dmap"
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.159 user=postgres
database=dspace host=127.0.0.1 port=45069
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.246 user=postgres
database=dspace host=127.0.0.1 port=45068
LOG: connection received: host=127.0.0.1 port=45071
LOG: connection authorized: user=postgres database=dspace
LOG: connection received: host=127.0.0.1 port=45072
LOG: connection authorized: user=postgres database=dspace
ERROR: syntax error at or near ")" at character 39
STATEMENT: INSERT INTO bitstreamformatregistry ( ) VALUES ( ) RETURNING null
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.054 user=postgres
database=dspace host=127.0.0.1 port=45072
LOG: disconnection: session time: 0:00:00.513 user=postgres
database=dspace host=127.0.0.1 port=45071
Does anybody understand where the problem is located? i've tried to
install dspace on Mac and Debian, with the packages required compiled
from the sources but i gor the same problem...
thank you !
Kocisky
different version of software and configurations. It seems that some
queries fails because of non existent relations and/or an empty INSERT
statement in the bitstreamformatregistry table (which is correctly
installed).
I've attached the log of the maven build, the ant fresh_install, the
postgres database and the configuration.
---------------------------------------------------------------------------------------------------------------------------
The versions actually used are:
dspace 1.7.0
postgres 9.0.2
user@dev:~/Desktop/dspace-1.7.0-src-release/dspace$ mvn -version
Apache Maven 3.0.1 (r1038046; 2010-11-23 05:58:32-0500)
Java version: 1.6.0_22
Java home: /usr/lib/jvm/java-6-sun-1.6.0.22/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux" version: "2.6.26-2-686" arch: "i386" Family: "unix"
user@dev:~/Desktop/dspace-1.7.0-src-release/dspace$ ant -version
Apache Ant(TM) version 1.8.2 compiled on December 20 2010
---------------------------------------------------------------------------------------------------------------------------
dspace configuration
#
# DSpace Configuration
#
# NOTE: The DSpace Configuration File is separated into several sections:
# * General Configurations
# * JSPUI & XMLUI Configurations
# * JSPUI Specific Configurations
# * XMLUI Specific Configurations
# * OAI-PMH Specific Configurations
# * SWORD Specific Configurations
# * OAI Harvesting Configurations
# * SOLR Statistics Configurations
#
# Revision: $Revision: 5874 $
#
# Date: $Date: 2010-11-17 14:52:46 -0600 (Wed, 17 Nov 2010) $
#
#---------------------------------------------------------------#
#------------------GENERAL CONFIGURATIONS-----------------------#
#---------------------------------------------------------------#
# These configs are used by underlying DSpace API, and are #
# therefore applicable to all interfaces #
#---------------------------------------------------------------#
##### Basic information ######
# DSpace installation directory
dspace.dir = /usr/local/dspace
# DSpace host name - should match base URL. Do not include port number
dspace.hostname = localhost
# DSpace base host URL. Include port number etc.
dspace.baseUrl = http://localhost:8280/dspace
# DSpace base URL. Include port number etc., but NOT trailing slash
# Change to xmlui if you wish to use the xmlui as the default, or remove
# "/jspui" and set webapp of your choice as the "ROOT" webapp in
# the servlet engine.
dspace.url = ${dspace.baseUrl}/xmlui
# The base URL of the OAI webapp (do not include /request).
dspace.oai.url = ${dspace.baseUrl}/oai
# Name of the site
dspace.name = DSpace at TF
##### Database settings #####
# Database name ("oracle", or "postgres")
#db.name = ${default.db.name}
db.name = postgres
#db.name = oracle
# URL for connecting to database
#db.url = ${default.db.url}
db.url = jdbc:postgresql://localhost:5433/dspace
# JDBC Driver
#db.driver = ${default.db.driver}
db.driver = org.postgresql.Driver
# Database username and password
#db.username = ${default.db.username}
#db.password = ${default.db.password}
db.username = postgres
db.password = zsx
# Schema name - if your database contains multiple schemas, you can
avoid problems with
# retrieving the definitions of duplicate object names by specifying
# the schema name here that is used for DSpace by uncommenting the
following entry
db.schema = dspace
# Connection pool parameters
# Maximum number of DB connections in pool
db.maxconnections = 30
# Maximum time to wait before giving up if all connections in pool are
busy (milliseconds)
db.maxwait = 5000
# Maximum number of idle connections in pool (-1 = unlimited)
db.maxidle = -1
# Determine if prepared statement should be cached. (default is true)
db.statementpool = true
# Specify a name for the connection pool (useful if you have multiple
applications sharing Tomcat's dbcp)
# If not specified, defaults to 'dspacepool'
# db.poolname = dspacepool
##### Email settings ######
# SMTP mail server
mail.server=smtp.myu.edu
# SMTP mail server authentication username and password (if required)
# mail.server.username = myusername
# mail.server.password = mypassword
# SMTP mail server alternate port (defaults to 25)
# mail.server.port = 25
# From address for mail
mail.from.address = dspace-...@myu.edu
# Currently limited to one recipient!
feedback.recipient = dspac...@myu.edu
# General site administration (Webmaster) e-mail
mail.admin = dspac...@myu.edu
# Recipient for server errors and alerts
# alert.recipient = email-address-here
# Recipient for new user registration emails
# registration.notify = email-address-here
# Set the default mail character set. This may be over ridden by
providing a line
# inside the email template "charset: <encoding>", otherwise this
default is used.
#mail.charset = UTF-8
# A comma separated list of hostnames that are allowed to refer
browsers to email forms.
# Default behaviour is to accept referrals only from dspace.hostname
#mail.allowed.referrers = localhost
# Pass extra settings to the Java mail library. Comma separated,
equals sign between
# the key and the value.
#mail.extraproperties = mail.smtp.socketFactory.port=465, \
#
mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory, \
# mail.smtp.socketFactory.fallback=false
# An option is added to disable the mailserver. By default, this
property is set to false
# By setting mail.server.disabled = true, DSpace will not send out emails.
# It will instead log the subject of the email which should have been sent
# This is especially useful for development and test environments
where production data is used when testing functionality.
#mail.server.disabled = false
# Default language for metadata values
default.language = en_US
[...]
---------------------------------------------------------------------------------------------------------------------------
maven build: at the beginning i have many WARNING but afterworlds it
downloads many packages...
mvn clean package
[INFO] Scanning for projects...
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:xmlui:war:1.7.0
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-compiler-plugin is missing. @
org.dspace:dspace-pom:8, line 41, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-surefire-plugin is missing. @
org.dspace:dspace-parent:1.7.0, line 36, column 18
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing. @
org.dspace:dspace-pom:8, line 93, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-jar-plugin is missing. @
org.dspace:dspace-pom:8, line 48, column 21
[WARNING] The expression ${artifactId} is deprecated. Please use
${project.artifactId} instead.
[WARNING] The expression ${version} is deprecated. Please use
${project.version} instead.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-checkstyle-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:cobertura-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-javadoc-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:jxr-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-jxr-plugin is missing.
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:lni:war:1.7.0
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-compiler-plugin is missing. @
org.dspace:dspace-pom:8, line 41, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-surefire-plugin is missing. @
org.dspace:dspace-parent:1.7.0, line 36, column 18
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing. @
org.dspace:dspace-pom:8, line 93, column 21
[WARNING] 'build.plugins.plugin.version' for
org.apache.maven.plugins:maven-jar-plugin is missing. @
org.dspace:dspace-pom:8, line 48, column 21
[WARNING] The expression ${artifactId} is deprecated. Please use
${project.artifactId} instead.
[WARNING] The expression ${version} is deprecated. Please use
${project.version} instead.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-checkstyle-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:cobertura-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-javadoc-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.codehaus.mojo:jxr-maven-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-site-plugin is missing.
[WARNING] 'reporting.plugins.plugin.version' for
org.apache.maven.plugins:maven-jxr-plugin is missing.
[WARNING]
[WARNING] Some problems were encountered while building the effective
model for org.dspace.modules:oai:war:1.7.0
[....]
[INFO] Expanding:
/home/user/Desktop/dspace-1.7.0-src-release/dspace/modules/jspui/target/jspui-1.7.0.war
into /tmp/archived-file-set.1453223868.tmp
[INFO] Expanding:
/home/user/Desktop/dspace-1.7.0-src-release/dspace/modules/lni/target/lni-1.7.0.war
into /tmp/archived-file-set.1450994982.tmp
[WARNING] NOTE: Currently, inclusion of module dependencies may
produce unpredictable results if a version conflict occurs.
[INFO] Initializing assembly filters...
[INFO] Copying 1394 files to
/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] DSpace Kernel :: API and Implementation ........... SUCCESS [22.697s]
[INFO] DSpace XML-UI (Manakin) ........................... SUCCESS [0.109s]
[INFO] DSpace XML-UI (Manakin) :: Wing-Framework ......... SUCCESS [7.761s]
[INFO] DSpace Solr Statistics Logging Client Library ..... SUCCESS [2.637s]
[INFO] DSpace XML-UI (Manakin) :: API and Core Aspects ... SUCCESS [12.107s]
[INFO] DSpace XML-UI (Manakin) :: Web Application Resources SUCCESS [25.382s]
[INFO] DSpace Discovery :: Modules ....................... SUCCESS [0.415s]
[INFO] DSpace Discovery :: Discovery Provider Library .... SUCCESS [3.011s]
[INFO] DSpace Discovery :: Discovery XMLUI API ........... SUCCESS [3.306s]
[INFO] DSpace Discovery :: Discovery XMLUI Webapp ........ SUCCESS [10.507s]
[INFO] DSpace Addon Modules .............................. SUCCESS [0.082s]
[INFO] DSpace XML-UI (Manakin) :: Web Application ........ SUCCESS [32.498s]
[INFO] DSpace LNI ........................................ SUCCESS [0.361s]
[INFO] DSpace LNI :: Core Implementation ................. SUCCESS [5.461s]
[INFO] DSpace LNI :: Web Application Resources ........... SUCCESS [8.927s]
[INFO] DSpace LNI :: Web Application ..................... SUCCESS [16.392s]
[INFO] DSpace OAI ........................................ SUCCESS [0.291s]
[INFO] DSpace OAI :: API and Implementation .............. SUCCESS [3.537s]
[INFO] DSpace OAI :: Web Application Resources ........... SUCCESS [3.144s]
[INFO] DSpace OAI :: Web Application ..................... SUCCESS [7.281s]
[INFO] DSpace JSP-UI ..................................... SUCCESS [0.038s]
[INFO] DSpace JSP-UI :: API and Implementation ........... SUCCESS [5.483s]
[INFO] DSpace JSP-UI :: Web Application Resources ........ SUCCESS [3.887s]
[INFO] DSpace JSP-UI :: Web Application .................. SUCCESS [8.014s]
[INFO] DSpace SWORD ...................................... SUCCESS [0.058s]
[INFO] DSpace SWORD :: API and Implementation ............ SUCCESS [3.444s]
[INFO] DSpace SWORD :: Web Application Resources ......... SUCCESS [1.934s]
[INFO] DSpace SWORD :: Web Application ................... SUCCESS [5.720s]
[INFO] DSpace SOLR :: Web Application .................... SUCCESS [10.957s]
[INFO] DSpace LNI :: CLI Client Application .............. SUCCESS [9.871s]
[INFO] DSpace Assembly and Configuration ................. SUCCESS [1:51.074s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 5:27.412s
[INFO] Finished at: Fri Jan 14 12:23:08 EST 2011
[INFO] Final Memory: 39M/135M
[INFO] ------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------
ant fresh_install
dev:/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir#
ant fresh_install
Buildfile: /home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml
init_installation:
init_configs:
test_database:
[java] 2011-01-14 11:38:24,832 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:24,838 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java]
[java] Attempting to connect to database:
[java] - URL: jdbc:postgresql://localhost:5433/dspace
[java] - Driver: org.postgresql.Driver
[java] - Username: postgres
[java] - Password: zsx
[java] - Schema: dspace
[java]
[java] Testing connection...
[java] Connected successfully!
[java]
setup_database:
[java] 2011-01-14 11:38:25,861 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:25,870 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] 2011-01-14 11:38:25,870 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2011-01-14 11:38:27,317 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:27,323 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] Started: 1295023107309
[java] Ended: 1295023107586
[java] Elapsed time: 0 secs (277 msecs)
load_registries:
[java] 2011-01-14 11:38:28,425 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2011-01-14 11:38:28,433 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if unintended, check your dspace.cfg for
(log.init.config)
[java] Error:
[java] - ERROR: syntax error at or near ")"
[java] 2011-01-14 11:38:28,984 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] org.postgresql.util.PSQLException: ERROR: syntax error at
or near ")"
[java] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
[java] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
[java] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
[java] at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:451)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:403)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:172)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:138)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:75)
BUILD FAILED
/home/user/Desktop/dspace-1.7.0-src-release/dspace/target/dspace-1.7.0-build.dir/build.xml:809:
Java returned: 1
Total time: 5 seconds
---------------------------------------------------------------------------------------------------------------------------
Postgres logs: there are many errors before the fatal one:
STATEMENT: INSERT INTO bitstreamformatregistry ( ) VALUES ( ) RETURNING null
as you can see it seems an empty statement...
DEBUG: autovacuum: processing database "template1"
LOG: connection received: host=127.0.0.1 port=45063
LOG: connection authorized: user=postgres database=dspace
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.132 user=postgres
database=dspace host=127.0.0.1 port=45063
LOG: connection received: host=127.0.0.1 port=45065
LOG: connection authorized: user=postgres database=dspace
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bitstreamformatregistry_pkey" for table "bitstreamformatregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"bitstreamformatregistry_short_description_key" for table
"bitstreamformatregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"fileextension_pkey" for table "fileextension"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bitstream_pkey" for table "bitstream"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"eperson_pkey" for table "eperson"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"eperson_email_key" for table "eperson"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup_pkey" for table "epersongroup"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"epersongroup_name_key" for table "epersongroup"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"group2group_pkey" for table "group2group"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"group2groupcache_pkey" for table "group2groupcache"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"item_pkey" for table "item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bundle_pkey" for table "bundle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"item2bundle_pkey" for table "item2bundle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bundle2bitstream_pkey" for table "bundle2bitstream"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadataschemaregistry_pkey" for table "metadataschemaregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"metadataschemaregistry_namespace_key" for table
"metadataschemaregistry"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"metadataschemaregistry_short_id_key" for table
"metadataschemaregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadatafieldregistry_pkey" for table "metadatafieldregistry"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"metadatavalue_pkey" for table "metadatavalue"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community_pkey" for table "community"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection_pkey" for table "collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community2community_pkey" for table "community2community"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community2collection_pkey" for table "community2collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection2item_pkey" for table "collection2item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"resourcepolicy_pkey" for table "resourcepolicy"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup2eperson_pkey" for table "epersongroup2eperson"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"handle_pkey" for table "handle"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"handle_handle_key" for table "handle"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"workspaceitem_pkey" for table "workspaceitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"workflowitem_pkey" for table "workflowitem"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"workflowitem_item_id_key" for table "workflowitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"tasklistitem_pkey" for table "tasklistitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"registrationdata_pkey" for table "registrationdata"
NOTICE: CREATE TABLE / UNIQUE will create implicit index
"registrationdata_email_key" for table "registrationdata"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"subscription_pkey" for table "subscription"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"epersongroup2item_pkey" for table "epersongroup2workspaceitem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"communities2item_pkey" for table "communities2item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"collection_item_count_pkey" for table "collection_item_count"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"community_item_count_pkey" for table "community_item_count"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checksum_results_pkey" for table "checksum_results"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"most_recent_checksum_pkey" for table "most_recent_checksum"
NOTICE: CREATE TABLE will create implicit sequence
"checksum_history_check_id_seq" for serial column
"checksum_history.check_id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"checksum_history_pkey" for table "checksum_history"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"harvested_collection_pkey" for table "harvested_collection"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"harvested_item_pkey" for table "harvested_item"
LOG: connection received: host=127.0.0.1 port=45066
LOG: connection authorized: user=postgres database=dspace
ERROR: relation "bi_1" does not exist at character 15
STATEMENT: SELECT * FROM bi_1 LIMIT 1
ERROR: relation "bi_1_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_1_dis LIMIT 1
ERROR: relation "bi_2" does not exist at character 15
STATEMENT: SELECT * FROM bi_2 LIMIT 1
ERROR: relation "bi_2_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_2_dis LIMIT 1
ERROR: relation "bi_3" does not exist at character 15
STATEMENT: SELECT * FROM bi_3 LIMIT 1
ERROR: relation "bi_3_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_3_dis LIMIT 1
ERROR: relation "bi_4" does not exist at character 15
STATEMENT: SELECT * FROM bi_4 LIMIT 1
ERROR: relation "bi_4_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_4_dis LIMIT 1
ERROR: relation "bi_5" does not exist at character 15
STATEMENT: SELECT * FROM bi_5 LIMIT 1
ERROR: relation "bi_5_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_5_dis LIMIT 1
ERROR: relation "bi_6" does not exist at character 15
STATEMENT: SELECT * FROM bi_6 LIMIT 1
ERROR: relation "bi_6_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_6_dis LIMIT 1
ERROR: relation "bi_7" does not exist at character 15
STATEMENT: SELECT * FROM bi_7 LIMIT 1
ERROR: relation "bi_7_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_7_dis LIMIT 1
ERROR: relation "bi_8" does not exist at character 15
STATEMENT: SELECT * FROM bi_8 LIMIT 1
ERROR: relation "bi_8_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_8_dis LIMIT 1
ERROR: relation "bi_9" does not exist at character 15
STATEMENT: SELECT * FROM bi_9 LIMIT 1
ERROR: relation "bi_9_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_9_dis LIMIT 1
ERROR: relation "bi_10" does not exist at character 15
STATEMENT: SELECT * FROM bi_10 LIMIT 1
ERROR: relation "bi_10_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_10_dis LIMIT 1
ERROR: relation "bi_item" does not exist at character 15
STATEMENT: SELECT * FROM bi_item LIMIT 1
ERROR: relation "bi_withdrawn" does not exist at character 15
STATEMENT: SELECT * FROM bi_withdrawn LIMIT 1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_item_pkey" for table "bi_item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_withdrawn_pkey" for table "bi_withdrawn"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dis_pkey" for table "bi_2_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dmap_pkey" for table "bi_2_dmap"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dis_pkey" for table "bi_4_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dmap_pkey" for table "bi_4_dmap"
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.112 user=postgres
database=dspace host=127.0.0.1 port=45066
LOG: disconnection: session time: 0:00:00.601 user=postgres
database=dspace host=127.0.0.1 port=45065
LOG: connection received: host=127.0.0.1 port=45068
LOG: connection authorized: user=postgres database=dspace
LOG: connection received: host=127.0.0.1 port=45069
LOG: connection authorized: user=postgres database=dspace
ERROR: relation "bi_1" does not exist at character 15
STATEMENT: SELECT * FROM bi_1 LIMIT 1
ERROR: relation "bi_1_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_1_dis LIMIT 1
ERROR: relation "bi_2" does not exist at character 15
STATEMENT: SELECT * FROM bi_2 LIMIT 1
NOTICE: drop cascades to constraint bi_2_dmap_distinct_id_fkey on
table bi_2_dmap
ERROR: relation "bi_3" does not exist at character 15
STATEMENT: SELECT * FROM bi_3 LIMIT 1
ERROR: relation "bi_3_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_3_dis LIMIT 1
ERROR: relation "bi_4" does not exist at character 15
STATEMENT: SELECT * FROM bi_4 LIMIT 1
NOTICE: drop cascades to constraint bi_4_dmap_distinct_id_fkey on
table bi_4_dmap
ERROR: relation "bi_5" does not exist at character 15
STATEMENT: SELECT * FROM bi_5 LIMIT 1
ERROR: relation "bi_5_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_5_dis LIMIT 1
ERROR: relation "bi_6" does not exist at character 15
STATEMENT: SELECT * FROM bi_6 LIMIT 1
ERROR: relation "bi_6_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_6_dis LIMIT 1
ERROR: relation "bi_7" does not exist at character 15
STATEMENT: SELECT * FROM bi_7 LIMIT 1
ERROR: relation "bi_7_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_7_dis LIMIT 1
ERROR: relation "bi_8" does not exist at character 15
STATEMENT: SELECT * FROM bi_8 LIMIT 1
ERROR: relation "bi_8_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_8_dis LIMIT 1
ERROR: relation "bi_9" does not exist at character 15
STATEMENT: SELECT * FROM bi_9 LIMIT 1
ERROR: relation "bi_9_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_9_dis LIMIT 1
ERROR: relation "bi_10" does not exist at character 15
STATEMENT: SELECT * FROM bi_10 LIMIT 1
ERROR: relation "bi_10_dis" does not exist at character 15
STATEMENT: SELECT * FROM bi_10_dis LIMIT 1
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_item_pkey" for table "bi_item"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_withdrawn_pkey" for table "bi_withdrawn"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dis_pkey" for table "bi_2_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_2_dmap_pkey" for table "bi_2_dmap"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dis_pkey" for table "bi_4_dis"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"bi_4_dmap_pkey" for table "bi_4_dmap"
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.159 user=postgres
database=dspace host=127.0.0.1 port=45069
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.246 user=postgres
database=dspace host=127.0.0.1 port=45068
LOG: connection received: host=127.0.0.1 port=45071
LOG: connection authorized: user=postgres database=dspace
LOG: connection received: host=127.0.0.1 port=45072
LOG: connection authorized: user=postgres database=dspace
ERROR: syntax error at or near ")" at character 39
STATEMENT: INSERT INTO bitstreamformatregistry ( ) VALUES ( ) RETURNING null
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: disconnection: session time: 0:00:00.054 user=postgres
database=dspace host=127.0.0.1 port=45072
LOG: disconnection: session time: 0:00:00.513 user=postgres
database=dspace host=127.0.0.1 port=45071
Does anybody understand where the problem is located? i've tried to
install dspace on Mac and Debian, with the packages required compiled
from the sources but i gor the same problem...
thank you !
Kocisky
Reply all
Reply to author
Forward
0 new messages