[MDEV-33229] [Draft] "InnoDB: Records in wrong order" with nopad collation and XA Created: 2024-01-12  Updated: 2024-01-12

Status: Open
Project: MariaDB Server
Component/s: Character Sets, Storage Engine - InnoDB, XA
Affects Version/s: 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
Fix Version/s: 10.11, 11.0, 11.1, 11.2, 11.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Needs to be finalized. Reproducible reliably on 10.11+ with the test below, but on some reason does not get converted into MTR (even though the test is single-threaded). Possibly it's related to file locations in load data / outfile, or client character sets, or some other usual obstacles.

10.11 d0c80c211c1fe3370b68be540bb9113028c6746f

2024-01-12 21:07:57 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000000911; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:07:59 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:07:59 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:08:02 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000bce; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:04 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:04 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000000bcd; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:08:07 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:10 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:13 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:18 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002e97; asc     . ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002da2; asc     - ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 0000000028c7; asc     ( ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002e97; asc     . ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:08:22 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002da2; asc     - ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 0000000028c7; asc     ( ;;
 
2024-01-12 21:08:23 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:23 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:23 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:23 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:27 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9c; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000000a9d; asc       ;;
 
2024-01-12 21:08:31 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 000000001de8; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: SQL NULL;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 0; hex ; asc ;;
 4: len 6; hex 800000000000; asc       ;;
 5: len 6; hex 0000000020d9; asc       ;;
 
2024-01-12 21:08:32 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:32 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:32 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 3: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 0000000020d9; asc       ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 6; hex 800000000000; asc       ;;
 1: SQL NULL;
 2: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 3: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 4: len 0; hex ; asc ;;
 5: SQL NULL;
 6: SQL NULL;
 7: len 6; hex 000000000a9c; asc       ;;
 
2024-01-12 21:08:33 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002e97; asc     . ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 000000000912; asc       ;;
 
2024-01-12 21:08:33 7 [ERROR] InnoDB: Records in wrong order
 
InnoDB: previous record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 00573f460154203f563f3f3f4d062a253fdaa4573f3f2a3f3f423f4a763f; asc  W?F T ?V???M *%?  W??*??B?Jv?; (total 67 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 202020202020202020202020202020202020202020202020202020202020; asc                               ; (total 64 bytes);
 7: len 6; hex 000000002da2; asc     - ;;
 
InnoDB: record PHYSICAL RECORD: n_fields 8; compact format; info bits 0
 0: len 30; hex 000f423279713f3f3f3f2f3f333f203f3f3f3f7a2831043f5a293f553d3f; asc   B2yq????/?3? ????z(1 ?Z)?U=?; (total 64 bytes);
 1: len 6; hex 800000000000; asc       ;;
 2: SQL NULL;
 3: len 0; hex ; asc ;;
 4: SQL NULL;
 5: SQL NULL;
 6: len 30; hex 1c3f023f353f5c3f3f3f3f75c59d3d333f3f783f3f1a3f3f143f3f3f3f37; asc  ? ?5?\????u  =3??x?? ?? ????7; (total 68 bytes);
 7: len 6; hex 0000000028c7; asc     ( ;;

randgen b34739b022e945299650a8d985a239f42f0d0acb

perl ./run.pl --seed=1705017803 --nometadata-reload --compatibility=10.11 --gendata=advanced --duration=30 --mysqld=--max-statement-time=5 --threads=1 --mysqld=--character-set-server=utf8 --mysqld=--collation-server=utf8_nopad_bin --engine=InnoDB --scenario=Standard --grammar=conf/yy/xa.yy --grammar=conf/yy/bulk_insert.yy --basedir=/data/bld/10.11-asan --vardir=/dev/shm/var


Generated at Thu Feb 08 10:37:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.