Dear All, When resetting pwd on DSpace 7.4 I am getting error, see attached postgres log and frontend screenshot error
We recently migrated our DSpace server to Oracle cloud and this errors started to show, when users tries to reset their passwd they receive attached error details. Regards, Lewatle -- 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/1a8bff52-cccc-42cd-ae74-0e94e0f4fcd6n%40googlegroups.com.
$ vi postgresql-11-main.log 2023-06-20 17:27:51.429 UTC [378729] wiredmin@wiredspace DETAIL: Key (email)=(0...@students.wits.ac.za) already exists. 2023-06-20 17:27:51.429 UTC [378729] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-20 17:27:55.528 UTC [378727] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-20 17:27:55.528 UTC [378727] wiredmin@wiredspace DETAIL: Key (email)=(0...@students.wits.ac.za) already exists. 2023-06-20 17:27:55.528 UTC [378727] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:25:48.812 UTC [404261] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:25:48.812 UTC [404261] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:25:48.812 UTC [404261] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:25:52.905 UTC [404216] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:25:52.905 UTC [404216] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:25:52.905 UTC [404216] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:09.322 UTC [404174] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:09.322 UTC [404174] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:09.322 UTC [404174] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:09.324 UTC [404269] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:09.324 UTC [404269] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:09.324 UTC [404269] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:11.333 UTC [404199] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:11.333 UTC [404199] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:11.333 UTC [404199] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:40.004 UTC [404273] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:40.004 UTC [404273] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:40.004 UTC [404273] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:50.247 UTC [404277] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:50.247 UTC [404277] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:50.247 UTC [404277] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:26:52.292 UTC [404268] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:26:52.292 UTC [404268] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:26:52.292 UTC [404268] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:27:08.677 UTC [403063] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:27:08.677 UTC [403063] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:27:08.677 UTC [403063] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:27:10.727 UTC [404262] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:27:10.727 UTC [404262] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:27:10.727 UTC [404262] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:27:10.728 UTC [402982] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:27:10.728 UTC [402982] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:27:10.728 UTC [402982] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:27:39.401 UTC [404311] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:27:39.401 UTC [404311] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:27:39.401 UTC [404311] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-22 23:27:49.673 UTC [404308] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-22 23:27:49.673 UTC [404308] wiredmin@wiredspace DETAIL: Key (email)=(9...@students.wits.ac.za) already exists. 2023-06-22 23:27:49.673 UTC [404308] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-24 17:22:05.317 UTC [424194] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-24 17:22:05.317 UTC [424194] wiredmin@wiredspace DETAIL: Key (email)=(m...@wits.ac.za) already exists. 2023-06-24 17:22:05.317 UTC [424194] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace ERROR: duplicate key value violates unique constraint "registrationdata_email_key" 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace DETAIL: Key (email)=(m...@wits.ac.za) already exists. 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4 2023-06-24 17:22:33.989 UTC [424203] wiredmin@wiredspace STATEMENT: update public.registrationdata set email=$1, expires=$2, token=$3 where registrationdata_id=$4