Delta Indexing and Reindexing of DB is failing

Patrick's Avatar


12 Nov, 2012 04:38 PM

Indexing of the database has been failing. In looking though the index logs all are returning a timeout error like the one below

@@@ruby Sphinx 2.1.0-dev (r3006)
Copyright (c) 2001-2011, Andrew Aksyonoff
Copyright (c) 2008-2011, Sphinx Technologies Inc (

using config file '/mnt/local/flying-sphinx/8795611df59f01b4d/sphinx.conf'...
indexing index 'article_delta'...
ERROR: index 'article_delta': sql_connect: could not connect to server: Connection timed out

Is the server running on host "" ( and accepting
TCP/IP connections on port 5432?

(DSN=pgsql://onpojfoiuu:*** total 0 docs, 0 bytes
total 189.478 sec, 0 bytes/sec, 0.00 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

  1. 1 Posted by pat on 12 Nov, 2012 04:47 PM

    pat's Avatar

    Sorry I created this without having signed into an account, see the full support ticket here

  2. 2 Posted by pat on 12 Nov, 2012 04:52 PM

    pat's Avatar

    I was able to solve this work a fs:rebuild

  3. Support Staff 3 Posted by Pat Allan on 12 Nov, 2012 09:50 PM

    Pat Allan's Avatar

    Great to hear, Pat. Any further issues, do let me know.



Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac