Auto-increment problem has re-emerged
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
Hi Do you have the init script in MySQL/MariaDB ? https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Single_instance... 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@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@biblibre.com> BibLibre, France - software and system maintainer
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@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...
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@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@biblibre.com> BibLibre, France - software and system maintainer _______________________________________________ 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/
Sounds like a perfect candidate for inclusion in misc/devel ;-) On Thu 7 Mar, 2019, 3:52 PM Tomas Cohen Arazi, <tomascohen@gmail.com> 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@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...
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@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@biblibre.com> BibLibre, France - software and system maintainer _______________________________________________ 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/
_______________________________________________ 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/
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@biblibre.com <mailto:fridolin.somers@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...
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@lists.koha-community.org <mailto: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/ >
-- Fridolin SOMERS <fridolin.somers@biblibre.com <mailto:fridolin.somers@biblibre.com>> BibLibre, France - software and system maintainer _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto: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/
_______________________________________________ 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/
participants (4)
-
Bob Birchall -
Fridolin SOMERS -
Indranil Das Gupta -
Tomas Cohen Arazi