distal-attribute
distal-attribute
distal-attribute
distal-attribute

Range check error / Out of memory

kalvaro posted 10 years ago in General
I'm getting weird error messages and memory issues with release 3.2 and I'd like to confirm whether there's actually a problem with the software or it's only my computer.

I've prepared a test dataset (please find the dump at the end of the message). Check this out:

SELECT
`field1` AS 'Nombre',
`field2`
FROM table1
INNER JOIN table2
ON table1.id=table2.id_tabla
INNER JOIN table3
ON table2.table3_actual=table3.id
WHERE table2.workflow=1


If I run it several times I get a Range check error one out of two times. Also, Windows Task Manager shows that HeidiSQL allocates 100MB of RAM instantly. It gets fixed if I remove the AS 'Nombre' part or rename "Nombre" as "foo".

The query runs fine in other MySQL front ends. Other similar queries in this database have similar memory problems; sometimes HeidiSQL allocates 300MB instantly and it gets released when I perform another query.

Any clue? Should I report it as a bug?

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 XXXXXXXXXXXXXX
# Database:             test
# Server version:       4.1.13
# Server OS:            Win32
# Target-Compatibility: MySQL 3.23
# max_allowed_packet:   1047552
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------
/*!40100 SET CHARACTER SET latin1*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;
DROP TABLE IF EXISTS `table1`;
#
# Table structure for table 'table1'
#
CREATE TABLE `table1` (
`id` int(10) unsigned NOT NULL auto_increment,
`field1` longtext,
`field2` longtext,
PRIMARY KEY  (`id`)
) TYPE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;
#
# Dumping data for table 'table1'
#
# (No data found.)
DROP TABLE IF EXISTS `table2`;
#
# Table structure for table 'table2'
#
CREATE TABLE `table2` (
`id` int(10) unsigned NOT NULL auto_increment,
`table3_actual` int(10) unsigned NOT NULL default '0',
`workflow` int(10) unsigned NOT NULL default '0',
`id_tabla` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`id`),
KEY `instanciaworkflow_FKIndex1` (`workflow`),
KEY `instanciaworkflow_FKIndex3` (`table3_actual`)
) TYPE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;
#
# Dumping data for table 'table2'
#
# (No data found.)
DROP TABLE IF EXISTS `table3`;
#
# Table structure for table 'table3'
#
CREATE TABLE `table3` (
`id` int(10) unsigned NOT NULL auto_increment,
`workflow` int(10) unsigned NOT NULL default '0',
`nombre` varchar(255) default NULL,
PRIMARY KEY  (`id`),
KEY `table3_FKIndex1` (`workflow`)
) TYPE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;
#
# Dumping data for table 'table3'
#
LOCK TABLES `table3` WRITE;
/*!40000 ALTER TABLE `table3` DISABLE KEYS*/;
INSERT INTO `table3` (`id`, `workflow`, `nombre`) VALUES
('1','1','inicial');
/*!40000 ALTER TABLE `table3` ENABLE KEYS*/;
UNLOCK TABLES;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;
[/b][/code][i:10abea607a][/i:10abea607a]
rosenfield posted 10 years ago
> Should I report it as a bug?

Definitely!
Why would you not report it as a bug?

> Any clue?

Ufortunately no, but looks interesting enough. I personally do not have time to look at it now, but if you post a bug it will be fixed - the developers go through the bug database pretty often.
ansgar posted 10 years ago
Not sure if that's the same issue but it looks like a similar bug is already posted here. But feel very free to leave a comment on that page - especially with that detailed reproduction recipe.
rosenfield posted 10 years ago
Or create a new issue, we can always close one of them if it proves to be a duplicate..

Either way, good thing to post in the bug tracker, since it helps us, erh, keep track of things..

I cannot reproduce using the table dump and query you've posted above, neither in v3.2 (r1129) nor in r1147.

Maybe our server versions differ?..
kalvaro posted 10 years ago
I've just reported it as bug:

http://sourceforge.net/tracker/index.php?func=detail&aid=1841608&group_id=164593&atid=832347

I hope it can be reproduced.
ansgar posted 10 years ago
Thanks a lot! That will definitely help fixing it!

Please login to leave a reply, or register at first.