Linux nanna21 2.6.18-92.1.10.el5 #1 SMP Wed Jul 23 03:55:54 EDT 2008 i686 athlon i386 GNU/Linux Fri Sep 24 11:31:37 CEST 2010 + cd /export/home/pb2/test/sb_1-2315564-1285320694.32 + SOURCE=mysql-5.5.7-m3-linux-i686.tar.gz + export SOURCE + SOURCENAME=mysql-5.5.7-m3-linux-i686 + export SOURCENAME + TMPDIR=/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp + export TMPDIR + PB2WORKDIR=/export/home/pb2/test/sb_1-2315564-1285320694.32 + export PB2WORKDIR + BRANCH_ID=226 + export BRANCH_ID + PRODUCT_ID=test-sysqa_rqg_mdl_deadlock-linux-x86 + export PRODUCT_ID + BRANCH_NAME=mysql-5.5-runtime + export BRANCH_NAME + SOURCE2NAME=unittest + export SOURCE2NAME + SOURCE2=unittest.tar.gz + export SOURCE2 + PARENT_ID=2315564 + export PARENT_ID + SOURCE1=Makefile + export SOURCE1 + SOURCE1NAME=Makefile + export SOURCE1NAME + PUSH_REVISION=jon.hauglid@oracle.com-20100924084409-e1b5fpajkv23cab3 + export PUSH_REVISION + PUSH_ID=1597401 + export PUSH_ID + BRANCH_SOURCE=http://bk-internal.mysql.com/bzr-mysql/mysql-5.5-runtime/ + export BRANCH_SOURCE + echo '[SOURCEBUILDER] POLICY mysql-5.5.7-m3-linux-i686-test/vardirs' [SOURCEBUILDER] POLICY mysql-5.5.7-m3-linux-i686-test/vardirs + RESULT=0 + grep 'no gnutar' which: no gnutar in (/usr/local/bin:/bin:/usr/bin) + echo no gnutar no gnutar + gunzip -c mysql-5.5.7-m3-linux-i686.tar.gz + tar xf - tar: Read 9728 bytes from - + true + mv mysql-5.5.7-m3-linux-i686 mysql-5.5.7-m3-linux-i686-test + cd mysql-5.5.7-m3-linux-i686-test + mkdir vardirs ++ pwd + DIR=/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test + cd /export/home/pb2/scripts + perl pb2gentest.pl /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs http://bk-internal.mysql.com/bzr-mysql/mysql-5.5-runtime/ rqg_mdl_deadlock ==================== Starting pb2gentest.pl ==================== ############################################################################## # rqg_mdl_deadlock ############################################################################## # 2010-09-24T11:31:40 Gathering info from the environment... # 2010-09-24T11:31:41 ===== Information on the host system: ===== # 2010-09-24T11:31:41 - Local time : Fri Sep 24 11:31:41 2010 # 2010-09-24T11:31:41 - Hostname : nanna21 # 2010-09-24T11:31:41 - Username : bteam # 2010-09-24T11:31:41 - PID : 14531 # 2010-09-24T11:31:41 - Working dir : /export/home/pb2/scripts/http_randgen # 2010-09-24T11:31:41 - PATH : /usr/local/bin:/bin:/usr/bin # 2010-09-24T11:31:41 - Script arguments: # 2010-09-24T11:31:41 basedir = /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test # 2010-09-24T11:31:41 vardir = /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs # 2010-09-24T11:31:41 tree = http://bk-internal.mysql.com/bzr-mysql/mysql-5.5-runtime/ # 2010-09-24T11:31:41 test = rqg_mdl_deadlock # 2010-09-24T11:31:41 ===== Information on the tested binaries (PB2): ===== # 2010-09-24T11:31:41 - Branch URL : http://bk-internal.mysql.com/bzr-mysql/mysql-5.5-runtime/ # 2010-09-24T11:31:41 - Branch name : mysql-5.5-runtime # 2010-09-24T11:31:41 - Revision : jon.hauglid@oracle.com-20100924084409-e1b5fpajkv23cab3 # 2010-09-24T11:31:41 - Source : mysql-5.5.7-m3-linux-i686.tar.gz # 2010-09-24T11:31:41 ===== Information on Random Query Generator version (bzr): ===== # 2010-09-24T11:31:41 - Date (rev) : 2010-09-15 11:24:20 +0300 # 2010-09-24T11:31:41 - Revno : 539 # 2010-09-24T11:31:41 - Revision ID : philips@eve-20100915082420-gwxtyqucsc9v5doh # 2010-09-24T11:31:41 - Branch nick : http_randgen # 2010-09-24T11:31:41 - Clean copy? : Yes # 2010-09-24T11:31:41 Configuring test... # 2010-09-24T11:31:41 XML reporting to TestTool automatically enabled based on hostname. # 2010-09-24T11:31:41 Running runall.pl... # 2010-09-24T11:31:41 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-09-24T11:31:41 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-09-24T11:31:41 Starting # 2010-09-24T11:31:41 # runall.pl \ # 2010-09-24T11:31:41 # --mysqld=--loose-skip-safemalloc \ # 2010-09-24T11:31:41 # --grammar=conf/runtime/WL5004_sql.yy \ # 2010-09-24T11:31:41 # --threads=10 \ # 2010-09-24T11:31:41 # --queries=1M \ # 2010-09-24T11:31:41 # --duration=1200 \ # 2010-09-24T11:31:41 # --mysqld=--innodb \ # 2010-09-24T11:31:41 # --mysqld=--innodb-lock-wait-timeout=50 \ # 2010-09-24T11:31:41 # --mysqld=--lock-wait-timeout=31536000 \ # 2010-09-24T11:31:41 # --mysqld=--log-output=file \ # 2010-09-24T11:31:41 # --reporters=Deadlock,ErrorLog,Backtrace,Shutdown \ # 2010-09-24T11:31:41 # --basedir=/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test \ # 2010-09-24T11:31:41 # --vardir=/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs \ # 2010-09-24T11:31:41 # --mysqld=--loose-table-lock-wait-timeout=1 \ # 2010-09-24T11:31:41 # --testname=rqg_mdl_deadlock \ # 2010-09-24T11:31:41 # --xml-output=/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/rqg_mdl_deadlock.xml \ # 2010-09-24T11:31:41 # --report-xml-tt \ # 2010-09-24T11:31:41 # --report-xml-tt-type=scp \ # 2010-09-24T11:31:41 # --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-09-24T11:31:41 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-09-24T11:31:41 Running perl mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs --master_port=19300 --mysqld="--loose-skip-safemalloc" --mysqld="--innodb" --mysqld="--innodb-lock-wait-timeout=50" --mysqld="--lock-wait-timeout=31536000" --mysqld="--log-output=file" --mysqld="--loose-table-lock-wait-timeout=1" 1st 2>&1 . ======================================================= WARNING: Using mysql-test-run.pl version 1! ======================================================= Logging: lib/v1/mysql-test-run.pl --start-and-exit --skip-ndb --mysqld=--core-file --mysqld=--loose-new --mysqld=--sql-mode=no_engine_substitution --mysqld=--relay-log=slave-relay-bin --mysqld=--loose-innodb --mysqld=--loose-falcon-debug-mask=2 --mysqld=--secure-file-priv= --mysqld=--max-allowed-packet=16Mb --mysqld=--loose-innodb-status-file=1 --mysqld=--master-retry-count=65535 --vardir=/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs --master_port=19300 --mysqld=--loose-skip-safemalloc --mysqld=--innodb --mysqld=--innodb-lock-wait-timeout=50 --mysqld=--lock-wait-timeout=31536000 --mysqld=--log-output=file --mysqld=--loose-table-lock-wait-timeout=1 1st MySQL Version 5.5.7 Using dynamic switching of binlog format Skipping ndbcluster Setting mysqld to support SSL connections Binaries are debug compiled Use of uninitialized value in scalar assignment at lib/v1/mysql-test-run.pl line 1943. Using MTR_BUILD_THREAD = 930 Using MASTER_MYPORT = 19300 Using MASTER_MYPORT1 = 19301 Using SLAVE_MYPORT = 19302 Using SLAVE_MYPORT1 = 19303 Using SLAVE_MYPORT2 = 19304 Using IM_PORT = 19307 Using IM_MYSQLD1_PORT = 19308 Using IM_MYSQLD2_PORT = 19309 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2010-09-24T11:31:55 Starting # 2010-09-24T11:31:55 gentest.pl \ # 2010-09-24T11:31:55 --gendata= \ # 2010-09-24T11:31:55 --reporter=Deadlock \ # 2010-09-24T11:31:55 --reporter=ErrorLog \ # 2010-09-24T11:31:55 --reporter=Backtrace \ # 2010-09-24T11:31:55 --reporter=Shutdown \ # 2010-09-24T11:31:55 --threads=10 \ # 2010-09-24T11:31:55 --queries=1M \ # 2010-09-24T11:31:55 --duration=1200 \ # 2010-09-24T11:31:55 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \ # 2010-09-24T11:31:55 --grammar=conf/runtime/WL5004_sql.yy \ # 2010-09-24T11:31:55 --xml-output=/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/rqg_mdl_deadlock.xml \ # 2010-09-24T11:31:55 --report-xml-tt \ # 2010-09-24T11:31:55 --report-xml-tt-type=scp \ # 2010-09-24T11:31:55 --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ \ # 2010-09-24T11:31:55 --testname=rqg_mdl_deadlock # 2010-09-24T11:31:55 ------------------------------- # 2010-09-24T11:31:55 Configuration # 2010-09-24T11:31:55 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2010-09-24T11:31:55 duration => 1200 # 2010-09-24T11:31:55 gendata => # 2010-09-24T11:31:55 grammar => conf/runtime/WL5004_sql.yy # 2010-09-24T11:31:55 queries => 1M # 2010-09-24T11:31:55 report-xml-tt => 1 # 2010-09-24T11:31:55 report-xml-tt-dest => regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-09-24T11:31:55 report-xml-tt-type => scp # 2010-09-24T11:31:55 reporters => ['Deadlock', 'ErrorLog', 'Backtrace', 'Shutdown'] # 2010-09-24T11:31:55 seed => 1 # 2010-09-24T11:31:55 testname => rqg_mdl_deadlock # 2010-09-24T11:31:55 threads => 10 # 2010-09-24T11:31:55 validators => [''] # 2010-09-24T11:31:55 xml-output => /export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/rqg_mdl_deadlock.xml # 2010-09-24T11:31:55 Executor initialized, id # 2010-09-24T11:31:55 Default schema: test # 2010-09-24T11:31:55 Creating MySQL table A, size 0 rows, engine . # 2010-09-24T11:31:56 Creating MySQL table B, size 1 rows, engine . # 2010-09-24T11:31:56 Creating MySQL table C, size 20 rows, engine . # 2010-09-24T11:31:56 Creating MySQL table D, size 100 rows, engine . # 2010-09-24T11:31:57 Creating MySQL table E, size 1000 rows, engine . # 2010-09-24T11:31:57 Creating MySQL table AA, size 0 rows, engine . # 2010-09-24T11:31:58 Creating MySQL table BB, size 1 rows, engine . # 2010-09-24T11:31:58 Creating MySQL table CC, size 20 rows, engine . # 2010-09-24T11:31:58 Creating MySQL table DD, size 100 rows, engine . # 2010-09-24T11:31:59 Reporters: Deadlock, ErrorLog, Backtrace, Shutdown # 2010-09-24T11:31:59 Validators: ErrorMessageCorruption # 2010-09-24T11:31:59 Starting 10 processes, 1M queries each, duration 1200 seconds. # 2010-09-24T11:31:59 GenTest::ErrorFilter(14921) started # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Query: ALTER SCHEMA testdb_N COLLATE = utf8_bin failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:00 Query: CREATE USER otto@localhost failed: 1396 Operation CREATE USER failed for 'otto'@'localhost'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: INSERT testdb_S . t1_view1_S SELECT `col_int_key` , `pk` , `col_int` FROM testdb_N . t1_base2_N A WHERE testdb_S . f1_1_S () = 8 AND `pk` = 5 LIMIT 1 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: LOCK TABLES testdb_N . t1_merge2_N AS f IN SHARE MODE NOWAIT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:00 Query: /* Sequence start */ CREATE PROCEDURE testdb_S . p1_1_S () BEGIN UPDATE testdb_S . t1_part1_S SET `col_int_key` = 3 WHERE `pk` > 0 LIMIT 7 ; UPDATE testdb_S . t1_temp1_N AS A NATURAL JOIN testdb_N . t1_merge2_N B SET A. `col_int` = 0 , B. `pk` = 5 ; END ; COMMIT ; SELECT SLEEP( 0.5 * 0.53 * 1 ) ; DROP PROCEDURE testdb_S . p1_1_S /* Sequence end */ failed: 1049 Unknown database '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: CALL testdb_N . p1_2_N failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: HANDLER handler_a READ FIRST failed: 1109 Unknown table '%s' in HANDLER. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: LOCK TABLES testdb_S . t1_part1_S AS z IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: LOCK TABLES testdb_S . t1_merge2_S AS i IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: KILL QUERY @kill_id failed: 1317 Query execution was interrupted. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: EXECUTE st1 failed: 1243 Unknown prepared statement handler (%s) given to EXECUTE. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: DEALLOCATE PREPARE st1 failed: 1243 Unknown prepared statement handler (%s) given to DEALLOCATE PREPARE. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Query: SHOW CREATE FUNCTION testdb_N . f1_1_N failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:00 Executor initialized, id 1 # 2010-09-24T11:32:00 Default schema: test # 2010-09-24T11:32:00 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:01 Executor initialized, id 1 # 2010-09-24T11:32:01 Default schema: test # 2010-09-24T11:32:01 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:01 Executor initialized, id 1 # 2010-09-24T11:32:01 Default schema: test # 2010-09-24T11:32:01 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-09-24T11:32:01 Started periodic reporting process... # 2010-09-24T11:32:01 Query: REVOKE ALL ON testdb_S . t1_base2_S FROM otto@localhost failed: 1147 There is no such grant defined for user '%s' on host '%s' on table '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: LOCK TABLES testdb_S . t1_temp1_S AS d IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: ROLLBACK TO SAVEPOINT A failed: 1305 SAVEPOINT %s does not exist. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: ALTER EVENT testdb_S . e1_2_S COMMENT 'UPDATED NOW()' failed: 1539 Unknown event '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: LOCK TABLES testdb_S . t1_part1_S AS n IN EXCLUSIVE MODE , testdb_S . t1_temp2_S AS g IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_S AS g IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: LOCK TABLES testdb_N . t1_view2_N AS d IN EXCLUSIVE MODE , testdb_S . t1_temp2_S AS i IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_S AS i IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: RENAME TABLE testdb_S . t1_part1_N TO testdb_N . t1_part1_N failed: 1017 Can't find file: '%s' (errno: %d). Further errors of this kind will be suppressed. # 2010-09-24T11:32:01 Query: LOCK TABLES testdb_S . t1_temp2_S AS w IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:02 Query: CREATE ALGORITHM = UNDEFINED VIEW testdb_S . t1_view2_N AS SELECT `col_int_key` , `pk` , `col_int` FROM ( SELECT `pk` , `col_int_key` , `pk` FROM testdb_S . t1_base2_S ) AS A NATURAL JOIN testdb_S . t1_part2_S B WHERE `pk` BETWEEN 7 AND 7 + 1 failed: 1349 View's SELECT contains a subquery in the FROM clause. Further errors of this kind will be suppressed. # 2010-09-24T11:32:02 Query: DROP TRIGGER testdb_S . tr1_1_N failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-09-24T11:32:02 Query: LOCK TABLES testdb_S . t1_view2_S AS u IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp2_S AS l IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS l IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:02 Query: BEGIN WORK failed: 2006 MySQL server has gone away # 2010-09-24T11:32:02 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:02 Query: LOCK TABLES testdb_N . t1_temp1_N AS r IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_base1_N AS t IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_base%d_N AS t IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:03 Query: REPLACE testdb_S . t1_part1_S ( `col_int_key` ) VALUES ( 6 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:03 Query: DROP TABLE testdb_N . t1_merge2_N failed: 1051 Unknown table '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:03 Query: ALTER TABLE testdb_S . t1_merge1_N ENGINE = MERGE UNION ( testdb_N . t1_base2_N , testdb_N . t1_base2_N ) failed: 1066 Not unique table/alias: '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:32:04 Query: UPDATE IGNORE testdb_S . t1_view1_N AS A NATURAL JOIN testdb_N . t1_temp2_N B SET A. `pk` = 1 , B. `col_int_key` = 6 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:05 Query: PREPARE st1 FROM " SELECT `col_int_key` , `col_int` , `pk` FROM testdb_N . t1_base1_N AS A WHERE `pk` BETWEEN 8 AND 8 + 1 PROCEDURE ANALYSE( 10 , 2000 ) LOCK IN SHARE MODE " failed: 2006 MySQL server has gone away # 2010-09-24T11:32:05 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:05 Query: LOCK TABLES testdb_S . t1_part2_N AS h IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_merge2_S AS y IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_merge%d_S AS y IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:06 Query: EXECUTE st1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:06 Query: CREATE FUNCTION testdb_N . f1_2_N () RETURNS INTEGER BEGIN INSERT testdb_S . t1_merge1_S ( `pk` ) VALUES ( NULL ) ; SELECT MAX( `col_int_key` ) FROM testdb_S . t1_view2_N INTO @my_var ; RETURN 1 ; END failed: 1304 FUNCTION %s already exists. Further errors of this kind will be suppressed. # 2010-09-24T11:32:06 Query: DELETE FROM test . executors WHERE id = @kill_id failed: 2006 MySQL server has gone away # 2010-09-24T11:32:06 Query: COMMIT AND CHAIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:06 Query: LOCK TABLES testdb_S . t1_merge2_S AS g IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS v IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS v IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:06 Query: LOCK TABLES testdb_S . t1_merge1_N AS p IN SHARE MODE , testdb_S . t1_part2_S AS v IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS v IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: DO GET_LOCK(TRIM(' 9 '), 0.5 * 0.14 * 1 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:07 Query: CREATE DATABASE testdb_N CHARACTER SET = utf8 failed: 1007 Can't create database 'testdb_N'; database exists. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:07 Query: DO RELEASE_LOCK(TRIM(' 0 ')) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:07 Query: CREATE PROCEDURE testdb_N . p1_2_N () BEGIN SELECT SQL_CACHE * FROM testdb_S . t1_temp2_S AS A UNION SELECT * FROM testdb_S . t1_part1_S B WHERE testdb_S . f1_2_S () = 6 AND `pk` = 1 LOCK IN SHARE MODE ; UPDATE LOW_PRIORITY testdb_S . t1_merge1_S SET `pk` = 2 WHERE `pk` > 0 LIMIT 2 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: LOCK TABLES testdb_S . t1_merge2_S AS h IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_view1_S AS j IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_view%d_S AS j IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:07 Query: LOCK TABLES testdb_S . t1_view1_S AS e IN EXCLUSIVE MODE , testdb_S . t1_part2_N AS v IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_part%d_N AS v IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: LOCK TABLES testdb_S . t1_view1_S AS c IN SHARE MODE , testdb_S . t1_base2_S AS t IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS t IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: KILL QUERY @kill_id failed: 1094 Unknown thread id: %s%d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:07 Query: LOCK TABLES testdb_S . t1_merge2_N AS k IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS b IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS b IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:08 Query: LOCK TABLES testdb_N . t1_base2_N AS f IN SHARE MODE NOWAIT , testdb_N . t1_base1_N AS h IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_base%d_N AS h IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:08 Query: LOCK TABLES testdb_N . t1_view1_N AS s IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp1_S AS f IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS f IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:08 Query: LOCK TABLES testdb_S . t1_view2_N AS k IN SHARE MODE , testdb_S . t1_view1_S AS q IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_view%d_S AS q IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:09 Query: ALTER DATABASE testdb_N DEFAULT CHARACTER SET = utf8 failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:09 Query: LOCK TABLES testdb_S . t1_merge2_S AS e IN SHARE MODE NOWAIT , testdb_S . t1_part1_N AS a IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_N AS a IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:09 Query: DROP TABLE IF EXISTS testdb_S . t1_base2_N CASCADE failed: 2006 MySQL server has gone away # 2010-09-24T11:32:09 Query: LOCK TABLES testdb_N . t1_view1_N AS g IN SHARE MODE NOWAIT , testdb_S . t1_view1_N AS p IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_N AS p IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:10 Query: HANDLER testdb_S . t1_base1_S OPEN AS handler_a failed: 2006 MySQL server has gone away # 2010-09-24T11:32:10 Query: LOCK TABLES testdb_S . t1_base1_S AS s IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_merge2_N AS v IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_merge%d_N AS v IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:10 Query: START TRANSACTION failed: 2006 MySQL server has gone away # 2010-09-24T11:32:11 Query: SHOW TABLE STATUS failed: 2006 MySQL server has gone away # 2010-09-24T11:32:11 Query: REPLACE testdb_S . t1_part2_N ( `col_int_key` ) VALUES ( 1 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:11 Query: REPLACE INTO testdb_S . t1_base2_S ( `col_int_key` ) VALUES ( 2 ) failed: 2013 Lost connection to MySQL server during query # 2010-09-24T11:32:11 Query: ROLLBACK WORK AND CHAIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:11 Query: LOCK TABLES testdb_S . t1_merge2_S AS p IN EXCLUSIVE MODE , testdb_N . t1_base1_N AS g IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_N . t%d_base%d_N AS g IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:12 Query: SELECT `col_int` , `col_int_key` , `pk` FROM testdb_N . t1_merge1_N AS A WHERE `pk` BETWEEN 1 AND 1 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:13 Query: LOCK TABLES testdb_N . t1_temp2_N AS t IN EXCLUSIVE MODE , testdb_S . t1_view1_N AS x IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_N AS x IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:13 Query: DO 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:13 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:13 Query: INSERT INTO testdb_S . t1_base2_N ( `pk` ) VALUES ( 0 ) ON DUPLICATE KEY UPDATE `col_int` = 9 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:13 Query: SELECT `pk` , `col_int` , `col_int_key` FROM testdb_S . t1_base1_N AS A WHERE testdb_N . f1_2_N () = 3 AND `pk` = 3 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:14 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:14 Query: START TRANSACTION failed: 2006 MySQL server has gone away # 2010-09-24T11:32:14 Query: LOCK TABLES testdb_S . t1_merge2_S AS v IN SHARE MODE NOWAIT , testdb_S . t1_view1_S AS g IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS g IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:14 Query: LOCK TABLES testdb_S . t1_merge1_S AS x IN SHARE MODE NOWAIT , testdb_S . t1_view1_S AS c IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS c IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:14 Query: LOCK TABLES testdb_N . t1_merge2_N AS c IN EXCLUSIVE MODE , testdb_S . t1_base1_S AS k IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS k IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:15 Query: LOCK TABLES testdb_S . t1_view2_S AS v IN SHARE MODE NOWAIT , testdb_N . t1_merge2_N AS p IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_merge%d_N AS p IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:15 Query: FLUSH TABLE testdb_S . t1_temp2_S failed: 2006 MySQL server has gone away # 2010-09-24T11:32:15 Query: ALTER SCHEMA testdb_N DEFAULT CHARACTER SET = utf8 failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:15 Query: ALTER DATABASE testdb_N DEFAULT COLLATE = utf8_bin failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:16 Query: LOCK TABLES testdb_N . t1_temp1_N AS e IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_part2_S AS f IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_part%d_S AS f IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:16 Query: LOCK TABLES testdb_N . t1_part2_N AS r IN SHARE MODE , testdb_S . t1_merge1_S AS x IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_merge%d_S AS x IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:16 Query: LOCK TABLES testdb_S . t1_temp1_S AS m IN SHARE MODE NOWAIT , testdb_S . t1_view2_S AS l IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS l IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:17 Query: COMMIT WORK AND CHAIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:17 Query: CREATE TEMPORARY TABLE IF NOT EXISTS testdb_N . t1_temp2_N LIKE test.table10_int_autoinc failed: 2006 MySQL server has gone away # 2010-09-24T11:32:18 Query: FLUSH TABLE testdb_S . t1_base1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:18 Query: LOCK TABLES testdb_S . t1_part1_S AS q IN SHARE MODE , testdb_S . t1_view1_N AS b IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_view%d_N AS b IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:18 Query: LOCK TABLES testdb_S . t1_base2_S AS s IN EXCLUSIVE MODE , testdb_S . t1_view1_S AS y IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_S AS y IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:18 Query: LOCK TABLES testdb_S . t1_base1_S AS z IN EXCLUSIVE MODE , testdb_S . t1_base2_S AS n IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS n IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:18 Query: LOCK TABLES testdb_N . t1_base2_N AS w IN SHARE MODE , testdb_S . t1_temp1_S AS m IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_temp%d_S AS m IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:18 Query: LOCK TABLES testdb_N . t1_part1_N AS x IN SHARE MODE , testdb_S . t1_part1_N AS w IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_N AS w IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:19 Query: UPDATE LOW_PRIORITY testdb_S . t1_base2_S AS A NATURAL JOIN testdb_N . t1_base1_N B SET A. `col_int` = 5 , B. `pk` = 5 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:19 Query: PREPARE st1 FROM " REPLACE testdb_S . t1_view1_S ( `pk` , `col_int_key` , `pk` ) SELECT HIGH_PRIORITY `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base1_S A NATURAL JOIN testdb_S . t1_base1_S B WHERE testdb_S . f1_2_N () = 8 AND `pk` = 5 LIMIT 1 " failed: 2006 MySQL server has gone away # 2010-09-24T11:32:19 Query: INSERT INTO testdb_S . t1_part1_S ( `pk` , `col_int` , `col_int_key` ) SELECT `pk` , `col_int` , `col_int_key` FROM testdb_S . t1_temp2_N WHERE SLEEP( 0.5 * 0.51 * 1 ) = 0 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:19 Query: LOCK TABLES testdb_S . t1_merge2_N AS j IN SHARE MODE NOWAIT , testdb_S . t1_part2_N AS v IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_N AS v IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:19 Query: LOCK TABLES testdb_S . t1_base2_S AS w IN SHARE MODE NOWAIT , testdb_S . t1_merge1_S AS u IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_merge%d_S AS u IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:20 Query: DO IS_FREE_LOCK(TRIM(' 1 ')) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:20 Query: HANDLER handler_a READ FIRST failed: 2006 MySQL server has gone away # 2010-09-24T11:32:20 Query: LOCK TABLES testdb_N . t1_part1_N AS c IN SHARE MODE , testdb_S . t1_part1_S AS j IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS j IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:20 Query: LOCK TABLES testdb_N . t1_view1_N AS l IN SHARE MODE , testdb_S . t1_base1_S AS f IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS f IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:21 Query: LOCK TABLES testdb_S . t1_merge1_S AS l IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_part1_S AS j IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_part%d_S AS j IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:21 Query: LOCK TABLES testdb_S . t1_part2_S AS s IN SHARE MODE NOWAIT , testdb_S . t1_view2_S AS j IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS j IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:21 Query: ALTER TABLE testdb_S . t1_base1_S CHANGE COLUMN my_column `col_int` INT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:21 Query: FLUSH TABLE testdb_S . t1_merge2_N failed: 2013 Lost connection to MySQL server during query # 2010-09-24T11:32:21 Query: FLUSH TABLE testdb_N . t1_view2_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:21 Query: BEGIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:21 Query: LOCK TABLES testdb_S . t1_view2_S AS i IN SHARE MODE NOWAIT , testdb_N . t1_temp1_N AS l IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_temp%d_N AS l IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:22 Query: FLUSH TABLE testdb_S . t1_part1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:22 Query: COMMIT WORK failed: 2006 MySQL server has gone away # 2010-09-24T11:32:22 Query: LOCK TABLES testdb_N . t1_view1_N AS j IN EXCLUSIVE MODE , testdb_S . t1_base1_N AS h IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_N AS h IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:23 Query: CREATE ALGORITHM = UNDEFINED VIEW testdb_S . t1_view1_N AS SELECT `col_int` , `pk` , `col_int_key` FROM testdb_S . t1_base1_S AS A WHERE `pk` BETWEEN 4 AND 4 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:24 Query: PREPARE st1 FROM " SELECT 1 FROM testdb_S . t1_part1_S WHERE SLEEP( 0.5 * 0.75 * 1 ) = 0 LIMIT 1 " failed: 2006 MySQL server has gone away # 2010-09-24T11:32:24 Query: LOCK TABLES testdb_N . t1_part1_N AS b IN SHARE MODE , testdb_S . t1_view1_N AS d IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_view%d_N AS d IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:24 Query: ALTER DATABASE testdb_N DEFAULT COLLATE = utf8_bin failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:24 Query: DROP TABLE IF EXISTS testdb_N . t1_base2_N CASCADE failed: 2006 MySQL server has gone away # 2010-09-24T11:32:24 Query: FLUSH TABLE testdb_S . t1_view1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:24 Query: LOCK TABLES testdb_S . t1_part1_S AS z IN SHARE MODE NOWAIT , testdb_S . t1_view2_S AS s IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS s IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:24 Query: LOCK TABLES testdb_S . t1_view1_N AS v IN SHARE MODE , testdb_S . t1_part2_S AS l IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS l IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:24 Query: LOCK TABLES testdb_S . t1_view2_S AS o IN SHARE MODE NOWAIT , testdb_S . t1_part2_N AS v IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_N AS v IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:25 Query: LOCK TABLES testdb_N . t1_base1_N AS o IN EXCLUSIVE MODE , testdb_S . t1_view2_S AS v IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_S AS v IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:25 Query: SHOW FUNCTION STATUS failed: 2006 MySQL server has gone away # 2010-09-24T11:32:26 Query: LOCK TABLES testdb_S . t1_view2_S AS m IN SHARE MODE NOWAIT , testdb_N . t1_temp1_N AS v IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_temp%d_N AS v IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:26 Query: BEGIN WORK failed: 2006 MySQL server has gone away # 2010-09-24T11:32:26 Query: LOCK TABLES testdb_S . t1_base1_N AS f IN EXCLUSIVE MODE , testdb_S . t1_view2_S AS z IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_S AS z IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:26 Query: LOCK TABLES testdb_S . t1_part1_N AS t IN SHARE MODE NOWAIT , testdb_S . t1_base2_S AS w IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_base%d_S AS w IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:26 Query: LOCK TABLES testdb_S . t1_part2_S AS t IN SHARE MODE NOWAIT , testdb_S . t1_base1_N AS z IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_base%d_N AS z IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:27 Query: LOCK TABLES testdb_S . t1_temp1_S AS j IN SHARE MODE , testdb_N . t1_temp2_N AS k IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_temp%d_N AS k IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:27 Query: LOCK TABLES testdb_S . t1_merge1_N AS h IN SHARE MODE , testdb_S . t1_base2_S AS f IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS f IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:27 Query: LOCK TABLES testdb_S . t1_part2_N AS x IN SHARE MODE , testdb_S . t1_part1_S AS h IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS h IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:28 Query: DO ( SELECT COUNT(*) FROM testdb_S . t1_base2_N WHERE `pk` BETWEEN 6 AND 6 + 20 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:28 Query: SELECT * FROM test.table10_int INTO OUTFILE '/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/gentest14929.tmp' failed: 2006 MySQL server has gone away # 2010-09-24T11:32:28 Query: LOCK TABLES testdb_S . t1_merge2_S AS t IN SHARE MODE NOWAIT , testdb_N . t1_part2_N AS y IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_part%d_N AS y IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:29 Query: LOCK TABLES testdb_S . t1_temp1_N AS o IN EXCLUSIVE MODE , testdb_S . t1_temp2_S AS m IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_S AS m IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:29 Query: LOCK TABLES testdb_S . t1_temp1_S AS a IN SHARE MODE , testdb_S . t1_base2_S AS b IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS b IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:29 Query: LOCK TABLES testdb_S . t1_part2_S AS u IN EXCLUSIVE MODE , testdb_S . t1_view2_S AS c IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_S AS c IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:29 Query: LOCK TABLES testdb_N . t1_temp1_N AS e IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS b IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS b IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:30 Query: COMMIT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:30 Query: DELETE A , B FROM testdb_N . t1_merge1_N AS A NATURAL JOIN testdb_S . t1_base2_S B WHERE `pk` BETWEEN 6 AND 6 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:30 Query: LOCK TABLES testdb_S . t1_base1_S AS p IN EXCLUSIVE MODE , testdb_S . t1_merge1_S AS d IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_merge%d_S AS d IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:30 Query: CREATE TABLE testdb_S . t1_base1_N LIKE test.table10_int_autoinc failed: 2006 MySQL server has gone away # 2010-09-24T11:32:30 Query: DO ( SELECT COUNT(*) FROM testdb_S . t1_merge1_S WHERE `pk` BETWEEN 9 AND 9 + 20 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:31 Query: DROP DATABASE IF EXISTS testdb_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:32 Query: HANDLER testdb_N . t1_base2_N OPEN AS handler_a failed: 2006 MySQL server has gone away # 2010-09-24T11:32:32 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:32 Query: ROLLBACK WORK AND CHAIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:32 Query: HANDLER handler_a READ FIRST failed: 2006 MySQL server has gone away # 2010-09-24T11:32:33 Query: HANDLER handler_a READ FIRST failed: 2006 MySQL server has gone away # 2010-09-24T11:32:33 Query: LOCK TABLES testdb_S . t1_temp2_S AS c IN SHARE MODE , testdb_N . t1_part2_N AS b IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_part%d_N AS b IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:33 Query: LOCK TABLES testdb_S . t1_merge1_S AS f IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_view1_S AS x IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_view%d_S AS x IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:33 Query: COMMIT AND CHAIN failed: 2006 MySQL server has gone away # 2010-09-24T11:32:33 Query: LOCK TABLES testdb_N . t1_view1_N AS q IN SHARE MODE NOWAIT , testdb_N . t1_view2_N AS s IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_view%d_N AS s IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:33 Query: SELECT `col_int` , `col_int_key` , `pk` FROM testdb_N . t1_merge2_N AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_S . t1_part1_N AS B WHERE B.`pk` = A.`pk` ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:33 Query: LOCK TABLES testdb_S . t1_merge2_S AS z IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_view1_S AS e IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_view%d_S AS e IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:34 Query: FLUSH TABLE testdb_S . t1_merge1_S failed: 2006 MySQL server has gone away # 2010-09-24T11:32:34 Query: UPDATE testdb_S . t1_merge2_S AS A NATURAL JOIN testdb_S . t1_temp1_N B SET A. `pk` = 3 , B. `col_int_key` = 8 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:34 Query: LOCK TABLES testdb_S . t1_view1_S AS g IN EXCLUSIVE MODE , testdb_S . t1_base2_N AS r IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_N AS r IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:34 Query: LOCK TABLES testdb_N . t1_part1_N AS r IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp1_S AS z IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS z IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:34 Query: LOCK TABLES testdb_S . t1_base1_S AS h IN EXCLUSIVE MODE , testdb_S . t1_view1_N AS t IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_N AS t IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:34 Query: LOCK TABLES testdb_N . t1_base2_N AS o IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS s IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS s IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:35 Query: HANDLER handler_a READ NEXT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:35 Query: REPLACE testdb_S . t1_merge1_S ( `pk` ) VALUES ( NULL ) failed: 2006 MySQL server has gone away # 2010-09-24T11:32:36 Query: ALTER EVENT testdb_S . e1_1_S COMMENT 'UPDATED NOW()' failed: 2006 MySQL server has gone away # 2010-09-24T11:32:36 Query: UNLOCK TABLES failed: 2013 Lost connection to MySQL server during query # 2010-09-24T11:32:36 Query: FLUSH TABLE testdb_N . t1_view1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:36 Query: LOCK TABLES testdb_N . t1_temp2_N AS g IN EXCLUSIVE MODE , testdb_S . t1_merge1_S AS b IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_merge%d_S AS b IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:36 Query: LOCK TABLES testdb_S . t1_base1_S AS g IN SHARE MODE , testdb_S . t1_part2_S AS i IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS i IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:37 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:37 Query: FLUSH TABLE testdb_N . t1_base2_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:37 Query: LOCK TABLES testdb_S . t1_view1_S AS x IN SHARE MODE failed: 2006 MySQL server has gone away # 2010-09-24T11:32:37 Query: LOCK TABLES testdb_S . t1_temp2_N AS q IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_part2_N AS m IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_part%d_N AS m IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:37 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:37 Query: LOCK TABLES testdb_S . t1_part2_S AS l IN SHARE MODE , testdb_S . t1_base2_S AS h IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS h IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:37 Query: LOCK TABLES testdb_N . t1_temp2_N AS b IN EXCLUSIVE MODE NOWAIT , testdb_N . t1_merge2_N AS y IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_N . t%d_merge%d_N AS y IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:38 Query: LOCK TABLES testdb_S . t1_base1_S AS q IN EXCLUSIVE MODE , testdb_S . t1_view2_N AS b IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_N AS b IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:38 Query: LOCK TABLES testdb_S . t1_merge2_S AS t IN EXCLUSIVE MODE , testdb_S . t1_view2_N AS j IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_N AS j IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:38 Query: LOCK TABLES testdb_N . t1_view1_N AS d IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS g IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS g IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:39 Query: ALTER SCHEMA testdb_N DEFAULT COLLATE utf8_bin failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:39 Query: ALTER DATABASE testdb_N DEFAULT CHARACTER SET utf8 failed: 1 Can't create/write to file './testdb_N/db.opt' (Errcode: 2) # 2010-09-24T11:32:39 Query: FLUSH TABLE testdb_S . t1_part2_S failed: 2006 MySQL server has gone away # 2010-09-24T11:32:39 Query: HANDLER handler_a CLOSE failed: 2006 MySQL server has gone away # 2010-09-24T11:32:39 Query: DROP DATABASE testdb_N failed: 1008 Can't drop database 'testdb_N'; database doesn't exist # 2010-09-24T11:32:39 Query: UPDATE testdb_S . t1_merge1_S AS A NATURAL JOIN testdb_N . t1_base2_N B SET A. `col_int` = 2 , B. `col_int_key` = 5 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:40 Query: HANDLER handler_a CLOSE failed: 2006 MySQL server has gone away # 2010-09-24T11:32:40 Query: LOCK TABLES testdb_N . t1_merge1_N AS q IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_view1_S AS q IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_view%d_S AS q IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:40 Query: UPDATE testdb_N . t1_view2_N SET `col_int_key` = 5 WHERE `pk` > 7 LIMIT 2 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:41 Query: LOCK TABLES testdb_S . t1_merge2_S AS c IN EXCLUSIVE MODE , testdb_S . t1_temp1_S AS r IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_S AS r IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:42 Query: LOCK TABLES testdb_S . t1_merge1_N AS e IN EXCLUSIVE MODE , testdb_N . t1_merge1_N AS d IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_N . t%d_merge%d_N AS d IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:42 Query: LOCK TABLES testdb_N . t1_base2_N AS k IN EXCLUSIVE MODE , testdb_S . t1_base2_S AS m IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS m IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:42 Query: LOCK TABLES testdb_S . t1_temp2_S AS x IN SHARE MODE NOWAIT , testdb_S . t1_merge2_S AS r IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_merge%d_S AS r IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:42 Query: LOCK TABLES testdb_S . t1_merge2_N AS n IN SHARE MODE , testdb_S . t1_merge2_S AS t IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_merge%d_S AS t IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:43 Query: ALTER TABLE testdb_S . t1_base2_S CHANGE COLUMN my_column `col_int_key` INT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:44 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:44 Query: LOCK TABLES testdb_S . t1_view2_N AS h IN SHARE MODE NOWAIT , testdb_S . t1_view1_S AS y IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS y IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:44 Query: LOCK TABLES testdb_N . t1_part2_N AS p IN SHARE MODE NOWAIT , testdb_S . t1_temp2_S AS a IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_temp%d_S AS a IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:44 Query: LOCK TABLES testdb_N . t1_view2_N AS h IN EXCLUSIVE MODE , testdb_S . t1_base2_S AS r IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS r IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:44 Query: LOCK TABLES testdb_S . t1_merge1_S AS p IN EXCLUSIVE MODE , testdb_N . t1_base2_N AS o IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_N . t%d_base%d_N AS o IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:44 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:44 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:44 Query: ROLLBACK WORK TO A failed: 2006 MySQL server has gone away # 2010-09-24T11:32:45 Query: DROP TABLE IF EXISTS testdb_N . t1_merge1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:45 Query: LOCK TABLES testdb_N . t1_merge2_N AS v IN SHARE MODE NOWAIT , testdb_N . t1_merge2_N AS o IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_merge%d_N AS o IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:45 Query: LOCK TABLES testdb_N . t1_base2_N AS w IN SHARE MODE , testdb_S . t1_part2_S AS z IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS z IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:45 Query: HANDLER testdb_S . t1_temp1_S OPEN AS handler_a failed: 2006 MySQL server has gone away # 2010-09-24T11:32:45 Query: FLUSH TABLE testdb_S . t1_part2_N failed: 2013 Lost connection to MySQL server during query # 2010-09-24T11:32:45 Query: LOCK TABLES testdb_N . t1_view1_N AS d IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_part2_S AS d IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_part%d_S AS d IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:46 Query: LOCK TABLES testdb_N . t1_base1_N AS z IN SHARE MODE , testdb_N . t1_view2_N AS n IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_view%d_N AS n IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:46 Query: LOCK TABLES testdb_S . t1_temp1_N AS f IN EXCLUSIVE MODE , testdb_S . t1_base1_S AS s IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS s IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:47 Query: INSERT INTO testdb_S . t1_view2_N ( `pk` , `col_int` , `col_int_key` ) SELECT `pk` , `col_int` , `col_int_key` FROM testdb_N . t1_view1_N WHERE SLEEP( 0.5 * 0.64 * 1 ) = 0 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:47 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:47 Query: LOCK TABLES testdb_N . t1_base2_N AS t IN SHARE MODE NOWAIT , testdb_S . t1_view1_S AS e IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS e IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:48 Query: LOCK TABLES testdb_S . t1_merge2_S AS a IN SHARE MODE NOWAIT , testdb_S . t1_temp1_S AS m IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_temp%d_S AS m IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:48 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:50 Query: COMMIT WORK failed: 2006 MySQL server has gone away # 2010-09-24T11:32:51 Query: UPDATE testdb_S . t1_temp1_N SET `col_int_key` = 9 WHERE `pk` > 5 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:51 Query: LOCK TABLES testdb_S . t1_temp2_S AS b IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_merge1_S AS q IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_merge%d_S AS q IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:51 Query: LOCK TABLES testdb_S . t1_part1_N AS z IN SHARE MODE , testdb_S . t1_temp2_S AS x IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_temp%d_S AS x IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:51 Query: LOCK TABLES testdb_S . t1_base2_S AS b IN EXCLUSIVE MODE , testdb_S . t1_merge2_S AS t IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_merge%d_S AS t IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:51 Query: LOCK TABLES testdb_S . t1_temp1_S AS l IN SHARE MODE , testdb_S . t1_base2_N AS y IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_N AS y IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:52 Query: PREPARE st1 FROM " DO ( SELECT COUNT(*) FROM testdb_S . t1_base1_N WHERE `pk` BETWEEN 0 AND 0 + 20 ) " failed: 2006 MySQL server has gone away # 2010-09-24T11:32:52 Query: LOCK TABLES testdb_N . t1_part2_N AS v IN EXCLUSIVE MODE NOWAIT , testdb_N . t1_view2_N AS p IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_N . t%d_view%d_N AS p IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:52 Query: LOCK TABLES testdb_S . t1_temp2_N AS o IN EXCLUSIVE MODE NOWAIT , testdb_N . t1_base2_N AS h IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_N . t%d_base%d_N AS h IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:53 Query: LOCK TABLES testdb_S . t1_base1_N AS i IN EXCLUSIVE MODE , testdb_S . t1_base1_S AS h IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS h IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:53 Query: LOCK TABLES testdb_S . t1_part1_S AS o IN SHARE MODE , testdb_N . t1_merge2_N AS c IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_merge%d_N AS c IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:54 Query: LOCK TABLES testdb_S . t1_view1_S AS l IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp1_S AS h IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS h IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:54 Query: LOCK TABLES testdb_S . t1_base1_S AS x IN SHARE MODE NOWAIT , testdb_S . t1_part2_S AS i IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS i IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:55 Query: SELECT `col_int_key` , `pk` , `col_int` FROM testdb_S . t1_merge2_S AS A UNION SELECT * FROM testdb_S . t1_merge2_N AS B WHERE `pk` BETWEEN 5 AND 5 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:55 Query: LOCK TABLES testdb_S . t1_base1_N AS g IN SHARE MODE , testdb_S . t1_part2_S AS j IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS j IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:56 Query: LOCK TABLES testdb_S . t1_temp2_N AS c IN SHARE MODE NOWAIT , testdb_S . t1_merge2_N AS r IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_merge%d_N AS r IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:56 Query: LOCK TABLES testdb_S . t1_view2_N AS w IN SHARE MODE , testdb_N . t1_temp1_N AS o IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_temp%d_N AS o IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:56 Query: COMMIT failed: 2006 MySQL server has gone away # 2010-09-24T11:32:56 Query: LOCK TABLES testdb_S . t1_view1_N AS c IN SHARE MODE , testdb_S . t1_base2_N AS j IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_N AS j IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:56 Query: LOCK TABLES testdb_S . t1_view2_N AS i IN SHARE MODE NOWAIT , testdb_S . t1_part1_S AS x IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS x IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:56 Query: REPLACE testdb_S . t1_part1_N SELECT HIGH_PRIORITY `col_int_key` , `pk` , `col_int` FROM testdb_S . t1_part1_S A WHERE `pk` BETWEEN 4 AND 4 + 1 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:56 Query: LOCK TABLES testdb_N . t1_part1_N AS b IN SHARE MODE NOWAIT , testdb_S . t1_view2_S AS x IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS x IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:57 Query: CALL testdb_S . p1_1_S failed: 2006 MySQL server has gone away # 2010-09-24T11:32:57 Query: LOCK TABLES testdb_S . t1_part2_S AS c IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_part2_S AS k IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_part%d_S AS k IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:57 Query: HANDLER testdb_S . t1_merge2_N OPEN handler_a failed: 2006 MySQL server has gone away # 2010-09-24T11:32:57 Query: CALL testdb_S . p1_1_N failed: 2006 MySQL server has gone away # 2010-09-24T11:32:57 Query: LOCK TABLES testdb_S . t1_view1_S AS v IN SHARE MODE , testdb_S . t1_view1_S AS z IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_view%d_S AS z IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:59 Query: SELECT HIGH_PRIORITY `pk` , `col_int` , `col_int_key` FROM testdb_S . t1_part1_S AS A NATURAL JOIN testdb_S . t1_base2_S B WHERE `pk` BETWEEN 9 AND 9 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:32:59 Query: LOCK TABLES testdb_S . t1_view1_S AS i IN SHARE MODE NOWAIT , testdb_S . t1_view2_S AS o IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_S AS o IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:32:59 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:32:59 Query: LOCK TABLES testdb_N . t1_view2_N AS z IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_view1_S AS w IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_view%d_S AS w IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:00 Query: LOCK TABLES testdb_N . t1_base1_N AS d IN EXCLUSIVE MODE NOWAIT , testdb_N . t1_temp2_N AS b IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_N . t%d_temp%d_N AS b IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:00 Query: LOCK TABLES testdb_S . t1_temp1_N AS c IN SHARE MODE , testdb_S . t1_part2_S AS s IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS s IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:00 Query: SELECT COUNT(*) FROM mysql.tables_priv WHERE user = LOWER('OTTO') failed: 2006 MySQL server has gone away # 2010-09-24T11:33:00 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:00 Query: LOCK TABLES testdb_S . t1_temp2_N AS a IN EXCLUSIVE MODE , testdb_S . t1_base1_S AS u IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS u IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:00 Query: LOCK TABLES testdb_S . t1_base1_N AS i IN EXCLUSIVE MODE , testdb_S . t1_base1_S AS k IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_base%d_S AS k IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:01 Query: LOCK TABLES testdb_N . t1_temp2_N AS b IN EXCLUSIVE MODE , testdb_S . t1_part2_S AS x IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_part%d_S AS x IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:01 Query: LOCK TABLES testdb_N . t1_view1_N AS a IN SHARE MODE NOWAIT , testdb_N . t1_base1_N AS z IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_base%d_N AS z IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:01 Query: SET SESSION SQL_MODE='' failed: 2006 MySQL server has gone away # 2010-09-24T11:33:02 Query: FLUSH TABLE testdb_S . t1_temp2_S failed: 2006 MySQL server has gone away # 2010-09-24T11:33:02 Query: LOCK TABLES testdb_S . t1_temp1_N AS e IN SHARE MODE , testdb_S . t1_merge1_S AS b IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_merge%d_S AS b IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:03 Query: HANDLER handler_a READ `PRIMARY` = ( 3 ) failed: 2006 MySQL server has gone away # 2010-09-24T11:33:03 Query: FLUSH TABLE testdb_S . t1_merge2_N failed: 2006 MySQL server has gone away # 2010-09-24T11:33:03 Query: CALL testdb_S . p1_2_S failed: 2006 MySQL server has gone away # 2010-09-24T11:33:03 Query: LOCK TABLES testdb_S . t1_merge1_N AS c IN SHARE MODE NOWAIT , testdb_S . t1_temp2_N AS n IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_temp%d_N AS n IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:03 Query: LOCK TABLES testdb_N . t1_merge1_N AS k IN SHARE MODE , testdb_S . t1_part1_S AS e IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_part%d_S AS e IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:04 Query: SELECT `col_int_key` , `col_int` , `pk` FROM testdb_N . t1_temp2_N A WHERE testdb_S . f1_2_S () = 9 AND `pk` = 3 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:04 Query: ALTER TABLE testdb_S . t1_merge2_S CHANGE COLUMN `pk` my_column INT failed: 2006 MySQL server has gone away # 2010-09-24T11:33:04 Query: LOCK TABLES testdb_S . t1_view2_S AS s IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_merge1_S AS q IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_merge%d_S AS q IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:05 Query: LOCK TABLES testdb_S . t1_view1_N AS f IN SHARE MODE , testdb_S . t1_view2_S AS b IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_view%d_S AS b IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:05 Query: LOCK TABLES testdb_S . t1_merge2_S AS m IN SHARE MODE , testdb_N . t1_base1_N AS g IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_base%d_N AS g IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_merge1_N AS w IN SHARE MODE NOWAIT failed: 2006 MySQL server has gone away # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_temp1_S AS a IN EXCLUSIVE MODE , testdb_S . t1_temp2_N AS c IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_N AS c IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_part1_N AS i IN EXCLUSIVE MODE , testdb_S . t1_view1_S AS r IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_S AS r IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_N . t1_view2_N AS j IN SHARE MODE , testdb_S . t1_base2_S AS b IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_S . t%d_base%d_S AS b IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_view2_N AS z IN SHARE MODE NOWAIT , testdb_S . t1_part2_S AS r IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_part%d_S AS r IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_base1_N AS i IN SHARE MODE NOWAIT , testdb_N . t1_temp1_N AS r IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_temp%d_N AS r IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:06 Query: LOCK TABLES testdb_S . t1_merge2_N AS f IN EXCLUSIVE MODE , testdb_S . t1_view1_N AS l IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_view%d_N AS l IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:07 Query: /* testdb_S . t1_base2_S */ INSERT INTO mysql.tables_priv (host,db,user,table_name,grantor,table_priv) VALUES (LOWER('LOCALHOST'),TRIM(' '),LOWER('OTTO'),TRIM(' t1_base2_S '),LOWER('ROOT@LOCALHOST'),'Select') failed: 1062 Duplicate entry '%s' for key '%s'. Further errors of this kind will be suppressed. # 2010-09-24T11:33:07 Query: LOCK TABLES testdb_S . t1_view2_S AS p IN SHARE MODE NOWAIT , testdb_N . t1_part1_N AS h IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_part%d_N AS h IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:07 Query: LOCK TABLES testdb_S . t1_part2_S AS o IN EXCLUSIVE MODE , testdb_S . t1_merge1_N AS e IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_merge%d_N AS e IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:08 Query: UPDATE testdb_S . t1_part2_N SET `pk` = 1 WHERE SLEEP( 0.5 * 0.16 * 1 ) = 0 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:08 Query: LOCK TABLES testdb_S . t1_merge2_N AS r IN SHARE MODE NOWAIT , testdb_S . t1_view2_N AS k IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_view%d_N AS k IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:08 Query: LOCK TABLES testdb_N . t1_part1_N AS a IN SHARE MODE NOWAIT , testdb_S . t1_temp2_S AS i IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_S . t%d_temp%d_S AS i IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:08 Query: PREPARE st1 FROM " SELECT `col_int` , `pk` , `col_int_key` FROM testdb_S . t1_temp1_S A UNION SELECT * FROM testdb_S . t1_merge1_S AS B WHERE testdb_N . f1_1_N () = 6 AND `pk` = 4 " failed: 2006 MySQL server has gone away # 2010-09-24T11:33:08 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:08 Query: CALL testdb_S . p1_2_S failed: 2006 MySQL server has gone away # 2010-09-24T11:33:08 Query: LOCK TABLES testdb_N . t1_part2_N AS b IN EXCLUSIVE MODE , testdb_S . t1_temp2_N AS n IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_temp%d_N AS n IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:09 Query: LOCK TABLES testdb_S . t1_merge2_S AS t IN EXCLUSIVE MODE , testdb_N . t1_part2_N AS c IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_N . t%d_part%d_N AS c IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:09 Query: LOCK TABLES testdb_S . t1_temp2_N AS r IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp1_S AS t IN EXCLUSIVE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS t IN EXCLUSIVE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:09 Query: LOCK TABLES testdb_S . t1_temp1_S AS m IN EXCLUSIVE MODE , testdb_N . t1_view2_N AS l IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_N . t%d_view%d_N AS l IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:09 Query: LOCK TABLES testdb_S . t1_base1_N AS l IN SHARE MODE NOWAIT , testdb_N . t1_base2_N AS d IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_base%d_N AS d IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:09 Query: HANDLER handler_a READ `PRIMARY` PREV failed: 2006 MySQL server has gone away # 2010-09-24T11:33:09 Query: CALL testdb_S . p1_2_N failed: 2006 MySQL server has gone away # 2010-09-24T11:33:09 Query: FLUSH TABLE testdb_S . t1_temp1_S failed: 2006 MySQL server has gone away # 2010-09-24T11:33:09 Query: START TRANSACTION failed: 2013 Lost connection to MySQL server during query # 2010-09-24T11:33:10 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:10 Query: CREATE TABLE IF NOT EXISTS testdb_N . t1_base2_N LIKE test.table1_int failed: 2006 MySQL server has gone away # 2010-09-24T11:33:10 Query: HANDLER handler_a READ FIRST failed: 2006 MySQL server has gone away # 2010-09-24T11:33:10 Query: SELECT `col_int` , `pk` , `col_int_key` FROM testdb_S . t1_merge2_S AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_base2_N AS B WHERE B.`pk` = A.`pk` ) failed: 2006 MySQL server has gone away # 2010-09-24T11:33:11 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:11 Query: LOCK TABLES testdb_S . t1_merge1_S AS f IN SHARE MODE NOWAIT , testdb_N . t1_view1_N AS o IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE NOWAIT , testdb_N . t%d_view%d_N AS o IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:11 Query: DELETE IGNORE A FROM testdb_S . t1_part1_N AS A WHERE `pk` BETWEEN 4 AND 4 + 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:11 Query: LOCK TABLES testdb_S . t1_view2_N AS z IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_base2_N AS y IN EXCLUSIVE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_base%d_N AS y IN EXCLUSIVE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:11 Query: LOCK TABLES testdb_N . t1_view2_N AS z IN EXCLUSIVE MODE failed: 2006 MySQL server has gone away # 2010-09-24T11:33:11 Query: LOCK TABLES testdb_S . t1_temp2_S AS m IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_base2_S AS e IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_base%d_S AS e IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:11 Query: ROLLBACK TO SAVEPOINT B failed: 2006 MySQL server has gone away # 2010-09-24T11:33:11 Query: UNLOCK TABLES failed: 2006 MySQL server has gone away # 2010-09-24T11:33:12 Query: LOCK TABLES testdb_S . t1_base1_S AS k IN SHARE MODE , testdb_N . t1_merge1_N AS o IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_merge%d_N AS o IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:12 Query: DELETE FROM testdb_S . t1_part2_N WHERE `pk` > 2 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:12 Query: FLUSH TABLE testdb_S . t1_base1_S failed: 2006 MySQL server has gone away # 2010-09-24T11:33:12 Query: INSERT INTO testdb_S . t1_view2_S SELECT HIGH_PRIORITY `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base2_S AS A NATURAL JOIN testdb_S . t1_temp2_N B WHERE testdb_S . f1_2_S () = 8 AND `pk` = 0 LIMIT 1 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:12 Query: LOCK TABLES testdb_S . t1_part1_N AS y IN SHARE MODE , testdb_N . t1_temp2_N AS p IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_temp%d_N AS p IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:13 Query: DELETE A , B FROM testdb_N . t1_base1_N AS A NATURAL JOIN testdb_N . t1_temp2_N B WHERE testdb_S . f1_2_S () = 6 AND `pk` = 8 failed: 2006 MySQL server has gone away # 2010-09-24T11:33:13 Query: CALL testdb_N . p1_2_N failed: 1457 Failed to load routine testdb_N.p1_2_N. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6) # 2010-09-24T11:33:13 Query: FLUSH TABLE testdb_S . t1_merge2_N failed: 2006 MySQL server has gone away # 2010-09-24T11:33:13 Query: LOCK TABLES testdb_S . t1_merge2_S AS v IN SHARE MODE , testdb_N . t1_view2_N AS u IN SHARE MODE NOWAIT failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN SHARE MODE , testdb_N . t%d_view%d_N AS u IN SHARE MODE NOWAIT' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:14 Query: /* Sequence start */ CREATE TABLE IF NOT EXISTS testdb_S . t1_base2_S LIKE test.table10_int_autoinc ; ALTER TABLE testdb_S . t1_base2_S ENGINE = InnoDB ; INSERT INTO testdb_S . t1_base2_S SELECT * FROM test.table10_int_autoinc ; COMMIT ; SELECT SLEEP( 0.13 * 1 ) ; DROP TABLE testdb_S . t1_base2_S /* Sequence end */ failed: 2006 MySQL server has gone away # 2010-09-24T11:33:14 Query: LOCK TABLES testdb_S . t1_part2_N AS j IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_temp2_S AS n IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE NOWAIT , testdb_S . t%d_temp%d_S AS n IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:14 Query: LOCK TABLES testdb_S . t1_view2_S AS v IN EXCLUSIVE MODE , testdb_S . t1_part1_N AS d IN SHARE MODE failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN EXCLUSIVE MODE , testdb_S . t%d_part%d_N AS d IN SHARE MODE' at line %d. Further errors of this kind will be suppressed. # 2010-09-24T11:33:14 Query: SHOW TRIGGERS failed: 2006 MySQL server has gone away # 2010-09-24T11:33:14 Query: CREATE TEMPORARY TABLE IF NOT EXISTS testdb_N . t1_temp1_N LIKE test.table0_int failed: 2006 MySQL server has gone away # 2010-09-24T11:33:15 Query: /* Sequence start */ CREATE SCHEMA testdb_S ; SELECT SLEEP( 2 * 0.34 * 1 ) ; DROP SCHEMA testdb_S /* Sequence end */ failed: 1007 Can't create database 'testdb_S'; database exists. Further errors of this kind will be suppressed. # 2010-09-24T11:43:21 10 stalled queries detected, declaring deadlock at DSN dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test. # 2010-09-24T11:43:21 Executing SHOW PROCESSLIST: $VAR1 = [ [ '1', 'root', 'localhost:57285', 'test', 'Sleep', '686', '', undef ], [ '144', 'root', 'localhost:57404', 'test', 'Query', '606', 'Waiting for table metadata lock', 'CREATE ALGORITHM = TEMPTABLE VIEW testdb_S . t1_view2_N AS SELECT `pk` , `col_int_key` , `col_in' ], [ '182', 'root', 'localhost:57431', 'test', 'Query', '606', 'Waiting for table metadata lock', 'DO ( SELECT COUNT(*) FROM testdb_S . t1_view2_N WHERE `pk` BETWEEN 6 AND 6 + 20 )' ], [ '184', 'root', 'localhost:57433', 'test', 'Query', '606', 'Waiting for release of readlock', 'DELETE FROM testdb_S . t1_view2_N WHERE `pk` > 4 LIMIT 1' ], [ '188', 'root', 'localhost:57437', 'test', 'Query', '605', 'Waiting for release of readlock', 'DROP SCHEMA testdb_S /* Sequence end */' ], [ '190', 'root', 'localhost:57439', 'test', 'Query', '606', 'Waiting for global metadata lock', 'FLUSH TABLES WITH READ LOCK' ], [ '191', 'root', 'localhost:57440', 'test', 'Query', '606', 'Waiting for release of readlock', 'LOAD DATA CONCURRENT INFILE \'/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/gentest14923.tmp\' ' ], [ '192', 'root', 'localhost:57441', 'test', 'Query', '606', 'Waiting for release of readlock', 'DELETE A FROM testdb_S . t1_view2_S AS A WHERE testdb_S . f1_2_S () = 5 AND `pk` = 2' ], [ '193', 'root', 'localhost:57442', 'test', 'Query', '606', 'Waiting for release of readlock', 'UPDATE IGNORE testdb_S . t1_view2_N SET `col_int` = 8 WHERE SLEEP( 0.5 * 0.02 * 1 ) = 0 LIMIT 1' ], [ '194', 'event_scheduler', 'localhost', undef, 'Daemon', '597', 'Waiting for release of readlock', undef ], [ '198', 'root', 'localhost:57445', 'test', 'Query', '606', 'Waiting for release of readlock', 'INSERT INTO testdb_S . t1_view1_N ( `pk` ) VALUES ( 2 )' ], [ '199', 'root', 'localhost:57446', 'testdb_N', 'Query', '606', 'Waiting for release of readlock', 'UPDATE testdb_N . t1_view2_N SET `pk` = 6 WHERE SLEEP( 0.5 * 0.96 * 1 ) = 0 LIMIT 1' ], [ '262', 'root', 'localhost:47129', 'test', 'Query', '0', undef, 'SHOW PROCESSLIST' ] ]; # 2010-09-24T11:43:21 Executing SHOW ENGINE INNODB STATUS: $VAR1 = [ [ 'InnoDB', '', ' ===================================== 100924 12:43:21 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 6 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 199 1_second, 27 sleeps, 3 10_second, 174 background, 172 flush srv_master_thread log flush and writes: 27 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 56, signal count 57 Mutex spin waits 130, rounds 1670, OS waits 9 RW-shared spins 24, rounds 750, OS waits 25 RW-excl spins 6, rounds 705, OS waits 21 Spin rounds per wait: 12.85 mutex, 31.25 RW-shared, 117.50 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 5A9 Purge done for trx\'s n:o < 0 undo n:o < 0 History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 14890, OS thread id 2783669136 MySQL thread id 262, query id 49305 localhost 127.0.0.1 root SHOW ENGINE INNODB STATUS ---TRANSACTION 0, not started, process no 14890, OS thread id 2830515088 MySQL thread id 198, query id 49112 localhost 127.0.0.1 root Waiting for release of readlock INSERT INTO testdb_S . t1_view1_N ( `pk` ) VALUES ( 2 ) ---TRANSACTION 5A8, not started, process no 14890, OS thread id 2783468432 MySQL thread id 193, query id 49109 localhost 127.0.0.1 root Waiting for release of readlock UPDATE IGNORE testdb_S . t1_view2_N SET `col_int` = 8 WHERE SLEEP( 0.5 * 0.02 * 1 ) = 0 LIMIT 1 ---TRANSACTION 5A6, not started, process no 14890, OS thread id 2831117200 MySQL thread id 191, query id 49120 localhost 127.0.0.1 root Waiting for release of readlock LOAD DATA CONCURRENT INFILE \'/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/gentest14923.tmp\' INTO TABLE testdb_S . t1_merge1_S ---TRANSACTION 5A5, not started, process no 14890, OS thread id 2830314384 MySQL thread id 192, query id 49117 localhost 127.0.0.1 root Waiting for release of readlock DELETE A FROM testdb_S . t1_view2_S AS A WHERE testdb_S . f1_2_S () = 5 AND `pk` = 2 ---TRANSACTION 0, not started, process no 14890, OS thread id 2830916496 MySQL thread id 190, query id 49095 localhost 127.0.0.1 root Waiting for global metadata lock FLUSH TABLES WITH READ LOCK ---TRANSACTION 5A7, not started, process no 14890, OS thread id 2830715792 MySQL thread id 182, query id 49115 localhost 127.0.0.1 root Waiting for table metadata lock DO ( SELECT COUNT(*) FROM testdb_S . t1_view2_N WHERE `pk` BETWEEN 6 AND 6 + 20 ) ---TRANSACTION 59D, not started, process no 14890, OS thread id 2781870992 MySQL thread id 188, query id 49122 localhost 127.0.0.1 root Waiting for release of readlock DROP SCHEMA testdb_S /* Sequence end */ ---TRANSACTION 59E, not started, process no 14890, OS thread id 2828856208 MySQL thread id 144, query id 49079 localhost 127.0.0.1 root Waiting for table metadata lock CREATE ALGORITHM = TEMPTABLE VIEW testdb_S . t1_view2_N AS SELECT `pk` , `col_int_key` , `col_int` FROM testdb_S . t1_temp1_N AS A WHERE testdb_N . f1_2_N () = 1 AND `pk` = 2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o\'s: 0, sync i/o\'s: 0 Pending flushes (fsync) log: 0; buffer pool: 0 155 OS file reads, 300 OS file writes, 225 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553193, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 2002366 Log flushed up to 2002366 Last checkpoint at 2002366 0 pending log writes, 0 pending chkp writes 69 log i/o\'s done, 0.00 log i/o\'s/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 137363456; in additional pool allocated 0 Dictionary memory allocated 133720 Buffer pool size 8191 Free buffers 7936 Database pages 254 Old database pages 0 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 144, created 110, written 320 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 254, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 14890, id 2825628560, state: waiting for server activity Number of rows inserted 1243, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ' ] ]; # 2010-09-24T11:43:21 Killing child process with pid 14931... # 2010-09-24T11:43:21 Killing child process with pid 14923... # 2010-09-24T11:43:21 Killing child process with pid 14929... # 2010-09-24T11:43:21 Killing child process with pid 14937... # 2010-09-24T11:43:21 Killing child process with pid 14940... # 2010-09-24T11:43:21 Killing child process with pid 14925... # 2010-09-24T11:43:21 Killing child process with pid 14935... # 2010-09-24T11:43:21 Killing child process with pid 14933... # 2010-09-24T11:43:21 Killing child process with pid 14942... # 2010-09-24T11:43:21 Killing child process with pid 14927... # 2010-09-24T11:43:21 Kill GenTest::ErrorFilter(14921) # 2010-09-24T11:43:21 Server deadlock reported, initiating analysis... # 2010-09-24T11:43:21 Killing mysqld with pid 14890 with SIGHUP in order to force debug output. # 2010-09-24T11:43:23 Killing mysqld with pid 14890 with SIGSEGV in order to capture core. # 2010-09-24T11:43:43 The last 100 lines from /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs/master-data//../log/master.err : lock: 0x8b07ec0: lock: 0x8b07e20: lock: 0x8b07920: lock: 0x8b07880: lock: 0x8b077e0: DB Table Version Thread Open Lock test DD 225 0 1 Not in use test C 225 0 1 Not in use test B 225 0 1 Not in use test A 225 0 1 Not in use test CC 225 0 1 Not in use test executors 225 0 1 Not in use mysql event 225 0 1 Not in use test E 225 0 1 Not in use test D 225 0 1 Not in use mysql db 225 0 1 Not in use test BB 225 0 1 Not in use mysql tables_priv 225 0 1 Not in use test AA 225 0 1 Not in use mysql procs_priv 225 0 1 Not in use mysql columns_priv 225 0 1 Not in use mysql user 225 0 1 Not in use test DUMMY 225 0 1 Not in use mysql proc 225 0 1 Not in use Current refresh version: 225 Key caches: default Buffer_size: 1048576 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 9 not flushed: 0 w_requests: 1185 writes: 677 r_requests: 4927 reads: 488 handler status: read_key: 5887 read_next: 340 read_rnd 0 read_first: 265 write: 140806 delete 188 update: 27 Table status: Opened tables: 2489 Open tables: 18 Open files: 16 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 100924 12:43:23 - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=12 max_threads=151 thread_count=12 connection_count=11 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60165 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = (nil) thread_stack 0x30000 /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld(my_print_stacktrace+0x32)[0x866b13f] /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld(handle_segfault+0x350)[0x81514c8] [0x1d4420] /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld(_Z26handle_connections_socketsv+0x133)[0x8152083] /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld(_Z11mysqld_mainiPPc+0x827)[0x8156a17] /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld(main+0x2e)[0x814a722] /lib/libc.so.6(__libc_start_main+0xdc)[0x736dec] /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld[0x814a641] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file # 2010-09-24T11:43:43 datadir is /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs/master-data/ # 2010-09-24T11:43:43 binary is /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin/mysqld # 2010-09-24T11:43:43 bindir is /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/bin # 2010-09-24T11:43:43 core is /export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test/vardirs/master-data//core.14890 warning: Can't read pathname for load map: Input/output error. Cannot access memory at address 0x2 15 /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/main.cc: No such file or directory. # 2010-09-24T11:43:44 Using host libthread_db library "/lib/libthread_db.so.1". # 2010-09-24T11:43:44 Core was generated by `/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test'. # 2010-09-24T11:43:44 Program terminated with signal 11, Segmentation fault. # 2010-09-24T11:43:44 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:44 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:44 #1 0x0089f067 in pthread_kill () from /lib/libpthread.so.0 # 2010-09-24T11:43:44 #2 0x0866b1dd in my_write_core (sig=11) # 2010-09-24T11:43:44 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/stacktrace.c:328 # 2010-09-24T11:43:44 #3 0x0815173e in handle_segfault (sig=11) # 2010-09-24T11:43:44 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:2517 # 2010-09-24T11:43:44 #4 # 2010-09-24T11:43:44 #5 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:44 #6 0x007e8033 in poll () from /lib/libc.so.6 # 2010-09-24T11:43:44 #7 0x08152083 in handle_connections_sockets () # 2010-09-24T11:43:44 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:5111 # 2010-09-24T11:43:44 #8 0x08156a17 in mysqld_main (argc=46, argv=0x923e2b0) # 2010-09-24T11:43:44 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:4581 # 2010-09-24T11:43:44 #9 0x0814a722 in main (argc=) # 2010-09-24T11:43:44 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/main.cc:24 # 2010-09-24T11:43:44 #5 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:44 in /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/main.cc warning: Can't read pathname for load map: Input/output error. Cannot access memory at address 0x2 # 2010-09-24T11:43:47 Using host libthread_db library "/lib/libthread_db.so.1". # 2010-09-24T11:43:47 Core was generated by `/export/home/pb2/test/sb_1-2315564-1285320694.32/mysql-5.5.7-m3-linux-i686-test'. # 2010-09-24T11:43:47 Program terminated with signal 11, Segmentation fault. # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 28 (process 14893): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a7f4c, mp=0x96a7f00, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a7f4c, mutex=0x96a7f00) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a7f00, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=0, # 2010-09-24T11:43:47 message1=0xb7fc138c, message2=0xb7fc1388, type=0xb7fc1384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05fe0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 27 (process 14894): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a7fd4, mp=0x96a7f88, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a7fd4, mutex=0x96a7f88) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a7f88, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=1, # 2010-09-24T11:43:47 message1=0xae66138c, message2=0xae661388, type=0xae661384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=1) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05fe4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 26 (process 14895): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a805c, mp=0x96a8010, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a805c, mutex=0x96a8010) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a8010, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=2, # 2010-09-24T11:43:47 message1=0xadc6038c, message2=0xadc60388, type=0xadc60384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=2) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05fe8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 25 (process 14896): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a80e4, mp=0x96a8098, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a80e4, mutex=0x96a8098) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a8098, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=3, # 2010-09-24T11:43:47 message1=0xad25f38c, message2=0xad25f388, type=0xad25f384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=3) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05fec) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 24 (process 14897): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a816c, mp=0x96a8120, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a816c, mutex=0x96a8120) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a8120, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=4, # 2010-09-24T11:43:47 message1=0xac85e38c, message2=0xac85e388, type=0xac85e384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05ff0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 23 (process 14898): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a81f4, mp=0x96a81a8, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a81f4, mutex=0x96a81a8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a81a8, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=5, # 2010-09-24T11:43:47 message1=0xabe5d38c, message2=0xabe5d388, type=0xabe5d384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=5) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05ff4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 22 (process 14899): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a827c, mp=0x96a8230, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a827c, mutex=0x96a8230) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a8230, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=6, # 2010-09-24T11:43:47 message1=0xab45c38c, message2=0xab45c388, type=0xab45c384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=6) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05ff8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 21 (process 14900): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a8304, mp=0x96a82b8, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a8304, mutex=0x96a82b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a82b8, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=7, # 2010-09-24T11:43:47 message1=0xaaa5b38c, message2=0xaaa5b388, type=0xaaa5b384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=7) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b05ffc) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 20 (process 14901): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a838c, mp=0x96a8340, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a838c, mutex=0x96a8340) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a8340, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=8, # 2010-09-24T11:43:47 message1=0xaa05a38c, message2=0xaa05a388, type=0xaa05a384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b06000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 19 (process 14902): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x96a8414, mp=0x96a83c8, # 2010-09-24T11:43:47 file=0x87fc968 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c", line=140) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x0858b48c in os_cond_wait (cond=0x96a8414, mutex=0x96a83c8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:140 # 2010-09-24T11:43:47 #4 0x0858b3e8 in os_event_wait_low (event=0x96a83c8, reset_sig_count=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0sync.c:567 # 2010-09-24T11:43:47 #5 0x08589df4 in os_aio_simulated_handle (global_segment=9, # 2010-09-24T11:43:47 message1=0xa965938c, message2=0xa9659388, type=0xa9659384) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0file.c:4900 # 2010-09-24T11:43:47 #6 0x08552c3d in fil_aio_wait (segment=9) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/fil/fil0fil.c:4464 # 2010-09-24T11:43:47 #7 0x084e46b3 in io_handler_thread (arg=0x8b06004) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0start.c:494 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 18 (process 14904): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x007eaa31 in select () from /lib/libc.so.6 # 2010-09-24T11:43:47 #2 0x0858bcd5 in os_thread_sleep (tm=1000000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0thread.c:274 # 2010-09-24T11:43:47 #3 0x084e2969 in srv_lock_timeout_thread (arg=0x0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0srv.c:2211 # 2010-09-24T11:43:47 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #5 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 17 (process 14905): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x007eaa31 in select () from /lib/libc.so.6 # 2010-09-24T11:43:47 #2 0x0858bcd5 in os_thread_sleep (tm=1000000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0thread.c:274 # 2010-09-24T11:43:47 #3 0x084e2cb3 in srv_error_monitor_thread (arg=0x0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0srv.c:2381 # 2010-09-24T11:43:47 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #5 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 16 (process 14906): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x007eaa31 in select () from /lib/libc.so.6 # 2010-09-24T11:43:47 #2 0x0858bcd5 in os_thread_sleep (tm=5000000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0thread.c:274 # 2010-09-24T11:43:47 #3 0x084e2556 in srv_monitor_thread (arg=0x0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0srv.c:2065 # 2010-09-24T11:43:47 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #5 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 15 (process 14907): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x007eaa31 in select () from /lib/libc.so.6 # 2010-09-24T11:43:47 #2 0x0858bcd5 in os_thread_sleep (tm=1000000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/os/os0thread.c:274 # 2010-09-24T11:43:47 #3 0x084e3266 in srv_master_thread (arg=0x0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/storage/innobase/srv/srv0srv.c:2643 # 2010-09-24T11:43:47 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #5 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 14 (process 14908): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x008a1f6e in do_sigwait () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x008a200f in sigwait () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #3 0x08150e61 in signal_hand (arg=0x0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:2718 # 2010-09-24T11:43:47 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #5 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 13 (process 14909): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x008a0e1b in read () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086acc8d in vio_read (vio=0x9b87560, buf=0x9ba1680 "\a", size=4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/vio/viosocket.c:44 # 2010-09-24T11:43:47 #3 0x081592b7 in my_real_read (net=0x9b39b10, complen=0xa8c272e8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/net_serv.cc:831 # 2010-09-24T11:43:47 #4 0x081597a6 in my_net_read (net=0x9b39b10) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/net_serv.cc:1028 # 2010-09-24T11:43:47 #5 0x081efc2c in do_command (thd=0x9b399e8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:717 # 2010-09-24T11:43:47 #6 0x082bbddf in do_handle_one_connection (thd_arg=0x9b399e8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #7 0x082bbed7 in handle_one_connection (arg=0x9b399e8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #9 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 12 (process 15075): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2010-09-24T11:43:47 from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x0867099f in safe_cond_timedwait (cond=0xa5d020c4, mp=0xa5d02080, # 2010-09-24T11:43:47 abstime=0xa89ccd4c, # 2010-09-24T11:43:47 file=0x874c83c "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1097) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:278 # 2010-09-24T11:43:47 #3 0x082c491d in inline_mysql_cond_timedwait (that=0xa5d020c4, # 2010-09-24T11:43:47 mutex=0xa5d02080, abstime=0xa89ccd4c, # 2010-09-24T11:43:47 src_file=0x874c704 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc", src_line=987) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1097 # 2010-09-24T11:43:47 #4 0x082c49d3 in MDL_wait::timed_wait (this=0xa5d02080, thd=0xa5d02018, # 2010-09-24T11:43:47 abs_timeout=0xa89ccd4c, set_status_on_timeout=false, # 2010-09-24T11:43:47 wait_state_name=0x874ccf0 "Waiting for table metadata lock") # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:986 # 2010-09-24T11:43:47 #5 0x082c688f in MDL_context::acquire_lock (this=0xa5d02080, # 2010-09-24T11:43:47 mdl_request=0x9b48390, lock_wait_timeout=31536000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:1772 # 2010-09-24T11:43:47 #6 0x082c6e1b in MDL_context::acquire_locks (this=0xa5d02080, # 2010-09-24T11:43:47 mdl_requests=0xa89ccfd4, lock_wait_timeout=31536000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:1882 # 2010-09-24T11:43:47 #7 0x08197c73 in lock_table_names (thd=0xa5d02018, tables_start=0x9b481a0, # 2010-09-24T11:43:47 tables_end=0x0, lock_wait_timeout=31536000, flags=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4554 # 2010-09-24T11:43:47 #8 0x0819e3a9 in open_tables (thd=0xa5d02018, start=0xa89cd104, # 2010-09-24T11:43:47 counter=0xa89cd0e8, flags=0, prelocking_strategy=0xa89cd12c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4731 # 2010-09-24T11:43:47 #9 0x0819ea55 in open_and_lock_tables (thd=0xa5d02018, tables=0x9b481a0, # 2010-09-24T11:43:47 derived=true, flags=0, prelocking_strategy=0xa89cd12c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:5357 # 2010-09-24T11:43:47 #10 0x0818ebe0 in open_and_lock_tables (thd=0xa5d02018, tables=0x9b481a0, # 2010-09-24T11:43:47 derived=true, flags=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.h:476 # 2010-09-24T11:43:47 #11 0x08281f1f in mysql_create_view (thd=0xa5d02018, views=0x9b481a0, # 2010-09-24T11:43:47 mode=VIEW_CREATE_NEW) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_view.cc:438 # 2010-09-24T11:43:47 #12 0x081ec94c in mysql_execute_command (thd=0xa5d02018) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:4212 # 2010-09-24T11:43:47 #13 0x081ed722 in mysql_parse (thd=0xa5d02018, # 2010-09-24T11:43:47 rawbuf=0x9b47fa0 "CREATE ALGORITHM = TEMPTABLE VIEW testdb_S . t1_view2_N AS SELECT `pk` , `col_int_key` , `col_int` FROM testdb_S . t1_temp1_N AS A WHERE testdb_N . f1_2_N () = 1 AND `pk` = 2", length=181, # 2010-09-24T11:43:47 parser_state=0xa89cddb8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #14 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0xa5d02018, # 2010-09-24T11:43:47 packet=0xa8a443a1 "CREATE ALGORITHM = TEMPTABLE VIEW testdb_S . t1_view2_N AS SELECT `pk` , `col_int_key` , `col_int` FROM testdb_S . t1_temp1_N AS A WHERE testdb_N . f1_2_N () = 1 AND `pk` = 2", packet_length=181) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #15 0x081efdee in do_command (thd=0xa5d02018) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #16 0x082bbddf in do_handle_one_connection (thd_arg=0xa5d02018) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #17 0x082bbed7 in handle_one_connection (arg=0xa5d02018) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #19 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 11 (process 15113): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2010-09-24T11:43:47 from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x0867099f in safe_cond_timedwait (cond=0xa8a09e6c, mp=0xa8a09e28, # 2010-09-24T11:43:47 abstime=0xa8b92a3c, # 2010-09-24T11:43:47 file=0x874c83c "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1097) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:278 # 2010-09-24T11:43:47 #3 0x082c491d in inline_mysql_cond_timedwait (that=0xa8a09e6c, # 2010-09-24T11:43:47 mutex=0xa8a09e28, abstime=0xa8b92a3c, # 2010-09-24T11:43:47 src_file=0x874c704 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc", src_line=987) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1097 # 2010-09-24T11:43:47 #4 0x082c49d3 in MDL_wait::timed_wait (this=0xa8a09e28, thd=0xa8a09dc0, # 2010-09-24T11:43:47 abs_timeout=0xa8b92a3c, set_status_on_timeout=true, # 2010-09-24T11:43:47 wait_state_name=0x874ccf0 "Waiting for table metadata lock") # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:986 # 2010-09-24T11:43:47 #5 0x082c69a2 in MDL_context::acquire_lock (this=0xa8a09e28, # 2010-09-24T11:43:47 mdl_request=0x9b5ebc8, lock_wait_timeout=31536000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:1788 # 2010-09-24T11:43:47 #6 0x081971bc in open_table_get_mdl_lock (thd=0xa8a09dc0, ot_ctx=0xa8b93188, # 2010-09-24T11:43:47 mdl_request=0x9b5ebc8, flags=0, mdl_ticket=0xa8b93044) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:2521 # 2010-09-24T11:43:47 #7 0x0819cc9c in open_table (thd=0xa8a09dc0, table_list=0x9b5e9d8, # 2010-09-24T11:43:47 mem_root=0xa8b93154, ot_ctx=0xa8b93188) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:2827 # 2010-09-24T11:43:47 #8 0x0819dd73 in open_and_process_table (thd=0xa8a09dc0, lex=0xa8a0af30, # 2010-09-24T11:43:47 tables=0x9b5e9d8, counter=0xa8b93208, flags=0, # 2010-09-24T11:43:47 prelocking_strategy=0xa8b9324c, has_prelocking_list=false, # 2010-09-24T11:43:47 ot_ctx=0xa8b93188, new_frm_mem=0xa8b93154) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4333 # 2010-09-24T11:43:47 #9 0x0819e474 in open_tables (thd=0xa8a09dc0, start=0xa8b93224, # 2010-09-24T11:43:47 counter=0xa8b93208, flags=0, prelocking_strategy=0xa8b9324c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4764 # 2010-09-24T11:43:47 #10 0x0819ea55 in open_and_lock_tables (thd=0xa8a09dc0, tables=0x9b5e9d8, # 2010-09-24T11:43:47 derived=true, flags=0, prelocking_strategy=0xa8b9324c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:5357 # 2010-09-24T11:43:47 #11 0x0818ebe0 in open_and_lock_tables (thd=0xa8a09dc0, tables=0x9b5e9d8, # 2010-09-24T11:43:47 derived=true, flags=0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.h:476 # 2010-09-24T11:43:47 #12 0x081e613a in mysql_execute_command (thd=0xa8a09dc0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2154 # 2010-09-24T11:43:47 #13 0x081ed722 in mysql_parse (thd=0xa8a09dc0, # 2010-09-24T11:43:47 rawbuf=0x9b5e1b8 "DO ( SELECT COUNT(*) FROM testdb_S . t1_view2_N WHERE `pk` BETWEEN 6 AND 6 + 20 )", length=82, parser_state=0xa8b93db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #14 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0xa8a09dc0, # 2010-09-24T11:43:47 packet=0xa8a14c91 "DO ( SELECT COUNT(*) FROM testdb_S . t1_view2_N WHERE `pk` BETWEEN 6 AND 6 + 20 )", packet_length=82) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #15 0x081efdee in do_command (thd=0xa8a09dc0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #16 0x082bbddf in do_handle_one_connection (thd_arg=0xa8a09dc0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #17 0x082bbed7 in handle_one_connection (arg=0xa8a09dc0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #19 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 10 (process 15115): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0xa8a11bac, # 2010-09-24T11:43:47 thd=0xa8a10ea8, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0xa8a10ea8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x081ed722 in mysql_parse (thd=0xa8a10ea8, # 2010-09-24T11:43:47 rawbuf=0x9b6d7d8 "DELETE FROM testdb_S . t1_view2_N WHERE `pk` > 4 LIMIT 1", length=60, parser_state=0xa5e53db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #7 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0xa8a10ea8, # 2010-09-24T11:43:47 packet=0xa5d03ec9 "DELETE FROM testdb_S . t1_view2_N WHERE `pk` > 4 LIMIT 1", packet_length=60) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #8 0x081efdee in do_command (thd=0xa8a10ea8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #9 0x082bbddf in do_handle_one_connection (thd_arg=0xa8a10ea8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #10 0x082bbed7 in handle_one_connection (arg=0xa8a10ea8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #11 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #12 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 9 (process 15119): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9d21bf4, # 2010-09-24T11:43:47 thd=0x9d20ef0, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0x9d20ef0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x081ed722 in mysql_parse (thd=0x9d20ef0, # 2010-09-24T11:43:47 rawbuf=0x9bdd416 "DROP SCHEMA testdb_S /* Sequence end */", length=39, # 2010-09-24T11:43:47 parser_state=0xa5cfedb8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #7 0x081eec97 in dispatch_command (command=COM_QUERY, thd=0x9d20ef0, # 2010-09-24T11:43:47 packet=0x9d2fe81 "", packet_length=117) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1146 # 2010-09-24T11:43:47 #8 0x081efdee in do_command (thd=0x9d20ef0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #9 0x082bbddf in do_handle_one_connection (thd_arg=0x9d20ef0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #10 0x082bbed7 in handle_one_connection (arg=0x9d20ef0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #11 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #12 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 8 (process 15121): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () # 2010-09-24T11:43:47 from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x0867099f in safe_cond_timedwait (cond=0x9bf5134, mp=0x9bf50f0, # 2010-09-24T11:43:47 abstime=0xa8bc3ffc, # 2010-09-24T11:43:47 file=0x874c83c "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1097) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:278 # 2010-09-24T11:43:47 #3 0x082c491d in inline_mysql_cond_timedwait (that=0x9bf5134, # 2010-09-24T11:43:47 mutex=0x9bf50f0, abstime=0xa8bc3ffc, # 2010-09-24T11:43:47 src_file=0x874c704 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc", src_line=987) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1097 # 2010-09-24T11:43:47 #4 0x082c49d3 in MDL_wait::timed_wait (this=0x9bf50f0, thd=0x9bf5088, # 2010-09-24T11:43:47 abs_timeout=0xa8bc3ffc, set_status_on_timeout=true, # 2010-09-24T11:43:47 wait_state_name=0x874cca8 "Waiting for global metadata lock") # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:986 # 2010-09-24T11:43:47 #5 0x082c69a2 in MDL_context::acquire_lock (this=0x9bf50f0, # 2010-09-24T11:43:47 mdl_request=0xa8bc4044, lock_wait_timeout=31536000) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mdl.cc:1788 # 2010-09-24T11:43:47 #6 0x083fede8 in Global_read_lock::lock_global_read_lock (this=0x9bf5d8c, # 2010-09-24T11:43:47 thd=0x9bf5088) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1051 # 2010-09-24T11:43:47 #7 0x082e94a7 in reload_acl_and_cache (thd=0x9bf5088, options=16388, # 2010-09-24T11:43:47 tables=0x0, write_to_binlog=0xa8bc4b6f) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_reload.cc:190 # 2010-09-24T11:43:47 #8 0x081eab1b in mysql_execute_command (thd=0x9bf5088) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:3615 # 2010-09-24T11:43:47 #9 0x081ed722 in mysql_parse (thd=0x9bf5088, # 2010-09-24T11:43:47 rawbuf=0x9c9df10 "FLUSH TABLES WITH READ LOCK", length=27, # 2010-09-24T11:43:47 parser_state=0xa8bc4db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #10 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9bf5088, # 2010-09-24T11:43:47 packet=0x9b60319 "FLUSH TABLES WITH READ LOCK ", packet_length=28) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #11 0x081efdee in do_command (thd=0x9bf5088) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #12 0x082bbddf in do_handle_one_connection (thd_arg=0x9bf5088) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #13 0x082bbed7 in handle_one_connection (arg=0x9bf5088) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #14 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #15 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 7 (process 15122): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9bac3bc, # 2010-09-24T11:43:47 thd=0x9bab6b8, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0x9bab6b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x081ed722 in mysql_parse (thd=0x9bab6b8, # 2010-09-24T11:43:47 rawbuf=0x9bd55c8 "LOAD DATA CONCURRENT INFILE '/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/gentest14923.tmp' INTO TABLE testdb_S . t1_merge1_S", # 2010-09-24T11:43:47 length=134, parser_state=0xa8bf5db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #7 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9bab6b8, # 2010-09-24T11:43:47 packet=0x9b670b1 " LOAD DATA CONCURRENT INFILE '/export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/gentest14923.tmp' INTO TABLE testdb_S . t1_merge1_S ", packet_length=136) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #8 0x081efdee in do_command (thd=0x9bab6b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #9 0x082bbddf in do_handle_one_connection (thd_arg=0x9bab6b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #10 0x082bbed7 in handle_one_connection (arg=0x9bab6b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #11 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #12 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 6 (process 15123): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9b9494c, # 2010-09-24T11:43:47 thd=0x9b93c48, abort_on_refresh=true, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x0819c5ae in open_table (thd=0x9b93c48, table_list=0xa8a1bc58, # 2010-09-24T11:43:47 mem_root=0xa8b30ee4, ot_ctx=0xa8b30f18) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:2646 # 2010-09-24T11:43:47 #6 0x0819dd73 in open_and_process_table (thd=0x9b93c48, lex=0xa8a1acb8, # 2010-09-24T11:43:47 tables=0xa8a1bc58, counter=0xa8b30f98, flags=512, # 2010-09-24T11:43:47 prelocking_strategy=0xa8b30f9c, has_prelocking_list=false, # 2010-09-24T11:43:47 ot_ctx=0xa8b30f18, new_frm_mem=0xa8b30ee4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4333 # 2010-09-24T11:43:47 #7 0x0819e474 in open_tables (thd=0x9b93c48, start=0xa8b30fb4, # 2010-09-24T11:43:47 counter=0xa8b30f98, flags=512, prelocking_strategy=0xa8b30f9c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4764 # 2010-09-24T11:43:47 #8 0x0819e8c1 in open_normal_and_derived_tables (thd=0x9b93c48, # 2010-09-24T11:43:47 tables=0xa8a1bc58, flags=512) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:5413 # 2010-09-24T11:43:47 #9 0x081fe50d in select_like_stmt_test_with_open (stmt=0xa8a339b8, # 2010-09-24T11:43:47 tables=0xa8a1bc58, # 2010-09-24T11:43:47 specific_prepare=0x846b0c2 , # 2010-09-24T11:43:47 setup_tables_done_option=1073741824) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_prepare.cc:1685 # 2010-09-24T11:43:47 #10 0x081fefe0 in mysql_test_multidelete (stmt=0xa8a339b8, tables=0xa8a1bc58) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_prepare.cc:1841 # 2010-09-24T11:43:47 #11 0x081ff8e8 in check_prepared_statement (stmt=0xa8a339b8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_prepare.cc:2035 # 2010-09-24T11:43:47 #12 0x08200623 in Prepared_statement::prepare (this=0xa8a339b8, # 2010-09-24T11:43:47 packet=0x9bf9380 " DELETE A FROM testdb_S . t1_view2_S AS A WHERE testdb_S . f1_2_S () = 5 AND `pk` = 2 ", packet_len=91) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_prepare.cc:3252 # 2010-09-24T11:43:47 #13 0x082033e5 in mysql_sql_stmt_prepare (thd=0x9b93c48) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_prepare.cc:2367 # 2010-09-24T11:43:47 #14 0x081e60b7 in mysql_execute_command (thd=0x9b93c48) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2140 # 2010-09-24T11:43:47 #15 0x081ed722 in mysql_parse (thd=0x9b93c48, # 2010-09-24T11:43:47 rawbuf=0x9bf91f0 "PREPARE st1 FROM \" DELETE A FROM testdb_S . t1_view2_S AS A WHERE testdb_S . f1_2_S () = 5 AND `pk` = 2 \"", length=110, # 2010-09-24T11:43:47 parser_state=0xa8b31db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #16 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9b93c48, # 2010-09-24T11:43:47 packet=0x9b98dc1 "PREPARE st1 FROM \" DELETE A FROM testdb_S . t1_view2_S AS A WHERE testdb_S . f1_2_S () = 5 AND `pk` = 2 \" ", packet_length=111) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #17 0x081efdee in do_command (thd=0x9b93c48) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #18 0x082bbddf in do_handle_one_connection (thd_arg=0x9b93c48) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #19 0x082bbed7 in handle_one_connection (arg=0x9b93c48) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #20 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #21 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 5 (process 15124): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9b6bdc4, # 2010-09-24T11:43:47 thd=0x9b6b0c0, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0x9b6b0c0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x081ed722 in mysql_parse (thd=0x9b6b0c0, # 2010-09-24T11:43:47 rawbuf=0x9bff218 "UPDATE IGNORE testdb_S . t1_view2_N SET `col_int` = 8 WHERE SLEEP( 0.5 * 0.02 * 1 ) = 0 LIMIT 1", length=97, parser_state=0xa5e84db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #7 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9b6b0c0, # 2010-09-24T11:43:47 packet=0x9b435d1 "UPDATE IGNORE testdb_S . t1_view2_N SET `col_int` = 8 WHERE SLEEP( 0.5 * 0.02 * 1 ) = 0 LIMIT 1", packet_length=97) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #8 0x081efdee in do_command (thd=0x9b6b0c0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #9 0x082bbddf in do_handle_one_connection (thd_arg=0x9b6b0c0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #10 0x082bbed7 in handle_one_connection (arg=0x9b6b0c0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #11 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #12 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 4 (process 15125): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9d34b94, # 2010-09-24T11:43:47 thd=0x9d33e90, abort_on_refresh=true, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x0819c5ae in open_table (thd=0x9d33e90, table_list=0xa89fee34, # 2010-09-24T11:43:47 mem_root=0xa89fed04, ot_ctx=0xa89fed38) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:2646 # 2010-09-24T11:43:47 #6 0x0819dd73 in open_and_process_table (thd=0x9d33e90, lex=0x9d35000, # 2010-09-24T11:43:47 tables=0xa89fee34, counter=0xa89fedb8, flags=2048, # 2010-09-24T11:43:47 prelocking_strategy=0xa89fedfc, has_prelocking_list=false, # 2010-09-24T11:43:47 ot_ctx=0xa89fed38, new_frm_mem=0xa89fed04) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4333 # 2010-09-24T11:43:47 #7 0x0819e474 in open_tables (thd=0x9d33e90, start=0xa89fedd4, # 2010-09-24T11:43:47 counter=0xa89fedb8, flags=2048, prelocking_strategy=0xa89fedfc) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:4764 # 2010-09-24T11:43:47 #8 0x0819ea55 in open_and_lock_tables (thd=0x9d33e90, tables=0xa89fee34, # 2010-09-24T11:43:47 derived=false, flags=2048, prelocking_strategy=0xa89fedfc) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.cc:5357 # 2010-09-24T11:43:47 #9 0x0818ebe0 in open_and_lock_tables (thd=0x9d33e90, tables=0xa89fee34, # 2010-09-24T11:43:47 derived=false, flags=2048) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_base.h:476 # 2010-09-24T11:43:47 #10 0x0829fb88 in Event_db_repository::open_event_table (thd=0x9d33e90, # 2010-09-24T11:43:47 lock_type=TL_WRITE, table=0xa89ff248) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_db_repository.cc:589 # 2010-09-24T11:43:47 #11 0x082a0200 in Event_db_repository::update_timing_fields_for_event ( # 2010-09-24T11:43:47 this=0x9b42138, thd=0x9d33e90, event_db_name= # 2010-09-24T11:43:47 {str = 0xa8a05ca8 "testdb_S", length = 8}, event_name= # 2010-09-24T11:43:47 {str = 0xa8a05cb8 "e1_2_S", length = 6}, update_last_executed=true, # 2010-09-24T11:43:47 last_executed=1285320804, update_status=false, status=1) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_db_repository.cc:1066 # 2010-09-24T11:43:47 #12 0x0829cc57 in Event_queue_element::update_timing_fields (this=0xa8a3de80, # 2010-09-24T11:43:47 thd=0x9d33e90) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_data_objects.cc:1185 # 2010-09-24T11:43:47 #13 0x08491275 in Event_queue::get_top_for_execution_if_time (this=0x9b8caa0, # 2010-09-24T11:43:47 thd=0x9d33e90, event_name=0xa89ff36c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_queue.cc:636 # 2010-09-24T11:43:47 #14 0x0848f637 in Event_scheduler::run (this=0x9b8a318, thd=0x9d33e90) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_scheduler.cc:475 # 2010-09-24T11:43:47 #15 0x0848fc7e in event_scheduler_thread (arg=0x9c03308) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/event_scheduler.cc:243 # 2010-09-24T11:43:47 #16 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #17 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 3 (process 15129): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9b5a0a4, # 2010-09-24T11:43:47 thd=0x9b593a0, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0x9b593a0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x081ed722 in mysql_parse (thd=0x9b593a0, # 2010-09-24T11:43:47 rawbuf=0x9d2de68 "INSERT INTO testdb_S . t1_view1_N ( `pk` ) VALUES ( 2 )", length=58, parser_state=0xa8b62db8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #7 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9b593a0, # 2010-09-24T11:43:47 packet=0x9d27e89 "INSERT INTO testdb_S . t1_view1_N ( `pk` ) VALUES ( 2 ) ", packet_length=59) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #8 0x081efdee in do_command (thd=0x9b593a0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #9 0x082bbddf in do_handle_one_connection (thd_arg=0x9b593a0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #10 0x082bbed7 in handle_one_connection (arg=0x9b593a0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #11 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #12 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 2 (process 15130): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x086707e2 in safe_cond_wait (cond=0x8af0a20, mp=0x8af0340, # 2010-09-24T11:43:47 file=0x87bb634 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h", line=1068) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/thr_mutex.c:240 # 2010-09-24T11:43:47 #3 0x083fe1a8 in inline_mysql_cond_wait (that=0x8af0a20, mutex=0x8af0340, # 2010-09-24T11:43:47 src_file=0x87bb520 "/export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc", src_line=1190) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/include/mysql/psi/mysql_thread.h:1068 # 2010-09-24T11:43:47 #4 0x083fe818 in Global_read_lock::wait_if_global_read_lock (this=0x9d2cb9c, # 2010-09-24T11:43:47 thd=0x9d2be98, abort_on_refresh=false, is_not_commit=true) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/lock.cc:1190 # 2010-09-24T11:43:47 #5 0x081e5d3f in mysql_execute_command (thd=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:2054 # 2010-09-24T11:43:47 #6 0x08450933 in sp_instr_stmt::exec_core (this=0x9c11d00, thd=0x9d2be98, # 2010-09-24T11:43:47 nextp=0xa899c0f4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sp_head.cc:3119 # 2010-09-24T11:43:47 #7 0x0845135f in sp_lex_keeper::reset_lex_and_exec_core (this=0x9c11d28, # 2010-09-24T11:43:47 thd=0x9d2be98, nextp=0xa899c0f4, open_tables=false, instr=0x9c11d00) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sp_head.cc:2920 # 2010-09-24T11:43:47 #8 0x08451ba3 in sp_instr_stmt::execute (this=0x9c11d00, thd=0x9d2be98, # 2010-09-24T11:43:47 nextp=0xa899c0f4) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sp_head.cc:3056 # 2010-09-24T11:43:47 #9 0x08454142 in sp_head::execute (this=0x9c10070, thd=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sp_head.cc:1390 # 2010-09-24T11:43:47 #10 0x08454ee7 in sp_head::execute_procedure (this=0x9c10070, thd=0x9d2be98, # 2010-09-24T11:43:47 args=0x9d2d73c) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sp_head.cc:2137 # 2010-09-24T11:43:47 #11 0x081ebce9 in mysql_execute_command (thd=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:3987 # 2010-09-24T11:43:47 #12 0x081ed722 in mysql_parse (thd=0x9d2be98, # 2010-09-24T11:43:47 rawbuf=0x9bb7588 "CALL testdb_N . p1_1_N", length=22, # 2010-09-24T11:43:47 parser_state=0xa899cdb8) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:5554 # 2010-09-24T11:43:47 #13 0x081eeb25 in dispatch_command (command=COM_QUERY, thd=0x9d2be98, # 2010-09-24T11:43:47 packet=0x9b55391 "CALL testdb_N . p1_1_N ", packet_length=23) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:1099 # 2010-09-24T11:43:47 #14 0x081efdee in do_command (thd=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_parse.cc:771 # 2010-09-24T11:43:47 #15 0x082bbddf in do_handle_one_connection (thd_arg=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1192 # 2010-09-24T11:43:47 #16 0x082bbed7 in handle_one_connection (arg=0x9d2be98) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/sql_connect.cc:1131 # 2010-09-24T11:43:47 #17 0x0089a45b in start_thread () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #18 0x007f1c4e in clone () from /lib/libc.so.6 # 2010-09-24T11:43:47 # 2010-09-24T11:43:47 Thread 1 (process 14890): # 2010-09-24T11:43:47 #0 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #1 0x0089f067 in pthread_kill () from /lib/libpthread.so.0 # 2010-09-24T11:43:47 #2 0x0866b1dd in my_write_core (sig=11) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/mysys/stacktrace.c:328 # 2010-09-24T11:43:47 #3 0x0815173e in handle_segfault (sig=11) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:2517 # 2010-09-24T11:43:47 #4 # 2010-09-24T11:43:47 #5 0x001d4402 in __kernel_vsyscall () # 2010-09-24T11:43:47 #6 0x007e8033 in poll () from /lib/libc.so.6 # 2010-09-24T11:43:47 #7 0x08152083 in handle_connections_sockets () # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:5111 # 2010-09-24T11:43:47 #8 0x08156a17 in mysqld_main (argc=46, argv=0x923e2b0) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/mysqld.cc:4581 # 2010-09-24T11:43:47 #9 0x0814a722 in main (argc=) # 2010-09-24T11:43:47 at /export/home/pb2/build/sb_0-2315491-1285319216.77/mysql-5.5.7-m3/sql/main.cc:24 # 2010-09-24T11:43:47 Waiting for mysqld with pid 14890 to terminate... # 2010-09-24T11:43:47 ... waiting complete. # 2010-09-24T11:43:48 XML report written to /export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/rqg_mdl_deadlock.xml # 2010-09-24T11:43:48 XML Transport type: SCP # 2010-09-24T11:43:48 SCP command is: scp /export/home/pb2/test/sb_1-2315564-1285320694.32/tmp/rqg_mdl_deadlock.xml regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-09-24T11:43:48 Test completed with failure status STATUS_SERVER_DEADLOCKED (106) # 2010-09-24T11:43:48 gentest.pl exited with exit status STATUS_SERVER_DEADLOCKED (106) 2010-09-24T11:43:48 [14539] runall.pl will exit with exit status STATUS_SERVER_DEADLOCKED (106) serverqa.rqg_mdl_deadlock [ fail ] # 2010-09-24T11:43:48 runall.pl failed with exit code 106 # 2010-09-24T11:43:48 Look above this message in the test log for failure details. # 2010-09-24T11:43:48 Checking for remaining mysqld processes... # 2010-09-24T11:43:48 None found. # 2010-09-24T11:43:48 [14531] pb2gentest.pl will exit with exit status 106 + grep 'no gnutar' which: no gnutar in (/usr/local/bin:/bin:/usr/bin) + echo no gnutar no gnutar + tar cf mysql-5.5.7-m3-linux-i686-test.tar mysql-5.5.7-m3-linux-i686-test/vardirs + true + gzip mysql-5.5.7-m3-linux-i686-test.tar + true + ls -l mysql-5.5.7-m3-linux-i686-test.tar.gz -rw-r--r-- 1 bteam wheel 3815217 Sep 24 11:43 mysql-5.5.7-m3-linux-i686-test.tar.gz + test x0 = x1 + echo '[SOURCEBUILDER] FAIL mysql-5.5.7-m3-linux-i686-test.tar.gz' [SOURCEBUILDER] FAIL mysql-5.5.7-m3-linux-i686-test.tar.gz + exit