Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

cannot connect to manticore mysql instance #2829

Open
2 of 4 tasks
Chaitanyspace opened this issue Dec 9, 2024 · 8 comments
Open
2 of 4 tasks

cannot connect to manticore mysql instance #2829

Chaitanyspace opened this issue Dec 9, 2024 · 8 comments
Labels
waiting Waiting for the original poster (in most cases) or something else

Comments

@Chaitanyspace
Copy link

Confirmation Checklist:

  • You have searched for an answer in the manual.
  • You have considered using the forum for general discussions, which can be more suitable for non-urgent or broad queries.
  • You are aware of our community support channels on Slack, Telegram EN, and Telegram RU, where you can interact with other users and our developers.
  • You know about Manticore Team's professional services. Engaging with our experts through a support subscription can significantly accelerate resolution times and provide tailored solutions to your specific needs.

Your question:

image
this is what im facing i started the docker on the port
@sanikolaev
Copy link
Collaborator

Hi. How did you run the container? It seems to me not the mysql listener is listening on port 3896.

@Chaitanyspace
Copy link
Author

docker run -e EXTRA=1 -d --name manticore_container -p 3896:3896 manticoresearch/manticore

@sanikolaev
Copy link
Collaborator

Manticore doesn't listen on port 3896 by default.

@sanikolaev sanikolaev added the waiting Waiting for the original poster (in most cases) or something else label Dec 10, 2024
@Chaitanyspace
Copy link
Author

i tried this as well
docker run --privileged -e EXTRA=1 --name manticore -v /etc/manticoresearch/manticore.conf:/etc/manticoresearch/manticore.conf -v /mnt/data/:/var/lib/manticore -p 127.0.0.1:9366:9306 -d manticoresearch/manticore

but shows this logs
root@cp [/var/run/manticore]# docker logs manticore
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 08:34:58.215 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 08:34:58.217 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded
caught SIGTERM, shutting down
shutdown daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
shutdown complete
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 08:50:25.448 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 08:50:25.450 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded
caught SIGTERM, shutting down
shutdown daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
shutdown complete
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 09:15:41.966 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 09:15:41.970 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded
root@cp [/var/run/manticore]# docker logs manticore
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 08:34:58.215 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 08:34:58.217 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded
caught SIGTERM, shutting down
shutdown daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
shutdown complete
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 08:50:25.448 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 08:50:25.450 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded
caught SIGTERM, shutting down
shutdown daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
shutdown complete
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)
[Tue Dec 10 09:15:41.966 2024] [1] using config file '/etc/manticoresearch/manticore.conf.sh' (20359 chars)...
[Tue Dec 10 09:15:41.970 2024] [1] TCP fast open unavailable (can't read /proc/sys/net/ipv4/tcp_fastopen, look Server_settings/Searchd#Technical-details-about-Sphinx-API-protocol-and-TFO in manual)
starting daemon version '6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)' ...
listening on all interfaces for sphinx and http(s), port=9312
listening on all interfaces for mysql, port=9306
listening on all interfaces for sphinx and http(s), port=9308
Manticore 6.3.8 d17bd2b6b@24112202 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 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)

precaching table 'big_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big.sph: No such file or directory
WARNING: table 'big_main': prealloc: failed to open /var/lib/manticore/big.sph: No such file or directory - NOT SERVING
precaching table 'big_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/big_delta.sph: No such file or directory
WARNING: table 'big_delta': prealloc: failed to open /var/lib/manticore/big_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'big': no such local table 'big_main', SKIPPED
WARNING: table 'big': table 'big': no such local table 'big_main' - NOT SERVING
precaching table 'piskei_main'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei.sph: No such file or directory
WARNING: table 'piskei_main': prealloc: failed to open /var/lib/manticore/piskei.sph: No such file or directory - NOT SERVING
precaching table 'piskei_delta'
Index header format is not json, will try it as binary...
WARNING: Unable to load header... Error failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory
WARNING: table 'piskei_delta': prealloc: failed to open /var/lib/manticore/piskei_delta.sph: No such file or directory - NOT SERVING
WARNING: table 'piskei': no such local table 'piskei_main', SKIPPED
WARNING: table 'piskei': table 'piskei': no such local table 'piskei_main' - NOT SERVING
prereading 0 tables
preread 0 tables in 0.000 sec
accepting connections
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restarting
WARNING: [BUDDY] invalid output, should be 'Buddy ver, started address:port', got 'Error while initialization: mkdir(): Permission denied
'
[BUDDY] restart amount of attempts (3) has been exceeded

