Error while comparing data

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
orcodb
Posts: 2
Joined: Tue 29 May 2018 08:30

Error while comparing data

Post by orcodb » Tue 29 May 2018 09:40

Hello guys!

I've been using the evaluation trial to compare and synchronize data on a deprecated DB we have, to store it in a new machine.

The program itself runs really well, but for some reason, when the table is too big, the server stops, always in the same spot (when it reaches 2.4 million objects approximately, it gives an error, see screenshots).

https://imgur.com/oQgtbBX

Error:

https://imgur.com/cCiHTGT

It translates to: "An attempt was made to move the file pointer before the beginning of the file." The error doesn't say much to be fair, but neither in Output nor the db servers itself, leaves any other message.

https://imgur.com/pIngqsv

We've changed all the timeout values, max packets allowed, maximum size of each packet... But no success.

dbforge version is 7.4.201 and we are using the Standard Version (evaluation).

Let me know if you need further info, I'll provide it. Hopefully you can give us some more insight as we have no clue what could be happening.

Thanks in advance

alexa
Devart Team
Posts: 2719
Joined: Fri 24 Jun 2011 14:17

Re: Error while comparing data

Post by alexa » Wed 30 May 2018 09:51

We will investigate this issue and will answer you as soon as possible.

alexa
Devart Team
Posts: 2719
Joined: Fri 24 Jun 2011 14:17

Re: Error while comparing data

Post by alexa » Wed 30 May 2018 15:43

Could you please provide us the versions of the Source and Target servers and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.

Also, if possible, please try to determine the object that caused the error (it should be mentioned at the end of the log file) and provide us its CREATE definitions for both Source and Target.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

orcodb
Posts: 2
Joined: Tue 29 May 2018 08:30

Re: Error while comparing data

Post by orcodb » Thu 31 May 2018 09:53

Hi alexa!

Thanks for reaching out.

I uninstalled the standard version yesterday, and today I saw your comment so I installed the enterprise edition (evaluation still). Now it suddenly works?! It doesn't crash at 2.4 million objects, it just goes without errors!

Is there any limitation on the Standard version for some reason?

Thanks for your help! :)

alexa
Devart Team
Posts: 2719
Joined: Fri 24 Jun 2011 14:17

Re: Error while comparing data

Post by alexa » Thu 31 May 2018 13:44

There is no limitation. it's limited only by the amount of features included https://www.devart.com/dbforge/mysql/st ... tions.html

Post Reply