Bug #38092 *gis (main.gis, ndb.ndb_gis, main.archive_gis, main.innodb_gis) tests fail

• Submitted: 14 Jul 2008 6:39
• Modified: 25 Dec 2009 5:57
• Reporter: Alexander Nozdrin
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0-BK
• OS: Solaris (x86)
• Assigned to: Alexey Kopytov
• CPU Architecture: Any
• Tags: disabled, pb2, pushbuild, test failure, tf54

[14 Jul 2008 6:39] Alexander Nozdrin

Description:
ndb.ndb_gis fails randomly with different symptoms.

See also: Bug#32789.

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=ndb.ndb_gis

[12 Feb 2009 14:36] Jonathan Miller

Does this still happen?

[18 Feb 2009 17:52] Alexander Nozdrin

Symptoms:
-------------------------------------------------
@@ -326,8 +326,8 @@
 116	0
 SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
 fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
+117	POINT(55.58852775304245 17.42653606411398)
+118	POINT(55.58852775304245 17.42653606411398)
 119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
@@ -878,8 +878,8 @@
 116	0
 SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon ORDER by fid;
 fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
+117	POINT(55.58852775304245 17.42653606411398)
+118	POINT(55.58852775304245 17.42653606411398)
 119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon ORDER by fid;
 fid	Area(g)
-------------------------------------------------

XRef2: http://tinyurl.com/apngnb

[18 Feb 2009 18:23] Alexander Nozdrin

Ok, it looks like, the problem now has nothing to do
with the problem reported originally. Also, I doubt,
it's a Cluster issue. It seems like something wrong
with GIS support in the server.

The following tests fail with similar symptoms: main.gis,
main.archive_gis, main.innodb_gis, ndb.ndb_gis).

It looks like the failures happen on Solaris 10/11
on x86 architecture only.

The symptoms are:
-----------------------------------------------------
@@ -318,8 +318,8 @@
 116	0
 SELECT fid, AsText(Centroid(g)) FROM gis_multi_polygon;
 fid	AsText(Centroid(g))
-117	POINT(55.58852775304245 17.426536064113982)
-118	POINT(55.58852775304245 17.426536064113982)
+117	POINT(55.58852775304245 17.42653606411398)
+118	POINT(55.58852775304245 17.42653606411398)
 119	POINT(2 2)
 SELECT fid, Area(g) FROM gis_multi_polygon;
 fid	Area(g)
@@ -655,7 +655,7 @@
 select object_id, geometrytype(geo), ISSIMPLE(GEO), ASTEXT(centroid(geo)) from
 t1 where object_id=85984;
 object_id	geometrytype(geo)	ISSIMPLE(GEO)	ASTEXT(centroid(geo))
-85984	MULTIPOLYGON	0	POINT(-114.87787186923313 36.33101763469049)
+85984	MULTIPOLYGON	0	POINT(-114.87787186923329 36.331017634690426)
 drop table t1;
 create table t1 (fl geometry not null);
 insert into t1 values (1);
-----------------------------------------------------

[3 Jul 2009 6:13] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090702084644-k95gd2asolvz2zpu) (version source revid:[e-mail]-20090625114553-z4ief5ojwoutyafc) (merge vers: 5.4.4-alpha) (pib:11)

[9 Jul 2009 7:34] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090702084644-k95gd2asolvz2zpu) (version source revid:[e-mail]-20090625114553-z4ief5ojwoutyafc) (merge vers: 5.4.4-alpha) (pib:11)

[25 Dec 2009 5:57] Alexey Kopytov

Fixed in both mysql-next-mr and mysql-6.0-coodebase when backporting WL#2934 to mysql-next-mr.