Unknown option 'fuzzy'

[StickKing]

Bug Description:

I am currently testing Manticore on a production project and noticed an issue similar to #395. Occasionally, I encounter the error "unknown option 'fuzzy'". Unfortunately, I haven't been able to identify a pattern for when it occurs — the server can run for a day or more without any issues, and then the error suddenly appears. I'm using plain mode tables loaded via xmlpipe and use only select queries.

Version:

manticore-buddy/bullseye               3.32.0+25070501-6af261a3 all

Logs:

DEBUG: -~-~-~-~-~-~-~-~ MT sched created -~-~-~-~-~-~-~-~
DEBUG: 0x55c9c693ca70 accepted mysql, sock=138, tick=1
DEBUG: 0x55c9c693ca70 accepted 1 connections all, tick=1
DEBUG: dlopen(libzstd.so.1)=0x7fd668001cf0
DEBUG: Sending handshake...
DEBUG: AsyncSend 97 bytes, sock=138
DEBUG: DiscardProcessed(0) iPos=0->0, iLen=0->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=0), timeout 899999987
DEBUG: got events=1, tick=2, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_ADD, sock=138
DEBUG: got events=1, tick=3, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 176 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 176, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=176->172, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 172 len...
DEBUG: HandshakeResponse41. PackedLen=172, hasBytes=140
DEBUG: User: root
DEBUG: 111 bytes of attrs
DEBUG: _os: Linux
DEBUG: _client_name: libmariadb
DEBUG: _pid: 11
DEBUG: _client_version: 3.1.29
DEBUG: _platform: x86_64
DEBUG: _server_host: dev.stand.com
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(172) iPos=172->0, iLen=172->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=4, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=5, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 22 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 22, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=22->18, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 18 len...
DEBUG: LoopClientMySQL command 3, 'SET NAMES utf8mb4'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(18) iPos=18->0, iLen=18->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=6, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=7, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 22 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 22, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=22->18, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 18 len...
DEBUG: LoopClientMySQL command 3, 'SET NAMES utf8mb4'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(18) iPos=18->0, iLen=18->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=8, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=9, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=10, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=11, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 152 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 152, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=152->148, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 148 len...
DEBUG: LoopClientMySQL command 3, 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1, layouts='fr,us''
DEBUG: P03: syntax error, unexpected tablename near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P02: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P04: syntax error, unexpected IDENT, expecting DEBUG near '(null)'
DEBUG: P05: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: unknown option 'fuzzy'
DEBUG: AsyncSend 35 bytes, sock=138
DEBUG: DiscardProcessed(148) iPos=148->0, iLen=148->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=12, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=13, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=14, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=15, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999983
DEBUG: got events=1, tick=16, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=17, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 152 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 152, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=152->148, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 148 len...
DEBUG: LoopClientMySQL command 3, 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1, layouts='fr,us''
DEBUG: P03: syntax error, unexpected tablename near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P02: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P04: syntax error, unexpected IDENT, expecting DEBUG near '(null)'
DEBUG: P05: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: unknown option 'fuzzy'
DEBUG: AsyncSend 35 bytes, sock=138
DEBUG: DiscardProcessed(148) iPos=148->0, iLen=148->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=18, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=19, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=20, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=21, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=22, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=23, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 152 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 152, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=152->148, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 148 len...
DEBUG: LoopClientMySQL command 3, 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1, layouts='fr,us''
DEBUG: P03: syntax error, unexpected tablename near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P02: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P04: syntax error, unexpected IDENT, expecting DEBUG near '(null)'
DEBUG: P05: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: unknown option 'fuzzy'
DEBUG: AsyncSend 35 bytes, sock=138
DEBUG: DiscardProcessed(148) iPos=148->0, iLen=148->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999988
DEBUG: got events=1, tick=24, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=25, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999985
DEBUG: got events=1, tick=26, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=27, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=28, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=29, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 152 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 152, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=152->148, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 148 len...
DEBUG: LoopClientMySQL command 3, 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1, layouts='fr,us''
DEBUG: P03: syntax error, unexpected tablename near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P02: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: P04: syntax error, unexpected IDENT, expecting DEBUG near '(null)'
DEBUG: P05: syntax error, unexpected identifier near 'SELECT count(*) AS count_1 
FROM table_name 
WHERE MATCH('search word') AND type IN (1, 2, 3, 8, 5, 6, 7, 9, 11, 12) OPTION fuzzy=1'
DEBUG: unknown option 'fuzzy'
DEBUG: AsyncSend 35 bytes, sock=138
DEBUG: DiscardProcessed(148) iPos=148->0, iLen=148->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=30, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=31, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999989
DEBUG: got events=1, tick=32, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138
DEBUG: got events=1, tick=33, interrupted=0
DEBUG: EngageWaiterAndYield awake (m_iSock=138, events=1)
DEBUG: AsyncRecvNBChunk 13 when read 4096 bytes, sock=138
DEBUG: SyncSockRead: AsyncRecvNBChunk returned 13, sock=138
DEBUG: DiscardProcessed(4) iPos=4->0, iLen=13->9, sock=138
DEBUG: AsyncReadMySQLPacketHeader returned 9 len...
DEBUG: LoopClientMySQL command 3, 'ROLLBACK'
DEBUG: AsyncSend 11 bytes, sock=138
DEBUG: DiscardProcessed(9) iPos=9->0, iLen=9->0, sock=138
DEBUG: Receiving command... 0 bytes in buf
DEBUG: AsyncRecvNBChunk -1 when read 4096 bytes, sock=138
DEBUG: AsyncRecvNBChunk -1 bytes (4 requested), sock=138
DEBUG: Still need to receive 4 bytes, sock=138
DEBUG: Coro::YieldWith (m_iEvent=1), timeout 899999985
DEBUG: got events=1, tick=34, interrupted=0
DEBUG: 0x7fd654000c70 epoll 132 setup, ev=0x3221225473, op=EPOLL_CTL_MOD, sock=138

