observer.log:[2023-11-21 14:01:17.806102] WDIAG [SQL.RESV] get_database_id (ob_schema_checker.cpp:426) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=12][errcode=-4002] invalid arguments(tenant_id=1, database_name=, ret=-4002)
observer.log:[2023-11-21 14:01:17.806116] WDIAG [SQL.RESV] resolve_sp_access_name (ob_resolver_utils.cpp:1718) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=12][errcode=-4002] fail to exec schema_checker.get_database_id(tenant_id, current_database, database_id)(ret=-4002)
observer.log:[2023-11-21 14:01:17.806122] INFO  [SHARE.SCHEMA] get_database_id (ob_schema_getter_guard.cpp:1785) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=4] database not exist(tenant_id=1, database_name=dbms_scheduler)
observer.log:[2023-11-21 14:01:17.806125] WDIAG [SQL.RESV] get_database_id (ob_schema_checker.cpp:432) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=3][errcode=-5154] database is not exist(tenant_id=1, database_name=dbms_scheduler, ret=-5154)
observer.log:[2023-11-21 14:01:17.806245] INFO  [PL.CACHE] need_check_schema_version (ob_pl_cache.cpp:294) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=3] need check schema(new_schema_version=1699588432065480, cached_tenant_schema_version=1699588432065480)
observer.log:[2023-11-21 14:01:17.806479] INFO  [STORAGE] ~ObStorageTableGuard (ob_storage_table_guard.cpp:147) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=8] throttle statics(need_speed_limit=false, last_throttle_status=false, last_print_log_time=1700549407431857, stat={total_throttle_time_us:0, total_skip_throttle_time_us:0, last_log_timestamp:1700555477805439, last_throttle_status:false, 0=0, 1=0, 2=0, 3=0})
observer.log:[2023-11-21 14:01:17.808260] INFO  [SERVER] execute_write_inner (ob_inner_sql_connection.cpp:1545) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=15] execute write sql(ret=0, tenant_id=1, affected_rows=2, sql=UPDATE __all_tenant_scheduler_job SET gmt_modified = usec_to_time(1700555477806289), next_date = usec_to_time(1700688600000000), start_date = usec_to_time(1700688600000000) WHERE tenant_id = 0 AND job_name = X'54485552534441595F57494E444F57')
observer.log:[2023-11-21 14:01:17.808285] WDIAG [PL] set_attribute (ob_dbms_scheduler_mysql.cpp:181) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=13][errcode=-4016] invalid arguments(1 == affected_rows=false)
observer.log:[2023-11-21 14:01:17.808343] WDIAG [PL] execute (ob_pl.cpp:3801) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=5][errcode=-4016] Unhandled exception has occurred in PL(*ctx_.status_=-4016, ret=-4016)
observer.log:[2023-11-21 14:01:17.808351] WDIAG [PL] execute (ob_pl.cpp:1435) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=7][errcode=-4016] fail to exec pl.execute()(ret=-4016)
observer.log:[2023-11-21 14:01:17.808355] WDIAG [PL] execute (ob_pl.cpp:2049) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=2][errcode=-4016] fail to exec execute(ctx, allocator, *(ctx.get_package_guard()), *routine, &params, ((0 == nocopy_params.count()) ? __null : &nocopy_params), &result, status, stack_ctx.is_top_stack(), inner_call, routine->is_function() || in_function, false, loc, is_called_from_sql)(ret=-4016)
observer.log:[2023-11-21 14:01:17.808377] WDIAG [SQL.ENG] execute (ob_routine_executor.cpp:214) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=6][errcode=-4016] failed to execute pl(package_id=310047, routine_id=4, ret=-4016, pkg_id=310047)
observer.log:[2023-11-21 14:01:17.808385] WDIAG [SQL] open_cmd (ob_result_set.cpp:98) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=6][errcode=-4016] execute cmd failed(ret=-4016)
observer.log:[2023-11-21 14:01:17.808388] WDIAG [SQL] open (ob_result_set.cpp:157) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=3][errcode=-4016] execute plan failed(ret=-4016)
observer.log:[2023-11-21 14:01:17.808394] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:145) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=5][errcode=-4016] close result set fail(cret=-4016)
observer.log:[2023-11-21 14:01:17.808398] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:932) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=3][errcode=-4016] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4016, err_:"OB_ERR_UNEXPECTED", retry_type:0, client_ret:-4016}, need_retry=false, THIS_WORKER.can_retry()=true, v.ctx_.multi_stmt_item_={is_part_of_multi_stmt:false, seq_num:0, sql:"call dbms_scheduler.set_attribute("THURSDAY_WINDOW", "NEXT_DATE", "2023-11-23 03:00:00")", batched_queries:NULL, is_ps_mode:false, ab_cnt:0})
observer.log:[2023-11-21 14:01:17.808412] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:151) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=13][errcode=-4016] result set open failed, check if need retry(ret=-4016, cli_ret=-4016, retry_ctrl_.need_retry()=0)
observer.log:[2023-11-21 14:01:17.808422] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:315) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=4] sending error packet(ob_error=-4016, client error=-4016, extra_err_info=NULL, lbt()="0x1142b34c 0x94274f2 0x93d3d01 0x4b49270 0x48c21c9 0x48bb5cd 0x48b1bcb 0x48ad05b 0x92f4a84 0x116e1baf 0x7fdd69653ea5 0x7fdd6937cb0d")
observer.log:[2023-11-21 14:01:17.808458] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:498) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=7] dump txn free route audit_record(value=1048581, session->get_sessid()=3221596497, session->get_proxy_sessid()=12402666151354779087)
observer.log:[2023-11-21 14:01:17.808466] WDIAG [SERVER] do_process (obmp_query.cpp:808) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=7][errcode=-4016] execute query fail(ret=-4016, timeout_timestamp=4917227477806009)
observer.log:[2023-11-21 14:01:17.808481] WDIAG [SQL.PC] common_free (ob_lib_cache_object_manager.cpp:141) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=3][errcode=0] set logical del time(cache_obj->get_logical_del_time()=972017652859, cache_obj->added_lc()=false, cache_obj->get_object_id()=6103, cache_obj->get_tenant_id()=1, lbt()="0x1142b34c 0x9bf4500 0x48c8234 0x9b6ca3d 0xccca720 0x4b36877 0x48ca25a 0x48c4de6 0x48c0ec3 0x48bb5cd 0x48b1bcb 0x48ad05b 0x92f4a84 0x116e1baf 0x7fdd69653ea5 0x7fdd6937cb0d")
observer.log:[2023-11-21 14:01:17.808489] INFO  [SQL.PC] before_cache_evicted (ob_i_lib_cache_object.cpp:76) [13339][T1_L0_G0][T1][YB42AC1F1F27-000609C386C12CF0-0-0] [lt=8] before_cache_evicted(this=0x7fdc4b12c050, this={can_direct_use_param:false, package_id:310047, routine_id:4, out_idx:[], out_name:[], out_type:[], out_type_name:[], out_type_owner:[], is_udt_routine:false})








[root@ip-172-31-31-39 log]# grep "[YB42AC1F1F27-000609C386C12CF0-0-0]" rootservice.log
grep: Invalid range end