A
A
AHDPEu2013-02-15 08:44:00
linux
AHDPEu, 2013-02-15 08:44:00

Sphinx indexes are not saved when working with oracle via odbc driver

Sphinx worked at the screw server, through odbc the driver. Everything was great. There was a need to move to redhat.
odbc driver and oracle client libraries got up as it should, connection and query execution through sqlplus and isql are fine. From php through odbc requests are executed.

For the test, a simple query was written that returned 1 row.

id = 1
s_name = "st. Street, d. 666 "

In the logs, after" sql_fetch_row "nothing is written, what kind of error is not clear.

indexing index 'address'…
ERROR: index 'address': sql_fetch_row:. 0.060 sec, 663 bytes/sec, 16.58 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

No index files are created, there are write permissions to the folder.
Sinned on the locale, changed NLS_LANG. Tried both utf-8 and win1251. The error is always the same.
If you specify a non-existent folder, or a folder without access, the corresponding error is written to the log (no access, it is impossible to create a file)

I would be grateful for any hint.

PS
Version of Sphinx 2.0.6-release (r3473)

In general, I figured out the problem. Downgraded to version 2.0.5 - everything worked.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question