MySQL Bugs: #5532: Error 22 from storage handler when inserting GIS data

Bug #5532	Error 22 from storage handler when inserting GIS data
Submitted:	12 Sep 2004 19:24	Modified:	24 Sep 2004 14:33
Reporter:	Georg Richter	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.4/5.0.2	OS:	Linux (Linux)
Assigned to:	Alexey Botchkov	CPU Architecture:	Any

Description:
Last insert command fails with error 22 from storage handler (see how to repeat). 
Thanks to Ian McIntosh for reporting this bug. 

How to repeat:
DROP TABLE IF EXISTS points_test; 
CREATE TABLE points_test (Coordinates POINT NOT NULL, SPATIAL INDEX(Coordinates)); 
INSERT INTO points_test VALUES(GeomFromText('POINT(383293632 1754448)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(564952612 157516260)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(903994614 180726515)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(98128178 141127631)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(862547902 799334546)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(341989013 850270906)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(803302376 93039099)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(857439153 817431356)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(319757546 343162742)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(826341972 717484432)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(305066789 201736238)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(626068992 616241497)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(55789424 755830108)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(802874458 312435220)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(153795660 551723671)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(242207428 537089292)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(553478119 807160039)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(694605552 457472733)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(987886554 792733729)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(598600363 850434457)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(592068275 940589376)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(700705362 395370650)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(33628474 558144514)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(212802006 353386020)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(901307256 39143977)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(70870451 206374045)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(240880214 696939443)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(822615542 296669638)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(452769551 625489999)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(609104858 606565210)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(177213669 851312285)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(143654501 730691787)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(658472325 838260052)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(188164520 646358878)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(630993781 786764883)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(496793334 223062055)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(727354258 197498696)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(618432704 760982731)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(755643210 831234710)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(114368751 656950466)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(870378686 185239202)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(863324511 111258900)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(882178645 685940052)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(407928538 334948195)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(311430051 17033395)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(941513405 488643719)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(868345680 85167906)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(219335507 526818004)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(923427958 407500026)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(173176882 554421738)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(194264908 669970217)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(777483793 921619165)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(867468912 395916497)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(682601897 623112122)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(227151206 796970647)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(280062588 97529892)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(982209849 143387099)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(208788792 864388493)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(829327151 616717329)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(199336688 140757201)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(633750724 140850093)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(629400920 502096404)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(226017998 848736426)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(28914408 149445955)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(256236452 202091290)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(703867693 450501360)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(872061506 481351486)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(372120524 739530418)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(877267982 54722420)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(362642540 104419188)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(851693067 642705127)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(201949080 833902916)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(786092225 410737872)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(698291409 615419376)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(27455201 897628096)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(756176576 661205925)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(38478189 385577496)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(163302328 264496186)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(234313922 192216735)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(413942141 490550373)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(394308025 117809834)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(941051732 266369530)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(599161319 313172256)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(5899948 476429301)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(367894677 368542487)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(580848489 219587743)')); 
INSERT INTO points_test VALUES(GeomFromText('POINT(11247614 782797569)')); 
 
ERROR 1030 at line 89: Got error 22 from storage engine

Verified against latest 5.0 BK source.

bk commit - 4.1 tree (hf:1.2000) BUG#5532

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html