Hi there,
Iam not able to login into manticore using the command mysql -h0 -P 9306.
manticore version : 4.2
does it happens right after daemon start or daemon works for some time?
could you provide searchd.log with the daemon startup commands?
Hi there
this is the status of the deamon
[root@test1~]# searchd --status
Manticore 4.2.0 15e927b@211223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2021, Manticore Software LTD (https://manticoresearch.com)
[42:52.622] [29124] using config file '/etc/manticoresearch/manticore.conf' (74658116 chars)...
[42:53.911] [29124] FATAL: failed to connect to daemon: please specify listen with sphinx protocol in your config file
[root@test1 ~]#
Searchd log
[root@test1 ~]# sudo tail -f /var/log/manticore/searchd.log
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11102': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11102.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11276': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11276.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11804': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11804.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: finished replaying total 1 in 0.000 sec
[Wed Aug 9 10:08:26.461 2023] [27556] accepting connections
[Wed Aug 9 10:08:26.465 2023] [27562] prereading 12121 indexes
[Wed Aug 9 10:08:44.001 2023] [27562] prereaded 12121 indexes in 17.540 sec
manticore status
[root@test1]# systemctl status manticore
● manticore.service - Manticore Search Engine
Loaded: loaded (/run/systemd/generator.early/manticore.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2023-08-09 10:08:26 IST; 3h 57min ago
Main PID: 27556 (searchd)
CGroup: /system.slice/manticore.service
├─27554 /usr/bin/searchd --config /etc/manticoresearch/manticore.conf
└─27556 /usr/bin/searchd --config /etc/manticoresearch/manticore.conf
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2912'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2913'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2914'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2915'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2916'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2917'
Aug 09 10:08:16 irl-d2r-prod-manticore-version4-node4 searchd[27551]: precaching index 'idx_storeid_2918'
Aug 09 10:08:26 irl-d2r-prod-manticore-version4-node4 systemd[1]: manticore.service: Supervising process 27556 which is not our child. We'll most likely no... exits.
Aug 09 10:08:26 irl-d2r-prod-manticore-version4-node4 systemd[1]: Started Manticore Search Engine.
Aug 09 10:54:28 irl-d2r-prod-manticore-version4-node4 systemd[1]: manticore.service: Supervising process 27556 which is not our child. We'll most likely no... exits.
Hint: Some lines were ellipsized, use -l to show in full.
Can anyone check this …
does this happens right after daemon start or daemon works for some time then connection disappear?
could you provide FULL searchd.log where ALL daemon startup events shown?
Hi there ,
Seems like this is happening right after the daemon starts
below is the searchd.log
[Wed Aug 9 03:30:46.048 2023] [25125] rotating index 'idx_storeid_10081': success
[Wed Aug 9 03:30:46.080 2023] [25125] rotating index 'idx_storeid_10086': success
[Wed Aug 9 03:30:46.108 2023] [25125] rotating index 'idx_storeid_10088': success
[Wed Aug 9 03:30:46.141 2023] [25125] rotating index 'idx_storeid_10096': success
[Wed Aug 9 03:30:46.173 2023] [25125] rotating index 'idx_storeid_10101': success
[Wed Aug 9 03:30:46.205 2023] [25125] rotating index 'idx_storeid_10106': success
[Wed Aug 9 03:30:46.238 2023] [25125] rotating index 'idx_storeid_10110': success
[Wed Aug 9 03:30:46.278 2023] [25125] rotating index 'idx_storeid_10121': success
[Wed Aug 9 03:30:46.306 2023] [25125] rotating index 'idx_storeid_10123': success
[Wed Aug 9 03:30:46.346 2023] [25125] rotating index 'idx_storeid_10134': success
[Wed Aug 9 03:30:46.376 2023] [25125] rotating index 'idx_storeid_10138': success
[Wed Aug 9 03:30:46.421 2023] [25125] rotating index 'idx_storeid_10155': success
[Wed Aug 9 03:30:46.461 2023] [25125] rotating index 'idx_storeid_10163': success
[Wed Aug 9 03:30:46.490 2023] [25125] rotating index 'idx_storeid_10165': success
[Wed Aug 9 03:30:46.526 2023] [25125] rotating index 'idx_storeid_10171': success
[Wed Aug 9 03:30:46.555 2023] [25125] rotating index 'idx_storeid_10173': success
[Wed Aug 9 03:30:46.590 2023] [25125] rotating index 'idx_storeid_10180': success
[Wed Aug 9 03:31:06.245 2023] [25125] WARNING: index 'idx_storeid_12207': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12207.sph: No such file or directory - NOT SERVING
[Wed Aug 9 03:31:06.245 2023] [25125] WARNING: index 'idx_storeid_12208': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12208.sph: No such file or directory - NOT SERVING
[Wed Aug 9 03:31:11.509 2023] [25125] WARNING: index 'idx_storeid_10407': rotating index 'idx_storeid_10407': .new prealloc failed: failed to mmap file '/var/lib/manticore/data/idx_storeid_10407.spb': Cannot allocate memory (length=1256940); NOT SERVING
[Wed Aug 9 03:31:11.509 2023] [25125] WARNING: index 'idx_storeid_10407': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10407.spi': Cannot allocate memory (length=473417) - NOT SERVING
[Wed Aug 9 03:31:11.510 2023] [25125] WARNING: index 'idx_storeid_10434': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10434.spa': Cannot allocate memory (length=661960) - NOT SERVING
[Wed Aug 9 03:31:11.510 2023] [25125] WARNING: index 'idx_storeid_10440': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10440.spi': Cannot allocate memory (length=208451) - NOT SERVING
[Wed Aug 9 03:31:11.513 2023] [25125] WARNING: index 'idx_storeid_10472': rotating index 'idx_storeid_10472': .new prealloc failed: failed to mmap file '/var/lib/manticore/data/idx_storeid_10472.spi': Cannot allocate memory (length=5513576); NOT SERVING
[Wed Aug 9 03:31:11.513 2023] [25125] WARNING: index 'idx_storeid_10472': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10472.spi': Cannot allocate memory (length=5513576) - NOT SERVING
[Wed Aug 9 03:31:11.514 2023] [25125] WARNING: index 'idx_storeid_10609': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10609.spi': Cannot allocate memory (length=4287333) - NOT SERVING
[Wed Aug 9 03:31:11.516 2023] [25125] WARNING: index 'idx_storeid_11025': rotating index 'idx_storeid_11025': .new prealloc failed: failed to mmap file '/var/lib/manticore/data/idx_storeid_11025.spi': Cannot allocate memory (length=3193474); NOT SERVING
[Wed Aug 9 03:31:11.516 2023] [25125] WARNING: index 'idx_storeid_11025': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11025.spi': Cannot allocate memory (length=3193474) - NOT SERVING
[Wed Aug 9 03:31:11.518 2023] [25125] WARNING: index 'idx_storeid_11102': rotating index 'idx_storeid_11102': .new prealloc failed: failed to mmap file '/var/lib/manticore/data/idx_storeid_11102.spi': Cannot allocate memory (length=1581368); NOT SERVING
[Wed Aug 9 03:31:11.518 2023] [25125] WARNING: index 'idx_storeid_11102': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11102.spi': Cannot allocate memory (length=1581368) - NOT SERVING
[Wed Aug 9 03:31:11.518 2023] [25125] WARNING: index 'idx_storeid_11276': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11276.spi': Cannot allocate memory (length=2104271) - NOT SERVING
[Wed Aug 9 03:31:11.520 2023] [25125] WARNING: index 'idx_storeid_11804': rotating index 'idx_storeid_11804': .new prealloc failed: failed to mmap file '/var/lib/manticore/data/idx_storeid_11804.spi': Cannot allocate memory (length=946181); NOT SERVING
[Wed Aug 9 03:31:11.520 2023] [25125] WARNING: index 'idx_storeid_11804': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11804.spi': Cannot allocate memory (length=946181) - NOT SERVING
[Wed Aug 9 03:31:11.596 2023] [25128] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 03:31:11.596 2023] [25128] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 03:31:11.596 2023] [25128] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 03:31:11.596 2023] [25128] binlog: finished replaying total 1 in 0.000 sec
[Wed Aug 9 03:31:11.597 2023] [25123] accepting connections
[Wed Aug 9 03:31:11.601 2023] [25129] prereading 12121 indexes
[Wed Aug 9 03:31:28.856 2023] [25129] prereaded 12121 indexes in 17.259 sec
[Wed Aug 9 08:09:10.358 2023] [25123] caught SIGTERM, shutting down
[Wed Aug 9 08:10:40.482 2023] [26527] watchdog: main process 26528 forked ok
[Wed Aug 9 08:10:40.483 2023] [26528] FATAL: failed to lock '/var/lib/manticore/data//binlog.lock': 11 'Resource temporarily unavailable'
[Wed Aug 9 08:10:40.677 2023] [26527] watchdog: main process 26528 exited cleanly (exit code 1), shutting down
[Wed Aug 9 08:13:20.198 2023] [26544] watchdog: main process 26545 forked ok
[Wed Aug 9 08:13:20.199 2023] [26545] starting daemon version '4.2.0 15e927b@211223 release' ...
[Wed Aug 9 08:13:20.199 2023] [26545] listening on all interfaces for mysql, port=9306
[Wed Aug 9 08:13:33.664 2023] [26548] WARNING: index 'idx_storeid_12207': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12207.sph: No such file or directory - NOT SERVING
[Wed Aug 9 08:13:33.664 2023] [26548] WARNING: index 'idx_storeid_12208': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12208.sph: No such file or directory - NOT SERVING
[Wed Aug 9 08:13:34.118 2023] [26548] WARNING: index 'idx_storeid_10407': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10407.spb': Cannot allocate memory (length=1256940) - NOT SERVING
[Wed Aug 9 08:13:34.118 2023] [26548] WARNING: index 'idx_storeid_10434': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10434.spi': Cannot allocate memory (length=672094) - NOT SERVING
[Wed Aug 9 08:13:34.119 2023] [26548] WARNING: index 'idx_storeid_10440': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10440.spi': Cannot allocate memory (length=208451) - NOT SERVING
[Wed Aug 9 08:13:34.120 2023] [26548] WARNING: index 'idx_storeid_10472': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10472.spi': Cannot allocate memory (length=5513576) - NOT SERVING
[Wed Aug 9 08:13:34.121 2023] [26548] WARNING: index 'idx_storeid_10609': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10609.spi': Cannot allocate memory (length=4287333) - NOT SERVING
[Wed Aug 9 08:13:34.122 2023] [26548] WARNING: index 'idx_storeid_11025': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11025.spi': Cannot allocate memory (length=3193474) - NOT SERVING
[Wed Aug 9 08:13:34.123 2023] [26548] WARNING: index 'idx_storeid_11102': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11102.spi': Cannot allocate memory (length=1581368) - NOT SERVING
[Wed Aug 9 08:13:34.124 2023] [26548] WARNING: index 'idx_storeid_11276': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11276.spi': Cannot allocate memory (length=2104271) - NOT SERVING
[Wed Aug 9 08:13:34.125 2023] [26548] WARNING: index 'idx_storeid_11804': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11804.spi': Cannot allocate memory (length=946181) - NOT SERVING
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 08:13:34.203 2023] [26550] binlog: finished replaying total 2 in 0.000 sec
[Wed Aug 9 08:13:34.204 2023] [26545] accepting connections
[Wed Aug 9 08:13:34.208 2023] [26551] prereading 12121 indexes
[Wed Aug 9 08:13:51.513 2023] [26551] prereaded 12121 indexes in 17.309 sec
[Wed Aug 9 08:24:51.480 2023] [26545] caught SIGTERM, shutting down
[Wed Aug 9 08:39:59.785 2023] [26822] watchdog: main process 26823 forked ok
[Wed Aug 9 08:39:59.787 2023] [26823] starting daemon version '4.2.0 15e927b@211223 release' ...
[Wed Aug 9 08:39:59.788 2023] [26823] listening on all interfaces for mysql, port=9306
[Wed Aug 9 08:40:13.200 2023] [26826] WARNING: index 'idx_storeid_12207': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12207.sph: No such file or directory - NOT SERVING
[Wed Aug 9 08:40:13.200 2023] [26826] WARNING: index 'idx_storeid_12208': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12208.sph: No such file or directory - NOT SERVING
[Wed Aug 9 08:40:13.643 2023] [26826] WARNING: index 'idx_storeid_10407': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10407.spb': Cannot allocate memory (length=1256940) - NOT SERVING
[Wed Aug 9 08:40:13.643 2023] [26826] WARNING: index 'idx_storeid_10434': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10434.spi': Cannot allocate memory (length=672094) - NOT SERVING
[Wed Aug 9 08:40:13.644 2023] [26826] WARNING: index 'idx_storeid_10440': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10440.spi': Cannot allocate memory (length=208451) - NOT SERVING
[Wed Aug 9 08:40:13.645 2023] [26826] WARNING: index 'idx_storeid_10472': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10472.spi': Cannot allocate memory (length=5513576) - NOT SERVING
[Wed Aug 9 08:40:13.646 2023] [26826] WARNING: index 'idx_storeid_10609': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10609.spi': Cannot allocate memory (length=4287333) - NOT SERVING
[Wed Aug 9 08:40:13.647 2023] [26826] WARNING: index 'idx_storeid_11025': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11025.spi': Cannot allocate memory (length=3193474) - NOT SERVING
[Wed Aug 9 08:40:13.648 2023] [26826] WARNING: index 'idx_storeid_11102': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11102.spi': Cannot allocate memory (length=1581368) - NOT SERVING
[Wed Aug 9 08:40:13.649 2023] [26826] WARNING: index 'idx_storeid_11276': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11276.spi': Cannot allocate memory (length=2104271) - NOT SERVING
[Wed Aug 9 08:40:13.650 2023] [26826] WARNING: index 'idx_storeid_11804': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11804.spi': Cannot allocate memory (length=946181) - NOT SERVING
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replaying log /var/lib/manticore/data//binlog.002
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: finished replaying /var/lib/manticore/data//binlog.002; 0.0 MB in 0.000 sec
[Wed Aug 9 08:40:13.728 2023] [26828] binlog: finished replaying total 3 in 0.000 sec
[Wed Aug 9 08:40:13.729 2023] [26823] accepting connections
[Wed Aug 9 08:40:13.733 2023] [26829] prereading 12121 indexes
[Wed Aug 9 08:40:31.115 2023] [26829] prereaded 12121 indexes in 17.386 sec
[Wed Aug 9 09:03:34.648 2023] [26823] caught SIGTERM, shutting down
[Wed Aug 9 09:07:58.908 2023] [27102] watchdog: main process 27103 forked ok
[Wed Aug 9 09:07:58.910 2023] [27103] starting daemon version '4.2.0 15e927b@211223 release' ...
[Wed Aug 9 09:07:58.910 2023] [27103] listening on all interfaces for mysql, port=9306
[Wed Aug 9 09:08:12.148 2023] [27106] WARNING: index 'idx_storeid_12207': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12207.sph: No such file or directory - NOT SERVING
[Wed Aug 9 09:08:12.148 2023] [27106] WARNING: index 'idx_storeid_12208': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12208.sph: No such file or directory - NOT SERVING
[Wed Aug 9 09:08:12.587 2023] [27106] WARNING: index 'idx_storeid_10407': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10407.spb': Cannot allocate memory (length=1256940) - NOT SERVING
[Wed Aug 9 09:08:12.588 2023] [27106] WARNING: index 'idx_storeid_10434': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10434.spi': Cannot allocate memory (length=672094) - NOT SERVING
[Wed Aug 9 09:08:12.588 2023] [27106] WARNING: index 'idx_storeid_10440': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10440.spi': Cannot allocate memory (length=208451) - NOT SERVING
[Wed Aug 9 09:08:12.589 2023] [27106] WARNING: index 'idx_storeid_10472': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10472.spi': Cannot allocate memory (length=5513576) - NOT SERVING
[Wed Aug 9 09:08:12.591 2023] [27106] WARNING: index 'idx_storeid_10609': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_10609.spi': Cannot allocate memory (length=4287333) - NOT SERVING
[Wed Aug 9 09:08:12.591 2023] [27106] WARNING: index 'idx_storeid_11025': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11025.spi': Cannot allocate memory (length=3193474) - NOT SERVING
[Wed Aug 9 09:08:12.592 2023] [27106] WARNING: index 'idx_storeid_11102': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11102.spi': Cannot allocate memory (length=1581368) - NOT SERVING
[Wed Aug 9 09:08:12.593 2023] [27106] WARNING: index 'idx_storeid_11276': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11276.spi': Cannot allocate memory (length=2104271) - NOT SERVING
[Wed Aug 9 09:08:12.594 2023] [27106] WARNING: index 'idx_storeid_11804': prealloc: failed to mmap file '/var/lib/manticore/data/idx_storeid_11804.spi': Cannot allocate memory (length=946181) - NOT SERVING
[Wed Aug 9 09:08:12.675 2023] [27103] accepting connections
[Wed Aug 9 09:08:12.678 2023] [27109] prereading 12121 indexes
[Wed Aug 9 09:08:30.112 2023] [27109] prereaded 12121 indexes in 17.437 sec
[Wed Aug 9 09:27:25.600 2023] [27103] caught SIGTERM, shutting down
[Wed Aug 9 10:08:12.715 2023] [27554] watchdog: main process 27556 forked ok
[Wed Aug 9 10:08:12.717 2023] [27556] starting daemon version '4.2.0 15e927b@211223 release' ...
[Wed Aug 9 10:08:12.717 2023] [27556] listening on all interfaces for mysql, port=9306
[Wed Aug 9 10:08:25.943 2023] [27559] WARNING: index 'idx_storeid_12207': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12207.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:25.943 2023] [27559] WARNING: index 'idx_storeid_12208': prealloc: failed to open /var/lib/manticore/data/idx_storeid_12208.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_10407': prealloc: failed to open /var/lib/manticore/data/idx_storeid_10407.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_10434': prealloc: failed to open /var/lib/manticore/data/idx_storeid_10434.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_10440': prealloc: failed to open /var/lib/manticore/data/idx_storeid_10440.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_10472': prealloc: failed to open /var/lib/manticore/data/idx_storeid_10472.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_10609': prealloc: failed to open /var/lib/manticore/data/idx_storeid_10609.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11025': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11025.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11102': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11102.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11276': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11276.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.383 2023] [27559] WARNING: index 'idx_storeid_11804': prealloc: failed to open /var/lib/manticore/data/idx_storeid_11804.sph: No such file or directory - NOT SERVING
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: replaying log /var/lib/manticore/data//binlog.001
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: replay stats: 0 commits; 0 updates, 0 reconfigure; 0 pq-add; 0 pq-delete; 0 pq-add-delete, 0 indexes
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: finished replaying /var/lib/manticore/data//binlog.001; 0.0 MB in 0.000 sec
[Wed Aug 9 10:08:26.460 2023] [27561] binlog: finished replaying total 1 in 0.000 sec
[Wed Aug 9 10:08:26.461 2023] [27556] accepting connections
[Wed Aug 9 10:08:26.465 2023] [27562] prereading 12121 indexes
[Wed Aug 9 10:08:44.001 2023] [27562] prereaded 12121 indexes in 17.540 sec
could you provide output of
ps aufx | grep searchd
netstat -tulpn | grep 9306
sudo lsof -i :19306
to make sure the searchd running and it bind to the port alone
[root@test1 aneeshc]# ps aufx | grep searchd
root 29894 0.0 0.0 241428 4640 pts/5 T 15:43 0:00 | \_ sudo tail -f /var/log/manticore/searchd.log
root 29896 0.0 0.0 108096 616 pts/5 T 15:43 0:00 | | \_ tail -f /var/log/manticore/searchd.log
root 29897 0.0 0.0 241428 4648 pts/5 T 15:43 0:00 | \_ sudo tail 500 -f /var/log/manticore/searchd.log
root 29899 0.0 0.0 108096 692 pts/5 T 15:43 0:00 | | \_ tail 500 -f /var/log/manticore/searchd.log
root 29900 0.0 0.0 241428 4652 pts/5 T 15:44 0:00 | \_ sudo tail 5 -f /var/log/manticore/searchd.log
root 29902 0.0 0.0 108096 696 pts/5 T 15:44 0:00 | | \_ tail 5 -f /var/log/manticore/searchd.log
root 29904 0.0 0.0 241428 4644 pts/5 T 15:44 0:00 | \_ sudo tail -f 200 /var/log/manticore/searchd.log
root 29906 0.0 0.0 108096 696 pts/5 T 15:44 0:00 | \_ tail -f 200 /var/log/manticore/searchd.log
root 30374 0.0 0.0 112812 980 pts/2 S+ 17:14 0:00 \_ grep --color=auto searchd
mantico+ 27554 0.0 0.1 241912 181368 ? S 10:08 0:00 /usr/bin/searchd --config /etc/manticoresearch/manticore.conf
mantico+ 27556 0.1 48.5 65121640 62673096 ? Sl 10:08 0:36 \_ /usr/bin/searchd --config /etc/manticoresearch/manticore.conf
[root@test1 aneeshc]# netstat -tulpn | grep 9306
tcp 6 0 0.0.0.0:9306 0.0.0.0:* LISTEN 27556/searchd
hi there ,
could any one look into this…
Hi @AneeshBabu
Sorry I was on vacation last week and couldn’t reply.
Iam not able to login into manticore using the command
mysql -h0 -P 9306.
What does it look like when you can’t log in?