[Koha] After Koha update and auto_increment_fix database won't start

[Tomas Cohen Arazi]

You need to first fix the problems, then add the line.

El mar, 28 jun 2022 11:43, Isabel Pineda <isabel.pineda at 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_Solution
> 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 at bugs.koha-community.org>
> Enviado el: martes, 28 de junio de 2022 08:06
> Para: Isabel Pineda <isabel.pineda at ds.edu.sv>
> CC: koha at 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 at 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 at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>