[peterlaursen]

is it a 32 bit or 64 bit Ubuntu?

Obviously the executable starts, but it does not find a single table (it would print everyone it finds). Also it will log when job has ended if it ends normally – and it did not!

Can you see if the sja process gets terminated or is still running after a while and what status it has? (I don't know what tools Ubuntu has for this, but some process viewer must be there!)

[peterlaursen]

I only asked this question because a developer asked if the table was very 'wide' (having hundreds of columns)

[peterlaursen]

I am sorry, but I never heard that.

Do you know what the problem should be?

Are you sure that this is not a problem with a specific client (maybe phpMyAdmin) ?

How would you migrate the database? With SQLyog I do not see any problems no matter if you

* export/import

* copy to other …

* use the Migration toolkit

* or use Data Sync

[peterlaursen]

You will find another recent discussion here if you search a little!

The way we currently reconnect with SSH will work if connection is lost between mysql and sshd. Not if it is lost between plink and sshd. We will research if/how we could possible re-instantiate plink too when connection is SSH type.

[peterlaursen]

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'?

[peterlaursen]

Once we get trained reading as fast as you can write we will consider this … 😛

[peterlaursen]

Quote:

Not running Vista, but XP Pro with SP2. If I dont click the ok on the pop up I can continue to run without any problems. I only have this issue on my laptop which has a duo core processor, no problems on my PC at home.

Actually most (but not all) of the reprots with Vista were dual processor systems too.

Does it happen occasionally or every time on that system?

[peterlaursen]

OK .. it really looks like we should consider to re-initiate PLINK too.

For most of this week we will be busy 'merging' code from 4 contributors into the first 6.1 build. After that we will to schedule this!

[peterlaursen]

Quote:

Thanks, that has solved it.

Sorry but what is THAT and what is IT?

did you copy the backup (and renamed it) to the new position? And old connections now appeared as well as you can now save connections?

If it was not like that then please explain in detail what you did and with what results!

[peterlaursen]

It is true that cheaper hosting plans often only give a user a single databse. Prefixing is then the common solution to keep some kind of structure when more aplications have tables in that database!

Currently the same prefix will have to be used on every host!

[peterlaursen]

Quote:

Somewhere, your program is corrupting memory.

There is no program that you have installed on both systems that may do this (corrupt memory) and interact with SQLyog .. a driver for instance? Do you use the same Firewal/AV software on those systems for instance?

Of course not everyone would report. But still we tried on quite a lot of systems and spent at least 10 hours trying to 'catch' this crash. And of course we have been reviewing the code too.

But let's see if your latest dumps will give more hints.

[peterlaursen]

This CTRL-V crahs is absolutely not reproducable for me (and the rest of us are sleeping!). However I am also pretty sure that we would have heard about it before if it was a general problem.

Do you have any software installed that enhances or changes clipboard functionality?

[peterlaursen]

@Odaat ..

I think this is not quite the same request as the previous posts!

What you are requesting is an option to associate .sql files with SQLyog. If you double click it 1) SQLyog will open

2) The query will be pasted into an empty SQL-editor tab

3) .. and executed

1) is no problem, but 2) and 3) raises some problems – or at least discussions

The problems are two:

1) If SQLyog is not open (or if no connections are open) we will need to open the connection dialogue! The query itself has no information about against WHICH server the query shall be executed. So the connections dialogue will have to be completed by user before proceeding.

2) If more connections are open which one should be used?

Do I understand you correct that you propose ONE connection defined as the DEFAULT CONNECTION and this one should be used?

[peterlaursen]

Just FYI: we cannot either consistently reproduce any different behaviour with the different versions in our own test.

Currently reconnection is attempted only once. We discussed:

1) providing a configuration option for user to set the # of reconnects

2) if first reconnect is not succesfull we could wait/sleep() for some time (say 200-ms or 500 ms) before trying again. The philosophy is that it will not make much sense to try again only a few milliseconds after failure. The remote host or or some network gear (routers, switches, transmitters) in the connection chain might need a little time …

Also reconnection with SSH tunnel assumes that PLINK is alive. We do not re-instantiate PLINK. But I also do not think it is the problem that PLINK dies (except if it is explicitly killed by user, of course!).

[peterlaursen]

“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)

[Author]

Posts