Hi everyone, The randgen trx log test is currently breaking as follows:
# 2011-01-07T23:21:49 /home/hudson/hudson/workspace/drizzle-staging-randgen-transaction-log/client/drizzle --host=127.0.0.1 --port=9307 --user=root test < /tmp//translog_27780_.sql ERROR 1727 (HY000): Transactional DDL not supported # 2011-01-07T23:21:49 Test completed with failure status STATUS_UNKNOWN_ERROR (2) It would seem that it is tied to the patch discussed here: http://www.flamingspork.com/blog/2011/01/06/no-implicit-commit-on-the-road-to-transactional-ddl/#comments For some background, the randgen test runs a variety of queries (well throws a heaping mess of them at the server). After we are done executing our queries, we convert the trx log into SQL via transaction_reader. We then try to populate a validation server via this SQL. This seems especially puzzling as the output from the transaction_reader / randgen combo looks like this: As far as I can see, there are no implicit DDL commits that should be breaking things...any thoughts? START TRANSACTION; CREATE TABLE `test`.`A` ( `pk` INT NOT NULL AUTO_INCREMENT, `col_enum_not_null_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_char_10_key` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL, `col_char_1024_not_null` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL, `col_char_10_not_null_key` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `col_text_key` TEXT COLLATE utf8_general_ci, `col_enum_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL, `col_int` INT DEFAULT NULL, `col_bigint_not_null` BIGINT NOT NULL, `col_enum_not_null` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_bigint_not_null_key` BIGINT NOT NULL, `col_text_not_null_key` TEXT COLLATE utf8_general_ci NOT NULL, `col_char_1024_key` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `col_enum` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL, `col_bigint_key` BIGINT DEFAULT NULL, `col_bigint` BIGINT DEFAULT NULL, `col_int_key` INT DEFAULT NULL, `col_text_not_null` TEXT COLLATE utf8_general_ci NOT NULL, `col_char_1024` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL, `col_int_not_null` INT NOT NULL, `col_char_10_not_null` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `col_char_1024_not_null_key` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL, `col_char_10` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL, `col_text` TEXT COLLATE utf8_general_ci, `col_int_not_null_key` INT NOT NULL, PRIMARY KEY (`pk`), KEY `col_enum_not_null_key` (`col_enum_not_null_key`), KEY `col_char_10_key` (`col_char_10_key`), KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`), KEY `col_text_key` (`col_text_key`(255)), KEY `col_enum_key` (`col_enum_key`), KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`), KEY `col_text_not_null_key` (`col_text_not_null_key`(255)), KEY `col_char_1024_key` (`col_char_1024_key`(255)), KEY `col_bigint_key` (`col_bigint_key`), KEY `col_int_key` (`col_int_key`), KEY `col_char_1024_not_null_key` (`col_char_1024_not_null_key`(255)), KEY `col_int_not_null_key` (`col_int_not_null_key`) ) ENGINE=InnoDB COLLATE = utf8_general_ci; COMMIT; START TRANSACTION; ALTER TABLE `A` DISABLE KEYS; COMMIT; START TRANSACTION; INSERT INTO `test`.`a` (`pk`,
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
