[MDEV-17909] Problem by MariaDB Update 10.1.32 -> 10.2.19 (Incorrect information in file: .frm) Created: 2018-12-05  Updated: 2018-12-20  Resolved: 2018-12-20

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Virtual Columns
Affects Version/s: 10.2, 10.3
Fix Version/s: 10.2.20, 10.3.12

Type: Bug Priority: Major
Reporter: Andrei Iulian Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Attachments: File 1.sql     File my.ini     File mypc.err     Text File mysql_upgrade.exe logs.txt     Text File mysql_upgrade_service.MySQL.log     File tbl01.tar.gz    
Issue Links:
Relates
relates to MDEV-17199 Assertion `pos < table->n_v_def' fail... Closed

 Description   

Hi,

I tried a MariaDB update 10.1.32 -> 10.2.19
My data was after that not available any more in the database (mysqld.exe: Incorrect information in file: '.\tst01\tbl01.frm')
I use many databases with tables with virtual columns and subpartitions.

Environment: WIN 10

.err file: attached
mypc.err
my.ini: attached
my.ini
Test Case: sql file to create a database in version 10.1.32 and some Inserts are attached (my.ini also) 1.sql
I update this to version 10.2.19 - at the end mysql_upgrade_service was without a error (mysql_upgrade_service.MySQL.log attached)
mysql_upgrade_service.MySQL.log
The .err file contains already some warnings

[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

After starting the database, I cannot see the data in the table any more.

Also if I try mysql_upgrade.exe I will get some errors (mysql_upgrade.exe logs.txt) but the data is still not available
mysql_upgrade.exe logs.txt



 Comments   
Comment by Elena Stepanova [ 2018-12-07 ]

Thanks for the report.

Here is the essential part of the original table:

DROP TABLE IF EXISTS tbl01;
 
CREATE TABLE `tbl01` (
 
	`Date` DATETIME(6) NOT NULL,
 
	`Data` VARBINARY(2000) NOT NULL,
 
	`a` VARCHAR(100) AS (COLUMN_GET(`Data`,1 AS CHAR(100))) VIRTUAL,
 
	PRIMARY KEY (`Date`)
 
)
 
/*!50100 PARTITION BY RANGE (TO_DAYS(`Date`))
 
(PARTITION p20181029 VALUES LESS THAN (737361) ENGINE = MyISAM,
 
 PARTITION p20181128 VALUES LESS THAN (737391) ENGINE = MyISAM)  */;

Reproducible as described (create the table on an old server => start new server => run mysql_upgrade => restart => attempt to use), or by just running the following on the new server:

CHECK TABLE `tbl01`  FOR UPGRADE;
 
FLUSH TABLES;
 
SHOW CREATE TABLE tbl01;

10.2 5ec9b88e1 debug

 
mysqld: /data/src/10.2/sql/table.cc:2937: Virtual_column_info* unpack_vcol_info_from_frm(THD*, MEM_ROOT*, TABLE*, String*, Virtual_column_info**, bool*): Assertion `vcol->expr == __null' failed.
 
181207 16:13:53 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f86d0d3eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x000055ac6a5e8d8c in unpack_vcol_info_from_frm (thd=0x7f8668000b00, mem_root=0x7f8668022b58, table=0x7f86680220a0, expr_str=0x7f86d0197130, vcol_ptr=0x7f8668022150, error_reported=0x7f86d01974b1) at /data/src/10.2/sql/table.cc:2937
 
#9  0x000055ac6a5e268e in parse_vcol_defs (thd=0x7f8668000b00, mem_root=0x7f8668022b58, table=0x7f86680220a0, error_reported=0x7f86d01974b1) at /data/src/10.2/sql/table.cc:1070
 
#10 0x000055ac6a5e9c09 in open_table_from_share (thd=0x7f8668000b00, share=0x7f866801d248, alias=0x7f8668011048 "tbl01", db_stat=33, prgflag=8, ha_open_flags=16, outparam=0x7f86680220a0, is_create_table=false) at /data/src/10.2/sql/table.cc:3202
 
#11 0x000055ac6a4715c1 in open_table (thd=0x7f8668000b00, table_list=0x7f8668011050, ot_ctx=0x7f86d0197a00) at /data/src/10.2/sql/sql_base.cc:1923
 
#12 0x000055ac6a4741a5 in open_and_process_table (thd=0x7f8668000b00, lex=0x7f8668004618, tables=0x7f8668011050, counter=0x7f86d0197ad4, flags=1024, prelocking_strategy=0x7f86d0197a80, has_prelocking_list=false, ot_ctx=0x7f86d0197a00) at /data/src/10.2/sql/sql_base.cc:3488
 
#13 0x000055ac6a475305 in open_tables (thd=0x7f8668000b00, options=..., start=0x7f86d0197ac0, counter=0x7f86d0197ad4, flags=1024, prelocking_strategy=0x7f86d0197a80) at /data/src/10.2/sql/sql_base.cc:4011
 
#14 0x000055ac6a4bc711 in open_tables (thd=0x7f8668000b00, tables=0x7f86d0197ac0, counter=0x7f86d0197ad4, flags=1024) at /data/src/10.2/sql/sql_base.h:475
 
#15 0x000055ac6a576006 in mysqld_show_create_get_fields (thd=0x7f8668000b00, table_list=0x7f8668011050, field_list=0x7f86d0197d90, buffer=0x7f86d0197db0) at /data/src/10.2/sql/sql_show.cc:1229
 
