Bug #20723 scheduled backups fail., first launch of admin fails, second launch works
Submitted: 27 Jun 2006 13:42 Modified: 27 Jul 2006 16:37
Reporter: Mike Koehler Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:mysql admin 1.1.9 OS:admin on w2k, server linux, 4.1
Assigned to: CPU Architecture:Any

[27 Jun 2006 13:42] Mike Koehler
Description:
Several of us here are experiencing the same problem. 

We have all downloaded and install the latest windows mysql browser, admin and odbc drivers (3.51) and everytime you need to enter the admin tool, the first time it stalls, you press cancel and re-launch and it works.

Why I bring this up is becuase I have other "connection failure" issues I think,  and this might be a clue as to our issues. 

I build backup jobs inside the mysql admin tool, and can execute them fine from the admin tool, but when I schedule them to run, they fail more than they complete successfully.

My event viewer looks like this:
Event Type:	Information
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		6/26/2006
Time:		11:00:00 PM
User:		N/A
Computer:	CURT
Description:
MySQL Administrator is preparing backup for profile Monday_risi_production_full.

then, it does this:
Event Type:	Error
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		6/26/2006
Time:		11:00:00 PM
User:		N/A
Computer:	CURT
Description:
Connection  cannot be found.

and sometimes I see this:
Event Type:	Error
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		6/27/2006
Time:		1:00:05 AM
User:		N/A
Computer:	CURT
Description:
Cannot connect to MySQL Server. Lost connection to MySQL server during query (Error Number 2013)

Some of us get similair results when trying to use an odbc driver in ms-access to import tables into ms-access locally. (we gave up on trying to "link" them in ms-access a while ago. They link but all data appears as "#DELETED#".

Thanks,
Mike

How to repeat:
attempt to launch the admin tool, every time, the first launch attempt fails.
[27 Jun 2006 15:55] Valeriy Kravchuk
Tnak you for a problem report. Scheduled backup failure is a known problem. See bug #4565, for example. I think, this is a duplicate.
[27 Jun 2006 16:25] Mike Koehler
I dont feel its a dupe of that bug.
I do have password save on, and the user is an admin.

In addition to the schedule backup part failing, for which I have also already tried removing the "-c" in the schedular command line (found in a different bug) , what do you make of the mysql admin tool ALWAYS failing the first launch, after hitting the cancel buttom and restarting ALWAYS working on the second attempt?
[27 Jun 2006 16:37] Valeriy Kravchuk
I can not repeat launch failure with 1.1.9 on XP SP2. So, please, give more details on your w2k service packs, antivirus software running etc.
[27 Jul 2006 23: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".
[21 Oct 2009 21:42] Bob Hansen
I had the same problem running Windows 2003 server. Here's what DIDN'T work.

I tried changing "-c" to "-C".
I tried removing "-c".
I tried created two stored connections, one for root and one for a user, both having full privs to the database, and logging into MySQL Administrator from each one.
I enabled obscured password storage.
I ensured I was logged in as administrator on this computer.
I ensured I had read and write privileges to the backup location.
I tried saving to a location on the C: drive and on the D: drive.
I checked the Event Viewer for errors but only had one error which re-directed me here.

Here's what DID work.

I found out that this user is part of a domain. When you schedule the project and click Save Project it prompts for a username and password so I did something like this

User: administrator
Pass: _password_

Only to find out later that I needed to reformat the username to include the domain. It worked when I entered the username this way

User: _DOMAIN_\administrator
Pass: _password_

Note: If you go to Control Panels>Scheduled Tasks and get Properties on your task, you should already see the proper format in the Run As box.

Note: This is report is similar to the problem described here:
http://bugs.mysql.com/bug.php?id=4565