[Koha] DBMS auto increment

[Scott Owen]

Thank you.

Is there a way to verify that the "fix" is working ?
Just watch for data errors ?



On Mon, Sep 27, 2021 at 2:19 AM Katrin Fischer <katrin.fischer.83 at web.de>
wrote:

> Hi Scott,
>
> yes, the wiki page has all the current information and suggestions on
> how to solve this issue. It also notes the DBMS versions where the
> problem will be fixed.
>
> The easiest way to resolve the problem is deleting the doubled up
> entries from the old* and deleted* tables. Then you can implement the
> fix and restart your DBMS server to reset the primary keys to the
> correct values. This will prevent the creation of more doubled up IDs
> between the tables.
>
> Hope this helps,
>
> Katrin
>
> On 22.09.21 21:37, Scott Owen wrote:
> > Hi All,
> >
> > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
> >
> >
> > Is this still the best procedure when getting the following error ?
> >
> >
> > ************************************************
> >
> > You should not ignore this warning.
> >
> > The problem is that InnoDB does not keep auto_increment across SQL server
> > restarts (it is only set in memory). So on server startup the
> > auto_increment values are set to max(table.id)+1.
> >
> > To know how to avoid this problem see the related wiki page: DBMS auto
> > increment fix<
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
> > Problems foundCheckouts
> >
> > The following ids exist in both tables issues and old_issues:
> >
> > 4782, 4781
> >
> >
> > ************************************************
> >
> > Any sql to clean things up in the two tables ?
> > _______________________________________________
> >
> > Koha mailing listhttp://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
>