See <http://hudson.drizzle.org/job/drizzle-build-fedora14/1088/>
------------------------------------------ [...truncated 4881 lines...] haildb.config_max_dirty_pages_pct [ pass ] 0 haildb.config_max_dirty_pages_pct_50 [ pass ] 20 haildb.config_max_purge_lag [ pass ] 20 haildb.config_max_purge_lag_42 [ pass ] 20 haildb.config_open_files_800 [ pass ] 10 haildb.config_open_files_default [ pass ] 40 haildb.config_print_verbose_log [ pass ] 30 haildb.config_print_verbose_log_off [ pass ] 0 haildb.config_print_verbose_log_on [ pass ] 50 haildb.config_read_io_threads_64 [ pass ] 10 haildb.config_read_io_threads_default [ pass ] 20 haildb.config_rollback_on_timeout [ pass ] 10 haildb.config_rollback_on_timeout_off [ pass ] 20 haildb.config_rollback_on_timeout_on [ pass ] 70 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-fedora14/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 ] 50 haildb.config_sync_spin_loops_100 [ pass ] 20 haildb.config_table_function [ pass ] 30 haildb.config_use_internal_malloc [ pass ] 30 haildb.config_use_sys_malloc [ pass ] 10 haildb.config_write_io_threads_64 [ pass ] 50 haildb.config_write_io_threads_default [ pass ] 60 haildb.count_distinct [ pass ] 90 haildb.count_distinct2 [ pass ] 1470 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-fedora14/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 ] 110 haildb.datadict_tables [ pass ] 140 haildb.drizzleslap [ pass ] 51890 haildb.haildb_datadict_dump_func [ pass ] 40 haildb.index_length_limit [ pass ] 50 haildb.index_multicolumn_unique [ pass ] 190 haildb.index_null [ pass ] 20 haildb.index_prefix [ pass ] 90 haildb.index_varchar [ pass ] 120 haildb.insert_null [ pass ] 30 haildb.lock_in_shared_mode [ pass ] 5870 haildb.plugin_load [ pass ] 20 haildb.rename [ pass ] 90 haildb.replace [ pass ] 20 haildb.rnd_pos [ pass ] 40 haildb.row_format [ pass ] 30 drizzle-test-run: WARNING: Forcing kill of process 9516 haildb.row_format_file_per_table [ pass ] 680 haildb.secondary_index_scan [ pass ] 50 haildb.status_table_function [ pass ] 60 haildb.truncate [ pass ] 100 haildb.trx_isolation_read_uncommitted [ pass ] 50 haildb.trx_isolation_repeatable_read [ pass ] 40 haildb.trx_isolation_serializable [ pass ] 10 haildb.type_blob [ pass ] 1610 haildb.type_blob_basic [ pass ] 110 haildb.type_blob_func [ pass ] 220 haildb.type_date [ pass ] 210 haildb.type_datetime [ pass ] 480 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-fedora14/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 ] 970 haildb.type_float [ pass ] 660 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-fedora14/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 ] 330 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-fedora14/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 ] 60 filesystem_engine.basic_delete [ pass ] 220 filesystem_engine.basic_insert [ pass ] 70 filesystem_engine.basic_select [ pass ] 0 filesystem_engine.basic_update [ pass ] 30 filesystem_engine.multiple_update [ pass ] 3140 filesystem_engine.rnd_pos [ pass ] 20 filesystem_engine.select_big_file [ pass ] 10 filesystem_engine.select_chop_line [ pass ] 20 filesystem_engine.select_cpuinfo [ pass ] 0 filesystem_engine.select_meminfo [ pass ] 20 filesystem_engine.select_separator_mode_weak [ pass ] 10 filesystem_engine.select_short_line [ pass ] 20 filesystem_engine.select_skip_blank_line [ pass ] 10 filesystem_engine.select_with_escaped_character [ pass ] 10 filesystem_engine.select_with_omit_field [ pass ] 20 filesystem_engine.select_with_separators [ pass ] 10 error_dictionary.main [ pass ] 210 errmsg_stderr.stderr [ pass ] 30 debug.assert [ pass ] 30 csv.alter_table [ pass ] 110 csv.basic [ pass ] 550 csv.bool_type [ pass ] 10 csv.not_null [ pass ] 120 csv.uuid_type [ pass ] 40 crc32.crc32 [ pass ] 20 collation_dictionary.data_dictionary [ pass ] 30 collation_dictionary.slap [ pass ] 220 blackhole.blackhole [ pass ] 20 blackhole.create_max_fields [ pass ] 700 auth_test.basic [ pass ] 30 auth_file.basic [ pass ] 60 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-fedora14/ws/drizzle7-2010.12.2045/_build/tests/var/log/aio_posix.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.basic [ pass ] 60 archive.bool_type [ pass ] 90 archive.discover [ pass ] 20 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-fedora14/ws/drizzle7-2010.12.2045/_build/tests/var/log/engine.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.uuid_type [ pass ] 10 -------------------------------------------------------------------------------- Stopping All Servers Failed 65/637 tests, 89.80% 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 192 times Spent 350.860 of 1229 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-fedora14/ws/drizzle7-2010.12.2045/_build'> make[3]: *** [check-am] Error 2 make[3]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-fedora14/ws/drizzle7-2010.12.2045/_build'> make[2]: *** [check-recursive] Error 1 make[2]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-fedora14/ws/drizzle7-2010.12.2045/_build'> make[1]: *** [check] Error 2 make[1]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-fedora14/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
