Install On Windows Vista

[gbruce]

Just downloaded SQLyog on a new windows vista machine and SQLyog crahes immedately when started. Thsi is the error I get from Vista

Problem Event Name: APPCRASH

Application Name: SQLyogEnt.exe

Application Version: 1.0.0.1

Application Timestamp: 46727808

Fault Module Name: StackHash_bfc5

Fault Module Version: 0.0.0.0

Fault Module Timestamp: 00000000

Exception Code: c0000005

Exception Offset: 7676ac79

OS Version: 6.0.6000.2.0.0.768.2

Locale ID: 1033

Additional Information 1: bfc5

Additional Information 2: 0a385cd912a585b319ae022c1fae7a1e

Additional Information 3: d5c1

Additional Information 4: 7708af8f55a4310c1c66bf035805928e

[peterlaursen]

I am using SQLyog with Vista too.

I think there is a bug in Vista, that does that if a program is started before the system has completely finished booting such crash can occur.  I have experienced this with SQLyog and other programs on Vista as well!

I also noticed that when it happens the system needs to be restarted to run that program!  Even reinstalling won't help!

Could you try please?

[Marco Balk]

It looks like I'm having the same problem with both versions (SQLyog Community Edition 6.04 (Stable) & SQLyog Community Edition 6.05 (BETA))

When I started SQLyog my PC has completely finished booting (I restarted at night and started the program in the morning).

These are the errors from my Eventviewer:

[codebox]Faulting application SQLyog.exe, version 1.0.0.1, time stamp 0x4694ee6b, faulting module unknown, version 0.0.0.0, time stamp 0x00000000, exception code 0xc0000005, fault offset 0x7670ac79, process id 0xcd0, application start time 0x01c7ca99f4d21e9b.[/codebox]

[codebox]Fault bucket 471732437, type 1

Event Name: APPCRASH

Response: None

Cab Id: 0

Problem signature:

P1: SQLyog.exe

P2: 1.0.0.1

P3: 4694ee6b

P4: StackHash_858a

P5: 0.0.0.0

P6: 00000000

P7: c0000005

P8: 7670ac79

P9:

P10: [/codebox]

My PC runs Vista Ultimate

[Marco Balk]

Just restarted my PC again, and now SQLyog starts without problems :huh:

[peterlaursen]

@Marco …

I would really like to know if your system is a Dual Core / Dual Processor too?

[Marco Balk]

Nope, it's not. It's a single core processor.

I can't remember exactly what kind of processor it is, but I guess it's an Intel. (Type PC: Fujitsu Siemens Esprimo)

[peterlaursen]

Did anybody experience this recently?

The reason that I ask is that I did not after installing a handfull of Vista updates from Windows Update about 2 weeks ago!

[Jimmy]

peterlaursen wrote on Sep 8 2007, 01:19 PM:

Did anybody experience this recently?

I just got a new Dell XPS m1330 laptop with Vista pre-loaded… going through trying to install all of my programs. I have not gotten SQLyog to work successfully yet. I've installed v6.07 (community version). During the install, a dialog box popped up warning me that I might need to restart the system if SQLYog hangs on launch. Sure enough, it hung on launch, so I rebooted. SQLYog then fired up successfully. I was able to log into my database (out on a hosted server), but that's it. I cannot run a query, I cannot expand the database structure… everything that attempts to “read” the DB hangs the SQLYog app.

Before loading any application, I went through all of the windows updates for Vista, so I should be running the “latest and greatest”. I also have not installed anything else yet, other than firefox (in order to download SQLYog), so with the exception of all the crapware that Dell threw on here, SQLYog is the only application installed.

Here are my system specs:

Vista Home Premium 32-bit

Intel Core2 Duo CPU T7100 1.8Ghz

2GB RAM

Here's an entry from my application log in the event viewer:

The program SQLyog.exe version 1.0.0.1 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: 160 Start Time: 01c7f76d0fe1bf5d Termination Time: 16

[codebox]

Fault bucket 82692990, type 5

Event Name: AppHangB1

Response: None

Cab Id: 0

Problem signature:

P1: SQLyog.exe

P2: 1.0.0.1

P3: 46dfa6f4

P4: 5f70

P5: 6144

P6:

P7:

P8:

