Mailinglist Archive: opensuse-buildservice (75 mails)

< Previous Next >
Re: [opensuse-buildservice] How to make use or get rid of https://<local-obs-instance>/search ?
Hi,

On 1. Mar 2018, at 11:52 , Adrian Schröter <adrian@xxxxxxx> wrote:

How to make internal search work?

In the logs I see:

[...] Can't connect to MySQL server on '127.0.0.1' (111 "Connection
refused") [...]

this is usually not the real MySQL server, but the searchd which offers also
a mysql interface ...

And the crash is usually caused by a not running searchd.

In your version it should have been started by clockworkd.
try to run in manually by running

rake.ruby2.X ts:index ts:start

as the right user (www?).

The most popular reason why searchd is not starting is some left over file
with wrong ownership. So I would

rm -rf /srv/www/obs/api/tmp/binlog
/srv/www/obs/api/log/production.searchd.log
/srv/www/obs/api/log/production.searchd.query.log
/srv/www/obs/api/log/production.sphinx.pid

before.


That was a good hint.
binlog was indeed not owned by wwwrun.
Found the clean-restart method of the obsapidelayed init-script and after that,
it works.

I wonder why, since that is a fresh 2.8 installation, but the following fixed
it:


# /etc/init.d/obsapidelayed clean-restart
redirecting to systemctl stop obsapidelayed.service
/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:51:
warning: constant ::Fixnum is deprecated
/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:52:
warning: constant ::Bignum is deprecated
/usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38:
warning: constant ::Fixnum is deprecated
/usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38:
warning: constant ::Bignum is deprecated
/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/core_ext/numeric/conversions.rb:138:
warning: constant ::Fixnum is deprecated
Generating configuration to /srv/www/obs/api/config/production.sphinx.conf
Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/srv/www/obs/api/config/production.sphinx.conf'...
WARNING: key 'max_matches' was permanently removed from Sphinx configuration.
Refer to documentation for details.
indexing index 'package_core'...
collected 25401 docs, 1.3 MB
collected 21 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.2 Mhits, 100.0% done
total 25401 docs, 1291159 bytes
total 1.661 sec, 777046 bytes/sec, 15286.85 docs/sec
indexing index 'project_core'...
collected 1506 docs, 0.1 MB
collected 21 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 1506 docs, 67107 bytes
total 0.899 sec, 74608 bytes/sec, 1674.34 docs/sec
skipping non-plain index 'package'...
skipping non-plain index 'project'...
total 26937 reads, 0.014 sec, 0.1 kb/call avg, 0.0 msec/call avg
total 28 writes, 0.007 sec, 175.1 kb/call avg, 0.2 msec/call avg
redirecting to systemctl start obsapidelayed.service

--

kind regards,
Carsten Hoeger
Professional Services



Email: carsten.hoeger@xxxxxxxxxxxxxxxx


------------------------------------------------------------------------------
Open-Xchange AG, Rollnerstr. 14, 90408 Nuremberg,
District Court Nuremberg HRB 24738
Managing Board: Rafael Laguna de la Vera, Carsten Dirks,
Michael Knapstein, Stephan Martin
Chairman of the Board: Richard Seibt

European Office:
Open-Xchange GmbH, Olper Huette 5f, D-57462 Olpe, Germany,
District Court Siegen, HRB 8718
Managing Director: Frank Hoberg

US Office:
Open-Xchange. Inc., 530 Lytton Avenue, Palo Alto, CA 94301, USA
------------------------------------------------------------------------------

< Previous Next >
List Navigation