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: | |
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
[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.