zhipenggan / sphinxsearch Goto Github PK

What steps will reproduce the problem?
1. запустил Sphinx
2. запустил ротатор
3. просматриваю данные через SphinxQL - ничего 
не изменилось 

What is the expected output? What do you see instead?
Обновление данных

What version of the product are you using? On what operating system?
2.0.* любая из них

Please provide any additional information below.

Может проблема что у меня Хакинтош конечно 
же - но вот лог запуска


Запуск SearchD

[Mon Apr 30 11:26:46.937 2012] [23537] Child process 23538 has been forked
[Mon Apr 30 11:26:46.938 2012] [23538] listening on all interfaces, port=3134
[Mon Apr 30 11:26:46.939 2012] [23538] listening on all interfaces, port=9306
[Mon Apr 30 11:26:47.186 2012] [23538] rotating index 'movie': success
[Mon Apr 30 11:26:47.208 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.001
[Mon Apr 30 11:26:47.208 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.208 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.001; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.002
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.002; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.003
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.003; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.003
[Mon Apr 30 11:26:47.209 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.003; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.004
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.004; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: replaying log 
/usr/local/var/data/binlog.004
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: replay stats: 0 rows in 0 
commits; 0 updates; 0 indexes
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: finished replaying 
/usr/local/var/data/binlog.004; 0.0 MB in 0.000 sec
[Mon Apr 30 11:26:47.210 2012] [23538] binlog: finished replaying total 6 in 
0.002 sec
[Mon Apr 30 11:26:47.246 2012] [23538] accepting connections


Запуск первый раз ротатора

[Mon Apr 30 11:27:28.858 2012] [23538] caught SIGHUP (seamless=1, in queue=1)
[Mon Apr 30 11:27:28.901 2012] [23538] rotating index 'movie': started


Запуск второй раз ротатора 

[Mon Apr 30 11:27:54.530 2012] [23538] caught SIGHUP (seamless=1, in queue=2)
[Mon Apr 30 11:31:19.698 2012] [23538] caught SIGHUP (seamless=1, in queue=3)


Сюда же могу еще добавить что по не 
понятным причинам - не всегда срабатывает 
Searchd --stop 

What steps will reproduce the problem?
1. In Sphinx 1.10-beta conf create a source and add a sql_field_string = field
2. In PHP Client API (version from 2010-06-29 14:08:19) try to use 
$cl->SetFilter('field', array('value'));
3. Get Assertion Failed errors

What is the expected output? What do you see instead?

I was expecting to see the result set, instead I see no results (and the 
Assertions errors)

What version of the product are you using? On what operating system?

1.10-beta on Linux 32bit with PHP API version from 2010-06-29 14:08:19

Please provide any additional information below.

As far as I understood Sphinx 1.10-beta "added string attributes support 
(sql_attr_string, sql_field_string, xml_attr_string, xml_field_string 
directives)" however the PHP API cannot use string filters.

I also try using the lastest PHP API from trunk (today 24th Feb 2011) without 
success.

What steps will reproduce the problem?
Install tarball 

What is the expected output? What do you see instead?
Indexer should report 2.0.8 (r3831)
Indexer is reporting 2.0.9 (r3832)


What version of the product are you using? On what operating system?
Well, not sure... is it 2.0.9 or 2.0.8?


Please provide any additional information below.
I don't have a problem with it being 2.0.9 - but I want to make sure the RPM 
for Fedora is labelled correctly before it is placed in the repository.

[mysqlse/ha_sphinx.cc:2251] -> [mysqlse/ha_sphinx.cc:2243]: (error) Possible 
null pointer dereference: pTls - otherwise it is redundant to check it against 
null.
[api/libsphinxclient/sphinxclient.c:2351]: (error) Memory leak: result
[src/indextool.cpp:974] -> [src/indextool.cpp:969]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:977] -> [src/indextool.cpp:969]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:978] -> [src/indextool.cpp:969]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1056] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1059] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1060] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1062] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1063] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1068] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indextool.cpp:1069] -> [src/indextool.cpp:1053]: (error, inconclusive) 
Possible null pointer dereference: pIndex - otherwise it is redundant to check 
it against null.
[src/indexer.cpp:922] -> [src/indexer.cpp:915]: (error, inconclusive) Possible 
null pointer dereference: pTokenizer - otherwise it is redundant to check it 
against null.
[src/indexer.cpp:926] -> [src/indexer.cpp:915]: (error, inconclusive) Possible 
null pointer dereference: pTokenizer - otherwise it is redundant to check it 
against null.
[src/indexer.cpp:952] -> [src/indexer.cpp:949]: (error, inconclusive) Possible 
null pointer dereference: pDict - otherwise it is redundant to check it against 
null.
[src/llsphinxjson.c:1328] -> [src/llsphinxjson.c:1325]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1333] -> [src/llsphinxjson.c:1325]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1334] -> [src/llsphinxjson.c:1325]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1337] -> [src/llsphinxjson.c:1325]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1546] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1547] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1548] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1549] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1550] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1551] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1552] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1553] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1554] -> [src/llsphinxjson.c:1543]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxjson.c:1607] -> [src/llsphinxjson.c:1601]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2136] -> [src/llsphinxql.c:2133]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2141] -> [src/llsphinxql.c:2133]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2142] -> [src/llsphinxql.c:2133]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2145] -> [src/llsphinxql.c:2133]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2354] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2355] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2356] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2357] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2358] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2359] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2360] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2361] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2362] -> [src/llsphinxql.c:2351]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/llsphinxql.c:2415] -> [src/llsphinxql.c:2409]: (error, inconclusive) 
Possible null pointer dereference: b - otherwise it is redundant to check it 
against null.
[src/indexer.cpp:1508]: (error) Resource leak: fp
[src/sphinxexcerpt.cpp:413] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:414] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:415] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:416] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:417] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:418] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:420] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:421] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:422] -> [src/sphinxexcerpt.cpp:410]: (error) Possible 
null pointer dereference: pWord - otherwise it is redundant to check it against 
null.
[src/sphinxexcerpt.cpp:424] -> [src/sphinxexcerpt.cpp:410]: (error, 
inconclusive) Possible null pointer dereference: pWord - otherwise it is 
redundant to check it against null.
[src/sphinxsort.cpp:1251] -> [src/sphinxsort.cpp:1254]: (error) Possible null 
pointer dereference: sSrc - otherwise it is redundant to check it against null.
[src/sphinxcustomsort.inl:22]: (error) Passing value 0.0 to log() leads to 
undefined result.
[src/sphinxsort.cpp:2462]: (error) Uninitialized variable: aa
[src/sphinxsort.cpp:2462]: (error) Uninitialized variable: bb
[src/sphinxrt.cpp] -> [src/sphinxrt.cpp:5117]: (error) Internal error. 
Token::Match called with varid 0. Please report this to Cppcheck developers
[src/sphinxsearch.cpp:792]: (error) Possible null pointer dereference: pCurEx
[src/sphinxutils.cpp:1459] -> [src/sphinxutils.cpp:1451]: (error, inconclusive) 
Possible null pointer dereference: sOptConfig - otherwise it is redundant to 
check it against null.
[src/tests.cpp:1833] -> [src/tests.cpp:1831]: (error, inconclusive) Possible 
null pointer dereference: fpRes - otherwise it is redundant to check it against 
null.
[src/tests.cpp:175]: (error) Buffer is accessed out of bounds: dTests
[src/tests.cpp:199]: (error) Buffer is accessed out of bounds: dTests2
[src/tests.cpp:260]: (error) Buffer is accessed out of bounds: dTestsShort

