See <http://hudson.drizzle.org/job/drizzle-build-ubuntu10.04-64bit-debug/1036/>
------------------------------------------ [...truncated 4479 lines...] haildb.config_print_verbose_log [ pass ] 2 haildb.config_print_verbose_log_off [ pass ] 3 haildb.config_print_verbose_log_on [ pass ] 2 haildb.config_read_io_threads_64 [ pass ] 34 haildb.config_read_io_threads_default [ pass ] 30 haildb.config_rollback_on_timeout [ pass ] 2 haildb.config_rollback_on_timeout_off [ pass ] 2 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.04-64bit-debug/ws/tests/var/log/config_status_file.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.config_sync_spin_loops [ pass ] 35 haildb.config_sync_spin_loops_100 [ pass ] 44 haildb.config_table_function [ pass ] 20 haildb.config_use_internal_malloc [ pass ] 9 haildb.config_use_sys_malloc [ pass ] 17 haildb.config_write_io_threads_64 [ pass ] 2 haildb.config_write_io_threads_default [ pass ] 2 haildb.count_distinct [ pass ] 99 haildb.count_distinct2 [ pass ] 1834 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.04-64bit-debug/ws/tests/var/log/count_distinct3.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.cursor_position [ pass ] 163 haildb.datadict_tables [ pass ] 103 haildb.drizzleslap [ pass ] 42654 haildb.haildb_datadict_dump_func [ pass ] 16 haildb.index_length_limit [ pass ] 45 haildb.index_multicolumn_unique [ pass ] 38 haildb.index_null [ pass ] 36 haildb.index_prefix [ pass ] 49 haildb.index_varchar [ pass ] 17 haildb.insert_null [ pass ] 86 haildb.lock_in_shared_mode [ pass ] 6245 haildb.plugin_load [ pass ] 26 haildb.rename [ pass ] 116 haildb.replace [ pass ] 25 haildb.rnd_pos [ pass ] 92 haildb.row_format [ pass ] 20 drizzle-test-run: WARNING: Forcing kill of process 25651 haildb.row_format_file_per_table [ pass ] 45 haildb.secondary_index_scan [ pass ] 39 haildb.status_table_function [ pass ] 44 haildb.truncate [ pass ] 135 haildb.trx_isolation_read_uncommitted [ pass ] 68 haildb.trx_isolation_repeatable_read [ pass ] 36 haildb.trx_isolation_serializable [ pass ] 18 haildb.type_blob [ pass ] 626 haildb.type_blob_basic [ pass ] 32 haildb.type_blob_func [ pass ] 40 haildb.type_date [ pass ] 139 haildb.type_datetime [ pass ] 234 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.04-64bit-debug/ws/tests/var/log/type_decimal.log> Stopping All Servers Restoring snapshot of databases Resuming Tests haildb.type_enum [ pass ] 1250 haildb.type_float [ pass ] 201 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.04-64bit-debug/ws/tests/var/log/type_timestamp.log> Stopping All Servers Restoring snapshot of databases Resuming Tests function_dictionary.functions [ pass ] 100 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.04-64bit-debug/ws/tests/var/log/filtered_replicator.log> Stopping All Servers Restoring snapshot of databases Resuming Tests filesystem_engine.basic_create_table [ pass ] 176 filesystem_engine.basic_delete [ pass ] 126 filesystem_engine.basic_insert [ pass ] 40 filesystem_engine.basic_select [ pass ] 9 filesystem_engine.basic_update [ pass ] 44 filesystem_engine.multiple_update [ pass ] 1831 filesystem_engine.rnd_pos [ pass ] 36 filesystem_engine.select_big_file [ pass ] 39 filesystem_engine.select_chop_line [ pass ] 4 filesystem_engine.select_cpuinfo [ pass ] 18 filesystem_engine.select_meminfo [ pass ] 10 filesystem_engine.select_separator_mode_weak [ pass ] 3 filesystem_engine.select_short_line [ pass ] 4 filesystem_engine.select_skip_blank_line [ pass ] 3 filesystem_engine.select_with_escaped_character [ pass ] 4 filesystem_engine.select_with_omit_field [ pass ] 4 filesystem_engine.select_with_separators [ pass ] 3 error_dictionary.main [ pass ] 43 errmsg_stderr.stderr [ pass ] 19 debug.assert [ pass ] 35 csv.alter_table [ pass ] 128 csv.basic [ pass ] 580 csv.bool_type [ pass ] 27 csv.not_null [ pass ] 25 csv.uuid_type [ pass ] 34 crc32.crc32 [ pass ] 96 collation_dictionary.data_dictionary [ pass ] 36 collation_dictionary.slap [ pass ] 347 blitzdb.alter [ pass ] 77 blitzdb.basic [ pass ] 360 blitzdb.bug621755-renametable-not-updating [ pass ] 109 blitzdb.decimal [ pass ] 477 blitzdb.index [ pass ] 843 blitzdb.indexes [ pass ] 27 blitzdb.join [ pass ] 93 blitzdb.range [ pass ] 99 blackhole.blackhole [ pass ] 28 blackhole.create_max_fields [ pass ] 1900 auth_test.basic [ pass ] 32 auth_file.basic [ pass ] 97 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.04-64bit-debug/ws/tests/var/log/aio_posix.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.basic [ pass ] 78 archive.bool_type [ pass ] 51 archive.discover [ pass ] 15 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.04-64bit-debug/ws/tests/var/log/engine.log> Stopping All Servers Restoring snapshot of databases Resuming Tests archive.uuid_type [ pass ] 78 -------------------------------------------------------------------------------- Stopping All Servers Failed 65/647 tests, 89.95% 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 195 times Spent 389.837 of 1315 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[3]: *** [test-drizzle] Error 1 make[3]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.04-64bit-debug/ws/'> make[2]: *** [check-am] Error 2 make[2]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.04-64bit-debug/ws/'> make[1]: *** [check-recursive] Error 1 make[1]: Leaving directory `<http://hudson.drizzle.org/job/drizzle-build-ubuntu10.04-64bit-debug/ws/'> make: *** [check] Error 2 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-builds Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-builds More help : https://help.launchpad.net/ListHelp
