[2024-09-13 17:27:47] INFO __init__.py:1611 parameters from cmd: host="172.16.51.35", port=2881, user="root", password="******", timeout="0", log-file="upgrade_checker.log"
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check observer version success, version = 4.2.4.0
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from oceanbase.__all_virtual_tenant_parameter_info where name='compatible', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) from oceanbase.__all_tenant, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) from __all_virtual_core_table where column_name in ('target_data_version', 'current_data_version') and column_value = 17180001280, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check data version success, all tenant's compatible/target_data_version/current_data_version is 4.2.4.0
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) as unsync_cnt from GV$OB_LOG_STAT where in_sync = 'NO', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check paxos replica success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) as cnt from DBA_OB_TENANT_JOBS where job_status='INPROGRESS' and result_code is null, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) as rebalance_task_cnt from CDB_OB_LS_REPLICA_TASKS, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check rebalance task success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) from CDB_OB_MAJOR_COMPACTION where (GLOBAL_BROADCAST_SCN > LAST_SCN or STATUS != 'IDLE'), rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check cluster status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) as count from DBA_OB_TENANTS where status != 'NORMAL', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check tenant status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) as count from oceanbase.__all_virtual_tenant_info where tenant_role != 'PRIMARY' and tenant_role != 'STANDBY', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check tenant info success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) from DBA_OB_TENANTS where LOCKED = 'YES', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check tenant lock status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) from CDB_OB_RESTORE_PROGRESS, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check restore job success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) from __all_virtual_ddl_task_status, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check ddl task execut status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) from CDB_OB_BACKUP_JOBS, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check backup job success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(*) from oceanbase.__all_server where (start_service_time <= 0 or status != "active"), rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check observer status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select if (a.cnt = b.cnt, 1, 0) as passed from (select count(*) as cnt from oceanbase.__all_virtual_server_schema_info where refreshed_schema_version > 1 and refreshed_schema_version % 8 = 0) as a join (select count(*) as cnt from oceanbase.__all_server join oceanbase.__all_tenant) as b, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check schema status success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct(substring_index(build_version, '_', 1)) from __all_server, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check server version success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select tenant_name from oceanbase.DBA_OB_TENANTS, rowcount = 5
[2024-09-13 17:27:48] INFO __init__.py:1611 check special tenant name success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select distinct value from GV$OB_PARAMETERS  where name='min_observer_version', rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select tenant_id from oceanbase.__all_tenant where compatibility_mode = 1, rowcount = 0
[2024-09-13 17:27:48] INFO __init__.py:1611 check oracle standby_replication privs success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) as cnt from oceanbase.__all_virtual_tenant_parameter_info where (name like "log_transport_compress_func" and value like "zlib_1.0"), rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check log_transport_compress_func success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select /*+ query_timeout(1000000000) */ count(1) from __all_virtual_table where (compress_func_name like '%zlib%'), rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check table compression method success
[2024-09-13 17:27:48] INFO __init__.py:1611 succeed to execute query: select count(1) as cnt from GV$OB_PARAMETERS where (name like "tableapi_transport_compress_func" and value like "zlib%");, rowcount = 1
[2024-09-13 17:27:48] INFO __init__.py:1611 check table_api_transport_compress_func success
[2024-09-13 17:27:48] INFO __init__.py:1611 alter system set server_permanent_offline_time = '72h'
[2024-09-13 17:27:48] INFO __init__.py:1611 select count(*) as cnt from oceanbase.__all_virtual_sys_parameter_stat
           where name = 'server_permanent_offline_time' and value != '72h'
[2024-09-13 17:27:48] INFO __init__.py:1611 server_permanent_offline_time is not sync, value should be 72h
[2024-09-13 17:27:53] INFO __init__.py:1611 select count(*) as cnt from oceanbase.__all_virtual_sys_parameter_stat
           where name = 'server_permanent_offline_time' and value != '72h'
[2024-09-13 17:27:53] INFO __init__.py:1611 server_permanent_offline_time is sync, value is 72h