After Koha update and auto_increment_fix database won't start
Hi. I have just updated Koha from 21.11.06 to 21.11.09. After that I got a warning on the "About Koha" page that some tables have problems with auto_increment, there was a link to this page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I followed the instructions on this page, but when I tried to restart mysql, MariaDB wouldn't start. The error message says: job for mariadb.service failed because the control process exited with error code I looked for solutions, but the only ones that I found included to remove all data from the database directory, and I don't want to do this. Is there any other solution? Thank you very much Isabel Pineda
Hi Isabel, Search for a more precise error in the mysql/mariadb log files. Maybe you have an error in the path? Double check the path you entered in /etc/mysql/my.cnf and the path of the file you created. Regards, Jonathan Le mar. 28 juin 2022 à 15:51, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi.
I have just updated Koha from 21.11.06 to 21.11.09. After that I got a warning on the "About Koha" page that some tables have problems with auto_increment, there was a link to this page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I followed the instructions on this page, but when I tried to restart mysql, MariaDB wouldn't start. The error message says: job for mariadb.service failed because the control process exited with error code
I looked for solutions, but the only ones that I found included to remove all data from the database directory, and I don't want to do this.
Is there any other solution?
Thank you very much Isabel Pineda
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Jonathan. This is the error message in the syslog: mysqld[20008]: error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 24 mysqld[20008]: Fatal error in defaults handling. Program aborted mysqld[20016]: error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 24 mysqld[20016]: Fatal error in defaults handling. Program aborted systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE systemd[1]: mariadb.service: Failed with result 'exit-code'. systemd[1]: Failed to start MariaDB 10.3.35 database server. I followed the instructions in https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solutio... Probably I did something wrong when I added the line init-file=/var/lib/mysql/init-file_koha_fix.sql at /etc/mysql/my.cnf. The instruction says to find the [mysqld] section in the file, but in my my.cnf file there is only one line that says: !includedir /etc/mysql/conf.d For the moment I commented the new line and restarted the database, so everything is working again, but I still have the warning about the auto_increment. Thank you Isabel ---Mensaje original----- De: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Enviado el: martes, 28 de junio de 2022 08:06 Para: Isabel Pineda <isabel.pineda@ds.edu.sv> CC: koha@lists.katipo.co.nz Asunto: Re: [Koha] After Koha update and auto_increment_fix database won't start Hi Isabel, Search for a more precise error in the mysql/mariadb log files. Maybe you have an error in the path? Double check the path you entered in /etc/mysql/my.cnf and the path of the file you created. Regards, Jonathan Le mar. 28 juin 2022 à 15:51, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi.
I have just updated Koha from 21.11.06 to 21.11.09. After that I got a warning on the "About Koha" page that some tables have problems with auto_increment, there was a link to this page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I followed the instructions on this page, but when I tried to restart mysql, MariaDB wouldn't start. The error message says: job for mariadb.service failed because the control process exited with error code
I looked for solutions, but the only ones that I found included to remove all data from the database directory, and I don't want to do this.
Is there any other solution?
Thank you very much Isabel Pineda
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
try adding to line to the following file... then restart /etc/mysql/mariadb.conf.d/50-server.cnf
I followed the instructions in https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solutio... Probably I did something wrong when I added the line init-file=/var/lib/mysql/init-file_koha_fix.sql at /etc/mysql/my.cnf. The instruction says to find the [mysqld] section in the file, but in my my.cnf file there is only one line that says: !includedir /etc/mysql/conf.d
You need to first fix the problems, then add the line. El mar, 28 jun 2022 11:43, Isabel Pineda <isabel.pineda@ds.edu.sv> escribió:
Hi Jonathan.
This is the error message in the syslog: mysqld[20008]: error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 24 mysqld[20008]: Fatal error in defaults handling. Program aborted mysqld[20016]: error: Found option without preceding group in config file: /etc/mysql/my.cnf at line: 24 mysqld[20016]: Fatal error in defaults handling. Program aborted systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE systemd[1]: mariadb.service: Failed with result 'exit-code'. systemd[1]: Failed to start MariaDB 10.3.35 database server.
I followed the instructions in https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Current_Solutio... Probably I did something wrong when I added the line init-file=/var/lib/mysql/init-file_koha_fix.sql at /etc/mysql/my.cnf. The instruction says to find the [mysqld] section in the file, but in my my.cnf file there is only one line that says: !includedir /etc/mysql/conf.d
For the moment I commented the new line and restarted the database, so everything is working again, but I still have the warning about the auto_increment.
Thank you Isabel
---Mensaje original----- De: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Enviado el: martes, 28 de junio de 2022 08:06 Para: Isabel Pineda <isabel.pineda@ds.edu.sv> CC: koha@lists.katipo.co.nz Asunto: Re: [Koha] After Koha update and auto_increment_fix database won't start
Hi Isabel,
Search for a more precise error in the mysql/mariadb log files. Maybe you have an error in the path? Double check the path you entered in /etc/mysql/my.cnf and the path of the file you created.
Regards, Jonathan
Le mar. 28 juin 2022 à 15:51, Isabel Pineda <isabel.pineda@ds.edu.sv> a écrit :
Hi.
I have just updated Koha from 21.11.06 to 21.11.09. After that I got a warning on the "About Koha" page that some tables have problems with auto_increment, there was a link to this page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix I followed the instructions on this page, but when I tried to restart mysql, MariaDB wouldn't start. The error message says: job for mariadb.service failed because the control process exited with error code
I looked for solutions, but the only ones that I found included to
remove all data from the database directory, and I don't want to do this.
Is there any other solution?
Thank you very much Isabel Pineda
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Isabel Pineda -
Jonathan Druart -
Mason James -
Tomas Cohen Arazi