Hi, Jose
Attached please find the dspace.log, I will take a look of the info you
sent.
appreciate for the help
--Elaine
On Thursday, August 31, 2023 at 11:54:52 AM UTC-4 Jose Blanco wrote:
> Elaine,
>
> Not sure. Have you tried the queries recommended here to see the
> results of the checker.
>
>
> https://wiki.lyrasis.org/display/DSDOC7x/Validating+CheckSums+of+Bitstreams#ValidatingCheckSumsofBitstreams-DatabaseQuery
>
> My only guess is that there is an item that is giving it trouble, if
> you could narrow it down, maybe you will see something.
>
> -Jose
>
> On Thu, Aug 31, 2023 at 11:39 AM Elaine Ding <dinge...@gmail.com> wrote:
> >
> > I don't see error in dspace.log , however there is some info in
> checker.log, Is that because the bitstream issue ?
> > Thanks
> >
> > checker.log ----
> >
> > Run start time: 08/30/2023 02:03:25
> > Run start time: 08/30/2023 02:04:01
> > Run start time: 08/30/2023 02:04:31
> > Run start time: 08/30/2023 02:05:57
> > Run start time: 08/30/2023 02:07:11
> > Run start time: 08/30/2023 02:13:16
> > Run start time: 08/30/2023 02:18:25
> > Run start time: 08/30/2023 02:19:11
> > ******************************************************
> > Bitstream ID: 0fee605a-91a9-49bc-b3be-ca784005ab43
> > Bitstream info found: false
> > Bitstream marked deleted: false
> > Bitstream found: true
> > To be processed: true
> > Internal Id: 9924273348884648871561730712958809106
> > Name: 00000000.tif
> > Store number: 0
> > Size: 11639014
> > Bitstream format: 14
> > User format description: null
> > Source: null
> > Checksum algorithm: MD5
> > Previous checksum: f062dea6d65cde6d752c25e439a4bf1e
> > Previous checksum date: 08/30/2023 02:19:11
> > New checksum: f062dea6d65cde6d752c25e439a4bf1e
> > Checksum comparison result: CHECKSUM_MATCH
> >
> > On Thursday, August 31, 2023 at 11:08:07 AM UTC-4 Jose Blanco wrote:
> >>
> >> Hi Elaine,
> >>
> >> Can you go to the dspace.log file and run it again, and see if the log
> >> file gives you any more information? It might point you to the line
> >> of code where this is happening, and maybe that will shed some light.
> >>
> >> Just from reading the error, it sounds like you have a table that
> >> returns 3 rows, but the code expects it to return just one row.
> >>
> >> -Jose
> >>
> >> On Thu, Aug 31, 2023 at 9:58 AM Elaine Ding <dinge...@gmail.com> wrote:
> >> >
> >> > I am using DSpace 7.6 . when I run "./bin/dspace checker -d2h" , it
> show errors like , have you ever see this ?
> >> >
> >> > Exception: org.hibernate.jdbc.BatchedTooManyRowsAffectedException:
> Batch update returned unexpected row count from update [0]; actual row
> count: 3; expected: 1
> >> >
> >> > any idea or suggestions ?
> >> >
> >> > Thanks
> >> > Elaine
> >> >
> >> > --
> >> > All messages to this mailing list should adhere to the Code of
> Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> >> > ---
> >> > 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...@googlegroups.com.
> >> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/98961616-f8d2-41be-aeb3-1185e61575cbn%40googlegroups.com
> .
> >
> > --
> > All messages to this mailing list should adhere to the Code of Conduct:
> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> > ---
> > 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...@googlegroups.com.
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/804a1c4a-9c62-401b-a967-7658d8ce520fn%40googlegroups.com
> .
>
--
All messages to this mailing list should adhere to the Code of Conduct:
https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
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/1d95ab2a-37e2-4ceb-b7d3-1ec6dc39bd92n%40googlegroups.com.
2023-08-31 12:10:39,496 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:39,598 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:39,603 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:39,605 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:39,606 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:39,609 INFO unknown unknown
org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when
creating PropertyDescriptor for public final void
org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)!
Ignoring this property.
2023-08-31 12:10:40,182 INFO unknown unknown org.ehcache.xml.XmlConfiguration
@ Loading Ehcache XML configuration from /opt/local/dspace/config/ehcache.xml.
2023-08-31 12:10:40,362 INFO unknown unknown
org.terracotta.offheapstore.paging.UpfrontAllocatingPageSource @ Allocating 4MB
in chunks
2023-08-31 12:10:40,369 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'sherpa.searchByJournalISSN' created in Eh107InternalCacheManager.
2023-08-31 12:10:40,371 INFO unknown unknown
org.terracotta.offheapstore.paging.UpfrontAllocatingPageSource @ Allocating
10.0MB in chunks
2023-08-31 12:10:40,372 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'manifests' created in Eh107InternalCacheManager.
2023-08-31 12:10:40,374 INFO unknown unknown
org.terracotta.offheapstore.paging.UpfrontAllocatingPageSource @ Allocating 4MB
in chunks
2023-08-31 12:10:40,375 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'canvasdimensions' created in Eh107InternalCacheManager.
2023-08-31 12:10:40,390 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=sherpa.searchByJournalISSN
2023-08-31 12:10:40,391 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=manifests
2023-08-31 12:10:40,391 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=canvasdimensions
2023-08-31 12:10:40,393 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=sherpa.searchByJournalISSN
2023-08-31 12:10:40,394 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=manifests
2023-08-31 12:10:40,394 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/ehcache.xml,Cache=canvasdimensions
2023-08-31 12:10:40,485 INFO unknown unknown org.eclipse.jetty.util.log @
Logging initialized @1491ms to org.eclipse.jetty.util.log.Slf4jLog
2023-08-31 12:10:40,747 INFO unknown unknown
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
@ Autowired annotation should only be used on methods with parameters: public
java.lang.String org.dspace.storage.bitstore.S3BitStoreService.getBucketName()
2023-08-31 12:10:40,924 INFO unknown unknown
org.dspace.importer.external.service.ImportService @ Loading 6 import sources.
2023-08-31 12:10:40,993 INFO unknown unknown
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
@ Autowired annotation is not supported on static methods: public static void
org.dspace.rdf.storage.DOIURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator)
2023-08-31 12:10:40,995 INFO unknown unknown
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor
@ Autowired annotation is not supported on static methods: public static void
org.dspace.rdf.storage.DOIHandleURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator)
2023-08-31 12:10:41,133 INFO unknown unknown
org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from:
classpath:org/dspace/storage/rdbms/sqlmigration/postgres,
classpath:org/dspace/storage/rdbms/migration,
classpath:org/dspace/storage/rdbms/xmlworkflow
2023-08-31 12:10:41,160 INFO unknown unknown
org.flywaydb.core.internal.license.VersionPrinter @ Flyway Community Edition
8.4.4 by Redgate
2023-08-31 12:10:41,161 INFO unknown unknown
org.flywaydb.core.internal.database.base.BaseDatabaseType @ Database:
jdbc:postgresql://localhost:5432/dspace (PostgreSQL 15.3)
2023-08-31 12:10:41,165 WARN unknown unknown
org.flywaydb.core.internal.database.base.Database @ Flyway upgrade recommended:
PostgreSQL 15.3 is newer than this version of Flyway and support has not been
tested. The latest supported version of PostgreSQL is 14.
2023-08-31 12:10:41,197 INFO unknown unknown
org.flywaydb.core.internal.license.VersionPrinter @ Flyway Community Edition
8.4.4 by Redgate
2023-08-31 12:10:41,199 WARN unknown unknown
org.flywaydb.core.internal.database.base.Database @ Flyway upgrade recommended:
PostgreSQL 15.3 is newer than this version of Flyway and support has not been
tested. The latest supported version of PostgreSQL is 14.
2023-08-31 12:10:41,211 INFO unknown unknown
org.dspace.storage.rdbms.DatabaseUtils @ DSpace database schema is up to date
2023-08-31 12:10:41,214 INFO unknown unknown org.dspace.event.EventServiceImpl
@ EventService dispatcher pool initialized
2023-08-31 12:10:41,233 INFO unknown unknown org.hibernate.Version @
HHH000412: Hibernate ORM core version 5.6.15.Final
2023-08-31 12:10:41,322 INFO unknown unknown
org.hibernate.annotations.common.Version @ HCANN000001: Hibernate Commons
Annotations {5.1.2.Final}
2023-08-31 12:10:41,352 INFO unknown unknown org.hibernate.dialect.Dialect @
HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL94Dialect
2023-08-31 12:10:41,416 WARN unknown unknown
org.hibernate.cfg.annotations.EntityBinder @ HHH000482:
@org.hibernate.annotations.Cache used on a non-root entity: ignored for
[org.dspace.content.Collection]. Please see the Hibernate documentation for
proper usage.
2023-08-31 12:10:41,417 WARN unknown unknown
org.hibernate.cfg.annotations.EntityBinder @ HHH000482:
@org.hibernate.annotations.Cache used on a non-root entity: ignored for
[org.dspace.content.Community]. Please see the Hibernate documentation for
proper usage.
2023-08-31 12:10:41,425 WARN unknown unknown
org.hibernate.cfg.annotations.EntityBinder @ HHH000482:
@org.hibernate.annotations.Cache used on a non-root entity: ignored for
[org.dspace.content.Site]. Please see the Hibernate documentation for proper
usage.
2023-08-31 12:10:41,426 WARN unknown unknown
org.hibernate.cfg.annotations.EntityBinder @ HHH000482:
@org.hibernate.annotations.Cache used on a non-root entity: ignored for
[org.dspace.eperson.EPerson]. Please see the Hibernate documentation for proper
usage.
2023-08-31 12:10:41,427 WARN unknown unknown
org.hibernate.cfg.annotations.EntityBinder @ HHH000482:
@org.hibernate.annotations.Cache used on a non-root entity: ignored for
[org.dspace.eperson.Group]. Please see the Hibernate documentation for proper
usage.
2023-08-31 12:10:41,478 INFO unknown unknown org.ehcache.xml.XmlConfiguration
@ Loading Ehcache XML configuration from
/opt/local/dspace/config/hibernate-ehcache-config.xml.
2023-08-31 12:10:41,534 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.MetadataSchema' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,534 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'default-query-results-region' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,535 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.MetadataField' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,536 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Site' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,536 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.eperson.EPerson' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,537 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Community' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,538 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'default-update-timestamps-region' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,538 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Collection' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,539 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.eperson.Group' created in Eh107InternalCacheManager.
2023-08-31 12:10:41,543 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.content.MetadataSchema
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.content.Community
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=default-query-results-region
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.content.MetadataField
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=default-update-timestamps-region
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.content.Collection
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.content.Site
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.eperson.EPerson
2023-08-31 12:10:41,544 INFO unknown unknown
org.ehcache.jsr107.Eh107CacheManager @ Registering Ehcache MBean
javax.cache:type=CacheStatistics,CacheManager=file./opt/local/dspace/config/hibernate-ehcache-config.xml,Cache=org.dspace.eperson.Group
2023-08-31 12:10:41,558 INFO unknown unknown
org.hibernate.validator.internal.util.Version @ HV000001: Hibernate Validator
6.2.5.Final
2023-08-31 12:10:41,667 WARN unknown unknown org.hibernate.orm.cache @
HHH90001006: Missing cache[org.dspace.alerts.SystemWideAlert] was created
on-the-fly. The created cache will use a provider-specific default
configuration: make sure you defined one. You can disable this warning by
setting 'hibernate.javax.cache.missing_cache_strategy' to 'create'.
2023-08-31 12:10:41,668 INFO unknown unknown
org.ehcache.jsr107.ConfigurationMerger @ Configuration of cache
org.dspace.alerts.SystemWideAlert will be supplemented by template default
2023-08-31 12:10:41,669 INFO unknown unknown
org.ehcache.jsr107.ConfigurationMerger @ Cache
org.dspace.alerts.SystemWideAlert will use expiry configuration from template
default
2023-08-31 12:10:41,671 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.alerts.SystemWideAlert' created in Eh107InternalCacheManager.
2023-08-31 12:10:42,208 INFO unknown unknown
org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl @ HHH000010: On
release of batch it still contained JDBC statements
2023-08-31 12:10:42,209 ERROR unknown unknown
org.hibernate.engine.jdbc.batch.internal.BatchingBatch @ HHH000315: Exception
executing batch [org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch
update returned unexpected row count from update [0]; actual row count: 3;
expected: 1], SQL: update public.most_recent_checksum set checksum_algorithm=?,
result=?, current_checksum=?, expected_checksum=?, matched_prev_checksum=?,
last_process_end_date=?, last_process_start_date=?, to_be_processed=? where
bitstream_id=?
2023-08-31 12:10:42,212 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.MetadataSchema' removed from
Eh107InternalCacheManager.
2023-08-31 12:10:42,212 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'default-query-results-region' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,212 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.MetadataField' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,212 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.alerts.SystemWideAlert' removed from
Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Community' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'default-update-timestamps-region' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Collection' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.content.Site' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.eperson.EPerson' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,213 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'org.dspace.eperson.Group' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,235 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'sherpa.searchByJournalISSN' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,235 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'manifests' removed from Eh107InternalCacheManager.
2023-08-31 12:10:42,236 INFO unknown unknown org.ehcache.core.EhcacheManager @
Cache 'canvasdimensions' removed from Eh107InternalCacheManager.
