Sergei Golubchik added a comment - 2012-03-21 17:17 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.

Rasmus Johansson added a comment - 2012-09-06 06:44 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.

Laurynas Biveinis added a comment - 2012-09-06 08: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.

Rasmus Johansson added a comment - 2012-09-06 08:06 Launchpad bug id: 933959