manticoresearch
manticoresearch copied to clipboard
manticoresoftware
how to connet this HeidiSQL
Having the same problem here (HeidiSQL 12.5.0.6677).
The problem is the first query when HeidiSQL is connected, this is a incorrect query for manticore because it doesn't have a information_schema table:
SHOW TABLES FROM information_schema;
Gives error:
SQL Error (1064): P01: syntax error, unexpected FROM, expecting $end near 'FROM information_schema'
When runing this query manually: SHOW TABLES; There is a response, but that first query isn't configurable in HeidiSQL. So it would be nice if Manticore supports 'FROM `information_schema'
No information about this error is the searchd log
@nickbo90 please provide your searchd and query logs. The point is that Manticore provides support for HeidiSQL using Manticore Buddy which intercepts failed requests and mocks the result. So it's important that Manticore Buddy is working. It should be clear from the searchd log.
2023-11-05 14:52:54 (1.63 MB/s) - ‘/tmp/manticore-columnar-lib_2.2.4-230822-5aec342_amd64.deb’ saved [1641468/1641468]
Manticore 6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822) [Sun Nov 5 14:53:01.231 2023] [1] using config file '/etc/manticoresearch/manticore.conf' (9278 chars)... starting daemon version '6.2.12 dc5144d35@230822 (columnar 2.2.4 5aec342@230822) (secondary 2.2.4 5aec342@230822)' ... listening on all interfaces for mysql, port=9306 listening on UNIX socket /var/run/mysqld/mysqld.sock listening on 172.17.0.2:9312 for sphinx and http(s) listening on all interfaces for sphinx and http(s), port=9308 prereading 0 tables preread 0 tables in 0.000 sec accepting connections [BUDDY] started v1.0.18 '/usr/share/manticore/modules/manticore-buddy/bin/manticore-buddy --listen=http://172.17.0.2:9312 --threads=16' at http://127.0.0.1:45911 [BUDDY] Loaded plugins: [BUDDY] core: empty-string, backup, emulate-elastic, insert, select, show, cli-table, plugin, test, insert-mva [BUDDY] local: [BUDDY] extra: WARNING: conn 192.168.128.127:57390(10), sock=18: failed to receive MySQL request body, expected length 5522759, invalid size read 5519843(-1) WARNING: conn 192.168.128.127:57391(11), sock=19: failed to receive MySQL request body, expected length 5522759, invalid size read 5518667(-1) WARNING: conn 192.168.128.127:57401(12), sock=18: failed to receive MySQL request body, expected length 5522759, invalid size read 5518667(-1)
Fixed in https://github.com/manticoresoftware/buddy-plugin-select/pull/9 and in https://github.com/manticoresoftware/buddy-plugin-show/pull/3 https://github.com/manticoresoftware/buddy-plugin-show/pull/3
@Nick-S-2018 all the PRs didn't pass tests. Please fix or provide more info on that.
The test failure doesn't relate to the PRs made. It's been going on for a while and caused by an issue with Manticore response format in one of our tests. It seems the docker image we use for testing needs to be updated with the newest Manticore version.
It looks good for me, we can merge me. Only the point is CI tests, but probably we need to investigate it separately.
P.S. Do not forget to update versions in buddy main brain with new packages
Done in https://github.com/manticoresoftware/buddy-plugin-show/commit/b53428069c9064721e3534585733fef645ec8395 and in https://github.com/manticoresoftware/buddy-plugin-select/commit/103a049c942a786576cd45ce62dc4784d7cd1f73