############{EXECUTE}{2023-02-28T17:22:36.285+08:00}############2023-02-28 17:22:36.322 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=92282, context=Context{parallelIdx=-1, stringMap={checkBeforeDataBackup=true, ob_version=4.0.0.0, prohibit_rollback=false, startClusterCompact=false, task_instance_id=81099, task_operation=execute, ob_cluster_id=1, startLogBackup=true, backupDim=CLUSTER, cluster_id=3, storageBaseInfo=******, tenantName=*, backupMode=physical, triggerType=BACKUP_NOW, latest_execution_start_time=2023-02-28T17:22:36.275+08:00, backupNow=true, sub_task_instance_id=92282, dataBackupMode=FULL_BACKUP, obClusterName=obcluster}, listMap={}}, executor=192.168.0.15 2023-02-28 17:22:36.361 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:22:36.371 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:22:36.376 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:22:36.384 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: alter system archivelog 2023-02-28 17:22:36.961 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.o.o.b.i.o.PhysicalBackupObOpsService : start log backup done, clusterId=3 2023-02-28 17:22:36.990 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:22:37.013 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:22:37.046 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:22:37.052 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:22:37.060 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:23:07.111 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:23:07.138 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:23:07.187 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:23:07.667 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:23:07.675 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:23:37.716 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:23:37.730 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:23:37.757 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:23:37.762 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:23:37.788 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:24:07.853 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:24:07.870 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:24:07.908 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:24:07.912 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:24:07.928 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:24:37.963 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:24:37.977 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:24:37.995 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:24:38.001 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:24:38.033 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:25:08.124 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:25:08.142 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:25:08.169 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:25:08.175 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:25:08.185 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:25:38.226 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:25:38.257 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:25:38.278 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:25:38.283 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:25:38.297 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:26:08.332 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:26:08.683 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:26:08.705 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:26:08.710 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:26:08.718 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:26:38.761 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:26:38.770 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:26:38.790 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:26:38.801 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:26:38.815 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:27:08.907 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:27:08.922 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:27:08.997 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:27:09.002 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:27:09.010 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:27:39.090 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:27:39.112 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:27:39.118 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:27:39.136 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:28:09.179 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:28:09.184 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:28:09.211 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:28:09.216 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:28:09.227 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:28:39.263 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:28:39.274 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:28:39.304 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:28:39.312 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:28:39.319 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:29:09.357 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:29:09.672 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:29:09.698 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:29:09.707 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:29:09.729 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:29:39.771 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:29:39.979 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:29:43.144 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:29:43.151 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:29:43.212 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:30:13.711 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:30:13.745 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:30:13.800 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:30:13.806 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:30:13.813 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:30:43.883 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:30:43.911 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:30:43.954 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:30:43.959 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:30:43.966 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:31:14.014 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:31:14.032 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:31:14.057 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:31:14.062 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:31:14.079 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:31:44.153 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:31:44.252 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:31:44.277 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:31:44.282 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:31:44.289 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:32:14.686 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, userId=100, clusterName=obcluster, tenantName=sys, dbUser=root 2023-02-28 17:32:14.701 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:32:14.740 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.core.obsdk.connector.ObConnectors : [obsdk]:connected server ip:192.168.0.192, sql port:2881 2023-02-28 17:32:14.747 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2023-02-28 17:32:14.763 INFO 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.obsdk.connector.ConnectTemplate : [obsdk] sql: SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, start_scn_display AS min_first_time, checkpoint_scn_display AS max_next_time, status, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?), args: [1004, 1004] 2023-02-28 17:32:14.773 ERROR 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.o.o.b.i.o.PhysicalBackupTaskService : data backup pre-check failed, log backup not started 2023-02-28 17:32:14.779 WARN 43 --- [pool-manual-subtask-executor14,76f4c04136f74278,40b0fa4633d9] c.a.o.c.t.engine.runner.RunnerFactory : Execute task failed, subtask=SubtaskInstanceOverview{id=92282, name=Start log backup if necessary, state=FAILED, operation=EXECUTE, className=com.oceanbase.ocp.backup.internal.task.schedule.StartLogBackupTask, seriesId=2, startTime=2023-02-28T17:22:36.275+08:00, endTime=null}, failedMessage=Failed to start data backup. Error message: data backup pre-check failed, log backup not started. com.alipay.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=BACKUP_START_DATA_BACKUP_FAILED, args=data backup pre-check failed, log backup not started at com.oceanbase.ocp.backup.internal.operation.PhysicalBackupTaskService.waitLogBackupStarted(PhysicalBackupTaskService.java:166) ~[ocp-backup-service-4.0.0-20220930.jar!/:4.0.0-20220930] at com.oceanbase.ocp.backup.internal.task.schedule.StartLogBackupTask.run(StartLogBackupTask.java:49) ~[ocp-backup-service-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:60) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.JavaSubtaskRunner.run(JavaSubtaskRunner.java:26) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.doRun(RunnerFactory.java:111) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.redirectOutputIfNotSysSchedule(RunnerFactory.java:183) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.runner.RunnerFactory.run(RunnerFactory.java:101) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at com.alipay.ocp.core.task.engine.coordinator.worker.subtask.ReadySubtaskWorker.lambda$null$1(ReadySubtaskWorker.java:117) ~[ocp-core-4.0.0-20220930.jar!/:4.0.0-20220930] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_312] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_312] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_312] Set state for subtask: 92282, operation:EXECUTE, state: FAILED