Bug #15358 Crash in scheduled backup, similar to #13507
Submitted: 30 Nov 2005 16:49 Modified: 7 Feb 2007 8:48
Reporter: Paul Furbacher Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:version 1.1.2.0 OS:Windows (Windows XP Pro, sp2)
Assigned to: Mike Lischke CPU Architecture:Any

[30 Nov 2005 16:49] Paul Furbacher
Description:
Here is what the Event Viewer > Event Properties dialog shows:
 
Event Type:	Error
Event Source:	Application Error
Event Category:	None
Event ID:	1000
Date:		11/30/2005
Time:		10:20:00 AM
User:		N/A
Computer:	GW-CLIMS-SERVER
Description:
Faulting application mysqladministrator.exe, version 1.1.2.0, 
faulting module mysqladministrator.exe, version 1.1.2.0, 
fault address 0x001c9c43.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 6d 79 73   ure  mys
0018: 71 6c 61 64 6d 69 6e 69   qladmini
0020: 73 74 72 61 74 6f 72 2e   strator.
0028: 65 78 65 20 31 2e 31 2e   exe 1.1.
0030: 32 2e 30 20 69 6e 20 6d   2.0 in m
0038: 79 73 71 6c 61 64 6d 69   ysqladmi
0040: 6e 69 73 74 72 61 74 6f   nistrato
0048: 72 2e 65 78 65 20 31 2e   r.exe 1.
0050: 31 2e 32 2e 30 20 61 74   1.2.0 at
0058: 20 6f 66 66 73 65 74 20    offset 
0060: 30 30 31 63 39 63 34 33   001c9c43
0068: 0d 0a                     ..      

****

What is confusing is that if I "Execute Backup Now", it doesn't fail.

However, it fails as a scheduled task.

To I test the failure of the scheduled backup, I can do it two ways: in MySQL Administrator, I set the time for backup to a few minutes from the current time, save the project, and enter the password when the "Account Information" dialog asks me to do so.  

In the second way, I go to the task in Control Panel > Scheduled Tasks and set the task that way (time, password, etc.), and it still fails.  The failure pops up a "report this to Microsoft" alert.  I've sent the error report numerous times, with no response.  The "Error Report Contents" dialog (which unfortunately does not all me to copy its contents) gives "Exception Information: Code: 0xc0000005 Flags: 0x00000000 Record 0x0 Address: 0x00000000005c9c43".  It lists 45 modules and a single thread.  Obviously, since I cannot copy the contents of this pane, I cannot give any more detail.

I suspect that there is some problem with permissions or with Administrator not being able to log in or something like this.  If it's not a bug in MySQL administrator, at least more documentation needs to be written as to what permissions should be set in the user accounts or something.  As it is now, I cannot schedule automatic backups of our database.  (And I'm trying to convince management to use MySQL instead of MS SQL Server, so it will be a big negative if we cannot do automated backups with MySQL.)

How to repeat:
See the steps to reproduce listed in "MySQL Bugs: #13507: Crash on schedule backup at libmysqladmin.dll at 0000592".  Note that the crash I'm experiencing is not in that DLL, but in the .exe itself.
[7 Dec 2005 12:26] Vasily Kishkin
I was not able to reproduce the bug on 1.1.4. Could you please upgrade your version of administrator and reproduce the bug ?
[27 Dec 2005 13:00] Marco de Krijger
Same problem here with mysql administrator version 1.1.6

0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 4d 79 53   ure  MyS
0018: 51 4c 41 64 6d 69 6e 69   QLAdmini
0020: 73 74 72 61 74 6f 72 2e   strator.
0028: 65 78 65 20 31 2e 31 2e   exe 1.1.
0030: 36 2e 30 20 69 6e 20 4d   6.0 in M
0038: 79 53 51 4c 41 64 6d 69   ySQLAdmi
0040: 6e 69 73 74 72 61 74 6f   nistrato
0048: 72 2e 65 78 65 20 31 2e   r.exe 1.
0050: 31 2e 36 2e 30 20 61 74   1.6.0 at
0058: 20 6f 66 66 73 65 74 20    offset 
0060: 30 30 31 64 32 63 35 33   001d2c53

