2024-07-17 18:01:45.419 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=3353838, context=Context{parallelIdx=-1, stringMap={ob_tenant_id=1004, tenant_id=1000001, checkBeforeDataBackup=true, tenant_name=data_office, ob_version=4.2.2.0, startClusterCompact=false, task_instance_id=3405499, task_operation=execute, ob_cluster_id=1, startLogBackup=true, backupDim=TENANT, cluster_id=1, storageBaseInfo=******, tenantName=data_office, backupMode=physical, triggerType=BACKUP_NOW, latest_execution_start_time=2024-07-17T18:01:45.396+08:00, sub_task_instance_name=Start log backup if necessary, backupNow=true, sub_task_instance_id=3353838, dataBackupMode=FULL_BACKUP, obClusterName=main_data}, listMap={}}, executor=10.0.104.235 2024-07-17 18:01:45.447 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.455 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.459 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:01:45.462 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:01:45.504 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] .o.b.i.o.PhysicalBackupOpsServiceFactory : start tenant log backup, tenantId=1000001, tenantName=data_office 2024-07-17 18:01:45.518 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.532 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.535 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:01:45.538 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: ALTER SYSTEM ARCHIVELOG, args: [] 2024-07-17 18:01:45.573 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:01:45.577 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.580 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:01:45.582 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:01:45.585 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:02:15.612 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:02:15.618 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:02:15.623 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:02:15.629 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:02:15.638 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:02:45.665 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:02:45.670 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:02:45.675 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:02:45.679 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:02:45.684 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:03:15.714 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:03:15.718 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:03:15.726 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:03:15.730 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:03:15.735 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:03:45.761 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:03:45.766 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:03:45.771 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:03:45.775 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:03:45.783 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:04:15.810 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:04:15.816 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:04:15.821 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:04:15.825 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:04:15.830 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:04:45.854 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:04:45.864 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:04:45.869 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:04:45.872 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:04:45.877 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:05:15.905 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:05:15.910 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:05:15.915 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:05:15.919 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:05:15.923 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:05:45.949 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:05:45.954 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:05:45.962 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:05:45.966 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:05:45.970 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:06:15.997 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:06:16.001 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:06:16.008 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:06:16.012 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:06:16.017 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:06:46.046 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:06:46.051 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:06:46.055 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:06:46.063 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:07:16.090 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:07:16.093 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:07:16.098 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:07:16.102 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:07:16.106 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:07:46.132 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:07:46.136 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:07:46.140 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:07:46.144 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:07:46.149 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:08:16.183 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:08:16.187 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:08:16.192 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:08:16.195 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:08:16.200 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:08:46.227 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:08:46.232 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:08:46.237 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:08:46.241 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:08:46.245 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:09:16.272 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:09:16.277 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:09:16.284 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:09:16.289 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:09:16.293 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:09:46.319 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:09:46.323 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:09:46.328 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:09:46.332 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:09:46.337 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:10:16.363 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:10:16.366 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:10:16.370 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:10:16.372 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:10:16.375 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:10:46.401 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.s.o.o.f.ConnectPropertiesBuilder : get credential from obsdk context, clusterName=main_data, tenantName=sys, dbUser=root 2024-07-17 18:10:46.406 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:10:46.411 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ObConnectors : [obsdk]:connected server ip:10.0.229.208, sql port:2881 2024-07-17 18:10:46.415 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: set ob_query_timeout = ?, args: [10000000] 2024-07-17 18:10:46.420 INFO 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.ocp.obsdk.connector.ConnectTemplate : [obsdk] sql: select * 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 WHERE tenant_id = ? AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = ?)), args: [1004, 1004] 2024-07-17 18:11:01.902 ERROR 6278 --- [pool-manual-subtask-executor1,2d6957a3c7224a93,9b2a103c1c34] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor : Failed to start data backup. Error message: data backup pre-check failed, log backup not started. com.oceanbase.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:193) at com.oceanbase.ocp.backup.internal.task.schedule.StartLogBackupTask.run(StartLogBackupTask.java:48) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.execute(JavaSubtaskRunner.java:64) at com.oceanbase.ocp.core.task.engine.runner.JavaSubtaskRunner.doRun(JavaSubtaskRunner.java:32) 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:203) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:197) at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:134) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) 2024-07-17 18:11:02.687 WARN 6278 --- [pool-manual-subtask-executor2,2d6957a3c7224a93,1f5aead6b92f] c.o.o.c.t.e.runner.JavaSubtaskRunner : Cancel subtask, id=3353838, context=Context{parallelIdx=-1, stringMap={ob_tenant_id=1004, tenant_id=1000001, checkBeforeDataBackup=true, tenant_name=data_office, ob_version=4.2.2.0, startClusterCompact=false, task_instance_id=3405499, task_operation=cancel, ob_cluster_id=1, startLogBackup=true, backupDim=TENANT, cluster_id=1, storageBaseInfo=******, tenantName=data_office, backupMode=physical, triggerType=BACKUP_NOW, latest_execution_start_time=2024-07-17T18:11:02.662+08:00, sub_task_instance_name=Start log backup if necessary, backupNow=true, sub_task_instance_id=3353838, dataBackupMode=FULL_BACKUP, obClusterName=main_data}, listMap={}}, operation=CANCEL, executor=10.0.104.235 Set state for subtask: 3353838, operation:CANCEL, state: FAILED