KFS同步过程中遇到的问题

1、[flysync@kes130 tools]$ ./fspm install

Your system does not appear to have a ruby interpreter installed

Please install ruby and ensure that ‘ruby --version’ works

解决方法：yum install -y ruby

2、ddl语句可以同步，但是dml失败

解决办法：源端高级设置配置replicate过滤，值为要同步的用户或表（大写）do:FLYSYNC_ORACLE.*

然后点击安装/更新生效

3、源端kfs服务一直报offline，查看日志

解决办法：授予flysync用户oinstall组

4、双轨部署完成后，一键切换失败，提示表不可以update

解决办法：清理同步日志号-原因是部署kfs之前oracle的同步用户和kingbase的用户表结构不一样（正常要求同步用户的结构内容都要一直）执行清理日志就是跳过报错的表继续进行

oracle端：

cd /home/flysync/kfsrep/releases/KingbaseFlySync-V001R006C004B20220309-replicator_pid24952/flysync-replicator/bin

replicator start

fsrepctl -service source_oracle offline

fsrepctl -service source_oracle reset -all -y

replicator restart

ip:kingbase

[flysync@kes130 ~]$ cd /home/flysync/kfsrep/releases/KingbaseFlySync-V001R006C004B20220309-replicator_pid74995/flysync-replicator/bin

replicator start

fsrepctl -service kingbase8 offline

fsrepctl -service kingbase8 reset -all -y

replicator restart
[flysync@kes130 bin]$ fsrepctl -service kingbase8 offline

[flysync@kes130 bin]$ fsrepctl -service kingbase8 trigger-enable -schema PUBLIC -y

[flysync@kes130 bin]$ fsrepctl -service kingbase8 online

5、./fspm install 报错如下

WARN >> 192_168_136_130 >> ntpd is not running. It is important that configured hosts have time synchronised. (NtpdRunningCheck)

WARN >> 192_168_136_130 >> Linux swappiness is currently set to 20, on restart it will be 20, consider setting this to 10 or under to avoid swapping. (SwappinessCheck)

ERROR >> 192_168_136_130 >> There was an error processing the query: ERROR: Unable to load driver: com.kingbase8.Driver

ERROR >> 192_168_136_130 >> undefined method `include?’ for nil:NilClass

ERROR >> 192_168_136_130 >> There was an error processing the query: ERROR: Unable to load driver: com.kingbase8.Driver

#####################################################################

Validation failed

#####################################################################

#####################################################################

Errors for 192_168_136_130

#####################################################################

ERROR >> 192_168_136_130 >> There was an error processing the query: ERROR: Unable to load driver: com.kingbase8.Driver (KingbaseVersionCheck)

ERROR >> 192_168_136_130 >> undefined method `include?’ for nil:NilClass (KingbaseVersionCheck)

ERROR >> 192_168_136_130 >> There was an error processing the query: ERROR: Unable to load driver: com.kingbase8.Driver (KingbaseDecoderbufCheck)

解决办法： 将kingbase8-8.6.0.jar包拷贝到/home/flysync/KingbaseFlySync-V001R006C004B20220309-replicator/flysync-replicator/lib下

cd /home/flysync/KingbaseFlySync-V001R006C004B20220309-replicator/extensions/jdbc

[flysync@kes130 jdbc]$ cp kingbase8-8.6.0.jar …/…/flysync-replicator/lib