CRossref database error?

[mklem]

Recieved this error after submitting XML:

org.springframework.dao.DeadlockLoserDataAccessException: PreparedStatementCallback; SQL [UPDATE atypon.citation_info SET JOURNALCITEID = ?, BOOKCITEID = ?, SERIESTITLEID = ?, MISSPELLINGID = ?, SUBMISSIONID = ?, VERSION = ?, YEAR = ?, VOLUME = ?, ISSUE = ?, SUPPLEMENT = ?, PAGE = ?, AUTHOR = ?, COMPONENTNUMBER = ?, EDITIONNUMBER = ?, OWNERPREFIX = ?, ARTICLETITLE = ?, SEQUENCENUMBER = ?, TYPE = ?, DOI = ?, MDCONFLICTID = ?, PAGEMOD = ?, SRCTYPE = ?, ORIGPAGE = ?, LASTPAGE = ?, PUBMONTH = ?, PUBDAY = ?, CONFNAMEID = ?, INSTCITEID = ?, FORCEDALIASID = ?, SRCSUBTYPE = ?, LASTUPDATE = ?, UNIXMLSTATUS = ?, UNICLOBID = ?, MASK = ?, ALIASID = ? WHERE CITATIONID = ?]; ORA-00060: deadlock detected while waiting for resource
; nested exception is java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource

Are you able to accept XML deposits now? Will the deposits receiving this error be re-processed later?

[ifarley]

Hello @mklem ,

Do you happen to have a submission ID for the registration that is triggering this error message? We did have a release earlier today, but I’m not aware of any lingering issues. A submission ID would help me verify.

-Isaac

[mklem]

Unfortunately I do not. I will make sure we record that data going forward.

[mklem]

Hi Issaac,

Where would I find the submission id? In an email or it is returned from calling your API?

[ifarley]

Hi @mklem

The submission ID is returned in the email submission log where this error message would have appeared.

-Isaac

[mklem]

@ifarley

The submission ID is returned in the email submission log where this error message would have appeared.

I found it using your admin tool. The submission id that had this error is:

1634040952

It was resubmitted soon after and it worked.

[ifarley]

Thank you for the submission ID @mklem . I see that the DOI in that submission has been resubmitted and registered with us. When I reran submission 1634040952, I now get a timestamp error, which means that the DOI was previously registered.

You should be all set on this example and any others that triggered this error. That was on our end, but it should be sorted now. If that is not the case, please do let me know.

Warm regards,
Isaac

[mklem]

Hi Issac,

I am seeing this error again this morning. Submission id is 1634349273
Saw it twice this morning.

[ifarley]

@mklem

1634349273

Thank you for flagging this to us. In the initial submissions, I see that there is one success message and one failure, even though the submission only contains one DOI. When I rerun the submission, I get a timestamp error, which means that we are indeed storing the previous, successful submission.

That said, these are certainly weird submission errors/logs. I have flagged this to our technical team so they can review the issue.

-Isaac

[mklem]

Thanks.

Here is another backend error message:

org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO atypon.citation_rels (CITATIONID1, CITATIONID2, REL, CREATED, QUERYKEY, DELETED) VALUES (?, ?, ?, ?, ?, ?)]; ORA-00001: unique constraint (ATYPON.NDX1_CIT_RELS) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ATYPON.NDX1_CIT_RELS) violated

DOI: 10.1103/PhysRevC.109.064618
Submission id: 1634356505

[mklem]

Also this:
org.springframework.dao.DeadlockLoserDataAccessException: PreparedStatementCallback; SQL [UPDATE atypon.uniclob_info SET DESCRIPTION = ?, COMPRESSED = ?, COMPRESSEDDATA = ?, UNCOMPRESSED_LENGTH = ? WHERE CLOBID = ?]; ORA-00060: deadlock detected while waiting for resource
; nested exception is java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource

[ifarley]

@mklem

1634356505

I’ve noted these other examples in the ticket open with our technical team. Thank you!

-Isaac

[mklem]

Hi Issac,

Is it possible to confirm if this message came from your servers:
Error processing references: null
Submission id is 1634348750

[ifarley]

Hello @mklem ,

Yes, that null error in processing references was on our end. I have resubmitted that registration and the references were processed, as you can see here: https://0-doi-crossref-org.libus.csd.mu.edu/servlet/submissionAdmin?sf=detail&submissionID=1634516614

