Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. P:\>G: G:\>cd "G:\pb2\test\sb_1-2092835-1280431606.84" G:\pb2\test\sb_1-2092835-1280431606.84>set SOURCE=mysql-5.5.6-m3-win-x86.zip G:\pb2\test\sb_1-2092835-1280431606.84>set SOURCENAME=mysql-5.5.6-m3-win-x86 G:\pb2\test\sb_1-2092835-1280431606.84>set PB2WORKDIR=G:\pb2\test\sb_1-2092835-1280431606.84 G:\pb2\test\sb_1-2092835-1280431606.84>set BRANCH_ID=226 G:\pb2\test\sb_1-2092835-1280431606.84>set PRODUCT_ID=test-sysqa_rqg_mdl_stability-win-x86 G:\pb2\test\sb_1-2092835-1280431606.84>set BRANCH_NAME=mysql-trunk-runtime G:\pb2\test\sb_1-2092835-1280431606.84>set PARENT_ID=2092835 G:\pb2\test\sb_1-2092835-1280431606.84>set PUSH_REVISION=kostja@sun.com-20100729162720-2m6f129tc8vibrph G:\pb2\test\sb_1-2092835-1280431606.84>set PUSH_ID=1449027 G:\pb2\test\sb_1-2092835-1280431606.84>set BRANCH_SOURCE=http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ G:\pb2\test\sb_1-2092835-1280431606.84> G:\pb2\test\sb_1-2092835-1280431606.84>set PATH=%PATH%;C:\Program Files\GnuWin32\bin G:\pb2\test\sb_1-2092835-1280431606.84>perl perl pb2gentest.pl G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test/vardirs http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ rqg_mdl_stability ==================== Starting pb2gentest.pl ==================== ############################################################################## # rqg_mdl_stability ############################################################################## # 2010-07-29T21:28:26 Gathering info from the environment... # 2010-07-29T21:28:26 ===== Information on the host system: ===== # 2010-07-29T21:28:26 - Local time : Thu Jul 29 21:28:26 2010 # 2010-07-29T21:28:26 - Hostname : loki06 # 2010-07-29T21:28:26 - Username : qauser # 2010-07-29T21:28:26 - PID : 2784 # 2010-07-29T21:28:26 - Working dir : G:/pb2/scripts/randgen # 2010-07-29T21:28:26 - PATH : G:\pb2\scripts\randgen\bin;G:\pb2\scripts\bin;C:\Program Files\Debugging Tools for Windows (x86);C:\Perl\site\bin;C:\Perl\bin;C:\Perl\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\SFU\common\;C:\Program Files\NTP\bin;C:\Program Files\Bazaar;C:\Program Files\GnuWin32\bin;C:\Program Files\GnuWin32\bin # 2010-07-29T21:28:26 - Script arguments: # 2010-07-29T21:28:26 basedir = G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test # 2010-07-29T21:28:26 vardir = G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test/vardirs # 2010-07-29T21:28:26 tree = http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-29T21:28:26 test = rqg_mdl_stability # 2010-07-29T21:28:26 ===== Information on the tested binaries (PB2): ===== # 2010-07-29T21:28:26 - Branch URL : http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-29T21:28:26 - Branch name : mysql-trunk-runtime # 2010-07-29T21:28:26 - Revision : kostja@sun.com-20100729162720-2m6f129tc8vibrph # 2010-07-29T21:28:26 - Source : mysql-5.5.6-m3-win-x86.zip # 2010-07-29T21:28:26 ===== Information on Random Query Generator version (bzr): ===== # 2010-07-29T21:28:26 - Date (rev) : 2010-07-15 11:37:13 +0200 # 2010-07-29T21:28:26 - Revno : 481 # 2010-07-29T21:28:26 - Revision ID : john.embretsen@sun.com-20100715093713-rrbtthuhfkkctudc # 2010-07-29T21:28:26 - Branch nick : randgen # 2010-07-29T21:28:26 - Clean copy? : Yes # 2010-07-29T21:28:26 Configuring test... # 2010-07-29T21:28:26 XML reporting to TestTool automatically enabled based on hostname. # 2010-07-29T21:28:26 Running runall.pl... # 2010-07-29T21:28:26 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-07-29T21:28:26 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-29T21:28:26 Starting # 2010-07-29T21:28:26 # runall.pl \ # 2010-07-29T21:28:26 # --mysqld=--loose-skip-safemalloc \ # 2010-07-29T21:28:26 # --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-29T21:28:26 # --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-29T21:28:26 # --validator=SelectStability,QueryProperties \ # 2010-07-29T21:28:26 # --engine=Innodb \ # 2010-07-29T21:28:26 # --mysqld=--innodb \ # 2010-07-29T21:28:26 # --mysqld=--default-storage-engine=Innodb \ # 2010-07-29T21:28:26 # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2010-07-29T21:28:26 # --mysqld=--innodb-flush-log-at-trx-commit=2 \ # 2010-07-29T21:28:26 # --mysqld=--loose-table-lock-wait-timeout=1 \ # 2010-07-29T21:28:26 # --mysqld=--innodb-lock-wait-timeout=1 \ # 2010-07-29T21:28:26 # --mysqld=--log-output=file \ # 2010-07-29T21:28:26 # --queries=1M \ # 2010-07-29T21:28:26 # --duration=600 \ # 2010-07-29T21:28:26 # --reporters=Deadlock,ErrorLog,Backtrace,Shutdown \ # 2010-07-29T21:28:26 # --basedir=G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test \ # 2010-07-29T21:28:26 # --vardir=G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test/vardirs \ # 2010-07-29T21:28:26 # --mysqld=--loose-lock-wait-timeout=1 \ # 2010-07-29T21:28:26 # --testname=rqg_mdl_stability \ # 2010-07-29T21:28:26 # --xml-output=C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml \ # 2010-07-29T21:28:26 # --report-xml-tt \ # 2010-07-29T21:28:26 # --report-xml-tt-type=scp \ # 2010-07-29T21:28:26 # --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-29T21:28:26 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-29T21:28:26 Running perl mysql-test-run.pl --start-and-exit --mysqld=--innodb --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=G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test/vardirs --master_port=19300 --mysqld="--loose-skip-safemalloc" --mysqld="--innodb" --mysqld="--default-storage-engine=Innodb" --mysqld="--transaction-isolation=SERIALIZABLE" --mysqld="--innodb-flush-log-at-trx-commit=2" --mysqld="--loose-table-lock-wait-timeout=1" --mysqld="--innodb-lock-wait-timeout=1" --mysqld="--log-output=file" --mysqld="--loose-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 --mysqld=--innodb --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=G:/pb2/test/sb_1-2092835-1280431606.84/mysql-5.5.6-m3-win-x86-test/vardirs --master_port=19300 --mysqld=--loose-skip-safemalloc --mysqld=--innodb --mysqld=--default-storage-engine=Innodb --mysqld=--transaction-isolation=SERIALIZABLE --mysqld=--innodb-flush-log-at-trx-commit=2 --mysqld=--loose-table-lock-wait-timeout=1 --mysqld=--innodb-lock-wait-timeout=1 --mysqld=--log-output=file --mysqld=--loose-lock-wait-timeout=1 1st 100729 21:28:27 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.6 Using dynamic switching of binlog format Using default engine 'Innodb' Disable Instance manager - testing not supported on Windows Skipping ndbcluster Setting mysqld to support SSL connections Binaries are debug compiled 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 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= TEST RESULT TIME (ms) ------------------------------------------------------- Servers started, exiting # 2010-07-29T21:28:42 Starting # 2010-07-29T21:28:42 gentest.pl \ # 2010-07-29T21:28:42 --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-29T21:28:42 --engine=Innodb \ # 2010-07-29T21:28:42 --validator=SelectStability \ # 2010-07-29T21:28:42 --validator=QueryProperties \ # 2010-07-29T21:28:42 --reporter=Deadlock \ # 2010-07-29T21:28:42 --reporter=ErrorLog \ # 2010-07-29T21:28:42 --reporter=Backtrace \ # 2010-07-29T21:28:42 --reporter=Shutdown \ # 2010-07-29T21:28:42 --threads=10 \ # 2010-07-29T21:28:42 --queries=1M \ # 2010-07-29T21:28:42 --duration=600 \ # 2010-07-29T21:28:42 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \ # 2010-07-29T21:28:42 --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-29T21:28:42 --xml-output=C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml \ # 2010-07-29T21:28:42 --report-xml-tt \ # 2010-07-29T21:28:42 --report-xml-tt-type=scp \ # 2010-07-29T21:28:42 --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ \ # 2010-07-29T21:28:42 --testname=rqg_mdl_stability # 2010-07-29T21:28:42 ------------------------------- # 2010-07-29T21:28:42 Configuration # 2010-07-29T21:28:42 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2010-07-29T21:28:42 duration => 600 # 2010-07-29T21:28:42 engine => Innodb # 2010-07-29T21:28:42 gendata => conf/runtime/metadata_stability.zz # 2010-07-29T21:28:42 grammar => conf/runtime/metadata_stability.yy # 2010-07-29T21:28:42 queries => 1M # 2010-07-29T21:28:42 report-xml-tt => 1 # 2010-07-29T21:28:42 report-xml-tt-dest => regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-29T21:28:42 report-xml-tt-type => scp # 2010-07-29T21:28:42 reporters => ['Deadlock', 'ErrorLog', 'Backtrace', 'Shutdown'] # 2010-07-29T21:28:42 seed => 1 # 2010-07-29T21:28:42 testname => rqg_mdl_stability # 2010-07-29T21:28:42 threads => 10 # 2010-07-29T21:28:42 validators => ['SelectStability', 'QueryProperties'] # 2010-07-29T21:28:42 xml-output => C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml # 2010-07-29T21:28:43 Default schema: test # 2010-07-29T21:28:43 # Creating MySQL table: test.table10_innodb; engine: innodb; rows: 10 . # 2010-07-29T21:28:43 # Creating MySQL table: test.table11_innodb; engine: innodb; rows: 11 . # 2010-07-29T21:28:43 Reporters: Deadlock, ErrorLog, Backtrace, Shutdown # 2010-07-29T21:28:43 Validators: SelectStability, QueryProperties # 2010-07-29T21:28:43 Starting 10 processes, 1M queries each, duration 600 seconds. # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:44 Query: SELECT /* QUERY_ID: 7353856 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) AS `col_int_key` FROM `table10_innodb` WHERE `col_int_key` < func_2 ( `col_int_key` ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:44 Query: UPDATE table_1 SET `col_int_key` = 7 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_2 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Query: SELECT /* QUERY_ID: 15464448 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM `table11_innodb` WHERE 4 < func_3 ( func_1 ( func_1 ( `col_int_key` ) ) ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Query: UPDATE table_2 SET `col_int_key` = 4 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:44 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Query: SELECT /* QUERY_ID: 1994240 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_2 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:44 Default schema: test # 2010-07-29T21:28:44 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:45 Default schema: test # 2010-07-29T21:28:45 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:45 Query: SELECT /* QUERY_ID: 14510848 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` WHERE 3 <> `col_int_key` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:45 Default schema: test # 2010-07-29T21:28:45 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:45 Started periodic reporting process... # 2010-07-29T21:28:45 Default schema: test # 2010-07-29T21:28:45 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:45 Default schema: test # 2010-07-29T21:28:45 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-29T21:28:45 GenTest::ErrorFilter(3) started # 2010-07-29T21:28:45 Query: UPDATE table_3 SET `col_int_key` = 3 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:45 Query: SELECT /* QUERY_ID: 15723520 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 3 ) AS `col_int_key` FROM view_1 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:45 Query: SELECT /* QUERY_ID: 7866880 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM table11_innodb failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:45 Query: CALL proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:45 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:46 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10069248 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM table11_innodb failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: SELECT /* QUERY_ID: 3537408 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: CALL proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: UPDATE table_2 SET `col_int_key` = 0 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: SELECT /* QUERY_ID: 1969920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 4 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: SELECT /* QUERY_ID: 7409664 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 1 ) AS `col_int_key` FROM table11_innodb WHERE 2 < func_2 ( `col_int_key` ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:47 Query: SELECT /* QUERY_ID: 1294592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 1 ) AS `col_int_key` FROM table_2 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: UPDATE table_1 SET `col_int_key` = 8 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: SELECT /* QUERY_ID: 16506368 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM `table10_innodb` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_1 ( `col_int_key` ) FROM `table10_innodb` WHERE 9 <> func_1 ( 6 ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: SELECT /* QUERY_ID: 13693440 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM `table11_innodb` failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 3 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: INSERT INTO table_1 SELECT * FROM table_1 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 1 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 7 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_3 ( @inout1 ) failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:48 Query: SELECT /* QUERY_ID: 4877056 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM `table11_innodb` WHERE `col_int_key` < func_2 ( `col_int_key` ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:49 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 11226368 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM `table10_innodb` WHERE func_2 ( `col_int_key` ) < func_2 ( `col_int_key` ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:49 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_1 FOR EACH ROW UPDATE table_1 SET `col_int_key` = 8 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:50 Query: UPDATE table11_innodb SET `col_int_key` = 6 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:50 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 5 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:50 Query: CREATE PROCEDURE proc_3 (INOUT inout1 INT) BEGIN SELECT func_1 ( 7 ) FROM `table11_innodb` WHERE 1 <> func_1 ( func_2 ( `col_int_key` ) ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 5 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_1 ( @inout1 ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 9 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 2 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 4 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:51 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT func_1 ( `col_int_key` ) FROM `table11_innodb` WHERE `col_int_key` < `col_int_key` ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:52 Query: UPDATE table10_innodb SET `col_int_key` = 0 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:52 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 10629376 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM table_2 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 11223552 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_1 WHERE `col_int_key` < 1 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: INSERT INTO table_3 SELECT * FROM table_3 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:53 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table_1 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 5 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:28:54 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 1 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: DROP TRIGGER trigger_2 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: DROP TRIGGER trigger_1 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: SELECT /* QUERY_ID: 13137920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_1 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_2 ( 9 ) FROM `table10_innodb` WHERE func_3 ( 6 ) < 8 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT func_3 ( 6 ) ) INTO inout1 FROM `table10_innodb` ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 16112896 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM table_3 WHERE func_2 ( func_1 ( func_2 ( func_2 ( func_3 ( func_1 ( 2 ) ) ) ) ) ) <> 3 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_2 SET `col_int_key` = 3 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 7 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:55 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:56 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:28:56 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 1 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:56 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 9 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:56 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3506944 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:57 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 7492352 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:57 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT 4 ) INTO inout1 FROM `table10_innodb` ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:57 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:57 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 8 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:58 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 9 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:58 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6807296 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE func_2 ( 1 ) < 1 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:28:58 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT 5 FROM view_2 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:58 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 11564544 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM table10_innodb WHERE 4 <> 8 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:58 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 8 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:28:59 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4535808 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM table_2 WHERE func_3 ( `col_int_key` ) <> 6 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:28:59 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_1 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 5 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:59 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 8 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:28:59 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15732736 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table10_innodb failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_1 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 6 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 6981632 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 8 ) AS `col_int_key` FROM `table10_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9169920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM `table10_innodb` failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 301056 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM `table11_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 4 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 9 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table_2 SET `col_int_key` = 6 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT 2 FROM `table10_innodb` WHERE `col_int_key` < func_1 ( `col_int_key` ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 0 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table_2 SET `col_int_key` = 5 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:00 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 8 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:02 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_2 ( `col_int_key` ) FROM view_2 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:04 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 3 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:05 Query: UPDATE table11_innodb SET `col_int_key` = 1 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:29:05 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 12639232 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 3 ) AS `col_int_key` FROM table11_innodb WHERE `col_int_key` < 0 failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:05 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 9 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:05 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 1 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:06 Query: INSERT INTO table_3 SELECT * FROM table_3 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:09 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_3 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 0 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:10 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-29T21:29:11 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 5270528 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_2 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:13 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT 6 FROM view_2 WHERE `col_int_key` < 8 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:14 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_1 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 6 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:14 Query: CREATE TEMPORARY TABLE table_3 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1651712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM table11_innodb failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:14 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 9 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:15 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 0 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:15 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:17 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:29:18 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5336320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:23 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 5 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:23 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 9 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:23 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:24 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_1 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 7 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:24 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 4 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:26 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 3 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:26 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 2880512 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM table10_innodb failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:26 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 4930816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM `table11_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:27 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:31 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7595520 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM table10_innodb failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:29:36 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 1 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:36 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15235584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 5 ) AS `col_int_key` FROM table_2 WHERE func_3 ( `col_int_key` ) <> 6 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:29:37 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 1172736 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 0 ) AS `col_int_key` FROM `table11_innodb` WHERE func_3 ( func_3 ( 9 ) ) <> `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:39 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 2 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:39 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15933440 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) AS `col_int_key` FROM view_2 WHERE 9 < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:29:39 Query: SELECT /* QUERY_ID: 6909184 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM table_2 WHERE `col_int_key` < 5; returns different result when executed after a delay of 0.01 seconds. # 2010-07-29T21:29:39 --- C:\DOCUME~1\qauser\LOCALS~1\Temp\1\/randgen-4316-1280431779-server0.dump 2010-07-29 21:29:39.792361100 +0200 # 2010-07-29T21:29:39 +++ C:\DOCUME~1\qauser\LOCALS~1\Temp\1\/randgen-4316-1280431779-server1.dump 2010-07-29 21:29:39.792361100 +0200 # 2010-07-29T21:29:39 @@ -1,10 +0,0 @@ # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:39 -8 # 2010-07-29T21:29:42 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7051264 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 1 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:29:43 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 2 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:43 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 2250752 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM table_2 WHERE 7 <> 5 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:44 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 9424384 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table_3 WHERE func_1 ( func_3 ( 4 ) ) < func_2 ( `col_int_key` ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:45 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:29:45 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 5 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:29:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15575808 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 8 ) AS `col_int_key` FROM table10_innodb failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:29:53 Query: ALTER TABLE table_3 ADD COLUMN `default` INTEGER DEFAULT 2 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:54 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 2889984 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM `table10_innodb` WHERE 6 < func_1 ( 0 ) failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:54 Query: CREATE TEMPORARY TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 12926464 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:29:56 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:29:57 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 5 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:58 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 2 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:29:59 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 2224896 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 WHERE 3 < 5 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-29T21:30:03 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 8768768 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 7 ) AS `col_int_key` FROM table_3 WHERE `col_int_key` < func_3 ( 4 ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:03 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_3 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 6 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:04 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 6 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:05 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 0 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:06 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 12600576 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM table10_innodb failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:06 Query: CREATE TABLE table_1 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8257536 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM table_1 WHERE 6 <> 5 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:30:08 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 16385280 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:09 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 15325696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 0 ) AS `col_int_key` FROM table_2 WHERE 3 < `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:09 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:09 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 4 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-29T21:30:15 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 16193536 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM `table11_innodb` WHERE `col_int_key` < 4 failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:16 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6509312 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM table11_innodb failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:30:16 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8660992 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM `table11_innodb` failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-29T21:30:16 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:30:17 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 4279040 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 8 ) AS `col_int_key` FROM table_1 WHERE 4 < 0 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:20 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9241856 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:30:20 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 5617920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM table_2 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:21 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6131200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 WHERE `col_int_key` < 4 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:30:22 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 8 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:26 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 13114624 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM table_2 WHERE 0 < func_3 ( `col_int_key` ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:27 Query: ALTER TABLE table_3 ADD COLUMN `default` INTEGER DEFAULT 9 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:29 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:30:34 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:30:35 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:35 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 12247296 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 2 ) AS `col_int_key` FROM table_2 WHERE 0 <> `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:36 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 1 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:39 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:30:50 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 4 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:50 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:30:54 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:55 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 12625408 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:30:56 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 3447296 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM table_1 WHERE func_1 ( func_3 ( `col_int_key` ) ) < func_1 ( `col_int_key` ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:30:58 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4210176 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_2 WHERE 7 <> 0 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:01 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 9 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:31:05 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 275712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:06 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1949696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:11 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9510912 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 3 ) AS `col_int_key` FROM view_2 WHERE 0 < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:31 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:31:31 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5180160 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:37 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12858112 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_2 WHERE 9 < func_1 ( 5 ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:40 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 8 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:31:51 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6634752 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` <> func_1 ( func_1 ( `col_int_key` ) ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:52 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 10681088 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < 9 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:54 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 11240192 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:31:55 Query: ALTER TABLE table_3 CHANGE COLUMN `default` `default` INTEGER DEFAULT 0 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-29T21:31:55 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:32:05 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6564096 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < func_1 ( `col_int_key` ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:07 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1414912 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 8 ) AS `col_int_key` FROM view_2 WHERE 4 < func_3 ( 8 ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:09 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3123200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:13 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1543680 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:14 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 12854528 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 1 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < func_2 ( func_3 ( 4 ) ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:16 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10991616 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE func_1 ( `col_int_key` ) < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:17 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13251584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:27 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11561472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 0 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:52 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 13000192 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 WHERE func_3 ( 3 ) <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:54 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6119680 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE 5 <> 2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:32:58 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7343616 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:03 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13082624 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE 9 < 5 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:14 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6731776 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:15 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10937088 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:17 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 7641600 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_2 WHERE func_2 ( 3 ) < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:17 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 7564544 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:20 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11404544 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < 0 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:21 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6565632 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 0 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:25 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1070592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:26 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 649728 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:27 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2304 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_2 WHERE `col_int_key` < 4 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:27 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7519232 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 0 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:35 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13241600 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 5 ) AS `col_int_key` FROM view_2 WHERE 2 < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:35 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4078336 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_2 WHERE 5 < 8 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:43 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14210816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM view_2 WHERE 0 <> 3 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:44 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10377984 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_2 WHERE func_2 ( 7 ) <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:52 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 16015616 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:54 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15543552 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_2 WHERE 8 <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:33:57 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13597952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_2 WHERE 6 <> func_2 ( 3 ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:02 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 852224 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:08 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11895040 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 7 ) AS `col_int_key` FROM view_2 WHERE 3 < func_1 ( func_1 ( `col_int_key` ) ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:09 Query: CALL proc_2 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:34:14 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9461248 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:22 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1351936 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 0 ) AS `col_int_key` FROM view_2 WHERE 5 <> 2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:25 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11765248 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:27 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14086656 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 5 ) AS `col_int_key` FROM view_2 WHERE `col_int_key` <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:39 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15234560 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_2 WHERE 6 < func_2 ( 4 ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:34:53 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12565248 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:00 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4838912 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 0 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:02 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3218944 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:03 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 921344 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM view_2 WHERE func_1 ( 1 ) <> 8 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:03 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4579584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_2 WHERE func_3 ( func_3 ( 5 ) ) <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:04 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13282048 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_2 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:05 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15575552 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 WHERE `col_int_key` <> 4 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:15 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7016448 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:18 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2820096 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:22 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15211008 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_2 WHERE `col_int_key` < 4 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:35:49 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11213824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE 1 <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:01 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 2932480 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:05 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3852800 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) AS `col_int_key` FROM view_2 WHERE 6 < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:08 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15073024 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:14 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 5852928 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:22 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8442112 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 WHERE 6 < 0 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:23 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1000704 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:36 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15171072 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 1 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:38 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11047424 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_2 WHERE 8 < 6 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:50 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16620544 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_2 WHERE `col_int_key` <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:36:57 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3993344 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE func_1 ( 7 ) <> 9 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:00 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2583808 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:04 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 11635200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:06 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 569856 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:06 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-29T21:37:07 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 435200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:20 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7024896 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE 0 < 8 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:23 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9645824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_2 WHERE `col_int_key` <> 2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:34 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4861696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE func_3 ( 7 ) <> func_2 ( 9 ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:36 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14638336 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 WHERE `col_int_key` <> func_1 ( `col_int_key` ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:39 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1008640 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:45 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 714240 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:45 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3216640 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:37:55 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 11539200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:01 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13930752 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:02 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13035776 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 WHERE 5 <> func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:06 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5928960 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_2 WHERE 8 <> func_2 ( func_2 ( func_3 ( func_1 ( 5 ) ) ) ) failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:09 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16529152 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:18 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15103744 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:20 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15860480 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:22 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 12073984 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 3 ) AS `col_int_key` FROM view_2 WHERE func_3 ( 6 ) < `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:24 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4205824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_2 failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:35 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13714176 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_2 WHERE `col_int_key` <> `col_int_key` failed: 1443 The definition of table 'view_2' prevents operation CREATE on table 'table11_innodb'. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed with error code 32. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:44 Child process completed successfully. # 2010-07-29T21:38:45 Killing periodic reporting process with pid -2744... # 2010-07-29T21:38:46 Shutting down the server... # 2010-07-29T21:38:49 XML report written to C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml # 2010-07-29T21:38:49 XML Transport type: SCP # 2010-07-29T21:38:49 SCP command is: pscp.exe -q C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-29T21:38:50 Test completed with failure status 32. # 2010-07-29T21:38:50 gentest.pl exited with exit status 32 2010-07-29T21:38:50 [380] runall.pl will exit with exit status 32 serverqa.rqg_mdl_stability [ fail ] # 2010-07-29T21:38:50 runall.pl failed with exit code 32 # 2010-07-29T21:38:50 Look above this message in the test log for failure details. # 2010-07-29T21:38:50 Checking for remaining mysqld processes... PsList 1.26 - Process Information Lister Copyright (C) 1999-2004 Mark Russinovich Sysinternals - www.sysinternals.com Process information for LOKI06: Name Pid Pri Thd Hnd Priv CPU Time Elapsed Time mysqld 2880 8 14 55487 161772 0:01:36.640 0:10:07.933 # 2010-07-29T21:38:50 ^--- Found running mysqld process(es), to be killed if possible. # 2010-07-29T21:38:50 [2784] pb2gentest.pl will exit with exit status 32 exit code: 32 [SOURCEBUILDER] FAIL mysql-5.5.6-m3-win-x86-test/vardirs.zip G:\pb2\test\sb_1-2092835-1280431606.84>