EPrints Technical Mailing List Archive

Message: #07522

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

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

Hi

As for the bellow error "ERROR: duplicate key value violates unique constraint "event_queue_pkey" could it be caused because we are using Postgresql instead of Mysql?

Thanks,
Maher

-----Original Message-----
From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Maher Abdellatif Ahmad Qahwash via Eprints-tech
Sent: Wednesday, October 10, 2018 8:29 AM
To: eprints-tech@ecs.soton.ac.uk
Subject: Re: [EP-tech] duplicate key value violates unique constraint "event_queue_pkey"

Hi

Any update on the bellow email "ERROR:  duplicate key value violates unique constraint "event_queue_pkey"?

We also noticed that when setting an embargo date we are receiving the following in the error logs:

Argument "2019," isn't numeric in sprintf at /opt/eprints3/perl_lib/EPrints/MetaField/Date.pm line 56.
Argument "10," isn't numeric in sprintf at /opt/eprints3/perl_lib/EPrints/MetaField/Date.pm line 57.

Thanks,
Maher

-----Original Message-----
From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Maher Abdellatif Ahmad Qahwash via Eprints-tech
Sent: Monday, October 01, 2018 5:00 PM
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] duplicate key value violates unique constraint "event_queue_pkey"
____________________________________________________________
Hi

We have installed the latest ePrints 3.4 with Postgresql 9.4  , adding a new item to the repository works fine but we are receiving this error continuously in the logs:

ERROR:  duplicate key value violates unique constraint "event_queue_pkey"
DETAIL:  Key (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) already exists. at /opt/eprints3/perl_lib/EPrints/Database.pm 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 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 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 line 534
	EPrints::DataObj::EPrint::update_triggers('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/DataObj/EPrint.pm line 1013
	EPrints::DataObj::EPrint::commit('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/Workflow/Stage.pm 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 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 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 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 line 117
	EPrints::Plugin::Screen::EPrint::Edit::from('EPrints::Plugin::Screen::EPrint::Edit=HASH(0x55aa5914bc58)') called at /opt/eprints3/perl_lib/EPrints/ScreenProcessor.pm 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 line 207
	eval {...} called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 207
	ModPerl::RegistryCooker::run('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 173
	ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/Registry.pm 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 other events for some reason are trying to use 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

*** Options: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fimsva91-ctp.trendmicro.com%3A443%2Fwis%2Fclicktime%2Fv1%2Fquery%3Furl%3Dhttps%253a%252f%252femea01.safelinks.protection.outlook.com%252f%253furl%253dhttps%25253A%25252F%25252Fimsva91%252dctp.trendmicro.com%25253A443%25252Fwis%25252Fclicktime%25252Fv1%25252Fquery%25253Furl%25253Dhttp%2525253a%2525252f%2525252fmailman.ecs.soton.ac.uk%2525252fmailman%2525252flistinfo%2525252feprints%2525252dtech%252526umid%25253DED3A9002%252d77D9%252d2105%252d8B0D%252dEAF52F62C589%252526auth%25253Dec34f7633709e8bd85e48c7fc0c92c09c079e558%252dc34bd800d696ea515801abcae6bc7080641b016c%2526amp%253bdata%253d01%25257C01%25257Ceprints%252dtech%252540ecs.soton.ac.uk%25257Ca0afb2f96a014d3ab7e208d62e71485f%25257C4a5378f929f44d3ebe89669d03ada9d8%25257C1%2526amp%253bsdata%253dY9hdAjo60BMjYb%25252BpMX%25252BEuNDAKRbCBe%25252B6Nzvaqk5d3mw%25253D%2526amp%253breserved%253d0%26umid%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-4b190db3ba2f611390171cb24a22fff8ec7e6509&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=8MbUkFJX9zOWMEdnY52Yy8mSoG2TZsW9hSp8ACX9g%2Bw%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%3Dhttps%253a%252f%252femea01.safelinks.protection.outlook.com%252f%253furl%253dhttps%25253A%25252F%25252Fimsva91%252dctp.trendmicro.com%25253A443%25252Fwis%25252Fclicktime%25252Fv1%25252Fquery%25253Furl%25253Dhttp%2525253a%2525252f%2525252fwww.eprints.org%2525252ftech.php%2525252f%252526umid%25253DED3A9002%252d77D9%252d2105%252d8B0D%252dEAF52F62C589%252526auth%25253Dec34f7633709e8bd85e48c7fc0c92c09c079e558%252d4bc7506d21d2e556f9e2bb6a744d25255fd6fc99%2526amp%253bdata%253d01%25257C01%25257Ceprints%252dtech%252540ecs.soton.ac.uk%25257Ca0afb2f96a014d3ab7e208d62e71485f%25257C4a5378f929f44d3ebe89669d03ada9d8%25257C1%2526amp%253bsdata%253d78E6Pgal3vHCb0JBjSIGoJoyfBBdYJcAKuVwWifqC50%25253D%2526amp%253breserved%253d0%26umid%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-482662c9f688ba41168b5e975b1bde91350ef486&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=yE1frdVEBhpIqP%2BNXiKojISEpkOz49otURcQSNqh5m4%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%3Dhttps%253a%252f%252femea01.safelinks.protection.outlook.com%252f%253furl%253dhttps%25253A%25252F%25252Fimsva91%252dctp.trendmicro.com%25253A443%25252Fwis%25252Fclicktime%25252Fv1%25252Fquery%25253Furl%25253Dhttp%2525253a%2525252f%2525252fwiki.eprints.org%252526umid%25253DED3A9002%252d77D9%252d2105%252d8B0D%252dEAF52F62C589%252526auth%25253Dec34f7633709e8bd85e48c7fc0c92c09c079e558%252dd7a679a5cb5b40d1c4e1fe8b5ad6d0356636b161%2526amp%253bdata%253d01%25257C01%25257Ceprints%252dtech%252540ecs.soton.ac.uk%25257Ca0afb2f96a014d3ab7e208d62e71485f%25257C4a5378f929f44d3ebe89669d03ada9d8%25257C1%2526amp%253bsdata%253dBwkPNCDV7hgW7657dmW6cJp5%25252FoZaS3Z8EvgvXOj48sQ%25253D%2526amp%253breserved%253d0%26umid%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-3a712b491589fe7337382736768cad62ad76ca17&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=uEFyAZ%2BA4n0Zkq9%2BljdmnIgZcHnjOMKu%2FAMDQ2l83QA%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%3Dhttps%253a%252f%252femea01.safelinks.protection.outlook.com%252f%253furl%253dhttps%25253A%25252F%25252Fimsva91%252dctp.trendmicro.com%25253A443%25252Fwis%25252Fclicktime%25252Fv1%25252Fquery%25253Furl%25253Dhttp%2525253a%2525252f%2525252fforum.eprints.org%252526umid%25253DED3A9002%252d77D9%252d2105%252d8B0D%252dEAF52F62C589%252526auth%25253Dec34f7633709e8bd85e48c7fc0c92c09c079e558%252d88bb4b5758c3bc8715cc1eeae54242330f7a7280%2526amp%253bdata%253d01%25257C01%25257Ceprints%252dtech%252540ecs.soton.ac.uk%25257Ca0afb2f96a014d3ab7e208d62e71485f%25257C4a5378f929f44d3ebe89669d03ada9d8%25257C1%2526amp%253bsdata%253deSP4qmrw3akjmUBIJUgW%25252Fd%25252ByuHlJWcHAImtyHDnlABI%25253D%2526amp%253breserved%253d0%26umid%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-9c1ec23d393ea32ca9b4299064fa969f780a0d1a&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=g4EQ%2Fz%2FYvPt%2BVwkadfyhk0GyY8R1oajmjqVKbF%2Fa9p8%3D&amp;reserved=0

*** 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%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-c8efb2ad168a47553509f10a5c2dcdc25b9d58a6&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=XvE6Zm61pLsyvfB5%2Fm2xkS6TPBjDoJZHtBL653UFXf4%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%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-cb1b0ef03649a1b7b89c55adc7c3c3f4459b5835&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=r0qdiIpGefVMtSe%2BLFnCcA%2BaHAvWDraK9uGmbfNXjEw%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%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-deed5e196e25dfefc8b2ae1c04ded87d57598684&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Ftejj5u94Wmj2b2kZzgLIpuFwBa76dh3ATkZKWSqSVQ%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%3D57B40FEF-77DF-4C05-87B7-4A9BB410CDDB%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-dda6ac017ed97fc887ee96f461e7cf1553a6814b&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C068d7cfad91645eb149808d62eaef939%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=EVsa8dVRvhQkrZU9jg90%2FfuNYd%2BDdVN8Wha5QlwjFig%3D&amp;reserved=0