<?xml version="1.0" encoding="UTF-8"?>
<doi_batch_diagnostic status="completed" sp="ds5">
   <submission_id>1634516614</submission_id>
   <batch_id>apsxref:8ad2ea8a-b219-4fb5-b652-23f0c6488bbf</batch_id>
   <record_diagnostic status="Success">
      <doi>10.1103/PhysRevD.109.115020</doi>
      <msg>Successfully updated</msg>
      <citations_diagnostic>
         <citation key="PhysRevD.109.115020Cc1R1" status="resolved_reference">10.1007/s10714-008-0707-4</citation>
         <citation key="PhysRevD.109.115020Cc2R1" status="resolved_reference">10.1086/150317</citation>
         <citation key="PhysRevD.109.115020Cc3R1" status="resolved_reference">10.1086/508162</citation>
         <citation key="PhysRevD.109.115020Cc4R1" status="resolved_reference">10.1086/513700</citation>
         <citation key="PhysRevD.109.115020Cc5R1" status="resolved_reference">10.1088/1361-6633/aab913</citation>
         <citation key="PhysRevD.109.115020Cc6R1" status="resolved_reference">10.1051/0004-6361/201833910</citation>
         <citation key="PhysRevD.109.115020Cc7R1" status="resolved_reference">10.1016/j.physrep.2004.08.031</citation>
         <citation key="PhysRevD.109.115020Cc8R1" status="resolved_reference">10.1146/annurev.astro.40.060401.093926</citation>
         <citation key="PhysRevD.109.115020Cc10R1" status="resolved_reference">10.1007/JHEP03(2010)080</citation>
         <citation key="PhysRevD.109.115020Cc11R1" status="resolved_reference">10.1103/PhysRevLett.113.171301</citation>
         <citation key="PhysRevD.109.115020Cc12R1" status="resolved_reference">10.1103/PhysRevD.41.2388</citation>
         <citation key="PhysRevD.109.115020Cc13R1" status="resolved_reference">10.1103/PhysRevLett.91.011302</citation>
         <citation key="PhysRevD.109.115020Cc14R1" status="resolved_reference">10.1103/PhysRevD.78.115012</citation>
         <citation key="PhysRevD.109.115020Cc15R1" status="resolved_reference">10.1016/j.physletb.2008.02.052</citation>
         <citation key="PhysRevD.109.115020Cc16R1" status="resolved_reference">10.1007/JHEP06(2021)103</citation>
         <citation key="PhysRevD.109.115020Cc17R1" status="resolved_reference">10.1103/PhysRevLett.118.021303</citation>
         <citation key="PhysRevD.109.115020Cc18R1" status="resolved_reference">10.1103/PhysRevLett.121.111302</citation>
         <citation key="PhysRevD.109.115020Cc19R1" status="resolved_reference">10.1103/PhysRevLett.131.041003</citation>
         <citation key="PhysRevD.109.115020Cc20R1" status="resolved_reference">10.1103/PhysRevLett.117.121303</citation>
         <citation key="PhysRevD.109.115020Cc21R1" status="resolved_reference">10.1103/PhysRevLett.119.181302</citation>
         <citation key="PhysRevD.109.115020Cc22R1" status="resolved_reference">10.1103/PhysRevLett.131.041002</citation>
         <citation key="PhysRevD.109.115020Cc23R1" status="resolved_reference">10.1007/JHEP05(2013)036</citation>
         <citation key="PhysRevD.109.115020Cc24R1" status="resolved_reference">10.1088/1475-7516/2012/10/026</citation>
         <citation key="PhysRevD.109.115020Cc25R1" status="resolved_reference">10.1103/PhysRevD.104.075022</citation>
         <citation key="PhysRevD.109.115020Cc26R1" status="resolved_reference">10.1007/JHEP06(2021)122</citation>
         <citation key="PhysRevD.109.115020Cc27R1" status="resolved_reference">10.1007/JHEP02(2022)051</citation>
         <citation key="PhysRevD.109.115020Cc28R1" status="resolved_reference">10.1088/1475-7516/2017/12/021</citation>
         <citation key="PhysRevD.109.115020Cc29R1" status="resolved_reference">10.1007/JHEP09(2015)162</citation>
         <citation key="PhysRevD.109.115020Cc30R1" status="resolved_reference">10.1016/j.physletb.2023.138119</citation>
         <citation key="PhysRevD.109.115020Cc31R1" status="resolved_reference">10.1093/ptep/ptaa104</citation>
         <citation key="PhysRevD.109.115020Cc32R1" status="resolved_reference">10.1088/0034-4885/70/11/R02</citation>
         <citation key="PhysRevD.109.115020Cc33R1" status="resolved_reference">10.1016/0370-2693(77)90435-X</citation>
         <citation key="PhysRevD.109.115020Cc36R1" status="resolved_reference">10.1103/PhysRevLett.44.912</citation>
         <citation key="PhysRevD.109.115020Cc37R1" status="resolved_reference">10.1016/0370-2693(80)90825-4</citation>
         <citation key="PhysRevD.109.115020Cc38R1" status="resolved_reference">10.1016/0550-3213(81)90354-0</citation>
         <citation key="PhysRevD.109.115020Cc39R1" status="resolved_reference">10.1103/PhysRevD.23.165</citation>
         <citation key="PhysRevD.109.115020Cc40R1" status="resolved_reference">10.1103/PhysRevD.22.2227</citation>
         <citation key="PhysRevD.109.115020Cc41R1" status="resolved_reference">10.1103/PhysRevD.22.2860</citation>
         <citation key="PhysRevD.109.115020Cc42R1" status="resolved_reference">10.1103/PhysRevLett.44.912</citation>
         <citation key="PhysRevD.109.115020Cc43R1" status="resolved_reference">10.1103/PhysRevLett.81.1171</citation>
         <citation key="PhysRevD.109.115020Cc44R1" status="resolved_reference">10.1007/BF01415558</citation>
         <citation key="PhysRevD.109.115020Cc45R1" status="resolved_reference">10.1103/PhysRevLett.80.5716</citation>
         <citation key="PhysRevD.109.115020Cc46R1" status="resolved_reference">10.1016/S0550-3213(02)00815-5</citation>
         <citation key="PhysRevD.109.115020Cc47R1" status="resolved_reference">10.1016/j.nuclphysb.2004.06.027</citation>
         <citation key="PhysRevD.109.115020Cc48R1" status="resolved_reference">10.1103/PhysRevD.100.035022</citation>
         <citation key="PhysRevD.109.115020Cc49R1" status="resolved_reference">10.1103/PhysRevD.101.023522</citation>
         <citation key="PhysRevD.109.115020Cc50R1" status="resolved_reference">10.1016/j.physletb.2020.135785</citation>
         <citation key="PhysRevD.109.115020Cc51R1" status="resolved_reference">10.1007/JHEP03(2022)195</citation>
         <citation key="PhysRevD.109.115020Cc52R1" status="resolved_reference">10.1103/PhysRevD.105.123512</citation>
         <citation key="PhysRevD.109.115020Cc53R1" status="resolved_reference">10.1103/PhysRevD.106.015001</citation>
         <citation key="PhysRevD.109.115020Cc54R1" status="resolved_reference">10.1103/PhysRevLett.132.021803</citation>
         <citation key="PhysRevD.109.115020Cc55R1" status="resolved_reference">10.1007/JHEP12(2023)154</citation>
         <citation key="PhysRevD.109.115020Cc56R1" status="resolved_reference">10.1103/PhysRevD.109.095002</citation>
         <citation key="PhysRevD.109.115020Cc57R1" status="resolved_reference">10.1103/PhysRevD.87.015020</citation>
         <citation key="PhysRevD.109.115020Cc58R1" status="resolved_reference">10.1007/JHEP03(2013)150</citation>
         <citation key="PhysRevD.109.115020Cc58R2" status="resolved_reference">10.1007/JHEP05(2013)049</citation>
         <citation key="PhysRevD.109.115020Cc59R1" status="resolved_reference">10.1016/j.physletb.2017.06.067</citation>
         <citation key="PhysRevD.109.115020Cc61R1" status="resolved_reference">10.1140/epjc/s10052-023-11578-9</citation>
         <citation key="PhysRevD.109.115020Cc62R1" status="resolved_reference">10.1103/PhysRevD.96.035010</citation>
         <citation key="PhysRevD.109.115020Cc63R1" status="resolved_reference">10.1103/PhysRevD.90.114018</citation>
         <citation key="PhysRevD.109.115020Cc64R1" status="resolved_reference">10.1140/epjc/s10052-016-4115-8</citation>
         <citation key="PhysRevD.109.115020Cc65R1" status="resolved_reference">10.1016/0550-3213(88)90462-2</citation>
         <citation key="PhysRevD.109.115020Cc66R1" status="resolved_reference">10.1140/epjc/s10052-016-4271-x</citation>
         <citation key="PhysRevD.109.115020Cc67R1" status="resolved_reference">10.1007/JHEP11(2012)106</citation>
         <citation key="PhysRevD.109.115020Cc68R1" status="resolved_reference">10.1007/JHEP08(2022)104</citation>
         <citation key="PhysRevD.109.115020Cc70R1" status="resolved_reference">10.1016/j.physrep.2007.10.005</citation>
         <citation key="PhysRevD.109.115020Cc71R1" status="error">Reference DOI 10.1002/(SICI)1521-3978(199804)46:3&lt;203::AID-PROP203&gt;3.0.CO;2-4 not found in Crossref doi: 10.1002/(SICI)1521-3978(199804)46:3&lt;203::AID-PROP203&gt;3.0.CO;2-4</citation>
         <citation key="PhysRevD.109.115020Cc73R1" status="resolved_reference">10.1007/JHEP08(2012)060</citation>
         <citation key="PhysRevD.109.115020Cc74R1" status="resolved_reference">10.1007/JHEP07(2023)088</citation>
         <citation key="PhysRevD.109.115020Cc75R1" status="resolved_reference">10.1016/j.physletb.2020.135754</citation>
         <citation key="PhysRevD.109.115020Cc76R1" status="resolved_reference">10.1007/JHEP07(2021)027</citation>
         <citation key="PhysRevD.109.115020Cc77R1" status="resolved_reference">10.1007/JHEP05(2023)233</citation>
         <citation key="PhysRevD.109.115020Cc78R1" status="error">Reference DOI 10.1103/Phys- RevD.16.1519 not found in Crossref doi: 10.1103/Phys- RevD.16.1519</citation>
         <citation key="PhysRevD.109.115020Cc79R1" status="resolved_reference">10.1103/PhysRevD.77.095009</citation>
         <citation key="PhysRevD.109.115020Cc80R1" status="resolved_reference">10.1016/S0370-2693(00)00962-X</citation>
         <citation key="PhysRevD.109.115020Cc81R1" status="resolved_reference">10.1103/PhysRevD.97.115022</citation>
         <citation key="PhysRevD.109.115020Cc82R1" status="resolved_reference">10.1016/j.cpc.2006.11.008</citation>
         <citation key="PhysRevD.109.115020Cc83R1" status="resolved_reference">10.1016/j.cpc.2014.04.012</citation>
         <citation key="PhysRevD.109.115020Cc84R1" status="resolved_reference">10.1016/j.cpc.2008.11.019</citation>
         <citation key="PhysRevD.109.115020Cc86R1" status="resolved_reference">10.1088/1475-7516/2016/06/024</citation>
         <citation key="PhysRevD.109.115020Cc87R1" status="resolved_reference">10.1007/JHEP07(2023)143</citation>
         <citation key="PhysRevD.109.115020Cc88R1" status="resolved_reference">10.1007/JHEP04(2012)136</citation>
         <citation key="PhysRevD.109.115020Cc89R1" status="resolved_reference">10.1103/PhysRevD.84.095005</citation>
         <citation key="PhysRevD.109.115020Cc6R2" status="resolved_reference">10.1051/0004-6361/201833910e</citation>
         <citation key="PhysRevD.109.115020Cc9R1" status="stored_query"></citation>
         <citation key="PhysRevD.109.115020Cc34R1" status="stored_query"></citation>
         <citation key="PhysRevD.109.115020Cc35R1" status="stored_query"></citation>
         <citation key="PhysRevD.109.115020Cc60R1" status="stored_query"></citation>
         <citation key="PhysRevD.109.115020Cc69R1" status="stored_query"></citation>
         <citation key="PhysRevD.109.115020Cc72R1" status="stored_query"></citation>
      </citations_diagnostic>
   </record_diagnostic>
   <batch_data>
      <record_count>1</record_count>
      <success_count>1</success_count>
      <warning_count>0</warning_count>
      <failure_count>0</failure_count>
   </batch_data>
</doi_batch_diagnostic>

-Isaac

[mklem]

Thank you for the fast responses Isaac.