wordbreaker breaks on long line 
and it is also generally not possible to use dicts bigger than 512 chars.

What steps will reproduce the problem?
1. use a line longer than 512 chars in the dict file (aka wordbreaker-dict.txt)
2. if chat at 511 is not a "space", one gets "bad freqdict line: zero freq"

What is the expected output? 
- program runs
What do you see instead?
- program breaks with "bad freqdict line: zero freq"

What version of the product are you using? 
- development
On what operating system?
- linux
Please provide any additional information below.
- program should support also multi-lines dict files.
- program should read line by line till end of file.

В sphinxapi.php в 0.9.9 в function SetRankingMode ( $ranker ) 
отсутствуют ранки SPH_RANK_MATCHANY и SPH_RANK_FIELDMASK.

The purpose of this place only to be the public mirror of SVN rep of
sphinx. The others posibilities here (Wiki, Issues) actually don't used by
developers.

Refer to original bugtrack of sphinxsearch here:
http://www.sphinxsearch.com/bugs/main_page.php

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

Данный репозиторий является лишь 
публичным зеркалом SVN репозитория проекта
sphinx, и его багтрэкер не поддерживается 
разработчиком. Техническая
поддержка, а также официальный багтрэкер 
доступны на веб-странице проекта:
http://www.sphinxsearch.com

