search

pat / thinking-sphinx

Sphinx/Manticore plugin for ActiveRecord/Rails
http://freelancing-gods.com/thinking-sphinx
MIT License
1.63k stars 470 forks source link

sql fetch row: out of space #1164

Closed atomical closed 4 years ago

atomical commented 4 years ago

Hi Pat,

We are seeing this error for one of our tables but it's significantly smaller than other tables indexed before it. It has about 1,500 records. When we set sql_range_step to 1 it indexes correctly but that slows down the indexing process for the other indexes. Any ideas?

 ** [out :: 192.168.157.127] indexing index 'kiosk_core'...
 ** [out :: 192.168.157.127] ERROR: index 'kiosk_core': sql_fetch_row: Error writing file '/tmp/MY3SPEwe' (Errcode: 28 - No space left on device).
 ** [out :: 192.168.157.127] total 0 docs, 0 bytes
 ** [out :: 192.168.157.127] total 2.035 sec, 0 bytes/sec, 0.00 docs/sec
 ** [out :: 192.168.157.127] total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
 ** [out :: 192.168.157.127] total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
 ** [out :: 192.168.157.127] 
 ** [out :: 192.168.157.127] The Sphinx indexing command failed:
 ** [out :: 192.168.157.127] Command: indexer --config "/var/www/shared/config/qa.sphinx.conf" kiosk_core --rotate
 ** [out :: 192.168.157.127] Status:  1
 ** [out :: 192.168.157.127] Output:  See above
 ** [out :: 192.168.157.127]
atomical commented 4 years ago

Found the issue. It was a join.

pat commented 4 years ago

Glad to know you got it figured out! And yeah, I was wondering if it was related to some SQL joins đŸ˜…