[MDEV-12536] mysqld restarts while adding index to incorrect CSV row Created: 2017-04-20  Updated: 2017-04-20

Status: Confirmed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.1.22
Fix Version/s: 10.1

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Olivier Bertrand
Resolution: Unresolved Votes: 0
Labels: None

Attachments: HTML File res    

 Description   

Mysqld exits without anything in error log when trying to alter CSV table, which has incorrect row. Example of file is just a single line "fdag afdg dfg"

MariaDB [test]> show create table test2\G
*************************** 1. row ***************************
       Table: test2
Create Table: CREATE TABLE `test2` (
  `num` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL
) ENGINE=CONNECT DEFAULT CHARSET=latin1 `table_type`=CSV `file_name`='/t/qq1' `sep_char`=';'
1 row in set (0.01 sec)
 
MariaDB [test]> \! cat /t/qq1
fdag afdg dfgMariaDB [test]> 
MariaDB [test]> alter table test2 add index(num);
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [test]> 

Thread 1 (Thread 0x7ffa6fbdeb00 (LWP 23991)):
#0  __longjmp () at ../sysdeps/x86_64/__longjmp.S:67
#1  0x24414d072e092f80 in ?? ()
Backtrace stopped: Cannot access memory at address 0x24414d072e092f80


Generated at Thu Feb 08 07:58:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.