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
9.08k stars 510 forks source link

Crash on ALTER ... add column ... text #2708

Closed sanikolaev closed 1 week ago

sanikolaev commented 3 weeks ago

Bug Description:

mysql> drop table if exists t; create table t; insert into t values(1); flush ramchunk t; alter table t add column f2 text;
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.03 sec)

--------------
create table t
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
insert into t values(1)
--------------

Query OK, 1 row affected (0.00 sec)

--------------
flush ramchunk t
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
alter table t add column f2 text
--------------

ERROR 2013 (HY000): Lost connection to MySQL server during query

Notes:

Manticore Search Version:

Manticore 6.3.7 9987798ac@24101806 dev (columnar 2.3.1 30ad2d6@24100914) (secondary 2.3.1 30ad2d6@24100914) (knn 2.3.1 30ad2d6@24100914)

Operating System Version:

Ubuntu Jammy (dev2)

Have you tried the latest development version?

No

Internal Checklist:

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

- [x] Implementation completed - [x] Tests developed - [x] Documentation updated - [x] Documentation reviewed - [x] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated
sanikolaev commented 1 week ago

Fixed in https://github.com/manticoresoftware/manticoresearch/commit/e79daf05f8149f3b4795062f53284d8a6eccaea5