<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
I See you have commas ( , ) in those quotes; I’m not familiar with the codepath between embargo input and MetaField::Date but could it be a locale or validation issue? It looks unrelated to your first problem.
<div class="">Kk</div>
<div class=""><br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On 10 Oct 2018, at 4:28 pm, Maher Abdellatif Ahmad Qahwash via Eprints-tech &lt;<a href="mailto:eprints-tech@ecs.soton.ac.uk" class="">eprints-tech@ecs.soton.ac.uk</a>&gt; wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Hi<br class="">
<br class="">
Any update on the bellow email &quot;ERROR: duplicate key value violates unique constraint &quot;event_queue_pkey&quot;?<br class="">
<br class="">
We also noticed that when setting an embargo date we are receiving the following in the error logs:<br class="">
<br class="">
Argument &quot;2019,&quot; isn't numeric in sprintf at /opt/eprints3/perl_lib/EPrints/MetaField/Date.pm line 56.<br class="">
Argument &quot;10,&quot; isn't numeric in sprintf at /opt/eprints3/perl_lib/EPrints/MetaField/Date.pm line 57.<br class="">
<br class="">
Thanks,<br class="">
Maher<br class="">
<br class="">
-----Original Message-----<br class="">
From: <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" class="">eprints-tech-bounces@ecs.soton.ac.uk</a> [<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk" class="">mailto:eprints-tech-bounces@ecs.soton.ac.uk</a>] On Behalf Of Maher Abdellatif Ahmad
 Qahwash via Eprints-tech<br class="">
