[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] duplicate key value violates unique constraint "event_queue_pkey"




Hi Thomas

Thank you for your input.  The "2019," error had been resolved as it was a wrong syntax we had in the document default pl file.

My question "could it be caused because we are using Postgresql instead of Mysql? " Is referring to the below error we are continuesly receiving in the error logs when we create a new item:

ERROR:  duplicate key value violates unique constraint "event_queue_pkey"
DETAIL:  Key (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) already exists. at /opt/eprints3/perl_lib/EPrints/Database.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fdatabase.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-c61e72712d82b9e6bb5e6f50231072e17ede7460&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=XbdVJHYlAVNYAgQ02zvFussh8EC3Z8u8grtffewExGA%3D&amp;reserved=0>line 1387.
EPrints::Database::add_record('EPrints::Database::Pg=HASH(0x55aa5922a478)', 'EPrints::DataSet=HASH(0x55aa57023030)', 'HASH(0x55aa592f77c8)') called at /opt/eprints3/perl_lib/EPrints/DataObj.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fdataobj.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-3e34d00fb3c4a7b336f3b4ce4b06147c3fc94707&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=35aydpIp3E3tFEIQGK8eXYDsMXwbkRjKgPbIDIcWN3E%3D&amp;reserved=0> line 294
EPrints::DataObj::create_from_data('EPrints::DataObj::EventQueue', 'EPrints::Repository=HASH(0x55aa55a83468)', 'HASH(0x55aa592f72d0)', 'EPrints::DataSet=HASH(0x55aa57023030)') called at /opt/eprints3/perl_lib/EPrints/DataObj/EventQueue.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252feventqueue.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-a337774b52c2dad88cce1c60b1ae360160fe058f&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=hClo4esYKcgHqtgh82LBCsirxKj6mlnIh%2B%2BuQYKEhUQ%3D&amp;reserved=0> line 109
EPrints::DataObj::EventQueue::create_unique('EPrints::DataObj::EventQueue', 'EPrints::Repository=HASH(0x55aa55a83468)', 'HASH(0x55aa592f72d0)') called at /opt/eprints3/perl_lib/EPrints/DataObj/EPrint.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252feprint.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-bce42089a9cfcce2798db417d33ef66e09210db1&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=hJ1n6Bj%2FsMAs3MlJTk8TpTHSSY25Bvnfi%2FF5mvl2ONs%3D&amp;reserved=0> line 534
EPrints::DataObj::EPrint::update_triggers('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/DataObj/EPrint.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252feprint.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-bce42089a9cfcce2798db417d33ef66e09210db1&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=hJ1n6Bj%2FsMAs3MlJTk8TpTHSSY25Bvnfi%2FF5mvl2ONs%3D&amp;reserved=0> line 1013
EPrints::DataObj::EPrint::commit('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/Workflow/Stage.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fstage.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-15aafce36f892a4edeadd4e9360fe5b4a41ec8d6&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=R4M0pW0VAj9KoD8Fd5NGGB44hIO5o8apU7mDMmro%2BYU%3D&amp;reserved=0> line 221
EPrints::Workflow::Stage::update_from_form('EPrints::Workflow::Stage=HASH(0x55aa5926a530)', 'EPrints::ScreenProcessor=HASH(0x55aa5922e510)') called at /opt/eprints3/perl_lib/EPrints/Workflow.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fworkflow.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-38fcd20e9cdafb34d660ee79a13cf7786cd79dd4&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=8d4%2FWqQuIGauHkmF9UMjnk0c96APW7dEImlg3gpMSag%3D&amp;reserved=0>line 401
EPrints::Workflow::update_from_form('EPrints::Workflow=HASH(0x55aa592ee8e8)', 'EPrints::ScreenProcessor=HASH(0x55aa5922e510)') called at /opt/eprints3/perl_lib/EPrints/Plugin/Screen/EPrint/Edit.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fedit.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-96aeeac9a50b07beeb745f8fb5e2ca09a2269c78&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Q31n2YNpYsr%2BK4rPmzM2z2x8ZilIudiqBcPyFpPpgqs%3D&amp;reserved=0> line 189
EPrints::Plugin::Screen::EPrint::Edit::action_next('EPrints::Plugin::Screen::EPrint::Edit=HASH(0x55aa5914bc58)') called at /opt/eprints3/perl_lib/EPrints/Plugin/Screen.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fscreen.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-db0e3ec256af16c08bdb1294e1073930abd2148c&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=jyOlxErjzjnnn7oS01LBk7w%2F14QMLN8IXz7y9YKmWGo%3D&amp;reserved=0> line 240
EPrints::Plugin::Screen::from('EPrints::Plugin::Screen::EPrint::Edit=HASH(0x55aa5914bc58)') called at /opt/eprints3/perl_lib/EPrints/Plugin/Screen/EPrint/Edit.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fedit.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-96aeeac9a50b07beeb745f8fb5e2ca09a2269c78&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Q31n2YNpYsr%2BK4rPmzM2z2x8ZilIudiqBcPyFpPpgqs%3D&amp;reserved=0> line 117
EPrints::Plugin::Screen::EPrint::Edit::from('EPrints::Plugin::Screen::EPrint::Edit=HASH(0x55aa5914bc58)') called at /opt/eprints3/perl_lib/EPrints/ScreenProcessor.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fscreenprocessor.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-f64d781b8fde717baff5cb17343669b831891d98&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=8gD924CqttjDWwLB6K%2BrSbaZxbo4Fi%2B8CP1skb9s4qM%3D&amp;reserved=0> line 316
EPrints::ScreenProcessor::process('EPrints::ScreenProcessor', 'session', 'EPrints::Repository=HASH(0x55aa55a83468)', 'template', undef, 'url', '/cgi/users/home') called at /opt/eprints3/cgi/users/home line 25
ModPerl::ROOT::ModPerl::Registry::opt_eprints3_cgi_users_home::handler('Apache2::RequestRec=SCALAR(0x55aa5445a690)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fregistrycooker.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-1bd429f502f4d21b11c212efa4d25ad253306e2b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=5gVEUuN8usGajX6f3%2FM%2FuM7JxSv5NHRxcTLDO%2F84Vrw%3D&amp;reserved=0> line 207
eval {...} called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fregistrycooker.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-1bd429f502f4d21b11c212efa4d25ad253306e2b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=5gVEUuN8usGajX6f3%2FM%2FuM7JxSv5NHRxcTLDO%2F84Vrw%3D&amp;reserved=0> line 207
ModPerl::RegistryCooker::run('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fregistrycooker.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-1bd429f502f4d21b11c212efa4d25ad253306e2b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=5gVEUuN8usGajX6f3%2FM%2FuM7JxSv5NHRxcTLDO%2F84Vrw%3D&amp;reserved=0> line 173
ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/Registry.pm<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252fregistry.pm%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-06686bad447ac5746e66b9cef1b71936baf0ecd2&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=6kO44GbICGCgjcDKtQhhyOqmIoeF4exXvy5UFf1uueU%3D&amp;reserved=0> line 32
ModPerl::Registry::handler('ModPerl::Registry', 'Apache2::RequestRec=SCALAR(0x55aa5445a690)') called at -e line 0
eval {...} called at -e line 0

doing a query in the "event_queue" with the same (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) shows that the pluginid is "Event::RDF" and is "waiting".  It seems another event is created with the same (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) which results in the "ERROR:  duplicate key value violates unique constraint "event_queue_pkey"

Thank you for your suggestions to solve this issue.

Thanks
Maher


____________________________________________________________
Hi Maher,

> could it be caused because we are using Postgresql instead of Mysql?
presumably not, because your error message
> Argument "2019," isn't numeric in sprintf at /opt/eprints3/perl_lib/EPrints/MetaField/Date.pm line 56
indicates a bad date format: 2019,10,... (instead 2019-10-10)!?

As already assumed by Karl this is caused by your input or a misconfigured localization.

Hth
Thomas
*** Options: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttp%253a%252f%252fmailman.ecs.soton.ac.uk%252fmailman%252flistinfo%252feprints%252dtech%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-a567dc7aa320e31e6cd2396bda972339d0411235&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=90z7nBg%2ByPA4Prmaefp89AdNSIztvUgYxG2AjdenJuw%3D&amp;reserved=0
*** Archive: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttp%253a%252f%252fwww.eprints.org%252ftech.php%252f%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-2bc5324e076d3fd81c5a94a461d59509f901636b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=CbnfUzL2m9aJKFlM5nJVg705WYvKzdGBMqLWGB%2Fdkr8%3D&amp;reserved=0
*** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttp%253a%252f%252fwiki.eprints.org%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-892f5d9fb96e475fc7ddf01be48f03d3cb5d1a7d&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=ixDcNURgEL5mHEKGG7pFFAmNmX7oFUBHbCWUe7uEXgE%3D&amp;reserved=0
*** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttp%253a%252f%252fforum.eprints.org%26umid%3D92C1FA58-77E1-EB05-9D92-71FF501CA4D8%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-ede041cdcbd4eca84b7b98da920bd2917ead3e2b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Cedae9f8d89064be3ff6a08d62ec92f46%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=YRPALtGAjZMN5pQqYDx2U0OrooEMVzAFekZ8lTYcZ2k%3D&amp;reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20181010/0503ca9a/attachment-0001.html