[Koha-bugs] [Bug 14598] itemtype is not set on statistics by C4::Circulation:: AddReturn

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14598

Gwendal JONCOUR <gwendal.joncour at univ-rennes2.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gwendal.joncour at univ-rennes
                   |                            |2.fr

--- Comment #135 from Gwendal JONCOUR <gwendal.joncour at univ-rennes2.fr> ---
Here in Université Rennes 2, France, we tried on a dump of our production, with
statistics from 2012 to now. For the numbers, we have approximately 2.4M lines
in statistics table (300K distinct itemnumbers from return stats with no
itemtype set), 900K lines in items, 46K in deleteditems, 500K lines in
biblioitems and 70K in deletedbiblioitems.

Despite days running the updatedatabase.pl script, the first query of the
16.06.00.039 update keep stuck in "sending data" state. We tried to upgrade our
test server to equivalent to our production server (12 cores and 48GB of RAM)
with no more result. We tried also to reduce our statistics to keep only those
from 2015 to now but the query keep stuck.

Is there anybody who succeed to apply the 16.06.00.039 update script to a
production equivalent database ?

-- 
You are receiving this mail because:
You are watching all bug changes.