I. problem description
We have a usage scenario for canal:
Synchronize the same table data from multiple source ends to the same target end for unified data display.
However, it is found that after the field is deleted at source 1, the canal client logs of other sources will report an error:
Target column: name not matched
after that, the SQL operations of this table (such as insert, even if data is not inserted into the deleted field) cannot be synchronized.
II. How to avoid
In the scenario where multiple source ends are performing canal synchronization to the same target end, the drop field is prohibited.
Read More:
- SqlSession was not registered for synchronization because synchronization is not active
- Python learning notes (5) — cross entropy error runtimeerror: 1D target tensor expected, multi target not supported
- In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
- [error summary] Rsync remote synchronization: error password file must not be other accessible
- Word column after the text evenly distributed in the left and right two columns, rather than fill in the left column and then fill in the right column, how to do?
- Error in installing canal server for windows
- java.lang.IllegalArgumentException: column ‘_id’ does not exist
- Analysis of [error code [942], ora-00942 in synchronization of DDL statements in ogg
- Rsync client synchronization error
- Oracle ORA-00984:column not allowed here
- The problem of master-slave database synchronization stop caused by MySQL deleting data
- Jstack command execution error: unable to open socket file: target process not responding or hotspot VM not loaded
- ORA-12545: Connect failed because target host or object does not exist
- The key “target densitydpi” is not supported
- When the source side of Dameng synchronization tool HS starts the service, it prompts that the so file does not exist: libdmoci.so
- Non real time fast synchronization scheme for mobile devices
- TNS-12545: Connect failed because target host or object does not exist
- Wrong classification of Python — assertion cur_ Target is greater than or equal to 0 and cur_ Target is less than n_ classes failed
- Servicetask synchronization failed to set automatic retrying
- Uncaught Error: _registerComponent(…): Target container is not a DOM element