First I tried using the scheduled task with the user that is logged on. That didn;t worked out at all, when I use "administrator" as user to execute this task it runs, but is giving me the error as only result.
[3 Jan 2006 14:51] Arnd Christel
I find out, the Problem is:
If your root has an Password you must in Options / Administrator check 'Show Global Privileges' then it will be run.
[3 Jan 2006 17:34] Paul Furbacher
The setting, "Show Global Privileges", in Tools > Options > Administrator has always been set in my instance of MySQL Administrator.  The backups have failed nonetheless.  Still, I suspect there's a problem related to security settings, but I cannot find it; hence this bug report.  Even if the backup facilitate cannot authenticate because of some kind of setting not being right, it shouldn't crash!  It should tell me what it couldn't do either with an email notice, a log output or something (!), and then gracefully quit.

As for the earlier suggestion by Vasily (?) to upgrade to the latest version: I'm now running Administrator 1.1.5 and I still have the problem.  If I want to make a backup, I have
to do it manually, typing in my password.  That works; the automated "cron" type of 
backup doesn't.  Oh well, I'll still use Administrator but sure wish we could solve this
problem.
[3 Jan 2006 17:37] Paul Furbacher
Small correction:  

I just wrote: "... Even if the backup facilitate cannot authenticate ....

What I meant to write was "... Even if the backup *facility* cannot authenticate ....
[4 Jan 2006 12:51] Arnd Christel
Hello,
perhaps your Problem is the target folder.
If I use an networkdrive I have also an problem when I'm not enter an User from the Domain.
If I use an localdrive, I use an lokal Admin.
[9 Jan 2006 10:16] Arnd Christel
Hello,
have you found the problem?
I have an german Dokumentation (step by Step) for training the MySQL Database, with a lot of pictures, I can't Upload it here because i you wont, I can sent it per Mail.
My Mail Adress is chria@bizerba.de
[26 Jan 2006 18:18] Jorge del Conde
I was able to repeat this by setting the scheduled task 5 mins ahead of the current time.  For the test, I ensured that my mysql root password was null.

I tested this under XP/SP2, 1.1.7
[30 Jan 2006 19:53] Sean Boswell
I had the exact same problem.  In bug report 4565 Curtis Paul suggested a fix that worked for me.

FROM BUG 4565:
"[30 Aug 2005 17:09] Curtis Paul 
I changed the "-c" to "-C"   but I don't know what the -c is for so I don't know
how this will effect your backed up data....but now it works with the microsoft
sched..."

I hope that helps
[7 Jul 2006 13:37] Mike Lischke
I cannot reproduce this problem with the latest sources. Please try version 1.2.
[13 Jul 2006 15:32] Tim Moody
I  have the same problem with Admin 1.1.5.

I don't see a 1.2 available for download.
[30 Oct 2006 0:42] Amin Taheri
Changing the -c to -C fixed the problem, but am unsure as to the differences in the finished backup.
[30 Oct 2006 0:42] Amin Taheri
Changing the -c to -C fixed the problem, but am unsure as to the differences in the finished backup.
[6 Feb 2007 11:28] Remko Strating
I had the same problem within mysqladministrator version 1.1.9

The reason was that I didn't made a connection within the option manage connections. 

By creating a valid connection I had solved the problem.  

You could see in the backup log that mysql is using the connections with are created in the file mysqlx_user_connections.xml. If there are no connections in this file the backup will not function. 

Maybe an improvement will be that by making a scheduled backup mysqladministrator will check that a connection exists.
[6 Feb 2007 13:54] Mark Schiavone
My problem with scheduled backups was also solved by establishing a valid connection. This bug situation could easily be resolved by simply editing the help manual to indicate that a connection must be established when defining scheduled backups on the Windows platform.
[7 Feb 2007 8:48] Stefan Hinz
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.