The OAI-PMH Provider currently sets the MySQL connection time zone to +00:00, but doesn't reset it back to the original value. If it's run under the same Plack as other services, the other services may use a connection that has the changed time zone, which results in wrong timestamps being recorded in the database.
Created attachment 74880 [details] [review] Bug 20665 - Reset MySQL connection time zone in the OAI-PMH Provider Test plan: 1.) Run tests in t/db_dependent/Server.t
Created attachment 74882 [details] [review] Bug 20665: Units tests for testing MySQL connection time zone TEST PLAN --------- apply this test patch prove t/db_dependent/OAI/Server.t -- should fail apply the other patch prove t/db_dependent/OAI/Server.t -- should pass run koha qa test tools Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Created attachment 74883 [details] [review] Bug 20665: Reset MySQL connection time zone in the OAI-PMH Provider TEST PLAN --------- apply unit test patch prove t/db_dependent/OAI/Server.t -- should fail apply this patch prove t/db_dependent/OAI/Server.t -- should pass run koha qa test tools Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Created attachment 74889 [details] [review] Bug 20665: Units tests for testing MySQL connection time zone TEST PLAN --------- apply this test patch prove t/db_dependent/OAI/Server.t -- should fail apply the other patch prove t/db_dependent/OAI/Server.t -- should pass run koha qa test tools Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Created attachment 74890 [details] [review] Bug 20665: Reset MySQL connection time zone in the OAI-PMH Provider TEST PLAN --------- apply unit test patch prove t/db_dependent/OAI/Server.t -- should fail apply this patch prove t/db_dependent/OAI/Server.t -- should pass run koha qa test tools Signed-off-by: Mark Tompsett <mtompset@hotmail.com> Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Raising priority.
Pushed to master for 18.05, thanks to everybody involved!