Hi Jonathan,
I appreciate what you’re trying to do here, so I’m going to take a few minutes now to check through all of these links. I’ve been dealing with this issue on and off over the years due to our local use of OPTIMIZE: https://bugs.mysql.com/bug.php?id=18274. I hadn’t realized that the auto_increment reset happens on server restarts as well until you mentioned it on the list. In any case, I’m glad to see your interest in this, because this really is a frustrating issue! I still don’t understand why you’d have data lost, because you should get a fatal software error before anything is actually lost, and that should give you the opportunity to manually repair the increment counter and problematic IDs, but… I haven’t yet read all the links, so I’ll keep reading. Regardless of this fine point, I still think it is something worth fixing, so thanks again for your work on this one! I’ll let you know what I think/find after reviewing the links… David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595 From: koha-devel-boun...@lists.koha-community.org [mailto:koha-devel-boun...@lists.koha-community.org] On Behalf Of Jonathan Druart Sent: Thursday, 20 July 2017 1:39 AM To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] AUTO_INCREMENT fix - prevent data lost I did not get confirmation, so I am not sure you all understand how important is this fix. We are going to fix properly and globally a long standing issue, and prevent data lost. I *really* want to see some of you to test this trick and confirm me that you agree on the solution and we can advertise it on the general Koha ML. On Wed, 12 Jul 2017 at 15:11 Jonathan Druart <jonathan.dru...@bugs.koha-community.org <mailto:jonathan.dru...@bugs.koha-community.org> > wrote: Hi devs, Please review and test https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I have added a ref from the Koha on Debian wiki page https://wiki.koha-community.org/wiki/Koha_on_Debian#Further_Configuration It sounds like I should add it somewhere more visible, but do not find where, any ideas? See also bug 18931 where I would like to add a warning on the about page if data are corrupted. Please review quickly, that way we can share the tips on the general mailing list. Cheers, Jonathan
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
