[MDEV-33229] [Draft] "InnoDB: Records in wrong order" with nopad collation and XA - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
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
Component/s: Character Sets, Storage Engine - InnoDB, XA
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

Attachments

Activity

People

Assignee:: Elena Stepanova

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2024-01-12 19:15

Updated:: 2024-01-12 19:19

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.