[MDEV-8050] [PATCH] sphinx test cases cannot run with sphinxsearch-2.2.6 Created: 2015-04-25  Updated: 2015-06-08  Resolved: 2015-06-05

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5.42, 10.0.17, 10.1.4
Fix Version/s: 5.5.44, 10.0.20, 10.1.6

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

ubuntu 12.02


Issue Links:
Relates
relates to MDEV-6262 analyze the coverity report on mariadb Open

 Description   

Sphinx options used by test have been removed

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.

https://travis-ci.org/openquery/mariadb-server/jobs/59841189

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'



 Comments   
Comment by Daniel Black [ 2015-04-25 ]

Patch for 5.5 https://github.com/MariaDB/server/pull/47
patch for 10.0 https://github.com/MariaDB/server/pull/48 (noting that files have moved)

Both still work on sphinxsearch 2.0.8-id64-release

With patch:

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_byA2
> 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_byA2
 - symlinking 'var' to '/dev/shm/var_auto_byA2'
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
140634816042656: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
 
==============================================================================
 
TEST                                  WORKER RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] > FREE
worker[1] > mtr_ping_port: 13001
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[2] > mtr_ping_port: 13010
worker[1] > FREE
worker[1] > mtr_ping_port: 13005
worker[1] > FREE
worker[1] > mtr_ping_port: 13006
worker[2] > FREE
worker[2] > mtr_ping_port: 13011
worker[1] > FREE
worker[1] > mtr_ping_port: 13007
worker[2] > FREE
worker[2] > mtr_ping_port: 13012
worker[1] > FREE
worker[1] > mtr_ping_port: 13008
worker[2] > FREE
worker[2] > mtr_ping_port: 13013
worker[1] > FREE
worker[1] > mtr_ping_port: 13009
worker[2] > FREE
worker[2] > mtr_ping_port: 13014
worker[1] > FREE
worker[3] > mtr_ping_port: 13020
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[2] > FREE
worker[2] > mtr_ping_port: 13015
worker[3] > FREE
worker[3] > mtr_ping_port: 13021
worker[2] > FREE
worker[2] > mtr_ping_port: 13016
worker[3] > FREE
worker[3] > mtr_ping_port: 13022
worker[2] > FREE
worker[2] > mtr_ping_port: 13017
worker[4] > mtr_ping_port: 13030
> Client connected
worker[3] > FREE
worker[3] > mtr_ping_port: 13023
worker[2] > FREE
worker[2] > mtr_ping_port: 13018
worker[3] > FREE
worker[4] > FREE
worker[3] > mtr_ping_port: 13024
worker[4] > mtr_ping_port: 13031
> Client connected
worker[2] > FREE
worker[2] > mtr_ping_port: 13019
worker[3] > FREE
worker[3] > mtr_ping_port: 13025
> Client connected
worker[2] > FREE
worker[3] > FREE
worker[2] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
worker[3] > mtr_ping_port: 13026
> Client connected
worker[3] > FREE
worker[3] > mtr_ping_port: 13027
worker[3] > FREE
worker[3] > mtr_ping_port: 13028
worker[3] > FREE
worker[3] > mtr_ping_port: 13029
worker[3] > FREE
worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
worker[4] > FREE
worker[4] > mtr_ping_port: 13032
worker[4] > FREE
worker[4] > mtr_ping_port: 13033
worker[4] > FREE
worker[4] > mtr_ping_port: 13034
worker[4] > FREE
worker[4] > mtr_ping_port: 13035
worker[4] > FREE
worker[4] > mtr_ping_port: 13036
worker[4] > FREE
worker[4] > mtr_ping_port: 13037
worker[4] > FREE
worker[4] > mtr_ping_port: 13038
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[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[4] > result: , file_mode: 0
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) leftorker[4] > Running test: sphinx.sphinx
worker[4] > Setting timezone: DEFAULT
worker[4] > Cleaning datadirs...
worker[4] > clean_dir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/4/tmp
worker[4] > clean_dir: /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/tmp/4
worker[4] > Generating my.cnf from '/home/travis/build/openquery/mariadb-server/mysql-test/suite/sphinx/my.cnf'
worker[4] > MASTER_MYPORT = 16060
worker[4] > MASTER_MYSOCK = /home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/tmp/4/mysqld.1.sock
worker[4] > SPHINXSEARCH_PORT = 16061
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[4] > mysqld_start:  [' --plugin-load=ha_sphinx.so', '--sphinx ']
 
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[4] > Started [mysqld.1 - pid: 32082, winpid: 32082]
worker[4] > cmd: "/usr/local/bin/indexer" --config "/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/4/my_sphinx.conf" test1 > "/home/travis/build/openquery/mariadb-server/debug_build/mysql-test/var/4/searchd/sphinx-searchd.log" 2>&1
worker[1] > result: , file_mode: 0
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) leftorker[1] Server said BYE
worker[1] Restarting 
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) left Child closed socket
worker[3] > result: , file_mode: 0
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) leftorker[3] Server said BYE
worker[3] Restarting 
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) left Child closed socket
worker[4] > Started [sphinx-searchd - pid: 32089, winpid: 32089]
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[2] > result: , file_mode: 0
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) leftorker[2] Server said BYE
worker[2] Restarting 
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) left Child closed socket
worker[4] Started [check-mysqld_1 - pid: 32094, winpid: 32094]
worker[4] Got [check-mysqld_1 - pid: 32094, winpid: 32094, exit: 0]
worker[4] > Started [mysqltest - pid: 32098, winpid: 32098]
worker[4] > Got [mysqltest - pid: 32098, winpid: 32098, exit: 0]
worker[4] > Started [warnings-mysqld.1 - pid: 32102, winpid: 32102]
worker[4] Got [warnings-mysqld.1 - pid: 32102, winpid: 32102, exit: 15872]
worker[4] Started [check-mysqld_1 - pid: 32106, winpid: 32106]
worker[4] Got [check-mysqld_1 - pid: 32106, winpid: 32106, exit: 0]
worker[4] sphinx.sphinx                            w4 worker[4] [ pass ]     36
sphinx.sphinx                            w4 [ pass ]     36
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) leftorker[4] Server said BYE
worker[4] Restarting  [sphinx-searchd - pid: 32089, winpid: 32089] [mysqld.1 - pid: 32082, winpid: 32082]
pent 0:00:03 on 2 tests. 0:00:00 (0 tests) left Child closed socket
--------------------------------------------------------------------------
Spent 0.004 seconds on Test administration
Spent 0.342 seconds on Server stop/start
Spent 0.065 seconds on Test execution
Spent 0.253 seconds on Check-testcase
Spent 6.49 seconds on Collecting test cases
Spent 0.04 seconds on Check for warnings
Spent 0.495 seconds on Initialization/cleanup
The servers were restarted 0 times
Spent 0.036 of 3 seconds executing testcases
 
Completed: All 1 tests were successful

Generated at Thu Feb 08 07:24:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.