What steps will reproduce the problem?

  1. Install sphinxsearch on Debian
  2. Make start at boot, add test index, enable in /etc/default/sphinxsearch
  3. Reboot

What is the expected output? What do you see instead?

  using config file '/etc/sphinxsearch/sphinx.conf'...
  FATAL: failed to create pid file '/var/run/sphinxsearch/searchd.pid': No such file or directory
  ERROR.

What version of the product are you using? On what operating system?

  Those Debian builds on sphinxsearch.com (sphinxsearch_2.1.3-release-1~wheezy_amd64.deb in particular). Packages from Debian repositories are OK.

Please provide any additional information below.

  Here's the part of init-script from repository package that site package misses (comes after "set -e"):

# Make sure the pidfile directory exists with correct permissions
piddir=`dirname "$PIDFILE"`
if [ ! -d "$piddir" ]; then
    mkdir -p "$piddir"
    chown -R sphinxsearch "$piddir"
    chgrp -R sphinxsearch "$piddir"
fi

Note that /run (/var/run is its symlink) is mounted as tmpfs, so it's not 
persistent and init-script should check the path for $PIDFILE.

http://code.google.com/p/sphinxsearch/source/browse/trunk/api/sphinxapi.py#949

sdds

When the Sphinx Python API fails to connect to the Sphinx server, a 
UnboundLocalError happens because a variable isn't correctly assigned... This 
shouldn't happen at all.. 

_Connect() method:

        try:
                        ........
            sock = socket.socket ( af, socket.SOCK_STREAM )   <--- this raises socket.error
            sock.settimeout ( self._timeout )
            sock.connect ( addr )
        except socket.error, msg:
            if sock:                  <--- sock doesn't exist!!! UnboundLocalError will be raised
                sock.close()
            self._error = 'connection to %s failed (%s)' % ( desc, msg )
            return


Solution:
Just assign the sock variable first to None to make sure is exists.

Put
    sock = None
before the try statement:

                sock = None
        try:
                        ........
            sock = socket.socket ( af, socket.SOCK_STREAM )
            sock.settimeout ( self._timeout )
            sock.connect ( addr )
        except socket.error, msg:
            if sock:
                sock.close()
            self._error = 'connection to %s failed (%s)' % ( desc, msg )
            return

What steps will reproduce the problem?
1. try in INSERT INTO rt (id, mva) VALUES (1,1)  /* instead of VALUES (1,(1)) */
2. read the error message

What is the expected output? What do you see instead?
expected: "row 1, column 3: non-MVA value specified for a MVA column"
obtained: "raw 1, column 3: non-MVA value specified for a MVA column"

also change the corresponding test, cf.
https://code.google.com/p/sphinxsearch/source/search?q=non-mva&origq=non-mva&btn
G=Search+Trunk

dsdad

Возможен ли релиз онлайн или GUI оболочки 
для быстрого конифгурирования индексов 
путей и т.д. в sphinx.conf ?

What steps will reproduce the problem?
1. We have an index split into 4 parts that contains 50 million documents total

2. We index these indexes with hitlesswords = /hitless.txt

3. Sphinx crashes immediately upon accepting connections, the daemon restarts, 
then crashes again (over and over) 

We tested this on sphinx 2.1.6, but also updated to the latest release in 
branch 121 and the problem still exists (2.1.7) rel121-r4614

