Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40583

[Draft] Failed to parse histogram for table ...: Un-escape error at offset ...

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Trivial
    • Resolution: Unresolved
    • 10.11, 11.4, 11.8, 12.3, 13.0
    • N/A
    • Admin statements
    • 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.
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.