[c64audio]

I hope you don't mind me mentioning this Peter, but you seem to be treating all these ini reports as separate isolated instances: I myself have seen two different machines using different OSs upgrading from different versions of Enterprise to 6.06/6.07 fail to copy that ini file more than once (and have told you so in other threads here, such as the word wrap thread). Do you think it might be time to admit that the ini-copy feature is broken? I've never seen it work, either from 6.05 to 6.06 or from v5 Enterprise to 6.06, and had to copy the relevant files myself.

Chris

[c64audio]

No, consistently happens in a table with less than 10 columns: one common thing is that the tables tend to have text fields in them: although the text field is not necessarily showing in the results pane at the time of the problem (I'm usually editing a query output, not a table).

Chris

[c64audio]

peterlaursen wrote on Sep 4 2007, 09:24 PM:

Sorry for continuing asking questions like this!

Are you connecting to the same server and/or the same data all the time?

Is it reproducable even if you create a small silly table with 3-5 columns on 'localhost'?

I've seen it attached to different servers on different continents, both with direct access and SSH tunnelling.

I never tried the localhost thing though. One of my DBs on the Windows 2003 server is local.

Chris

[c64audio]

There is no application software common to both systems, except SQLYog itself and MySql server: not even Microsoft Office is installed in the 2003 Server machine.

Chris

[c64audio]

And I just replicated the problem on said Windows 2003 server, which is running pretty much nothing. This time, that installation wasn't even polite enough to create a dump: it just quit straight out. It only took about 10 pastes to get it to happen.

As a programmer (which I am), my next step would to think about possible ways in which the clipboard would get corrupted by the paste function rather than fixating on the fact that you can't replicate it: it's obvious here that I'm doing something different to you, and triggering a different code path. Somewhere, your program is corrupting memory.

As for people not complaining: (a) you'd be surprised what people put up with (after all, I've only just started complaining about it, but I've been putting up with it for months), and (:cool: probably not many people use SqlYog to do what I'm doing (mass data entry using keys and copy/paste in the results pane on the result of a query). So I wouldn't put much stock in that. I've had quite nasty bugs myself which have taken months for people to report.

Chris

[c64audio]

I'll add this, too: before it happens (after pasting the last successful cell, there's an odd pause of about 1/2 second. Then, though I can move about the grid, I know the next CTRL-V will result in a crash. That indicates that the clipboard is getting corrupted after being pasted that final time, so I guess the clipboard is pointing somewhere nasty at that point.

Interestingly after the crash I can still navigate round the software, click the menus and even right click, but the next action that requires any actual work, it exits.

Chris

[c64audio]

I have Microsoft Office XP installed, but I haven't noticed Office Clipboard being installed, so I'd say no.

Incidentally, I just installed SQLYog 6.06 stable enterprise onto a machine that previously had SQLYog 5.03RC1, and it lost the ini settings again: and I checked the steps that it displays while installing, and it didn't mention anything about migrating settings, copying ini files, or anything else.

So that's two machines it's happened on, and I did nothing special to install: download (didn't save to a dir first, just selected “run”), then install, follow prompts automatically, then start SqlYog automatically.

I'm testing the machine now, which is on the same LAN as the MySql server, and is running Windows 2003 server.

Chris

[c64audio]

peterlaursen wrote on Sep 3 2007, 09:01 PM:

“It always happens during a CTRL-V operation.”

I would like to ask you if you have an option to test with another system?

There might be something wrong with your system!

Anyway we will of course check this dump tomorrow (Tuesday)

It's 5 dumps. Could have been 6, since it just did it again.

Points to note:

1) Of course, it doesn't happen EVERY time I press CTRL-V.

2) I'm using keyboard control only during the time this happens.

Another system? I'll try tomorrow.

Chris

[c64audio]

peterlaursen wrote on Sep 3 2007, 11:32 AM:

We will try again to reproduce the fast data entry crash. Could you attache 1 or 2 dumps more (as

they may give a hint).

