租户开启binlog服务

AntTech_E6QBJV · 2025 年10 月 22 日 17:52

报错日志（详见附件）

2025-10-22 16:47:26.808 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.ocp.service.iam.user.UserService : user 100 login with organization 10000000

2025-10-22 16:47:26.814 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.c.t.e.runner.JavaSubtaskRunner : Run subtask, id=5537, context=Context{parallelIdx=-1, stringMap={tenant_id=6, target_tenant_binlog_service_status=RUNNING, cluster_cdcro_password=xxx task_instance_id=5420, task_operation=execute, binlog_cluster_id=3, binlog_instance_replicate_count=1, tenant_binlog_service_id=6, operation_scope=Tenant, latest_execution_start_time=2025-10-22T16:47:26.774+08:00, sub_task_instance_name=Wait tenant binlog service active, sub_task_instance_id=5537, cluster_cdcro_username=cdcro}, listMap={binlog_service_obproxy_cluster_ids_to_add=[1], binlog_instance_parameters=[binlog_expire_logs_seconds|86400, binlog_expire_logs_size|53687091200]}}, executor=10.40.65.146

2025-10-22 16:47:26.846 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null)

2025-10-22 16:47:26.852 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG STATUS FOR TENANT myoceanbase2.test2

2025-10-22 16:47:26.982 WARN 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] query failed, sql: [SHOW BINLOG STATUS FOR TENANT myoceanbase2.test2], error message: [Incorrect result size: expected 1, actual 0]

2025-10-22 16:47:26.987 WARN 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : no result for show binlog status, cluster: myoceanbase2, tenant: test2

2025-10-22 16:47:26.992 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Tenant binlog service is not active, retrying…

2025-10-22 16:47:30.029 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null)

2025-10-22 16:47:30.034 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG STATUS FOR TENANT myoceanbase2.test2

2025-10-22 16:47:30.166 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Tenant binlog service is active, tenantId=6

2025-10-22 16:47:30.175 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.b.operator.JdbcBinlogOperator : binlog operator created, connectProperties=ConnectProperties(address=10.40.65.151, port=2983, username=null, password=null)

2025-10-22 16:47:30.214 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] c.o.o.binlogsdk.operator.BinlogTemplate : [binlogsdk] sql: SHOW BINLOG INSTANCES FOR myoceanbase2.test2

2025-10-22 16:47:30.345 INFO 16470 — [manual-subtask-executor16,53897cae143d401d,972fe44834739996] .b.i.t.WaitTenantBinlogServiceActiveTask : Binlog instance [p9waot6hwm] status not normal, retrying…

subtask_5537.log (9.6 KB)

辞霜 · 2025 年10 月 22 日 18:04

这边修改了你的用户等级，麻烦提供一份完整的日志附件

AntTech_E6QBJV · 2025 年10 月 22 日 19:30

已经上传日志

淇铭 · 2025 年10 月 23 日 10:44

你创建binlog server了么？你可以先看看ocp的文档
https://www.oceanbase.com/docs/common-ocp-1000000003339476

AntTech_E6QBJV · 2025 年10 月 23 日 10:50

有的，之前已经创建好

淇铭 · 2025 年10 月 23 日 10:58

看着没有创建实例呀
注意binlog的版本一定要适配ob的版本要不然会有问题

AntTech_E6QBJV · 2025 年10 月 23 日 11:20

怎么创建实例，在租户里面，点击开通，参考是这个文档
http://10.40.198.13:23599/docs/zh-CN/index.html#/700.manage-binlog-service-of-a-tenant.html

AntTech_E6QBJV · 2025 年10 月 23 日 11:22

OceanBase 版本号 4.3.5.4

binlog 版本号 4.0.1

cdc 版本号 4.0.1

淇铭 · 2025 年10 月 23 日 13:58

淇铭 · 2025 年10 月 23 日 13:58

https://www.oceanbase.com/docs/common-ocp-1000000003339290
https://www.oceanbase.com/docs/common-oblogproxy-doc-1000000003926240
可以先好好看看ocp文档和binlog的文档

AntTech_E6QBJV · 2025 年10 月 24 日 16:48

上传，最新的 obbinlog-ce-4.2.5-100000042025052216.el7.x86_64.rpm 包，报错

Unhandled exception, type=DataAccessResourceFailureException, message=could not execute statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute statement

旭辉 · 2025 年10 月 24 日 16:51

将上传包报错的截图及ocp-server.log 发下

旭辉 · 2025 年10 月 24 日 17:32

最新的也不是这个包 obbinlog-ce-4.2.5-100000042025052216.el7.x86_64.rpm，最新的是4.2.10

AntTech_E6QBJV · 2025 年10 月 27 日 11:41

AntTech_E6QBJV · 2025 年10 月 27 日 11:42

ocp-server-1027.log (13.1 MB)
*

旭辉 · 2025 年10 月 27 日 14:09

025-10-27 11:39:39.775 ERROR 2458 --- [http-nio-0.0.0.0-8081-exec-9,ffb81588d0a4e3e1,f3babe318a5294f5] c.o.o.s.c.e.RestExceptionHandler         : Unhandled exception, uri=/api/v2/software-packages, duration=42939

org.springframework.dao.DataAccessResourceFailureException: could not execute statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute statement
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:255)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:551)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:243)
……

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
	... 200 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: (conn=134538047) Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
	at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128)
	at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202)
	at com.oceanbase.jdbc.OceanBaseStatement.executeExceptionEpilogue(OceanBaseStatement.java:320)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:257)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.execute(JDBC4PreparedStatement.java:171)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeUpdate(JDBC4PreparedStatement.java:205)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
	... 224 common frames omitted
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
	at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:205)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:186)
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:401)
	at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:248)
	... 229 common frames omitted
Caused by: java.sql.SQLException: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
	at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2366)
	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)
	... 230 common frames omitted