[peg110]

peterlaursen wrote on Aug 24 2007, 08:11 AM:

If you sync first time to an empty database, there is no real sync going on – only a copy process. Syncing to empty target and target with data is not comparable.

To me it simply looks as if connection was lost 2nd time you sync'ed! After that “SHOW FULL FIELDS FROM …” retrives nothing for every table that follows and the sync for every table will then have to be skipped.

Ok, but WHY?

Why will it (everytime) Lose it's connection after the first (essentially) database copy?

Why will it not sync?

[peg110]

peterlaursen wrote on Aug 22 2007, 03:40 PM:

Now … quite some time has passed since version 5.21. This verson was one of the first Open Source releases and there were some what we call 'refactoring bugs' in there.

The memory of the radar has expired. A new image of the enemy has to be spotted! 🙂

We have to concentrate on the 6.x code tree! For the simple reason that if there was and still is an issue we cannot 'fix backwards'. Only in future versions we can!

Could you upgrade to latest 6.x build? Or install the 6.x trial? If both are not possible please create a ticket and we will find a solution!

Well, I upgraded and it seems to work now. That is atleast for the FIRST time. (getting the structure and the initial round of data across.) As a side note, I did manage to get the 5.21 version to work as long as the user was NOT root.

Anyway, as I said I did get it to work with the 6.05 version. BUT after I tried to run it a subsequent time (to actually SYNC the databases), I got a lot of errors.

Code:

Sync started at Fri Aug 24 07:25:10 2007

`articles` 34 34 1st Phase : 0 0 1st Phase + 2nd Phase : 0 0 16
`articles_toc` 13 13 1st Phase : 0 0 1st Phase + 2nd Phase : 0 0 8
`pages` 4 4 1st Phase : 0 0 1st Phase + 2nd Phase : 0 0 4
`phpbb2_auth_access` 13 13 WARNING: No primary key found in table `phpbb2_auth_access`. This might result in error.1st Phase : 0 0 1st Phase + 2st Phase: 0 0 0
`phpbb2_banlist` 79 79 1st Phase : 0 0 1st Phase + 2nd Phase : 0 0 0
`phpbb2_categories` 5 5 1st Phase : 0 0 1st Phase + 2nd Phase : 0 0 0
`phpbb2_config` 61 61 Error No. 2013

Lost connection to MySQL server during query

1st Phase : 0 0

MySQL server has gone away – Could not get FIELD information for '`phpbb2_confirm`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_disallow`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_forum_prune`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_forums`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_groups`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_posts`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_posts_text`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_privmsgs`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_privmsgs_text`' in the SOURCE dtabase
MySQL server has gone away – Could not get FIELD information for '`phpbb2_ranks`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_search_results`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_search_wordlist`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_search_wordmatch`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_sessions`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_smilies`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_themes`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_themes_name`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_topics`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_topics_watch`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_user_group`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_users`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_vote_desc`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_vote_results`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_vote_voters`' in the SOURCE database
MySQL server has gone away – Could not get FIELD information for '`phpbb2_words`' in the SOURCE database

So now what?

[peg110]

peterlaursen wrote on Jan 20 2007, 02:31 AM:

Code:

Ok, I suppose the WIZARD completed successfully, but the JOB did not!

Yes .. that is what it says!

Obviously you cannot authenticate!

That's what the error indicates, however, I am able to use SQLYog to access both servers individually, access tables, Query, update, delete, create tables and databases, and virtually anything I want. So IS authentication REALLY the issue? I dunno… that's why I am here.

peterlaursen wrote:

1) Please doublecheck user and password DONE. Everything is OK!

2) Run the wizard but select to save the jobfile (and not execute). Are user details in the jobfile OK? Yes… See Code Block below.

3) Try a 'Notifications Service' job on that server. for instance juste execute 'SELECT'1';” …

Same result as the SYNC job. But again, I can run the query manually and it works fine.

Questions:

1) do you use any kind of tunnelling? NO

2) if not does user have access from remote machines? YES

Here is the “Saved” job file.

Code:

192.168.254.105
root PASSWORD 3306 [default]
DBTABLE

192.168.254.102
root PASSWORD 3306 [default]
DBTABLE

All tests or attempts to resolve this problem (listed above) were run from a Windows XP sp2 machine at ip address 192.168.254.30.

Any thoughts would be wonderful.

P.S. I haven't gotten back to this post in a while because of other pressing issues, this fell off the radar. Now… It's back. Again, HELP (please).

[Author]

Posts