Bug#861262: sphinxsearch needs systemd unit file

2017-11-27 Thread Yvan Taviaud - Dugwood
It's not in the main tarball, it's in the Debian deb archive: 
http://sphinxsearch.com/files/sphinxsearch_2.2.11-release-1~jessie_amd64.deb
(open the file with any archive manager not supporting deb packages, 
then open the «data.tar.xz», you'll find it there).


So the fix would be to import the Jessie deb package as it's available 
on sphinxsearch.com, with a few ajustments for Stretch.


Le 27/11/2017 à 15:32, Matthew Gabeler-Lee a écrit :
Looking at http://sphinxsearch.com/bugs/view.php?id=2321 and the 
2.2.11 vs. 2.2.10 upstream source releases, or the upstream git repo, 
I can't find any signs that a systemd unit file was actually added to 
the tree at all.  Nor does upstream ticket 2321 appear in the 
changelog for 2.2.11.


Seems someone upstream maybe forgot to actually commit/push the fix?

And for that matter, the sysvinit script debian ships is not really 
related to upstream's one in contrib.






Bug#861262: Sleep issue

2017-11-07 Thread Yvan Taviaud - Dugwood

It's been fixed in Sphinx by using a dedicated systemd script:
http://sphinxsearch.com/bugs/view.php?id=2321

Hum... wait... blade106 is me... so I've already hit the bug 2 years 
ago, and found the fix :-)


In the meanwhile, Debian dropped the package in Jessie, so I've changed 
the installation script, that's why I'm here again.


Debian should include the systemd service script, as it is in the source 
tarball from Sphinx website.




Bug#861262: Sleep issue

2017-11-07 Thread Yvan Taviaud - Dugwood
File /etc/init.d/sphinxsearch isn't run, as my system uses systemd. 
Seems to be the issue: systemd doesn't use a timeout, it must be 
configured somewhere.




Bug#861262: Sleep issue

2017-11-07 Thread Yvan Taviaud - Dugwood
Hit the same issue, and read 
http://sphinxsearch.com/forum/view.html?id=10783 and 
https://bugs.launchpad.net/ubuntu/+source/sphinxsearch/+bug/990395.


At first I thought it was due to the privileged user (root used instead 
of sphinxsearch), but it seems the following isn't run:

[ -n "$DODTIME" ] && sleep $DODTIME

as the restart happens to run in less than one second:
DODTIME=1   # Time to wait for the server to die, in seconds
    # If this value is set too low you might not
    # let some servers to die gracefully and
    # 'restart' will not work

Running the following to simulate the behaviour always works:
service sphinxsearch stop && sleep 1 && service sphinxsearch start

I can see that the code is the same for all Debian releases (from Wheezy 
to Sid), so it must be an external change (bash/dash?).


Second restart works because the process is effectively stopped after 1 
second at most. If you run:
service sphinxsearch restart; service sphinxsearch restart; service 
sphinxsearch restart

you'll have 3 fails (or 2 if the service wasn't working at first).

I'm trying to find out why the sleep isn't run, I'll let you know when I 
find it.


--
Yvan.



Bug#877856: mysql-utilities: Parsing MySQL version is broken

2017-10-06 Thread Yvan Taviaud - Dugwood

Package: mysql-utilities
Version: 1.6.4-1
Severity: grave
Tags: newcomer upstream
Justification: renders package unusable

MySQL version parser is broken in 1.6.4, fixed in 1.6.5, but doesn't
seem to be available:
https://dev.mysql.com/doc/mysql-utilities/1.6/en/mysql-utils-install-deb.html
refers to 1.6.4, and:
https://dev.mysql.com/doc/mysql-utilities/1.6/en/mysql-utils-install-source.html
refers to 1.6.4 too.

Example Python script, to be run as root (or any user that has access to 
mysqld

executable):

test.py
__
from mysql.utilities.common.tools import (get_mysqld_version, get_tool_path)

if __name__ == '__main__':
    mysqld_path = get_tool_path("/usr", "mysqld")
    version_str = get_mysqld_version(mysqld_path)
    print version_str
__

MariaDB is installed, and report:
root# mysqld --version
mysqld  Ver 10.1.26-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 
(Debian 9.1)


Running the Python script:
root# python test.py
None

Fixing the function parse_mysqld_version,
in /usr/lib/python2.7/dist-packages/mysql/utilities/common/tools.py,
according to:
https://github.com/mysql/mysql-utilities/blob/release-1.6.5/mysql/utilities/common/tools.py#L247

Run the script again:
root# python test.py
('10', '1', '26')

This breaks mysqlfrm tool, because the failed parsing of the version
will run script for MySQL < 5.7.6 where I have a MySQL 5.7.19 (Percona
XtraDB Cluster 5.7)

Thanks Debian team!


-- System Information:
Debian Release: 9.1
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-3-amd64 (SMP w/8 CPU cores)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), 
LANGUAGE=fr:en_US:en_GB (charmap=UTF-8)

Shell: /bin/sh linked to /bin/bash
Init: systemd (via /run/systemd/system)

Versions of packages mysql-utilities depends on:
ii  python  2.7.13-2
ii  python-mysql.connector  2.1.6-1

mysql-utilities recommends no packages.

mysql-utilities suggests no packages.

-- no debconf information