Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25426

Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status from my_ok from multi_delete::send_eof

    XMLWordPrintable

    Details

      Description

      Lightly sporadic, repeat until crashes (usually ~2 attempts).
      Apologies for the longer text strings, but attempts are replacing it with a REPEAT('a',...) or simplifying them failed.

      # mysqld options required for replay: --log-bin 
      DROP DATABASE test;
      CREATE DATABASE test;
      USE test;
      SET @@SESSION.sql_mode='',@@GLOBAL.binlog_cache_size=256,@@GLOBAL.max_binlog_cache_size=18;
      CREATE TABLE t(c BLOB,c2 INT,c3 DATE,KEY (c(1))) ENGINE=InnoDB;
      CREATE TEMPORARY TABLE t(c INT,c2 INT,c3 INT,KEY (c)) ENGINE=InnoDB;
      CREATE TABLE t2(c DECIMAL(1),c2 YEAR,c3 BLOB) ENGINE=MyISAM;
      SET @@GLOBAL.server_id=1;
      XA START 'xid2';
      INSERT INTO t2 VALUES('(QsMfc=^+N$=}t)nN8yC1wtrus_=X0q95en*rKi$-c2:8w&bh=VPpucn/&(FXO?F=c=/cwoDQ;#[:+V6N]_jw]Uk-,UF1=Ugb9q,zXOdviGa@9?xc:A','゚・✿ヾ╲(。◕‿◕。)╱✿・゚','#5i4=_@/X@^OfQgA"/bVL$p}=efKLIV{;H:p=iy0uN(=F8*[$#f)?qIbT6/]P*=@-s%WK=).,tH=A(;{cw@DcqyCiUu}E=:cA)v.c00OGc-GM,"P;o/t.Q;{ig%0)?Z$%qzLwO=),[1GDj;=(lSSmj3z{;r=r4=B+^Fdi;2K~Pq{@p46TnSNc4dIfiG]L&lW1K/:%n2lb;=+qYIUVt_w=-ae1N_Ke6~@}NWu"$6Pf{a22V"#Z$JRG1"qoNC${*S{Vt_ccvw([M+/S$xvSX}f)xSE=pJPemhngTv/Co1~:Oi:gHW9.5?G=)/*hQa=$uzgts7O;SvwI~EVtQ+-fw,]o;lShZHjG[AW5KVZiF[Ei)Cp3:~NRiPMVYjOk/UZYq4;$1jivN)BfgOHMfQquCzc0+%*tcD=_{A-a1#Qy3GMmNwc=~,$;ie[b=*{R@=#-(/%$r=O)01j=F1(V@Y$^ouupsApL~om?e~^gklTMl{("OgjRH6wSc$L~W+S;YtPG?Tdhxp;xZHJG=*%r+KnDnA)ps0_T9"7=ZP#=Ok)+t(meE.G;Wm::zuJ_0$rmH-yng*Y.}7gJYg*Vp=2+Vt~Nw5@=fEMwL_J^bOOz4&95bo)#=f"E;69x]R=qpJJt9=W[f8%FogGC=EO"vkdb6j');
      INSERT INTO t SELECT * FROM t2;
      SET @@SESSION.collation_connection=utf32_german2_ci;
      INSERT INTO t VALUES('sk,fbr0/$g+Gn~BUkSCkx0+g=,2X=,^,cl~lcn=&[tqBOTHUTStz^j^-dn?=ud{/lR,LHtk,RN*(^4lKIDo=n^ONlBt$),=z60drS_20Js(_&A6ki?xyp;=d3a@RRyrH=eyTZoU=?uWMdp-yLas=Gg:+rH=%dH=VkfYyBw7K0/Tqa=R~dt=fW7#9=b3k_V:CA7sb98R=TtR=Y~lZ[pM["g=]JALi:$u/APg11*cp9Qcy_nT;G[Tg-c]7U{={)C=-eCia2=gQi.=:0KZnrqRJp8dUO~Rf@~$G=XU{ipdNs_]#PM+v*OdP{)"qW*lSE]=g06jc}Jaack4k,-s4iL~kHs#[Wz[WVN7X)H*I)TCIOXfax[#"gx?pRaqYQw_.:Vlm=b,+_-V3bccpQ?Plj3LiJxS]~oISRrW;G"*m27YhdHoyCl+~ZXi[v8ExpaD#=V=4huwy=Qoa#Jx={ItJo2dtT5+=Vs=35OHa:52=SI]6nWCLXzF3SPf}q"d%Un-iEzAm+v$pGh5*x0eum=H{&ws+T#KJy_Xa4Vo~*ARI,yp0lF{R("t=7#vM)?kVWz^qxrFBpH@/Nz,JG${]@dfAeV&dUdDVAI?$3)1iO,?JjxuW%@-DMt$9azV:YV=KugJkSuT?JyH)P47/vo={Wq_7(-No?Bh,9N=djSAYu&A,U^YF=J}:fEdc.mjv(*f*)o0+p[i,cjV^L1W=~h*5MwXlyKS%^=NW~qYt7a1#KA7;5.zTBAZ;*a3.f=U=&Q$:*_%nq~YDWMZcmEe:#IvV$P]:?nUVkoyn;02dR%FqL[4=9=sS6]d@$W{&8.[?{2l1Z$HFchrDr6-q{PdF9:','rn=dF;6ya3Mu#K/]jubOXhHbP)2Dg&X}PchQ^]Mqiqwsw0lF3S/Plks,+7Wi]hstBZ]fHk9olk_t}0-5N[w6J;ax0kg7DGlsxfVV9Ag~62Otvr#~P=a"@?HvLqc}(7t$b}8[dZlK1t(k"_1:GXj+97=-]8nh/]*"ILTGG"W(M=]:=JVy;Wt7slg(G$]~jh^=_^D,cd=_G?-YG:=t(xJ-em*eNW~zKdpBdLXM58=rq7*wa}=Eol9IY?o/{Od=dWR8L+X%@#Qd,hv;nIAO_=KQ1"Hk6:~pp67;reg8L)B+PRe,&z%bdD52kOl$vdLD~HBlslwno?w=s/)vP3/k9~I:&]}EGY=pk7q2O=SpgdBm*3?VwSwu]ZtBR6iX[d1wM@ea90A}A^cskt4#MsiDQ=gO+9p94dhaNN/Sd_Iig:BEW+D"L~zsKKDX9mitVZh?BsyjQ8F8E*="uK=W*wo-GNOP"(KFBS3DGCdnO,]TN-rYO2x%L-VfD,Hx}4R)K$}znE7@w=C@iMPI74kCA3[mCcvP}Zm,J(&7rckpaM6)0-{sM-;?#Kt_kTA{P2O"fsQRAr&8^NA77=?SNH;z=(:_}mMg.}=Ky#B5I^-wo+)&FFKq:c_n$dLqf"%L45KhZ8#@+zC/pZ=g=[D=v,$ha;BwPB+0QbJS.r=U&Y2lw#xMW+=G@a62~=@[;x"3rDRZ8).J*[.gcykBo=^t_rAQ=:Fk*llA=/$^Y.l}mQ;l=djh+F%8+Y{T;sqj[X9R#m-jX8=MrB4b;O3BplWAUl7-*FnY(-dMk.iG8fnE-.~v8&O^jMaKH~:OkhtXoJhtgMOZy_6#0zV0PK;x{@qjiR8:GBa+u{2p&SgI5+jwfN7^~q@9GDd0KTU}IqpFJKmB%QcEYu6gb%7uNO9XfZhkL6NLDT@+I.{tum}jS_&f=:XoyG:m"LhPw(G1ctH2sV:aI;6hfDx80QMhNI6?ownC;4iZsc5/{75NS].T60',CURRENT_TIMESTAMP(1));
      DELETE FROM a3,a2 USING t AS a1 JOIN t AS a2 JOIN t2 AS a3;
      

      Leads to:

      10.6.0 f74704c7d963ddcd1109843a5861c6bd76409c8d (Debug)

      mysqld: /test/10.6_dbg/sql/sql_error.cc:334: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
      

      10.6.0 f74704c7d963ddcd1109843a5861c6bd76409c8d (Debug)

      Core was generated by `/test/MD120421-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x15353969a700 (LWP 2439101))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055d5b3003c9e in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
      #2  0x000055d5b27a2b07 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000015355058a859 in __GI_abort () at abort.c:79
      #6  0x000015355058a729 in __assert_fail_base (fmt=0x153550720588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55d5b316a3d0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x55d5b316a2b0 "/test/10.6_dbg/sql/sql_error.cc", line=334, function=<optimized out>) at assert.c:92
      #7  0x000015355059bf36 in __GI___assert_fail (assertion=assertion@entry=0x55d5b316a3d0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x55d5b316a2b0 "/test/10.6_dbg/sql/sql_error.cc", line=line@entry=334, function=function@entry=0x55d5b316a408 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x000055d5b24875e5 in Diagnostics_area::set_ok_status (this=0x1534f4006ab8, affected_rows=3, last_insert_id=last_insert_id@entry=0, message=message@entry=0x0) at /test/10.6_dbg/sql/sql_error.h:1017
      #9  0x000055d5b299d91d in my_ok (message=0x0, id=0, affected_rows_arg=<optimized out>, thd=<optimized out>) at /test/10.6_dbg/sql/sql_class.h:5486
      #10 multi_delete::send_eof (this=0x1534f4017168) at /test/10.6_dbg/sql/sql_delete.cc:1629
      #11 0x000055d5b2562c37 in do_select (procedure=<optimized out>, join=0x1534f40171d8) at /test/10.6_dbg/sql/sql_select.cc:20377
      #12 JOIN::exec_inner (this=this@entry=0x1534f40171d8) at /test/10.6_dbg/sql/sql_select.cc:4493
      #13 0x000055d5b2562f46 in JOIN::exec (this=this@entry=0x1534f40171d8) at /test/10.6_dbg/sql/sql_select.cc:4273
      #14 0x000055d5b256101f in mysql_select (thd=thd@entry=0x1534f4000db8, tables=0x1534f4014c20, fields=@0x1534f40058e0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1534f40170c8, last = 0x1534f40170c8, elements = 1}, <No data fields>}, conds=conds@entry=0x0, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2202245794688, result=0x1534f4017168, unit=0x1534f4004f90, select_lex=0x1534f4005790) at /test/10.6_dbg/sql/sql_select.cc:4749
      #15 0x000055d5b24e4002 in mysql_execute_command (thd=thd@entry=0x1534f4000db8) at /test/10.6_dbg/sql/sql_parse.cc:4845
      #16 0x000055d5b24cda02 in mysql_parse (thd=thd@entry=0x1534f4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153539699410) at /test/10.6_dbg/sql/sql_parse.cc:8004
      #17 0x000055d5b24dc726 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1534f4000db8, packet=packet@entry=0x1534f400b489 "DELETE FROM a3,a2 USING t AS a1 JOIN t AS a2 JOIN t2 AS a3", packet_length=packet_length@entry=58, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1331
      #18 0x000055d5b24dfac7 in do_command (thd=0x1534f4000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1399
      #19 0x000055d5b2639176 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d5b5e98a08, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
      #20 0x000055d5b263977b in handle_one_connection (arg=arg@entry=0x55d5b5e98a08) at /test/10.6_dbg/sql/sql_connect.cc:1312
      #21 0x000055d5b2ae7253 in pfs_spawn_thread (arg=0x55d5b5dc93c8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #22 0x0000153550a98609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x0000153550687293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.2.38 (dbg), 10.3.29 (dbg), 10.4.19 (dbg), 10.5.10 (dbg), 10.6.0 (dbg)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.38 (opt), 10.3.29 (opt), 10.4.19 (opt), 10.5.10 (opt), 10.6.0 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.33 (dbg), 5.7.33 (opt), 8.0.23 (dbg), 8.0.23 (opt)

        Attachments

          Activity

            People

            Assignee:
            rucha174 Rucha Deodhar
            Reporter:
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: