[PATCH] sphinx test cases cannot run with sphinxsearch-2.2.6

WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'port' was permanently removed from Sphinx configuration. Refer to documentation for details.

1.94s$ cd ../mysql-test && MTR_BINDIR="${TRAVIS_BUILD_DIR}"/debug_build ./mysql-test-run.pl ${BIGTEST} --report-times --parallel=4 --mem --verbose sphinx

Logging: ./mysql-test-run.pl  --report-times --parallel=4 --mem --verbose sphinx

vardir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var

Removing old var directory...

> opt_vardir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var

> Removing /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/

> Removing /dev/shm/var_auto_owtW

> Removing /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/tmp/

Creating var directory '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var'...

> Creating /dev/shm/var_auto_owtW

 - symlinking 'var' to '/dev/shm/var_auto_owtW'

Checking supported features...

> cmd: /home/travis/build/openquery/mariadb-server/debug_build/sql/mysqld --no-defaults --datadir=. --basedir=/home/travis/build/openquery/mariadb-server --lc-messages-dir=/home/travis/build/openquery/mariadb-server/debug_build/sql/share --skip-grant-tables --log-warnings=0 --verbose --help

MariaDB Version 5.5.43-MariaDB-debug

Installing system database...

 - skipping SSL, mysqld not compiled with SSL

 - binaries are debug compiled

Collecting tests...

> Collecting: main

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test

Error in cipher list

139797463103136:error:140E6118:SSL routines:SSL_CIPHER_PROCESS_RULESTR:invalid command:ssl_ciph.c:1169:

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/r

> Collecting: archive

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/archive

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/archive

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/archive

> Collecting: binlog

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/binlog

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/binlog/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/binlog/r

> Read combinations file

> Collecting: csv

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/csv

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/csv

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/csv

> Collecting: federated

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/federated

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/federated

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/federated

> Read combinations file

> Collecting: funcs_1

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_1

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_1/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_1/r

> Collecting: funcs_2

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_2

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_2/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/funcs_2/r

> Collecting: handler

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/handler

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/handler

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/handler

> Collecting: heap

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/heap

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/heap

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/heap

> Collecting: innodb

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb/r

> Collecting: innodb_zip

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb_zip

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb_zip/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/innodb_zip/r

> Collecting: maria

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/maria

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/maria

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/maria

> Collecting: optimizer_unfixed_bugs

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/optimizer_unfixed_bugs

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/optimizer_unfixed_bugs/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/optimizer_unfixed_bugs/r

> Collecting: oqgraph

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/oqgraph

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/oqgraph/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/oqgraph/r

> Collecting: parts

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/parts

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/parts/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/parts/r

> Collecting: percona

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/percona

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/percona

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/percona

> Collecting: perfschema

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/perfschema

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/perfschema/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/perfschema/r

> Collecting: plugins

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/plugins

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/plugins/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/plugins/r

> Collecting: rpl

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/rpl

> overlays: /home/travis/build/openquery/mariadb-server/storage/tokudb/mysql-test/rpl

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/rpl/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/rpl/r

> testdir: /home/travis/build/openquery/mariadb-server/storage/tokudb/mysql-test/rpl/t

> resdir: /home/travis/build/openquery/mariadb-server/storage/tokudb/mysql-test/rpl/r

> Collecting: sphinx

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sphinx

> tool: /usr/local/bin/searchd

Sphinx 2.2.6-id64-release (r4843)

Copyright (c) 2001-2014, Andrew Aksyonoff

Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

Usage: searchd [OPTIONS]

Options are:

-h, --help		display this help message

-c, --config <file>	read configuration from specified file

			(default is sphinx.conf)

--stop			send SIGTERM to currently running searchd

--stopwait		send SIGTERM and wait until actual exit

--status		get ant print status variables

			(PID is taken from pid_file specified in config file)

--iostats		log per-query io stats

--cpustats		log per-query cpu stats

--strip-path		strip paths from stopwords, wordforms, exceptions

			and other file names stored in the index header

--replay-flags=<OPTIONS>

			extra binary log replay options (the only current one

			is 'accept-desc-timestamp')

Debugging options are:

--console		run in console mode (do not fork, do not log to files)

-p, --port <port>	listen on given port (overrides config setting)

-l, --listen <spec>	listen on given address, port or path (overrides

			config settings)

-i, --index <index>	only serve given index(es)

--nodetach		do not detach into background

--logdebug, --logdebugv, --logdebugvv

			enable additional debug information logging

			(with different verboseness)

--pidfile		force using the PID file (useful with --console)

--safetrace		only use system backtrace() call in crash reports

Examples:

searchd --config /usr/local/sphinx/etc/sphinx.conf

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sphinx

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sphinx

> Collecting: sys_vars

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sys_vars

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sys_vars/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/sys_vars/r

> Collecting: unit

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/unit

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/unit

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/unit

> Collecting: vcol

> suitedir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/vcol

> testdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/vcol/t

> resdir: /home/travis/build/openquery/mariadb-server/mysql-test/suite/vcol/r

worker[1] > mtr_ping_port: 13000

==============================================================================

worker[1] > FREE

worker[1] > mtr_ping_port: 13001

TEST                                  WORKER RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] > FREE

worker[1] > mtr_ping_port: 13002

worker[1] > FREE

worker[1] > mtr_ping_port: 13003

worker[1] > FREE

worker[1] > mtr_ping_port: 13004

worker[1] > FREE

worker[1] > mtr_ping_port: 13005

worker[1] > FREE

worker[1] > mtr_ping_port: 13006

worker[2] > mtr_ping_port: 13010

worker[1] > FREE

worker[1] > mtr_ping_port: 13007

worker[1] > FREE

worker[1] > mtr_ping_port: 13008

worker[2] > FREE

worker[2] > mtr_ping_port: 13011

worker[1] > FREE

worker[1] > mtr_ping_port: 13009

worker[2] > FREE

worker[2] > mtr_ping_port: 13012

worker[1] > FREE

worker[2] > FREE

worker[2] > mtr_ping_port: 13013

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

worker[2] > FREE

worker[2] > mtr_ping_port: 13014

worker[2] > FREE

worker[2] > mtr_ping_port: 13015

worker[2] > FREE

worker[2] > mtr_ping_port: 13016

worker[2] > FREE

worker[3] > mtr_ping_port: 13020

worker[2] > mtr_ping_port: 13017

worker[2] > FREE

worker[2] > mtr_ping_port: 13018

worker[2] > FREE

worker[2] > mtr_ping_port: 13019

worker[3] > FREE

worker[3] > mtr_ping_port: 13021

worker[2] > FREE

worker[4] > mtr_ping_port: 13030

worker[2] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039

worker[3] > FREE

worker[3] > mtr_ping_port: 13022

> Client connected

worker[4] > FREE

worker[3] > FREE

worker[4] > mtr_ping_port: 13031

worker[3] > mtr_ping_port: 13023

> Client connected

worker[4] > FREE

worker[3] > FREE

worker[3] > mtr_ping_port: 13024

worker[4] > mtr_ping_port: 13032

> Client connected

worker[3] > FREE

worker[4] > FREE

> Client connected

worker[3] > mtr_ping_port: 13025

worker[4] > mtr_ping_port: 13033

worker[3] > FREE

worker[4] > FREE

worker[4] > mtr_ping_port: 13034

worker[3] > mtr_ping_port: 13026

worker[4] > FREE

worker[3] > FREE

worker[3] > mtr_ping_port: 13027

worker[4] > mtr_ping_port: 13035

worker[3] > FREE

worker[4] > FREE

worker[4] > mtr_ping_port: 13036

worker[3] > mtr_ping_port: 13028

worker[4] > FREE

worker[3] > FREE

worker[4] > mtr_ping_port: 13037

worker[3] > mtr_ping_port: 13029

worker[3] > FREE

worker[4] > FREE

worker[4] > mtr_ping_port: 13038

worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059

worker[4] > FREE

worker[4] > mtr_ping_port: 13039

worker[4] > FREE

worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079

worker[1] Creating var directory '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1'...

worker[1] > Creating /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1

worker[2] Creating var directory '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/2'...

worker[2] > Creating /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/2

worker[4] Creating var directory '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/4'...

worker[4] > Creating /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/4

worker[3] Creating var directory '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/3'...

worker[3] > Creating /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/3

worker[1] > result: , file_mode: 0

worker[2] > result: , file_mode: 0

�];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left��];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left�worker[2] Server said BYE

worker[2] Restarting 

worker[1] > Running test: sphinx.sphinx

worker[1] > Setting timezone: DEFAULT

�];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left�worker[1] > Cleaning datadirs...

worker[1] > clean_dir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/tmp

> Child closed socket

worker[1] > clean_dir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/tmp/1

worker[1] > Generating my.cnf from '/home/travis/build/openquery/mariadb-server/mysql-test/suite/sphinx/my.cnf'

worker[4] > result: , file_mode: 0

�];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left�worker[3] > result: , file_mode: 0

worker[4] Server said BYE

�];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left�worker[4] Restarting 

worker[3] Server said BYE

worker[3] Restarting 

�];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left��];mtr: spent 0:00:01 on 2 tests. 0:00:00 (0 tests) left�> Child closed socket

