MySQL Bugs: #73824: Crash on spatial view

Bug #73824	Crash on spatial view
Submitted:	6 Sep 2014 9:49	Modified:	15 Sep 2014 22:35
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.2.2-1ubu1404	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	crash, spatial

Description:
Workbench crashes when I select the spatial view.

How to repeat:
-- on 5.7.4-m14 running in mysql sandbox
use test;
create table test (id int, p point);
insert into test values(1, GeomFromText('POINT(1 1)'));
insert into test values(1, GeomFromText('POINT(1 2)'));
insert into test values(1, GeomFromText('POINT(1 3)'));
insert into test values(1, GeomFromText('POINT(2 3)'));
insert into test values(1, GeomFromText('POINT(2 2)'));
insert into test values(1, GeomFromText('POINT(2 1)'));
select * from test;

Then select the spatial view....and crash.

Core was generated by `/usr/bin/mysql-workbench-bin'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007fb5178abbb9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
56	../nptl/sysdeps/unix/sysv/linux/raise.c: No such file or directory.
(gdb) bt
#0  0x00007fb5178abbb9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#1  0x00007fb5178aefc8 in __GI_abort () at abort.c:89
#2  0x00007fb5181b76b5 in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#3  0x00007fb5181b5836 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#4  0x00007fb5181b5863 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#5  0x00007fb5181b5aa2 in __cxa_throw () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#6  0x00007fb51c7fa502 in spatial::Converter::change_projection(spatial::ProjectionView, OGRSpatialReference*, OGRSpatialReference*) () from /usr/lib/mysql-workbench/libwbpublic.so.6.2.2
#7  0x00007fb51c7fa02c in spatial::Converter::Converter(spatial::ProjectionView, OGRSpatialReference*, OGRSpatialReference*)
    () from /usr/lib/mysql-workbench/libwbpublic.so.6.2.2
#8  0x00007fb51e159a33 in SpatialDrawBox::render(bool) () from /usr/lib/mysql-workbench/libwbprivate.so.6.2.2
#9  0x00007fb51e1592c9 in SpatialDrawBox::do_render_layers(void*) () from /usr/lib/mysql-workbench/libwbprivate.so.6.2.2
#10 0x00007fb519ec2f15 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#11 0x00007fb518798182 in start_thread (arg=0x7fb4e1ced700) at pthread_create.c:312
#12 0x00007fb51796ffbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

From the stdout:
-----------------------------------------------------
terminate called after throwing an instance of 'std::logic_error'
  what():  Unable to perform specified transformation.

Aborted (core dumped)
-----------------------------------------------------

Hello Daniël,

Thank you for the report and test case.
Verified as described.

Thanks,
Umesh

// OS, package details

[root@ushastry coredir]# rpm -qa|grep mysql-workbench
mysql-workbench-community-6.2.2-1.el6.x86_64
[root@ushastry coredir]# cat /etc/*release
CentOS release 6.5 (Final)
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
CentOS release 6.5 (Final)
CentOS release 6.5 (Final)

[root@ushastry coredir]# mysql-workbench --log-level=3 -v
Ready.

terminate called after throwing an instance of 'std::logic_error'
  what():  Unable to perform specified transformation.

Fixed as of the upcoming MySQL Workbench 6.2.3 release, and here's the changelog entry:

Clicking the spatial view in the results tab could cause a crash.

Thank you for the bug report.

See also Oracle bug #19429414