[#MDEV-2834] LP:933959 - Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS

[MDEV-2834] LP:933959 - Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE Created: 2012-03-21 Updated: 2015-02-02 Resolved: 2012-10-04
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	None

Type:

Bug

Priority:

Minor

Reporter:

Elena Stepanova

Assignee:

Sergei Golubchik

Resolution:

Fixed

Votes:

Labels:

Launchpad

Attachments:

LPexportBug933959.xml

Description

Version: '5.3.4-MariaDB-rc-debug-log'
mysqld: protocol.cc:509: void net_end_statement(THD*): Assertion `0' failed.

#8 0xb741d014 in __assert_fail () from /lib/libc.so.6
#9 0x082c4fad in net_end_statement (thd=0x9eebc88) at protocol.cc:509
#10 0x082e2484 in dispatch_command (command=COM_QUERY, thd=0x9eebc88,
packet=0x9eede31 "SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES", packet_length=51)
at sql_parse.cc:1620
#11 0x082e08df in do_command (thd=0x9eebc88) at sql_parse.cc:923
#12 0x082dd865 in handle_one_connection (arg=0x9eebc88) at sql_connect.cc:1193
#13 0xb76abb25 in start_thread () from /lib/libpthread.so.0

Query (0x9f2e398): SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES
Connection ID (thread ID): 4
Status: NOT_KILLED

bzr version-info
revision-id: <email address hidden>
date: 2012-02-16 20:15:57 +0400
build-date: 2012-02-17 07:40:46 +0400
revno: 3424

Also reproducible on MariaDB 5.1 and 5.2.
Could not reproduce on 5.5, but the test is not deterministic., so there is no guarantee. It is, however, noticeable, that the flow works much slower on 5.5

MTR test case (please note that the number of attempts is set in the $run variable):

--source include/have_innodb.inc

CREATE TABLE t1 (
a DATE,
b TIME,
c VARCHAR(1),
d INT
) ENGINE=InnoDB;
--connect (con1,127.0.0.1,root,,test)
--connect (con2,127.0.0.1,root,,test)
let $run=1000;
--disable_query_log
--disable_result_log
while ($run)
{
--echo # $run attempts left
--connection con1
--send
ALTER TABLE t1 ADD KEY(d);
--connection con2
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES;
--connection con1
--reap
ALTER TABLE t1 DROP KEY d;
--dec $run
}

End of test case

Comments

Comment by Sergei Golubchik [ 2012-03-21 ]

Re: Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE
it's xtradb bug. eventually in the test case it tries to put some garbage into a row of the I_S.INNODB_SYS_INDEXES table, that fails, and the error is propagated all the way up. The assertion in the server fires because the error is not sent to the user. I'll fix that - the server will send a generic error if an I_S plugin failed without reporting an error. But the real bug is trying to put garbage into INNODB_SYS_INDEXES. This should've not happened in the first place.

Comment by Rasmus Johansson (Inactive) [ 2012-09-06 ]

Re: Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE
Couldn't reproduce with PS 5.5

sudo ./mysql-test-run.pl --vardir=$HOME/mysql --extern "socket=/run/mysqld/mysqld.sock" --extern user=root --extern password=test t/933959.test
defined(@array) is deprecated at lib/mtr_cases.pm line 338.
(Maybe you should just omit the defined()?)
defined(@array) is deprecated at ./mysql-test-run.pl line 519.
(Maybe you should just omit the defined()?)
Logging: ./mysql-test-run.pl --vardir=/home/raghu/mysql --extern socket=/run/mysqld/mysqld.sock --extern user=root --extern password=test t/933959.test
MySQL Version 5.5.27
Checking supported features...

skipping ndbcluster
skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /home/raghu/mysql
Using server port 40822

==============================================================================

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as root will cause some tests to be skipped
CREATE TABLE t1 (
a DATE,
b TIME,
c VARCHAR(1),
d INT
) ENGINE=InnoDB;

1000 attempts left
999 attempts left
998 attempts left
997 attempts left
996 attempts left
995 attempts left
994 attempts left
993 attempts left
992 attempts left
991 attempts left
990 attempts left
989 attempts left
988 attempts left
987 attempts left
986 attempts left
985 attempts left
984 attempts left
983 attempts left
982 attempts left
981 attempts left
980 attempts left
979 attempts left
978 attempts left
977 attempts left
976 attempts left
975 attempts left
974 attempts left
973 attempts left
972 attempts left
971 attempts left
970 attempts left
969 attempts left
968 attempts left
967 attempts left
966 attempts left
965 attempts left
964 attempts left
963 attempts left
962 attempts left
961 attempts left
960 attempts left
959 attempts left
958 attempts left
957 attempts left
956 attempts left
955 attempts left
954 attempts left
953 attempts left
952 attempts left
951 attempts left
950 attempts left
949 attempts left
948 attempts left
947 attempts left
946 attempts left
945 attempts left
944 attempts left
943 attempts left
942 attempts left
941 attempts left
940 attempts left
939 attempts left
938 attempts left
937 attempts left
936 attempts left
935 attempts left
934 attempts left
933 attempts left
932 attempts left
931 attempts left
930 attempts left
929 attempts left
928 attempts left
927 attempts left
926 attempts left
925 attempts left
924 attempts left
923 attempts left
922 attempts left
921 attempts left
920 attempts left
919 attempts left
918 attempts left
917 attempts left
916 attempts left
915 attempts left
914 attempts left
913 attempts left
912 attempts left
911 attempts left
910 attempts left
909 attempts left
908 attempts left
907 attempts left
906 attempts left
905 attempts left
904 attempts left
903 attempts left
902 attempts left
901 attempts left
900 attempts left
899 attempts left
898 attempts left
897 attempts left
896 attempts left
895 attempts left
894 attempts left
893 attempts left
892 attempts left
891 attempts left
890 attempts left
889 attempts left
888 attempts left
887 attempts left
886 attempts left
885 attempts left
884 attempts left
883 attempts left
882 attempts left
881 attempts left
880 attempts left
879 attempts left
878 attempts left
877 attempts left
876 attempts left
875 attempts left
874 attempts left
873 attempts left
872 attempts left
871 attempts left
870 attempts left
869 attempts left
868 attempts left
867 attempts left
866 attempts left
865 attempts left
864 attempts left
863 attempts left
862 attempts left
861 attempts left
860 attempts left
859 attempts left
858 attempts left
857 attempts left
856 attempts left
855 attempts left
854 attempts left
853 attempts left
852 attempts left
851 attempts left
850 attempts left
849 attempts left
848 attempts left
847 attempts left
846 attempts left
845 attempts left
844 attempts left
843 attempts left
842 attempts left
841 attempts left
840 attempts left
839 attempts left
838 attempts left
837 attempts left
836 attempts left
835 attempts left
834 attempts left
833 attempts left
832 attempts left
831 attempts left
830 attempts left
829 attempts left
828 attempts left
827 attempts left
826 attempts left
825 attempts left
824 attempts left
823 attempts left
822 attempts left
821 attempts left
820 attempts left
819 attempts left
818 attempts left
817 attempts left
816 attempts left
815 attempts left
814 attempts left
813 attempts left
812 attempts left
811 attempts left
810 attempts left
809 attempts left
808 attempts left
807 attempts left
806 attempts left
805 attempts left
804 attempts left
803 attempts left
802 attempts left
801 attempts left
800 attempts left
799 attempts left
798 attempts left
797 attempts left
796 attempts left
795 attempts left
794 attempts left
793 attempts left
792 attempts left
791 attempts left
790 attempts left
789 attempts left
788 attempts left
787 attempts left
786 attempts left
785 attempts left
784 attempts left
783 attempts left
782 attempts left
781 attempts left
780 attempts left
779 attempts left
778 attempts left
777 attempts left
776 attempts left
775 attempts left
774 attempts left
773 attempts left
772 attempts left
771 attempts left
770 attempts left
769 attempts left
768 attempts left
767 attempts left
766 attempts left
765 attempts left
764 attempts left
763 attempts left
762 attempts left
761 attempts left
760 attempts left
759 attempts left
758 attempts left
757 attempts left
756 attempts left
755 attempts left
754 attempts left
753 attempts left
752 attempts left
751 attempts left
750 attempts left
749 attempts left
748 attempts left
747 attempts left
746 attempts left
745 attempts left
744 attempts left
743 attempts left
742 attempts left
741 attempts left
740 attempts left
739 attempts left
738 attempts left
737 attempts left
736 attempts left
735 attempts left
734 attempts left
733 attempts left
732 attempts left
731 attempts left
730 attempts left
729 attempts left
728 attempts left
727 attempts left
726 attempts left
725 attempts left
724 attempts left
723 attempts left
722 attempts left
721 attempts left
720 attempts left
719 attempts left
718 attempts left
717 attempts left
716 attempts left
715 attempts left
714 attempts left
713 attempts left
712 attempts left
711 attempts left
710 attempts left
709 attempts left
708 attempts left
707 attempts left
706 attempts left
705 attempts left
704 attempts left
703 attempts left
702 attempts left
701 attempts left
700 attempts left
699 attempts left
698 attempts left
697 attempts left
696 attempts left
695 attempts left
694 attempts left
693 attempts left
692 attempts left
691 attempts left
690 attempts left
689 attempts left
688 attempts left
687 attempts left
686 attempts left
685 attempts left
684 attempts left
683 attempts left
682 attempts left
681 attempts left
680 attempts left
679 attempts left
678 attempts left
677 attempts left
676 attempts left
675 attempts left
674 attempts left
673 attempts left
672 attempts left
671 attempts left
670 attempts left
669 attempts left
668 attempts left
667 attempts left
666 attempts left
665 attempts left
664 attempts left
663 attempts left
662 attempts left
661 attempts left
660 attempts left
659 attempts left
658 attempts left
657 attempts left
656 attempts left
655 attempts left
654 attempts left
653 attempts left
652 attempts left
651 attempts left
650 attempts left
649 attempts left
648 attempts left
647 attempts left
646 attempts left
645 attempts left
644 attempts left
643 attempts left
642 attempts left
641 attempts left
640 attempts left
639 attempts left
638 attempts left
637 attempts left
636 attempts left
635 attempts left
634 attempts left
633 attempts left
632 attempts left
631 attempts left
630 attempts left
629 attempts left
628 attempts left
627 attempts left
626 attempts left
625 attempts left
624 attempts left
623 attempts left
622 attempts left
621 attempts left
620 attempts left
619 attempts left
618 attempts left
617 attempts left
616 attempts left
615 attempts left
614 attempts left
613 attempts left
612 attempts left
611 attempts left
610 attempts left
609 attempts left
608 attempts left
607 attempts left
606 attempts left
605 attempts left
604 attempts left
603 attempts left
602 attempts left
601 attempts left
600 attempts left
599 attempts left
598 attempts left
597 attempts left
596 attempts left
595 attempts left
594 attempts left
593 attempts left
592 attempts left
591 attempts left
590 attempts left
589 attempts left
588 attempts left
587 attempts left
586 attempts left
585 attempts left
584 attempts left
583 attempts left
582 attempts left
581 attempts left
580 attempts left
579 attempts left
578 attempts left
577 attempts left
576 attempts left
575 attempts left
574 attempts left
573 attempts left
572 attempts left
571 attempts left
570 attempts left
569 attempts left
568 attempts left
567 attempts left
566 attempts left
565 attempts left
564 attempts left
563 attempts left
562 attempts left
561 attempts left
560 attempts left
559 attempts left
558 attempts left
557 attempts left
556 attempts left
555 attempts left
554 attempts left
553 attempts left
552 attempts left
551 attempts left
550 attempts left
549 attempts left
548 attempts left
547 attempts left
546 attempts left
545 attempts left
544 attempts left
543 attempts left
542 attempts left
541 attempts left
540 attempts left
539 attempts left
538 attempts left
537 attempts left
536 attempts left
535 attempts left
534 attempts left
533 attempts left
532 attempts left
531 attempts left
530 attempts left
529 attempts left
528 attempts left
527 attempts left
526 attempts left
525 attempts left
524 attempts left
523 attempts left
522 attempts left
521 attempts left
520 attempts left
519 attempts left
518 attempts left
517 attempts left
516 attempts left
515 attempts left
514 attempts left
513 attempts left
512 attempts left
511 attempts left
510 attempts left
509 attempts left
508 attempts left
507 attempts left
506 attempts left
505 attempts left
504 attempts left
503 attempts left
502 attempts left
501 attempts left
500 attempts left
499 attempts left
498 attempts left
497 attempts left
496 attempts left
495 attempts left
494 attempts left
493 attempts left
492 attempts left
491 attempts left
490 attempts left
489 attempts left
488 attempts left
487 attempts left
486 attempts left
485 attempts left
484 attempts left
483 attempts left
482 attempts left
481 attempts left
480 attempts left
479 attempts left
478 attempts left
477 attempts left
476 attempts left
475 attempts left
474 attempts left
473 attempts left
472 attempts left
471 attempts left
470 attempts left
469 attempts left
468 attempts left
467 attempts left
466 attempts left
465 attempts left
464 attempts left
463 attempts left
462 attempts left
461 attempts left
460 attempts left
459 attempts left
458 attempts left
457 attempts left
456 attempts left
455 attempts left
454 attempts left
453 attempts left
452 attempts left
451 attempts left
450 attempts left
449 attempts left
448 attempts left
447 attempts left
446 attempts left
445 attempts left
444 attempts left
443 attempts left
442 attempts left
441 attempts left
440 attempts left
439 attempts left
438 attempts left
437 attempts left
436 attempts left
435 attempts left
434 attempts left
433 attempts left
432 attempts left
431 attempts left
430 attempts left
429 attempts left
428 attempts left
427 attempts left
426 attempts left
425 attempts left
424 attempts left
423 attempts left
422 attempts left
421 attempts left
420 attempts left
419 attempts left
418 attempts left
417 attempts left
416 attempts left
415 attempts left
414 attempts left
413 attempts left
412 attempts left
411 attempts left
410 attempts left
409 attempts left
408 attempts left
407 attempts left
406 attempts left
405 attempts left
404 attempts left
403 attempts left
402 attempts left
401 attempts left
400 attempts left
399 attempts left
398 attempts left
397 attempts left
396 attempts left
395 attempts left
394 attempts left
393 attempts left
392 attempts left
391 attempts left
390 attempts left
389 attempts left
388 attempts left
387 attempts left
386 attempts left
385 attempts left
384 attempts left
383 attempts left
382 attempts left
381 attempts left
380 attempts left
379 attempts left
378 attempts left
377 attempts left
376 attempts left
375 attempts left
374 attempts left
373 attempts left
372 attempts left
371 attempts left
370 attempts left
369 attempts left
368 attempts left
367 attempts left
366 attempts left
365 attempts left
364 attempts left
363 attempts left
362 attempts left
361 attempts left
360 attempts left
359 attempts left
358 attempts left
357 attempts left
356 attempts left
355 attempts left
354 attempts left
353 attempts left
352 attempts left
351 attempts left
350 attempts left
349 attempts left
348 attempts left
347 attempts left
346 attempts left
345 attempts left
344 attempts left
343 attempts left
342 attempts left
341 attempts left
340 attempts left
339 attempts left
338 attempts left
337 attempts left
336 attempts left
335 attempts left
334 attempts left
333 attempts left
332 attempts left
331 attempts left
330 attempts left
329 attempts left
328 attempts left
327 attempts left
326 attempts left
325 attempts left
324 attempts left
323 attempts left
322 attempts left
321 attempts left
320 attempts left
319 attempts left
318 attempts left
317 attempts left
316 attempts left
315 attempts left
314 attempts left
313 attempts left
312 attempts left
311 attempts left
310 attempts left
309 attempts left
308 attempts left
307 attempts left
306 attempts left
305 attempts left
304 attempts left
303 attempts left
302 attempts left
301 attempts left
300 attempts left
299 attempts left
298 attempts left
297 attempts left
296 attempts left
295 attempts left
294 attempts left
293 attempts left
292 attempts left
291 attempts left
290 attempts left
289 attempts left
288 attempts left
287 attempts left
286 attempts left
285 attempts left
284 attempts left
283 attempts left
282 attempts left
281 attempts left
280 attempts left
279 attempts left
278 attempts left
277 attempts left
276 attempts left
275 attempts left
274 attempts left
273 attempts left
272 attempts left
271 attempts left
270 attempts left
269 attempts left
268 attempts left
267 attempts left
266 attempts left
265 attempts left
264 attempts left
263 attempts left
262 attempts left
261 attempts left
260 attempts left
259 attempts left
258 attempts left
257 attempts left
256 attempts left
255 attempts left
254 attempts left
253 attempts left
252 attempts left
251 attempts left
250 attempts left
249 attempts left
248 attempts left
247 attempts left
246 attempts left
245 attempts left
244 attempts left
243 attempts left
242 attempts left
241 attempts left
240 attempts left
239 attempts left
238 attempts left
237 attempts left
236 attempts left
235 attempts left
234 attempts left
233 attempts left
232 attempts left
231 attempts left
230 attempts left
229 attempts left
228 attempts left
227 attempts left
226 attempts left
225 attempts left
224 attempts left
223 attempts left
222 attempts left
221 attempts left
220 attempts left
219 attempts left
218 attempts left
217 attempts left
216 attempts left
215 attempts left
214 attempts left
213 attempts left
212 attempts left
211 attempts left
210 attempts left
209 attempts left
208 attempts left
207 attempts left
206 attempts left
205 attempts left
204 attempts left
203 attempts left
202 attempts left
201 attempts left
200 attempts left
199 attempts left
198 attempts left
197 attempts left
196 attempts left
195 attempts left
194 attempts left
193 attempts left
192 attempts left
191 attempts left
190 attempts left
189 attempts left
188 attempts left
187 attempts left
186 attempts left
185 attempts left
184 attempts left
183 attempts left
182 attempts left
181 attempts left
180 attempts left
179 attempts left
178 attempts left
177 attempts left
176 attempts left
175 attempts left
174 attempts left
173 attempts left
172 attempts left
171 attempts left
170 attempts left
169 attempts left
168 attempts left
167 attempts left
166 attempts left
165 attempts left
164 attempts left
163 attempts left
162 attempts left
161 attempts left
160 attempts left
159 attempts left
158 attempts left
157 attempts left
156 attempts left
155 attempts left
154 attempts left
153 attempts left
152 attempts left
151 attempts left
150 attempts left
149 attempts left
148 attempts left
147 attempts left
146 attempts left
145 attempts left
144 attempts left
143 attempts left
142 attempts left
141 attempts left
140 attempts left
139 attempts left
138 attempts left
137 attempts left
136 attempts left
135 attempts left
134 attempts left
133 attempts left
132 attempts left
131 attempts left
130 attempts left
129 attempts left
128 attempts left
127 attempts left
126 attempts left
125 attempts left
124 attempts left
123 attempts left
122 attempts left
121 attempts left
120 attempts left
119 attempts left
118 attempts left
117 attempts left
116 attempts left
115 attempts left
114 attempts left
113 attempts left
112 attempts left
111 attempts left
110 attempts left
109 attempts left
108 attempts left
107 attempts left
106 attempts left
105 attempts left
104 attempts left
103 attempts left
102 attempts left
101 attempts left
100 attempts left
99 attempts left
98 attempts left
97 attempts left
96 attempts left
95 attempts left
94 attempts left
93 attempts left
92 attempts left
91 attempts left
90 attempts left
89 attempts left
88 attempts left
87 attempts left
86 attempts left
85 attempts left
84 attempts left
83 attempts left
82 attempts left
81 attempts left
80 attempts left
79 attempts left
78 attempts left
77 attempts left
76 attempts left
75 attempts left
74 attempts left
73 attempts left
72 attempts left
71 attempts left
70 attempts left
69 attempts left
68 attempts left
67 attempts left
66 attempts left
65 attempts left
64 attempts left
63 attempts left
62 attempts left
61 attempts left
60 attempts left
59 attempts left
58 attempts left
57 attempts left
56 attempts left
55 attempts left
54 attempts left
53 attempts left
52 attempts left
51 attempts left
50 attempts left
49 attempts left
48 attempts left
47 attempts left
46 attempts left
45 attempts left
44 attempts left
43 attempts left
42 attempts left
41 attempts left
40 attempts left
39 attempts left
38 attempts left
37 attempts left
36 attempts left
35 attempts left
34 attempts left
33 attempts left
32 attempts left
31 attempts left
30 attempts left
29 attempts left
28 attempts left
27 attempts left
26 attempts left
25 attempts left
24 attempts left
23 attempts left
22 attempts left
21 attempts left
20 attempts left
19 attempts left
18 attempts left
17 attempts left
16 attempts left
15 attempts left
14 attempts left
13 attempts left
12 attempts left
11 attempts left
10 attempts left
9 attempts left
8 attempts left
7 attempts left
6 attempts left
5 attempts left
4 attempts left
3 attempts left
2 attempts left
1 attempts left
main.933959 [ pass ] 48282
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 48.282 of 56 seconds executing testcases

Completed: All 1 tests were successful.

Comment by Laurynas Biveinis [ 2012-09-06 ]

Re: Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE
If, as Sergei writes, "the real bug is trying to put garbage into INNODB_SYS_INDEXES", then we cannot mark it as invalid because this testcase passes. It's not deterministic and the code might have been perturbed enough to hide it. Setting to Incomplete for now.

Comment by Rasmus Johansson (Inactive) [ 2012-09-06 ]

Launchpad bug id: 933959

Generated at Thu Feb 08 06:44:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-2834] LP:933959 - Assertion `0' failed in net_end_statement(THD*) on concurrent SELECT FROM I_S.INNODB_SYS_INDEXES and ALTER TABLE Created: 2012-03-21 Updated: 2015-02-02 Resolved: 2012-10-04