[2025-05-06 11:01:21] INFO upgrade_checker.py:743 parameters from cmd: host=“127.0.0.1”, port=2881, user=“root@sys”, password="", timeout=“0”, log-file=“upgrade_checker.log”
[2025-05-06 11:01:21] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:21] INFO upgrade_checker.py:337 check observer version success, version = 4.2.5.1
[2025-05-06 11:01:21] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:22] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from oceanbase.__all_virtual_tenant_parameter_info where name=‘compatible’, rowcount = 1
[2025-05-06 11:01:22] INFO upgrade_checker.py:57 succeed to execute query: select count() from oceanbase.__all_tenant, rowcount = 1
[2025-05-06 11:01:24] INFO upgrade_checker.py:57 succeed to execute query: select count() from __all_virtual_core_table where column_name in (‘target_data_version’, ‘current_data_version’) and column_value = 17180001537, rowco
unt = 1
[2025-05-06 11:01:24] 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-05-06 11:01:24] INFO upgrade_checker.py:57 succeed to execute query: select count(1) as unsync_cnt from GV$OB_LOG_STAT where in_sync = ‘NO’, rowcount = 1
[2025-05-06 11:01:24] INFO upgrade_checker.py:396 check paxos replica success
[2025-05-06 11:01:24] 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-05-06 11:01:25] 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-05-06 11:01:25] INFO upgrade_checker.py:408 check rebalance task success
[2025-05-06 11:01:25] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_MAJOR_COMPACTION where (GLOBAL_BROADCAST_SCN > LAST_SCN or STATUS != ‘IDLE’), rowcount = 1
[2025-05-06 11:01:25] INFO upgrade_checker.py:416 check cluster status success
[2025-05-06 11:01:25] INFO upgrade_checker.py:57 succeed to execute query: select count() as count from DBA_OB_TENANTS where status != ‘NORMAL’, rowcount = 1
[2025-05-06 11:01:25] INFO upgrade_checker.py:428 check tenant status success
[2025-05-06 11:01:26] INFO upgrade_checker.py:57 succeed to execute query: select count() as count from oceanbase.__all_virtual_tenant_info where tenant_role != ‘PRIMARY’ and tenant_role != ‘STANDBY’, rowcount = 1
[2025-05-06 11:01:26] INFO upgrade_checker.py:438 check tenant info success
[2025-05-06 11:01:26] INFO upgrade_checker.py:57 succeed to execute query: select count() from DBA_OB_TENANTS where LOCKED = ‘YES’, rowcount = 1
[2025-05-06 11:01:26] INFO upgrade_checker.py:447 check tenant lock status success
[2025-05-06 11:01:27] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_RESTORE_PROGRESS, rowcount = 1
[2025-05-06 11:01:27] INFO upgrade_checker.py:456 check restore job success
[2025-05-06 11:01:27] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:27] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from __all_virtual_ddl_task_status, rowcount = 1
[2025-05-06 11:01:27] INFO upgrade_checker.py:502 check ddl task execut status success
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select count(1) from CDB_OB_BACKUP_JOBS, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:513 check backup job success
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select count() from oceanbase.__all_server where (start_service_time <= 0 or status != “active”), rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:592 check observer status success
[2025-05-06 11:01:28] 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_schema_version % 8 = 0) as a join (select count() as cnt from oceanbase.__all_server join oceanbase.__all_tenant) as b, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:599 check schema status success
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct(substring_index(build_version, ‘_’, 1)) from __all_server, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:585 check server version success
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select tenant_name from oceanbase.DBA_OB_TENANTS, rowcount = 161
[2025-05-06 11:01:28] INFO upgrade_checker.py:609 check special tenant name success
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select distinct value from GV$OB_PARAMETERS where name=‘min_observer_version’, rowcount = 1
[2025-05-06 11:01:28] INFO upgrade_checker.py:57 succeed to execute query: select tenant_id from oceanbase.__all_tenant where compatibility_mode = 1, rowcount = 0
[2025-05-06 11:01:28] INFO upgrade_checker.py:661 check oracle standby_replication privs success
[2025-05-06 11:01:29] INFO upgrade_checker.py:57 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”), row
count = 1
[2025-05-06 11:01:29] INFO upgrade_checker.py:615 check log_transport_compress_func success
[2025-05-06 11:01:30] 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-05-06 11:01:30] INFO upgrade_checker.py:621 check table compression method success
[2025-05-06 11:01:30] INFO upgrade_checker.py:57 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
[2025-05-06 11:01:30] INFO upgrade_checker.py:627 check table_api_transport_compress_func success
[2025-05-06 11:01:30] 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: [30 replicas unsync, please check] ’
[2025-05-06 11:01:30] 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: [30 replicas unsync, please check] ’
[2025-05-06 11:01:30] ERROR upgrade_checker.py:749 normal error
Traceback (most recent call last):
File “upgrade_checker.py”, line 744, in
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: [30 replicas unsync, please check] ’
Traceback (most recent call last):
File “upgrade_checker.py”, line 744, in
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: [30 replicas unsync, please check] ’