【 使用环境 】生产环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】想实现canal for ob采集oceanbase的binlog,故采用oblogproxy,但是将binlog_mode设置为true的时候就会报错
报错信息如下:
2026-10-21 11:36:37.350179 [info] mysql_connection_wrapper.cpp(93): The number of connections in the connection pool is:30
2026-10-21 11:36:37.351318 [debug] database_protocol.cpp(1740): set node_id=9db9dde329a5b8f14efa04dd99be679
2026-10-21 11:36:37.361366 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.361451 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 0
2026-10-21 11:36:37.364624 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.364772 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 1
2026-10-21 11:36:37.367728 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.368916 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 2
2026-10-21 11:36:37.368908 [error] mysql_connection_wrapper.h(213): The maximum number (3) of retries was reached and the execution failed.
2026-10-21 11:36:37.386248 [info] tcp_port_pool.cpp(54): Successfully init tcp port pool, available ports(total: 256): 8100|8101|8102|8103|8104|8105|8106|8107|8108|8109|8110|8111|8112|8113|8114|8115|8116|8117|8118|8119|8120|8121|8122|8123|8124|8125|8126|8127|8128|8129|8130|8131|8132|8133|8134|8135|8136|8137|8138|8139|8140|8141|8142|8143|8144|8145|8146|8147|8148|8149|8150|8151|8152|8153|8154|8155|8156|8157|8158|8159|8160|8161|8162|8163|8164|8165|8166|8167|8168|8169|8170|8171|8172|8173|8174|8175|8176|8177|8178|8179|8180|8181|8182|8183|8184|8185|8186|8187|8188|8189|8190|8191|8192|8193|8194|8195|8196|8197|8198|8199|8200|8201|8202|8203|8204|8205|8206|8207|8208|8209|8210|8211|8212|8213|8214|8215|8216|8217|8218|8219|8220|8221|8222|8223|8224|8225|8226|8227|8228|8229|8230|8231|8232|8233|8234|8235|8236|8237|8238|8239|8240|8241|8242|8243|8244|8245|8246|8247|8248|8249|8250|8251|8252|8253|8254|8255|8256|8257|8258|8259|8260|8261|8262|8263|8264|8265|8266|8267|8268|8269|8270|8271|8272|8273|8274|8275|8276|8277|8278|8279|8280|8281|8282|8283|8284|8285|8286|8287|8288|8289|8290|8291|8292|8293|8294|8295|8296|8297|8298|8299|8300|8301|8302|8303|8304|8305|8306|8307|8308|8309|8310|8311|8312|8313|8314|8315|8316|8317|8318|8319|8320|8321|8322|8323|8324|8325|8326|8327|8328|8329|8330|8331|8332|8333|8334|8335|8336|8337|8338|8339|8340|8341|8342|8343|8344|8345|8346|8347|8348|8349|8350|8351|8352|8353|8354|8355
2026-10-21 11:36:37.387761 [debug] database_protocol.cpp(2967): Query config items,sql: SELECT * FROM config_template WHERE granularity = ?
2026-10-21 11:36:37.387838 [debug] database_protocol.cpp(3118): set granularity=0
2026-10-21 11:36:37.389587 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.389690 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 0
2026-10-21 11:36:37.392578 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.392687 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 1
2026-10-21 11:36:37.392687 [error] mysql_connection_wrapper.cpp(278): Failed to execute query, error: (conn=3221496821) No database selected , error code:1046
2026-10-21 11:36:37.395390 [warning] mysql_connection_wrapper.h(204): Execution failed, wait 1000 microseconds and try again…,the current number of retries is 2
2026-10-21 11:36:37.395512 [error] mysql_connection_wrapper.h(213): The maximum number (3) of retries was reached and the execution failed.
2026-10-21 11:36:37.396623 [error] binlog_manager.cpp(101): Failed to query global configs from metadb.
2026-10-21 11:36:37.407432 [error] binlog_manager.cpp(47): Failed to init global config
2026-10-21 11:36:37.407534 [warning] entry.cpp(137): !!!LogProxy Exit, ret: -1