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
更多人大金仓数据库信息，详见https://www.kingbase.com.cn/
