Delta Indexing and Reindexing of DB is failing

Patrick's Avatar

Patrick

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 (http://sphinxsearch.com)

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 "ec2-107-20-192-196.compute-1.amazonaws.com" (10.83.130.151) and accepting
TCP/IP connections on port 5432?

(DSN=pgsql://onpojfoiuu:***@ec2-107-20-192-196.compute-1.amazonaws.com:5...). 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

    http://support.flying-sphinx.com/discussions/problems/395-delta-ind...

  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.

    Cheers

    Pat

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

Generic

? 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