MySQL Forums
Forum List  »  GIS

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

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

Written By
myisamchk segfaults on spatial index
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.