Lost connection to MySQL server during query - manticore 6.0.5

[ricardopintottrdata]

ubuntu@manticorev2:~$ mysql -P9306 --protocol=tcp
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 6.0.5 45410e8@230509 dev (columnar 2.0.5 24e76dd@230422) (secondary 2.0.5 24e76dd@230422) git branch HEAD (no branch)

[ricardopintottrdata]

The query that gives the error:

mysql> SELECT *, WEIGHT() as weight FROM ericaentityes WHERE EntityFinancialDataID > 0 AND FinancialEUR.40100 >= 1 AND FinancialEUR.40100 <= 10 AND FinancialEUR.LastYearAvailable = 1 GROUP BY EntityID ORDER BY EntityName DESC LIMIT 0, 20 OPTION max_matches = 1000, max_matches = 1000000, accurate_aggregation = 0
-> ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:9306' (111)
ERROR:
Can't connect to the server

[barryhunter]

You should consult searchd.log.

It's highly likely it's logging something at the time of the crash

[sanikolaev]

Ricardo has provided his data and we've reproduced the crash.

[githubmanticore]

➤ Ilya Kuznetsov commented:

Fixed the crash in 6aa58d3