2025-01-16 10:09:23.001  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.service.iam.user.UserService     : user 100 login with organization 10000000

2025-01-16 10:09:23.004  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.o.c.t.e.runner.JavaSubtaskRunner     : Run subtask, id=11029141, context=Context{parallelIdx=-1, stringMap={tenant_id=2000002, tenant_name=payment, ob_tenant_parameter_map=, task_instance_id=11025460, create_readonly_user_flag=true, task_operation=execute, create_standby_tenant_param_json={"enableArbitration":false,"logTransportMode":"NETWORK","mode":"MYSQL","name":"payment","parameters":[],"primaryRootPassword":"******","primaryTenantId":1000001,"primaryZone":"RANDOM","restoreTenant":false,"zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}},{"name":"zone2","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}},{"name":"zone3","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}}]}, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1001,"name":"pool_payment_zone1_qvg","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone1"]},{"id":1003,"name":"pool_payment_zone2_onq","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone2"]},{"id":1002,"name":"pool_payment_zone3_hww","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone3"]}], primary_tenant_id=1000001, restore_tenant_job_id=1736993321927, cluster_id=2000001, system_variable_map=, standby_tenant_readonly_pass
word=xxx latest_execution_start_time=2025-01-16T10:09:22.988+08:00, sub_task_instance_name=Wait restore standby tenant success, standby_tenant_readonly_username=STANDBYRO, sub_task_instance_id=11029141, backup_config_json={"useCustomStorage":false,"fromBackupStrategy":true,"backupStorageType":"BACKUP_STORAGE_COS","storageUrl":"oceanbase-1328078479/backup","ossSecretModel":{"endpoint":"cos.ap-guangzhou.myqcloud.com","accessKeyId"=xxx,"accessKeySecret"=xxx,"appId":"1328078479"}}}, listMap={}}, executor=10.2.117.13

2025-01-16 10:09:23.090  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.o.s.o.o.f.ConnectPropertiesBuilder   : get credential from obsdk context,  clusterName=scob, tenantName=sys, dbUser=root

2025-01-16 10:09:23.119  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:09:23.128  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: SHOW VARIABLES LIKE 'system_time_zone'

2025-01-16 10:09:23.146  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:09:23.156  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: SELECT tenant_id, name, value, gmt_create, gmt_modified FROM __all_virtual_sys_variable WHERE name = ?

2025-01-16 10:09:23.187  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:09:23.217  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS restore_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment', args: [1736993321927]

2025-01-16 10:09:23.232  WARN 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] query failed, sql:[select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS restore_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment'], error message:[PreparedStatementCallback; bad SQL grammar [select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS re
store_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment']; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221820091) Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')]

2025-01-16 10:09:23.242  INFO 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.ocp.obsdk.connector.ConnectTemplate  : Last Trace Info:[YB420A030106-00062BB94ED4D56D-0-0]

2025-01-16 10:09:23.267 ERROR 1432603 --- [manual-subtask-executor16,370c0d6e3f0229b8,840dddabe1555bfe] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor  : Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')

java.sql.SQLException: Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2364)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2229)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2117)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:399)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:248)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:171)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeQuery(JDBC4PreparedStatement.java:185)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:724)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:650)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:715)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:746)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:759)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:812)
	at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.query(ConnectTemplate.java:91)
	at com.oceanbase.ocp.bac
kup.internal.obsdk.ObBackupConnectTemplate.query(ObBackupConnectTemplate.java:50)
	at com.oceanbase.backup.core.obsdk.operator.MysqlPhysicalAdvancedBackupOperator.listRestoreTasks(MysqlPhysicalAdvancedBackupOperator.java:693)
	at com.oceanbase.ocp.service.task.business.tenant.WaitRestoreStandbyTenantSuccessTask.lambda$run$0(WaitRestoreStandbyTenantSuccessTask.java:67)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithLimit(Retry.java:82)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithLimit(Retry.java:61)
	at com.oceanbase.ocp.service.task.business.tenant.WaitRestoreStandbyTenantSuccessTask.run(WaitRestoreStandbyTenantSuccessTask.java:63)
	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:206)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137)
	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)


Set state for subtask: 11029141, operation:EXECUTE, state: FAILED
2025-01-16 10:17:18.226  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.service.iam.user.UserService     : user 100 login with organization 10000000

2025-01-16 10:17:18.228  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.o.c.t.e.runner.JavaSubtaskRunner     : Retry subtask, id=11029141, context=Context{parallelIdx=-1, stringMap={tenant_id=2000002, tenant_name=payment, ob_tenant_parameter_map=, task_instance_id=11025460, create_readonly_user_flag=true, task_operation=retry, create_standby_tenant_param_json={"enableArbitration":false,"logTransportMode":"NETWORK","mode":"MYSQL","name":"payment","parameters":[],"primaryRootPassword":"******","primaryTenantId":1000001,"primaryZone":"RANDOM","restoreTenant":false,"zones":[{"name":"zone1","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}},{"name":"zone2","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}},{"name":"zone3","replicaType":"FULL","resourcePool":{"unitCount":1,"unitSpecName":"S5"}}]}, target_tenant_status=NORMAL, resource_pool_list_json=[{"id":1001,"name":"pool_payment_zone1_qvg","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone1"]},{"id":1003,"name":"pool_payment_zone2_onq","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone2"]},{"id":1002,"name":"pool_payment_zone3_hww","unitConfig":{"iopsWeight":20,"logDiskSize":144,"logDiskSizeByte":154618822656,"maxCpuCoreCount":20.00,"maxIops":0,"maxMemoryByte":51539607552,"maxMemorySize":48,"minCpuCoreCount":20.00,"minIops":0,"minMemoryByte":51539607552,"minMemorySize":48},"unitCount":1,"zoneList":["zone3"]}], primary_tenant_id=1000001, restore_tenant_job_id=1736993321927, cluster_id=2000001, system_variable_map=, standby_tenant_readonly_pass
word=xxx latest_execution_start_time=2025-01-16T10:17:18.214+08:00, sub_task_instance_name=Wait restore standby tenant success, standby_tenant_readonly_username=STANDBYRO, sub_task_instance_id=11029141, backup_config_json={"useCustomStorage":false,"fromBackupStrategy":true,"backupStorageType":"BACKUP_STORAGE_COS","storageUrl":"oceanbase-1328078479/backup","ossSecretModel":{"endpoint":"cos.ap-guangzhou.myqcloud.com","accessKeyId"=xxx,"accessKeySecret"=xxx,"appId":"1328078479"}}}, listMap={}}, executor=10.2.117.13

