les-ob.sql       timezone_V1.log              upgrade_post.py
[root@mxt-datanode01 etc]#  python upgrade_checker.py -h 127.0.0.1 -P 2881 -u root@sys -p'ABcd__1324'
[2025-03-14 14:00:24] INFO upgrade_checker.py:743 parameters from cmd: host="127.0.0.1", port=2881, user="root@sys", passw
ord="******", timeout="0", log-file="upgrade_checker.log"
[2025-03-14 14:00:24] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:24] INFO upgrade_checker.py:337 check observer version success, version = 4.2.5.1
[2025-03-14 14:00:24] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:25] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from oceanbase.__all_virt
ual_tenant_parameter_info where name='compatible', rowcount = 1
[2025-03-14 14:00:25] INFO upgrade_checker.py:57 succeed to execute query: select count(*) from oceanbase.__all_tenant, ro
wcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 succeed to execute query: select count(*) from __all_virtual_core_table w
here column_name in ('target_data_version', 'current_data_version') and column_value = 17180001537, rowcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:387 check data version success, all tenant's compatible/target_data_version/
current_data_version is 4.2.5.1
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 succeed to execute query: select count(1) as unsync_cnt from GV$OB_LOG_ST
AT where in_sync = 'NO', rowcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:396 check paxos replica success
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 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
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 succeed to execute query: select count(1) as rebalance_task_cnt from CDB_
OB_LS_REPLICA_TASKS, rowcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:408 check rebalance task success
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_MAJOR_COMPACTION wh
ere (GLOBAL_BROADCAST_SCN > LAST_SCN or STATUS != 'IDLE'), rowcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:416 check cluster status success
[2025-03-14 14:00:27] INFO upgrade_checker.py:57 succeed to execute query: select count(*) as count from DBA_OB_TENANTS wh
ere status != 'NORMAL', rowcount = 1
[2025-03-14 14:00:27] INFO upgrade_checker.py:428 check tenant status success
[2025-03-14 14:00:28] INFO upgrade_checker.py:57 succeed to execute query: select count(*) as count from oceanbase.__all_v
irtual_tenant_info where tenant_role != 'PRIMARY' and tenant_role != 'STANDBY', rowcount = 1
[2025-03-14 14:00:28] INFO upgrade_checker.py:438 check tenant info success
[2025-03-14 14:00:28] INFO upgrade_checker.py:57 succeed to execute query: select count(*) from DBA_OB_TENANTS where LOCKE
D = 'YES', rowcount = 1
[2025-03-14 14:00:28] INFO upgrade_checker.py:447 check tenant lock status success
[2025-03-14 14:00:28] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_RESTORE_PROGRESS, r
owcount = 1
[2025-03-14 14:00:28] INFO upgrade_checker.py:456 check restore job success
[2025-03-14 14:00:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from __all_virtual_ddl_task_sta
tus, rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:502 check ddl task execut status success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_BACKUP_JOBS, rowcou
nt = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:513 check backup job success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select count(*) from oceanbase.__all_server whe
re (start_service_time <= 0 or status != "active"), rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:592 check observer status success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 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_s
chema_version % 8 = 0) as a join (select count(*) as cnt from oceanbase.__all_server join oceanbase.__all_tenant) as b, ro
wcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:599 check schema status success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select distinct(substring_index(build_version, 
'_', 1)) from __all_server, rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:585 check server version success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select tenant_name from oceanbase.DBA_OB_TENANT
S, rowcount = 159
[2025-03-14 14:00:29] INFO upgrade_checker.py:609 check special tenant name success
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS  wh
ere name='min_observer_version', rowcount = 1
[2025-03-14 14:00:29] INFO upgrade_checker.py:57 succeed to execute query: select tenant_id from oceanbase.__all_tenant wh
ere compatibility_mode = 1, rowcount = 0
[2025-03-14 14:00:29] INFO upgrade_checker.py:661 check oracle standby_replication privs success
[2025-03-14 14:00:30] INFO upgrade_checker.py:57 succeed to execute query: select count(1) as cnt from oceanbase.__all_vir
tual_tenant_parameter_info where (name like "log_transport_compress_func" and value like "zlib_1.0"), rowcount = 1
[2025-03-14 14:00:30] INFO upgrade_checker.py:615 check log_transport_compress_func success
[2025-03-14 14:00:31] INFO upgrade_checker.py:57 succeed to execute query: select /*+ query_timeout(1000000000) */ count(1
) from __all_virtual_table where (compress_func_name like '%zlib%'), rowcount = 1
[2025-03-14 14:00:31] INFO upgrade_checker.py:621 check table compression method success
[2025-03-14 14:00:31] INFO upgrade_checker.py:57 succeed to execute query: select count(1) as cnt from GV$OB_PARAMETERS wh
ere (name like "tableapi_transport_compress_func" and value like "zlib%");, rowcount = 1
[2025-03-14 14:00:31] INFO upgrade_checker.py:627 check table_api_transport_compress_func success
[2025-03-14 14:00:31] ERROR upgrade_checker.py:712 run error
Traceback (most recent call last):
  File "upgrade_checker.py", line 709, in do_check
    check_fail_list()
  File "upgrade_checker.py", line 666, in check_fail_list
    raise MyError(error_msg)
MyError: 'upgrade checker failed with 1 reasons: [26 replicas unsync, please check] '
[2025-03-14 14:00:31] ERROR upgrade_checker.py:721 normal error
Traceback (most recent call last):
  File "upgrade_checker.py", line 709, in do_check
    check_fail_list()
  File "upgrade_checker.py", line 666, in check_fail_list
    raise MyError(error_msg)
MyError: 'upgrade checker failed with 1 reasons: [26 replicas unsync, please check] '
[2025-03-14 14:00:31] ERROR upgrade_checker.py:749 normal error
Traceback (most recent call last):
  File "upgrade_checker.py", line 744, in <module>
    do_check(host, port, user, password, timeout, upgrade_params)
  File "upgrade_checker.py", line 709, in do_check
    check_fail_list()
  File "upgrade_checker.py", line 666, in check_fail_list
    raise MyError(error_msg)
MyError: 'upgrade checker failed with 1 reasons: [26 replicas unsync, please check] '
Traceback (most recent call last):
  File "upgrade_checker.py", line 744, in <module>
    do_check(host, port, user, password, timeout, upgrade_params)
  File "upgrade_checker.py", line 709, in do_check
    check_fail_list()
  File "upgrade_checker.py", line 666, in check_fail_list
    raise MyError(error_msg)
__main__.MyError: 'upgrade checker failed with 1 reasons: [26 replicas unsync, please check] '
[root@mxt-datanode01 etc]#