Here is our crash from the logs:

-------------- backtrace begins here ---------------
Program compiled with gcc 4.4.7
Configured with flags: '--with-mysql' '--enable-id64'
Host OS is Linux sph07 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 
2014
x86_64 x86_64 x86_64 GNU/Linux
Stack bottom = 0x7f0b0eff6dbf, thread stack size = 0x800000
Trying manual backtrace:
Something wrong with thread stack, manual backtrace may be incorrect 
(fp=0x7f0b0eff4960)
Stack looks OK, attempting backtrace.
0x41a563
0x665c4d
0x6660ae
0x6588ee
0x659df4
0x6860ef
0x65b6d2
0x4cccb9
0x4d528e
0x43b6e0
0x43be68
0x58eeed
0x7f0eefc0c9d1
Something wrong in frame pointers, manual backtrace failed (fp=0)
Trying system backtrace:
begin of system symbols:
searchd[0x585034]
searchd(_ZN16SphCrashLogger_c11HandleCrashEi+0x1c3)[0x41a563]
/lib64/libpthread.so.0(+0xf710)[0x7f0eefc14710]
searchd[0x665c4d]
searchd[0x6660ae]
searchd[0x6588ee]
searchd[0x659df4]
searchd[0x6860ef]
searchd[0x65b6d2]
searchd[0x4cccb9]
searchd[0x4d528e]
searchd[0x43b6e0]
searchd(_Z21LocalSearchThreadFuncPv+0x78)[0x43be68]
searchd(_Z20sphThreadProcWrapperPv+0x1d)[0x58eeed]
/lib64/libpthread.so.0(+0x79d1)[0x7f0eefc0c9d1]
[Mon Mar 17 12:16:47.928 2014] [27033] Child process 28044 has been killed with 
signal
11, will be restarted
[Mon Mar 17 12:16:47.928 2014] [27033] Child process 28187 has been forked
[Mon Mar 17 12:16:47.929 2014] [28187] listening on all interfaces, port=9311
[Mon Mar 17 12:16:47.929 2014] [28187] listening on all interfaces, port=9312
[Mon Mar 17 12:16:47.929 2014] [28187] WARNING: index 'idx1_template': key 
'path' not
found - NOT SERVING
[Mon Mar 17 12:17:01.216 2014] [28187] WARNING: index 'idxUK1_template': key 
'path' not
found - NOT SERVING
[Mon Mar 17 12:17:01.797 2014] [28187] WARNING: index 'idxCA1_template': key 
'path' not
found - NOT SERVING
[Mon Mar 17 12:17:04.066 2014] [28187] accepting connections
------- FATAL: CRASH DUMP -------
[Mon Mar 17 12:17:05.216 2014] [28187]