@sanikolaev
Copy link
Collaborator

Pls share your config file you map to the container and "ls -la /mnt/data".

@Chaitanyspace
Copy link
Author

Chaitanyspace commented Dec 15, 2024 •
edited
Loading

@sanikolaev
its resolved,im able to connect to the manticore
command used to connect to the manticore instance running inside docker container on to the host machine
docker run --hostname=$(hostname) --mac-address=$(ip link show eth0 | awk '/ether/ {print $2}') --env="extra=1" --env="PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" --env="LANG=C.UTF-8" --env="LC_ALL=C.UTF-8" --env="MANTICORE_CONFIG=/etc/manticoresearch/manticore.conf.sh|/etc/manticoresearch/manticore.conf" --volume=/usr/local/lib/manticore:/usr/local/lib/manticore --volume=/var/lib/manticore:/var/lib/manticore --network=bridge --workdir=/var/lib/manticore -p 1786:9306 --runtime=runc -d manticoresearch/manticore:dev

issue im getting

root@cp [~]# docker exec -it peaceful_banach indexer --rotate --all
Manticore 6.3.9 4abb05606@24121317 dev
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)

using config file '/etc/manticoresearch/manticore.conf'...
indexing table 'big_main'...
ERROR: table 'big_main': sql_query_pre[1]: P01: syntax error, unexpected SELECT, expecting VALUES near 'SELECT 'rjl84uds2_piskei1_shalom', MAX(id) FROM rjl84uds2_piskei1_shalom' (DSN=mysql://test:@localhost:3306/test).
total 0 docs, 0 bytes
total 0.017 sec, 0 bytes/sec, 0.00 docs/sec
indexing table 'big_delta'...
ERROR: table 'big_delta': sql_query: P01: syntax error, unexpected '(' near '(SELECT max_doc_id FROM sph_counter WHERE counter_table='rjl84uds2_piskei1_shalom' LIMIT 1)' (DSN=mysql://test:@localhost:3306/test).
total 0 docs, 0 bytes
total 0.001 sec, 0 bytes/sec, 0.00 docs/sec
WARNING: skipping non-plain table 'big'...
indexing table 'piskei_main'...
ERROR: table 'piskei_main': sql_query_pre[1]: P01: syntax error, unexpected SELECT, expecting VALUES near 'SELECT 'rjl84uds2_piskei7', MAX(id) FROM rjl84uds2_piskei7' (DSN=mysql://test:@localhost:3306/test).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing table 'piskei_delta'...
ERROR: table 'piskei_delta': sql_query: P01: syntax error, unexpected '(' near '(SELECT max_doc_id FROM sph_counter WHERE counter_table='rjl84uds2_piskei7' LIMIT 1)' (DSN=mysql://test:@localhost:3306/test).
total 0 docs, 0 bytes
total 0.001 sec, 0 bytes/sec, 0.00 docs/sec
WARNING: skipping non-plain table 'piskei'...
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
root@cp [~]# docker exec -it peaceful_banach /bin/bash
root@cp:/var/lib/manticore# nano /etc/manticoresearch/manticore.conf
root@cp:/var/lib/manticore#

manticore conf file attached
manticore.conf.txt

@Chaitanyspace
Copy link
Author

Chaitanyspace commented Dec 15, 2024 •
edited
Loading

@sanikolaev
also one more question i had
my one manticore is running on host with 9306 ports without docker env
and other one manticore instance is running on 1244 inside docker
what i want to do is i want to insert or data from big table from 9306 manticore to the 1244 manticore instance tried this one with the python client of manticore total records are 1500002 the process gets killed
attaching the python script as well

and thanks a lot for the active support !!!
test.py.txt

@sanikolaev
Copy link
Collaborator

total records are 1500002 the process gets killed

Check in the logs. It could be OOM or smth.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
waiting Waiting for the original poster (in most cases) or something else
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@sanikolaev @Chaitanyspace