Bug #25792 | mysql server crashed on table(trigger) insert | ||
---|---|---|---|
Submitted: | 23 Jan 2007 17:50 | Modified: | 9 Jun 2008 16:31 |
Reporter: | Pablo Calder?n | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S1 (Critical) |
Version: | 5.0.27 | OS: | Linux (suse 10) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[23 Jan 2007 17:50]
Pablo Calder?n
[23 Jan 2007 18:01]
MySQL Verification Team
Thank you for the bug report. Could you please the complete test case script with table create statement and data insert if needed. Thanks in advance.
[23 Jan 2007 18:06]
Pablo Calder?n
struct evetoFinalTable: CREATE TABLE `eventoFinal` ( `id` int(11) NOT NULL auto_increment, `tipo` int(11) unsigned default NULL, `nalarma` int(11) unsigned default NULL, `idVehiculo` varchar(15) default NULL, `idRuta` varchar(13) default NULL, `x` double default NULL, `y` double default NULL, `fecha` varchar(12) default NULL, `hora` varchar(12) default '00:00:00', `leido` tinyint(4) default '0', `timeStamp` int(15) default NULL, `velocidad` int(11) default NULL, `timeRestore` int(15) default NULL, `heading` int(11) default NULL, `odometro` float default '0', `odometroReal` double default NULL, `gps` tinyint(1) default NULL, `gpsFix` tinyint(1) default NULL, `datosCola` tinyint(1) default NULL, `generico1` varchar(20) default NULL, `generico2` varchar(20) default NULL, `generico3` varchar(20) default NULL, `generico4` varchar(20) default NULL, `generico5` varchar(20) default NULL, `generico6` varchar(20) default NULL, `dig01` tinyint(1) default NULL, `dig02` tinyint(1) default NULL, `dig03` tinyint(1) default NULL, `dig04` tinyint(1) default NULL, `dig05` tinyint(1) default NULL, `dig06` tinyint(1) default NULL, `output1` tinyint(4) default NULL, `output2` tinyint(4) default NULL, `output3` tinyint(4) default NULL, `output4` tinyint(4) default NULL, PRIMARY KEY (`id`), KEY `fecha` (`fecha`), KEY `hora` (`hora`), KEY `x` (`x`), KEY `y` (`y`), KEY `key_time` (`timeStamp`), KEY `timeRestore` (`timeRestore`), KEY `nalarma` (`nalarma`), KEY `k1` (`idVehiculo`), KEY `k2` (`tipo`), KEY `odometroReal` (`odometroReal`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=225688 ; struct H_Evento: CREATE TABLE `H_Evento` ( `idEvento` bigint(20) NOT NULL, `idEventoTipo` smallint(5) unsigned NOT NULL default '0', `idMovil` varchar(15) default NULL, `timeStamp` int(15) unsigned default NULL, `velocidad` smallint(5) unsigned default NULL, `odometro` double default NULL, `lugar` varchar(100) default NULL, `sentido` varchar(30) default NULL, `idVehiculo` varchar(15) default NULL, `evento` varchar(100) default NULL, PRIMARY KEY (`idEvento`), KEY `key_movil` (`idMovil`), KEY `key_tiempo` (`timeStamp`), KEY `k1` (`idEventoTipo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Note: trigger "getDirecccion" is a udf function
[24 Jan 2007 16:37]
MySQL Verification Team
Thank you for the feedback. "Note: trigger "getDirecccion" is a udf function" So could you please provide the udf function code. Thanks in advance.
[25 Jan 2007 15:06]
Pablo Calder?n
I'd provide the udf source, but it use an static linked library. Any way the alloc memory is done in the init function using init->ptr. I have red about the alloc memory; but I do not know if using funtions besides the main function can cause troubles. If you still need the source we will sent you the link to download the mapserver library and the source. Thank you:
[31 Jan 2007 21:27]
MySQL Verification Team
Thank you for the feedback. "If you still need the source we will sent you the link to download the mapserver library and the source." Yes please provide it. Thanks in advance.
[2 Feb 2007 13:01]
Pablo Calder?n
udf source
Attachment: udf_gis.cc (text/plain), 13.94 KiB.
[2 Feb 2007 13:02]
Pablo Calder?n
thanks, uploaded udf source.
[9 May 2008 16:31]
MySQL Verification Team
Thank you for the feedback. Do you have still the same behavior with latest release?. I wasn't able to test your udf because I don't have #include <map.h> in my environment Suse 10.3.
[9 Jun 2008 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".