EXAMPLE: Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. 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 Problems found Holds The following ids exist in both tables holds and old_reserves: 1, 2, 3 NOTE: The error refers to: both tables holds and old_reserves There is no holds table. It should read reserves.
Created attachment 84759 [details] [review] Bug 21441: Fix wrong reference to a 'holds' table on system information tab It looks like a typo snuck in on the about page, listing a holds table instead of reserves. To test: - Manually create the same PK (reserve_id) in reserves and old_reserves - Verify that the message on about > system information now correctly lists those tables (not holds and old_reserves)
Good catch!
Created attachment 84766 [details] [review] Bug 21441: Fix wrong reference to a 'holds' table on system information tab It looks like a typo snuck in on the about page, listing a holds table instead of reserves. To test: - Manually create the same PK (reserve_id) in reserves and old_reserves - Verify that the message on about > system information now correctly lists those tables (not holds and old_reserves) Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Created attachment 84879 [details] [review] Bug 21441: Fix wrong reference to a 'holds' table on system information tab It looks like a typo snuck in on the about page, listing a holds table instead of reserves. To test: - Manually create the same PK (reserve_id) in reserves and old_reserves - Verify that the message on about > system information now correctly lists those tables (not holds and old_reserves) Signed-off-by: Owen Leonard <oleonard@myacpl.org> Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Simple one to QA.. Passed
Awesome work all! Pushed to master for 19.05
Pushed to 18.11.x for 18.11.03
backported to 18.05.x for 18.05.09
Pushed to 17.11.x for 17.11.15