Hello,
We are in the process of migrating from DSpace 6.0 to DSpace-CRIS 6RC2 and we have followed the instructions to Upgrade an existent DSpace (not CRIS) <https://wiki.lyrasis.org/display/DSPACECRIS/Installation#Installation-Upgra deanexistentDSpace(notCRIS)installation> . After successfully building the application and upgrading the database, we have the following error in dspace.log: FATAL org.dspace.core.Context @ Cannot obtain the bean which provides a database connection. Check previous entries in the dspace.log to find why the db failed to initialize. The schema validator returned: Wrong column type in public.subscription for column community_id. Found: int4, expected: uuid Please let me know if you have an idea what should be done to fix it. Below are the necessary details. Thank you, Liviu Petcu Centos 7 / Tomcat 8.5.37 / PostgreSQL 9.6.17 / DSpace 6.0 XMLUI Here is the last part of dspace.log 2020-09-07 15:58:37,715 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator 2020-09-07 15:58:37,715 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata 2020-09-07 15:58:37,719 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.doi 2020-09-07 15:58:37,719 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [dspace_object, resource_type_id, resource_id, doi_id, doi, status] 2020-09-07 15:58:37,723 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstream 2020-09-07 15:58:37,723 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [deleted, size_bytes, internal_id, checksum_algorithm, bitstream_id, checksum, store_number, sequence_id, bitstream_format_id, uuid] 2020-09-07 15:58:37,726 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstreamformatregistry 2020-09-07 15:58:37,726 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [short_description, internal, description, bitstream_format_id, mimetype, support_level] 2020-09-07 15:58:37,729 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle 2020-09-07 15:58:37,729 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [primary_bitstream_id, bundle_id, uuid] 2020-09-07 15:58:37,732 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle2bitstream 2020-09-07 15:58:37,732 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [bitstream_order, bitstream_order_legacy, bundle_id, bitstream_id] 2020-09-07 15:58:37,736 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_history 2020-09-07 15:58:37,736 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, process_start_date, process_end_date, bitstream_id, check_id, checksum_calculated, checksum_expected] 2020-09-07 15:58:37,739 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_results 2020-09-07 15:58:37,739 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result_description, result_code] 2020-09-07 15:58:37,742 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection 2020-09-07 15:58:37,743 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, submitter, logo_bitstream_id, workflow_step_3, admin, workflow_step_1, workflow_step_2, template_item_id, uuid] 2020-09-07 15:58:37,746 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection2item 2020-09-07 15:58:37,746 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, item_id] 2020-09-07 15:58:37,749 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community 2020-09-07 15:58:37,749 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [logo_bitstream_id, community_id, admin, uuid] 2020-09-07 15:58:37,752 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2collection 2020-09-07 15:58:37,752 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, community_id] 2020-09-07 15:58:37,755 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2community 2020-09-07 15:58:37,755 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [parent_comm_id, child_comm_id] 2020-09-07 15:58:37,758 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.dspaceobject 2020-09-07 15:58:37,758 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid] 2020-09-07 15:58:37,761 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.eperson 2020-09-07 15:58:37,761 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [sub_frequency, password, can_log_in, digest_algorithm, salt, eperson_id, netid, last_active, self_registered, uuid, email, require_certificate] 2020-09-07 15:58:37,765 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup 2020-09-07 15:58:37,765 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [permanent, name, eperson_group_id, uuid] 2020-09-07 15:58:37,768 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2eperson 2020-09-07 15:58:37,768 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_id, eperson_group_id] 2020-09-07 15:58:37,771 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2workspaceitem 2020-09-07 15:58:37,771 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_group_id, workspace_item_id] 2020-09-07 15:58:37,774 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.fileextension 2020-09-07 15:58:37,774 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [file_extension_id, extension, bitstream_format_id] 2020-09-07 15:58:37,777 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2group 2020-09-07 15:58:37,777 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id] 2020-09-07 15:58:37,780 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2groupcache 2020-09-07 15:58:37,780 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id] 2020-09-07 15:58:37,783 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.handle 2020-09-07 15:58:37,783 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [handle_id, resource_legacy_id, resource_type_id, resource_id, handle] 2020-09-07 15:58:37,786 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_collection 2020-09-07 15:58:37,787 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, oai_source, metadata_config_id, last_harvested, oai_set_id, harvest_type, harvest_status, id, harvest_message, harvest_start_time] 2020-09-07 15:58:37,790 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_item 2020-09-07 15:58:37,790 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [oai_id, last_harvested, item_id, id] 2020-09-07 15:58:37,793 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item 2020-09-07 15:58:37,793 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, discoverable, in_archive, withdrawn, submitter_id, last_modified, uuid, owning_collection] 2020-09-07 15:58:37,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item2bundle 2020-09-07 15:58:37,796 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, bundle_id] 2020-09-07 15:58:37,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatafieldregistry 2020-09-07 15:58:37,799 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [scope_note, metadata_schema_id, qualifier, metadata_field_id, element] 2020-09-07 15:58:37,802 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadataschemaregistry 2020-09-07 15:58:37,802 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [metadata_schema_id, namespace, short_id] 2020-09-07 15:58:37,806 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatavalue 2020-09-07 15:58:37,806 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [text_value, dspace_object_id, text_lang, authority, confidence, metadata_value_id, place, metadata_field_id] 2020-09-07 15:58:37,810 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.most_recent_checksum 2020-09-07 15:58:37,810 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [last_process_end_date, result, expected_checksum, matched_prev_checksum, to_be_processed, current_checksum, checksum_algorithm, bitstream_id, last_process_start_date] 2020-09-07 15:58:37,813 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.registrationdata 2020-09-07 15:58:37,813 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [registrationdata_id, expires, email, token] 2020-09-07 15:58:37,816 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.requestitem 2020-09-07 15:58:37,816 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [request_name, decision_date, expires, item_id, request_message, request_email, request_date, bitstream_id, allfiles, accept_request, requestitem_id, token] 2020-09-07 15:58:37,820 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.resourcepolicy 2020-09-07 15:58:37,820 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [end_date, dspace_object, rptype, resource_type_id, policy_id, eperson_id, action_id, epersongroup_id, rpdescription, resource_id, start_date, rpname] 2020-09-07 15:58:37,824 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.site 2020-09-07 15:58:37,824 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid] 2020-09-07 15:58:37,828 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.subscription 2020-09-07 15:58:37,828 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [subscription_id, collection_id, community_id, eperson_id] 2020-09-07 15:58:37,831 INFO org.hibernate.cfg.Configuration @ HHH000044: Configuring from URL: file:/dspace/config/hibernate.cfg.xml 2020-09-07 15:58:37,833 INFO org.hibernate.cfg.Configuration @ HHH000041: Configured SessionFactory: null 2020-09-07 15:58:37,838 INFO org.hibernate.dialect.Dialect @ HHH000400: Using dialect: org.dspace.storage.rdbms.hibernate.postgres.DSpacePostgreSQL82Dialect 2020-09-07 15:58:37,838 INFO org.hibernate.engine.jdbc.internal.LobCreatorBuilder @ HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException 2020-09-07 15:58:37,838 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [pg-uuid] overrides previous : org.hibernate.type.PostgresUUIDType@56ba8b09 2020-09-07 15:58:37,838 INFO org.hibernate.type.BasicTypeRegistry @ HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@2b56a660 2020-09-07 15:58:37,850 INFO org.hibernate.engine.transaction.internal.TransactionFactoryInitiator @ HHH000399: Using default transaction strategy (direct JDBC transactions) 2020-09-07 15:58:37,850 INFO org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory @ HHH000397: Using ASTQueryTranslatorFactory 2020-09-07 15:58:37,852 WARN net.sf.ehcache.CacheManager @ Creating a new instance of CacheManager using the diskStorePath "/tomcat/temp/DSpaceHibernateCache" which is already used by an existing CacheManager. The source of the configuration was net.sf.ehcache.config.generator.ConfigurationSource$URLConfigurationSource@5 957eab3. The diskStore path for this CacheManager will be set to /tomcat/temp/DSpaceHibernateCache/ehcache_auto_created_1599483517852. 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. 2020-09-07 15:58:37,855 INFO org.hibernate.cache.spi.UpdateTimestampsCache @ HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache 2020-09-07 15:58:37,855 INFO org.hibernate.cache.internal.StandardQueryCache @ HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache 2020-09-07 15:58:37,875 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator 2020-09-07 15:58:37,875 INFO org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata 2020-09-07 15:58:37,879 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.doi 2020-09-07 15:58:37,879 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [dspace_object, resource_type_id, resource_id, doi_id, doi, status] 2020-09-07 15:58:37,882 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstream 2020-09-07 15:58:37,882 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [deleted, size_bytes, internal_id, checksum_algorithm, bitstream_id, checksum, store_number, sequence_id, bitstream_format_id, uuid] 2020-09-07 15:58:37,885 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bitstreamformatregistry 2020-09-07 15:58:37,885 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [short_description, internal, description, bitstream_format_id, mimetype, support_level] 2020-09-07 15:58:37,888 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle 2020-09-07 15:58:37,888 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [primary_bitstream_id, bundle_id, uuid] 2020-09-07 15:58:37,891 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.bundle2bitstream 2020-09-07 15:58:37,891 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [bitstream_order, bitstream_order_legacy, bundle_id, bitstream_id] 2020-09-07 15:58:37,895 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_history 2020-09-07 15:58:37,895 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result, process_start_date, process_end_date, bitstream_id, check_id, checksum_calculated, checksum_expected] 2020-09-07 15:58:37,898 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.checksum_results 2020-09-07 15:58:37,898 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [result_description, result_code] 2020-09-07 15:58:37,901 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection 2020-09-07 15:58:37,901 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, submitter, logo_bitstream_id, workflow_step_3, admin, workflow_step_1, workflow_step_2, template_item_id, uuid] 2020-09-07 15:58:37,904 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.collection2item 2020-09-07 15:58:37,904 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, item_id] 2020-09-07 15:58:37,907 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community 2020-09-07 15:58:37,907 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [logo_bitstream_id, community_id, admin, uuid] 2020-09-07 15:58:37,910 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2collection 2020-09-07 15:58:37,910 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, community_id] 2020-09-07 15:58:37,913 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.community2community 2020-09-07 15:58:37,913 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [parent_comm_id, child_comm_id] 2020-09-07 15:58:37,916 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.dspaceobject 2020-09-07 15:58:37,916 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid] 2020-09-07 15:58:37,919 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.eperson 2020-09-07 15:58:37,919 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [sub_frequency, password, can_log_in, digest_algorithm, salt, eperson_id, netid, last_active, self_registered, uuid, email, require_certificate] 2020-09-07 15:58:37,922 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup 2020-09-07 15:58:37,922 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [permanent, name, eperson_group_id, uuid] 2020-09-07 15:58:37,925 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2eperson 2020-09-07 15:58:37,925 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_id, eperson_group_id] 2020-09-07 15:58:37,928 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.epersongroup2workspaceitem 2020-09-07 15:58:37,928 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [eperson_group_id, workspace_item_id] 2020-09-07 15:58:37,931 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.fileextension 2020-09-07 15:58:37,931 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [file_extension_id, extension, bitstream_format_id] 2020-09-07 15:58:37,934 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2group 2020-09-07 15:58:37,934 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id] 2020-09-07 15:58:37,937 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.group2groupcache 2020-09-07 15:58:37,937 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [child_id, parent_id] 2020-09-07 15:58:37,940 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.handle 2020-09-07 15:58:37,940 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [handle_id, resource_legacy_id, resource_type_id, resource_id, handle] 2020-09-07 15:58:37,943 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_collection 2020-09-07 15:58:37,944 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [collection_id, oai_source, metadata_config_id, last_harvested, oai_set_id, harvest_type, harvest_status, id, harvest_message, harvest_start_time] 2020-09-07 15:58:37,947 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.harvested_item 2020-09-07 15:58:37,947 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [oai_id, last_harvested, item_id, id] 2020-09-07 15:58:37,950 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item 2020-09-07 15:58:37,950 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, discoverable, in_archive, withdrawn, submitter_id, last_modified, uuid, owning_collection] 2020-09-07 15:58:37,953 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.item2bundle 2020-09-07 15:58:37,953 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [item_id, bundle_id] 2020-09-07 15:58:37,956 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatafieldregistry 2020-09-07 15:58:37,956 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [scope_note, metadata_schema_id, qualifier, metadata_field_id, element] 2020-09-07 15:58:37,960 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadataschemaregistry 2020-09-07 15:58:37,960 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [metadata_schema_id, namespace, short_id] 2020-09-07 15:58:37,963 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.metadatavalue 2020-09-07 15:58:37,963 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [text_value, dspace_object_id, text_lang, authority, confidence, metadata_value_id, place, metadata_field_id] 2020-09-07 15:58:37,966 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.most_recent_checksum 2020-09-07 15:58:37,966 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [last_process_end_date, result, expected_checksum, matched_prev_checksum, to_be_processed, current_checksum, checksum_algorithm, bitstream_id, last_process_start_date] 2020-09-07 15:58:37,969 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.registrationdata 2020-09-07 15:58:37,970 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [registrationdata_id, expires, email, token] 2020-09-07 15:58:37,973 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.requestitem 2020-09-07 15:58:37,973 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [request_name, decision_date, expires, item_id, request_message, request_email, request_date, bitstream_id, allfiles, accept_request, requestitem_id, token] 2020-09-07 15:58:37,976 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.resourcepolicy 2020-09-07 15:58:37,976 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [end_date, dspace_object, rptype, resource_type_id, policy_id, eperson_id, action_id, epersongroup_id, rpdescription, resource_id, start_date, rpname] 2020-09-07 15:58:37,979 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.site 2020-09-07 15:58:37,979 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [uuid] 2020-09-07 15:58:37,982 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000261: Table found: public.subscription 2020-09-07 15:58:37,982 INFO org.hibernate.tool.hbm2ddl.TableMetadata @ HHH000037: Columns: [subscription_id, collection_id, community_id, eperson_id] 2020-09-07 15:58:37,983 FATAL org.dspace.core.Context @ Cannot obtain the bean which provides a database connection. Check previous entries in the dspace.log to find why the db failed to initialize. The schema validator returned: Wrong column type in public.subscription for column community_id. Found: int4, expected: uuid And here is database info: ~ $ dspace/bin/dspace database info Database Type: postgres Database URL: jdbc:postgresql://localhost:5432/dspace Database Schema: public Database Username: dspace Database Software: PostgreSQL version 9.6.17 Database Driver: PostgreSQL JDBC Driver version 42.2.1 PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3) +----------------+-----------------------------------------------------+---- -----------------+---------+ | Version | Description | Installed on | State | +----------------+-----------------------------------------------------+---- -----------------+---------+ | 1 | << Flyway Baseline >> | 2019-04-22 13:09:19 | Baselin | | 1.1 | Initial DSpace 1.1 database schema | 2019-04-22 13:09:19 | Success | | 1.2 | Upgrade to DSpace 1.2 schema | 2019-04-22 13:09:19 | Success | | 1.3 | Upgrade to DSpace 1.3 schema | 2019-04-22 13:09:19 | Success | | 1.3.9 | Drop constraint for DSpace 1 4 schema | 2019-04-22 13:09:19 | Success | | 1.4 | Upgrade to DSpace 1.4 schema | 2019-04-22 13:09:19 | Success | | 1.5 | Upgrade to DSpace 1.5 schema | 2019-04-22 13:09:19 | Success | | 1.5.9 | Drop constraint for DSpace 1 6 schema | 2019-04-22 13:09:19 | Success | | 1.6 | Upgrade to DSpace 1.6 schema | 2019-04-22 13:09:19 | Success | | 1.7 | Upgrade to DSpace 1.7 schema | 2019-04-22 13:09:20 | Success | | 1.8 | Upgrade to DSpace 1.8 schema | 2019-04-22 13:09:20 | Success | | 1.8.2.2 | DSpaceCRIS-subscription database schema | | Ignored | | 3.0 | Upgrade to DSpace 3.x schema | 2019-04-22 13:09:20 | Success | | 3.2.1.0 | DSpaceCRIS-Upgrade-crismodule 182 to 321 | | Ignored | | 4.0 | Upgrade to DSpace 4.x schema | 2019-04-22 13:09:20 | Success | | 4.1.0.0 | DSpaceCRIS-Upgrade-crismodule 321 to 4 | | Ignored | | 4.3.0.0 | DSpaceCRIS-Upgrade-crismodule 4 to 43 | | Ignored | | 4.9.2015.10.26 | DS-2818 registry update | 2019-04-22 13:09:20 | Success | | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy | 2019-04-22 13:09:20 | Success | | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint | 2019-04-22 13:09:20 | Success | | 5.0.2014.09.26 | DS-1582 Metadata For All Objects | 2019-04-22 13:09:20 | Success | | 5.3.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.1 | FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.2 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.3 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.4 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.5 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.0.6 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.1.0 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.3.1.1 | DSpaceCRIS-Upgrade-crismodule 5 to 53 | | Ignored | | 5.4.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 54 | | Ignored | | 5.4.0.1 | DSpaceCRIS-Upgrade-crismodule 5 to 54 | | Ignored | | 5.5.0.1 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.5.1.0 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.5.1.1 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.5.1.2 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.5.1.3 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.5.1.4 | DSpaceCRIS-Upgrade-crismodule 5 to 55 | | Ignored | | 5.6.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 56 | | Ignored | | 5.6.0.1 | DSpaceCRIS-Upgrade-crismodule 5 to 56 | | Ignored | | 5.6.2016.08.23 | DS-3097 | 2019-04-22 13:09:20 | Success | | 5.7.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 57 | | Ignored | | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type id column | | Ignored | | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow | | Ignored | | 5.8.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 58 | | Ignored | | 5.8.0.1 | DSpaceCRIS-Upgrade-crismodule 5 to 58 | | Ignored | | 5.8.0.2 | DSpaceCRIS-Upgrade-crismodule 5 to 58 | | Ignored | | 5.8.0.3 | DSpaceCRIS-Upgrade-crismodule 5 to 58 | | Ignored | | 5.8.0.4 | DSpaceCRIS-Upgrade-crismodule 5 to 58 | | Ignored | | 5.8.0.5 | DSpaceCRIS-ImpBitstreamMetadata | | Ignored | | 5.9.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 59 | | Ignored | | 5.10.0.0 | DSpaceCRIS-Upgrade-crismodule 5 to 510 | | Ignored | | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration | 2019-04-22 13:09:20 | Success | | 6.0.2015.03.07 | DS-2701 Hibernate migration | 2019-04-22 13:09:20 | Success | | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration | 2019-04-22 13:09:20 | Success | | 6.0.2016.01.03 | DS-3024 | 2019-04-22 13:09:20 | Success | | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables | 2019-04-22 13:09:20 | Success | | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin | 2019-04-22 13:09:20 | Success | | 6.0.2016.04.01 | DS-1955 Increase embargo reason | 2019-04-22 13:09:20 | Success | | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix | 2019-04-22 13:09:20 | Success | | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights | 2019-04-22 13:09:20 | Success | | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column | 2019-04-22 13:09:20 | Success | | 6.0.2016.07.21 | DS-2775 | 2019-04-22 13:09:20 | Success | | 6.0.2016.07.26 | DS-3277 fix handle assignment | 2019-04-22 13:09:20 | Success | | 6.0.2016.08.23 | DS-3097 | 2019-04-22 13:09:20 | Success | | 1.8.2.0 | DSpaceCRIS-crismodule database schema | 2020-09-05 00:18:29 | OutOrdr | | 1.8.2.1 | DSpaceCRIS-crispubmed database schema | 2020-09-05 00:18:30 | OutOrdr | | 6.0.2017.05.04 | D4CRIS-2 | 2020-09-05 23:56:28 | Success | | 6.0.2017.06.15 | D4CRIS-2 | 2020-09-05 23:56:29 | Success | | 6.0.2017.06.16 | D4CRIS-2 | 2020-09-05 23:56:29 | Success | | 6.0.2017.06.26 | D4CRIS-2 | 2020-09-05 23:56:29 | Success | | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow | 2020-09-05 23:56:29 | Success | | 6.1.2017.07.25 | D4CRIS-2 | 2020-09-05 23:56:29 | Success | | 6.1.2017.08.09 | D4CRIS-2 | 2020-09-05 23:56:29 | Success | | 6.3.2019.05.27 | D4CRIS-745 | 2020-09-05 23:56:29 | Success | | 6.3.2020.04.16 | D4CRIS-910 | 2020-09-05 23:56:29 | Success | +----------------+-----------------------------------------------------+---- -----------------+---------+ -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/03b301d6851a%24742739e0%245c75ada0%24%40gmail.com.
