Bug 29502 - Possibility of changing the database engine to avoid errors in autoincremental fields
Summary: Possibility of changing the database engine to avoid errors in autoincrementa...
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: 20.05
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-17 13:05 UTC by Jonathan Cuéllar
Modified: 2022-06-06 20:25 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Cuéllar 2021-11-17 13:05:13 UTC
Hi,

A few days ago a reboot of the DB server was carried out due to a failure, this caused Koha to present a failure in incremental fields and they began to duplicate record id, specifically in reservations. Is there a possibility to change the database engine to avoid errors of autoincremental fields when failures happen in the DB server?

Thanks for the help.

Jonathan Cúellar
Comment 1 Jonathan Druart 2021-11-18 09:05:18 UTC
You will find the relevant info on this wiki page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix