search

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
8.93k stars 495 forks source link

🆕 Update buddy version #2585

Closed githubmanticore closed 2 days ago

githubmanticore commented 4 days ago

Update buddy version to: 2.3.13 24092608 8c4c46f which includes:

8c4c46f Update composer deps c716c81 Fix logic with HTTP request handling and finding queries for fuzzy search 7d530ca Fix duplicates in autocomplete response, empty query workaround and improve errors efbc816 Fix: multiple same suggestions when phrase differs in 1 char for different layouts af39b55 Handle fuzzy=0 case and simply proxy query as is cfa94f0 Fix both error messages for fuzzy & autocomplete cee12db Fix sharding queue repeat logic and return when query handling failed immediately 3c4f419 rolled back peer_timeout to default 3 second 9d56536 added cluster options to join statements for sharding; trying other cluster options to break wait loop earlier on join cluster 4769a52 Fixed the handling of queries from DbForge MySQL tool (#349) c7b9fb3 Fix issue with QueryProcessor test cuz we inject protected properties and did not expect it originally f197cae Update composer deps de4ab0b Refactor logic to make better to run "hooks" and improve logic in drop sharded table 37bb7b3 Add DROP SHARDED TABLE logic

github-actions[bot] commented 4 days ago

clt

👎 CLT tests in test/clt-tests/plugins/ ✅ OK: 0 ❌ Failed: 1 ⏳ Duration: 10s 👉 Check Action Results for commit 296c7e9 Failed tests:

test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– *************************** 1. row *************************** ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'show' is disabled + +------+---------------+----------+----------+-----------------+ + | id | query | time | protocol | host | + +------+---------------+----------+----------+-----------------+ + | 6 | select | 88us ago | http | 127.0.0.1:34088 | + | 8 | SHOW QUERIES | 1us | mysql | 127.0.0.1:51764 | + | 4 | show_settings | 17us | http | 127.0.0.1:34080 | + +------+---------------+----------+----------+-----------------+ ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– - *************************** 1. row *************************** + ERROR 1064 (42000) at line 1: Plugin 'show' is disabled ––– input ––– mysql -h0 -P9306 -e "create table t (id bigint, vector float_vector knn_type='hnsw' knn_dims='4' hnsw_similarity='l2')" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - + ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled + ```
github-actions[bot] commented 4 days ago

clt

👎 CLT tests in test/clt-tests/plugins/ ✅ OK: 0 ❌ Failed: 1 ⏳ Duration: 10s 👉 Check Action Results for commit a3fb76c Failed tests:

test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– *************************** 1. row *************************** ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'show' is disabled + +------+---------------+----------+----------+-----------------+ + | id | query | time | protocol | host | + +------+---------------+----------+----------+-----------------+ + | 6 | select | 74us ago | http | 127.0.0.1:41282 | + | 8 | SHOW QUERIES | 1us | mysql | 127.0.0.1:47204 | + | 4 | show_settings | 15us | http | 127.0.0.1:41268 | + +------+---------------+----------+----------+-----------------+ ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– - *************************** 1. row *************************** + ERROR 1064 (42000) at line 1: Plugin 'show' is disabled ––– input ––– mysql -h0 -P9306 -e "create table t (id bigint, vector float_vector knn_type='hnsw' knn_dims='4' hnsw_similarity='l2')" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - + ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled + ```
github-actions[bot] commented 3 days ago

clt

👎 CLT tests in test/clt-tests/plugins/ ✅ OK: 0 ❌ Failed: 1 ⏳ Duration: 9s 👉 Check Action Results for commit 622e7ec Failed tests:

test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– *************************** 1. row *************************** ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'show' is disabled + +------+---------------+----------+----------+-----------------+ + | id | query | time | protocol | host | + +------+---------------+----------+----------+-----------------+ + | 6 | select | 71us ago | http | 127.0.0.1:46932 | + | 8 | SHOW QUERIES | 2us | mysql | 127.0.0.1:44178 | + | 4 | show_settings | 18us | http | 127.0.0.1:46918 | + +------+---------------+----------+----------+-----------------+ ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– - *************************** 1. row *************************** + ERROR 1064 (42000) at line 1: Plugin 'show' is disabled ––– input ––– mysql -h0 -P9306 -e "create table t (id bigint, vector float_vector knn_type='hnsw' knn_dims='4' hnsw_similarity='l2')" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - + ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled + ```
sanikolaev commented 3 days ago

@PavelShilin89 It looks like the CLT tests should be adapted according to the new daemon+buddy behaviour introduced in this PR. Please look into it.

github-actions[bot] commented 3 days ago

clt

👎 CLT tests in test/clt-tests/plugins/ ✅ OK: 0 ❌ Failed: 1 ⏳ Duration: 10s 👉 Check Action Results for commit ceca37c Failed tests:

test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– *************************** 1. row *************************** ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'show' is disabled + +------+---------------+-----------+----------+-----------------+ + | id | query | time | protocol | host | + +------+---------------+-----------+----------+-----------------+ + | 6 | select | 111us ago | http | 127.0.0.1:36172 | + | 8 | SHOW QUERIES | 2us | mysql | 127.0.0.1:50598 | + | 4 | show_settings | 16us | http | 127.0.0.1:36164 | + +------+---------------+-----------+----------+-----------------+ ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– - *************************** 1. row *************************** + ERROR 1064 (42000) at line 1: Plugin 'show' is disabled ––– input ––– mysql -h0 -P9306 -e "create table t (id bigint, vector float_vector knn_type='hnsw' knn_dims='4' hnsw_similarity='l2')" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - + ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled + ```
github-actions[bot] commented 3 days ago

clt

👎 CLT tests in test/clt-tests/plugins/ ✅ OK: 0 ❌ Failed: 1 ⏳ Duration: 9s 👉 Check Action Results for commit 650e1a2 Failed tests:

test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– *************************** 1. row *************************** ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'show' is disabled + +------+---------------+----------+----------+-----------------+ + | id | query | time | protocol | host | + +------+---------------+----------+----------+-----------------+ + | 6 | select | 78us ago | http | 127.0.0.1:35312 | + | 8 | SHOW QUERIES | 2us | mysql | 127.0.0.1:56226 | + | 4 | show_settings | 17us | http | 127.0.0.1:35308 | + +------+---------------+----------+----------+-----------------+ ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-show" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SHOW QUERIES\G"|grep "1. row" ––– output ––– - *************************** 1. row *************************** + ERROR 1064 (42000) at line 1: Plugin 'show' is disabled ––– input ––– mysql -h0 -P9306 -e "create table t (id bigint, vector float_vector knn_type='hnsw' knn_dims='4' hnsw_similarity='l2')" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "DISABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled ––– input ––– mysql -h0 -P9306 -e "ENABLE BUDDY PLUGIN manticoresoftware/buddy-plugin-knn" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "select id, knn_dist() from t where knn ( image_vector, 5, 1 );" ––– output ––– - + ERROR 1064 (42000) at line 1: Plugin 'knn' is disabled + ```
github-actions[bot] commented 3 days ago

clt

👎 CLT tests in test/clt-tests/buddy/ ✅ OK: 1 ❌ Failed: 2 ⏳ Duration: 57s 👉 Check Action Results for commit 650e1a2 Failed tests:

test/clt-tests/buddy/test-fuzzy-search-negative.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– php -d memory_limit=-1 ./test/clt-tests/scripts/load_us_names_min_infix_len.php 1000 10 1000000 5 > /dev/null ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SELECT COUNT(*) FROM name;" ––– output ––– +----------+ | count(*) | +----------+ | 1000000 | +----------+ ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('RICH') OPTION fuzzy=-1;" ––– output ––– ERROR 1064 (42000) at line 1: P01: syntax error, unexpected '-' near '-1' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('SMITH') OPTION fuzzy='0';" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('SMYTH') OPTION fuzzy='2';" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('john') OPTION fuzzy=a;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('jane') OPTION fuzzy=@;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('j', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE(123, 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Something went wrong + ERROR 1064 (42000) at line 1: Failed to parse query ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Something went wrong + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('@#$', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('thisisaverylonginputstring', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'non_existing_table', 'us' AS layouts);" ––– output ––– ERROR 1064 (42000) at line 1: no such table 'non_existing_table' ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'name', 123 AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ```
test/clt-tests/buddy/test-fuzzy-search-non-min-infix-len.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "create table test (id bigint, value text);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Fuzzy search requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "ALTER TABLE test min_infix_len='2';" ––– output ––– ––– input ––– sleep 30; mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– ```
PavelShilin89 commented 3 days ago

@donhardman Note that commit 296c7e9 contains the changes that caused the error test/clt-tests/plugins/test-enable-disable-buddy-plugin.rec. Enabling and disabling the plugin stopped working.

github-actions[bot] commented 2 days ago

clt

👎 CLT tests in test/clt-tests/buddy/ ✅ OK: 1 ❌ Failed: 2 ⏳ Duration: 58s 👉 Check Action Results for commit d1341c6 Failed tests:

test/clt-tests/buddy/test-fuzzy-search-negative.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– php -d memory_limit=-1 ./test/clt-tests/scripts/load_us_names_min_infix_len.php 1000 10 1000000 5 > /dev/null ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SELECT COUNT(*) FROM name;" ––– output ––– +----------+ | count(*) | +----------+ | 1000000 | +----------+ ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('RICH') OPTION fuzzy=-1;" ––– output ––– ERROR 1064 (42000) at line 1: P01: syntax error, unexpected '-' near '-1' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('SMITH') OPTION fuzzy='0';" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('SMYTH') OPTION fuzzy='2';" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('john') OPTION fuzzy=a;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM name WHERE MATCH('jane') OPTION fuzzy=@;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Invalid value for option 'fuzzy' ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('j', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE(123, 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Something went wrong + ERROR 1064 (42000) at line 1: Failed to parse query ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Something went wrong + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('@#$', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('thisisaverylonginputstring', 'name', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'non_existing_table', 'us' AS layouts);" ––– output ––– ERROR 1064 (42000) at line 1: no such table 'non_existing_table' ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'name', 123 AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ```
test/clt-tests/buddy/test-fuzzy-search-non-min-infix-len.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "create table test (id bigint, value text);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Fuzzy search requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "ALTER TABLE test min_infix_len='2';" ––– output ––– ––– input ––– sleep 30; mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– ```
github-actions[bot] commented 2 days ago

clt

👎 CLT tests in test/clt-tests/buddy/ ✅ OK: 2 ❌ Failed: 1 ⏳ Duration: 57s 👉 Check Action Results for commit 904a8d9 Failed tests:

test/clt-tests/buddy/test-fuzzy-search-non-min-infix-len.rec ```diff ––– input ––– rm -f /var/log/manticore/searchd.log; searchd --stopwait > /dev/null; searchd; if timeout 10 grep -qm1 '\[BUDDY\] started' <(tail -n 1000 -f /var/log/manticore/searchd.log); then echo 'Buddy started!'; else echo 'Timeout or failed!'; cat /var/log/manticore/searchd.log;fi ––– output ––– Manticore %{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE}) Copyright (c) 2001-2016, Andrew Aksyonoff Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com) Copyright (c) 2017-%{YEAR}, Manticore Software LTD (https://manticoresearch.com) [#!/[0-9]{2}:[0-9]{2}.[0-9]{3}/!#] [#!/[0-9]+/!#] using config file '/etc/manticoresearch/manticore.conf' (%{NUMBER} chars)... starting daemon version '%{SEMVER} %{COMMITDATE}#!/(\sdev)?\s/!#(columnar %{SEMVER} %{COMMITDATE}) (secondary %{SEMVER} %{COMMITDATE}) (knn %{SEMVER} %{COMMITDATE})' ... listening on %{IPADDR}:9312 for sphinx and http(s) listening on %{IPADDR}:9306 for mysql listening on %{IPADDR}:9308 for sphinx and http(s) Buddy started! ––– input ––– mysql -h0 -P9306 -e "create table test (id bigint, value text);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– - ERROR 1064 (42000) at line 1: Autocomplete plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Autocomplete requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– - ERROR 1064 (42000) at line 1: Fuzzy plugin requires min_infix_len to be set + ERROR 1064 (42000) at line 1: Fuzzy search requires min_infix_len to be set ––– input ––– mysql -h0 -P9306 -e "ALTER TABLE test min_infix_len='2';" ––– output ––– ––– input ––– sleep 30; mysql -h0 -P9306 -e "CALL AUTOCOMPLETE('jo', 'test', 'us' AS layouts);" ––– output ––– ––– input ––– mysql -h0 -P9306 -e "SELECT * FROM test WHERE MATCH('RICH') OPTION fuzzy=1;" ––– output ––– ```