Delta Indexing and Reindexing of DB is failing

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. 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. I was able to solve this work a fs:rebuild

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

    Cheers

    Pat

Reply to this discussion Internal reply only staff will see it

Markdown

Attaching KB article:

» »

Read more…

Attach files

Up to 10MB each.

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

Recent Discussions