DSpace 7.6 checksum error

[Elaine Ding]

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

[Jose Blanco]

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

> --
> 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.

[Elaine Ding]

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

[Jose Blanco]

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

> To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/804a1c4a-9c62-401b-a967-7658d8ce520fn%40googlegroups.com.

[Elaine Ding]

Hi, Jose

Attached please find the dspace.log, I will take a look of the info you sent. 

appreciate for the help

--Elaine