Sergei Golubchik added a comment - 2024-02-11 19:16 Test case: --- a/plugin/type_uuid/mysql-test/type_uuid/order.test +++ b/plugin/type_uuid/mysql-test/type_uuid/order.test @@ -16,6 +16,7 @@ let $datadir= `select @@datadir`; select * from t2 order by b; select * from t2 order by a; show create table t2; +repair table t2; explain select * from t1 left join t2 on (t1.a=t2.a); --sorted_result

Alexander Barkov added a comment - 2024-02-13 08:04 This MTR test demonstrates the problem: source include/have_sequence.inc; let $datadir= ` select @@datadir`;   --copy_file $MTR_SUITE_DIR/std_data/mdev-29959.frm $datadir/test/t2.frm --copy_file $MTR_SUITE_DIR/std_data/mdev-29959.MYI $datadir/test/t2.MYI --copy_file $MTR_SUITE_DIR/std_data/mdev-29959.MYD $datadir/test/t2.MYD select * from t2 order by b limit 3; select * from t2 order by b desc limit 3; repair table t2; select * from t2 order by b limit 3; select * from t2 order by b desc limit 3; drop table t2; select * from t2 order by b limit 3; a b 00001234-5566-0777-0888-99aabbccddee 0 10101234-5566-0777-8888-99aabbccddee 1 00201234-5566-0777-c888-99aabbccddee 2 select * from t2 order by b desc limit 3; a b 16301234-5566-f777-e888-99aabbccddee 63 06201234-5566-f777-c888-99aabbccddee 62 16101234-5566-f777-8888-99aabbccddee 61 repair table t2; Table Op Msg_type Msg_text test.t2 repair status OK select * from t2 order by b limit 3; a b 99aabbcc-ddee-0888-0777-556600001234 0 10101234-5566-0777-8888-99aabbccddee 1 00201234-5566-0777-c888-99aabbccddee 2 select * from t2 order by b desc limit 3; a b 99aabbcc-ddee-e888-f777-556616301234 63 99aabbcc-ddee-c888-f777-556606201234 62 99aabbcc-ddee-8888-f777-556616101234 61 drop table t2; The data after REPAIR is broken.

Alexander Barkov added a comment - 2024-02-15 14:23 serg , please review a patch: https://github.com/MariaDB/server/commit/f22662c36b14ce0fb4c7343b1950fd34a29a99f6 Thanks.

Mads Jon Nielsen added a comment - 2024-10-02 06:34 - edited I've just experienced a very weird error in production, and don't know how we ended up in this state. We noticed our rowbased replication stopped, and reported it couldn't update a row, because the row didn't exist on that mariadb instance, which it 100% do :smile: It looks like our primary key of the type UUID has ended up in some very weird state. Do you guys think my issues are related to this issue? MariaDB [game-configuration]> SELECT * FROM providers; +--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+ | id | created_at | updated_at | name | slug | is_active | +--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+ | 1ee24792-8647-6f3e-8061-0242ac12006b | 2023-07-17 08:08:48.240570 | 2023-07-17 08:08:48.240570 | <masked> | <masked> | 1 | | 1ee24792-8699-6424-b01e-0242ac12006b | 2023-07-17 08:08:48.271552 | 2023-07-17 08:08:48.271552 | <masked> | <masked> | 1 | | 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 | +--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+ 3 rows in set (0.003 sec)   MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b'; Empty set (0.000 sec)   MariaDB [game-configuration]> CHECK TABLE providers EXTENDED; +------------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------------------+-------+----------+----------+ | game-configuration.providers | check | status | OK | +------------------------------+-------+----------+----------+ 1 row in set (0.000 sec)   MariaDB [game-configuration]> ALTER TABLE providers CHANGE COLUMN id id CHAR(36); Query OK, 3 rows affected (0.012 sec) Records: 3 Duplicates: 0 Warnings: 0   MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b'; +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ | id | created_at | updated_at | name | slug | is_active | +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ | 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 | +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ 1 row in set (0.000 sec)   MariaDB [game-configuration]> ALTER TABLE providers CHANGE COLUMN id id UUID; Query OK, 3 rows affected (0.011 sec) Records: 3 Duplicates: 0 Warnings: 0   MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b'; +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ | id | created_at | updated_at | name | slug | is_active | +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ | 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 | +--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+ 1 row in set (0.000 sec)