[MDEV-10986] sphinx.union-5539 and sphinx.sphinx fail in buildbot and outside Created: 2016-10-09  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - SphinxSE, Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Won't Fix Votes: 0
Labels: None


 Description    

sphinx.union-5539                        [ fail ]
 
        Test ended at 2016-10-09 17:24:41
 
 
 
CURRENT_TEST: sphinx.union-5539
 
--- /data/releases/mariadb-10.1.17-linux-glibc_214-x86_64/mysql-test/plugin/sphinx/sphinx/union-5539.result	2016-08-29 17:38:56.000000000 +0300
 
+++ /data/releases/mariadb-10.1.17-linux-glibc_214-x86_64/mysql-test/plugin/sphinx/sphinx/union-5539.reject	2016-10-09 17:24:41.368601488 +0300
 
@@ -5,10 +5,12 @@
 
 2	1	;mode=extended2;limit=1000000;maxmatches=500
 
 3	1	;mode=extended2;limit=1000000;maxmatches=500
 
 4	1	;mode=extended2;limit=1000000;maxmatches=500
 
+5	1	;mode=extended2;limit=1000000;maxmatches=500
 
 SELECT a.* FROM (SELECT * FROM ts si WHERE si.query='@* 123nothingtofind123;mode=extended2;limit=1000000;maxmatches=500') AS a UNION SELECT b.* FROM (SELECT * FROM ts si WHERE si.query=';mode=extended2;limit=1000000;maxmatches=500') AS b;
 
 id	w	query
 
 1	1	;mode=extended2;limit=1000000;maxmatches=500
 
 2	1	;mode=extended2;limit=1000000;maxmatches=500
 
 3	1	;mode=extended2;limit=1000000;maxmatches=500
 
 4	1	;mode=extended2;limit=1000000;maxmatches=500
 
+5	1	;mode=extended2;limit=1000000;maxmatches=500
 
 drop table ts;



 Comments   
Comment by Elena Stepanova [ 2016-11-06 ]

Also fail in buildbot:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/3865/steps/test/logs/stdio

sphinx.union-5539                        w4 [ fail ]
 
        Test ended at 2016-11-04 20:30:08
 
 
 
CURRENT_TEST: sphinx.sphinx
 
CURRENT_TEST: sphinx.sphinx
 
CURRENT_TEST: sphinx.union-5539
 
 
 
 
 
The server [sphinx-searchd - pid: 3073, winpid: 3073, exit: 256] crashed while running 'check testcase before test'
 
Server log from this test:
 
----------SERVER LOG START-----------
 
----------SERVER LOG END-------------
 
 
 
 
 
 - skipping '/usr/local/mariadb-10.2.3-linux-x86_64/mysql-test/var/4/log/sphinx.union-5539/'

Comment by Elena Stepanova [ 2017-01-04 ]

Another kind of failure:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-quantal-amd64/builds/4348/steps/test/logs/stdio

sphinx.sphinx                            w1 [ fail ]
 
        Test ended at 2017-01-04 06:25:45
 
 
 
CURRENT_TEST: sphinx.sphinx
 
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';
 
 
 
 - saving '/usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/1/log/sphinx.sphinx/' to '/usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/log/sphinx.sphinx/'

Happens at the beginning of tests, retry always works all right. Probably a timing issue with starting searchd.

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