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

main.mysqldump fails sporadically in buildbot

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wheezy-amd64/builds/3197/steps/test_4/logs/stdio

      main.mysqldump 'innodb_plugin'           w3 [ fail ]
              Test ended at 2015-01-06 11:37:45
       
      CURRENT_TEST: main.mysqldump
      mysqldump: Couldn't find table: "non_existing"
      mysqldump: Got error: 1356: "View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES
      mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
      mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: user1 has insufficent privileges to SHOW CREATE FUNCTION `hello1`!
      mysqldump: Got error: 2005: "Unknown MySQL server host 'unknownhost' (-2)" when trying to connect
      mysqldump: Couldn't execute 'SHOW SLAVE STATUS': MySQL server has gone away (2006)
      --- /usr/share/mysql/mysql-test/r/mysqldump.result	2015-01-06 09:25:23.000000000 -0500
      +++ /run/shm/var/3/log/mysqldump.reject	2015-01-06 11:37:44.806794848 -0500
      @@ -4293,6 +4293,7 @@
       aberration
       drop table words;
       mysqlimport: Error: 1146, Table 'test.words' doesn't exist, when using table: words
      +mysqlimport: Error: 2002 Can't connect to local MySQL server through socket '' (111 "Connection refused")
       drop table t1;
       drop table t2;
       drop table words2;
       
      mysqltest: Result length mismatch

      The error message 'Error: 2002 Can't connect to local MySQL server through socket '' (111 "Connection refused")' can happen if the socket value is empty. In the test, mysqlimport is run with my.cnf from the vardir, and this config has a socket value in the [client] section. So, can it be that the file gets overridden due to some race condition?

      Same log, a different failure with xtradb:

      *** glibc detected *** /usr/bin/mysqlimport: double free or corruption (!prev): 0x00007fc5209eb0f0 ***
      ======= Backtrace: =========
      /lib/x86_64-linux-gnu/libc.so.6(+0x75b46)[0x7fc51e98db46]
      /lib/x86_64-linux-gnu/libc.so.6(cfree+0x6c)[0x7fc51e99287c]
      /usr/bin/mysqlimport(+0x4e9b5)[0x7fc5203199b5]
      /usr/bin/mysqlimport(+0x4bdab)[0x7fc520316dab]
      /usr/bin/mysqlimport(+0x22601)[0x7fc5202ed601]
      /usr/bin/mysqlimport(+0x231bb)[0x7fc5202ee1bb]
      /usr/bin/mysqlimport(+0x237a1)[0x7fc5202ee7a1]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50)[0x7fc51fe93b50]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fc51e9f06dd]
      ======= Memory map: ========
      7fc518000000-7fc518021000 rw-p 00000000 00:00 0 
      7fc518021000-7fc51c000000 ---p 00000000 00:00 0 
      7fc51ccf3000-7fc51ccf4000 ---p 00000000 00:00 0 
      7fc51ccf4000-7fc51d4f4000 rw-p 00000000 00:00 0 
      7fc51d4f4000-7fc51d4ff000 r-xp 00000000 08:01 34                         /lib/x86_64-linux-gnu/libnss_files-2.13.so
      7fc51d4ff000-7fc51d6fe000 ---p 0000b000 08:01 34                         /lib/x86_64-linux-gnu/libnss_files-2.13.so
      7fc51d6fe000-7fc51d6ff000 r--p 0000a000 08:01 34                         /lib/x86_64-linux-gnu/libnss_files-2.13.so
      7fc51d6ff000-7fc51d700000 rw-p 0000b000 08:01 34                         /lib/x86_64-linux-gnu/libnss_files-2.13.so
      7fc51d700000-7fc51d701000 ---p 00000000 00:00 0 
      7fc51d701000-7fc51df01000 rw-p 00000000 00:00 0 
      7fc51df01000-7fc51df02000 ---p 00000000 00:00 0 
      7fc51df02000-7fc51e702000 rw-p 00000000 00:00 0 
      7fc51e702000-7fc51e717000 r-xp 00000000 08:01 18                         /lib/x86_64-linux-gnu/libgcc_s.so.1
      7fc51e717000-7fc51e917000 ---p 00015000 08:01 18                         /lib/x86_64-linux-gnu/libgcc_s.so.1
      7fc51e917000-7fc51e918000 rw-p 00015000 08:01 18                         /lib/x86_64-linux-gnu/libgcc_s.so.1
      7fc51e918000-7fc51ea95000 r-xp 00000000 08:01 16                         /lib/x86_64-linux-gnu/libc-2.13.so
      7fc51ea95000-7fc51ec95000 ---p 0017d000 08:01 16                         /lib/x86_64-linux-gnu/libc-2.13.so
      7fc51ec95000-7fc51ec99000 r--p 0017d000 08:01 16                         /lib/x86_64-linux-gnu/libc-2.13.so
      7fc51ec99000-7fc51ec9a000 rw-p 00181000 08:01 16                         /lib/x86_64-linux-gnu/libc-2.13.so
      7fc51ec9a000-7fc51ec9f000 rw-p 00000000 00:00 0 
      7fc51ec9f000-7fc51ed20000 r-xp 00000000 08:01 25                         /lib/x86_64-linux-gnu/libm-2.13.so
      7fc51ed20000-7fc51ef1f000 ---p 00081000 08:01 25                         /lib/x86_64-linux-gnu/libm-2.13.so
      7fc51ef1f000-7fc51ef20000 r--p 00080000 08:01 25                         /lib/x86_64-linux-gnu/libm-2.13.so
      7fc51ef20000-7fc51ef21000 rw-p 00081000 08:01 25                         /lib/x86_64-linux-gnu/libm-2.13.so
      7fc51ef21000-7fc51f009000 r-xp 00000000 08:01 264207                     /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.17
      7fc51f009000-7fc51f209000 ---p 000e8000 08:01 264207                     /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.17
      7fc51f209000-7fc51f211000 r--p 000e8000 08:01 264207                     /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.17
      7fc51f211000-7fc51f213000 rw-p 000f0000 08:01 264207                     /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.17
      7fc51f213000-7fc51f228000 rw-p 00000000 00:00 0 
      7fc51f228000-7fc51f22a000 r-xp 00000000 08:01 32                         /lib/x86_64-linux-gnu/libdl-2.13.so
      7fc51f22a000-7fc51f42a000 ---p 00002000 08:01 32                         /lib/x86_64-linux-gnu/libdl-2.13.so
      7fc51f42a000-7fc51f42b000 r--p 00002000 08:01 32                         /lib/x86_64-linux-gnu/libdl-2.13.so
      7fc51f42b000-7fc51f42c000 rw-p 00003000 08:01 32                         /lib/x86_64-linux-gnu/libdl-2.13.so
      7fc51f42c000-7fc51f5e2000 r-xp 00000000 08:01 264729                     /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7fc51f5e2000-7fc51f7e2000 ---p 001b6000 08:01 264729                     /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7fc51f7e2000-7fc51f7fd000 r--p 001b6000 08:01 264729                     /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7fc51f7fd000-7fc51f80c000 rw-p 001d1000 08:01 264729                     /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7fc51f80c000-7fc51f810000 rw-p 00000000 00:00 0 
      7fc51f810000-7fc51f864000 r-xp 00000000 08:01 264730                     /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7fc51f864000-7fc51fa64000 ---p 00054000 08:01 264730                     /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7fc51fa64000-7fc51fa67000 r--p 00054000 08:01 264730                     /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7fc51fa67000-7fc51fa6e000 rw-p 00057000 08:01 264730                     /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7fc51fa6e000-7fc51fa75000 r-xp 00000000 08:01 38                         /lib/x86_64-linux-gnu/librt-2.13.so
      7fc51fa75000-7fc51fc74000 ---p 00007000 08:01 38                         /lib/x86_64-linux-gnu/librt-2.13.so
      7fc51fc74000-7fc51fc75000 r--p 00006000 08:01 38                         /lib/x86_64-linux-gnu/librt-2.13.so
      7fc51fc75000-7fc51fc76000 rw-p 00007000 08:01 38                         /lib/x86_64-linux-gnu/librt-2.13.so
      7fc51fc76000-7fc51fc8c000 r-xp 00000000 08:01 170                        /lib/x86_64-linux-gnu/libz.so.1.2.7
      7fc51fc8c000-7fc51fe8b000 ---p 00016000 08:01 170                        /lib/x86_64-linux-gnu/libz.so.1.2.7
      7fc51fe8b000-7fc51fe8c000 r--p 00015000 08:01 170                        /lib/x86_64-linux-gnu/libz.so.1.2.7
      7fc51fe8c000-7fc51fe8d000 rw-p 00016000 08:01 170                        /lib/x86_64-linux-gnu/libz.so.1.2.7
      7fc51fe8d000-7fc51fea4000 r-xp 00000000 08:01 36                         /lib/x86_64-linux-gnu/libpthread-2.13.so
      7fc51fea4000-7fc5200a3000 ---p 00017000 08:01 36                         /lib/x86_64-linux-gnu/libpthread-2.13.so
      7fc5200a3000-7fc5200a4000 r--p 00016000 08:01 36                         /lib/x86_64-linux-gnu/libpthread-2.13.so
      7fc5200a4000-7fc5200a5000 rw-p 00017000 08:01 36                         /lib/x86_64-linux-gnu/libpthread-2.13.so
      7fc5200a5000-7fc5200a9000 rw-p 00000000 00:00 0 
      7fc5200a9000-7fc5200c9000 r-xp 00000000 08:01 40                         /lib/x86_64-linux-gnu/ld-2.13.so
      7fc5202ba000-7fc5202c2000 rw-p 00000000 00:00 0 
      7fc5202c6000-7fc5202c8000 rw-p 00000000 00:00 0 
      7fc5202c8000-7fc5202c9000 r--p 0001f000 08:01 40                         /lib/x86_64-linux-gnu/ld-2.13.so
      7fc5202c9000-7fc5202ca000 rw-p 00020000 08:01 40                         /lib/x86_64-linux-gnu/ld-2.13.so
      7fc5202ca000-7fc5202cb000 rw-p 00000000 00:00 0 
      7fc5202cb000-7fc5205b1000 r-xp 00000000 08:01 262824                     /usr/bin/mysqlimport
      7fc5207b1000-7fc5207b9000 r--p 002e6000 08:01 262824                     /usr/bin/mysqlimport
      7fc5207b9000-7fc52081f000 rw-p 002ee000 08:01 262824                     /usr/bin/mysqlimport
      7fc52081f000-7fc520829000 rw-p 00000000 00:00 0 
      7fc5209eb000-7fc520a29000 rw-p 00000000 00:00 0                          [heap]
      7fffbea10000-7fffbea32000 rw-p 00000000 00:00 0                          [stack]
      7fffbeb26000-7fffbeb27000 r-xp 00000000 00:00 0                          [vdso]
      ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
      main.mysqldump 'xtradb'                  w2 [ fail ]
              Test ended at 2015-01-06 11:38:55
       
      CURRENT_TEST: main.mysqldump
      mysqldump: Couldn't find table: "non_existing"
      mysqldump: Got error: 1356: "View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES
      mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
      mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES
      mysqltest: At line 1783: command "$MYSQL_IMPORT --silent --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat 2>&1" failed with wrong error: 134
       
      The result from queries just before the failure was:
      < snip >
      abdomen
      abdomens
      abdominal
      abduct
      abducted
      abduction
      abductions
      abductor
      abductors
      abducts
      Abe
      abed
      Abel
      Abelian
      Abelson
      Aberdeen
      Abernathy
      aberrant
      aberration
      drop table words;
       
      More results from queries before failure can be found in /run/shm/var/2/log/mysqldump.log
       
       - skipping '/run/shm/var/2/log/main.mysqldump-xtradb/'

      Another flavor:
      http://buildbot.askmonty.org/buildbot/builders/kvm-dgcov-jaunty-i386/builds/4569/steps/test_3/logs/stdio

      main.mysqldump 'xtradb'                  w1 [ fail ]
              Test ended at 2015-01-15 09:52:01
       
      CURRENT_TEST: main.mysqldump
      mysqldump: Couldn't find table: "non_existing"
      mysqldump: Got error: 1356: "View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them" when using LOCK TABLES
      mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      Warning: 3072 bytes lost at 0x10841c0, allocated by T@0 at mysys/my_malloc.c:164, mysys/string.c:107, client/mysqldump.c:5831, client/mysqldump.c:3462, client/mysqldump.c:3440, client/mysqldump.c:3620, client/mysqldump.c:4525, client/mysqldump.c:4342
      Warning: 8152 bytes lost at 0x1082160, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1652, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991
      Warning:   96 bytes lost at 0x107e0e0, allocated by T@0 at sql-common/client.c:1626, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa32af39c4d
      Warning:  160 bytes lost at 0x107dfc0, allocated by T@0 at sql-common/client.c:4222, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa32af39c4d, 0x40a7c9
      Warning: 8152 bytes lost at 0x1080100, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1503, sql-common/client.c:4167, sql-common/client.c:4200, libmysql/libmysql.c:714, libmysql/libmysql.c:801, client/mysqldump.c:4007, client/mysqldump.c:4491
      Memory lost: 19632 bytes in 5 chunks
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      Warning: 3072 bytes lost at 0xcf31c0, allocated by T@0 at mysys/my_malloc.c:164, mysys/string.c:107, client/mysqldump.c:5831, client/mysqldump.c:3462, client/mysqldump.c:3440, client/mysqldump.c:3621, client/mysqldump.c:4525, client/mysqldump.c:4342
      Warning: 8152 bytes lost at 0xcf1160, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1652, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991
      Warning:   96 bytes lost at 0xced0e0, allocated by T@0 at sql-common/client.c:1626, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa4c008dc4d
      Warning:  160 bytes lost at 0xcecfc0, allocated by T@0 at sql-common/client.c:4222, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa4c008dc4d, 0x40a7c9
      Warning: 8152 bytes lost at 0xcef100, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1503, sql-common/client.c:4167, sql-common/client.c:4200, libmysql/libmysql.c:714, libmysql/libmysql.c:801, client/mysqldump.c:4007, client/mysqldump.c:4491
      Memory lost: 19632 bytes in 5 chunks
      mysqldump: Got error: 1083: "Field separator argument is not what is expected; check the manual" when executing 'SELECT INTO OUTFILE'
      Warning: 3072 bytes lost at 0x239a1c0, allocated by T@0 at mysys/my_malloc.c:164, mysys/string.c:107, client/mysqldump.c:5831, client/mysqldump.c:3462, client/mysqldump.c:3440, client/mysqldump.c:3622, client/mysqldump.c:4525, client/mysqldump.c:4342
      Warning: 8152 bytes lost at 0x2398160, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1652, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991
      Warning:   96 bytes lost at 0x23940e0, allocated by T@0 at sql-common/client.c:1626, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa0290fcc4d
      Warning:  160 bytes lost at 0x2393fc0, allocated by T@0 at sql-common/client.c:4222, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7fa0290fcc4d, 0x40a7c9
      Warning: 8152 bytes lost at 0x2396100, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1503, sql-common/client.c:4167, sql-common/client.c:4200, libmysql/libmysql.c:714, libmysql/libmysql.c:801, client/mysqldump.c:4007, client/mysqldump.c:4491
      Memory lost: 19632 bytes in 5 chunks
      mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
      mysqldump: Got error: 1146: "Table 'test.???????????????????????' doesn't exist" when using LOCK TABLES
      Warning: 8152 bytes lost at 0x298d1b0, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1652, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991
      Warning:   96 bytes lost at 0x298d0d0, allocated by T@0 at sql-common/client.c:1626, sql-common/client.c:4233, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7f418b4cec4d
      Warning:  160 bytes lost at 0x298cfb0, allocated by T@0 at sql-common/client.c:4222, libmysql/libmysql.c:803, client/mysqldump.c:4007, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7f418b4cec4d, 0x40a7c9
      Warning: 8152 bytes lost at 0x29919d0, allocated by T@0 at mysys/my_alloc.c:233, sql-common/client.c:1503, sql-common/client.c:4167, sql-common/client.c:4200, libmysql/libmysql.c:714, libmysql/libmysql.c:801, client/mysqldump.c:4007, client/mysqldump.c:4491
      Warning: 1024 bytes lost at 0x298cb30, allocated by T@0 at mysys/string.c:39, client/mysqldump.c:5812, client/mysqldump.c:4491, client/mysqldump.c:4342, client/mysqldump.c:5991, 0x7f418b4cec4d, 0x40a7c9
      Memory lost: 17584 bytes in 5 chunks
      mysqltest: At line 1783: command "$MYSQL_IMPORT --silent --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat 2>&1" failed with wrong error: 139
       
      The result from queries just before the failure was:
      < snip >
      abdomen
      abdomens
      abdominal
      abduct
      abducted
      abduction
      abductions
      abductor
      abductors
      abducts
      Abe
      abed
      Abel
      Abelian
      Abelson
      Aberdeen
      Abernathy
      aberrant
      aberration
      drop table words;
       
      More results from queries before failure can be found in /dev/shm/var_auto_d2bo/1/log/mysqldump.log
       
       - saving '/dev/shm/var_auto_d2bo/1/log/main.mysqldump-xtradb/' to '/dev/shm/var_auto_d2bo/log/main.mysqldump-xtradb/'

      Attachments

        Issue Links

          Activity

            At least one of reasons why the test fails is this: mysqlimport can crash when it is run with --use-threads=N where N>1.
            To reproduce,

            • start a server;
            • run something like

              while [ $? -le 1 ]; do client/mysqlimport --use-threads=2 test nonexisting1.txt nonexisting2.txt nonexisting3.txt nonexisting4.txt --socket=/tmp/mysql.sock -uroot; done

            Soon enough it crashes with

            Stack trace from 10.0 commit 5c66abf0b0de6d632f85a57c841f80d28a7e0337

            Core was generated by `client/mysqlimport --use-threads=2 test nonexisting1.txt nonexisting2.txt nonex'.
            Program terminated with signal 11, Segmentation fault.
            #0  0x0000000000435bda in free_root (root=0x7f610884b490, MyFlags=0) at /home/elenst/git/10.0/mysys/my_alloc.c:383
            383         old=next; next= next->next ;
             
            Thread 3 (Thread 0x7f610904f700 (LWP 5131)):
            #0  0x00007f610a1c01a4 in ?? () from /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
            #1  0x00007f610aa204ec in ?? () from /lib64/ld-linux-x86-64.so.2
            #2  0x00007f6109086ae2 in __run_exit_handlers (status=1, listp=0x7f61093d64c8, run_list_atexit=true) at exit.c:78
            #3  0x00007f6109086b35 in *__GI_exit (status=171795248) at exit.c:100
            #4  0x000000000040c96e in safe_exit (error=1, mysql=0x7f6104001580) at /home/elenst/git/10.0/client/mysqlimport.c:505
            #5  0x000000000040c9d5 in db_error_with_table (mysql=0x7f6104001580, table=0x7f610904ec70 "nonexisting1") at /home/elenst/git/10.0/client/mysqlimport.c:514
            #6  0x000000000040c411 in write_to_table (filename=0x7fff12147604 "nonexisting1.txt", mysql=0x7f6104001580) at /home/elenst/git/10.0/client/mysqlimport.c:380
            #7  0x000000000040cc48 in worker_thread (arg=0x7fff12147604) at /home/elenst/git/10.0/client/mysqlimport.c:600
            #8  0x00007f610a7fcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #9  0x00007f610912c70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            #10 0x0000000000000000 in ?? ()
             
            Thread 2 (Thread 0x7f610ac10720 (LWP 5130)):
            #0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
            #1  0x000000000040cee3 in main (argc=4, argv=0x11ae5b0) at /home/elenst/git/10.0/client/mysqlimport.c:654
             
            Thread 1 (Thread 0x7f610884e700 (LWP 5132)):
            #0  0x0000000000435bda in free_root (root=0x7f610884b490, MyFlags=0) at /home/elenst/git/10.0/mysys/my_alloc.c:383
            #1  0x0000000000447551 in free_defaults (argv=0x11ae590) at /home/elenst/git/10.0/mysys/my_default.c:653
            #2  0x000000000040c92e in safe_exit (error=1, mysql=0x11b0560) at /home/elenst/git/10.0/client/mysqlimport.c:498
            #3  0x000000000040c9d5 in db_error_with_table (mysql=0x11b0560, table=0x7f610884dc70 "nonexisting2") at /home/elenst/git/10.0/client/mysqlimport.c:514
            #4  0x000000000040c411 in write_to_table (filename=0x7fff12147615 "nonexisting2.txt", mysql=0x11b0560) at /home/elenst/git/10.0/client/mysqlimport.c:380
            #5  0x000000000040cc48 in worker_thread (arg=0x7fff12147615) at /home/elenst/git/10.0/client/mysqlimport.c:600
            #6  0x00007f610a7fcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #7  0x00007f610912c70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            #8  0x0000000000000000 in ?? ()

            MTR test (to run with --repeat=X):

            --disable_abort_on_error
            connect (con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK);
            --exec $MYSQL_IMPORT --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat  2>&1

            It's possible that there are other reasons for sporadic failures in main.mysqldump, but I think it makes sense to fix this flavor first and see how it goes.

            elenst Elena Stepanova added a comment - At least one of reasons why the test fails is this: mysqlimport can crash when it is run with --use-threads=N where N>1. To reproduce, start a server; run something like while [ $? -le 1 ]; do client/mysqlimport --use-threads=2 test nonexisting1.txt nonexisting2.txt nonexisting3.txt nonexisting4.txt --socket=/tmp/mysql.sock -uroot; done Soon enough it crashes with Stack trace from 10.0 commit 5c66abf0b0de6d632f85a57c841f80d28a7e0337 Core was generated by `client/mysqlimport --use-threads=2 test nonexisting1.txt nonexisting2.txt nonex'. Program terminated with signal 11, Segmentation fault. #0 0x0000000000435bda in free_root (root=0x7f610884b490, MyFlags=0) at /home/elenst/git/10.0/mysys/my_alloc.c:383 383 old=next; next= next->next ;   Thread 3 (Thread 0x7f610904f700 (LWP 5131)): #0 0x00007f610a1c01a4 in ?? () from /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0 #1 0x00007f610aa204ec in ?? () from /lib64/ld-linux-x86-64.so.2 #2 0x00007f6109086ae2 in __run_exit_handlers (status=1, listp=0x7f61093d64c8, run_list_atexit=true) at exit.c:78 #3 0x00007f6109086b35 in *__GI_exit (status=171795248) at exit.c:100 #4 0x000000000040c96e in safe_exit (error=1, mysql=0x7f6104001580) at /home/elenst/git/10.0/client/mysqlimport.c:505 #5 0x000000000040c9d5 in db_error_with_table (mysql=0x7f6104001580, table=0x7f610904ec70 "nonexisting1") at /home/elenst/git/10.0/client/mysqlimport.c:514 #6 0x000000000040c411 in write_to_table (filename=0x7fff12147604 "nonexisting1.txt", mysql=0x7f6104001580) at /home/elenst/git/10.0/client/mysqlimport.c:380 #7 0x000000000040cc48 in worker_thread (arg=0x7fff12147604) at /home/elenst/git/10.0/client/mysqlimport.c:600 #8 0x00007f610a7fcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304 #9 0x00007f610912c70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 #10 0x0000000000000000 in ?? ()   Thread 2 (Thread 0x7f610ac10720 (LWP 5130)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216 #1 0x000000000040cee3 in main (argc=4, argv=0x11ae5b0) at /home/elenst/git/10.0/client/mysqlimport.c:654   Thread 1 (Thread 0x7f610884e700 (LWP 5132)): #0 0x0000000000435bda in free_root (root=0x7f610884b490, MyFlags=0) at /home/elenst/git/10.0/mysys/my_alloc.c:383 #1 0x0000000000447551 in free_defaults (argv=0x11ae590) at /home/elenst/git/10.0/mysys/my_default.c:653 #2 0x000000000040c92e in safe_exit (error=1, mysql=0x11b0560) at /home/elenst/git/10.0/client/mysqlimport.c:498 #3 0x000000000040c9d5 in db_error_with_table (mysql=0x11b0560, table=0x7f610884dc70 "nonexisting2") at /home/elenst/git/10.0/client/mysqlimport.c:514 #4 0x000000000040c411 in write_to_table (filename=0x7fff12147615 "nonexisting2.txt", mysql=0x11b0560) at /home/elenst/git/10.0/client/mysqlimport.c:380 #5 0x000000000040cc48 in worker_thread (arg=0x7fff12147615) at /home/elenst/git/10.0/client/mysqlimport.c:600 #6 0x00007f610a7fcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304 #7 0x00007f610912c70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 #8 0x0000000000000000 in ?? () MTR test (to run with --repeat=X): --disable_abort_on_error connect (con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK); --exec $MYSQL_IMPORT --use-threads=2 test $MYSQLTEST_VARDIR/tmp/t1.txt $MYSQLTEST_VARDIR/tmp/t2.txt $MYSQLTEST_VARDIR/std_data/words.dat $MYSQLTEST_VARDIR/std_data/words2.dat 2>&1 It's possible that there are other reasons for sporadic failures in main.mysqldump, but I think it makes sense to fix this flavor first and see how it goes.

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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