MySQL 5.1.31 crashes when do insert

MySQL 5.1.31 crashes when do insert

am 19.12.2009 05:41:56 von Kurian Thayil

--00504502d060dfffd0047b0d7926
Content-Type: multipart/alternative; boundary=00504502d060dfffc7047b0d7924

--00504502d060dfffc7047b0d7924
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Installed compiled mysql-5.1.31 in a centOS 4.4 box. When tried to execute
an insert query I get Error 2013. In fact mysql server crashes and restarts.


*mysql> INSERT INTO `session_table` VALUES
(2,'2',122,'38507720d9d18aede22a2346571a35e7','2009-03-18 10:50:57');
ERROR 2013 (HY000): Lost connection to MySQL server during query
*
Any idea why this is happening? I was able to restore a database which has
tables with 400000-500000 records without any issues. Attached is the error
log. Thanks in advance.

Regards,

Kurian Thayil.

--00504502d060dfffc7047b0d7924
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

Installed compiled mysql-5.1.31 in a centOS 4.4 box. When tried=
to execute an insert query I get Error 2013. In fact mysql server crashes =
and restarts.

mysql> INSERT INTO `session_table` VAL=
UES (2,'2',122,'38507720d9d18aede22a2346571a35e7','2009=
-03-18 10:50:57');

ERROR 2013 (HY000): Lost connection to MySQL server during query
ng>
Any idea why this is happening? I was able to restore a databas=
e which has tables with 400000-500000 records without any issues.=A0Attache=
d is the error log. Thanks in advance.


Regards,

Kurian Thayil.

--00504502d060dfffc7047b0d7924--
--00504502d060dfffd0047b0d7926
Content-Type: text/plain; charset=US-ASCII; name="mysql-error.err.txt"
Content-Disposition: attachment; filename="mysql-error.err.txt"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_g3dwjhq80

MDkxMjE4IDIzOjE3OjE3IElubm9EQjogQXNzZXJ0aW9uIGZhaWx1cmUgaW4g dGhyZWFkIDI5Nzc4
NTY0MTYgaW4gZmlsZSBoYW5kbGVyL2hhX2lubm9kYi5jYyBsaW5lIDM0NTQg DQpJbm5vREI6IFdl
IGludGVudGlvbmFsbHkgZ2VuZXJhdGUgYSBtZW1vcnkgdHJhcC4gDQpJbm5v REI6IFN1Ym1pdCBh
IGRldGFpbGVkIGJ1ZyByZXBvcnQgdG8gaHR0cDovL2J1Z3MubXlzcWwuY29t LiANCklubm9EQjog
SWYgeW91IGdldCByZXBlYXRlZCBhc3NlcnRpb24gZmFpbHVyZXMgb3IgY3Jh c2hlcywgZXZlbiAN
Cklubm9EQjogaW1tZWRpYXRlbHkgYWZ0ZXIgdGhlIG15c3FsZCBzdGFydHVw LCB0aGVyZSBtYXkg
YmUgDQpJbm5vREI6IGNvcnJ1cHRpb24gaW4gdGhlIElubm9EQiB0YWJsZXNw YWNlLiBQbGVhc2Ug
cmVmZXIgdG8gDQpJbm5vREI6IGh0dHA6Ly9kZXYubXlzcWwuY29tL2RvYy9y ZWZtYW4vNS4xL2Vu
L2ZvcmNpbmctcmVjb3ZlcnkuaHRtbCANCklubm9EQjogYWJvdXQgZm9yY2lu ZyByZWNvdmVyeS4g
DQowOTEyMTggMjM6MTc6MTcgLSBteXNxbGQgZ290IHNpZ25hbCA2IDsgDQpU aGlzIGNvdWxkIGJl
IGJlY2F1c2UgeW91IGhpdCBhIGJ1Zy4gSXQgaXMgYWxzbyBwb3NzaWJsZSB0 aGF0IHRoaXMgYmlu
YXJ5IA0Kb3Igb25lIG9mIHRoZSBsaWJyYXJpZXMgaXQgd2FzIGxpbmtlZCBh Z2FpbnN0IGlzIGNv
cnJ1cHQsIGltcHJvcGVybHkgYnVpbHQsIA0Kb3IgbWlzY29uZmlndXJlZC4g VGhpcyBlcnJvciBj
YW4gYWxzbyBiZSBjYXVzZWQgYnkgbWFsZnVuY3Rpb25pbmcgaGFyZHdhcmUu IA0KV2Ugd2lsbCB0
cnkgb3VyIGJlc3QgdG8gc2NyYXBlIHVwIHNvbWUgaW5mbyB0aGF0IHdpbGwg aG9wZWZ1bGx5IGhl
bHAgZGlhZ25vc2UgDQp0aGUgcHJvYmxlbSwgYnV0IHNpbmNlIHdlIGhhdmUg YWxyZWFkeSBjcmFz
aGVkLCBzb21ldGhpbmcgaXMgZGVmaW5pdGVseSB3cm9uZyANCmFuZCB0aGlz IG1heSBmYWlsLiAN
Cg0Ka2V5X2J1ZmZlcl9zaXplPTgzODQ1MTIgDQpyZWFkX2J1ZmZlcl9zaXpl PTEzMTA3MiANCm1h
eF91c2VkX2Nvbm5lY3Rpb25zPTEgDQptYXhfdGhyZWFkcz0xNTEgDQp0aHJl YWRzX2Nvbm5lY3Rl
ZD0xIA0KSXQgaXMgcG9zc2libGUgdGhhdCBteXNxbGQgY291bGQgdXNlIHVw IHRvIA0Ka2V5X2J1
ZmZlcl9zaXplICsgKHJlYWRfYnVmZmVyX3NpemUgKyBzb3J0X2J1ZmZlcl9z aXplKSptYXhfdGhy
ZWFkcyA9IDMzNzcxNiBLIA0KYnl0ZXMgb2YgbWVtb3J5IA0KSG9wZSB0aGF0 J3Mgb2s7IGlmIG5v
dCwgZGVjcmVhc2Ugc29tZSB2YXJpYWJsZXMgaW4gdGhlIGVxdWF0aW9uLiAN Cg0KdGhkOiAweGE5
YzUxYTAgDQpBdHRlbXB0aW5nIGJhY2t0cmFjZS4gWW91IGNhbiB1c2UgdGhl IGZvbGxvd2luZyBp
bmZvcm1hdGlvbiB0byBmaW5kIG91dCANCndoZXJlIG15c3FsZCBkaWVkLiBJ ZiB5b3Ugc2VlIG5v
IG1lc3NhZ2VzIGFmdGVyIHRoaXMsIHNvbWV0aGluZyB3ZW50IA0KdGVycmli bHkgd3JvbmcuLi4g
DQpzdGFja19ib3R0b20gPSAweGIxN2U3MWRjIHRocmVhZF9zdGFjayAweDMw MDAwIA0KL3Vzci9s
b2NhbC9saWJleGVjL215c3FsZChteV9wcmludF9zdGFja3RyYWNlKzB4MWQp IFsweDg1MTNlNWRd
IA0KL3Vzci9sb2NhbC9saWJleGVjL215c3FsZChoYW5kbGVfc2VnZmF1bHQr MHgzMGQpIFsweDgx
ZmE4NDldIA0KL2xpYi90bHMvbGlicHRocmVhZC5zby4wIFsweDllNGE5OF0g DQovbGliL3Rscy9s
aWJjLnNvLjYoYWJvcnQrMHhlOSkgWzB4ODUxMjg5XSANCi91c3IvbG9jYWwv bGliZXhlYy9teXNx
bGQoaGFfaW5ub2Jhc2U6OndyaXRlX3Jvdyh1bnNpZ25lZCBjaGFyKikrMHg0 MGMpIFsweDgzOTIw
MzBdIA0KL3Vzci9sb2NhbC9saWJleGVjL215c3FsZChoYW5kbGVyOjpoYV93 cml0ZV9yb3codW5z
aWduZWQgY2hhciopKzB4NTkpIFsweDgyZGUzYTVdIA0KL3Vzci9sb2NhbC9s aWJleGVjL215c3Fs
ZCh3cml0ZV9yZWNvcmQoVEhEKiwgc3RfdGFibGUqLCBzdF9jb3B5X2luZm8q KSsweDNmNykgWzB4
ODI3NjNhZl0gDQovdXNyL2xvY2FsL2xpYmV4ZWMvbXlzcWxkKG15c3FsX2lu c2VydChUSEQqLCBU
QUJMRV9MSVNUKiwgTGlzdDxJdGVtPiYsIExpc3Q8TGlzdDxJdGVtPiA+Jiwg TGlzdDxJdGVtPiYs
IExpc3Q8SXRlbT4mLCBlbnVtX2R1cGxpY2F0ZXMsIGJvb2wpKzB4OTIxKSBb MHg4Mjc3ZTE5XSAN
Ci91c3IvbG9jYWwvbGliZXhlYy9teXNxbGQobXlzcWxfZXhlY3V0ZV9jb21t YW5kKFRIRCopKzB4
NTQ3ZikgWzB4ODIwZDhmN10gDQovdXNyL2xvY2FsL2xpYmV4ZWMvbXlzcWxk KG15c3FsX3BhcnNl
KFRIRCosIGNoYXIgY29uc3QqLCB1bnNpZ25lZCBpbnQsIGNoYXIgY29uc3Qq KikrMHgxMmMpIFsw
eDgyMTEyNjRdIA0KL3Vzci9sb2NhbC9saWJleGVjL215c3FsZChkaXNwYXRj aF9jb21tYW5kKGVu
dW1fc2VydmVyX2NvbW1hbmQsIFRIRCosIGNoYXIqLCB1bnNpZ25lZCBpbnQp KzB4Y2Q4KSBbMHg4
MjEyMDIwXSANCi91c3IvbG9jYWwvbGliZXhlYy9teXNxbGQoZG9fY29tbWFu ZChUSEQqKSsweGQ0
KSBbMHg4MjEyYjNjXSANCi91c3IvbG9jYWwvbGliZXhlYy9teXNxbGQoaGFu ZGxlX29uZV9jb25u
ZWN0aW9uKzB4NTMxKSBbMHg4MjAyYjY1XSANCi9saWIvdGxzL2xpYnB0aHJl YWQuc28uMCBbMHg5
ZGUzY2NdIA0KL2xpYi90bHMvbGliYy5zby42KF9fY2xvbmUrMHg1ZSkgWzB4 OGYzZjBlXSANClRy
eWluZyB0byBnZXQgc29tZSB2YXJpYWJsZXMuIA0KU29tZSBwb2ludGVycyBt YXkgYmUgaW52YWxp
ZCBhbmQgY2F1c2UgdGhlIGR1bXAgdG8gYWJvcnQuLi4gDQp0aGQtPnF1ZXJ5 IGF0IDB4YTllZTg1
OCA9IElOU0VSVCBJTlRPIGBzZXNzaW9uX3RhYmxlYCBWQUxVRVMgKDIsJzIn LDEyMiwnMzg1MDc3
MjBkOWQxOGFlZGUyMmEyMzQ2NTcxYTM1ZTcnLCcyMDA5LTAzLTE4IDEwOjUw OjU3JykgDQp0aGQt
PnRocmVhZF9pZD0xIA0KdGhkLT5raWxsZWQ9Tk9UX0tJTExFRCANClRoZSBt YW51YWwgcGFnZSBh
dCBodHRwOi8vZGV2Lm15c3FsLmNvbS9kb2MvbXlzcWwvZW4vY3Jhc2hpbmcu aHRtbCBjb250YWlu
cyANCmluZm9ybWF0aW9uIHRoYXQgc2hvdWxkIGhlbHAgeW91IGZpbmQgb3V0 IHdoYXQgaXMgY2F1
c2luZyB0aGUgY3Jhc2guIA0KMDkxMjE4IDIzOjE3OjE3IG15c3FsZF9zYWZl IE51bWJlciBvZiBw
cm9jZXNzZXMgcnVubmluZyBub3c6IDAgDQowOTEyMTggMjM6MTc6MTcgbXlz cWxkX3NhZmUgbXlz
cWxkIHJlc3RhcnRlZCANCklubm9EQjogVGhlIGxvZyBzZXF1ZW5jZSBudW1i ZXIgaW4gaWJkYXRh
IGZpbGVzIGRvZXMgbm90IG1hdGNoIA0KSW5ub0RCOiB0aGUgbG9nIHNlcXVl bmNlIG51bWJlciBp
biB0aGUgaWJfbG9nZmlsZXMhIA0KMDkxMjE4IDIzOjE3OjE3IElubm9EQjog RGF0YWJhc2Ugd2Fz
IG5vdCBzaHV0IGRvd24gbm9ybWFsbHkhIA0KSW5ub0RCOiBTdGFydGluZyBj cmFzaCByZWNvdmVy
eS4gDQpJbm5vREI6IFJlYWRpbmcgdGFibGVzcGFjZSBpbmZvcm1hdGlvbiBm cm9tIHRoZSAuaWJk
IGZpbGVzLi4uIA0KSW5ub0RCOiBSZXN0b3JpbmcgcG9zc2libGUgaGFsZi13 cml0dGVuIGRhdGEg
cGFnZXMgZnJvbSB0aGUgZG91Ymxld3JpdGUgDQpJbm5vREI6IGJ1ZmZlci4u LiANCjA5MTIxOCAy
MzoxNzoxNyBJbm5vREI6IFN0YXJ0ZWQ7IGxvZyBzZXF1ZW5jZSBudW1iZXIg MCA1MjQ5NSANCjA5
MTIxOCAyMzoxNzoxNyBbTm90ZV0gRXZlbnQgU2NoZWR1bGVyOiBMb2FkZWQg MCBldmVudHMgDQow
OTEyMTggMjM6MTc6MTcgW05vdGVdIC91c3IvbG9jYWwvbGliZXhlYy9teXNx bGQ6IHJlYWR5IGZv
ciBjb25uZWN0aW9ucy4gDQpWZXJzaW9uOiAnNS4xLjMxJyBzb2NrZXQ6ICcv dG1wL215c3FsL3Vu
aXguc29jaycgcG9ydDogODg0MiBTb3VyY2UgZGlzdHJpYnV0aW9uIA0K

--00504502d060dfffd0047b0d7926
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--00504502d060dfffd0047b0d7926--

Re: MySQL 5.1.31 crashes when do insert

am 19.12.2009 19:58:01 von Kurian Thayil

--=-tQiiH8/IlzCP6ILTuRpq
Content-Type: multipart/alternative; boundary="=-t5nLrAYFNQkhUnnE9pco"


--=-t5nLrAYFNQkhUnnE9pco
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Hi,

Well its a bug in MySQL 5.1.31 and fixed in MySQL 5.1.33. The reason
being InnoDB engine can't take a float kind of datatype as
auto_increment field. In my table, auto_increment was defined as double.
Hence the issue.

Regards,
- =20
Kurian Mathew Thayil.
(GPG KeyID: E232394F)


On Sat, 2009-12-19 at 10:11 +0530, Kurian Thayil wrote:

> Hi,=20
>=20
> Installed compiled mysql-5.1.31 in a centOS 4.4 box. When tried to
> execute an insert query I get Error 2013. In fact mysql server crashes
> and restarts.=20
>=20
> mysql> INSERT INTO `session_table` VALUES
> (2,'2',122,'38507720d9d18aede22a2346571a35e7','2009-03-18 10:50:57');=20
> ERROR 2013 (HY000): Lost connection to MySQL server during query=20
>=20
> Any idea why this is happening? I was able to restore a database which
> has tables with 400000-500000 records without any issues. Attached is
> the error log. Thanks in advance.
>=20
> Regards,=20
>=20
> Kurian Thayil.

--=-t5nLrAYFNQkhUnnE9pco
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable








Hi,



Well its a bug in MySQL 5.1.31 and fixed in MySQL 5.1.33. The reason being =
InnoDB engine can't take a float kind of datatype as auto_increment field. =
In my table, auto_increment was defined as double. Hence the issue.



Regards,








- =20

Kurian Mathew Thayil.

(GPG KeyID: E232394F)






On Sat, 2009-12-19 at 10:11 +0530, Kurian Thayil wrote:


Hi,



Installed compiled mysql-5.1.31 in a centOS 4.4 box. When tried to exec=
ute an insert query I get Error 2013. In fact mysql server crashes and rest=
arts.



mysql> INSERT INTO `session_table` VALUES (2,'2',122,'38507720=
d9d18aede22a2346571a35e7','2009-03-18 10:50:57');

ERROR 2013 (HY000): Lost connection to MySQL server during query =




Any idea why this is happening? I was able to restore a database which =
has tables with 400000-500000 records without any issues. Attached is =
the error log. Thanks in advance.



Regards,



Kurian Thayil.




--=-t5nLrAYFNQkhUnnE9pco--

--=-tQiiH8/IlzCP6ILTuRpq
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAkstIjYACgkQmpp12uIyOU9aZQCgpmyBrdvonhocc0m+INML SZTq
fgUAn2+1uQcJrB1NT6gW3lrTH8lklTEq
=jXs1
-----END PGP SIGNATURE-----

--=-tQiiH8/IlzCP6ILTuRpq--