Manticore Search Version:

Manticore 13.2.3 bf96368a6@25070806 (columnar 8.0.0 1f68681@25070110) (secondary 8.0.0 1f68681@25070110) (knn 8.0.0 1f68681@25070110) (embeddings 1.0.0)

Operating System Version:

Debian GNU/Linux 11 (bullseye) (docker container)

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.}

Details

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed

[sanikolaev]

Hi @StickKing

If you mean:

DEBUG: unknown option 'fuzzy'

That's normal in DEBUG mode. For example:

mysql -P9306 -h0 -e "drop table if exists t; create table t(f text) min_infix_len='2';
set global log_level=debug;
SELECT * from t where match('abc') option fuzzy=1;
set global log_level=info;"
tail /opt/homebrew/var/log/manticore/searchd.log
[Tue Aug  5 07:08:40.782 2025] [105679569] [BUDDY] [6891adf8bb2d14.05963376] response data: {"version":3,"type":"sql response","message":[{"total":0,"error":"","warning":"","columns":[{"id":{"type":"long long"}},{"f":{"type":"string"}}],"data":[]}],"meta":{"total":"0","total_found":"0","total_relation":"eq","time":"0.002"},"error_code":200}
[Tue Aug  5 07:08:40.782 2025] [105679569] [BUDDY] [6891adf8bb2d14.05963376] response time: 1.35 ms
[Tue Aug  5 07:09:02.680 2025] [105679560] DEBUG: unknown option 'fuzzy'
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] [6891ae0ea612d6.60508574] request data: {"type":"unknown sql request","error":{"message":"unknown option 'fuzzy'","body":null},"version":3,"user":"sn","message":{"path_query":"","body":"SELECT * from t where match('abc') option fuzzy=1","http_method":""}}
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] [6891ae0ea612d6.60508574] Plugin: Fuzzy
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] [6891ae0ea612d6.60508574] Fuzzy payload: {"path":"","table":"t","fuzzy":true,"distance":2,"layouts":[],"preserve":false,"payload":"SELECT * from t where match('abc') option fuzzy=1","queries":[]}
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] Fuzzy: variations for 'abc': [{"original":"abc","keywords":[]}]
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] Fuzzy: match: (abc^50)
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] [6891ae0ea612d6.60508574] response data: {"version":3,"type":"sql response","message":[{"total":0,"error":"","warning":"","columns":[{"id":{"type":"long long"}},{"f":{"type":"string"}}],"data":[]}],"meta":{"total":"0","total_found":"0","total_relation":"eq","time":"0.000"},"error_code":200}
[Tue Aug  5 07:09:02.681 2025] [105679565] [BUDDY] [6891ae0ea612d6.60508574] response time: 0.629 ms

You won’t see that log line if you’re not in DEBUG mode. For example:

mysql -P9306 -h0 -e "drop table if exists t; create table t(f text) min_infix_len='2';
set global log_level=info;
SELECT * from t where match('abc') option fuzzy=1"
tail /opt/homebrew/var/log/manticore/searchd.log

This won’t show anything related in the log.

If you're seeing unknown option 'fuzzy' as the actual response to a query (not just in the logs), please share the full query where that happens.

[StickKing]

Hi @sanikolaev. I’m running Manticore not in debug mode. I used the --logdebugv flag for clarity. This error is returned when executing a query (I’m using the SQLAlchemy dialect to work with Manticore):

[sanikolaev]

What's in the searchd log at the time you get this error?

[StickKing]

Sorry, that's all I have (I'm using the searchd --nodetach command). I'll try to get more logs.

[StickKing]

logs
manticore_logs.zip