P9:

P10:

Attached files:

C:UsersJimAppDataLocalTempWER3DBB.tmp.appcompat.txt

These files may be available here:

C:UsersJimAppDataLocalMicrosoftWindowsWERReportArchiveReport06a54c8a

[/codebox]

[peterlaursen]

'hanging' is another issue than 'crashing', I think.

Is it a remote or local server ?

How do you connect (direct, HTTP, SSH) ?

Can you absolutely positively that this does not happen with another SQLyog version/and Operating System when connecting to the same server with the same parameters ?

We have several DELL systems ourselves, but we purchase without any OS and preinstalled software. Currently i am wirting form A HP laptop (dv9000 sries) with preinstalled Vista and some softwares.

If you can allow us to connect to the server, you can crate a ticket with connection details. Ideally do like this: Create a new empty database and a new user (for us). GRANT that user all privileges to that databse only. Then we will not be able to access your data .. what we basically do not want either!

[Jimmy]

peterlaursen wrote on Sep 15 2007, 03:11 AM:

'hanging' is another issue than 'crashing', I think.

You're right… let me clarify just a bit. When I first installed it, it “crashed”. After a reboot, it no longer crashes, it hangs after trying to access the DB.

Quote:

Is it a remote or local server ?

How do you connect (direct, HTTP, SSH) ?

It's a remote server. I'm not sure how I log in, “directly” I assume… I simply use the SQLYog connection screen, entering the host address, user/pass, port (3306) and the database. I only have a “MySQL” tab. Whereas the help menu shows a screenshot with HTTP, SSH, and SSL tabs, I don't have these tabs.

Quote:

Can you absolutely positively that this does not happen with another SQLyog version/and Operating System when connecting to the same server with the same parameters ?

Yes, I am connected right now on my old Dell laptop, running XP and the exact same version of SQLYog, connecting with the same parameters. Everything is running fine on that system.

Quote:

If you can allow us to connect to the server, you can crate a ticket with connection details. Ideally do like this: Create a new empty database and a new user (for us). GRANT that user all privileges to that databse only. Then we will not be able to access your data .. what we basically do not want either!

Sorry, I do not have administrative access to this server or database.

One more piece of info: When I execute a query on my Vista system, the hang occurs while the app is “Executing Query(s)”. I see this down in the status bar. My task manager does not show the app as “not responding” until I start trying to click around in the SQLYog app. If I hit the “X”, or “File > Exit”, I get the dialog box saying “Could not close connection. Query(s) are being executed.” Hitting OK brings me back to the app, which now has a status bar that changed to “Ready”. However, the query has not returned a result, and I still have the “hour glass” cursor when hovering over the app (Vista's default is a spinny-circle icon). Task manager still says the app is “running”. After clicking on various spots, going through the menus (most of which are greyed out in this state), the task manager and app now finally say “Not Responding”.

[peterlaursen]

1)

“I only have a “MySQL” tab” .. OK .. you are using the COMMUNITY version!

2)

All this “My task manager does not show the app as “not responding” until I start trying to click around in the SQLYog app. If I hit the “X”, or “File > Exit”, I get the dialog box saying “Could not close connection. Query(s) are being executed.” Hitting OK brings me back to the app, which now has a status bar that changed to “Ready”. However, the query has not returned a result, and I still have the “hour glass” cursor when hovering over the app (Vista's default is a spinny-circle icon). Task manager still says the app is “running”. After clicking on various spots, going through the menus (most of which are greyed out in this state), the task manager and app now finally say “Not Responding”.”

I think I a few times have expericed something similar if connection broke while a query is running. It will not then retrieve results (of course), but SQLyog does not seem to 'be told' by the OS that connection is broken either. I will try to work with our test engineers on Monday to see if we can reproduce it consistently.

3)

Do you have any firewalls enabled (including the one shipped with Vista) ?

[Jimmy]

Jimmy wrote on Sep 15 2007, 12:22 AM:

I've installed v6.07 (community version).

peterlaursen wrote on Sep 15 2007, 12:11 PM:

1) “I only have a “MySQL” tab” .. OK .. you are using the COMMUNITY version!

Yep! :^)

Quote:

