EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #07518


< 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

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%3Dhttp%253a%252f%252fmailman.ecs.soton.ac.uk%252fmailman%252flistinfo%252feprints%252dtech%26umid%3DED3A9002-77D9-2105-8B0D-EAF52F62C589%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-c34bd800d696ea515801abcae6bc7080641b016c&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=Y9hdAjo60BMjYb%2BpMX%2BEuNDAKRbCBe%2B6Nzvaqk5d3mw%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%3DED3A9002-77D9-2105-8B0D-EAF52F62C589%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-4bc7506d21d2e556f9e2bb6a744d25255fd6fc99&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=78E6Pgal3vHCb0JBjSIGoJoyfBBdYJcAKuVwWifqC50%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%3DED3A9002-77D9-2105-8B0D-EAF52F62C589%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-d7a679a5cb5b40d1c4e1fe8b5ad6d0356636b161&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=BwkPNCDV7hgW7657dmW6cJp5%2FoZaS3Z8EvgvXOj48sQ%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%3DED3A9002-77D9-2105-8B0D-EAF52F62C589%26auth%3Dec34f7633709e8bd85e48c7fc0c92c09c079e558-88bb4b5758c3bc8715cc1eeae54242330f7a7280&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=eSP4qmrw3akjmUBIJUgW%2Fd%2ByuHlJWcHAImtyHDnlABI%3D&amp;reserved=0