生产系统如何更改system_time_zone ？

一起唠嗑
#1

生产系统如何更改system_time_zone ？

#2

image
image1107×530 56 KB

1 个赞
#3

备份任务似乎会依赖sys租户下的 system_time_zone, 那这不是完蛋了 :sob: 我们的system_time_zone 也有问题. 导致备份一直Wait log backup checkpoint

#4

备份失败日志:

2026-04-22 18:10:28.184  INFO 97485 --- [manual-subtask-executor14,2f7635b676dda6d8,877379edece71cd5] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: SELECT /*+ ocp_query */ * from (SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, IF(start_scn_display != '', start_scn_display, NULL) AS min_first_time, IF(checkpoint_scn_display != '', checkpoint_scn_display, NULL) AS max_next_time, status, IF(checkpoint_scn != '', truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4), NULL) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY RIGHT JOIN (SELECT tenant_id as _tenant_id, max(round_id) as _round_id FROM CDB_OB_ARCHIVELOG_SUMMARY GROUP BY _tenant_id ) AS t ON tenant_id = t._tenant_id and round_id = t._round_id)

2026-04-22 18:10:28.199  INFO 97485 --- [manual-subtask-executor14,2f7635b676dda6d8,877379edece71cd5] .o.o.b.i.t.s.WaitLogBackupCheckpointTask : log backup checkpoint=2026-04-22T02:08:01.158723Z is before data backup min restore time=2026-04-22T09:33:10.001925360Z

2026-04-22 18:10:28.202  INFO 97485 --- [manual-subtask-executor14,2f7635b676dda6d8,877379edece71cd5] c.o.ocp.common.lang.pattern.Retry        : wait for 30 seconds

Set state for subtask: 1009332, operation:RETRY, state: FAILED
2026-04-22 18:10:57.373  WARN 97485 --- [subtask-executor27,08479c393f6fb166,a2da975d67d6eeff] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor  : Receive timeout callback, id=1009332, name=Wait log backup checkpoint, elapsed=600, timeout=600

2026-04-22 18:10:57.373 ERROR 97485 --- [manual-subtask-executor14,2f7635b676dda6d8,877379edece71cd5] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor  : interrupted, msg:sleep interrupted

java.lang.RuntimeException: interrupted, msg:sleep interrupted
	at com.oceanbase.ocp.common.lang.pattern.Retry.waitFor(Retry.java:202)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithTimeout(Retry.java:114)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithTimeout(Retry.java:98)
	at com.oceanbase.ocp.backup.internal.task.schedule.WaitLogBackupCheckpointTask.run(WaitLogBackupCheckpointTask.java:68)
	at com.oceanbase.ocp.core.task.runtime.Subtask.retry(Subtask.java:86)
	at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.retry(JavaSubtaskRunner.java:76)
	at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:35)
	at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26)
	at com.oceanbase.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:76)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.doRun(SubtaskExecutor.java:234)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:228)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$3(SubtaskExecutor.java:154)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at com.oceanbase.ocp.common.trace.TraceDecorator.lambda$decorate$0(TraceDecorator.java:33)
	at java.base/java.lang.Thread.run(Unknown Source)
#5

666