[Koha-devel] Auto-increment problem has re-emerged

[Bob Birchall]

We've upgraded to MariaDB 10.3.13.
Thanks Fridolin, thanks Tomas.
Bob

On 7/3/19 9:22 pm, Tomas Cohen Arazi wrote:
> Yesterday we noticed the sysadmin made a typo on the file and it was 
> causing the init file to be skipped silently on startup. I wrote a 
> small script to avoid human errors
>
> I suggest you try that SQL file right now and see if it loads.
>
> I can share that simple script.
>
> El jue., 7 de marzo de 2019 05:02, Fridolin SOMERS 
> <fridolin.somers at biblibre.com <mailto:fridolin.somers at biblibre.com>> 
> escribió:
>
>     Hi
>
>     Do you have the init script in MySQL/MariaDB ?
>
>     https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Single_instance_setup
>
>     We have it under Xenial and no problem anymore with autoincrements.
>
>     Regards,
>
>     Le 27/02/2019 à 06:24, Bob Birchall a écrit :
>     > We're running multiple instances of Koha 18.05.06 installed on
>     stretch
>     > from packages.
>     >
>     > In recent days we've struck the auto-increment problem several
>     times, in
>     > relation to issues / old_issues. Known fixes are applied.
>     >
>     > Is anyone else experiencing this?
>     >
>     > Thanks,
>     > Bob
>     >
>     > Calyx
>     > _______________________________________________
>     > Koha-devel mailing list
>     > Koha-devel at lists.koha-community.org
>     <mailto:Koha-devel at 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/
>     >
>
>     -- 
>     Fridolin SOMERS <fridolin.somers at biblibre.com
>     <mailto:fridolin.somers at biblibre.com>>
>     BibLibre, France - software and system maintainer
>     _______________________________________________
>     Koha-devel mailing list
>     Koha-devel at lists.koha-community.org
>     <mailto:Koha-devel at 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/
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20190329/a563e80e/attachment.html>