The last one wasn't even a fast data entry crash: it was just a CTRL-V crash. It always happens during a CTRL-V operation.

[attachment=738:dumps.zip]

[c64audio]

http://www.webyog.com/forums/index.php?showtopic=3419

It's the problem you couldn't replicate where SQLYog crashes with fast data entry with an error related to the clipboard (it crashes on CTRL-V).

Chris

[c64audio]

peterlaursen wrote on Sep 2 2007, 09:40 PM:

I understand you like you are talking about the BLOB viewer?

1) What is your setting in tools..preferences.. “enable wordwrap … ” . If checked it works OK for me.

2) “a search facility in that dialog box…” That dialogue box is (still) the BLOB viewer I think? Yes and I would even go further and say that plugins for the BLOB viewer similar to the image plugin (a simple HTML-editor, a HEX-editor, even a simple media player etc) would be nice! This has been on 'wishlist' for some time, but other issues have been considered more urgent!

Ah, this is probably a consequence of my old INI file not being copied over during 6.06 beta installation. I'll turn it on (my previous ini file survived about three years, so I forgot there was a word wrap option).

If word-wrap isn't turned on, the horizontal scrollbar doesn't seem to be able to get you to the end of the string, if you have one REALLY long string (for example, 2K), though you can get there with the cursor keys.

I'm still having that clipboard problem, and it happens every single time I do any data entry of note. You want some more dump files? Or maybe I should hypercam it?

Chris

[c64audio]

Marjolein Katsma wrote on Sep 1 2007, 10:53 PM:

Update – I found all the relevant log files:

• boot.log – nothing related to either sshd or mysqld for the relevant period of time
• messages – only relevant is a close of sshd session 4012 @ 21:06, which session was started

yesterday @ 8:55: that was me killing the session in SQLyog *after* MySQL had

“gone away”

• mysql's .err – shows mysqld has been running continuously since 2007-08-29 @ 22:55

So… neither mysqld nor sshd actually stopped on the server side during the relevant period; nothing on the server side (that I can find) that could cause this – and yet both clients (with the same plink.exe) report that “MySQL server has gone away”. Looks to me like plink.exe may be timing out after a (longish) period of idleness. But why can't it reconnect even then?

I've been complaining about “Gone Away” messages in another thread, mostly concerned with its behaviour over SSH tunnelling. I got no satisfactory answer then, after they'd fixed structure sync.

Chris

[c64audio]

peterlaursen wrote on Aug 20 2007, 09:34 PM:

1) Please refer to the beta1 release notes: From 6.06 beta 1 the .ini file is no longer read from installation folder but from user's 'application data' folder.

2K,XP,2003: /documents and settings/user/application data/sqlyog (i think, but currently I only have Vista available!)

Vista: /users/user/AppData/Roaming/SQLyog

(note that folder names may be localised/non-english)

First time the program is opened after install of 6.06 the .ini, .err and .log files are copied to the new position (and a backup left in original position). Did that copy process fail for you? We have tested it VERY MUCH and have no other reports of such failure!

2) I think we should try to reproduce with a so-called 'slow connection'- it might be a buffer that runs over if user is faster than the connection!

Is it a SSH-connection that you use when reproducing or any kind of conenction?

1) There's an ini file there (now), but it was either new or missing when I first booted 6.06, since the contents of the original file just didn't make it over to the new place. The XP account concerned has admin permissions, and is pretty much the only account used on the machine.

2) I've seen the crash on SSH and non-SSH connections.

Chris

[c64audio]

The new beta ignores my previous connections I set up: I find an sqlyog.bak.ini in that directory which now has that information in it, but SQLYog doesn't read it any more.

I'm sure the data entry crash bug is to do with the speed at which I'm entering the data and the slight pause while the data is updated meaning something's getting triggered wrong.

Chris

[c64audio]

OK, that fixed the “copy database” bug, thanks.

Chris

[Author]

Posts