Bug #40668 mysqld-nt crashed on Vista32
Submitted: 12 Nov 2008 13:43 Modified: 12 Nov 2008 20:06
Reporter: Heinz Höfling Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.67 OS:Windows (Vista Ultimate32)
Assigned to: CPU Architecture:Any
Tags: crash, Vista32

[12 Nov 2008 13:43] Heinz Höfling
Description:
The daemon crashed at the "insert into".
The same mysql-version and same Application runs fine on XPSp3

from host.err:

081112 14:17:38 [Note] F:\Programme\MySQL Server 5.0\bin\mysqld-nt.exe: ready for connections.
Version: '5.0.67-community-nt-log'  socket: ''  port: 3306  MySQL Community Edition (GPL)
081112 14:20:01 - mysqld got exception 0xc0000005 ;
This......shorted...fail.
key_buffer_size=183500800
read_buffer_size=65536
max_used_connections=2
max_connections=100
threads_connected=1
......
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
006B430B    mysqld-nt.exe!???
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 18FDBC38=Insert Into "UserFields"("idThumbUDF","uf_Original_datetime") Values(4,'2005:08:12 17:21:04')
thd->thread_id=20

The insert statement crashed the server also when i use it in phpmyadmin

How to repeat:
Start Server
use phpmyadmin to execute:
Insert Into "UserFields"("idThumbUDF","uf_Original_datetime") Values(4,'2005:08:12 17:21:04')

--> Server crashed

also the simpler statement crashed the server

Insert Into "UserFields"("idThumbUDF") Values(4)

--> Server crashed

idThumbUDF is of type Integer

Insert into other tables are Ok.
[12 Nov 2008 14:23] MySQL Verification Team
Thank you the bug report. Could you please provide the create table statement?. Thanks in advance.
[12 Nov 2008 18:05] Heinz Höfling
create-Tables.sql File.

Attachment: tp_mysql5_innodb.sql (text/x-sql), 52.73 KiB.

[12 Nov 2008 18:15] Heinz Höfling
Hardcopy of phpadmin

Attachment: screen.png (image/png, text), 59.33 KiB.

[12 Nov 2008 18:29] Heinz Höfling
I have recreated the userfields and userfieldsInfo table.
The problem disaspears. :-( :-)  :-)

I have copyied the database from a wxpSp3 pc to the Vista-PC
Now, after recreating the two tables, all works fine.

Please close the Bug.

By
Heinz