--- crashed SphinxAPI request dump ---
AAABHQAACQYAAAAAAAAABAAAAAAAAAAAAAAAZAAAAAYAAAAAAAAABAAAAA5yZWxldmFuY2UgZGVzYwAA
AG5AKGtl
eXdvcmQsa2V5d29yZHMsYnJhbmQsbWVyY2hhbnQsY2F0ZWdvcnksc2VycFF1ZXJ5LGNlbGVicml0eSkg
c2Vhc29uaW5nICBAbWVyY2hhbnQgKCgiIF5HYW5kZXIrTW91bnRhaW4kICIpKQAAAAAAAAAHZGlzdF9V
UwAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAJcHJvZHVjdGlkAAAD6AAAAA5yZWxldmFuY2Ug
ZGVzYwAAAAAAAAADAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAFAAAAB2tleXdvcmQAAABkAAAACXNl
cnBRdWVyeQAAADIAAAAIY2F0ZWdvcnkAAAABAAAABWJyYW5kAAAACgAAAAhrZXl3b3JkcwAAADIAAAAA
AAAAAAAAAMwqLCBAd2VpZ2h0ICogKCgoMyAqIG1lcmNoYW50V2VpZ2h0KSArIGJyYW5kV2VpZ2h0KSAv
IDQpIEFTIHJlbGV2YW5jZSwgTUlOKHByaWNlKSBBUyBtaW5QcmljZSwgTUFYKHByaWNlKSBBUyBtYXhQ
cmljZSwgTUlOKHByaWNlX3NhbGUpIEFTIG1pblByaWNlU2FsZSwgTUFYKHByaWNlX3NhbGUpIEFT
IG1heFByaWNlU2FsZSwgQGNvdW50IEFTIGdyb3VwQ291bnQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AABlAAAABgAAAAAAAAAEAAAADnJlbGV2YW5jZSBkZXNjAAAAbkAoa2V5d29yZCxrZXl3b3JkcyxicmFu
ZCxtZXJjaGFudCxjYXRlZ29yeSxzZXJwUXVlcnksY2VsZWJyaXR5KSBzZWFzb25pbmcgIEBtZXJjaGFu
dCAoKCIgXkdhbmRlcitNb3VudGFpbiQgIikpAAAAAAAAAAdkaXN0X1VTAAAAAQAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAABAAAAAVicmFuZAAAAGUAAAAQYnJhbmRXZWlnaHQgZGVzYwAAAAAAAAADAAAAZAAA
AAAAAAAAAAAAAAAAAAAAAAAFAAAAB2tleXdvcmQAAABkAAAACXNlcnBRdWVyeQAAADIAAAAIY2F0ZWdv
cnkAAAABAAAABWJyYW5kAAAACgAAAAhrZXl3b3JkcwAAADIAAAAAAAAAAAAAAMwqLCBAd2VpZ2h0ICog
KCgoMyAqIG1lcmNoYW50V2VpZ2h0KSArIGJyYW5kV2VpZ2h0KSAvIDQpIEFTIHJlbGV2YW5jZSwg
TUlOKHByaWNlKSBBUyBtaW5QcmljZSwgTUFYKHByaWNlKSBBUyBtYXhQcmljZSwgTUlOKHByaWNlX3Nh
bGUpIEFTIG1pblByaWNlU2FsZSwgTUFYKHByaWNlX3NhbGUpIEFTIG1heFByaWNlU2FsZSwgQGNvdW50
IEFTIGdyb3VwQ291bnQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABlAAAABgAAAAAAAAAEAAAADnJl
bGV2YW5jZSBkZXNjAAAAbkAoa2V5d29yZCxrZXl3b3JkcyxicmFuZCxtZXJjaGFudCxjYXRlZ29y
eSxzZXJwUXVlcnksY2VsZWJyaXR5KSBzZWFzb25pbmcgIEBtZXJjaGFudCAoKCIgXkdhbmRlcitNb3Vu
dGFpbiQgIikpAAAAAAAAAAdkaXN0X1VTAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAhjYXRl
Z29yeQAAAGUAAAAPZ3JvdXBDb3VudCBkZXNjAAAAAAAAAAMAAABkAAAAAAAAAAAAAAAAAAAAAAAAAAUA
AAAHa2V5d29yZAAAAGQAAAAJc2VycFF1ZXJ5AAAAMgAAAAhjYXRlZ29yeQAAAAEAAAAFYnJhbmQA
AAAKAAAACGtleXdvcmRzAAAAMgAAAAAAAAAAAAAAzCosIEB3ZWlnaHQgKiAoKCgzICogbWVyY2hhbnRX
ZWlnaHQpICsgYnJhbmRXZWlnaHQpIC8gNCkgQVMgcmVsZXZhbmNlLCBNSU4ocHJpY2UpIEFTIG1pblBy
aWNlLCBNQVgocHJpY2UpIEFTIG1heFByaWNlLCBNSU4ocHJpY2Vfc2FsZSkgQVMgbWluUHJpY2VTYWxl
LCBNQVgocHJpY2Vfc2FsZSkgQVMgbWF4UHJpY2VTYWxlLCBAY291bnQgQVMgZ3JvdXBDb3VudAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGUAAAAGAAAAAAAAAAQAAAAOcmVsZXZhbmNlIGRlc2MAAABu
QChrZXl3b3JkLGtleXdvcmRzLGJyYW5kLG1lcmNoYW50LGNhdGVnb3J5LHNlcnBRdWVyeSxjZWxlYnJp
dHkpIHNlYXNvbmluZyAgQG1lcmNoYW50ICgoIiBeR2FuZGVyK01vdW50YWluJCAiKSkAAAAAAAAAB2Rp
c3RfVVMAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAACG1lcmNoYW50AAAAZQAAABNtZXJj
aGFudFdlaWdodCBkZXNjAAAAAAAAAAMAAABkAAAAAAAAAAAAAAAAAAAAAAAAAAUAAAAHa2V5d29yZAAA
AGQAAAAJc2VycFF1ZXJ5AAAAMgAAAAhjYXRlZ29yeQAAAAEAAAAFYnJhbmQAAAAKAAAACGtleXdvcmRz
AAAAMgAAAAAAAAAAAAAAzCosIEB3ZWlnaHQgKiAoKCgzICogbWVyY2hhbnRXZWlnaHQpICsgYnJhbmRX
ZWlnaHQpIC8gNCkgQVMgcmVsZXZhbmNlLCBNSU4ocHJpY2UpIEFTIG1pblByaWNlLCBNQVgocHJp
Y2UpIEFTIG1heFByaWNlLCBNSU4ocHJpY2Vfc2FsZSkgQVMgbWluUHJpY2VTYWxlLCBNQVgocHJpY2Vf
c2FsZSkgQVMgbWF4UHJpY2VTYWxlLCBAY291bnQgQVMgZ3JvdXBDb3VudAAAAAAAAAAAAAAAAAAAAAA=
--- request dump end ---
Sphinx 2.1.7-id64-dev (rel21-r4614)
Handling signal 11
-------------- backtrace begins here ---------------
Program compiled with gcc 4.4.7
Configured with flags: '--with-mysql' '--enable-id64'
Host OS is Linux sph07 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 
2014
x86_64 x86_64 x86_64 GNU/Linux
Stack bottom = 0x7f0af27f2dbf, thread stack size = 0x800000
Trying manual backtrace:

What steps will reproduce the problem?
1. Set logging format to sphinxQL
2. Execute query like SELECT * FROM foo WHERE foo_id IN ( 
1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,
1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,
1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,
1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,
1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,
1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,
1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,
1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,
1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,
1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,
1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,
1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,
1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,
1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,
1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,
1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,
1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,
1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,
1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,
1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,
1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,
1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,
1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,
1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,
1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,
1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,
1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,
1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,
1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,
1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,
1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,
1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,
1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,
1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,
1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,
1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,
1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,
1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,
1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,
1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,
1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,
1656,1657,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,
1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,
1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,
1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,
1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,
1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,
1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,
1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,
1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,
1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,
1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,
1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,
1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,
1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,
1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,
1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,
1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,
1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,
1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,
1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,
1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,
1992,1993,1994,1995,1996,1997,1998,1999,2000)

What is the expected output? What do you see instead?
Sphinx crashes. 

What version of the product are you using? On what operating system?
Sphinx 2.0.1-beta

Please provide any additional information below.
In StringBuffer_c::Append, iLen > 0, assert is compiled out, buffer overflow 
occurs. 
Patch is in attached file (with other modifications)

What steps will reproduce the problem?
1. follow installation guide in documentation

What is the expected output?
SphinxSE in MySql engines

What do you see instead?
No SphinxSe in MySql engines

What version of the product are you using? On what operating system?
0.0.0-rc2

Please provide any additional information below.
In file mysqlse/CMakeLists.txt change (last) line

ADD_LIBRARY(sphinx ha_sphinx.cc)

to (2 lines)

INCLUDE("${PROJECT_SOURCE_DIR}/storage/mysql_storage_engine.cmake")
MYSQL_STORAGE_ENGINE(SPHINX)

What steps will reproduce the problem?

  SELECT id AS id FROM my_index

Other variants w/o AS, with backquoted alias, alias in different case result in 
the same error. However if alias is different from case-insensitive "id" the 
query works.

What is the expected output? What do you see instead?

  ERROR 1064 (42000): sphinxql: syntax error, unexpected ID, expecting IDENT near 'id from my_index'

