>From Koha/Database.pm
89 RaiseError => $ENV{DEBUG} ? 1 : 0,
=> We do not raise SQL errors.
The insert into old_issues fails, but the delete from issues is done anyway.
On Wed, 19 Jul 2017 at 20:43 David Cook <dc...@prosentient.com.au> wrote:
> 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 <02%2092%2012%2008%2099>
>
> Direct: 02 8005 0595 <02%2080%2005%2005%2095>
>
>
>
> *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> 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/
