"drop table if exists t; create table t" via /cli hangs

[sanikolaev]

Bug Description:

MRE:

snikolaev@dev2:~$ sudo systemctl restart manticore
snikolaev@dev2:~$ time curl localhost:9308/cli -d 'drop table if exists t; create table t'
{"error":"file_get_contents(http://127.0.0.1:9312/sql?mode=raw): Failed to open stream: HTTP request failed!"}
real	1m0.069s
user	0m0.009s
sys	0m0.000s

Notes:

• Note, it hangs for exactly 1 minute
• 2nd/3rd run sometimes also hangs, but sometimes it's fast for a few consecutive runs. It seems that restarting the daemon helps it hang again.
• The same via /cli_json works fast:

   snikolaev@dev2:~$ time curl localhost:9308/cli_json -d 'drop table if exists t; create table t'
   {"error":"P03: syntax error, unexpected $undefined, expecting tablename or MODIFY near '; create table '"}
   real	0m0.010s
   user	0m0.008s
   sys	0m0.000s
  

Manticore Search Version:

Manticore 6.2.13 e12bc4f67@24050620 dev (columnar 2.2.5 0c18998@240424) (secondary 2.2.5 0c18998@240424) (knn 2.2.5 0c18998@240424)

Operating System Version:

Ubuntu Jammy (dev2)

Have you tried the latest development version?

• Yes

Internal Checklist:

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

• Task estimated
• Specification created, reviewed, and approved
• Implementation completed
• Tests developed
• Documentation updated
• Documentation proofread
• Changelog updated

[sanikolaev]

Blocked by #274 as it seems they have the same origin.

[sanikolaev]

The likely root cause is #274 (comment)

[Nick-S-2018]

Fixed in manticoresoftware/manticoresearch@bb40ff7

[sanikolaev]

Tests developed

Tests will be implemented within #274

[sanikolaev]

@Nick-S-2018 pls update the changelog https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1

[Nick-S-2018]

Done in manticoresoftware/manticoresearch@ccfc1a0

[sanikolaev]

@Nick-S-2018 pls update the changelog here https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1#gid=1102439133

[Nick-S-2018]

Done