search

midenok / mariadb

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.
GNU General Public License v2.0
0 stars 0 forks source link

MTR hang #107

Open midenok opened 2 years ago

midenok commented 2 years ago

Reproduce

mtrz -v --suite=b

b.zip

--- a/sql/sql_insert.cc
+++ b/sql/sql_insert.cc
@@ -715,6 +715,8 @@ bool mysql_insert(THD *thd,TABLE_LIST *table_list,
   List_item *values;
   Name_resolution_context *context;
   Name_resolution_context_state ctx_state;
+  //DBUG_ASSERT(!opt_bootstrap);
+  DBUG_ASSERT(opt_bootstrap);
 #ifndef EMBEDDED_LIBRARY
   char *query= thd->query();
   /*

Result

ps axfo pid,s,args
   5711 S              |   |   |               \_ -/bin/bash
   5717 S              |   |   |                   \_ perl /home/midenok/src/mariadb/10.3/build/opt/mysql-test/mysql-test-run --force --max-test-fail=0 --suite-timeout=1440 --mysqld=--silent-startup --mysqld=--loose-innodb-flush-method=fsync --tail-lines=0 --skip-test-list=/home/midenok/src/mariadb/10.3/tests_exclude --fast --reorder --parallel=10 -v --suite=b
   5719 S              |   |   |                   |   \_ /usr/bin/perl /home/midenok/src/mariadb/10.3/src/mysql-test/mysql-test-run.pl --force --max-test-fail=0 --suite-timeout=1440 --mysqld=--silent-startup --mysqld=--loose-innodb-flush-method=fsync --tail-lines=0 --skip-test-list=/home/midenok/src/mariadb/10.3/tests_exclude --fast --reorder --parallel=10 -v --suite=b
   5756 Z              |   |   |                   |       \_ [perl] <defunct>
   5757 Z              |   |   |                   |       \_ [perl] <defunct>
   5758 Z              |   |   |                   |       \_ [perl] <defunct>
   5759 Z              |   |   |                   |       \_ [perl] <defunct>
   5760 Z              |   |   |                   |       \_ [perl] <defunct>
   5761 S              |   |   |                   |       \_ /usr/bin/perl /home/midenok/src/mariadb/10.3/src/mysql-test/mysql-test-run.pl --force --max-test-fail=0 --suite-timeout=1440 --mysqld=--silent-startup --mysqld=--loose-innodb-flush-method=fsync --tail-lines=0 --skip-test-list=/home/midenok/src/mariadb/10.3/tests_exclude --fast --reorder --parallel=10 -v --suite=b
   5762 S              |   |   |                   |       \_ /usr/bin/perl /home/midenok/src/mariadb/10.3/src/mysql-test/mysql-test-run.pl --force --max-test-fail=0 --suite-timeout=1440 --mysqld=--silent-startup --mysqld=--loose-innodb-flush-method=fsync --tail-lines=0 --skip-test-list=/home/midenok/src/mariadb/10.3/tests_exclude --fast --reorder --parallel=10 -v --suite=b
   5763 Z              |   |   |                   |       \_ [perl] <defunct>
   5764 Z              |   |   |                   |       \_ [perl] <defunct>
   5765 Z              |   |   |                   |       \_ [perl] <defunct>
   5718 S              |   |   |                   \_ tee -a mtr.log

mtr.log

midenok commented 2 years ago

Note

Only perl becomes zombie, it's not SafeProcess:

{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5756
safe_process[5853]: parent_pid: 5756
safe_process[5853]: parent_pid: 5756
safe_process[6011]: parent_pid: 5756
safe_process[5989]: parent_pid: 5756
safe_process[6011]: parent_pid: 5756
safe_process[5989]: parent_pid: 5756
safe_process[6011]: parent_pid: 5756
safe_process[6534]: parent_pid: 5756
safe_process[6503]: parent_pid: 5756
safe_process[6011]: parent_pid: 5756
safe_process[6534]: parent_pid: 5756
safe_process[6503]: parent_pid: 5756
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5757
safe_process[5855]: parent_pid: 5757
safe_process[5855]: parent_pid: 5757
safe_process[6070]: parent_pid: 5757
safe_process[6039]: parent_pid: 5757
safe_process[6070]: parent_pid: 5757
safe_process[6039]: parent_pid: 5757
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5758
safe_process[5871]: parent_pid: 5758
safe_process[5871]: parent_pid: 5758
safe_process[6111]: parent_pid: 5758
safe_process[6089]: parent_pid: 5758
safe_process[6111]: parent_pid: 5758
safe_process[6089]: parent_pid: 5758
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5760
safe_process[5880]: parent_pid: 5760
safe_process[5880]: parent_pid: 5760
safe_process[6215]: parent_pid: 5760
safe_process[6195]: parent_pid: 5760
safe_process[6215]: parent_pid: 5760
safe_process[6195]: parent_pid: 5760
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5763
safe_process[5883]: parent_pid: 5763
safe_process[5883]: parent_pid: 5763
safe_process[6376]: parent_pid: 5763
safe_process[6345]: parent_pid: 5763
safe_process[6376]: parent_pid: 5763
safe_process[6345]: parent_pid: 5763
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5764
safe_process[5890]: parent_pid: 5764
safe_process[5890]: parent_pid: 5764
safe_process[6485]: parent_pid: 5764
safe_process[6453]: parent_pid: 5764
safe_process[6485]: parent_pid: 5764
safe_process[6453]: parent_pid: 5764
{10.3} midenok@lian:log$ grep safe_process ~/log/mtr.log |grep 5765
safe_process[5893]: parent_pid: 5765
safe_process[5893]: parent_pid: 5765
safe_process[6415]: parent_pid: 5765
safe_process[6395]: parent_pid: 5765
safe_process[6415]: parent_pid: 5765
safe_process[6395]: parent_pid: 5765