Problems with SJA – Linux Version

[acmbc]

Hi,

We are trying to use the command-line linux version of SJA to synchronize two remote databases.

We are encountering error 1064 on several tables. This error only occurs in relatively few of the records in the tables, but results in the dbs not being properly synchronized.

I should note that the field data in these tables contain many accented characters (portuguese) as well as text fields.

I am sending an sja.log file for a synchronization operation which contains these errors (I have NO idea where the p&!!…..etc. strings come from. They are NOT in the field data.

SJA.LOG:

Sync started at Thu Mar 25 02:58:56 2004

Error No. 1064

You have an error in your SQL syntax near 'p&‼Bp&‼B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'h&‼Bh&‼B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'X&‼BX&‼B' at line 1

Error No. 1064

You have an error in your SQL syntax near '°%‼B°%‼B' at line 1

Thanks for any help!

Augusto Carvalho

[Shadow]

I did encounter similar problems regarding special Central European characters. It turned out that the backup db had wrong character set setting…

[acmbc]

I haven't checked the character set on the dbs – the “backup” db was created from a snapshot of the master db, and all the data *appears* right. I can try reexporting and specifying the character set to use.

[acmbc]

Nope – don't think it's the character set. For testing purposes, tried synchronzing between 2 db's on the same MySQL installation (they would have the same character sets). Still get the errors.

Any ideas?

[Shadow]

Well, then I have no idea what could cause your problem. Doest the replication fail only on those records that contain special characters?

[acmbc]

Yes, as an example, one of the tables we are replicating – a product list – causes 4 failures out of 2515. Obviously this is only representative of the number of changed records since we made the “baseline” snapshot.

We have tried replicating between 2 db's on the SAME server, as I said, and the problems still occur. As for the character sets, our production db is in 3.23.54, which does not seem to like explicit naming of characters sets, at the table level at least!

[Shadow]

Well, you should ask Ritesh, if you could send him the problematic records (given it's possible) and if he could debug sja using your data.

MySql 3.x supports only one character set/server…

[Ritesh]

It will be very nice if you can email me a backup of the database.

[Shadow]

He even volounteers, you don't need to ask! 😀

[floyd]

Hello,

I also encounter the same problem with using in linux verson

Error No. 1064

You have an error in your SQL syntax near 'h4Bh4B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'x5Bx5B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'h5Bh5B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'X5BX5B' at line 1

Error No. 1064

You have an error in your SQL syntax near 'À4BÀ4B' at line 1

my DB just have Eng. and Daytime. No any special language.

and my MySQL version is 3.23.58-1.80 and 3.23.58-1.73 (Redhat rpm)

any ppl have idea?

Floyd

[Shadow]

Do you use any unusual (special) characters?

[floyd]

no….

the following is a row of my DB

404080804 20040408 07:30 26 2 804 810 a 1 0 0 2004-04-08 07:30:00

just “:” and “-” two symbol

Floyd

[Shadow]

Then – unfortunately – I cannot help. I don't have any computers around running linux…

[webshowpro]

Has there been any progress on this issue?

The same thing is happening to me.:

Error No. 1064^M

SQL server version for the right syntax to use near 'Ã<8f>^SBÃ<8f>^SB' at line 1

I use a cryus IMAP installation, and the database that is giving me trouble is used to authenticate IMAP users, the data basicaly is usernames and addresses and passwords

I am running Mysql 4.0.15, on a RedHat 8.0 installation. I- I don't know how to tell which records specifically are causing the problem. Ot is happening on four records out of about 3000.

-Brandon

[darthwonka]

I have the same problem.. sync worked a couple times then just started getting Error 1064 on one of our tables.

Error No. 1064^M

You have an error in your SQL syntax near 'order='3', display_thumb='0' where `id`='211'' at line 1^M

Error No. 1064^M

You have an error in your SQL syntax near 'order='2', display_thumb='0' where `id`='210'' at line 1^M

Error No. 1064^M

You have an error in your SQL syntax near 'order='0', display_thumb='0' where `id`='208'' at line 1^M

Error No. 1064^M

You have an error in your SQL syntax near 'order='1', display_thumb='0' where `id`='209'' at line 1^M

Sync started at Thu May 20 11:49:29 2004

All of these 'id's it is looking to match do not exist in the table. Also, of note, the id's are not necessarily in sequencial order.

Thanks for any assistance.

( I emailed Ritesh with a backup of the table)

[Ritesh]

Hello,

Which version of MySQL?

Can you attach a dump of the database?

[darthwonka]

Quote:

Hello,

Which version of MySQL?

Can you attach a dump of the database?

The dump should be in your inbox… if you need it in another format, let me know.

I am currently using mysql-server-3.23.58-1.9 on both machines.

[Ritesh]

I have received the dump. Thanks 🙂

[Author]

Posts