Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question