MySQL Bugs: #43081: GLib-ERROR **:gmen.c173: failed to allocate 6560000 bytes aborting...

Bug #43081	GLib-ERROR **:gmen.c173: failed to allocate 6560000 bytes aborting...
Submitted:	21 Feb 2009 15:35	Modified:	10 Mar 2009 12:25
Reporter:	tedaz tedaz	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.16	OS:	Windows (XP Pro SP3 English)
Assigned to:		CPU Architecture:	Any
Tags:	failed allocate

Description:
There are about 550K records in a mysql table.
Use the MySQL Query Browser to run a select sentence.

eg: table name is "test"
select * from test;

MySQL 5.1.31-community

How to repeat:
There are about 550K records in a mysql table.
Use the MySQL Query Browser to run a select sentence.

eg: table name is "test"
select * from test;

failed to allocate 6560000 bytes

Attachment: 未标题-2.png (image/x-png, text), 46.17 KiB.

failed to allocate 6560000 bytes

Attachment: ccas.png (image/x-png, text), 7.86 KiB.

Thank you for the bug report. Could you please provide the create table statement.
Thanks in advance.

Here is the create table statement:

CREATE TABLE  `nccback`.`testcc` (
  `sid` varchar(9) NOT NULL,
  `c_l_o` varchar(6) NOT NULL,
  `i_f` smallint(6) NOT NULL default '0',
  `year` smallint(6) NOT NULL default '0',
  `mon` smallint(6) NOT NULL default '0',
  `day` smallint(6) default NULL,
  `c_d` datetime NOT NULL default '0000-00-00 00:00:00',
  `usid` int(11) NOT NULL default '0',
  `repid` int(11) default NULL,
  `frcn` varchar(8) default NULL,
  PRIMARY KEY  USING BTREE (`sid`),
  KEY `ids_rep_index` USING BTREE (`repid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Error message

Attachment: msg-error.png (image/png, text), 36.39 KiB.

Thank you for the feedback. I couldn't repeat with version 1.2.17 instead I got the message showed in the picture attached. Please try the new version.

Thanks for your help.
I downloaded the latest version of the MySQL Query Browser(1.2.17).
And I tried the select * from ... statement again. Unfortunately, I got the same error message again.
PS: My computer is Windows XP Pro 32bit, only 4GB memory installed.

MySQL Query Browser 1.2.17

Attachment: 0.PNG (image/x-png, text), 19.46 KiB.

A lot of memory used when the MySQL Query Browser crashed

Attachment: 1.PNG (image/x-png, text), 32.48 KiB.

GLib-ERROR gmem.c:173

Attachment: 2.PNG (image/x-png, text), 4.73 KiB.

Runtime Error

Attachment: 3.PNG (image/x-png, text), 7.86 KiB.

I can't repeat this but I will give this error to development maybe they have an idea about it.

Many thanks for writing a bug report.

The workaround here is to use LIMIT in your select statement.

We are on the way to implement whole functionality of MySQL Query Browser into MySQL Workbench and in MySQL Workbench this problem already is fixed.