已解决
自制数据库迁移工具-C版-02-HappySunshineV1.1-(支持Gbase8a)
来自网友在路上 166866提问 提问时间：2023-10-25 17:08:23阅读次数： 66
最佳答案 问答题库668位专家为你答疑解惑
目录
一、环境信息
二、简述
三、升级点
四、支持功能
五、安装包下载地址
六、配置参数介绍
七、安装步骤
1、配置环境变量
2、生效环境变量
3、检验动态链接是否正常
4、修改配置文件MigrationConfig.txt
八、运行效果
一、环境信息
名称值CPUIntel(R) Core(TM) i5-1035G1 CPU @ 1.00GHz操作系统CentOS Linux release 7.9.2009 (Core)内存3G逻辑核数2Gbase8a版本8.6.2-R43.34.27468a27HappySunshine版本V1.1二、简述
心血来潮写了这个小工具，主要是检验一下C语言的学习情况，功能不是很丰富，后面再逐步更新，如果大家测试出现什么问题，可以在博客下方留言，我找时间改进一下。
三、升级点
序号功能备注1LOAD方式加载数据。根据参数SwitchNums来决定是用LOAD方法，还是INSERT方法。2删除目录和文件3自定义工具参数例如：OneBatchNums、SwitchNums、OsInfo等4提升程序局部性部分逻辑减少堆内存的频繁申请和释放，变为一次申请，重复使用。5优化部分函数效率 6修复BUG四、支持功能
序号功能备注1GBASE8a到8a库级数据迁移表定义及其他暂不支持。2单表INSERT批量加载INSERT方式多行数据为一批。3单表LOAD加载加载后支持删除导出数据文件。4并发加载多张表数据5均匀分配迁移任务每个线程处理的表数相差不超过1。6均匀分配数据库连接每个Gbase8a管理节点的数据库连接相差不超过1。7日志落地8读取配置文件可以自定义迁移参数。五、安装包下载地址
已经放到开头啦，欢迎大家测试使用。电脑端才可以看见安装包。
六、配置参数介绍
序号参数备注1[Tool]Tool标签头，下面只能写Tool相关参数。
2ThreadNums程序迁移时开的线程数。3Level迁移级别。2:库级迁移，MigrationDb、BlackList生效。1:表级迁移，WhiteList。现在只支持2。4OsInfoLOAD数据时使用。样例：'工具所在操作系统IP;操作系统用户;操作系统用户密码;'
长度同下方的数据库IP;数据库用户名;数据库用户密码;5OneBatchNums一个批次插入的数据条数。（INSERT方式）可不要调过大，导致频繁申请内存，比较消耗性能。6SwitchNums此数以上使用LOAD方法加载数据，以下使用INSERT方法。7[Source] Source标签头，下面只能写Source相关参数。8ConnInfo
样例：'IP;数据库用户名;数据库用户密码;数据库名;数据库端口号;数据连接字符集;'
（1）单个IP长度限制19，数据库IP地址。
（2）单个用户名长度限制19，数据库用户名。
（3）单个用户名密码长度限制29，数据库密码。
（4）单个数据库名长度限制29，数据库名。
（5）数据库端口。
（6）长度限制9，数据库连接字符集，支持utf8和gbk。
（7）ConnInfo数量需要小于等于ThreadNums。
（8）Source中ConnInfo和Target中ConnInfo数量需要一致。第一个对应第一个，第二个对应第二，以此类推。
（9）ConnInfo标签可以有多个。
七、安装步骤
大家可以看README的内容，其实是一样的。
下面的配置大家根据实际情况来，我这边只是给一个例子。
1、配置环境变量
/home/czg/.bashrc中添加如下
export HAPPY_SUNSHINE_HOME=/home/czg/HappySunshineTool
export LD_LIBRARY_PATH=$HAPPY_SUNSHINE_HOME/Libs:$LD_LIBRARY_PATH2、生效环境变量
source /home/czg/.bashrc3、检验动态链接是否正常
[czg@czg0 HappySunshineTool]$ ldd Bin/HappySunshine linux-vdso.so.1 => (0x00007ffd15d23000)libPublicFunction.so => /home/czg/HappySunshineTool/Libs/libPublicFunction.so (0x00007efc35c98000)libLog.so => /home/czg/HappySunshineTool/Libs/libLog.so (0x00007efc35a95000)libFileOperate.so => /home/czg/HappySunshineTool/Libs/libFileOperate.so (0x00007efc35892000)libGbase8aOperate.so => /home/czg/HappySunshineTool/Libs/libGbase8aOperate.so (0x00007efc35689000)libgbase.so.16 => /home/czg/HappySunshineTool/Libs/libgbase.so.16 (0x00007efc35242000)libpthread.so.0 => /lib64/libpthread.so.0 (0x00007efc35026000)libMyHashTable.so => /home/czg/HappySunshineTool/Libs/libMyHashTable.so (0x00007efc34e22000)libSqQueue.so => /home/czg/HappySunshineTool/Libs/libSqQueue.so (0x00007efc34c1e000)libc.so.6 => /lib64/libc.so.6 (0x00007efc34850000)libm.so.6 => /lib64/libm.so.6 (0x00007efc3454e000)/lib64/ld-linux-x86-64.so.2 (0x00007efc35e9b000)如果有动态库没有找到，就要看看环境变量是否配置正确或是否生效。
4、修改配置文件MigrationConfig.txt
具体的内容我都在配置文件中写好，大家按照规则来就行。
//*代表不可以空
//SSpecailTab、TSpecailTab、ConnInfo标签可以有多个
//单引号包围参数，分号分割参数项
//每行开头不可以有空格，不然会跳过此参数检查。
//#代表参数暂时没有实现。
//暂时只支持库级。[Tool] //工具信息。
ThreadNums : '2;' //*程序迁移时开的线程数。
Level : '2;' //*迁移级别。2:库级迁移，MigrationDb、BlackList生效。1:表级迁移，WhiteList。
InsatllPath : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/;' //工具安装路径。LOAD使用。
OsInfo : '192.168.142.12;gbase;gbase;' //LOAD使用。工具所在操作系统IP;操作系统用户;操作系统用户密码;长度同下方的数据库IP;数据库用户名;数据库用户密码;
OneBatchNums : '30000;' //一个批次插入的数据条数。（INSERT方式）
SwitchNums : '2000000;' //此数以上使用LOAD，以下使用INSERT。[Source] //源端信息。
ConnInfo : '192.168.142.12;root;;czg;5258;utf8;' //'IP;数据库用户名;数据库用户密码;数据库名;数据库端口号;数据连接字符集;'//*单个IP长度限制19，数据库IP地址。//*单个用户名长度限制19，数据库用户名。//*单个用户名密码长度限制29，数据库密码。//*单个数据库名长度限制29，数据库名。//*数据库端口。//*长度限制9，数据库连接字符集，支持utf8和gbk。//ConnInfo数量需要小于等于ThreadNums。//Source中ConnInfo和Target中ConnInfo数量需要一致。第一个对应第一个，第二个对应第二，以此类推。
ConnInfo : '192.168.142.12;root;;czg;5258;utf8;'
MigrationDb : 'czg;' //库级迁移参数，单个数据库名长度限制29，需要迁移的数据库名。和WhiteList二选一。
BlackList : 'haha;testtab_copy;moon_copy;' //库级迁移参数，黑名单，表名，长度限制参考Db。和MigrationDb一起使用可以。
#WhiteList : 'testtab;testtab_copy;' //表级迁移参数，白名单，表名，长度限制参考Db。和MigrationDb二选一。
#SSpecailTab : 'czg.testtab;a,b,c;Limit 10;' //源端库名.表名;多个列;附件条件;
#SSpecailTab : 'czg.haha;;WHERE A = 1;' //源端库名.表名;多个列;附件条件;[Target] //目的端信息。
ConnInfo : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;'
ConnInfo : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;'
MigrationDb : 'zxj;' //*单个用户名长度限制29，需要迁移到的数据库名。
#TSpecailTab : 'czg.testtab;a,b,c;zxj.testtab;' //源端库名.表名;多个列;目的端库名.表名;
#TSpecailTab : 'czg.haha;;czg.haha;' //源端库名.表名;多个列;目的端库名.表名;
八、运行效果
HeadNodeArray[0] : [(czg,tmp,0),(czg,test_table_3,0),(czg,test_table_1,0),(czg,test_2023_09_21,0),(czg,test_2023_09_14,0),(czg,test_2023,0),(czg,test_09_19,0),(czg,test,0),(czg,sun_gbk,0),(czg,strtab,0),(czg,sg_t_loadconfig_incr,0),(czg,moon,0),(czg,jointable,0),(czg,hash_tab,0),(czg,czg_test,0),(czg,b,0),(czg,a,0)]
TableNum : 17
HeadNodeArray[1] : [(czg,testtab,0),(czg,test_table_2,0),(czg,test_table,0),(czg,test_2023_09_19,0),(czg,test_20230720,0),(czg,test_12_05,0),(czg,test20230302,0),(czg,t_policy_ext_info,0),(czg,sun,0),(czg,sg_t_loadconfig_incr_odm,0),(czg,nodedatamap,0),(czg,jointable1,0),(czg,hash_tb_like,0),(czg,d_admin_kpi_code,0),(czg,czg,0),(czg,alldbvoidrate,0)]我们只需要关注结尾的这一块输出即可，如果每张表结尾都是0，表示迁移成功，如果有个别表状态为1，表示报错，如果是2，表示没跑此表。
[gbase@czg2 Bin]$ ./HappySunshine配置文件MigrationConfig.txt完毕，到Bin目录下执行即可。日志在Log目录下。
[gbase@czg2 Log]$ cat HappySunshineV1.1.log
2023-10-25 14:16:00-Tid[115043]-[Info ]-HappySunshineV1.1
2023-10-25 14:16:00-Tid[115043]-[Debug]-Open File : OK, FilePath : ../ConfigFile/MigrationConfig.txt, FileMode : r.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (414,4,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (625,4,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (615,4,3).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1019,8,3).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (504,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1124,8,4).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (590,8,6).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1191,8,7).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1045,8,5).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1104,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (889,8,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (925,8,5).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1067,8,3).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1104,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1068,8,4).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Arg Tab : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Printf HashTable
DataNum : 0 , [(nil)]
DataNum : 1 , [ (Key : 'Source', FuncPtr : 0x7fd1984e46d0, Value : '') ]
DataNum : 1 , [ (Key : 'Tool', FuncPtr : 0x7fd1984e4790, Value : '') ]
DataNum : 1 , [ (Key : 'Target', FuncPtr : 0x7fd1984e4730, Value : '') ]
TotalDataNum : 3
ArrayMaxLen : 4
2023-10-25 14:16:00-Tid[115043]-[Debug]-Printf HashTable
DataNum : 1 , [ (Key : 'Level', FuncPtr : 0x7fd1984e47f0, Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 0 , [(nil)]
DataNum : 1 , [ (Key : 'ThreadNums', FuncPtr : 0x7fd1984e3d80, Value : '') ]
DataNum : 1 , [ (Key : 'InsatllPath', FuncPtr : 0x7fd1984e4300, Value : '') ]
DataNum : 1 , [ (Key : 'SwitchNums', FuncPtr : 0x7fd1984e45f0, Value : '') ]
DataNum : 1 , [ (Key : 'OsInfo', FuncPtr : 0x7fd1984e43d0, Value : '') ]
DataNum : 1 , [ (Key : 'OneBatchNums', FuncPtr : 0x7fd1984e4510, Value : '') ]
TotalDataNum : 6
ArrayMaxLen : 8
2023-10-25 14:16:00-Tid[115043]-[Debug]-Printf HashTable
DataNum : 1 , [ (Key : 'MigrationDb', FuncPtr : 0x7fd1984e4230, Value : '') ]
DataNum : 1 , [ (Key : 'BlackList', FuncPtr : 0x7fd1984e4870, Value : '') ]
DataNum : 1 , [ (Key : 'ConnInfo', FuncPtr : 0x7fd1984e3dd0, Value : '') ]
DataNum : 1 , [ (Key : 'SSpecailTab', FuncPtr : (nil), Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 1 , [ (Key : 'WhiteList', FuncPtr : (nil), Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 0 , [(nil)]
TotalDataNum : 5
ArrayMaxLen : 8
2023-10-25 14:16:00-Tid[115043]-[Debug]-Printf HashTable
DataNum : 1 , [ (Key : 'MigrationDb', FuncPtr : 0x7fd1984e4910, Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 1 , [ (Key : 'ConnInfo', FuncPtr : 0x7fd1984e3ff0, Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 1 , [ (Key : 'TSpecailTab', FuncPtr : (nil), Value : '') ]
DataNum : 0 , [(nil)]
DataNum : 0 , [(nil)]
DataNum : 0 , [(nil)]
TotalDataNum : 3
ArrayMaxLen : 8
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//*代表不可以空'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//SSpecailTab、TSpecailTab、ConnInfo标签可以有多个'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//单引号包围参数，分号分割参数项'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//每行开头不可以有空格，不然会跳过此参数检查。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//#代表参数暂时没有实现。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '//暂时只支持库级。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '[Tool] //工具信息。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get Arg Head : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (414,4,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update To ArgsFlag : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'ThreadNums : '2;' //*程序迁移时开的线程数。如果库中的表数量小于线程数，这个参数不生效。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'ThreadNums', ArgVal : '2;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1019,8,3).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Db Conn Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Db Conn Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init EnvInfoSt : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationAll : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MAIS : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'Level : '2;' //*迁移级别。2:库级迁移，MigrationDb、BlackList生效。1:表级迁移，WhiteList。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'Level', ArgVal : '2;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (504,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update Mgrtn Level : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'InsatllPath : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/;' //工具安装路径。LOAD使用。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'InsatllPath', ArgVal : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1124,8,4).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update InstallPath : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'OsInfo : '192.168.142.12;gbase;gbase;' //LOAD使用。工具所在操作系统IP;操作系统用户;操作系统用户密码;长度同下方的数据库IP;数据库用户名;数据库用户密码;'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'OsInfo', ArgVal : '192.168.142.12;gbase;gbase;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (590,8,6).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update OsInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'OneBatchNums : '30000;' //一个批次插入的数据条数。（INSERT方式）'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'OneBatchNums', ArgVal : '30000;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1191,8,7).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update InsertNums : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'SwitchNums : '2000000;' //此数以上使用LOAD，以下使用INSERT。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'SwitchNums', ArgVal : '2000000;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1045,8,5).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update SwitchNums : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '[Source] //源端信息。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get Arg Head : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (625,4,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update S ArgsFlag : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'ConnInfo : '192.168.142.12;root;;czg;5258;utf8;' //'IP;数据库用户名;数据库用户密码;数据库名;数据库端口号;数据连接字符集;''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'ConnInfo', ArgVal : '192.168.142.12;root;;czg;5258;utf8;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update S ConnInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*单个IP长度限制19，数据库IP地址。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*单个用户名长度限制19，数据库用户名，规则同上。个数需要和Host一致。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*单个用户名密码长度限制29，数据库密码，规则同上。个数需要和Host一致。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*单个数据库名长度限制29，数据库名，规则同上。个数需要和Host一致。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*数据库端口，规则同上。个数需要和Host一致。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //*长度限制9，数据库连接字符集，支持utf8和gbk，规则同上。个数需要和Host一致。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //ConnInfo数量需要小于ThreadNums。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' //Source中ConnInfo和Target中ConnInfo数量需要一致。第一个对应第一个，第二个对应第二，以此类推。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'ConnInfo : '192.168.142.12;root;;czg;5258;utf8;''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'ConnInfo', ArgVal : '192.168.142.12;root;;czg;5258;utf8;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update S ConnInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'MigrationDb : 'czg;' //库级迁移参数，单个数据库名长度限制29，需要迁移的数据库名。和WhiteList二选一。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'MigrationDb', ArgVal : 'czg;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1104,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update S Mgrtn Db : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'BlackList : 'haha;testtab_copy;moon_copy;' //库级迁移参数，黑名单，表名，长度限制参考Db。和MigrationDb一起使用可以。 '
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'BlackList', ArgVal : 'haha;testtab_copy;moon_copy;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (889,8,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update Black List : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '#WhiteList : 'testtab;testtab_copy;' //表级迁移参数，白名单，表名，长度限制参考Db。和MigrationDb二选一。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '#SSpecailTab : 'czg.testtab;a,b,c;Limit 10;' //源端库名.表名;多个列;附件条件;'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '#SSpecailTab : 'czg.haha;;WHERE A = 1;' //源端库名.表名;多个列;附件条件;'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ' '
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '[Target] //目的端信息。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get Arg Head : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (615,4,3).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update T ArgsFlag : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'ConnInfo : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'ConnInfo', ArgVal : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update T ConnInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'ConnInfo : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'ConnInfo', ArgVal : '192.168.142.12;czg;qwer1234;zxj;5258;utf8;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (794,8,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update T ConnInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : 'MigrationDb : 'zxj;' //*单个用户名长度限制29，需要迁移到的数据库名。'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Get ArgName Val : OK, HeadOrArg : 'MigrationDb', ArgVal : 'zxj;'.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1104,8,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Split Str To Queue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update T Mgrtn Db : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '#TSpecailTab : 'czg.testtab;a,b,c;zxj.testtab;' //源端库名.表名;多个列;目的端库名.表名;'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : '#TSpecailTab : 'czg.haha;;czg.haha;' //源端库名.表名;多个列;目的端库名.表名;'
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Data Content : ''
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read A Line Data : OK, The File Read Ends.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destory Arg Tab : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Close File : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read Config File : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'root', DbName : 'czg', DbPort : 5258.
2023-10-25 14:16:00-Tid[115043]-[Debug]-client character : utf8
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (402,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1297,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read SqQueue : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (979,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-New Hash Tab Node : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Insert Hash Table : OK, There Is A Hash Collision.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Sql Query : SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'czg'2023-10-25 14:16:00-Tid[115043]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115043]-[Debug]-alias name : TABLE_NAME
2023-10-25 14:16:00-Tid[115043]-[Debug]-column name : TABLE_NAME
2023-10-25 14:16:00-Tid[115043]-[Debug]-alias table name : TABLES
2023-10-25 14:16:00-Tid[115043]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115043]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115043]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115043]-[Debug]-define column len : 192
2023-10-25 14:16:00-Tid[115043]-[Debug]-max column len : 24
2023-10-25 14:16:00-Tid[115043]-[Debug]-alias name len : 10
2023-10-25 14:16:00-Tid[115043]-[Debug]-column name len : 10
2023-10-25 14:16:00-Tid[115043]-[Debug]-charset : 33
2023-10-25 14:16:00-Tid[115043]-[Debug]-flags : 1 , info : not null
2023-10-25 14:16:00-Tid[115043]-[Debug]-type : 253 , info : VARCHAR
2023-10-25 14:16:00-Tid[115043]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Read Db All Table : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (97,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1373,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (98,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (324,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (867,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1641,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (826,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1245,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (952,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1001,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (441,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (979,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1150,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (2093,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (2508,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (656,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (342,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (745,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1822,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (448,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (844,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (849,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (838,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (742,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (943,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1138,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1143,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1136,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1063,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1207,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1208,3,2).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1209,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (759,3,0).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (1297,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Hash : (337,3,1).
2023-10-25 14:16:00-Tid[115043]-[Debug]-Search Hash Table : Not Found.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Init MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push MigrationInfo : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Push Table Info : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Clear Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy Hash Table : OK.
2023-10-25 14:16:00-Tid[115043]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115043]-[Debug]-Update DbLvTabInfo : OK.
2023-10-25 14:16:00-Tid[115043]-[Info ]-Printf MigrationAll:
Level : 2
SourceMigrationDb : 'czg'
TargetMigrationDb : 'zxj'
GroupNum : 2
InsertGroupIdx : 1
DbConnInfoArrayLen : 2
SelectGroupIdx : 0
OsIp : '192.168.142.12'
OsUser : 'gbase'
OsPwd : 'gbase'
InstallPath : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/'
OneBatchInsertNums : 30000
SwitchThreshold : 2000000
HeadNodeArray[0] : [(czg,tmp,2),(czg,test_table_3,2),(czg,test_table_1,2),(czg,test_2023_09_21,2),(czg,test_2023_09_14,2),(czg,test_2023,2),(czg,test_09_19,2),(czg,test,2),(czg,sun_gbk,2),(czg,strtab,2),(czg,sg_t_loadconfig_incr,2),(czg,moon,2),(czg,jointable,2),(czg,hash_tab,2),(czg,czg_test,2),(czg,b,2),(czg,a,2)]
TableNum : 17
HeadNodeArray[1] : [(czg,testtab,2),(czg,test_table_2,2),(czg,test_table,2),(czg,test_2023_09_19,2),(czg,test_20230720,2),(czg,test_12_05,2),(czg,test20230302,2),(czg,t_policy_ext_info,2),(czg,sun,2),(czg,sg_t_loadconfig_incr_odm,2),(czg,nodedatamap,2),(czg,jointable1,2),(czg,hash_tb_like,2),(czg,d_admin_kpi_code,2),(czg,czg,2),(czg,alldbvoidrate,2)]
TableNum : 16
DbConnInfo[0] : [('192.168.142.12','root','','czg',5258,'utf8')->('192.168.142.12','czg','qwer1234','zxj',5258,'utf8')]
DbConnInfo[1] : [('192.168.142.12','root','','czg',5258,'utf8')->('192.168.142.12','czg','qwer1234','zxj',5258,'utf8')]
2023-10-25 14:16:00-Tid[115043]-[Info ]-SqQueue Data :
Data : [ 'haha' ,'testtab_copy' ,'moon_copy' ]
FrontIndex : 0
RearIndex : 3
SqQueueLen : 3
SqQueueMaxLen : 1024
Flag : STRING_TYPE_FLAG
2023-10-25 14:16:00-Tid[115048]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'root', DbName : 'czg', DbPort : 5258.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'root', DbName : 'czg', DbPort : 5258.
2023-10-25 14:16:00-Tid[115047]-[Debug]-client character : utf8
2023-10-25 14:16:00-Tid[115048]-[Debug]-client character : utf8
2023-10-25 14:16:00-Tid[115047]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'zxj', DbPort : 5258.
2023-10-25 14:16:00-Tid[115048]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'zxj', DbPort : 5258.
2023-10-25 14:16:00-Tid[115047]-[Debug]-client character : utf8
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.tmp
2023-10-25 14:16:00-Tid[115048]-[Debug]-client character : utf8
2023-10-25 14:16:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.testtab
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : tmp, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.tmp -> zxj.tmp , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_table_3
2023-10-25 14:16:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115048]-[Debug]-max column len : 7
2023-10-25 14:16:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : testtab, Cnt : 2621440
2023-10-25 14:16:00-Tid[115048]-[Debug]-Sql Query : SET autocommit = 1;
2023-10-25 14:16:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect 0 Rows.
2023-10-25 14:16:00-Tid[115048]-[Debug]-8a Set Parameters : OK, ParameterName : autocommit, ParameterVal : 1.
2023-10-25 14:16:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115048]-[Debug]-Sql Query : SELECT * FROM czg.testtab INTO OUTFILE 'sftp://gbase:gbase@192.168.142.12/opt/Developer/ComputerLang
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_table_3, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_table_3 -> zxj.test_table_3 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_table_1
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_table_1, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_table_1 -> zxj.test_table_1 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_2023_09_21
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_2023_09_21, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_2023_09_21 -> zxj.test_2023_09_21 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_2023_09_14
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_2023_09_14, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_2023_09_14 -> zxj.test_2023_09_14 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_2023
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_2023, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_2023 -> zxj.test_2023 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_09_19
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_09_19, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test_09_19 -> zxj.test_09_19 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : test, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.test -> zxj.test , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.sun_gbk
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : sun_gbk, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.sun_gbk -> zxj.sun_gbk , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.strtab
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : strtab, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.strtab -> zxj.strtab , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.sg_t_loadconfig_incr
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : sg_t_loadconfig_incr, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.sg_t_loadconfig_incr -> zxj.sg_t_loadconfig_incr, 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.moon
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : moon, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.moon -> zxj.moon , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.jointable
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : jointable, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.jointable -> zxj.jointable , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.hash_tab
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : hash_tab, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.hash_tab -> zxj.hash_tab , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.czg_test
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : czg_test, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.czg_test -> zxj.czg_test , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.b
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : b, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.b -> zxj.b , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Init DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.a
2023-10-25 14:16:00-Tid[115047]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name : COUNT(*)
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-table name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-db name :
2023-10-25 14:16:00-Tid[115047]-[Debug]-default val : (null)
2023-10-25 14:16:00-Tid[115047]-[Debug]-define column len : 21
2023-10-25 14:16:00-Tid[115047]-[Debug]-max column len : 1
2023-10-25 14:16:00-Tid[115047]-[Debug]-alias name len : 8
2023-10-25 14:16:00-Tid[115047]-[Debug]-column name len : 0
2023-10-25 14:16:00-Tid[115047]-[Debug]-charset : 63
2023-10-25 14:16:00-Tid[115047]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:16:00-Tid[115047]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:16:00-Tid[115047]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:16:00-Tid[115047]-[Debug]-CountTabNum : OK, Db : czg, Tab : a, Cnt : 0
2023-10-25 14:16:00-Tid[115047]-[Info ]-Migration Complete : czg.a -> zxj.a , 0 Row, Elapsed Time 0 s.
2023-10-25 14:16:00-Tid[115047]-[Debug]-Migration Group : OK, ConnIndex : 0, ScanIndex : 0.
2023-10-25 14:16:36-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 36 s, Affect 2621440 Rows.
2023-10-25 14:16:36-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:16:36-Tid[115048]-[Debug]-Sql Query : LOAD DATA INFILE 'sftp://gbase:gbase@192.168.142.12/opt/Developer/ComputerLanguageStudy/C/DataStruct
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 24 s, Affect 2621440 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Judge File Type : OK. '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data' Is Dir.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Open Local Dir : OK, DirName : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data'.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Read Local Dir : OK.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Judge File Type : OK. '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data/czg.testtab.data' Is Normal File.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Remove File : OK, FileName : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data/czg.testtab.data'.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Read Local Dir : OK, Read End.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Close Local Dir : OK.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Remove Dir : OK, DirName : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data'.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Rm All Type File : OK, Name : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/LoadDataFile/czg.testtab.data'.
2023-10-25 14:17:00-Tid[115048]-[Debug]-TabMigrationLoad : OK
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.testtab -> zxj.testtab , 2621440 Row, Elapsed Time 60 s, Efficiency 43690 Row/s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_table_2
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_table_2, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test_table_2 -> zxj.test_table_2 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_table
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_table, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test_table -> zxj.test_table , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_2023_09_19
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_2023_09_19, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test_2023_09_19 -> zxj.test_2023_09_19 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_20230720
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_20230720, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test_20230720 -> zxj.test_20230720 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test_12_05
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test_12_05, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test_12_05 -> zxj.test_12_05 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.test20230302
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : test20230302, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.test20230302 -> zxj.test20230302 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.t_policy_ext_info
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : t_policy_ext_info, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.t_policy_ext_info -> zxj.t_policy_ext_info , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.sun
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : sun, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.sun -> zxj.sun , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.sg_t_loadconfig_incr_odm
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : sg_t_loadconfig_incr_odm, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.sg_t_loadconfig_incr_odm -> zxj.sg_t_loadconfig_incr_odm, 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.nodedatamap
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : nodedatamap, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.nodedatamap -> zxj.nodedatamap , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.jointable1
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : jointable1, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.jointable1 -> zxj.jointable1 , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.hash_tb_like
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : hash_tb_like, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.hash_tb_like -> zxj.hash_tb_like , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.d_admin_kpi_code
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : d_admin_kpi_code, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.d_admin_kpi_code -> zxj.d_admin_kpi_code , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.czg
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : czg, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.czg -> zxj.czg , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Init DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Splicing Sql : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Sql Query : SELECT COUNT(*) FROM czg.alldbvoidrate
2023-10-25 14:17:00-Tid[115048]-[Debug]-Execute Sql : OK, Sql Elapsed Time 0 s, Affect -1 Rows.
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name : COUNT(*)
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-table name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-db name :
2023-10-25 14:17:00-Tid[115048]-[Debug]-default val : (null)
2023-10-25 14:17:00-Tid[115048]-[Debug]-define column len : 21
2023-10-25 14:17:00-Tid[115048]-[Debug]-max column len : 1
2023-10-25 14:17:00-Tid[115048]-[Debug]-alias name len : 8
2023-10-25 14:17:00-Tid[115048]-[Debug]-column name len : 0
2023-10-25 14:17:00-Tid[115048]-[Debug]-charset : 63
2023-10-25 14:17:00-Tid[115048]-[Debug]-flags : 32897 , info : Unkown Flags!!!
2023-10-25 14:17:00-Tid[115048]-[Debug]-type : 8 , info : BIGINT
2023-10-25 14:17:00-Tid[115048]-[Debug]-Fetch DQL Data : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-Destroy DqlResult : OK
2023-10-25 14:17:00-Tid[115048]-[Debug]-CountTabNum : OK, Db : czg, Tab : alldbvoidrate, Cnt : 0
2023-10-25 14:17:00-Tid[115048]-[Info ]-Migration Complete : czg.alldbvoidrate -> zxj.alldbvoidrate , 0 Row, Elapsed Time 0 s.
2023-10-25 14:17:00-Tid[115048]-[Debug]-Migration Group : OK, ConnIndex : 1, ScanIndex : 1.
2023-10-25 14:17:00-Tid[115043]-[Info ]-Printf MigrationAll:
Level : 2
SourceMigrationDb : 'czg'
TargetMigrationDb : 'zxj'
GroupNum : 2
InsertGroupIdx : 1
DbConnInfoArrayLen : 2
SelectGroupIdx : 2
OsIp : '192.168.142.12'
OsUser : 'gbase'
OsPwd : 'gbase'
InstallPath : '/opt/Developer/ComputerLanguageStudy/C/DataStructureTestSrc/PublicFunction/Gbase8a/'
OneBatchInsertNums : 30000
SwitchThreshold : 2000000
HeadNodeArray[0] : [(czg,tmp,0),(czg,test_table_3,0),(czg,test_table_1,0),(czg,test_2023_09_21,0),(czg,test_2023_09_14,0),(czg,test_2023,0),(czg,test_09_19,0),(czg,test,0),(czg,sun_gbk,0),(czg,strtab,0),(czg,sg_t_loadconfig_incr,0),(czg,moon,0),(czg,jointable,0),(czg,hash_tab,0),(czg,czg_test,0),(czg,b,0),(czg,a,0)]
TableNum : 17
HeadNodeArray[1] : [(czg,testtab,0),(czg,test_table_2,0),(czg,test_table,0),(czg,test_2023_09_19,0),(czg,test_20230720,0),(czg,test_12_05,0),(czg,test20230302,0),(czg,t_policy_ext_info,0),(czg,sun,0),(czg,sg_t_loadconfig_incr_odm,0),(czg,nodedatamap,0),(czg,jointable1,0),(czg,hash_tb_like,0),(czg,d_admin_kpi_code,0),(czg,czg,0),(czg,alldbvoidrate,0)]
TableNum : 16
DbConnInfo[0] : [('192.168.142.12','root','','czg',5258,'utf8')->('192.168.142.12','czg','qwer1234','zxj',5258,'utf8')]
DbConnInfo[1] : [('192.168.142.12','root','','czg',5258,'utf8')->('192.168.142.12','czg','qwer1234','zxj',5258,'utf8')]
2023-10-25 14:17:00-Tid[115043]-[Info ]-SqQueue Data :
Data : [ 'haha' ,'testtab_copy' ,'moon_copy' ]
FrontIndex : 0
RearIndex : 3
SqQueueLen : 3
SqQueueMaxLen : 1024
Flag : STRING_TYPE_FLAG
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationInfo: OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry Db Conn Info : OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry Db Conn Info : OK
2023-10-25 14:17:00-Tid[115043]-[Debug]-Destroy SqQueue : OK.
2023-10-25 14:17:00-Tid[115043]-[Debug]-Destory EnvInfoSt : OK.
2023-10-25 14:17:00-Tid[115043]-[Debug]-Destroy SqQueue : OK.
2023-10-25 14:17:00-Tid[115043]-[Debug]-Dstry MigrationAll : OK查看全文
99%的人还看了
相似问题
- MySQL数据库：开源且强大的关系型数据库管理系统
- 【腾讯云云上实验室-向量数据库】探索腾讯云向量数据库：全方位管理与高效利用多维向量数据的引领者
- 【史上最细教程】服务器MySQL数据库完成主从复制
- 字符串结尾空格比较相关参数BLANK_PAD_MODE(DM8:达梦数据库)
- 缓存雪崩、击穿、穿透及解决方案_保证缓存和数据库一致性
- Redis 与其他数据库的不同之处 | Navicat
- 多协议数据库管理软件 Navicat Premium 16 mac中文版功能
- （数据库管理系统）DBMS与（数据库系统）DBS的区别
- duplicate复制数据库单个数据文件复制失败报错rman-03009 ora-03113
- 数据库课后习题加真题
猜你感兴趣
版权申明
本文"自制数据库迁移工具-C版-02-HappySunshineV1.1-(支持Gbase8a)"：http://eshow365.cn/6-24315-0.html 内容来自互联网，请自行判断内容的正确性。如有侵权请联系我们，立即删除！
- 上一篇: JS：将秒数转化为时分秒的形式
- 下一篇: 微软成AI热潮大赢家，继续押注大模型和人工智能