What version of the product are you using? On what operating system?

"2.0.4-1.1ubuntu1 (raring)" worked correctly. Current stable 
"2.1.3-release-1~wheezy" has the regression. The bug can be related to 
http://sphinxsearch.com/bugs/view.php?id=1264.

Also note that such alias can make no sense for hand-written queries it can be 
produces by a SQL generation utility.

bug WARNING: 'mem_limit = 1G' parse error 'G'

I want to know what is the difference between ranking, sorting, matching modes 
and filtering in Sphinx and how can I do more than one thing at a time.

In documentation also, it is written you can do ranking and sorting 
simultaneously. How is it possible because if I rank then results will be 
arranged in some order and if I do sorting the results will be arranged in some 
different order.

If possible please explain using some example. I am using version 2.1.9.


Please don't refer me to Sphinx documentation. I have already read it.

Every answer is appreciated.

Thanks in advance.

What steps will reproduce the problem?
1. I am using test.php api of sphinx
2. When i search for any keyword it gives me no result. 
3. Same thing i did with command "search test" in command line it shows me error
" index 'test1': search error: ."
If i run the same command like this 'search -q test', it give me the desired 
output. But not able to get the result in PHP API.

What is the expected output? What do you see instead?
Expected out put should be result array. But i get the below mentioned.
Array
(
    [error] => 
    [warning] => 
    [status] => 0
    [fields] => Array
        (
            [0] => title
            [1] => module_name
            [2] => search_content
        )

    [attrs] => Array
        (
            [sample_id] => 1
            [title] => 7
            [module_name] => 7
            [search_content] => 7
            [client_id] => 1
            [date_added_ts] => 1
            [date_modified_ts] => 1
            [date_published_ts] => 1
        )

    [total] => 0
    [total_found] => 0
    [time] => 0.000
    [words] => Array
        (
            [5] => Array
                (
                    [docs] => 3
                    [hits] => 3
                )

            [test] => Array
                (
                    [docs] => 20
                    [hits] => 49
                )

        )

)

What version of the product are you using? On what operating system?
I am using Sphinx 2.0.4-release (r3135) and Ubuntu 12.04 LTS

Please provide any additional information below.

Hi,

I would like to be able to fetch low level info from an index file built by 
sphinx. Things like, list of tokens, stemmed tokens, term frequency, document 
frequency and so forth. 

Is there an easy way to use sphinx as a library, not just a search daemon?

I know this is not the focus of the project, but If could have some pointers to 
how these data can be extracted, i'd be very glad.

thanks in advance.

Try to escape a string containing \\" sequences like 

\\"Yeah 
Yeah Yeahs\\"

and try to send a sphinx query '@t_text \\"Yeah yeah yeahs\\"   @ch_text 
(ch_id_15)', that contains that 
escaped string to the sphinx server. 

An error occurs. It looks like: 
 remote query error: index main_2: syntax error, unexpected TOK_FIELDLIMIT near '
  @ch_text (ch_id_15)';

After passing any string to the SphinxClient.EscapeString(String) method, we 
should get a string, that will 
be accepted in the shpinx query.

The issue is to be seen on the revision 2006 at least.

listening on 127.0.0.1:3312
WARNING: process shared mutex unsupported, MVA update disabled ( 
pthread_mutexattr_setpshared, errno = 22 )
precaching index 'topics'
precaching index 'delta'                                    
precached 2 indexes in 0.013 sec  

# uname -r
9.1-PRERELEASE

# grep -E "workers|mva" /usr/local/etc/sphinx.conf
    workers                 = prefork
    mva_updates_pool        = 32M

What steps will reproduce the problem?
1. is not going to the library

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

step 1 - build configure - sh buildconf.sh (good)
step 2 - configurate system request - ./configure (good)
step 3 - compliting source code (error)

# make
make  all-am
/bin/sh ./libtool --tag=CC    --mode=link gcc  -g -O2    -o test test.o 
.libs/libsphinxclient.a
libtool: link: gcc -g -O2 -o test test.o  .libs/libsphinxclient.a
.libs/libsphinxclient.a(sphinxclient.o)(.text+0x5eb): In function `set_error':
/root/libsphinxclient/sphinxclient.c:359: undefined reference to `_vsnprintf'
*** Error code 1

