Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0
-
None
Description
Needs cleaning and if possible improving stability, but concurrent ANALYZE invocations, a mix of character set, non-determinism, and non-critical outcome altogether make the problem unimportant. I just need it to be filed so that the tests could ignore it in future.
Note that the test uses LOAD_FILE, the file is attached.
Command line MTR options are in the first line of the test case.
# Remaining options: --mysqld=--innodb --mysqld=--plugin-maturity=experimental --mysqld=--connect-timeout=10 --mysqld=--debug-no-sync=FALSE --mysqld=--log-bin-trust-function-creators=FALSE --mysqld=--max-heap-table-size=16777216 --mysqld=--loose-feedback-debug-interval= --mysqld=--loose-innodb-buffer-pool-size=134217728 --mysqld=--loose-innodb-write-io-threads=4 --mysqld=--loose-innodb-log-file-size=100663296 --mysqld=--loose-plugin-blackhole --mysqld=--loose-plugin-innodb-buffer-pool-stats --mysqld=--loose-plugin-innodb-cmp --mysqld=--loose-plugin-innodb-cmp-per-index --mysqld=--loose-plugin-innodb-cmp-reset --mysqld=--loose-plugin-innodb-ft-default-stopword --mysqld=--loose-plugin-innodb-ft-deleted --mysqld=--loose-plugin-innodb-ft-index-cache --mysqld=--loose-plugin-innodb-sys-fields --mysqld=--loose-plugin-innodb-sys-indexes --mysqld=--loose-plugin-innodb-sys-tablespaces --mysqld=--loose-plugin-innodb-sys-tablestats --mysqld=--loose-plugin-innodb-tablespaces-encryption --mysqld=--loose-plugin-thread-pool-stats --mysqld=--loose-plugin-wsrep-provider --mysqld=--slow-query-log-file=mesh-slow.log --mysqld=--secure-file-priv= --mysqld=--loose-debug-assert-on-not-freed-memory=1 --mysqld=--thread_pool_dedicated_listener=ON --mysqld=--slave-transaction-retry-errors=1213,1205 --mysqld=--character-set-server=macce --mysqld=--collation-server=macce_nopad_bin --mysqld=--max-statement-time=20 --mysqld=--lock-wait-timeout=0 --mem --repeat=100 |
|
|
# Search pattern(s): (?^s:Failed to parse histogram for table) |
|
|
--let $charset= `SELECT @@character_set_server`
|
--let $collation= `SELECT @@collation_server`
|
--eval alter database test charset $charset collate $collation
|
/* WRK-0 QNO 7 */ CREATE DATABASE IF NOT EXISTS blobs_db; |
/* WRK-0 QNO 9 */ USE blobs_db; |
/* WRK-0 QNO 61 */ CREATE TABLE `BB` ( |
pk integer auto_increment, |
`col_tinytext_utf8_not_null_key` tinytext CHARACTER SET utf8 not null, |
`col_text_utf8_not_null_key` text CHARACTER SET utf8 not null, |
primary key (pk ASC), |
key (`col_text_utf8_not_null_key` (255) ASC)) ENGINE=aria; |
--error ER_DUP_FIELDNAME |
/* WRK-0 QNO 62 */ ALTER TABLE `BB` ADD pk BIGINT AUTO_INCREMENT PRIMARY KEY; |
/* WRK-0 QNO 7 */ CREATE DATABASE IF NOT EXISTS advanced_db; |
/* WRK-0 QNO 12 */ CREATE TABLE advanced_db.t1_Aria (col_char BINARY(192) NOT NULL DEFAULT '', col_timestamp TIMESTAMP NOT NULL DEFAULT '1971-01-01 00:00:00', col_int TINYINT(24) NULL, col_varchar VARCHAR(2110) NOT NULL DEFAULT '', col_inet6 INET6 NULL, id INTEGER AUTO_INCREMENT, PRIMARY KEY(id)) ENGINE=Aria; |
--connect (con19_0,localhost,root,,)
|
--connect (con20_0,localhost,root,,)
|
/* WRK-3 QNO 16 */ CREATE OR REPLACE TABLE global_4 ( f1 VARCHAR ( 32 ) CHARACTER SET utf8 NOT NULL, f2 VARCHAR ( 32 ), f3 VARCHAR ( 128 ), f4 VARCHAR ( 1024 ) DEFAULT 'lamvhzzwxplmnbceorxazhtbursdv', f5 VARBINARY ( 512 ), KEY ( f2 ( 2 ) ) USING BTREE, KEY ( f2 ( 32 ), f1 ( 32 ) ) USING BTREE ) ENGINE=HEAP ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 3072 IGNORE SELECT 'bag' AS f1, 'w' AS f2, 't' AS f3, 'foundation' AS f4, 'c' AS f5 FROM DUAL; |
--connection con19_0
|
/* WRK-2 QNO 8971 */ CREATE TABLE IF NOT EXISTS local_2_5 ( f1 VARCHAR ( 128 ) DEFAULT 'rwtafjazbzwf', f2 VARCHAR ( 32 ) CHARACTER SET utf8, f3 VARCHAR ( 128 ), f4 VARCHAR ( 128 ) DEFAULT 'wtafjazbzwfhcovekwd', f5 VARCHAR ( 512 ) COLLATE utf8_bin DEFAULT 'tafjazbzwfhc', PRIMARY KEY ( f2 ) USING BTREE ) ENGINE=HEAP ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 512 SELECT * FROM global_4; |
/* WRK-2 QNO 9054 */ INSERT IGNORE INTO local_2_5 VALUES ( 5, NULL, 'wise', NULL, 't' ), ( 'lobby', NULL, NULL, NULL, NULL ), ( 3, REPEAT( 'X', 888 ), LOAD_FILE('/data/src/rqg/data/blobs/ru-7kb.txt'), NULL, NULL ), ( 8, 's', NULL, 3, NULL ); |
/* WRK-2 QNO 9218 */ CREATE OR REPLACE TABLE local_2_1 ( f1 VARCHAR ( 32 ) CHARACTER SET utf8 DEFAULT 'stbvclqnp', f2 VARCHAR ( 128 ) COLLATE utf8_bin NOT NULL DEFAULT 'tbvcl', f3 VARBINARY ( 128 ), f4 VARBINARY ( 128 ), f5 VARCHAR ( 32 ) DEFAULT 'bvclqnpwx', KEY ( f1 ( 1 ) ) USING BTREE ) ENGINE=HEAP ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 3072 SELECT * FROM local_2_5; |
--send
|
/* WRK-2 QNO 9233 */ SET STATEMENT lock_wait_timeout=10 FOR ANALYZE TABLE `advanced_db`.`t1_Aria` PERSISTENT FOR ALL; |
--connection con20_0
|
--send
|
/* WRK-3 QNO 9736 */ SET STATEMENT lock_wait_timeout=10 FOR ANALYZE TABLE `test`.`local_2_1`, `blobs_db`.`BB` PERSISTENT FOR ALL; |
--connection con19_0
|
--reap
|
--error 0,ER_LOCK_WAIT_TIMEOUT
|
/* WRK-2 QNO 9238 */ CREATE OR REPLACE TABLE local_2_1 ( f1 VARCHAR ( 32 ) COLLATE utf8_bin DEFAULT 'vclqnpwxqfru', f2 VARCHAR ( 128 ) CHARACTER SET utf8 DEFAULT 'clqnpwxqfruawlxjercfdnpsxepm', f3 VARCHAR ( 1024 ) NOT NULL DEFAULT 'lqnpwxqfruaw', f4 VARBINARY ( 128 ), f5 VARCHAR ( 512 ) COLLATE utf8_bin DEFAULT 'qnpwxqfrua', KEY ( f1, f2 ) USING BTREE ) ENGINE=HEAP ROW_FORMAT = DYNAMIC KEY_BLOCK_SIZE = 3072; |
--connection con20_0
|
--reap
|
SELECT * FROM local_2_1; |
|
10.11 d3afdd162bf8aecde785ccff0fd3dbe47e14923f |
SELECT * FROM local_2_1;
|
f1 f2 f3 f4 f5
|
Warnings:
|
Warning 4186 Failed to parse histogram for table test.local_2_1: Un-escape error at offset 544.
|
bug.690-19b [ 2 fail ] Found warnings/errors in server log file!
|
Test ended at 2026-08-01 17:07:34
|
line
|
2026-08-01 17:07:34 6 [ERROR] Failed to parse histogram for table test.local_2_1: Un-escape error at offset 544.
|