manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
8.9k stars 493 forks source link

Crash with signal 11 when executing alter table command #2291

Open anStalf opened 3 months ago

anStalf commented 3 months ago

Bug Description:

Next command sequence executing crash: Start new container

docker run -e EXTRA=1 --rm -d --name manticore -p 9306:9306 manticoresearch/manticore:latest;

Wait strating

mysql -h0 -P9306

Execute some commands:

create table demo (info string, value integer);
insert into demo (info, value) values ('test 1 [DEM]', 1), ('test 2 [TES]', 2);
show table demo settings;
desc demo;
select * from demo where match('test');
create table demo_2 like demo with data;
show tables;
desc demo_2;
select * from demo_2;

Next command will kill container

alter table demo_2 modify column info text;

with next message: Снимок экрана 2024-06-06 в 18 50 22

Manticore Search Version:

6.3.0

Operating System Version:

Mac + Docker:Latest

Have you tried the latest development version?

None

Internal Checklist:

To be completed by the assignee. Check off tasks that have been completed or are not applicable.

- [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] Changelog updated
klirichek commented 2 days ago

MRE

create table demo (info string);
insert into demo (info) values ('test 1 [DEM]');
flush ramchunk demo;
alter table demo modify column info text;
klirichek commented 2 days ago

without 'flush ramchunk' example above produces also impossible combo of flags:

mysql> alter table demo modify column info text;
Query OK, 0 rows affected (0,01 sec)

mysql> desc demo;
+-------+--------+--------------------------+
| Field | Type   | Properties               |
+-------+--------+--------------------------+
| id    | bigint |                          |
| info  | string | indexed stored attribute |
+-------+--------+--------------------------+
2 rows in set (0,00 sec)