#16 0x000055ac6a5766e2 in mysqld_show_create (thd=0x7f8668000b00, table_list=0x7f8668011050) at /data/src/10.2/sql/sql_show.cc:1324
 
#17 0x000055ac6a4e6307 in mysql_execute_command (thd=0x7f8668000b00) at /data/src/10.2/sql/sql_parse.cc:4243
 
#18 0x000055ac6a4f21bd in mysql_parse (thd=0x7f8668000b00, rawbuf=0x7f8668010f78 "show create table tbl01", length=23, parser_state=0x7f86d0199250, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8013
 
#19 0x000055ac6a4dfaf5 in dispatch_command (command=COM_QUERY, thd=0x7f8668000b00, packet=0x7f86680191a1 "show create table tbl01", packet_length=23, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
 
#20 0x000055ac6a4de458 in do_command (thd=0x7f8668000b00) at /data/src/10.2/sql/sql_parse.cc:1378
 
#21 0x000055ac6a630bc9 in do_handle_one_connection (connect=0x55ac6e570800) at /data/src/10.2/sql/sql_connect.cc:1335
 
#22 0x000055ac6a630956 in handle_one_connection (arg=0x55ac6e570800) at /data/src/10.2/sql/sql_connect.cc:1241
 
#23 0x00007f86d27fa494 in start_thread (arg=0x7f86d019a700) at pthread_create.c:333
 
#24 0x00007f86d0dfb93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

10.2 5ec9b88e1 non-debug

 
MariaDB [test]> show create table tbl01;
 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

10.3 b6f203984b debug

 
#3  <signal handler called>
 
#4  0x0000558b826425ab in unpack_vcol_info_from_frm (thd=0x7faef4000b00, mem_root=0x7faef4025528, table=0x7faef4024a60, expr_str=0x7faf4d17c980, vcol_ptr=0x7faef4026f31, error_reported=0x7faf4d17cd01) at /data/src/10.3/sql/table.cc:3045
 
#5  0x0000558b8263b6ff in parse_vcol_defs (thd=0x7faef4000b00, mem_root=0x7faef4025528, table=0x7faef4024a60, error_reported=0x7faf4d17cd01) at /data/src/10.3/sql/table.cc:1072
 
#6  0x0000558b826435d6 in open_table_from_share (thd=0x7faef4000b00, share=0x7faef40200a8, alias=0x7faef4013928, db_stat=33, prgflag=8, ha_open_flags=16, outparam=0x7faef4024a60, is_create_table=false, partitions_to_open=0x0) at /data/src/10.3/sql/table.cc:3336
 
#7  0x0000558b8249f0c9 in open_table (thd=0x7faef4000b00, table_list=0x7faef40138e0, ot_ctx=0x7faf4d17d260) at /data/src/10.3/sql/sql_base.cc:1975
 
#8  0x0000558b824a2116 in open_and_process_table (thd=0x7faef4000b00, lex=0x7faef40048e8, tables=0x7faef40138e0, counter=0x7faf4d17d334, flags=1024, prelocking_strategy=0x7faf4d17d2e0, has_prelocking_list=false, ot_ctx=0x7faf4d17d260) at /data/src/10.3/sql/sql_base.cc:3596
 
#9  0x0000558b824a3312 in open_tables (thd=0x7faef4000b00, options=..., start=0x7faf4d17d320, counter=0x7faf4d17d334, flags=1024, prelocking_strategy=0x7faf4d17d2e0) at /data/src/10.3/sql/sql_base.cc:4121
 
#10 0x0000558b824ee3c3 in open_tables (thd=0x7faef4000b00, tables=0x7faf4d17d320, counter=0x7faf4d17d334, flags=1024) at /data/src/10.3/sql/sql_base.h:471
 
#11 0x0000558b825c631d in mysqld_show_create_get_fields (thd=0x7faef4000b00, table_list=0x7faef40138e0, field_list=0x7faf4d17d5f0, buffer=0x7faf4d17d610) at /data/src/10.3/sql/sql_show.cc:1261
 
#12 0x0000558b825c6ab3 in mysqld_show_create (thd=0x7faef4000b00, table_list=0x7faef40138e0) at /data/src/10.3/sql/sql_show.cc:1366
 
#13 0x0000558b82531fef in mysql_execute_command (thd=0x7faef4000b00) at /data/src/10.3/sql/sql_parse.cc:4532
 
#14 0x0000558b8253d7cb in mysql_parse (thd=0x7faef4000b00, rawbuf=0x7faef4013808 "show create table tbl01", length=23, parser_state=0x7faf4d17f640, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
 
#15 0x0000558b8252a97f in dispatch_command (command=COM_QUERY, thd=0x7faef4000b00, packet=0x7faef401ba31 "show create table tbl01", packet_length=23, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1850
 
#16 0x0000558b825293a3 in do_command (thd=0x7faef4000b00) at /data/src/10.3/sql/sql_parse.cc:1395
 
#17 0x0000558b826910ba in do_handle_one_connection (connect=0x558b865397f0) at /data/src/10.3/sql/sql_connect.cc:1402
 
#18 0x0000558b82690e3e in handle_one_connection (arg=0x558b865397f0) at /data/src/10.3/sql/sql_connect.cc:1308
 
#19 0x00007faf66420494 in start_thread (arg=0x7faf4d180700) at pthread_create.c:333
 
#20 0x00007faf64a2193f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Might be related to MDEV-17199.
The table created on current 10.1 (pre-10.1.38, 328d7779b) is attached. I have changed it to MyISAM for simplicity, it is not important for the issue.

Generated at Thu Feb 08 08:40:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.