Export Bug – Too Much Rows

[fcx]

Hi,

It's about one bug I encountered since version 6.04 – 6.07 (previous 5.15 was OK) and is still present in the last 6.12 release.

When you export the result of a query in CSV format, if SQLYog lost the focus (you're doing something else during the export), the number of rows exported is false.

It seems that SQLYog restarts with previous rows each time it has the focus again. Not exactly from the beginning.

The number of rows is correct if you let SQLYog and your PC quiet during the export.

Thanks in advance

[peterlaursen]

We will try do reproduce!

If you can provide more specific instruction in how to reproduce then it would be appreciated!

[fcx]

Nothing special to reproduce :

• Make a query with enough rows to test (1.000 – 10.000)
• Note the number of rows
• Export as
• For the format, I'd try CSV with column names and “Fill Excel friendly values” bouton
• Choose the name of the file
• OK
• during the export, do something else on your machine with other windows
• When finished, see the number of rows exported

If you don't reproduce, I would give you information about the MySQL Server version or my PC configuration if you like

Thanks

[peterlaursen]

could you tell what other applications you would typically have running at the same time as SQLyog?

[fcx]

peterlaursen wrote on Nov 13 2007, 07:21 PM:

could you tell what other applications you would typically have running at the same time as SQLyog?

• Explorer
• Excel (Office 2003)
• Outlook
• Word
• DOS command
• Opalis client (Job scheduling software)
• ADS client (Advantage Database middleware for Clipper)

I reproduced the same bug on 3 differents PC (the 2 other ones without Opalis). All are under Windows XP SP2.

[fcx]

One new test, closing every thing I could, including resident programs in system tray.

I just had SQLYog with 11.653 rows and 3 Windows explorer. Changing between the 4 windows with mouse during half the time. My export has 18.463 rows.

[peterlaursen]

And this happens for you with all tables (big enough to take the necessary amount of time to export) and not only specific tables?

[fcx]

yes, on every query I've tested

[peterlaursen]

Still not reproducable!

Server version?

Table Engine?

We have to be sure that your indexes or tablespace is not corrupted!

Do you consistently use PK's in your tables?

Did you try 'repair table' (if MyISAM)?

With InnoDB the ultimate repair is to export and import again!

still waiting for the breakthrough here!

[fcx]

Server 5.0.22

MyISAM tables without PK or InnoDB without PK on differents schemas

If tablespaces or indexes are corrupted, I think I didn't get the good result before export.

[fcx]

New test :

Same thing with a single request “select * from tableA” on another schema using InnoDB tables with PK, FK and all normal DB constraints.

[peterlaursen]

So weird only that we cannot reproduce when it is so simple for you to do!

Do you have access to another server (alternatively we may create an account for you on our server) ?

Do you have an option to try on another client machine?

[peterlaursen]

not required.

Finally we 'caught it in the act' . Now we can debug this, I think!

[fcx]

Same test with a new server installed this morning with the last 5.0.45 release and updated SQLYog 6.13 (to have my connection list back :roll:)

After copying a schema from one server to the new one using SQLYog 🙂

and same result.

As I said before, I've allready tried 2 other PCs with the same effect

[fcx]

peterlaursen wrote on Nov 16 2007, 01:19 PM:

not required.

Finally we 'caught it in the act' . Now we can debug this, I think!

Thanks

[peterlaursen]

We were not able to finish analyzing this with 6.14 RC. Now it is absolutely priority #1.

[fcx]

Don't worry, I'll wait for 6.15.

We just know we've to be patient when exporting and do it with attention. Coffe time 😉

Thanks for this product

[Mahesh]

HI,

Issue Confirmed !

Exporting more number of rows but happening only in Xp not in vista.

We are looking into this issue

[peterlaursen]

Now fixed! We will release *something* shortly!

[peterlaursen]

Please verify the fix for this issue with this build:

ENTERPRISE link:

http://www.webyog.com/downloads/betas/not_…QLyog614Ent.exe

COMMUNITY link:

http://www.webyog.com/downloads/betas/not_…d/SQLyog614.exe

[fcx]

It seems to be longer (back to V5.15 speed) but it's much better !

Thanks a lot for this

I'm waiting the 6.15 stable

[Author]

Posts