See <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/164/>
------------------------------------------ [...truncated 2705 lines...] select * from t2; a b 1 1 2 2 drop table t2; delete from t1 where a=0; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/auto_increment.log> Stopping All Servers mysql-test-run: WARNING: Forcing kill of process 14143 Restoring snapshot of databases Saving core Resuming Tests embedded_innodb.auto_increment_neg_gaps [ fail ] drizzletest: At line 10: query 'delete from t1 where a in (2,3,4)' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: create table t1 (a int not null auto_increment primary key); insert into t1 values (NULL); insert into t1 values (NULL); insert into t1 values (NULL); insert into t1 values (NULL); insert into t1 values (NULL); insert into t1 values (NULL); insert into t1 values (-1); select last_insert_id(); last_insert_id() 6 delete from t1 where a in (2,3,4); More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/auto_increment_neg_gaps.log> Stopping All Servers Restoring snapshot of databases Resuming Tests embedded_innodb.basic_auto_increment [ pass ] 6 embedded_innodb.basic_create_nullable [ pass ] 5 embedded_innodb.basic_create_select [ pass ] 13 embedded_innodb.basic_create_table [ pass ] 9 embedded_innodb.basic_create_with_index [ pass ] 33 embedded_innodb.basic_delete_all_rows [ fail ] drizzletest: At line 3: query 'delete from t1' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: CREATE TABLE t1 (a int primary key); insert into t1 values (1),(2),(3); delete from t1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/basic_delete_all_rows.log> Stopping All Servers Restoring snapshot of databases Resuming Tests embedded_innodb.basic_delete_row [ fail ] drizzletest: At line 4: query 'delete from t1 where a=2' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: CREATE TABLE t1 (a int primary key); insert into t1 values (1),(2),(3),(4),(5),(6); select * from t1 order by a; a 1 2 3 4 5 6 delete from t1 where a=2; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/basic_delete_row.log> Stopping All Servers Restoring snapshot of databases Resuming Tests embedded_innodb.basic_drop_table [ pass ] 8 embedded_innodb.basic_index_lookup [ pass ] 13 embedded_innodb.basic_innodb_table_proto_table [ pass ] 6 embedded_innodb.basic_innodb_truncate_table [ pass ] 7 embedded_innodb.basic_insert [ pass ] 5 embedded_innodb.basic_insert_multi_column [ pass ] 5 embedded_innodb.basic_insert_pkey_duplicate [ pass ] 5 embedded_innodb.basic_pkey_index_reverse_scan [ pass ] 5 embedded_innodb.basic_pkey_index_scan [ pass ] 5 embedded_innodb.basic_rename_table [ pass ] 6 embedded_innodb.basic_savepoint [ pass ] 7 embedded_innodb.basic_select [ pass ] 5 embedded_innodb.basic_select_multirow [ pass ] 5 embedded_innodb.basic_show_tables [ pass ] 5 embedded_innodb.basic_statement_rollback [ pass ] 6 embedded_innodb.basic_transaction [ pass ] 8 embedded_innodb.basic_transaction_autocommit [ pass ] 8 embedded_innodb.basic_transaction_rollback [ pass ] 5 embedded_innodb.basic_update [ fail ] drizzletest: At line 3: query 'update t1 set a=2 where a=1' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: create table t1(a int primary key); insert into t1 values (1); update t1 set a=2 where a=1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/basic_update.log> Stopping All Servers mysql-test-run: WARNING: Forcing kill of process 14303 Restoring snapshot of databases Resuming Tests embedded_innodb.basic_with_indexes [ pass ] 5 embedded_innodb.config_table_function [ pass ] 2 embedded_innodb.cursor_position [ pass ] 17 embedded_innodb.index_multicolumn_unique [ pass ] 27 embedded_innodb.index_null [ pass ] 16 embedded_innodb.index_varchar [ pass ] 19 embedded_innodb.insert_null [ pass ] 9 embedded_innodb.libinnodb_datadict_dump_func [ pass ] 8 embedded_innodb.libinnodb_version_func [ pass ] 1 embedded_innodb.plugin_load [ pass ] 1 embedded_innodb.rename [ pass ] 30 embedded_innodb.rnd_pos [ fail ] drizzletest: At line 17: query 'UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = "40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr ASC LIMIT 1' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: CREATE TABLE t1 ( aufnr varchar(12) NOT NULL default '', plnfl varchar(6) NOT NULL default '', vornr varchar(4) NOT NULL default '' primary key, xstatus_vor int NOT NULL default '0' ); INSERT INTO t1 VALUES ('40004712','000001','0010',9); INSERT INTO t1 VALUES ('40004712','000001','0020',0); UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = "40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr ASC LIMIT 1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/rnd_pos.log> Stopping All Servers Restoring snapshot of databases Resuming Tests embedded_innodb.secondary_index_scan [ pass ] 18 embedded_innodb.status_table_function [ fail ] drizzletest: At line 13: query 'delete from t1' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: < snip > have_atomic_builtins SELECT * FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="page_size"; NAME VALUE page_size 16384 SELECT (@fsync_count:= VALUE) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done"; fsyncs # create table t1 (a int primary key); SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done"; fsyncs 4 insert into t1 values (1); SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done"; fsyncs 5 insert into t1 values (5),(2),(3),(4); SELECT (value - @fsync_count) AS fsyncs FROM DATA_DICTIONARY.INNODB_STATUS WHERE NAME="fsync_req_done"; fsyncs 6 delete from t1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/status_table_function.log> Stopping All Servers Restoring snapshot of databases Resuming Tests embedded_innodb.type_enum [ pass ] 824 embedded_innodb.type_float [ fail ] drizzletest: At line 72: query 'update t1 set d2 = d1' failed: 1031: Table storage engine for 't1' doesn't have this option The result from queries just before the failure was: < snip > `col2` double(22,5) NOT NULL, `col3` double NOT NULL, `col4` double DEFAULT NULL ) ENGINE=DEFAULT drop table t1,t2; create table t1 (a float primary key); insert into t1 values (1); select max(a),min(a),avg(a) from t1; max(a) min(a) avg(a) 1 1 1 drop table t1; create table t1 (c20 char primary key); insert into t1 values (5000.0); ERROR 22001: Data too long for column 'c20' at row 1 insert into t1 values (0.5e4); ERROR 22001: Data too long for column 'c20' at row 1 drop table t1; create table t1 (d1 double primary key, d2 double); insert into t1 set d1 = -1.0; update t1 set d2 = d1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build/tests/var/log/type_float.log> Stopping All Servers mysql-test-run: WARNING: Forcing kill of process 14502 Restoring snapshot of databases Resuming Tests csv.csv [ pass ] 239 csv.csv_alter_table [ pass ] 10 csv.csv_not_null [ pass ] 9 crc32.crc32 [ pass ] 5 collation_dictionary.data_dictionary [ pass ] 4 collation_dictionary.slap [ pass ] 95 blackhole.blackhole [ pass ] 8 blackhole.create_max_fields [ pass ] 438 auth_file.basic [ pass ] 4 archive.archive [ pass ] 343 archive.archive_aio_posix [ pass ] 374 archive.archive_basic [ pass ] 3 archive.archive_discover [ pass ] 3 -------------------------------------------------------------------------------- Stopping All Servers Failed 8/357 tests, 97.76% were successful. The log files in var/log may give you some hint of what went wrong. If you want to report this error, go to: http://bugs.launchpad.net/drizzle The servers were restarted 52 times Spent 346.507 of 554 seconds executing testcases mysql-test-run in default mode: *** Failing the test(s): embedded_innodb.auto_increment embedded_innodb.auto_increment_neg_gaps embedded_innodb.basic_delete_all_rows embedded_innodb.basic_delete_row embedded_innodb.basic_update embedded_innodb.rnd_pos embedded_innodb.status_table_function embedded_innodb.type_float mysql-test-run: *** ERROR: there were failing test cases make[4]: *** [test-drizzle] Error 1 make[4]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build'> make[3]: *** [check-am] Error 2 make[3]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build'> make[2]: *** [check-recursive] Error 1 make[2]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build'> make[1]: *** [check] Error 2 make[1]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu910-64bit-debug/ws/drizzle-2010.04.1503/_build'> make: *** [distcheck] Error 1 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-builds Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-builds More help : https://help.launchpad.net/ListHelp
