MySQL Forums
Forum List  »  GIS

myisamchk segfaults on spatial index
Posted by: Jean-Paul Le Fèvre
Date: May 23, 2005 01:44PM

Hi,
I'm currently working with mysql 5.0.4. I've a table with a geometry column (type point).
Since my table can be pretty big (nbr of rows > 20 millions) I've added a spatial index.

If I try to compress the table with myisampack I'm unable to rebuild the index with
myisamchk ( -r or -o) : it immediatly crashes with a Segmentation fault.

Before mass insertion I've tried to run myisamchk --keys-used=0 but once the insertion done
myisamchk segfaults when I want to recreate the index.

Index on other columns seem to be correctly handled my myisamchk.

Is there anything to do ?

Options: ReplyQuote


Subject
Views
Written By
Posted
myisamchk segfaults on spatial index
3570
May 23, 2005 01:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.