自制数据库迁移工具-C版-02-HappySunshineV1.1-(支持Gbase8a)
目录
一、环境信息
二、简述
三、升级点
四、支持功能
五、安装包下载地址
六、配置参数介绍
七、安装步骤
1、配置环境变量
2、生效环境变量
3、检验动态链接是否正常
4、修改配置文件MigrationConfig.txt
八、运行效果
一、环境信息
名称 | 值 |
CPU | Intel(R) Core(TM) i5-1035G1 CPU @ 1.00GHz |
操作系统 | CentOS Linux release 7.9.2009 (Core) |
内存 | 3G |
逻辑核数 | 2 |
Gbase8a版本 | 8.6.2-R43.34.27468a27 |
HappySunshine版本 | V1.1 |
二、简述
心血来潮写了这个小工具,主要是检验一下C语言的学习情况,功能不是很丰富,后面再逐步更新,如果大家测试出现什么问题,可以在博客下方留言,我找时间改进一下。
三、升级点
序号 | 功能 | 备注 |
1 | LOAD方式加载数据。 | 根据参数SwitchNums来决定是用LOAD方法,还是INSERT方法。 |
2 | 删除目录和文件 | |
3 | 自定义工具参数 | 例如:OneBatchNums、SwitchNums、OsInfo等 |
4 | 提升程序局部性 | 部分逻辑减少堆内存的频繁申请和释放,变为一次申请,重复使用。 |
5 | 优化部分函数效率 | |
6 | 修复BUG |
四、支持功能
序号 | 功能 | 备注 |
1 | GBASE8a到8a库级数据迁移 | 表定义及其他暂不支持。 |
2 | 单表INSERT批量加载 | INSERT方式多行数据为一批。 |
3 | 单表LOAD加载 | 加载后支持删除导出数据文件。 |
4 | 并发加载多张表数据 | |
5 | 均匀分配迁移任务 | 每个线程处理的表数相差不超过1。 |
6 | 均匀分配数据库连接 | 每个Gbase8a管理节点的数据库连接相差不超过1。 |
7 | 日志落地 | |
8 | 读取配置文件 | 可以自定义迁移参数。 |
五、安装包下载地址
已经放到开头啦,欢迎大家测试使用。电脑端才可以看见安装包。
六、配置参数介绍
序号 | 参数 | 备注 |
1 | [Tool] | Tool标签头,下面只能写Tool相关参数。 |
2 | ThreadNums | 程序迁移时开的线程数。 |
3 | Level | 迁移级别。2:库级迁移,MigrationDb、BlackList生效。1:表级迁移,WhiteList。现在只支持2。 |
4 | OsInfo | LOAD数据时使用。 样例:'工具所在操作系统IP;操作系统用户;操作系统用户密码;' 长度同下方的数据库IP;数据库用户名;数据库用户密码; |
5 | OneBatchNums | 一个批次插入的数据条数。(INSERT方式)可不要调过大,导致频繁申请内存,比较消耗性能。 |
6 | SwitchNums | 此数以上使用LOAD方法加载数据,以下使用INSERT方法。 |
7 | [Source] | Source标签头,下面只能写Source相关参数。 |
8 | ConnInfo | 样例:'IP;数据库用户名;数据库用户密码;数据库名;数据库端口号;数据连接字符集;' |
9 | MigrationDb | 库级迁移参数,单个数据库名长度限制29,需要迁移的数据库名。和WhiteList二选一。 |
10 | BlackList | 库级迁移参数,黑名单,表名,长度限制参考Db。和MigrationDb一起使用可以。 |
11 | [Target] | Target标签头,下面只能写Target相关参数。 |
12 | ConnInfo | 参考Source的。 |
13 | MigrationDb | 参考Source的。 |
七、安装步骤
大家可以看README的内容,其实是一样的。
下面的配置大家根据实际情况来,我这边只是给一个例子。
1、配置环境变量
/home/czg/.bashrc中添加如下
export HAPPY_SUNSHINE_HOME=/home/czg/HappySunshineTool
export LD_LIBRARY_PATH=$HAPPY_SUNSHINE_HOME/Libs:$LD_LIBRARY_PATH
2、生效环境变量
source /home/czg/.bashrc
3、检验动态链接是否正常
[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
相关文章:
自制数据库迁移工具-C版-02-HappySunshineV1.1-(支持Gbase8a)
目录 一、环境信息 二、简述 三、升级点 四、支持功能 五、安装包下载地址 六、配置参数介绍 七、安装步骤 1、配置环境变量 2、生效环境变量 3、检验动态链接是否正常 4、修改配置文件MigrationConfig.txt 八、运行效果 一、环境信息 名称值CPUIntel(R) Core(TM) i…...
k8s创建pod-affinity亲和性时报错解决办法
1.如下报错 Error from server (BadRequest): error when creating “pod-required-affinity-demo-2.yaml”: Pod in version “v1” cannot be handled as a Pod: json: cannot unmarshal string into Go struct field LabelSelectorRequirement.spec.affinity.podAffinity.re…...

基于边缘智能网关的储能系统安全监测管理方案
“储能系统充电”是配套新能源汽车产业发展的重要应用之一。得益于电池技术的发展,新能源汽车正逐步迈入快充时代,由于在使用快速充电桩时,可能导致用电峰值负荷超过电网的承载能力,对于电网的稳定性和持续性会有较大影响…...

大数据Flink(一百零一):SQL 表值函数(Table Function)
文章目录 SQL 表值函数(Table Function) SQL 表值函数(Table Function) Python UDTF,即 Python TableFunction,针对每一条输入数据,Python UDTF 可以产生 0 条、1 条或者多条输出数据,此外,一条输出数据可以包含多个列。比如以下示例,定义了一个名字为 split 的Pyt…...
内核进程初始化和创建
task_struct 1.进程的状态 分时技术进行多进程调度 重点:进程的创建是如何的? linux在初始化的过程中那个会进行0号进程的创建,fork sched_init(); 做了什么 内核态 不可抢占 用户态 可以抢占 move_to_user_mode(); 把内核状态切换到…...

【进程概念④】:进程地址空间(虚拟内存与物理内存)
【进程概念④】:进程地址空间(虚拟内存与物理内存) 一.进程地址空间二.分页与虚拟地址①.what②.how③.why 三.页表细节①.标志位②.缺页中断 四.总结意义 一.进程地址空间 你觉得我们代码中写的数据都在哪存储着呢? 在内存里存着࿰…...
C语言内存四分区
四个区域:代码区,全局区,栈区,堆区 ①代码区 存放所写代码,二进制内容 ②全局区(又分data区和bss区) 存放全局变量,静态变量,常量 data区:已经初始化的全局变…...

数据可视化报表分享:区域管理驾驶舱
在零售数据分析中,区域管理驾驶舱报表是用来分析企业运营数据,以制定销售策略和提高利润。因此这张报表需要整合大量数据,数据整合、分析、指标计算的工作量极大,在讲究高效率、高度及时性的大数据时代,BI数据可视化分…...

解决pip安装包后但是Pycharm检测不到
首先要知道python找包的原理:原理 之后把一下代码打印一下: import sys print(sys.executable)# /usr/bin/python2 print(sys.path)# [/usr/lib/python2.7, /usr/lib/python2.7/dist-packages, /usr/local/lib/python2.7/dist-packages] print(sys.prefi…...

折纸问题
折纸的次数 —— 从上到下的折痕 本质上是中序遍历的问题,因为每一次在已有的折痕后折的时候,当前折痕上的折痕一定为凹,当前折痕下的折痕一定为凸 。实际模拟了一个不存在的二叉树结构的中序遍历。 注:折纸折几次整颗二叉树就有…...

mysql-面试50题-2
一、查询数据 学生表 Student create table Student(SId varchar(10),Sname varchar(10),Sage datetime,Ssex varchar(10)); insert into Student values(01 , 赵雷 , 1990-01-01 , 男); insert into Student values(02 , 钱电 , 1990-12-21 , 男); insert into Student v…...

FoLR:Focus on Local Regions for Query-based Object Detection论文学习笔记
论文地址:https://arxiv.org/abs/2310.06470 自从DETR问询式检测器首次亮相以来,基于查询的方法在目标检测中引起了广泛关注。然而,这些方法面临着收敛速度慢和性能亚优等挑战。值得注意的是,在目标检测中,自注意力机制…...

【QT开发(15)】QT在没有桌面的系统中可以使用
在没有桌面的系统中,可以使用QT库。QT库可以在没有图形用户界面(GUI)的环境中运行,例如在服务器或命令行终端中。 这样就可利用Qt的: 对象模型,信号和槽容器类多线程和多进程网络编程 等...

『heqingchun-Qt的艺术-优雅界面设计开发』
Qt的艺术-优雅界面设计开发 效果图 一、新建Qt窗口工程 二、准备资源文件 1.图标资源 链接: 图标资源 2.Qss资源 链接: Qss资源 三、设计开发 项目源码链接: CSDN资源...
webGL编程指南 第四章 平移+旋转.RotatdTanslatedTriangle.html
我会持续更新关于wegl的编程指南中的代码。 当前的代码不会使用书中的缩写,每一步都是会展开写。希望能给后来学习的一些帮助 git代码地址 :git 本篇文章将把旋转和平位移结合起来,因为矩阵的不存在交换法则 文章中设计的矩阵地址在这里…...

使用canvas实现时间轴上滑块的各种常用操作(仅供参考)
一、简介 使用canvas,模拟绘制时间轴区域,有时间刻度标尺,时间轴区域上会有多行,每行都有一个滑块。 1、时间刻度标尺可以拖动,会自动对齐整数点秒数,最小步数为0.1秒。 2、滑块可以自由拖动,…...
Netty优化-扩展自定义协议中的序列化算法
Netty优化-扩展自定义协议中的序列化算法 一. 优化与源码1. 优化1.1 扩展自定义协议中的序列化算法 一. 优化与源码 1. 优化 1.1 扩展自定义协议中的序列化算法 序列化,反序列化主要用在消息正文的转换上 序列化时,需要将 Java 对象变为要传输的数据…...

【Java网络编程】二
本文主要介绍了传输层的UDP协议和TCP协议,以及在Java中如何通过Socket套接字实现网络编程(内附UDP和TCP版本的回显服务器代码) 一.网络通信 网络编程,就是写一个应用程序,让这个程序可以使用网络通信,这里就…...

通过IP地址可以做什么
通过IP地址可以做很多事情,因为它是互联网通信的基础之一。本文将探讨IP地址的定义、用途以及一些可能的应用。 IP地址的用途 1. 设备标识:IP地址用于标识互联网上的每个设备,这包括计算机、服务器、路由器、智能手机等。它类似于我们日常生…...
前端 CSS 经典:clip、clip-path
1. clip 1.1 clip: auto | inherit | rect auto:默认,不裁剪 inherit:继承父级 clip 属性 rect:规则四边形裁剪 1.2 clip: rect(top, right, bottom, left) 注意: 1.裁剪只对 fixed 和 absolute 的元素有效。 2.top&…...

机器人/智能车纯视觉巡线经典策略—滑动窗口+直方图法
作者:SkyXZ CSDN:SkyXZ~-CSDN博客 博客园:SkyXZ - 博客园 在机器人或智能车的自主导航任务中,视觉巡线是一项最为基础且关键的能力之一。通过摄像头实时获取道路图像,并基于图像信息判断行驶路径࿰…...

嵌入式学习--江协stm32day5
USART 1. 引脚与接口层 异步引脚: TX:发送数据输出;RX:接收数据输入;SW_RX:单线半双工模式的接收引脚(替代 RX)。 同步引脚:SCLK:同步模式下的时钟输出&…...

c#,Powershell,mmsys.cpl,使用Win32 API展示音频设备属性对话框
常识(基础) 众所周知,mmsys.cpl使管理音频设备的控制面板小工具, 其能产生一个对话框(属性表)让我们查看和修改各设备的详细属性: 在音量合成器中单击音频输出设备的小图标也能实现这个效果&a…...

理解非结构化文档:将 Reducto 解析与 Elasticsearch 结合使用
作者:来自 Elastic Adel Wu 演示如何将 Reducto 的文档处理与 Elasticsearch 集成以实现语义搜索。 Elasticsearch 与业界领先的生成式 AI 工具和提供商有原生集成。欢迎观看我们的网络研讨会,了解如何超越 RAG 基础,或使用 Elastic 向量数据…...
二元函数可微 切平面逼近 线性函数逼近
二元函数 f ( x , y ) f(x, y) f(x,y) 在某点可微 的含义,可以从几何直观、严格数学定义、与一阶偏导数的关系三个层面来理解: 🔹1. 几何直观上的含义(最易理解) 二元函数 f ( x , y ) f(x, y) f(x,y) 在点 ( x 0 …...

【MySQL】10.事务管理
1. 事务的引入 首先我们需要知道CURD操作不加控制会产生什么问题: 为了解决上面的问题,CURD需要满足如下条件: 2. 事务的概念 事务就是一组DML语句组成,这些语句在逻辑上存在相关性,这一组DML语句要么全部成功&…...
Python项目中添加环境配置文件
在Python项目中添加配置文件有多种方式,每种方式对应不同的依赖包和读取方法。以下是 7种主流配置管理方案,包含安装命令、配置示例和变量读取方法: 1. .env 文件(推荐简单项目) 依赖包: python-dotenv pip install …...
【LRU】 (最近最少使用)
LRU (最近最少使用) 文章目录 LRU (最近最少使用)一、LRU是什么?二、实现1.常规算法2.双栈更替总结 一、LRU是什么? LRU(Least Recently Used)是一种常见的缓存淘汰策略,核心思想是 “淘汰最长时间未被使用的缓存数据…...
Kafka 快速上手:安装部署与 HelloWorld 实践(一)
一、Kafka 是什么?为什么要学? ** 在大数据和分布式系统的领域中,Kafka 是一个如雷贯耳的名字。Kafka 是一种分布式的、基于发布 / 订阅的消息系统,由 LinkedIn 公司开发,后成为 Apache 基金会的顶级开源项目 。它以…...

抽奖系统核心——抽奖管理
目录 前端逻辑: 核心全局变量: reloadConf函数: nextStep函数: 后端实现: 抽奖接口: Controller层: Service层: MqReceiver: drawPrizeService: statusConvert()方法: activityStatu…...