SunOS tor06-z1 5.10 Generic_141444-09 sun4v sparc SUNW,SPARC-Enterprise-T5120 Wed Jul 28 18:34:26 CEST 2010 + cd /export/home/pb2/test/sb_1-2086505-1280334855.73 + SOURCE=mysql-5.5.6-m3-solaris10-sparc-64bit.tar.gz + export SOURCE + SOURCENAME=mysql-5.5.6-m3-solaris10-sparc-64bit + export SOURCENAME + TMPDIR=/export/home/pb2/test/sb_1-2086505-1280334855.73/tmp + export TMPDIR + PB2WORKDIR=/export/home/pb2/test/sb_1-2086505-1280334855.73 + export PB2WORKDIR + BRANCH_ID=226 + export BRANCH_ID + PRODUCT_ID=test-sysqa_rqg_mdl_stability-sol10-sparc64 + export PRODUCT_ID + BRANCH_NAME=mysql-trunk-runtime + export BRANCH_NAME + SOURCE2NAME=unittest + export SOURCE2NAME + SOURCE2=unittest.tar.gz + export SOURCE2 + PARENT_ID=2086505 + export PARENT_ID + SOURCE1=Makefile + export SOURCE1 + SOURCE1NAME=Makefile + export SOURCE1NAME + PUSH_REVISION=kostja@sun.com-20100727143242-7bbcamhho1pvk8di + export PUSH_REVISION + PUSH_ID=1443230 + export PUSH_ID + BRANCH_SOURCE=http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ + export BRANCH_SOURCE + echo '[SOURCEBUILDER] POLICY mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs' [SOURCEBUILDER] POLICY mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs + RESULT=0 + grep 'no gnutar' no gnutar in /export/home/pb2/local/bin /opt/csw/bin /usr/bin /usr/local/bin /usr/sfw/bin + gunzip -c mysql-5.5.6-m3-solaris10-sparc-64bit.tar.gz + tar xf - + true + mv mysql-5.5.6-m3-solaris10-sparc-64bit mysql-5.5.6-m3-solaris10-sparc-64bit-test + cd mysql-5.5.6-m3-solaris10-sparc-64bit-test + mkdir vardirs ++ pwd + DIR=/export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test + cd /export/home/pb2/scripts + perl pb2gentest.pl /export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test /export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ rqg_mdl_stability ==================== Starting pb2gentest.pl ==================== ############################################################################## # rqg_mdl_stability ############################################################################## # 2010-07-28T18:36:09 Gathering info from the environment... # 2010-07-28T18:36:10 ===== Information on the host system: ===== # 2010-07-28T18:36:10 - Local time : Wed Jul 28 18:36:10 2010 # 2010-07-28T18:36:10 - Hostname : tor06-z1 # 2010-07-28T18:36:10 - Username : qauser # 2010-07-28T18:36:10 - PID : 7783 # 2010-07-28T18:36:10 - Working dir : /export/home/pb2/scripts/http_randgen # 2010-07-28T18:36:10 - PATH : /export/home/pb2/local/bin:/opt/csw/bin:/usr/bin:/usr/local/bin:/usr/sfw/bin:/opt/studio12/SUNWspro/bin # 2010-07-28T18:36:10 - Script arguments: # 2010-07-28T18:36:10 basedir = /export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test # 2010-07-28T18:36:10 vardir = /export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs # 2010-07-28T18:36:10 tree = http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-28T18:36:10 test = rqg_mdl_stability # 2010-07-28T18:36:10 ===== Information on the tested binaries (PB2): ===== # 2010-07-28T18:36:10 - Branch URL : http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-28T18:36:10 - Branch name : mysql-trunk-runtime # 2010-07-28T18:36:10 - Revision : kostja@sun.com-20100727143242-7bbcamhho1pvk8di # 2010-07-28T18:36:10 - Source : mysql-5.5.6-m3-solaris10-sparc-64bit.tar.gz # 2010-07-28T18:36:10 ===== Information on Random Query Generator version (bzr): ===== # 2010-07-28T18:36:10 - Date (rev) : 2010-07-15 11:37:13 +0200 # 2010-07-28T18:36:10 - Revno : 481 # 2010-07-28T18:36:10 - Revision ID : john.embretsen@sun.com-20100715093713-rrbtthuhfkkctudc # 2010-07-28T18:36:10 - Branch nick : http_randgen # 2010-07-28T18:36:10 - Clean copy? : Yes # 2010-07-28T18:36:10 Configuring test... # 2010-07-28T18:36:10 XML reporting to TestTool automatically enabled based on hostname. # 2010-07-28T18:36:10 Running runall.pl... # 2010-07-28T18:36:11 Copyright (c) 2008-2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. # 2010-07-28T18:36:11 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-28T18:36:11 Starting # 2010-07-28T18:36:11 # runall.pl \ # 2010-07-28T18:36:11 # --mysqld=--loose-skip-safemalloc \ # 2010-07-28T18:36:11 # --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-28T18:36:11 # --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-28T18:36:11 # --validator=SelectStability,QueryProperties \ # 2010-07-28T18:36:11 # --engine=Innodb \ # 2010-07-28T18:36:11 # --mysqld=--innodb \ # 2010-07-28T18:36:11 # --mysqld=--default-storage-engine=Innodb \ # 2010-07-28T18:36:11 # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2010-07-28T18:36:11 # --mysqld=--innodb-flush-log-at-trx-commit=2 \ # 2010-07-28T18:36:11 # --mysqld=--loose-table-lock-wait-timeout=1 \ # 2010-07-28T18:36:11 # --mysqld=--innodb-lock-wait-timeout=1 \ # 2010-07-28T18:36:11 # --mysqld=--log-output=file \ # 2010-07-28T18:36:11 # --queries=1M \ # 2010-07-28T18:36:11 # --duration=600 \ # 2010-07-28T18:36:11 # --reporters=Deadlock,ErrorLog,Backtrace,Shutdown \ # 2010-07-28T18:36:11 # --basedir=/export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test \ # 2010-07-28T18:36:11 # --vardir=/export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs \ # 2010-07-28T18:36:11 # --mysqld=--loose-lock-wait-timeout=1 \ # 2010-07-28T18:36:11 # --testname=rqg_mdl_stability \ # 2010-07-28T18:36:11 # --xml-output=/export/home/pb2/test/sb_1-2086505-1280334855.73/tmp/rqg_mdl_stability.xml \ # 2010-07-28T18:36:11 # --report-xml-tt \ # 2010-07-28T18:36:11 # --report-xml-tt-type=scp \ # 2010-07-28T18:36:11 # --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-28T18:36:11 master_port : 19300 slave_port : 19302 master_ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-28T18:36:11 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=/export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-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=/export/home/pb2/test/sb_1-2086505-1280334855.73/mysql-5.5.6-m3-solaris10-sparc-64bit-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 100728 18:36:14 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.6 Using dynamic switching of binlog format Using default engine 'Innodb' 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-07-28T18:36:26 Starting # 2010-07-28T18:36:26 gentest.pl \ # 2010-07-28T18:36:26 --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-28T18:36:26 --engine=Innodb \ # 2010-07-28T18:36:26 --validator=SelectStability \ # 2010-07-28T18:36:26 --validator=QueryProperties \ # 2010-07-28T18:36:26 --reporter=Deadlock \ # 2010-07-28T18:36:26 --reporter=ErrorLog \ # 2010-07-28T18:36:26 --reporter=Backtrace \ # 2010-07-28T18:36:26 --reporter=Shutdown \ # 2010-07-28T18:36:26 --threads=10 \ # 2010-07-28T18:36:26 --queries=1M \ # 2010-07-28T18:36:26 --duration=600 \ # 2010-07-28T18:36:26 --dsn=dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test \ # 2010-07-28T18:36:26 --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-28T18:36:26 --xml-output=/export/home/pb2/test/sb_1-2086505-1280334855.73/tmp/rqg_mdl_stability.xml \ # 2010-07-28T18:36:26 --report-xml-tt \ # 2010-07-28T18:36:26 --report-xml-tt-type=scp \ # 2010-07-28T18:36:26 --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ \ # 2010-07-28T18:36:26 --testname=rqg_mdl_stability # 2010-07-28T18:36:26 ------------------------------- # 2010-07-28T18:36:26 Configuration # 2010-07-28T18:36:26 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2010-07-28T18:36:26 duration => 600 # 2010-07-28T18:36:26 engine => Innodb # 2010-07-28T18:36:26 gendata => conf/runtime/metadata_stability.zz # 2010-07-28T18:36:26 grammar => conf/runtime/metadata_stability.yy # 2010-07-28T18:36:26 queries => 1M # 2010-07-28T18:36:26 report-xml-tt => 1 # 2010-07-28T18:36:26 report-xml-tt-dest => regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-28T18:36:26 report-xml-tt-type => scp # 2010-07-28T18:36:26 reporters => ['Deadlock', 'ErrorLog', 'Backtrace', 'Shutdown'] # 2010-07-28T18:36:26 seed => 1 # 2010-07-28T18:36:26 testname => rqg_mdl_stability # 2010-07-28T18:36:26 threads => 10 # 2010-07-28T18:36:26 validators => ['SelectStability', 'QueryProperties'] # 2010-07-28T18:36:26 xml-output => /export/home/pb2/test/sb_1-2086505-1280334855.73/tmp/rqg_mdl_stability.xml # 2010-07-28T18:36:27 Default schema: test # 2010-07-28T18:36:27 # Creating MySQL table: test.table10_innodb; engine: innodb; rows: 10 . # 2010-07-28T18:36:27 # Creating MySQL table: test.table11_innodb; engine: innodb; rows: 11 . # 2010-07-28T18:36:28 Reporters: Deadlock, ErrorLog, Backtrace, Shutdown # 2010-07-28T18:36:28 Validators: SelectStability, QueryProperties # 2010-07-28T18:36:28 Starting 10 processes, 1M queries each, duration 600 seconds. # 2010-07-28T18:36:29 GenTest::ErrorFilter(7814) started # 2010-07-28T18:36:29 Default schema: test # 2010-07-28T18:36:29 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:29 Default schema: test # 2010-07-28T18:36:29 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:29 Default schema: test # 2010-07-28T18:36:29 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:29 Default schema: test # 2010-07-28T18:36:29 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:29 Default schema: test # 2010-07-28T18:36:29 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Default schema: test # 2010-07-28T18:36:30 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Default schema: test # 2010-07-28T18:36:30 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Default schema: test # 2010-07-28T18:36:30 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Default schema: test # 2010-07-28T18:36:30 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Default schema: test # 2010-07-28T18:36:30 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-28T18:36:30 Started periodic reporting process... # 2010-07-28T18:36:30 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-28T18:36:31 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-28T18:36:31 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-28T18:36:33 Query: UPDATE table10_innodb SET `col_int_key` = 6 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-28T18:36:34 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 4 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-28T18:36:34 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-28T18:36:34 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-28T18:36:39 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-28T18:36:40 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 4 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-28T18:36:43 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-28T18:36:43 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-28T18:36:44 Query: ALTER TABLE table_2 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-28T18:36:47 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-28T18:36:49 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-28T18:36:49 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 3014400 */ /* 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-28T18:36:50 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_1 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-28T18:36:50 Query: ALTER TABLE table10_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-28T18:36:55 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-28T18:37:33 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-28T18:37:33 --- /export/home/pb2/test/sb_1-2086505-1280334855.73/tmp//randgen7818-1280335053-server0.dump Wed Jul 28 18:37:33 2010 # 2010-07-28T18:37:33 +++ /export/home/pb2/test/sb_1-2086505-1280334855.73/tmp//randgen7818-1280335053-server1.dump Wed Jul 28 18:37:33 2010 # 2010-07-28T18:37:33 @@ -1,10 +1,0 @@ # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:33 -8 # 2010-07-28T18:37:44 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-28T18:37:45 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7961856 */ /* 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-28T18:38:18 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-28T18:38:23 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-28T18:38:50 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-28T18:39:03 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-28T18:39:03 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-28T18:39:07 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-28T18:39:09 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-28T18:39:37 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-28T18:39:40 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-28T18:39:53 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-28T18:40:01 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-28T18:40:05 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-28T18:40:21 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-28T18:40:22 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-28T18:40:23 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-28T18:40:27 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-28T18:40:32 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-28T18:40:34 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-28T18:40:51 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-28T18:41:11 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-28T18:41:18 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-28T18:41:21 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-28T18:41:23 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-28T18:41:31 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-28T18:41:37 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-28T18:41:37 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-28T18:41:41 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-28T18:41:46 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-28T18:41:47 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-28T18:41:47 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-28T18:41:49 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-28T18:41:56 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-28T18:41:59 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-28T18:42:02 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-28T18:42:04 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-28T18:42:08 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-28T18:42:18 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-28T18:42:23 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-28T18:42:32 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-28T18:42:33 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-28T18:42:35 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-28T18:42:55 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-28T18:42:55 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-28T18:43:04 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-28T18:43:16 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-28T18:43:20 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9103104 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) 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-28T18:43:21 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-28T18:43:25 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-28T18:43:26 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-28T18:43:27 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-28T18:43:27 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-28T18:43:30 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-28T18:43:30 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-28T18:43:37 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-28T18:43:47 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-28T18:43:51 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-28T18:44:11 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-28T18:44:33 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-28T18:44:35 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-28T18:44:40 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-28T18:44:49 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-28T18:44:54 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-28T18:44:55 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-28T18:45:02 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-28T18:45:07 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-28T18:45:21 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-28T18:45:29 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-28T18:45:39 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-28T18:45:45 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-28T18:45:47 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-28T18:45:55 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-28T18:45:56 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-28T18:46:05 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-28T18:46:10 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-28T18:46:15 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-28T18:46:21 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-28T18:46:29 Child process completed with error code 32. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:29 Child process completed successfully. # 2010-07-28T18:46:30 Killing periodic reporting process with pid 7815... # 2010-07-28T18:46:30 Kill GenTest::ErrorFilter(7814) # 2010-07-28T18:46:30 Shutting down the server... # 2010-07-28T18:46:30 Waiting for mysqld with pid 7808 to terminate... +++++ # 2010-07-28T18:46:35 ... waiting complete. # 2010-07-28T18:46:37 XML report written to /export/home/pb2/test/sb_1-2086505-1280334855.73/tmp/rqg_mdl_stability.xml # 2010-07-28T18:46:37 XML Transport type: SCP # 2010-07-28T18:46:37 SCP command is: scp /export/home/pb2/test/sb_1-2086505-1280334855.73/tmp/rqg_mdl_stability.xml regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-28T18:46:37 Test completed with failure status 32. # 2010-07-28T18:46:37 gentest.pl exited with exit status 32 2010-07-28T18:46:37 [7792] runall.pl will exit with exit status 32 serverqa.rqg_mdl_stability [ fail ] # 2010-07-28T18:46:37 runall.pl failed with exit code 32 # 2010-07-28T18:46:37 Look above this message in the test log for failure details. # 2010-07-28T18:46:37 Checking for remaining mysqld processes... # 2010-07-28T18:46:37 None found. # 2010-07-28T18:46:37 [7783] pb2gentest.pl will exit with exit status 32 + grep 'no gnutar' no gnutar in /export/home/pb2/local/bin /opt/csw/bin /usr/bin /usr/local/bin /usr/sfw/bin + tar cf mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs tar: mysql-5.5.6-m3-solaris10-sparc-64bit-test/vardirs/std_data_ln: symbolic link too long + true + gzip mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar + true + ls -l mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar.gz -rw-r--r-- 1 qauser staff 3638996 Jul 28 18:46 mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar.gz + test x0 = x1 + echo '[SOURCEBUILDER] FAIL mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar.gz' [SOURCEBUILDER] FAIL mysql-5.5.6-m3-solaris10-sparc-64bit-test.tar.gz + exit