| 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: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.15-nt-max | OS: | Windows (Windows SBS 2003) |
| Assigned to: | CPU Architecture: | Any | |
[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".
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.