MySQL Bugs: #18277: crash

Bug #18277	crash
Submitted:	16 Mar 2006 11:28	Modified:	23 Mar 2006 16:29
Reporter:	Mr Antoine	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	3.23.54	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
[root@ensim tmp]# resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
0x80b3c9f handle_segfault__Fi + 431
0x4002cac5 _end + 937274461
0x80fe6b0 berkeley_cmp_packed_key__FP4__dbPC8__db_dbtT1 + 80
0x814739c __bam_cmp + 288
0x818b1c6 __bam_search + 886
0x8180d1d __bam_c_search + 1633
0x817e881 __bam_c_get + 1297
0x815b0a0 __db_c_get + 840
0x81571ab __db_get + 323
0x8100bfa rnd_pos__11ha_berkeleyPcT1 + 106
0x80f737a rr_from_pointers__FP14st_read_record + 58
0x80dae6e join_init_read_record__FP13st_join_table + 78
0x80da38c sub_select__FP4JOINP13st_join_tableb + 76
0x80da104 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 404
0x80d2c84 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 7268
0x80b9f1f mysql_execute_command__Fv + 831
0x80bd315 mysql_parse__FP3THDPcUi + 69
0x80b9213 do_command__FP3THD + 1219
0x80b87c9 handle_one_connection__FPv + 633

How to repeat:
Don't know yet

Also had that in mysqld.log :

thd->query at 0x8328078 = SELECT * FROM radacct WHERE UserName = '0473689092@erevia.com' AND RadAcctId > 0 ORDER BY AcctStartTime LIMIT 0,1
thd->thread_id=4996

I now can issue this SQL statement in phpmyadmin without any problem ...

Thank you for a problem report. If it was that SELECT * FROM radacct WHERE UserName = '0473689092@erevia.com' AND RadAcctId > 0 ORDER BY AcctStartTime LIMIT 0,1 that crashed your server, please, send the SHOW CREATE TABLE and SHOW TABLE STATUS results for that table. The uname -a results for your Linux might be also useful.

Can you also try to upgrade to a newer version, 3.23.58 at least?

Hi,

It is a production environment ...

I just rolled back to MyIsam format

Show Table Status is now :
radacct MyISAM Dynamic 1170106 186 217647804 4294967295 290757632 0 1319329 2006-03-16 14:09:09 2006-03-16 14:47:20 2006-03-16 14:53:42 pack_keys=0   

Structure now is :
CREATE TABLE radacct (
  RadAcctId bigint(21) NOT NULL auto_increment,
  AcctSessionId varchar(32) NOT NULL default '',
  AcctUniqueId varchar(32) NOT NULL default '',
  UserName varchar(64) NOT NULL default '',
  Realm varchar(64) default '',
  NASIPAddress varchar(15) NOT NULL default '',
  NASPortId int(12) default NULL,
  NASPortType varchar(32) default NULL,
  PreSessionTime int(3) default NULL,
  AcctStartTime datetime NOT NULL default '0000-00-00 00:00:00',
  AcctStopTime datetime NOT NULL default '0000-00-00 00:00:00',
  AcctSessionTime int(12) default NULL,
  AcctAuthentic varchar(32) default NULL,
  ConnectInfo_start varchar(32) default NULL,
  ConnectInfo_stop varchar(32) default NULL,
  AcctInputOctets int(12) default NULL,
  AcctOutputOctets int(12) default NULL,
  CalledStationId varchar(10) NOT NULL default '',
  CallingStationId varchar(10) NOT NULL default '',
  AcctTerminateCause varchar(32) NOT NULL default '',
  ServiceType varchar(32) default NULL,
  FramedProtocol varchar(32) default NULL,
  FramedIPAddress varchar(15) NOT NULL default '',
  AcctStartDelay int(12) default NULL,
  AcctStopDelay int(12) default NULL,
  DataRate varchar(10) NOT NULL default '',
  XmitRate varchar(10) NOT NULL default '',
  WithKit char(1) NOT NULL default 'f',
  Communaute varchar(4) default NULL,
  id_dby_argent int(11) NOT NULL default '0',
  cout_FT decimal(10,5) NOT NULL default '0.00000',
  cout_ER decimal(10,5) NOT NULL default '0.00000',
  PRIMARY KEY  (RadAcctId),
  UNIQUE KEY AcctUniqueId (AcctUniqueId),
  KEY UserName (UserName),
  KEY FramedIPAddress (FramedIPAddress),
  KEY AcctSessionId (AcctSessionId),
  KEY AcctStartTime (AcctStartTime),
  KEY AcctStopTime (AcctStopTime),
  KEY NASIPAddress (NASIPAddress),
  KEY Communaute (Communaute),
  KEY id_dby_argent (id_dby_argent)
) TYPE=MyISAM PACK_KEYS=0;

I just had changed type to BDB

[root@ensim root]# uname -a
Linux ensim.erevia.com 2.4.9-34 #1 Sat Jun 1 06:25:16 EDT 2002 i686 unknown
[root@ensim root]#

I'll try to check one day, but with 3.23.59 (current) version. Even if there is really a bug, it will not be fixed in any foreseeable future. So, please, upgrade.

MySql just crashed again, on another table which format is hereunder :

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x88c1138 = SELECT annee , id_mois FROM dby_temps WHERE id_inscrit = 5170 ORDER BY annee DESC , id_mois DESC LIMIT 0,1
thd->thread_id=257

CREATE TABLE dby_temps (
  id_inscrit int(11) NOT NULL default '0',
  annee int(4) NOT NULL default '0',
  id_mois int(2) NOT NULL default '0',
  id_forfait int(4) NOT NULL default '0',
  sec_jour int(7) NOT NULL default '0',
  sec_nuit int(7) NOT NULL default '0',
  sec_hf int(7) NOT NULL default '0',
  sec_24h int(7) NOT NULL default '0',
  sec_inv int(7) NOT NULL default '0',
  sec_hsc int(7) NOT NULL default '0',
  sec_hc int(7) NOT NULL default '0',
  sec_hp int(7) NOT NULL default '0',
  sec_hsc_gg int(7) NOT NULL default '0',
  sec_hc_gg int(7) NOT NULL default '0',
  sec_hp_gg int(7) NOT NULL default '0',
  mnt_facture decimal(10,5) NOT NULL default '0.00000',
  mnt_non_rembourse decimal(10,5) NOT NULL default '0.00000',
  RadAcctId bigint(21) NOT NULL default '0',
  etat_temps char(1) NOT NULL default 'W',
  ts timestamp(14) NOT NULL,
  option_nomade char(1) NOT NULL default 'f',
  option_hidden char(1) NOT NULL default 'f',
  nb_view smallint(6) NOT NULL default '0',
  nb_session mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (id_inscrit,annee,id_mois)
) TYPE=BerkeleyDB;