2) All this “My task manager does not show the app as “not responding” until I start trying to click around in the SQLYog app. If I hit the “X”, or “File > Exit”, I get the dialog box saying “Could not close connection. Query(s) are being executed.” Hitting OK brings me back to the app, which now has a status bar that changed to “Ready”. However, the query has not returned a result, and I still have the “hour glass” cursor when hovering over the app (Vista's default is a spinny-circle icon). Task manager still says the app is “running”. After clicking on various spots, going through the menus (most of which are greyed out in this state), the task manager and app now finally say “Not Responding”.”

I think I a few times have expericed something similar if connection broke while a query is running. It will not then retrieve results (of course), but SQLyog does not seem to 'be told' by the OS that connection is broken either. I will try to work with our test engineers on Monday to see if we can reproduce it consistently.

Hmmm… this happens for me consistently. I've opened SQLYog probably a dozen times now, and have not been able to run a single query. It simply goes into “executing query” mode, and then never does anything again. Meanwhile, I'll go over to my XP system and run querys all day long.

Quote:

3) Do you have any firewalls enabled (including the one shipped with Vista) ?

No, I've disabled the default firewall, and have not installed any other firewalls yet.

Okay, well hang on a minute… here's a monkey wrench… the system came with PC Cillin firewall/AV software. The first thing I did out of the box was to uninstall PC-Cillin. I just went in to the Windows Security area to verify that I did indeed turn off the firewall… and it looks like the system still has some PC-Cillin hooks somewhere. Windows does say that PC-Cillin is “turned off”, but the fact that it says anything at all about PC-Cillin now that I've uninstalled it means that not all of the hooks were killed (I even did the uninstall in safe mode). It's possible that some hangers-oners of the PC-Cillin software are affecting things. I think I'm going to go ahead and re-load the OS from the shipped disk (like I should have done in the first place). Hopefully I'll be able to get that accomplished soon, and report back.

Thanks for your time so far.

Jimmy

[peterlaursen]

this

http://code.google.com/p/sqlyog/issues/detail?id=208

.. might be related!

[Jimmy]

Update: Fresh install of Vista, no firewall software installed yet, Windows Firewall disabled, and the problem continues. I can (apparently) log in to my database, but SQLYog hangs when trying to access the database.

No joy on using the community version with Vista, yet. 🙁

[peterlaursen]

No other networking programs having problems?

What about MySQL Administrator, Query Browser?

It is a new PC. There might be hardware issues

This is NOT related to the crash at startup and we have no other such reports.

[Jimmy]

peterlaursen wrote on Sep 17 2007, 12:20 AM:

What about MySQL Administrator, Query Browser?

Good point… I dl/installed Query Browser 1.2.12, and it looks like I get the same problem. I can log on to the DB just fine, but it won't read the DB.

Quote:

It is a new PC. There might be hardware issues

This is NOT related to the crash at startup and we have no other such reports.

Looks like it's a problem with my setup, Vista, something local. I assume there are others using the community version of SQLYog, or even Query Browser, with Vista just fine??

Any recommendations on a forum to try and figure out what is causing my woes?

[peterlaursen]

We can simulate/reproduce the situation if we start a long running query and disconnect the network cable before result has returned.

It looks like a problem with the MySQL API on Vista in combination with a lost connection (possibly due to hardware error).

We will research into it to find more detailed information if we can!

[Jimmy]

peterlaursen wrote on Sep 18 2007, 12:11 AM:

We can simulate/reproduce the situation if we start a long running query and disconnect the network cable before result has returned.

It looks like a problem with the MySQL API on Vista in combination with a lost connection (possibly due to hardware error).

We will research into it to find more detailed information if we can!

Thanks for your time on this Peter. I've spoken with the server administrator, and it appears that he's having the same problems. We're calling it “a problem on the server end” at the moment. We also have an application that we use to talk to the database from client systems (this is a multi-player style game)… those client applications are also having problems talking to the server. So far it looks like the high-ports are what are giving us the problems, but we haven't narrowed it down to the server specifically, because we haven't been able to find anyone else using Vista to talk to a MySQL database to rule out an out-of-the-box-Vista problem.

Thanks again for your time.

[peterlaursen]

We reported this to bugs.mysql.com

http://bugs.mysql.com/bug.php?id=31109

[Author]

Posts