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 ?
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@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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 (2)
-
Katrin Fischer -
Scott Owen