Bug #15959 mysql service crashes after 2 calls of the same stored procedure.
Submitted: 23 Dec 2005 9:20 Modified: 23 Jan 2006 10:37
Reporter: Christian Belz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15-nt-max OS:Microsoft Windows (Windows SBS 2003)
Assigned to: CPU Architecture:Any

[23 Dec 2005 9:20] Christian Belz
Description:
I use Access 2000 as frontend and call a stored procedure like below:

---------------------------------------------------------
Set dbs = CurrentDb
Set qdf = dbs.QueryDefs("a_da_fertig")
qdf.Connect = Form_F_Menu.Bez_strConnect.Caption
qdf.ReturnsRecords = False
        
DoCmd.OpenForm "F_From_Date", acNormal, , , acFormEdit, acDialog
strTmp = Format(strFromDate, "yyyy.mm.dd")
strSeitDatum = strTmp
sSQL = "call a_da_fertig(""" & strFromDate & """);"
qdf.SQL = sSQL
qdf.Execute

---------------------------------------------------------

The first Call works without any problems!
When i try to call the same procedure a few mins later the mysql service crashes. When i wait about 10 mins till next call it works fine!

---------------------------------------------------------
There is no error message in the log. I just found this:

051223 10:08:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
051223 10:08:28  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 677813687.
InnoDB: Doing recovery: scanned up to log sequence number 0 679265721
051223 10:08:29  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name 
051223 10:08:29  InnoDB: Started; log sequence number 0 679265721
051223 10:08:30 [Note] D:\Programme\MySQL\MySQL Server 5.0\bin\mysqld-max-nt: ready for connections.
Version: '5.0.15-nt-max'  socket: ''  port: 3306  Official MySQL binary

---------------------------------------------------------

Is there a problem with temporary Tables?

---------------------------------------------------------

I will add the stored Procedure after opening. (says its to long)

How to repeat:
Just call the procedure 2 times in a short time period.
[23 Dec 2005 9:22] Christian Belz
Stored Procedure: a_da_fertig

Attachment: a_da_fertig.sql (application/octet-stream, text), 35.46 KiB.

[23 Dec 2005 9:26] Christian Belz
Microsoft SBS 2003 Crash info:

AppName: mysqld-max-nt.exe           AppVer: 0.0.0.0     ModName: mysqld-max-nt.exe                 ModVer: 0.0.0.0        Offset: 000e4c8c
[23 Dec 2005 10:37] Valeriy Kravchuk
Thank you for a problem report. Sorry, but when I tried to call your procedure it gave me:

mysql> call a_da_fertig(now());
ERROR 1146 (42S02): Table 'jes.t_artikel_main' doesn't exist

So, I need the SHOW CREATE TABLE results and some data for that jes.t_artikel_main table. Please, check the other tables referenced in your procedure too.
[23 Dec 2005 12:08] Christian Belz
Create tables with a few Data

Attachment: tmp2.sql (application/octet-stream, text), 77.95 KiB.

[24 Jan 2006 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".