Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
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;
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Summary | sphinx.union-5539 fails | sphinx.union-5539 and sphinx.sphinx fail in buildbot and outside |
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.
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.0 [ 16000 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.0 [ 16000 ] |
| Fix Version/s | 10.1 [ 16100 ] |
| Workflow | MariaDB v3 [ 77711 ] | MariaDB v4 [ 143491 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Won't Fix [ 2 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
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:08CURRENT_TEST: sphinx.sphinxCURRENT_TEST: sphinx.sphinxCURRENT_TEST: sphinx.union-5539The 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/'