> Child closed socket

worker[1] > MASTER_MYPORT = 16000

worker[1] > MASTER_MYSOCK = /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/tmp/1/mysqld.1.sock

worker[1] > SPHINXSEARCH_PORT = 16001

worker[1] > mysqld_start:  [' --plugin-load=ha_sphinx.so', '--sphinx ']

worker[1] > Started [mysqld.1 - pid: 1513, winpid: 1513]

worker[1] > cmd: "/usr/local/bin/indexer" --config "/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/my_sphinx.conf" test1 > "/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/searchd/sphinx.log" 2>&1

worker[1] > Started [sphinx-searchd - pid: 1520, winpid: 1520]

worker[1] Started [check-mysqld_1 - pid: 1525, winpid: 1525]

worker[1] Got [check-mysqld_1 - pid: 1525, winpid: 1525, exit: 0]

worker[1] > Started [mysqltest - pid: 1529, winpid: 1529]

worker[1] > Got [mysqltest - pid: 1529, winpid: 1529, exit: 256]

worker[1] > Stopping all servers...

worker[1] Saving datadirs...

worker[1]  - saving '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/mysqld.1'

worker[1]  - saving '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/searchd'

worker[1] sphinx.sphinx                            w1 worker[1] [ fail ]

        Test ended at 2015-04-24 08:29:16

worker[1] 

CURRENT_TEST: sphinx.sphinx

safe_process[1529]: parent_pid: 1509

safe_process[1529]: Started child 1530, terminated: 0

mysqltest: At line 4: query 'select * from ts where q='test'' failed: 1429: Unable to connect to foreign data source: failed to connect to searchd (host=127.0.0.1, errno=111, port=16

The result from queries just before the failure was:

create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/*";

select * from ts where q='test';

safe_process[1529]: Got signal 17, child_pid: 1530

safe_process[1529]: Killing child: 1530

safe_process[1529]: Child exit: 1

sphinx.sphinx                            w1 [ fail ]

        Test ended at 2015-04-24 08:29:16

CURRENT_TEST: sphinx.sphinx

safe_process[1529]: parent_pid: 1509

safe_process[1529]: Started child 1530, terminated: 0

mysqltest: At line 4: query 'select * from ts where q='test'' failed: 1429: Unable to connect to foreign data source: failed to connect to searchd (host=127.0.0.1, errno=111, port=16

The result from queries just before the failure was:

create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/*";

select * from ts where q='test';

safe_process[1529]: Got signal 17, child_pid: 1530

safe_process[1529]: Killing child: 1530

safe_process[1529]: Child exit: 1

 - saving '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/log/sphinx.sphinx/' to '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/log/sphinx.sphinx/'

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 2 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): sphinx.sphinx

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation

at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases

The command "cd ../mysql-test && MTR_BINDIR="${TRAVIS_BUILD_DIR}"/debug_build ./mysql-test-run.pl ${BIGTEST} --report-times --parallel=4 --mem --verbose sphinx" exited with 1.

0.02s$ find  ${TRAVIS_BUILD_DIR}/debug_build/mysql-test/var/log/sphinx.sphinx/ -name "*.log" -print -ls -exec cat {} \;

/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/log/sphinx.sphinx/searchd/sphinx.log

3759071109    4 -rw-r--r--   1 travis   travis       2219 Apr 24 08:29 /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/log/sphinx.sphinx/searchd/sphinx.log

Sphinx 2.2.6-id64-release (r4843)

Copyright (c) 2001-2014, Andrew Aksyonoff

Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/my_sphinx.conf'...

WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'port' was permanently removed from Sphinx configuration. Refer to documentation for details.

indexing index 'test1'...

collected 4 docs, 0.0 MB

sorted 0.0 Mhits, 100.0% done

total 4 docs, 201 bytes

total 0.003 sec, 52466 bytes/sec, 1044.11 docs/sec

total 4 reads, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg

total 12 writes, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg

safe_process[1520]: parent_pid: 1509

safe_process[1520]: Started child 1521, terminated: 0

[Fri Apr 24 08:29:15.570 2015] [ 1521] using config file '/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/1/my_sphinx.conf'...

[Fri Apr 24 08:29:15.572 2015] [ 1521] listening on all interfaces, port=9312

[Fri Apr 24 08:29:15.572 2015] [ 1521] listening on all interfaces, port=9306

Sphinx 2.2.6-id64-release (r4843)

Copyright (c) 2001-2014, Andrew Aksyonoff

Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

WARNING: key 'charset_type' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Refer to documentation for details.

WARNING: key 'port' was permanently removed from Sphinx configuration. Refer to documentation for details.

precaching index 'test1'