Forum Replies Created
-
AuthorPosts
-
Tirpune
Memberpeterlaursen wrote on Oct 6 2006, 02:39 PM:it will/should work with UPDATES too.a md5()-checksum is is generated on the column(s) on both hosts. If they diifer the source-row will owerwrite the target row.
Could we see the jobfile? (fake details as you like).
You can create a ticket if you do not wnat to expose it in public.
The UPDATE concerns FILE_CONTENT column so shouldn't that be included also.
And that gets us right where started… 🙂
Memberpeterlaursen wrote on Oct 6 2006, 02:39 PM:it will/should work with UPDATES too.a md5()-checksum is is generated on the column(s) on both hosts. If they diifer the source-row will owerwrite the target row.
Could we see the jobfile? (fake details as you like).
You can create a ticket if you do not wnat to expose it in public.
localhost root xxx 3306 utf8 opencms xxx root 3306 utf8 opencms `CMS_BACKUP_CONTENTS` `CMS_BACKUP_PROJECTRESOURCES` `CMS_BACKUP_PROJECTS` `CMS_BACKUP_PROPERTIES` `CMS_BACKUP_PROPERTYDEF` `CMS_BACKUP_RESOURCES` `CMS_BACKUP_STRUCTURE` `CMS_GROUPS` `CMS_GROUPUSERS` `CMS_OFFLINE_ACCESSCONTROL` `CMS_OFFLINE_CONTENTS` `CMS_OFFLINE_PROPERTIES` `CMS_OFFLINE_PROPERTYDEF` `CMS_OFFLINE_RESOURCES` `CMS_OFFLINE_STRUCTURE` `CMS_ONLINE_ACCESSCONTROL` `CMS_ONLINE_CONTENTS` `RESOURCE_ID` `CMS_ONLINE_PROPERTIES` `CMS_ONLINE_PROPERTYDEF` `CMS_ONLINE_RESOURCES` `CMS_ONLINE_STRUCTURE` `CMS_PROJECTRESOURCES` `CMS_PROJECTS` `CMS_PUBLISH_HISTORY` `CMS_STATICEXPORT_LINKS` `CMS_SYSTEMID` `CMS_TASK` `CMS_TASKLOG` `CMS_TASKPAR` `CMS_TASKTYPE` `CMS_USERS` Memberpeterlaursen wrote on Oct 6 2006, 11:30 AM:I meant RESOURCE_ID of course.as ther is a Unique Index on RESORUCE_ID that column must be unique
Column RESOURCE_ID didn't do the trick. When through fine but without the results you (and I) where hoping.
What do think of my comment about the updated content (existing rows)?
Memberpeterlaursen wrote on Oct 5 2006, 04:14 PM:OK .. now I think I understandthe problem is that the concatted strings that SJA need to generate to build checksums with become to long compared to some buffer settings on the server (or the memory available) for those rows where FILE_CONTENT are largest. It is a LONGBLOB column and can be as big as 4 GB.
Can you name any settings that could affect this?
peterlaursen wrote on Oct 5 2006, 04:14 PM:Use theoption in the jobfile. Read about it here: http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf
as the column IDX1 is unique, you use that single columns with the
option and concatted strings will be very short! And sync will be MUCH faster too. I tried and got an error:
Error No. 1054
Unknown column 'IDX1' in 'field list'
IDX1 is not a column, is it? Did you maybe mean the CONTENT_ID or RESOURCE_ID?
On the other hand if I understand you correctly this would only work with inserts and deletes but not with updates to existing content?
Memberpeterlaursen wrote on Oct 5 2006, 04:14 PM:OK .. now I think I understandthe problem is that the concatted strings that SJA need to generate to build checksums with become to long compared to some buffer settings on the server (or the memory available) for those rows where FILE_CONTENT are largest. It is a LONGBLOB column and can be as big as 4 GB.
Use the
option in the jobfile. Read about it here: http://webyog.com/en/whitepapers/Using_SQL…L_Databases.pdf
as the column IDX1 is unique, you use that single columns with the
option and concatted strings will be very short! And sync will be MUCH faster too. Great! I'll try that tomorrow morning and will let you know how it went. Thanks!
Memberpeterlaursen wrote on Oct 5 2006, 02:20 PM:what is that equivalent in rows?mysql>show table status;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+| CMS_ONLINE_CONTENTS | MyISAM | 10 | Dynamic | 6524 | 111700 | 1060443632 | 281474976710655 | 936960 | 331708824 | NULL | 2006-05-24 16:07:23 | 2006-10-05 14:18:59 | | utf8_general_ci | NULL |
Memberpeterlaursen wrote on Oct 5 2006, 02:09 PM:do you use thetag in your XML ? No.
localhost root xxx 3306 opencms xxx root 3306 opencms Memberpeterlaursen wrote on Oct 5 2006, 01:40 PM:is this the case on both servers?how is the charset dropdown/
tag for BOTH connections? Always inform about Program versions!!
MySQL versions?
Platform on which the servers run?
SJA version?
SJA for Linux or Windows?
The charset is identical.
>>MySQL versions?
mysql-4.1.12-3.RHEL4.1
>>Platform on which the servers run?
Red Hat Enterprise Linux ES release 4 (Nahant Update 2)
>>SJA version?
5.18
>>SJA for Linux or Windows?
Linux
-
AuthorPosts