Sent: Monday, October 01, 2018 5:00 PM<br class="">
To: <a href="mailto:eprints-tech@ecs.soton.ac.uk" class="">eprints-tech@ecs.soton.ac.uk</a><br class="">
Subject: [EP-tech] duplicate key value violates unique constraint &quot;event_queue_pkey&quot;<br class="">
____________________________________________________________<br class="">
Hi<br class="">
<br class="">
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:<br class="">
<br class="">
ERROR: duplicate key value violates unique constraint &quot;event_queue_pkey&quot;<br class="">
DETAIL: Key (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) already exists. at /opt/eprints3/perl_lib/EPrints/Database.pm line 1387.<br class="">
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<br class="">
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<br class="">
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<br class="">
EPrints::DataObj::EPrint::update_triggers('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/DataObj/EPrint.pm line 1013<br class="">
EPrints::DataObj::EPrint::commit('EPrints::DataObj::EPrint=HASH(0x55aa59246210)') called at /opt/eprints3/perl_lib/EPrints/Workflow/Stage.pm line 221<br class="">
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<br class="">
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<br class="">
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<br class="">
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<br class="">
EPrints::Plugin::Screen::EPrint::Edit::from('EPrints::Plugin::Screen::EPrint::Edit=HASH(0x55aa5914bc58)') called at /opt/eprints3/perl_lib/EPrints/ScreenProcessor.pm line 316<br class="">
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<br class="">
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<br class="">
eval {...} called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 207<br class="">
ModPerl::RegistryCooker::run('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/RegistryCooker.pm line 173<br class="">
ModPerl::RegistryCooker::default_handler('ModPerl::Registry=HASH(0x55aa592206f8)') called at /usr/lib64/perl5/vendor_perl/ModPerl/Registry.pm line 32<br class="">
ModPerl::Registry::handler('ModPerl::Registry', 'Apache2::RequestRec=SCALAR(0x55aa5445a690)') called at -e line 0<br class="">
eval {...} called at -e line 0<br class="">
<br class="">
doing a query in the &quot;event_queue&quot; with the same (eventqueueid)=(e9210339587b3507d2bdafc95a238a39) shows that the pluginid is &quot;Event::RDF&quot; and is &quot;waiting&quot;. It seems other events for some reason are trying to use the same (eventqueueid)=(e9210339587b3507d2bdafc95a238a39)
 which results in the &quot;ERROR: duplicate key value violates unique constraint &quot;event_queue_pkey&quot;<br class="">
<br class="">
Thank you for your suggestions to solve this issue.<br class="">
<br class="">
Thanks<br class="">
<br class="">
*** Options: <a href="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%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=t%2FcNAPZozTzv5NFOquiixdYUAi%2FTw4vjkFcfrAsqxTA%3D&amp;reserved=0" originalSrc="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2fmailman.ecs.soton.ac.uk%2fmailman%2flistinfo%2feprints%2dtech&umid=ED3A9002-77D9-2105-8B0D-EAF52F62C589&auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-c34bd800d696ea515801abcae6bc7080641b016c" shash="QkKGn4UYB5hHP7CGuwE5g0D1xWw5ZLqseIc1dwUyryXRAOzMOsDoWaqCk/kIOD7v0OgDUQfvLKyGIDxF6bhhSbkt/E0Ks/RH7T/zFtjvQq+KACC9sosTM9FRToYtXGozkqSFOtdI66C7R8anro71j+nQYF2YM/3jzVlnPQidV3Y=" class="">
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;amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;amp;sdata=Y9hdAjo60BMjYb%2BpMX%2BEuNDAKRbCBe%2B6Nzvaqk5d3mw%3D&amp;amp;reserved=0</a><br class="">
*** Archive: <a href="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%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=kFYoOmYNu7LozWYIjkKavk5qdZ7X%2BeLXABEcJc7oXAo%3D&amp;reserved=0" originalSrc="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2fwww.eprints.org%2ftech.php%2f&umid=ED3A9002-77D9-2105-8B0D-EAF52F62C589&auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-4bc7506d21d2e556f9e2bb6a744d25255fd6fc99" shash="jKUQ+ffQx1OP07d2TVQthkIZwaH3l1ya5h8UZWs4zIUGP2GxgNn8VMIJ3qVvLL2BHPvC7wybf5FXLzOkjqjiOe8IVo/CW8WQ3doDeBBwxwRJ5+oA4CoNeE+l18AAPIv6BDJpj1rOWghPlPMRusvxyXdIHNw8IzPBRJux78ckzwo=" class="">
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;amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;amp;sdata=78E6Pgal3vHCb0JBjSIGoJoyfBBdYJcAKuVwWifqC50%3D&amp;amp;reserved=0</a><br class="">
*** EPrints community wiki: <a href="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%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=2AVZz98E4Iw6THM10TT9LXz40rwQ71o2hPXd6gvERlM%3D&amp;reserved=0" originalSrc="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2fwiki.eprints.org&umid=ED3A9002-77D9-2105-8B0D-EAF52F62C589&auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-d7a679a5cb5b40d1c4e1fe8b5ad6d0356636b161" shash="H+m2MB7dqOxMp9Mm4ZSYGN15eU38y8c4KhnRppQRCmrHXVC+61pupAaw6mkCc/x5KpiT2UBpojNY9/pqMfyaarAU3xCck+edcXSm9s4Qm61YwK+bY3VWqF70cCirrzAv/qXgTZlS+bQUyVaT00XU9udGt3VvWc0nR/J+wuT5Fy0=" class="">
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;amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;amp;sdata=BwkPNCDV7hgW7657dmW6cJp5%2FoZaS3Z8EvgvXOj48sQ%3D&amp;amp;reserved=0</a><br class="">
*** EPrints developers Forum: <a href="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%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=3vpuB8xFWvo1iZdpIaVgBSluHbAt3mZdjUicO4zl1%2FU%3D&amp;reserved=0" originalSrc="https://imsva91-ctp.trendmicro.com:443/wis/clicktime/v1/query?url=http%3a%2f%2fforum.eprints.org&umid=ED3A9002-77D9-2105-8B0D-EAF52F62C589&auth=ec34f7633709e8bd85e48c7fc0c92c09c079e558-88bb4b5758c3bc8715cc1eeae54242330f7a7280" shash="OMmGL5fbh/1en2zzUuSJlKnQJylR/QQBQxQ+tMOQ4MNe0A26rbjGg+x9jP+puX4I7d6Ovf2NaGg123+ffuB+H6RspzMzhFr61ZFU57th7kLwUM0rn/qUiLc9peP5UX6aGjEXQUUULwfueJcSLbnt6ioL8UNvbHvXhDQpzL9H8I4=" class="">
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;amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7Ca0afb2f96a014d3ab7e208d62e71485f%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;amp;sdata=eSP4qmrw3akjmUBIJUgW%2Fd%2ByuHlJWcHAImtyHDnlABI%3D&amp;amp;reserved=0</a><br class="">
<br class="">
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" class="">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br class="">
*** Archive: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=PgQAVHUr7SvLtZYyX5ktIcLFraehvigerm1LEFN0gWs%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="pWAVXcEESzrTW8kXzQpMuGHf8oMXjRyaXAs5ozaygbrYdtVBlEwxFM/Y2bqWOs8fszYDByhVE8jxA/grk5xW4y91mEktdhVbZIrwRI4iA6WxtShXIfGazU5jfaPoPC8+D3/v+54m4meh4qwWzO9HuC3lLPjLfDKxfLwCEVvHwAI=" class="">
http://www.eprints.org/tech.php/</a><br class="">
*** EPrints community wiki: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=HM7cqNOsX7h6u0ghnINMnW5wkzZaHsdy2ppUvfmzq0s%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="W2S5CRleBltYnXNCzlwxyx7IOB3MVARrtwrIibkbXqkDShPEtvBnnyIGhczgcmen8lRgWZJlI3kBgeGGIMthOaFqX7/INOe0AIL/ArMTdert9+RXQAQF1FTkIuomuI/1+n50cfu09S+SH5JlMsufgtuKm41mq9yUo3rAnOYXd0Y=" class="">
http://wiki.eprints.org/</a><br class="">
*** EPrints developers Forum: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C808348ea8b584af62c4808d62e72a1df%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=CBbfCR%2BY%2BRNh59TeCaZrbpJoroa8FIAqi2DKY8Pi5H4%3D&amp;reserved=0" originalSrc="http://forum.eprints.org/" shash="byzGrGPgZdBOPD/jD7y22PUha5K2NdG1JQweMw2l+P1GqVEBkzWMLKyi5TowiXT0Tj+qtGpVkw00eyGh0f9h8sjR9Y3HXNuDe5DYjo2+MbvId8lY9V1cQJnJ50gg5/OGEi+utllahIA3hHDpEyMgV78ccIU8h1xSETgcVjA3OEM=" class="">
http://forum.eprints.org/</a><br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
<div class="">
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
--&nbsp;</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
Karl Goetz, &nbsp;Senior Library Officer (Library Systems)</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
University of Tasmania,&nbsp;Private Bag&nbsp;25,&nbsp;Hobart 7001</div>
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
Available Tuesday, Wednesday, Thursday</div>
</div>
</div>
</div>
<br class="">
</div>
<p style="font-size:10pt; line-height:10pt; font-family: Calibri,sans-serif;"><br>
<br>
University of Tasmania Electronic Communications Policy (December, 2014). <br>
This email is confidential, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone outside the intended recipient organisation is prohibited and may be a criminal offence. Please delete if obtained
 in error and email confirmation to the sender. The views expressed in this email are not necessarily the views of the University of Tasmania, unless clearly intended otherwise.
</p>
</body>
</html>