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
9.07k stars 509 forks source link

Unable to start 6.3.6 on Windows #2731

Closed GavinMcL closed 1 week ago

GavinMcL commented 2 weeks ago

Bug Description:

Hi

I can’t get 6.3.6 to start on Windows, it halts with the message

WARNING: GlobalCrashQueryGetRef: thread-local info is not set! Use ad-hoc

I am just using the example manticore.conf which is included in the install with the port numbers revised for my environment.

I haven’t installed executor as I don’t need it yet, I don’t have Docker installed. If I read the documentation correctly (and the forums) it isn't required. I have added buddy_path = # to the conf file.

searchd
{
    listen = 127.0.0.1:9637
    listen = 127.0.0.1:9636:mysql
    listen = 127.0.0.1:9638:http
    log = c:\opt\manticore-6.3.6/var/log/manticore/searchd.log
    query_log = c:\opt\manticore-6.3.6/var/log/manticore/query.log
    pid_file = c:\opt\manticore-6.3.6/var/run/manticore/searchd.pid
    data_dir = c:\opt\manticore-6.3.6/var/data
    query_log_format = sphinxql
    buddy_path = #
}

I’m trying to start it from an Administrator console and specifying full path to searchd and config;

> c:\opt\manticore-6.3.6\bin\searchd.exe --config c:\opt\manticore-6.3.6\etc\manticoresearch\manticore.conf
Manticore 6.3.6 593045790@24080214 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2024, Manticore Software LTD (https://manticoresearch.com)

[44:53.250] [21964] using config file 'c:/opt/manticore-6.3.6/etc/manticoresearch/manticore.conf' (403 chars)...
[44:53.253] [21964] WARNING: preopen_indexes=1 has no effect with seamless_rotate=0
starting daemon version '6.3.6 593045790@24080214 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206)' ...
listening on 127.0.0.1:9637 for sphinx and http(s)
listening on 127.0.0.1:9636 for mysql
listening on 127.0.0.1:9638 for sphinx and http(s)
binlog: replaying log c:\opt\manticore-6.3.6/var/data/binlog/binlog.001
WARNING: binlog: empty binlog c:\opt\manticore-6.3.6/var/data/binlog/binlog.001 detected, skipping
binlog: finished replaying total 1 in 0.000 sec
prereading 0 tables
preread 0 tables in 0.000 sec
WARNING: GlobalCrashQueryGetRef: thread-local info is not set! Use ad-hoc

Just to note that version 6.2.12 will start on Windows using the same steps above.

I've attached a zip with the binlog.meta, searchd.log and the mdmp generated. All other files generated were zero length.

regards Gavin windows-636-nostart.zip

Manticore Search Version:

Manticore 6.3.6 593045790@24080214

Operating System Version:

Windows 10 pro (10.0.19045)

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.

- [ ] Implementation completed - [ ] Tests developed - [ ] Documentation updated - [ ] Documentation reviewed - [ ] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated
tomatolog commented 2 weeks ago

could you add to your searchd section of the config?

searchd
{
buddy_path = #

and check that all starts well

GavinMcL commented 2 weeks ago

Hi

I already had buddy_path = # at the end of the searchd section of the config. I tried moving it to the top to be the first line on searchd section just in case, but no change, startup still fails with the same problem.

tomatolog commented 2 weeks ago

could you try recent package from the dev repository instead of the release?

GavinMcL commented 2 weeks ago

Hi

I forgot about the dev repo - thanks. I have tried 6.3.7 475f52e66@24110510 dev and that starts ok on Windows, and works ok with my config.

I noticed that SHOW TABLES now returns the index name column as Table where in 5.0.2 and 6.2.12 it returned as Index - is that a change that will continue?

tomatolog commented 2 weeks ago

yes index > table will be breaking change