See <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/428/>
------------------------------------------ [...truncated 4200 lines...] haildb.config_print_verbose_log_on [ pass ] 29 haildb.config_read_io_threads_64 [ pass ] 27 haildb.config_read_io_threads_default [ pass ] 6 haildb.config_rollback_on_timeout [ pass ] 20 haildb.config_rollback_on_timeout_off [ pass ] 3 haildb.config_rollback_on_timeout_on [ pass ] 2 haildb.config_status_file [ fail ] drizzletest: At line 4: query 'SET GLOBAL innodb_status_file=1' failed: 20: drizzle_state_read:lost connection to server (EOF) The result from queries just before the failure was: SET @my_statusfile = @@global.innodb_status_file; SHOW VARIABLES LIKE 'innodb_status_file'; Variable_name Value innodb_status_file OFF SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME='status_file'; NAME TYPE VALUE status_file BOOL false SET GLOBAL innodb_status_file=1; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/config_status_file.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.config_sync_spin_loops [ pass ] 2 haildb.config_sync_spin_loops_100 [ pass ] 9 haildb.config_table_function [ pass ] 3 haildb.config_use_internal_malloc [ pass ] 2 haildb.config_use_sys_malloc [ pass ] 11 haildb.config_write_io_threads_64 [ pass ] 2 haildb.config_write_io_threads_default [ pass ] 2 haildb.count_distinct [ pass ] 156 haildb.count_distinct2 [ pass ] 1637 haildb.count_distinct3 [ fail ] drizzletest: At line 18: query 'SET @rnd= RAND()' failed: 20: drizzle_state_read:lost connection to server (EOF) The result from queries just before the failure was: DROP TABLE IF EXISTS t1, t2; CREATE TABLE t1 (id INTEGER, grp int, id_rev INTEGER); More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/count_distinct3.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.cursor_position [ pass ] 38 haildb.datadict_tables [ pass ] 57 haildb.drizzleslap [ pass ] 38135 haildb.haildb_datadict_dump_func [ pass ] 18 haildb.index_length_limit [ pass ] 26 haildb.index_multicolumn_unique [ pass ] 214 haildb.index_null [ pass ] 32 haildb.index_prefix [ pass ] 43 haildb.index_varchar [ pass ] 20 haildb.insert_null [ pass ] 56 haildb.lock_in_shared_mode [ pass ] 6194 haildb.plugin_load [ pass ] 33 haildb.rename [ pass ] 80 haildb.replace [ pass ] 54 haildb.rnd_pos [ pass ] 69 haildb.row_format [ pass ] 32 drizzle-test-run: WARNING: Forcing kill of process 17908 haildb.row_format_file_per_table [ pass ] 73 haildb.secondary_index_scan [ pass ] 25 haildb.status_table_function [ pass ] 27 haildb.truncate [ pass ] 47 haildb.trx_isolation_read_uncommitted [ pass ] 23 haildb.trx_isolation_repeatable_read [ pass ] 16 haildb.trx_isolation_serializable [ pass ] 16 haildb.type_blob [ pass ] 676 haildb.type_blob_basic [ pass ] 16 haildb.type_blob_func [ pass ] 28 haildb.type_date [ pass ] 124 haildb.type_datetime [ pass ] 334 haildb.type_decimal [ fail ] drizzletest: At line 405: query 'set @a=1.0' failed: 20: drizzle_state_read:lost connection to server (EOF) The result from queries just before the failure was: < snip > ERROR 42000: Too big precision 66 specified for column 'd'. Maximum is 65. CREATE TABLE t1 (i INT, d1 DECIMAL(9,2), d2 DECIMAL(9,2)); INSERT INTO t1 VALUES (1, 101.40, 21.40), (1, -80.00, 0.00), (2, 0.00, 0.00), (2, -13.20, 0.00), (2, 59.60, 46.40), (2, 30.40, 30.40), (3, 37.00, 7.40), (3, -29.60, 0.00), (4, 60.00, 15.40), (4, -10.60, 0.00), (4, -34.00, 0.00), (5, 33.00, 0.00), (5, -25.80, 0.00), (5, 0.00, 7.20), (6, 0.00, 0.00), (6, -51.40, 0.00); SELECT i, SUM(d1) AS a, SUM(d2) AS b FROM t1 GROUP BY i HAVING a <> b; i a b 6 -51.40 0.00 SELECT i, ROUND(SUM(d1), 2) AS a, ROUND(SUM(d2), 2) AS b FROM t1 GROUP BY i HAVING a <> b; i a b 6 -51.40 0.00 drop table t1; create table t1 (c1 varchar(100), c2 longtext); insert into t1 set c1= 'non PS, 1.0 as constant', c2=1.0; insert into t1 set c1='PS, 1.0 as constant ', c2=1.0; set @a=1.0; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/type_decimal.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.type_enum [ pass ] 588 haildb.type_float [ pass ] 184 haildb.type_timestamp [ fail ] drizzletest: At line 112: query 'SET TIMESTAMP=1000000000' failed: 20: drizzle_state_read:lost connection to server (EOF) The result from queries just before the failure was: < snip > ERROR HY000: Received an invalid value '0' for a UNIX timestamp. select ix+0 from t1; ix+0 truncate table t1; insert into t1 values ("00000000000000"),("20030101010160"),("20030101016001"),("20030101240101"),("20030132010101"),("20031301010101"),("20031200000000"),("20030000000000"); ERROR HY000: Received an invalid value '00000000000000' for a UNIX timestamp. select ix+0 from t1; ix+0 truncate table t1; insert into t1 values ("0000-00-00 00:00:00 some trailer"),("2003-01-01 00:00:00 some trailer"); ERROR HY000: Received an invalid value '0000-00-00 00:00:00 some trailer' for a UNIX timestamp. select ix+0 from t1; ix+0 drop table t1; create table t1 (t1 timestamp default now(), t2 timestamp on update now()); ERROR HY000: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause create table t1 (t1 timestamp on update now(), t2 timestamp default now() on update now()); ERROR HY000: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause create table t1 (t1 timestamp default '2003-01-01 00:00:00', t2 datetime, t3 timestamp); SET TIMESTAMP=1000000000; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/type_timestamp.log> Stopping All Servers Restoring snapshot of databases Resuming Tests function_dictionary.functions [ pass ] 163 filtered_replicator.filtered_replicator [ fail ] drizzletest: At line 18: query 'set global filtered_replicator_filteredtables=t2' failed: 20: drizzle_state_read:lost connection to server (EOF) The result from queries just before the failure was: set global filtered_replicator_filteredtables=t2; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/filtered_replicator.log> Stopping All Servers Restoring snapshot of databases Resuming Tests filesystem_engine.basic_create_table [ pass ] 18 filesystem_engine.basic_delete [ pass ] 65 filesystem_engine.basic_insert [ pass ] 14 filesystem_engine.basic_select [ pass ] 24 filesystem_engine.basic_update [ pass ] 15 filesystem_engine.multiple_update [ pass ] 1867 filesystem_engine.rnd_pos [ pass ] 24 filesystem_engine.select_big_file [ pass ] 12 filesystem_engine.select_chop_line [ pass ] 3 filesystem_engine.select_cpuinfo [ pass ] 6 filesystem_engine.select_meminfo [ pass ] 5 filesystem_engine.select_separator_mode_weak [ pass ] 2 filesystem_engine.select_short_line [ pass ] 3 filesystem_engine.select_skip_blank_line [ pass ] 3 filesystem_engine.select_with_escaped_character [ pass ] 3 filesystem_engine.select_with_omit_field [ pass ] 4 filesystem_engine.select_with_separators [ pass ] 3 error_dictionary.main [ pass ] 70 errmsg_stderr.stderr [ pass ] 38 debug.assert [ pass ] 11 csv.alter_table [ pass ] 297 csv.basic [ pass ] 997 csv.bool_type [ pass ] 32 csv.not_null [ pass ] 44 csv.uuid_type [ pass ] 9 crc32.crc32 [ pass ] 109 collation_dictionary.data_dictionary [ pass ] 31 collation_dictionary.slap [ pass ] 297 blitzdb.alter [ pass ] 54 blitzdb.basic [ pass ] 441 blitzdb.bug621755-renametable-not-updating [ pass ] 88 blitzdb.decimal [ pass ] 362 blitzdb.index [ pass ] 981 blitzdb.indexes [ pass ] 84 blitzdb.join [ pass ] 133 blitzdb.range [ pass ] 158 blackhole.blackhole [ pass ] 86 blackhole.create_max_fields [ pass ] 666 auth_test.basic [ pass ] 45 auth_file.basic [ pass ] 93 archive.aio_posix [ fail ] drizzletest: At line 10: query 'SET GLOBAL archive_aio=ON' failed: 1232: Incorrect argument type to variable 'storage_engine' The result from queries just before the failure was: DROP TABLE if exists t1,t2,t3,t4,t5,t6; SET storage_engine=ARCHIVE; SET GLOBAL archive_aio=ON; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/aio_posix.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.basic [ pass ] 61 archive.bool_type [ pass ] 240 archive.discover [ pass ] 55 archive.engine [ fail ] drizzletest: At line 11: query 'SET GLOBAL archive_aio=OFF' failed: 1286: Unknown table engine 'OFF' The result from queries just before the failure was: DROP TABLE if exists t1,t2,t3,t4,t5,t6; SET storage_engine=ARCHIVE; SET GLOBAL archive_aio=OFF; More results from queries before failure can be found in <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build/tests/var/log/engine.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.uuid_type [ pass ] 95 -------------------------------------------------------------------------------- Stopping All Servers Failed 65/646 tests, 89.94% 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 194 times Spent 361.603 of 1246 seconds executing testcases drizzle-test-run in default mode: *** Failing the test(s): main.count_distinct3 main.create main.ctype_utf8 main.data_dictionary_like_info main.drizzledump main.drizzledump_restore main.func_gconcat main.func_group main.func_in main.func_str main.greedy_optimizer main.information_schema main.information_schema_inno main.join_outer main.loaddata main.olap main.order_by main.parser main.savepoints main.select_safe main.small_tmp_table main.status main.subselect main.subselect_mat main.subselect_sj2 main.type_decimal main.type_newdecimal main.type_timestamp main.union main.user_var main.variables main.warnings user_locks.create_barrier user_locks.kill_wait user_locks.signal_count user_locks.wait transaction_log.auto_commit transaction_log.rollback transaction_log.select_for_update transaction_log.transaction_log_rollback transaction_log.transaction_log_transaction transaction_log.truncate_log session_dictionary.long_proccesslist_info session_dictionary.user_variable myisam.basic myisam.mix2_myisam memory.basic memory.heap_var innobase.deadlock_innodb innobase.index_merge_innodb innobase.innodb-autoinc-44030 innobase.innodb-semi-consistent innobase.innodb innobase.innodb_bug53591 innobase.innodb_mysql innobase.unsafe_binlog_innodb haildb.config_lru_block_access_recency haildb.config_lru_old_blocks_pct haildb.config_status_file haildb.count_distinct3 haildb.type_decimal haildb.type_timestamp filtered_replicator.filtered_replicator archive.aio_posix archive.engine drizzle-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-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build'> make[3]: *** [check-am] Error 2 make[3]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build'> make[2]: *** [check-recursive] Error 1 make[2]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_build'> make[1]: *** [check] Error 2 make[1]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.10-64bit/ws/drizzle7-2010.12.2045/_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
