Re: Strange error message for create-select query

2001-05-24 Thread Sinisa Milivojevic
brainheap writes: > Hi Sinisa! > > Sinisa Milivojevic wrote: > > > Yes it was. > I used myisamchk -o first > and myisamchk -r next - it repaired indexes as well > > but the result was the same :0( > It was corrupted ?? Can you try again CREATE from SELECT ?? Check out disk space too. Next

re: re: Strange error message for create-select query

2001-05-24 Thread brainheap
Hi Sinisa! Sinisa Milivojevic wrote: > > Then it is very much possible that a table from which you have done > SELECT is corrupted. Check it out. > Yes it was. I used myisamchk -o first and myisamchk -r next - it repaired indexes as well but the result was the same :0( Any other idea? Maybe

Re: Strange error message for create-select query

2001-05-23 Thread Sinisa Milivojevic
alex writes: > Hi ppl! > > I've a strange problem - I'm creating HEAP-type table and filling it > with the result of select query from a relatively big table > (containing ~2187000 records). > > The resulting error message is the following "Got error code 127 from > table handler" > And that's a

Re: Strange error message for create-select query

2001-05-23 Thread alex
Hi ppl! I've a strange problem - I'm creating HEAP-type table and filling it with the result of select query from a relatively big table (containing ~2187000 records). The resulting error message is the following "Got error code 127 from table handler" And that's all :0) I'm just wondering what