Stop in /root/libsphinxclient.
*** Error code 1

Stop in /root/libsphinxclient

mysql> show meta;
+---------------+---------------------------------------------------------------
---------------------------------------------------+
| Variable_name | Value                                                         
                                                   |
+---------------+---------------------------------------------------------------
---------------------------------------------------+
| warning       | sphinxql: syntax error, unexpected SYSVAR, expecting IDENT 
(or 16 other tokens) near '@@version_comment limit 1' |
| total         | 1000                                                          
                                                   |
| total_found   | 5065229                                                       
                                                   |
| time          | 0.072                                                         
                                                   |
+---------------+---------------------------------------------------------------
---------------------------------------------------+
4 rows in set (0.00 sec)

when it worked on distributed, get the result like this.
and just one table incorrect, the other tables not.
when i select this table, total_found number is right, but just output this 
error, i don't know why??

my gmail: [email protected]

waiting for your response.
thank you~

Hi,

There was an error while trying to autobuild your package:

> Start Time: 20100110-1742

[...]

> Build-Depends: debhelper (>= 7), autotools-dev, gawk, libmysqlclient-dev,
dpatch, libpq-dev, autoconf, libtool, automake, docbook-to-man

[...]

> Toolchain package versions: libc6.1-dev_2.10.2-2 linux-libc-dev_2.6.32-3
g++-4.4_4.4.2-9 gcc-4.4_4.4.2-9 binutils_2.20-4 libstdc++6_4.4.2-9
libstdc++6-4.4-dev_4.4.2-9
> 

[...]

> alpha-linux-gnu-g++  -g -O2 -D_FILE_OFFSET_BITS=64 -DNDEBUG  -Wl,-z,defs
-o indexer indexer.o libsphinx.a  -rdynamic -L/usr/lib/mysql -lmysqlclient
-L/usr/lib -lpq -lm -lz  -L/usr/local/lib -lrt  -lpthread
> alpha-linux-gnu-g++ -DHAVE_CONFIG_H -I. -I../config 
-DSYSCONFDIR="\"/etc/sphinxsearch\"" -I/usr/local/include
-I/usr/include/mysql  -DBIG_JOINS=1    -DUNIV_LINUX -DUNIV_LINUX
-I/usr/include/postgresql  -g -O2 -D_FILE_OFFSET_BITS=64 -DNDEBUG -MT
searchd.o -MD -MP -MF .deps/searchd.Tpo -c -o searchd.o searchd.cpp
> searchd.cpp: In function 'int ServiceMain(int, char**)':
> searchd.cpp:8399: error: cannot convert 'long int' to 'va_list' for
argument '3' to 'void sphLog(ESphLogLevel, const char*, va_list)'
> make[3]: *** [searchd.o] Error 1
> make[3]: Leaving directory
`/build/buildd-sphinxsearch_0.9.9-3-alpha-weq69Y/sphinxsearch-0.9.9/src'
> make[2]: *** [all] Error 2
> make[2]: Leaving directory
`/build/buildd-sphinxsearch_0.9.9-3-alpha-weq69Y/sphinxsearch-0.9.9/src'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory
`/build/buildd-sphinxsearch_0.9.9-3-alpha-weq69Y/sphinxsearch-0.9.9'
> make: *** [build-stamp] Error 2
> dpkg-buildpackage: error: debian/rules build gave error exit status 2

A full build log can be found at:
http://buildd.debian.org/build.php?arch=alpha&pkg=sphinxsearch&ver=0.9.9-3


Debian bugreport:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=564620

For example, we have index "index". If we pass "index " (with last space) to 
SphinxAPI, it passes it to sphinx as-is.
There seems also to be a bug in sphinx that was EXTREMELY difficult to find.
See code:
https://code.google.com/p/sphinxsearch/source/browse/trunk/src/searchd.cpp?r=251
2#5759
Sphinx thinks the search is multi-index (as there is a space), thus throws an 
error.