2025-01-16 10:17:18.302  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.o.s.o.o.f.ConnectPropertiesBuilder   : get credential from obsdk context,  clusterName=scob, tenantName=sys, dbUser=root

2025-01-16 10:17:18.322  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:17:18.330  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: SHOW VARIABLES LIKE 'system_time_zone'

2025-01-16 10:17:18.346  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:17:18.355  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: SELECT tenant_id, name, value, gmt_create, gmt_modified FROM __all_virtual_sys_variable WHERE name = ?

2025-01-16 10:17:18.377  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: set ob_query_timeout = ?, args: [10000000]

2025-01-16 10:17:18.408  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] sql: select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS restore_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment', args: [1736993321927]

2025-01-16 10:17:18.421  WARN 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : [obsdk] query failed, sql:[select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS restore_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment'], error message:[PreparedStatementCallback; bad SQL grammar [select * from (SELECT job_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display AS restore_finish_timestamp, IF(recover_scn_display != '', recover_scn_display, NULL) AS re
store_current_timestamp, start_timestamp AS start_time, finish_timestamp AS completion_time, restore_progress AS data_restore_progress, recover_progress AS log_restore_progress, status, comment AS error_msg, description FROM ( SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, recover_scn_display, start_timestamp, NULL AS finish_timestamp, status, restore_progress, recover_progress, NULL AS comment, description FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id, backup_cluster_name, backup_tenant_name, backup_tenant_id, backup_dest, restore_tenant_name, restore_tenant_id, restore_option, restore_scn_display, NULL as recover_scn_display, start_timestamp, finish_timestamp, status, NULL AS restore_progress, NULL AS recover_progress, comment, description FROM CDB_OB_RESTORE_HISTORY ) RIGHT JOIN (SELECT job_id AS _job_id, max(tenant_id) as _tenant_id FROM ( SELECT job_id, tenant_id FROM CDB_OB_RESTORE_PROGRESS UNION SELECT job_id, tenant_id FROM CDB_OB_RESTORE_HISTORY ) GROUP BY _job_id ) AS t ON job_id = t._job_id AND tenant_id = t._tenant_id WHERE description = ? ORDER BY start_time DESC)  where restore_tenant_name = 'payment']; nested exception is java.sql.SQLSyntaxErrorException: (conn=3221818514) Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')]

2025-01-16 10:17:18.431  INFO 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.ocp.obsdk.connector.ConnectTemplate  : Last Trace Info:[YB420A030106-00062BB94F04ABCC-0-0]

2025-01-16 10:17:18.456 ERROR 1432603 --- [manual-subtask-executor13,370c0d6e3f0229b8,746af3a226d1fdca] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor  : Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')

java.sql.SQLException: Unknown column 'recover_scn_display' in 'field list'
If column exists but type cannot be identified (example 'select ? `field1` from dual'). Use CAST function to solve this problem (example 'select CAST(? as integer) `field1` from dual')
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2364)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2229)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2117)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:399)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:248)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:171)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeQuery(JDBC4PreparedStatement.java:185)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:724)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:650)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:715)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:746)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:759)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:812)
	at com.oceanbase.ocp.obsdk.connector.ConnectTemplate.query(ConnectTemplate.java:91)
	at com.oceanbase.ocp.bac
kup.internal.obsdk.ObBackupConnectTemplate.query(ObBackupConnectTemplate.java:50)
	at com.oceanbase.backup.core.obsdk.operator.MysqlPhysicalAdvancedBackupOperator.listRestoreTasks(MysqlPhysicalAdvancedBackupOperator.java:693)
	at com.oceanbase.ocp.service.task.business.tenant.WaitRestoreStandbyTenantSuccessTask.lambda$run$0(WaitRestoreStandbyTenantSuccessTask.java:67)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithLimit(Retry.java:82)
	at com.oceanbase.ocp.common.lang.pattern.Retry.executeUntilWithLimit(Retry.java:61)
	at com.oceanbase.ocp.service.task.business.tenant.WaitRestoreStandbyTenantSuccessTask.run(WaitRestoreStandbyTenantSuccessTask.java:63)
	at com.oceanbase.ocp.core.task.runtime.Subtask.retry(Subtask.java:49)
	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:206)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.redirectConsoleOutput(SubtaskExecutor.java:200)
	at com.oceanbase.ocp.core.task.engine.coordinator.worker.subtask.SubtaskExecutor.lambda$submit$2(SubtaskExecutor.java:137)
	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)


Set state for subtask: 11029141, operation:RETRY, state: FAILED