Error with csvpip

seems it is a general system administration issue at your box that could be fixed with usual linux administrator and I not very good at linux administration. You could also use our Services in case you need a help with linux box a administration.

I have done little investigation,
When i stop manticore,delete pid file, i check for folder and file permission.
Then i start manticore (/etc/init.d/manticore start) pid file is with 600 permission.

I try searchd -c /etc/manticoresearch/manticore.conf
i have
FATAL: failed to lock pid file ‘/var/run/manticore/searchd_v2.pid’:
I reset permission to pid file
i try aigain searchd -c…
i hav again

FATAL: failed to lock pid file ‘/var/run/manticore/searchd_v2.pid’: Resource temporarily unavailable (searchd already running?)

**If i try indexer : **
i hav
collected 999 docs, 0.2 MB
creating lookup: 1.0 Kdocs, 100.0% done
creating histograms: 1.0 Kdocs, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 999 docs, 245704 bytes
total 0.060 sec, 4051379 bytes/sec, 16472.37 docs/sec
total 14 reads, 0.000 sec, 52.7 kb/call avg, 0.0 msec/call avg
total 17 writes, 0.000 sec, 79.3 kb/call avg, 0.0 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=27536).

But at log file i hav :
[Mon Aug 31 14:07:07.123 2020] [27536] caught SIGHUP (seamless=1, in_rotate=0, need_rotate=0)
[Mon Aug 31 14:07:07.124 2020] [27543] WARNING: nothing to rotate after SIGHUP

Finally i can’t acess to the index over sphinxql “show tables” shows nothing.

Please provide even more details:

  • ps aux|grep searchd
  • ls -la of you index files and the pid file
  • how exactly you run indexer (including under which user)
  • how exactly you run searchd (including the user)

These all should be ordered how you run it so we can understand why this or that happened.

ps aux|grep searchd command give this :
mantico+ 4820 0.0 0.0 38536 3896 ? S Aug30 0:00 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 4821 0.0 0.0 827072 8624 ? Sl Aug30 0:44 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
root 13519 0.0 0.0 12716 964 pts/0 S+ 13:35 0:00 grep searchd
mantico+ 26798 0.0 0.0 38536 3788 ? S Aug31 0:00 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 26799 0.0 0.0 761404 7400 ? Sl Aug31 0:26 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 27156 0.0 0.0 38536 3832 ? S Aug31 0:00 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 27157 0.0 0.0 761404 7620 ? Sl Aug31 0:26 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 27535 0.0 0.0 38536 3856 ? S Aug31 0:00 /usr/bin/search d --config /etc/manticoresearch/manticore.conf
mantico+ 27536 0.0 0.0 761272 6996 ? Sl Aug31 0:26 /usr/bin/search d --config /etc/manticoresearch/manticore.conf

I run indexer under root
i use indexer --rotate --all (i have one index for now )
I run searchd under root
i use command : searchd -c /etc/manticoresearch/manticore.conf
My machine
Debian 9 (Debian 4.9.189-3+deb9u2 ) with plesk

  • OS: ‪Debian 9.13‬
  • Product: Plesk Obsidian 18.0.29
  • 32 G ram

Finally i hav found the solution.
Thanks a lot Sergey and Tomat for your time !

For the solution i did :
killall -9 searchd
searchd -c /etc/manticoresearch/manticore.conf
indexer --rotate --all

Last step : allow RT index creation via SphinxQL
for now i receive error : FATAL: ‘data_dir’ cannot be mixed with index declarations in ‘/etc/manticoresearch/manticore.conf’
Thanks again

Read about plain mode vs rt mode - https://manual.manticoresearch.com/Read_this_first#Real-time-mode-vs-plain-mode

Thanks for your quick answer.
Very nice work you have done for Manticore !