目录
一、环境信息
二、简述
三、支持功能
四、空洞率
五、工具流程图
六、安装包下载地址
七、参数介绍
1、命令模板
2、命令样例
3、参数表格
八、安装步骤
1、配置环境变量
2、生效环境变量
3、检验动态链接是否正常
九、运行效果
一、环境信息
名称 | 值 |
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 |
EasyClean版本 | V1.0 |
二、简述
工作和兴趣相结合的产物,既能更好的完成工作,也能看看自己的学习情况如何,无论如何,大家一起加油。
三、支持功能
序号 | 功能 | 备注 |
1 | 多进程执行任务 | |
2 | 空洞率清理 | |
3 | 自定义配置 | 后续会细讲参数。 |
4 | SQL重试功能 | 如果sql执行出错,会尝试3次。 |
四、空洞率
大家可以参考之前的博客《南大通用数据库-Gbase-8a-学习-33-空洞率查询与解决方法》。
五、工具流程图
1、管理者进程检查传入参数是否正确。
2、管理者进程启动会去Gbase8a中检索需要清理空洞率的表。
3、管理者进程获取环境变量和创建消息队列。
4、管理者进程创建多个执行者进程。
5、管理者进程向消息队列发送消息。
6、执行者进程检查传入参数是否正确。
7、执行者连接数据库和获取环境变量、连接消息队列。
8、执行者从消息队列中接收消息。
9、执行者进程操作数据库清理空洞率。
10、管理者进程发送完所有清理的表,向消息队列发送完成任务消息。
11、执行者进程接收到完成任务消息,清理申请的资源。
12、管理者进程回收所有执行者进程的PCB资源。
13、管理者进程关闭消息队列。
14、管理者进程清理申请的资源。
六、安装包下载地址
已经放到开头啦,欢迎大家测试使用。电脑端才可以看见安装包。
七、参数介绍
1、命令模板
[gbase@czg2 Exec]$ ./Manager 'DbHost;DbUser;DbPwd;DbName;DbPort;DbCharset;ChdProcessNum;TargetDb;VoidRate;ClearTabNum;'
2、命令样例
[gbase@czg2 Exec]$ ./Manager '192.168.142.12;czg;qwer1234;gbase;5258;utf8;3;zxj;0;2;'
3、参数表格
序号 | 参数 | 备注 |
1 | DbHost | 连接源端数据库IP。 |
2 | DbUser | 连接源端数据库用户。 |
3 | DbPwd | 连接源端数据库用户密码。 |
4 | DbName | 连接源端数据库。 |
5 | DbPort | 连接源端数据库端口号。 |
6 | DbCharset | 连接源端数据库的字符集。 |
7 | ChdProcessNum | 启动的子进程数。 |
8 | TargetDb | 需要清理空洞率的数据库。 |
9 | VoidRate | 空洞率到达此值时进行清理,1-100。 |
10 | ClearTabNum | 清理TargetDb下空洞率超过VoidRate的表的个数。如果是0,表示无限制。 |
八、安装步骤
大家可以看README的内容,其实是一样的。
下面的配置大家根据实际情况来,我这边只是给一个例子。
1、配置环境变量
/home/gbase/.bashrc中添加如下
export CLEAN_VOID_RATE_TOOL_HOME=/home/gbase/EasyClean/export LD_LIBRARY_PATH=$CLEAN_VOID_RATE_TOOL_HOME/Libs:$LD_LIBRARY_PATH
2、生效环境变量
source /home/gbase/.bashrc
3、检验动态链接是否正常
[gbase@czg0 Exec]$ ldd Manager linux-vdso.so.1 =>(0x00007ffe315b5000)libPublicFunction.so => /home/gbase/EasyClean//Libs/libPublicFunction.so (0x00007f54c1a1b000)libLog.so => /home/gbase/EasyClean//Libs/libLog.so (0x00007f54c1817000)libGbase8aOperate.so => /home/gbase/EasyClean//Libs/libGbase8aOperate.so (0x00007f54c160a000)libgbase.so.16 => /home/gbase/EasyClean//Libs/libgbase.so.16 (0x00007f54c114a000)libSqQueue.so => /home/gbase/EasyClean//Libs/libSqQueue.so (0x00007f54c0f45000)libDataConvertion.so => /home/gbase/EasyClean//Libs/libDataConvertion.so (0x00007f54c0d42000)libProcess.so => /home/gbase/EasyClean//Libs/libProcess.so (0x00007f54c0b3e000)libFileOperate.so => /home/gbase/EasyClean//Libs/libFileOperate.so (0x00007f54c0938000)libMyHashTable.so => /home/gbase/EasyClean//Libs/libMyHashTable.so (0x00007f54c0734000)libc.so.6 => /lib64/libc.so.6 (0x00007f54c0366000)libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f54c014a000)libdl.so.2 => /lib64/libdl.so.2 (0x00007f54bff46000)libm.so.6 => /lib64/libm.so.6 (0x00007f54bfc44000)/lib64/ld-linux-x86-64.so.2 (0x00007f54c1c1e000)[gbase@czg0 Exec]$ ldd Executor linux-vdso.so.1 =>(0x00007ffddffde000)libPublicFunction.so => /home/gbase/EasyClean//Libs/libPublicFunction.so (0x00007f7563dff000)libLog.so => /home/gbase/EasyClean//Libs/libLog.so (0x00007f7563bfb000)libGbase8aOperate.so => /home/gbase/EasyClean//Libs/libGbase8aOperate.so (0x00007f75639ee000)libgbase.so.16 => /home/gbase/EasyClean//Libs/libgbase.so.16 (0x00007f756352e000)libSqQueue.so => /home/gbase/EasyClean//Libs/libSqQueue.so (0x00007f7563329000)libDataConvertion.so => /home/gbase/EasyClean//Libs/libDataConvertion.so (0x00007f7563126000)libProcess.so => /home/gbase/EasyClean//Libs/libProcess.so (0x00007f7562f22000)libFileOperate.so => /home/gbase/EasyClean//Libs/libFileOperate.so (0x00007f7562d1c000)libMyHashTable.so => /home/gbase/EasyClean//Libs/libMyHashTable.so (0x00007f7562b18000)libc.so.6 => /lib64/libc.so.6 (0x00007f756274a000)libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f756252e000)libdl.so.2 => /lib64/libdl.so.2 (0x00007f756232a000)libm.so.6 => /lib64/libm.so.6 (0x00007f7562028000)/lib64/ld-linux-x86-64.so.2 (0x00007f7564002000)
如果有动态库没有找到,就要看看环境变量是否配置正确或是否生效。
九、运行效果
[gbase@czg0 Exec]$ ./Manager '192.168.142.12;czg;qwer1234;gbase;5258;utf8;3;zxj;0;2;'2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Info ]-EasyClean-V1.0-Manager.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Init SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Init SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-InitInArgvSt : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Split Str To Queue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyStrToLong: OK, Str : 5258, Base : 10, RetVal : 5258.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyStrToLong: OK, Str : 3, Base : 10, RetVal : 3.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyStrToLong: OK, Str : 2, Base : 10, RetVal : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Check Input Arg: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'gbase', DbPort : 5258.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-client character : utf82023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Init DqlResult : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Sql Query: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'zxj'2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect -1 Rows.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name : TABLE_NAME2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name: TABLE_NAME2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Table Name : TABLES2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Table Name : 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Db Name: 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Default Val: (null)2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Define Column Len: 1922023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Max Column Len : 242023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name Len : 102023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name Len: 102023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Charset: 332023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Flags: 1, Info : not null2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Type : 253, Info : VARCHAR2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Fetch DQL Data : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Read Db All Table: OK2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Clear SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Init DqlResult : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Sql Query: SELECT COUNT(*) FROM PERFORMANCE_SCHEMA.TABLES WHERE TABLE_SCHEMA='zxj' AND TABLE_NAME='a' AND DELET2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect -1 Rows.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name : COUNT(*)2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name: 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Table Name : 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Table Name : 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Db Name: 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Default Val: (null)2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Define Column Len: 212023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Max Column Len : 12023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name Len : 82023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name Len: 02023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Charset: 632023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Flags: 32897, Info : Unkown Flags!!!2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Type : 8, Info : BIGINT2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Fetch DQL Data : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Destroy DqlResult: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Enter SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Init DqlResult : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Sql Query: SELECT COUNT(*) FROM PERFORMANCE_SCHEMA.TABLES WHERE TABLE_SCHEMA='zxj' AND TABLE_NAME='alldbvoidrat2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect -1 Rows.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name : COUNT(*)2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name: 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Table Name : 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Table Name : 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Db Name: 2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Default Val: (null)2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Define Column Len: 212023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Max Column Len : 12023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Alias Name Len : 82023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Column Name Len: 02023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Charset: 632023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Flags: 32897, Info : Unkown Flags!!!2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Type : 8, Info : BIGINT2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Fetch DQL Data : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Destroy DqlResult: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Enter SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-ChkDbLvTabVoidRate : OK, DbName : zxj, ClearTabNums : 2, VoidRate : 0.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Get Os Env : OK, OsEnvName : CLEAN_VOID_RATE_TOOL_HOME, RetVal : /home/gbase/EasyClean/.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-File2Key : OK, RetKey : 26182.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageGet : OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 4940.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Enter SqQueue: OK.2023-12-22 16:37:43-P[4940]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 0.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 4941.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Enter SqQueue: OK.2023-12-22 16:37:43-P[4941]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 0.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 4942.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Enter SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 3.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 3.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 3.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 3.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-SqQueue Data :Data : [ 4940 ,4941 ,4942 ]FrontIndex : 0RearIndex: 3SqQueueLen : 3SqQueueMaxLen: 20Flag : INT_TYPE_FLAG2023-12-22 16:37:43-P[4942]-T[140294174734144]-[Debug]-MyFork : OK, Pid : 0.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Printf InArgvSt:SourceHost : 192.168.142.12SourceUser : czgSourcePwd: qwer1234SourceDbName : gbaseSourcePort : 5258SourceCharset: utf8TargetDb : zxjVoidRate : 0ClearTabNum: 2ToolPath : /home/gbase/EasyClean/ExecutorPath : /home/gbase/EasyClean/Exec/ExecutorPublicStr: /home/gbase/EasyClean/Exec/File2Key.DataChdProcessNum: 32023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-SqQueue Data :Data : [ 'a' ,'alldbvoidrate' ]FrontIndex : 0RearIndex: 2SqQueueLen : 2SqQueueMaxLen: 1024Flag : STRING_TYPE_FLAG2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 2.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Leave SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageSend: OK, MsgSize :1, MsgType : 1, MsgInfo : 'a'.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 1.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Leave SqQueue: OK.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageSend: OK, MsgSize : 13, MsgType : 1, MsgInfo : 'alldbvoidrate'.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 0.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageSend: OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageSend: OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-MessageSend: OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:43-P[4939]-T[140294174734144]-[Debug]-Leave SqQueue: OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Info ]-EasyClean-V1.0-Executor.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Info ]-EasyClean-V1.0-Executor.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Info ]-EasyClean-V1.0-Executor.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Init SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-InitInArgvSt : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Split Str To Queue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-MyStrToLong: OK, Str : 5258, Base : 10, RetVal : 5258.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-MyStrToLong: OK, Str : 3, Base : 10, RetVal : 3.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-MyStrToLong: OK, Str : 2, Base : 10, RetVal : 2.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Check Input Arg: OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Init SqQueue : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'gbase', DbPort : 5258.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-InitInArgvSt : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Split Str To Queue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-MyStrToLong: OK, Str : 5258, Base : 10, RetVal : 5258.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-MyStrToLong: OK, Str : 3, Base : 10, RetVal : 3.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-MyStrToLong: OK, Str : 2, Base : 10, RetVal : 2.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Check Input Arg: OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'gbase', DbPort : 5258.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Init SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-InitInArgvSt : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Split Str To Queue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-MyStrToLong: OK, Str : 5258, Base : 10, RetVal : 5258.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-MyStrToLong: OK, Str : 3, Base : 10, RetVal : 3.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Read SqQueue : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-MyStrToLong: OK, Str : 2, Base : 10, RetVal : 2.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Check Input Arg: OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-client character : utf82023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Sql Query: SET gcluster_lock_timeout = 52023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-8a Set Parameters: OK, ParameterName : 'gcluster_lock_timeout', ParameterVal : '5'.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Get Os Env : OK, OsEnvName : CLEAN_VOID_RATE_TOOL_HOME, RetVal : /home/gbase/EasyClean/.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-File2Key : OK, RetKey : 26182.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-MessageGet : OK.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Printf InArgvSt:SourceHost : 192.168.142.12SourceUser : czgSourcePwd: qwer1234SourceDbName : gbaseSourcePort : 5258SourceCharset: utf8TargetDb : zxjVoidRate : 0ClearTabNum: 2ToolPath : /home/gbase/EasyClean/ExecutorPath : PublicStr: /home/gbase/EasyClean/Exec/File2Key.DataChdProcessNum: 32023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-SqQueue Data :Data : [ '192.168.142.12' ,'czg' ,'qwer1234' ,'gbase' ,'5258' ,'utf8' ,'3' ,'zxj' ,'0' ,'2' ]FrontIndex : 0RearIndex: 10SqQueueLen : 10SqQueueMaxLen: 1024Flag : STRING_TYPE_FLAG2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-MessageRcv : OK, MsgSize :1, MsgType : 1, MsgInfo : 'a'.2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Sql Query: LOCK TABLE zxj.a WRITE2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Connect Info : OK , DbHost : '192.168.142.12', DbUser : 'czg', DbName : 'gbase', DbPort : 5258.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-client character : utf82023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Sql Query: SET gcluster_lock_timeout = 52023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-8a Set Parameters: OK, ParameterName : 'gcluster_lock_timeout', ParameterVal : '5'.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Get Os Env : OK, OsEnvName : CLEAN_VOID_RATE_TOOL_HOME, RetVal : /home/gbase/EasyClean/.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-File2Key : OK, RetKey : 26182.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-MessageGet : OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Printf InArgvSt:SourceHost : 192.168.142.12SourceUser : czgSourcePwd: qwer1234SourceDbName : gbaseSourcePort : 5258SourceCharset: utf8TargetDb : zxjVoidRate : 0ClearTabNum: 2ToolPath : /home/gbase/EasyClean/ExecutorPath : PublicStr: /home/gbase/EasyClean/Exec/File2Key.DataChdProcessNum: 32023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-SqQueue Data :Data : [ '192.168.142.12' ,'czg' ,'qwer1234' ,'gbase' ,'5258' ,'utf8' ,'3' ,'zxj' ,'0' ,'2' ]FrontIndex : 0RearIndex: 10SqQueueLen : 10SqQueueMaxLen: 1024Flag : STRING_TYPE_FLAG2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-MessageRcv : OK, MsgSize : 13, MsgType : 1, MsgInfo : 'alldbvoidrate'.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Sql Query: LOCK TABLE zxj.alldbvoidrate WRITE2023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-client character : utf82023-12-22 16:37:43-P[4942]-T[140090744272704]-[Debug]-Sql Query: CREATE TABLE zxj.a_COPY_TAB LIKE zxj.a2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Sql Query: SET gcluster_lock_timeout = 52023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-8a Set Parameters: OK, ParameterName : 'gcluster_lock_timeout', ParameterVal : '5'.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Get Os Env : OK, OsEnvName : CLEAN_VOID_RATE_TOOL_HOME, RetVal : /home/gbase/EasyClean/.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-File2Key : OK, RetKey : 26182.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-MessageGet : OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Printf InArgvSt:SourceHost : 192.168.142.12SourceUser : czgSourcePwd: qwer1234SourceDbName : gbaseSourcePort : 5258SourceCharset: utf8TargetDb : zxjVoidRate : 0ClearTabNum: 2ToolPath : /home/gbase/EasyClean/ExecutorPath : PublicStr: /home/gbase/EasyClean/Exec/File2Key.DataChdProcessNum: 32023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-GetSqQueueLen: OK, SqQueueLen : 10.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-SqQueue Data :Data : [ '192.168.142.12' ,'czg' ,'qwer1234' ,'gbase' ,'5258' ,'utf8' ,'3' ,'zxj' ,'0' ,'2' ]FrontIndex : 0RearIndex: 10SqQueueLen : 10SqQueueMaxLen: 1024Flag : STRING_TYPE_FLAG2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-MessageRcv : OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-Destroy SqQueue: OK.2023-12-22 16:37:43-P[4941]-T[139722938136384]-[Debug]-DestoryInArgvSt: OK.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:43-P[4940]-T[139647257421632]-[Debug]-Sql Query: CREATE TABLE zxj.alldbvoidrate_COPY_TAB LIKE zxj.alldbvoidrate2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 1 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Sql Query: INSERT INTO zxj.alldbvoidrate_COPY_TAB SELECT * FROMzxj.alldbvoidrate2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 1 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Sql Query: INSERT INTO zxj.a_COPY_TAB SELECT * FROMzxj.a2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Sql Query: TRUNCATE TABLE zxj.alldbvoidrate2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Sql Query: TRUNCATE TABLE zxj.a2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Sql Query: INSERT INTO zxj.alldbvoidrate SELECT * FROMzxj.alldbvoidrate_COPY_TAB2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Sql Query: UNLOCK TABLES2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Sql Query: INSERT INTO zxj.a SELECT * FROMzxj.a_COPY_TAB2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Sql Query: DROP TABLE zxj.alldbvoidrate_COPY_TAB2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Sql Query: UNLOCK TABLES2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Sql Query: DROP TABLE zxj.a_COPY_TAB2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Info ]-ClearTabVoidRate : OK, DbName : zxj, TabName : alldbvoidrate.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-MessageRcv : OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-Destroy SqQueue: OK.2023-12-22 16:37:44-P[4940]-T[139647257421632]-[Debug]-DestoryInArgvSt: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-ChkProcExitStatus: OK, Normal Termination, Pid : 4940, Exit Status : 0.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-MyWaitPid: OK, RetPid : 4940.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-Leave SqQueue: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-ChkProcExitStatus: OK, Normal Termination, Pid : 4941, Exit Status : 0.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-MyWaitPid: OK, RetPid : 4941.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-Leave SqQueue: OK.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Execute Sql: OK, Sql Elapsed Time 0 s, Affect 0 Rows.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Info ]-ClearTabVoidRate : OK, DbName : zxj, TabName : a.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-MessageRcv : OK, MsgSize :6, MsgType : 1, MsgInfo : 'Finish'.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-Destroy SqQueue: OK.2023-12-22 16:37:44-P[4942]-T[140090744272704]-[Debug]-DestoryInArgvSt: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-ChkProcExitStatus: OK, Normal Termination, Pid : 4942, Exit Status : 0.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-MyWaitPid: OK, RetPid : 4942.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-MessageCtl : OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-Destroy DqlResult: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-Destroy SqQueue: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-DestoryInArgvSt: OK.2023-12-22 16:37:44-P[4939]-T[140294174734144]-[Debug]-Destroy SqQueue: OK.