Skip to content

Instantly share code, notes, and snippets.

@hardyoyo
Created November 21, 2016 21:57
Show Gist options
  • Save hardyoyo/b03ee24f21681b351286d34e9cda3cf7 to your computer and use it in GitHub Desktop.
Save hardyoyo/b03ee24f21681b351286d34e9cda3cf7 to your computer and use it in GitHub Desktop.
SQL syntax error on upgrade from 5.x to 6.x
2016-11-18 23:04:57,347 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.spidersfile:null
2016-11-18 23:04:57,347 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.server:http://localhost:8081/solr/statistics
2016-11-18 23:04:57,347 INFO org.dspace.statistics.SolrLoggerServiceImpl @ usage-statistics.dbfile:/usr/local/dspace/dspace/config/GeoLiteCity.dat
2016-11-18 23:04:57,371 INFO org.dspace.statistics.SolrLoggerServiceImpl @ useProxies=false
2016-11-18 23:04:57,556 INFO org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/usr/local/dspace/dspace/etc/postgres, classpath:org.dspace.storage.rdbms.sqlmigration.postgres, classpath:org.dspace.storage.rdbms.migration
2016-11-18 23:04:57,587 INFO org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2016-11-18 23:04:57,594 INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:postgresql://localhost:5432/ds5 (PostgreSQL 9.5)
2016-11-18 23:04:57,622 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Upgrading metadata table "public"."schema_version" to the Flyway 4.0 format ...
2016-11-18 23:04:57,695 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.1 to 1147897299 ...
2016-11-18 23:04:57,696 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.2 to 903973515 ...
2016-11-18 23:04:57,697 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.3 to -783235991 ...
2016-11-18 23:04:57,698 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.4 to -831219528 ...
2016-11-18 23:04:57,699 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.5 to -1234304544 ...
2016-11-18 23:04:57,699 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.6 to -495469766 ...
2016-11-18 23:04:57,700 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.7 to -589640641 ...
2016-11-18 23:04:57,701 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 1.8 to -171791117 ...
2016-11-18 23:04:57,701 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 3.0 to -1098885663 ...
2016-11-18 23:04:57,702 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 4.0 to 1191833374 ...
2016-11-18 23:04:57,703 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 5.0.2014.08.08 to -1208221648 ...
2016-11-18 23:04:57,703 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 5.0.2014.09.26 to 1509433410 ...
2016-11-18 23:04:57,704 INFO org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Updating checksum of 5.6.2016.08.23 to 410632858 ...
2016-11-18 23:04:57,705 INFO org.flywaydb.core.Flyway @ Metadata table schema_version successfully upgraded to the Flyway 4.0 format.
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations:
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.06 DS 2701 Dso Uuid Migration JDBC PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.03 DS-3024 SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.21 DS-2775 SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING
2016-11-18 23:04:57,719 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.08.23 DS-3097 SQL PENDING
2016-11-18 23:04:57,741 INFO org.flywaydb.core.internal.command.DbValidate @ Successfully validated 31 migrations (execution time 00:00.011s)
2016-11-18 23:04:57,762 INFO org.flywaydb.core.internal.command.DbMigrate @ Current version of schema "public": 5.6.2016.08.23
2016-11-18 23:04:57,763 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2015.03.06 - DS 2701 Dso Uuid Migration
2016-11-18 23:04:57,807 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate migration
2016-11-18 23:04:58,430 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2015.08.31 - DS 2701 Hibernate Workflow Migration
2016-11-18 23:04:58,452 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.01.03 - DS-3024
2016-11-18 23:04:58,469 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.01.26 - DS 2188 Remove DBMS Browse Tables
2016-11-18 23:04:58,491 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.02.25 - DS-3004-slow-searching-as-admin
2016-11-18 23:04:58,494 INFO org.flywaydb.core.internal.dbsupport.JdbcTemplate @ DB: column "name" of relation "epersongroup" does not exist, skipping
2016-11-18 23:04:58,504 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.04.01 - DS-1955 Increase embargo reason
2016-11-18 23:04:58,514 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.04.04 - DS-3086-OAI-Performance-fix
2016-11-18 23:04:58,532 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.04.14 - DS-3125-fix-bundle-bitstream-delete-rights
2016-11-18 23:04:58,548 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.05.10 - DS-3168-fix-requestitem item id column
2016-11-18 23:04:58,562 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.07.21 - DS-2775
2016-11-18 23:04:58,574 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.07.26 - DS-3277 fix handle assignment
2016-11-18 23:04:58,585 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 6.0.2016.08.23 - DS-3097
2016-11-18 23:04:58,596 INFO org.flywaydb.core.internal.command.DbMigrate @ Successfully applied 13 migrations to schema "public" (execution time 00:00.840s).
2016-11-18 23:04:58,606 INFO org.dspace.event.EventServiceImpl @ EventService dispatcher pool initialized
2016-11-18 23:04:58,692 INFO org.hibernate.annotations.common.Version @ HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
2016-11-18 23:04:58,696 INFO org.hibernate.Version @ HHH000412: Hibernate Core {4.2.21.Final}
2016-11-18 23:04:58,697 INFO org.hibernate.cfg.Environment @ HHH000206: hibernate.properties not found
2016-11-18 23:04:58,698 INFO org.hibernate.cfg.Environment @ HHH000021: Bytecode provider name : javassist
2016-11-18 23:04:58,715 INFO org.hibernate.cfg.Configuration @ HHH000044: Configuring from URL: file:/usr/local/dspace/dspace/config/hibernate.cfg.xml
2016-11-18 23:04:58,751 INFO org.hibernate.cfg.Configuration @ HHH000041: Configured SessionFactory: null
2016-11-18 23:04:58,886 INFO org.hibernate.dialect.Dialect @ HHH000400: Using dialect: org.dspace.storage.rdbms.hibernate.postgres.DSpacePostgreSQL82Dialect
2016-11-18 23:04:58,901 INFO org.hibernate.engine.jdbc.internal.LobCreatorBuilder @ HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2016-11-18 23:04:58,907 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [pg-uuid] overrides previous : org.hibernate.type.PostgresUUIDType@4e0eba7d
2016-11-18 23:04:58,907 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@28f58c94
2016-11-18 23:04:59,116 WARN org.hibernate.mapping.RootClass @ HHH000038: Composite-id class does not override equals(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:04:59,117 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:04:59,117 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.eperson.Group2GroupCache
2016-11-18 23:04:59,122 INFO org.hibernate.engine.transaction.internal.TransactionFactoryInitiator @ HHH000399: Using default transaction strategy (direct JDBC transactions)
2016-11-18 23:04:59,124 INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory @ HHH000397: Using ASTQueryTranslatorFactory
2016-11-18 23:04:59,149 WARN net.sf.ehcache.config.ConfigurationFactory @ No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/local/dspace/dspace/webapps/rest/WEB-INF/lib/ehcache-core-2.4.3.jar!/ehcache-failsafe.xml
2016-11-18 23:04:59,154 WARN net.sf.ehcache.CacheManager @ Creating a new instance of CacheManager using the diskStorePath "/usr/local/dspace/temp" which is already used by an existing CacheManager.
The source of the configuration was net.sf.ehcache.config.generator.ConfigurationSource$DefaultConfigurationSource@67a84e5.
The diskStore path for this CacheManager will be set to /usr/local/dspace/temp/ehcache_auto_created_1479510299154.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
2016-11-18 23:04:59,155 INFO org.hibernate.cache.spi.UpdateTimestampsCache @ HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2016-11-18 23:04:59,157 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2016-11-18 23:04:59,174 INFO org.hibernate.cache.internal.StandardQueryCache @ HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2016-11-18 23:04:59,174 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2016-11-18 23:04:59,195 INFO org.hibernate.validator.internal.util.Version @ HV000001: Hibernate Validator 5.1.2.Final
2016-11-18 23:04:59,543 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataSchema]; using defaults.
2016-11-18 23:04:59,554 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataField]; using defaults.
2016-11-18 23:04:59,679 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator
2016-11-18 23:04:59,679 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata
2016-11-18 23:04:59,688 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.doi
2016-11-18 23:04:59,688 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [dspace_object, resource_id, status, resource_type_id, doi_id, doi]
2016-11-18 23:04:59,692 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstream
2016-11-18 23:04:59,692 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [checksum_algorithm, size_bytes, bitstream_id, bitstream_format_id, uuid, checksum, store_number, internal_id, deleted, sequence_id]
2016-11-18 23:04:59,696 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstreamformatregistry
2016-11-18 23:04:59,696 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [mimetype, short_description, description, support_level, bitstream_format_id, internal]
2016-11-18 23:04:59,699 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle
2016-11-18 23:04:59,699 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [primary_bitstream_id, bundle_id, uuid]
2016-11-18 23:04:59,703 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle2bitstream
2016-11-18 23:04:59,703 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [bitstream_id, bundle_id, bitstream_order_legacy, bitstream_order]
2016-11-18 23:04:59,706 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_history
2016-11-18 23:04:59,707 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, bitstream_id, process_end_date, check_id, checksum_expected, checksum_calculated, process_start_date]
2016-11-18 23:04:59,710 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_results
2016-11-18 23:04:59,710 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result_code, result_description]
2016-11-18 23:04:59,714 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection
2016-11-18 23:04:59,714 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, workflow_step_1, workflow_step_2, admin, submitter, template_item_id, workflow_step_3, uuid, logo_bitstream_id]
2016-11-18 23:04:59,718 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection2item
2016-11-18 23:04:59,718 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, item_id]
2016-11-18 23:04:59,721 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community
2016-11-18 23:04:59,721 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [admin, uuid, community_id, logo_bitstream_id]
2016-11-18 23:04:59,724 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2collection
2016-11-18 23:04:59,724 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, community_id]
2016-11-18 23:04:59,727 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2community
2016-11-18 23:04:59,727 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [parent_comm_id, child_comm_id]
2016-11-18 23:04:59,730 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.dspaceobject
2016-11-18 23:04:59,730 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:04:59,734 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.eperson
2016-11-18 23:04:59,734 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [require_certificate, can_log_in, email, sub_frequency, digest_algorithm, netid, uuid, self_registered, password, last_active, eperson_id, salt]
2016-11-18 23:04:59,737 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup
2016-11-18 23:04:59,737 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [permanent, eperson_group_id, name, uuid]
2016-11-18 23:04:59,740 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2eperson
2016-11-18 23:04:59,740 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_group_id, eperson_id]
2016-11-18 23:04:59,743 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2workspaceitem
2016-11-18 23:04:59,743 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workspace_item_id, eperson_group_id]
2016-11-18 23:04:59,746 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.fileextension
2016-11-18 23:04:59,746 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [extension, bitstream_format_id, file_extension_id]
2016-11-18 23:04:59,749 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2group
2016-11-18 23:04:59,749 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:04:59,752 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2groupcache
2016-11-18 23:04:59,752 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:04:59,755 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.handle
2016-11-18 23:04:59,755 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [resource_id, handle, resource_legacy_id, resource_type_id, handle_id]
2016-11-18 23:04:59,758 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_collection
2016-11-18 23:04:59,758 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, harvest_message, harvest_start_time, oai_set_id, collection_id, harvest_status, oai_source, harvest_type, last_harvested, metadata_config_id]
2016-11-18 23:04:59,761 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_item
2016-11-18 23:04:59,761 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, oai_id, item_id, last_harvested]
2016-11-18 23:04:59,764 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item
2016-11-18 23:04:59,764 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [last_modified, submitter_id, withdrawn, owning_collection, item_id, uuid, in_archive, discoverable]
2016-11-18 23:04:59,767 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item2bundle
2016-11-18 23:04:59,767 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, bundle_id]
2016-11-18 23:04:59,770 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatafieldregistry
2016-11-18 23:04:59,770 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [element, metadata_schema_id, metadata_field_id, scope_note, qualifier]
2016-11-18 23:04:59,773 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadataschemaregistry
2016-11-18 23:04:59,773 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [metadata_schema_id, short_id, namespace]
2016-11-18 23:04:59,776 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatavalue
2016-11-18 23:04:59,776 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [authority, metadata_field_id, text_lang, text_value, metadata_value_id, confidence, place, dspace_object_id]
2016-11-18 23:04:59,779 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.most_recent_checksum
2016-11-18 23:04:59,779 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, checksum_algorithm, bitstream_id, to_be_processed, matched_prev_checksum, last_process_start_date, expected_checksum, last_process_end_date, current_checksum]
2016-11-18 23:04:59,782 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.registrationdata
2016-11-18 23:04:59,782 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [registrationdata_id, expires, token, email]
2016-11-18 23:04:59,785 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.requestitem
2016-11-18 23:04:59,785 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [expires, bitstream_id, request_name, token, item_id, request_date, requestitem_id, decision_date, allfiles, accept_request, request_message, request_email]
2016-11-18 23:04:59,788 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.resourcepolicy
2016-11-18 23:04:59,788 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [rpname, action_id, dspace_object, resource_id, end_date, resource_type_id, rpdescription, rptype, start_date, policy_id, eperson_id, epersongroup_id]
2016-11-18 23:04:59,790 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.site
2016-11-18 23:04:59,791 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:04:59,793 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.subscription
2016-11-18 23:04:59,793 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [subscription_id, collection_id, eperson_id]
2016-11-18 23:04:59,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.tasklistitem
2016-11-18 23:04:59,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workflow_id, eperson_id, tasklist_id]
2016-11-18 23:04:59,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionhistory
2016-11-18 23:04:59,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionhistory_id]
2016-11-18 23:04:59,801 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionitem
2016-11-18 23:04:59,802 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionitem_id, item_id, versionhistory_id, version_number, version_summary, version_date, eperson_id]
2016-11-18 23:04:59,804 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.webapp
2016-11-18 23:04:59,804 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [webapp_id, appname, started, isui, url]
2016-11-18 23:04:59,807 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workflowitem
2016-11-18 23:04:59,807 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, multiple_titles, item_id, owner, state, workflow_id, multiple_files, published_before]
2016-11-18 23:04:59,810 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workspaceitem
2016-11-18 23:04:59,810 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [stage_reached, workspace_item_id, collection_id, multiple_titles, item_id, page_reached, multiple_files, published_before]
2016-11-18 23:04:59,826 INFO org.dspace.storage.rdbms.DatabaseRegistryUpdater @ Updating Bitstream Format Registry based on /usr/local/dspace/dspace/config/registries/bitstream-formats.xml
2016-11-18 23:04:59,994 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:04:59,995 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: syntax error at or near "."
Position: 244
2016-11-18 23:04:59,995 ERROR org.dspace.storage.rdbms.DatabaseRegistryUpdater @ Error attempting to update Bitstream Format and/or Metadata Registries
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
at org.hibernate.loader.Loader.doQuery(Loader.java:906)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
at org.hibernate.loader.Loader.doList(Loader.java:2550)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
at org.hibernate.loader.Loader.list(Loader.java:2361)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1623)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
at org.dspace.core.AbstractHibernateDAO.list(AbstractHibernateDAO.java:122)
at org.dspace.core.AbstractHibernateDAO.singleResult(AbstractHibernateDAO.java:156)
at org.dspace.content.dao.impl.BitstreamFormatDAOImpl.findByMIMEType(BitstreamFormatDAOImpl.java:63)
at org.dspace.content.BitstreamFormatServiceImpl.findByMIMEType(BitstreamFormatServiceImpl.java:95)
at org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:184)
at org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:146)
at org.dspace.storage.rdbms.DatabaseRegistryUpdater.updateRegistries(DatabaseRegistryUpdater.java:68)
at org.dspace.storage.rdbms.DatabaseRegistryUpdater.afterMigrate(DatabaseRegistryUpdater.java:121)
at org.flywaydb.core.internal.command.DbMigrate$3.doInTransaction(DbMigrate.java:250)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:246)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:655)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:574)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:550)
at org.dspace.core.Context.<clinit>(Context.java:94)
at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:74)
at org.dspace.app.util.DSpaceWebappListener.contextInitialized(DSpaceWebappListener.java:31)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
Position: 244
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
... 46 more
2016-11-18 23:05:05,865 INFO org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/usr/local/dspace/dspace/etc/postgres, classpath:org.dspace.storage.rdbms.sqlmigration.postgres, classpath:org.dspace.storage.rdbms.migration
2016-11-18 23:05:05,879 INFO org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2016-11-18 23:05:05,886 INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:postgresql://localhost:5432/ds5 (PostgreSQL 9.5)
2016-11-18 23:05:05,941 INFO org.dspace.storage.rdbms.DatabaseUtils @ DSpace database schema is up to date
2016-11-18 23:05:05,950 INFO org.dspace.event.EventServiceImpl @ EventService dispatcher pool initialized
2016-11-18 23:05:06,041 INFO org.hibernate.annotations.common.Version @ HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
2016-11-18 23:05:06,045 INFO org.hibernate.Version @ HHH000412: Hibernate Core {4.2.21.Final}
2016-11-18 23:05:06,047 INFO org.hibernate.cfg.Environment @ HHH000206: hibernate.properties not found
2016-11-18 23:05:06,048 INFO org.hibernate.cfg.Environment @ HHH000021: Bytecode provider name : javassist
2016-11-18 23:05:06,065 INFO org.hibernate.cfg.Configuration @ HHH000044: Configuring from URL: file:/usr/local/dspace/dspace/config/hibernate.cfg.xml
2016-11-18 23:05:06,103 INFO org.hibernate.cfg.Configuration @ HHH000041: Configured SessionFactory: null
2016-11-18 23:05:06,228 INFO org.hibernate.dialect.Dialect @ HHH000400: Using dialect: org.dspace.storage.rdbms.hibernate.postgres.DSpacePostgreSQL82Dialect
2016-11-18 23:05:06,237 INFO org.hibernate.engine.jdbc.internal.LobCreatorBuilder @ HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2016-11-18 23:05:06,241 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [pg-uuid] overrides previous : org.hibernate.type.PostgresUUIDType@d4e33ab
2016-11-18 23:05:06,241 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@9222660
2016-11-18 23:05:06,402 WARN org.hibernate.mapping.RootClass @ HHH000038: Composite-id class does not override equals(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:05:06,402 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:05:06,403 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.eperson.Group2GroupCache
2016-11-18 23:05:06,407 INFO org.hibernate.engine.transaction.internal.TransactionFactoryInitiator @ HHH000399: Using default transaction strategy (direct JDBC transactions)
2016-11-18 23:05:06,409 INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory @ HHH000397: Using ASTQueryTranslatorFactory
2016-11-18 23:05:06,436 WARN net.sf.ehcache.config.ConfigurationFactory @ No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/local/dspace/dspace/webapps/oai/WEB-INF/lib/ehcache-core-2.4.3.jar!/ehcache-failsafe.xml
2016-11-18 23:05:06,441 WARN net.sf.ehcache.CacheManager @ Creating a new instance of CacheManager using the diskStorePath "/usr/local/dspace/temp" which is already used by an existing CacheManager.
The source of the configuration was net.sf.ehcache.config.generator.ConfigurationSource$DefaultConfigurationSource@73d0c296.
The diskStore path for this CacheManager will be set to /usr/local/dspace/temp/ehcache_auto_created_1479510306441.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
2016-11-18 23:05:06,442 INFO org.hibernate.cache.spi.UpdateTimestampsCache @ HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2016-11-18 23:05:06,444 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2016-11-18 23:05:06,458 INFO org.hibernate.cache.internal.StandardQueryCache @ HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2016-11-18 23:05:06,459 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2016-11-18 23:05:06,582 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataSchema]; using defaults.
2016-11-18 23:05:06,592 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataField]; using defaults.
2016-11-18 23:05:06,708 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator
2016-11-18 23:05:06,708 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata
2016-11-18 23:05:06,715 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.doi
2016-11-18 23:05:06,715 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [dspace_object, resource_id, status, resource_type_id, doi_id, doi]
2016-11-18 23:05:06,718 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstream
2016-11-18 23:05:06,719 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [checksum_algorithm, size_bytes, bitstream_id, bitstream_format_id, uuid, checksum, store_number, internal_id, deleted, sequence_id]
2016-11-18 23:05:06,722 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstreamformatregistry
2016-11-18 23:05:06,722 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [mimetype, short_description, description, support_level, bitstream_format_id, internal]
2016-11-18 23:05:06,725 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle
2016-11-18 23:05:06,725 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [primary_bitstream_id, bundle_id, uuid]
2016-11-18 23:05:06,728 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle2bitstream
2016-11-18 23:05:06,729 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [bitstream_id, bundle_id, bitstream_order_legacy, bitstream_order]
2016-11-18 23:05:06,732 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_history
2016-11-18 23:05:06,732 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, bitstream_id, process_end_date, check_id, checksum_expected, checksum_calculated, process_start_date]
2016-11-18 23:05:06,735 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_results
2016-11-18 23:05:06,735 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result_code, result_description]
2016-11-18 23:05:06,739 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection
2016-11-18 23:05:06,739 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, workflow_step_1, workflow_step_2, admin, submitter, template_item_id, workflow_step_3, uuid, logo_bitstream_id]
2016-11-18 23:05:06,742 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection2item
2016-11-18 23:05:06,742 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, item_id]
2016-11-18 23:05:06,745 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community
2016-11-18 23:05:06,745 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [admin, uuid, community_id, logo_bitstream_id]
2016-11-18 23:05:06,748 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2collection
2016-11-18 23:05:06,748 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, community_id]
2016-11-18 23:05:06,751 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2community
2016-11-18 23:05:06,751 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [parent_comm_id, child_comm_id]
2016-11-18 23:05:06,754 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.dspaceobject
2016-11-18 23:05:06,754 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:05:06,757 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.eperson
2016-11-18 23:05:06,757 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [require_certificate, can_log_in, email, sub_frequency, digest_algorithm, netid, uuid, self_registered, password, last_active, eperson_id, salt]
2016-11-18 23:05:06,760 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup
2016-11-18 23:05:06,760 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [permanent, eperson_group_id, name, uuid]
2016-11-18 23:05:06,763 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2eperson
2016-11-18 23:05:06,763 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_group_id, eperson_id]
2016-11-18 23:05:06,766 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2workspaceitem
2016-11-18 23:05:06,766 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workspace_item_id, eperson_group_id]
2016-11-18 23:05:06,769 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.fileextension
2016-11-18 23:05:06,769 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [extension, bitstream_format_id, file_extension_id]
2016-11-18 23:05:06,772 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2group
2016-11-18 23:05:06,772 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:05:06,775 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2groupcache
2016-11-18 23:05:06,775 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:05:06,777 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.handle
2016-11-18 23:05:06,777 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [resource_id, handle, resource_legacy_id, resource_type_id, handle_id]
2016-11-18 23:05:06,781 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_collection
2016-11-18 23:05:06,781 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, harvest_message, harvest_start_time, oai_set_id, collection_id, harvest_status, oai_source, harvest_type, last_harvested, metadata_config_id]
2016-11-18 23:05:06,784 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_item
2016-11-18 23:05:06,784 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, oai_id, item_id, last_harvested]
2016-11-18 23:05:06,786 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item
2016-11-18 23:05:06,787 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [last_modified, submitter_id, withdrawn, owning_collection, item_id, uuid, in_archive, discoverable]
2016-11-18 23:05:06,789 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item2bundle
2016-11-18 23:05:06,789 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, bundle_id]
2016-11-18 23:05:06,791 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatafieldregistry
2016-11-18 23:05:06,791 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [element, metadata_schema_id, metadata_field_id, scope_note, qualifier]
2016-11-18 23:05:06,794 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadataschemaregistry
2016-11-18 23:05:06,794 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [metadata_schema_id, short_id, namespace]
2016-11-18 23:05:06,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatavalue
2016-11-18 23:05:06,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [authority, metadata_field_id, text_lang, text_value, metadata_value_id, confidence, place, dspace_object_id]
2016-11-18 23:05:06,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.most_recent_checksum
2016-11-18 23:05:06,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, checksum_algorithm, bitstream_id, to_be_processed, matched_prev_checksum, last_process_start_date, expected_checksum, last_process_end_date, current_checksum]
2016-11-18 23:05:06,801 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.registrationdata
2016-11-18 23:05:06,801 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [registrationdata_id, expires, token, email]
2016-11-18 23:05:06,804 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.requestitem
2016-11-18 23:05:06,804 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [expires, bitstream_id, request_name, token, item_id, request_date, requestitem_id, decision_date, allfiles, accept_request, request_message, request_email]
2016-11-18 23:05:06,806 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.resourcepolicy
2016-11-18 23:05:06,806 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [rpname, action_id, dspace_object, resource_id, end_date, resource_type_id, rpdescription, rptype, start_date, policy_id, eperson_id, epersongroup_id]
2016-11-18 23:05:06,809 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.site
2016-11-18 23:05:06,809 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:05:06,811 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.subscription
2016-11-18 23:05:06,811 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [subscription_id, collection_id, eperson_id]
2016-11-18 23:05:06,813 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.tasklistitem
2016-11-18 23:05:06,814 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workflow_id, eperson_id, tasklist_id]
2016-11-18 23:05:06,816 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionhistory
2016-11-18 23:05:06,816 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionhistory_id]
2016-11-18 23:05:06,818 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionitem
2016-11-18 23:05:06,818 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionitem_id, item_id, versionhistory_id, version_number, version_summary, version_date, eperson_id]
2016-11-18 23:05:06,820 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.webapp
2016-11-18 23:05:06,821 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [webapp_id, appname, started, isui, url]
2016-11-18 23:05:06,823 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workflowitem
2016-11-18 23:05:06,823 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, multiple_titles, item_id, owner, state, workflow_id, multiple_files, published_before]
2016-11-18 23:05:06,826 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workspaceitem
2016-11-18 23:05:06,826 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [stage_reached, workspace_item_id, collection_id, multiple_titles, item_id, page_reached, multiple_files, published_before]
2016-11-18 23:05:06,920 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl @ HHH000010: On release of batch it still contained JDBC statements
2016-11-18 23:05:06,920 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:06,920 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Batch entry 0 insert into .webapp (appname, isui, started, url, webapp_id) values (NULL, NULL, NULL, NULL, 58) was aborted: ERROR: syntax error at or near "."
Position: 13 Call getNextException to see other errors in the batch.
2016-11-18 23:05:06,920 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:06,920 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: syntax error at or near "."
Position: 13
2016-11-18 23:05:06,920 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch @ HHH000315: Exception executing batch [could not execute batch]
2016-11-18 23:05:06,962 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.spidersfile:null
2016-11-18 23:05:06,962 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.server:http://localhost:8081/solr/statistics
2016-11-18 23:05:06,963 INFO org.dspace.statistics.SolrLoggerServiceImpl @ usage-statistics.dbfile:/usr/local/dspace/dspace/config/GeoLiteCity.dat
2016-11-18 23:05:06,983 INFO org.dspace.statistics.SolrLoggerServiceImpl @ useProxies=false
2016-11-18 23:05:07,010 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl @ HHH000010: On release of batch it still contained JDBC statements
2016-11-18 23:05:07,010 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:07,010 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Batch entry 0 delete from .webapp where webapp_id=58 was aborted: ERROR: syntax error at or near "."
Position: 13 Call getNextException to see other errors in the batch.
2016-11-18 23:05:07,010 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:07,010 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: syntax error at or near "."
Position: 13
2016-11-18 23:05:07,011 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch @ HHH000315: Exception executing batch [could not execute batch]
2016-11-18 23:05:13,054 INFO org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/usr/local/dspace/dspace/etc/postgres, classpath:org.dspace.storage.rdbms.sqlmigration.postgres, classpath:org.dspace.storage.rdbms.migration
2016-11-18 23:05:13,068 INFO org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2016-11-18 23:05:13,075 INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:postgresql://localhost:5432/ds5 (PostgreSQL 9.5)
2016-11-18 23:05:13,125 INFO org.dspace.storage.rdbms.DatabaseUtils @ DSpace database schema is up to date
2016-11-18 23:05:13,139 INFO org.dspace.event.EventServiceImpl @ EventService dispatcher pool initialized
2016-11-18 23:05:13,228 INFO org.hibernate.annotations.common.Version @ HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
2016-11-18 23:05:13,232 INFO org.hibernate.Version @ HHH000412: Hibernate Core {4.2.21.Final}
2016-11-18 23:05:13,233 INFO org.hibernate.cfg.Environment @ HHH000206: hibernate.properties not found
2016-11-18 23:05:13,234 INFO org.hibernate.cfg.Environment @ HHH000021: Bytecode provider name : javassist
2016-11-18 23:05:13,250 INFO org.hibernate.cfg.Configuration @ HHH000044: Configuring from URL: file:/usr/local/dspace/dspace/config/hibernate.cfg.xml
2016-11-18 23:05:13,294 INFO org.hibernate.cfg.Configuration @ HHH000041: Configured SessionFactory: null
2016-11-18 23:05:13,407 INFO org.hibernate.dialect.Dialect @ HHH000400: Using dialect: org.dspace.storage.rdbms.hibernate.postgres.DSpacePostgreSQL82Dialect
2016-11-18 23:05:13,415 INFO org.hibernate.engine.jdbc.internal.LobCreatorBuilder @ HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2016-11-18 23:05:13,419 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [pg-uuid] overrides previous : org.hibernate.type.PostgresUUIDType@23e666a
2016-11-18 23:05:13,419 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@4eb5ba4c
2016-11-18 23:05:13,575 WARN org.hibernate.mapping.RootClass @ HHH000038: Composite-id class does not override equals(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:05:13,575 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.checker.MostRecentChecksum
2016-11-18 23:05:13,576 WARN org.hibernate.mapping.RootClass @ HHH000039: Composite-id class does not override hashCode(): org.dspace.eperson.Group2GroupCache
2016-11-18 23:05:13,580 INFO org.hibernate.engine.transaction.internal.TransactionFactoryInitiator @ HHH000399: Using default transaction strategy (direct JDBC transactions)
2016-11-18 23:05:13,582 INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory @ HHH000397: Using ASTQueryTranslatorFactory
2016-11-18 23:05:13,607 WARN net.sf.ehcache.config.ConfigurationFactory @ No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/local/dspace/dspace/webapps/jspui/WEB-INF/lib/ehcache-core-2.4.3.jar!/ehcache-failsafe.xml
2016-11-18 23:05:13,612 WARN net.sf.ehcache.CacheManager @ Creating a new instance of CacheManager using the diskStorePath "/usr/local/dspace/temp" which is already used by an existing CacheManager.
The source of the configuration was net.sf.ehcache.config.generator.ConfigurationSource$DefaultConfigurationSource@192aff1.
The diskStore path for this CacheManager will be set to /usr/local/dspace/temp/ehcache_auto_created_1479510313612.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
2016-11-18 23:05:13,613 INFO org.hibernate.cache.spi.UpdateTimestampsCache @ HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2016-11-18 23:05:13,615 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2016-11-18 23:05:13,630 INFO org.hibernate.cache.internal.StandardQueryCache @ HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2016-11-18 23:05:13,630 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2016-11-18 23:05:13,754 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataSchema]; using defaults.
2016-11-18 23:05:13,764 WARN org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataField]; using defaults.
2016-11-18 23:05:13,872 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator
2016-11-18 23:05:13,872 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata
2016-11-18 23:05:13,879 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.doi
2016-11-18 23:05:13,879 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [dspace_object, resource_id, status, resource_type_id, doi_id, doi]
2016-11-18 23:05:13,882 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstream
2016-11-18 23:05:13,882 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [checksum_algorithm, size_bytes, bitstream_id, bitstream_format_id, uuid, checksum, store_number, internal_id, deleted, sequence_id]
2016-11-18 23:05:13,885 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstreamformatregistry
2016-11-18 23:05:13,885 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [mimetype, short_description, description, support_level, bitstream_format_id, internal]
2016-11-18 23:05:13,889 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle
2016-11-18 23:05:13,889 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [primary_bitstream_id, bundle_id, uuid]
2016-11-18 23:05:13,892 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle2bitstream
2016-11-18 23:05:13,892 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [bitstream_id, bundle_id, bitstream_order_legacy, bitstream_order]
2016-11-18 23:05:13,895 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_history
2016-11-18 23:05:13,896 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, bitstream_id, process_end_date, check_id, checksum_expected, checksum_calculated, process_start_date]
2016-11-18 23:05:13,899 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_results
2016-11-18 23:05:13,899 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result_code, result_description]
2016-11-18 23:05:13,903 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection
2016-11-18 23:05:13,903 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, workflow_step_1, workflow_step_2, admin, submitter, template_item_id, workflow_step_3, uuid, logo_bitstream_id]
2016-11-18 23:05:13,906 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection2item
2016-11-18 23:05:13,906 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, item_id]
2016-11-18 23:05:13,909 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community
2016-11-18 23:05:13,909 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [admin, uuid, community_id, logo_bitstream_id]
2016-11-18 23:05:13,913 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2collection
2016-11-18 23:05:13,913 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, community_id]
2016-11-18 23:05:13,916 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2community
2016-11-18 23:05:13,916 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [parent_comm_id, child_comm_id]
2016-11-18 23:05:13,919 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.dspaceobject
2016-11-18 23:05:13,919 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:05:13,923 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.eperson
2016-11-18 23:05:13,923 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [require_certificate, can_log_in, email, sub_frequency, digest_algorithm, netid, uuid, self_registered, password, last_active, eperson_id, salt]
2016-11-18 23:05:13,926 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup
2016-11-18 23:05:13,926 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [permanent, eperson_group_id, name, uuid]
2016-11-18 23:05:13,930 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2eperson
2016-11-18 23:05:13,930 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_group_id, eperson_id]
2016-11-18 23:05:13,933 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2workspaceitem
2016-11-18 23:05:13,933 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workspace_item_id, eperson_group_id]
2016-11-18 23:05:13,935 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.fileextension
2016-11-18 23:05:13,935 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [extension, bitstream_format_id, file_extension_id]
2016-11-18 23:05:13,939 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2group
2016-11-18 23:05:13,939 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:05:13,942 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2groupcache
2016-11-18 23:05:13,942 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id]
2016-11-18 23:05:13,945 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.handle
2016-11-18 23:05:13,945 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [resource_id, handle, resource_legacy_id, resource_type_id, handle_id]
2016-11-18 23:05:13,948 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_collection
2016-11-18 23:05:13,948 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, harvest_message, harvest_start_time, oai_set_id, collection_id, harvest_status, oai_source, harvest_type, last_harvested, metadata_config_id]
2016-11-18 23:05:13,951 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_item
2016-11-18 23:05:13,951 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [id, oai_id, item_id, last_harvested]
2016-11-18 23:05:13,954 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item
2016-11-18 23:05:13,954 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [last_modified, submitter_id, withdrawn, owning_collection, item_id, uuid, in_archive, discoverable]
2016-11-18 23:05:13,957 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item2bundle
2016-11-18 23:05:13,957 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, bundle_id]
2016-11-18 23:05:13,960 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatafieldregistry
2016-11-18 23:05:13,960 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [element, metadata_schema_id, metadata_field_id, scope_note, qualifier]
2016-11-18 23:05:13,962 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadataschemaregistry
2016-11-18 23:05:13,962 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [metadata_schema_id, short_id, namespace]
2016-11-18 23:05:13,964 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatavalue
2016-11-18 23:05:13,964 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [authority, metadata_field_id, text_lang, text_value, metadata_value_id, confidence, place, dspace_object_id]
2016-11-18 23:05:13,967 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.most_recent_checksum
2016-11-18 23:05:13,967 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, checksum_algorithm, bitstream_id, to_be_processed, matched_prev_checksum, last_process_start_date, expected_checksum, last_process_end_date, current_checksum]
2016-11-18 23:05:13,969 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.registrationdata
2016-11-18 23:05:13,970 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [registrationdata_id, expires, token, email]
2016-11-18 23:05:13,972 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.requestitem
2016-11-18 23:05:13,972 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [expires, bitstream_id, request_name, token, item_id, request_date, requestitem_id, decision_date, allfiles, accept_request, request_message, request_email]
2016-11-18 23:05:13,975 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.resourcepolicy
2016-11-18 23:05:13,975 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [rpname, action_id, dspace_object, resource_id, end_date, resource_type_id, rpdescription, rptype, start_date, policy_id, eperson_id, epersongroup_id]
2016-11-18 23:05:13,977 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.site
2016-11-18 23:05:13,977 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid]
2016-11-18 23:05:13,979 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.subscription
2016-11-18 23:05:13,979 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [subscription_id, collection_id, eperson_id]
2016-11-18 23:05:13,982 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.tasklistitem
2016-11-18 23:05:13,982 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [workflow_id, eperson_id, tasklist_id]
2016-11-18 23:05:13,984 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionhistory
2016-11-18 23:05:13,984 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionhistory_id]
2016-11-18 23:05:13,987 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.versionitem
2016-11-18 23:05:13,987 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [versionitem_id, item_id, versionhistory_id, version_number, version_summary, version_date, eperson_id]
2016-11-18 23:05:13,989 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.webapp
2016-11-18 23:05:13,989 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [webapp_id, appname, started, isui, url]
2016-11-18 23:05:13,992 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workflowitem
2016-11-18 23:05:13,992 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, multiple_titles, item_id, owner, state, workflow_id, multiple_files, published_before]
2016-11-18 23:05:13,995 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.workspaceitem
2016-11-18 23:05:13,995 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [stage_reached, workspace_item_id, collection_id, multiple_titles, item_id, page_reached, multiple_files, published_before]
2016-11-18 23:05:14,084 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl @ HHH000010: On release of batch it still contained JDBC statements
2016-11-18 23:05:14,084 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:14,084 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Batch entry 0 insert into .webapp (appname, isui, started, url, webapp_id) values (NULL, NULL, NULL, NULL, 59) was aborted: ERROR: syntax error at or near "."
Position: 13 Call getNextException to see other errors in the batch.
2016-11-18 23:05:14,084 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:14,084 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: syntax error at or near "."
Position: 13
2016-11-18 23:05:14,084 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch @ HHH000315: Exception executing batch [could not execute batch]
2016-11-18 23:05:14,125 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.spidersfile:null
2016-11-18 23:05:14,125 INFO org.dspace.statistics.SolrLoggerServiceImpl @ solr-statistics.server:http://localhost:8081/solr/statistics
2016-11-18 23:05:14,125 INFO org.dspace.statistics.SolrLoggerServiceImpl @ usage-statistics.dbfile:/usr/local/dspace/dspace/config/GeoLiteCity.dat
2016-11-18 23:05:14,145 INFO org.dspace.statistics.SolrLoggerServiceImpl @ useProxies=false
2016-11-18 23:05:14,172 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl @ HHH000010: On release of batch it still contained JDBC statements
2016-11-18 23:05:14,172 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:14,172 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ Batch entry 0 delete from .webapp where webapp_id=59 was aborted: ERROR: syntax error at or near "."
Position: 13 Call getNextException to see other errors in the batch.
2016-11-18 23:05:14,172 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42601
2016-11-18 23:05:14,172 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: syntax error at or near "."
Position: 13
2016-11-18 23:05:14,172 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch @ HHH000315: Exception executing batch [could not execute batch]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment