Error In Sync Job

[eddierosenthal]

i created wordpress tables both locally and remote.

i have wp_posts locally with data and am trying to sync the table

to the remote database.

i am attaching the jobfile, the errorlog, and a jpg showing the

job completed.

There is no error, and it shows it completed successfully.

However the remote data has not changed!

There are still only 1221 rows , although the job shows there

`wp_posts` 31370 1221 30149 0 0

are 30149 new rows inserted…

here is the structure of the table

/*

SQLyog Enterprise – MySQL GUI v8.14

MySQL – 5.1.36-community-log : Database – wordpress

*********************************************************************

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*Table structure for table `wp_posts` */

CREATE TABLE `wp_posts` (

`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`post_author` bigint(20) unsigned NOT NULL DEFAULT '0',

`post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`post_content` longtext NOT NULL,

`post_title` text NOT NULL,

`post_excerpt` text NOT NULL,

`post_status` varchar(20) NOT NULL DEFAULT 'publish',

`comment_status` varchar(20) NOT NULL DEFAULT 'open',

`ping_status` varchar(20) NOT NULL DEFAULT 'open',

`post_password` varchar(20) NOT NULL DEFAULT '',

`post_name` varchar(200) NOT NULL DEFAULT '',

`to_ping` text NOT NULL,

`pinged` text NOT NULL,

`post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`post_content_filtered` text NOT NULL,

`post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',

`guid` varchar(255) NOT NULL DEFAULT '',

`menu_order` int(11) NOT NULL DEFAULT '0',

`post_type` varchar(20) NOT NULL DEFAULT 'post',

`post_mime_type` varchar(100) NOT NULL DEFAULT '',

`comment_count` bigint(20) NOT NULL DEFAULT '0',

PRIMARY KEY (`ID`),

one of the fields is a longtext field with html in it.

[peterlaursen]

If SJA.log tells that rows were inserted then INSERT statements were fired but INSERTs did not succeed. This could be a server issue or incorrect INSERT syntax generated by SJA.

1) I can see that you are using version 8.14. Would you mind try 8.71?

2) Try the option to 'generate sync script', open the sync script in an editor and check an insert statement if it looks OK. (and maybe even try to execute such one).

3) What is 'max_allowed_packet' setting on server? If it is 1M (default) could you try to raise the setting? How big is a single row of the table approximately (min and max).

4) What is your setting as regards 'continue on error' ?

5) Also if you could you share a dump of the table from both hosts it would make things easier. Please contact us a [email protected] for arranging this.

[peterlaursen]

OK .. the jobfile answers the question about 'abort on error'. It is – what surprises me.

DATA for the case would be much appreciated.

[peterlaursen]

I can also see that you are using HTTP tunnel. That could very well be part of the problem. I think there were some fixes lately. So please try 8.71.

[eddierosenthal]

'peterlaursen' wrote:

I can also see that you are using HTTP tunnel. That could very well be part of the problem. I think there were some fixes lately. So please try 8.71.

ok i purchased the upgrade installed and copied the SQLyogTunnel.php to destination. same error – here it is.

Sync started at Sun Dec 26 11:05:01 2010

`wp_posts` 30062 0 Error No. 1

Error in tunneling. Please send the HTTP response to http://www.webyog.com/support

this was during a direct sync from the sqlyog ultimate program latest version.

i will try the cmd line interface next.

ok that failed.

i could not attach the data, it was too big to upload.

[peterlaursen]

“Error no. 1” means that the HTP-response is not usable for HTTP tunnel. Please first tell: Can you connect to the tunneler from a browser and does the page display OK?

[nithin]

Hello,

I remember we have already discussed about the case “Error no.1” that you reported last month.

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

Instead of showing “Error No.1” for all the errors returned by Tunnel we plan to log the exact error in one of the upcoming versions. For you it happened because the target table is empty and SQLyog frames BULK INSERT query for 1000 rows returned from source and the memory allocated to PHP is less to handle this received BULK query. So please use the option “-r” as explained in previous post.

Code:

– Save the data sync job file
– Run the job from the command prompt >sja dsync_job.xml -r20
(this -r option retrieves 20 rows at a time from the source server and frame BULK INSERT query to the tunneler, by default it was 1000 rows. You can try different values also)

Your first post of this thread says: `wp_posts` 31370 1221 30149 0 0

No. rows in source:31370

No. rows in target:1221

But your latest replay it became: `wp_posts` 30062 0 Error No. 1

It means no. of rows in target table is 0.

Can you tell us whether you have emptied the target table since the first time of operation? Or is the target server a live server which undergoes continuous insertions and deletions?

Regards

Nithin

[nithin]

Quote:

There are still only 1221 rows , although the job shows there

`wp_posts` 31370 1221 30149 0 0

are 30149 new rows inserted…

It happened because you selected the option “Generate Script”. So it wont sync the data to target database unless you will not import the “Generated SQL script” at target server. If you want to sync it immediately you have to select the option “Direct sync”

The job file you attached contains directsync” /> if you select the option 'Direct sync'. You can edit the job file and change to 'directsync'.

See the screen-shot attached.

-'Direct sync': This option will sync immediately as the sync tools finds differences in the table.

-'Generate script only': It generates SQL sync script for later execution

-'Sync & Generate script': This options can be selected if you want a log of what the 'direct sync' did on the database(s).

[Author]

Posts