Thinking Sphinx : Error while indexing

Z@M

unread,

Jan 20, 2011, 6:38:37 AM1/20/11

to Thinking Sphinx

indexing index 'users_core'...
ERROR: index 'users_core': sql_range_query: Incorrect key file for
table '/tmp/#sql_ff2_0.MYI'; try to repair it (DSN=mysql://
root:***@localhost:3306/myname)

What does this means ?
I can't find the file '/tmp/#sql_ff2_0.MYI'
How do i repair it ?

Z@M

unread,

Jan 21, 2011, 8:42:31 AM1/21/11

to Thinking Sphinx

Mysql is taking 100% memory when i do rake ts:rebuild
also when i save the user model from console.
it eats up the /tmp memory and the system shows warning and ask for
disk cleanup
i am really worried about this behavior.
some body please help.

Pat Allan

unread,

Jan 21, 2011, 8:46:31 PM1/21/11

to thinkin...@googlegroups.com

How many records do you have in your users table? How long does indexing take? And what are the smallest and largest ids?
SELECT MIN(id), MAX(id) FROM users

--
Pat

> --
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>

Z@M

unread,

Jan 22, 2011, 2:24:32 AM1/22/11

to Thinking Sphinx

i have very few records .
< 50

Pat Allan

unread,

Jan 22, 2011, 6:24:14 AM1/22/11

to thinkin...@googlegroups.com

How have these records been created? Via fixtures?
http://freelancing-god.github.com/ts/en/common_issues.html#slow_indexing

And how long does indexing take?

--
Pat

Z@M

unread,

Jan 24, 2011, 1:44:01 AM1/24/11

to Thinking Sphinx

Indexing hangs system shows memmory is full and ask for a disk cleanup
then i will kill the process .
if i wait for say 10 mts it shows this error

indexing index 'users_core'...
ERROR: index 'users_core': sql_range_query: Incorrect key file for
table '/tmp/#sql_ff2_0.MYI'; try to repair it (DSN=mysql://
root:***@localhost:3306/myname)

When i created a new db and migrated the schema and start using it
from scratch it works fine .
i dont know whats created the problem last time .

when the system says memmory full . i went and checked the db/sphinx
folder size it was less than few mbs
so i wonder where the sphinx is storing the index.

On Jan 22, 4:24 pm, Pat Allan <p...@freelancing-gods.com> wrote:
> How have these records been created? Via fixtures?http://freelancing-god.github.com/ts/en/common_issues.html#slow_indexing

Pat Allan

unread,

Jan 24, 2011, 1:47:28 AM1/24/11

to thinkin...@googlegroups.com

Did you load your data via fixtures? Try adding the following to your config/sphinx.yml file (create it if it doesn't exist):
development:
sql_range_step: 10000000