| ... | ... | @@ -94,4 +94,58 @@ java.lang.RuntimeException: Couldn't find table t_restricted_consumer in databas |
|
|
|
at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227) ~[maxwell-1.40.0.jar:1.40.0]
|
|
|
|
at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337) ~[maxwell-1.40.0.jar:1.40.0]
|
|
|
|
解决方案:在databases中写入库信息
|
|
|
|
```
|
|
|
|
|
|
|
|
## oceanbase数据库卡住不消费
|
|
|
|
```
|
|
|
|
|
|
|
|
>>> tailf /home/maxwell/maxwell-1.40.0/logs/bdp_bid.out
|
|
|
|
2024-01-22 15:20:43.053 INFO Server - Started Server@5b873c1c{STARTING}[10.0.12,sto=0] @1801ms
|
|
|
|
2024-01-22 15:20:47.544 ERROR MysqlParserListener - (parse PURGE TABLE __recycle_$_42100023_1705288380474488)
|
|
|
|
2024-01-22 15:20:47.544 ERROR SchemaChange - Error parsing SQL: 'PURGE TABLE __recycle_$_42100023_1705288380474488'
|
|
|
|
2024-01-22 15:20:47.545 ERROR AbstractSchemaStore - Error on bin log position Position[BinlogPosition[mysql-bin.000149:191458712], lastHeartbeat=0]
|
|
|
|
com.zendesk.maxwell.schema.ddl.MaxwellSQLSyntaxError: PURGE
|
|
|
|
at com.zendesk.maxwell.schema.ddl.MysqlParserListener.visitErrorNode(MysqlParserListener.java:93)
|
|
|
|
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:17)
|
|
|
|
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:28)
|
|
|
|
at com.zendesk.maxwell.schema.ddl.SchemaChange.parseSQL(SchemaChange.java:101)
|
|
|
|
at com.zendesk.maxwell.schema.ddl.SchemaChange.parse(SchemaChange.java:115)
|
|
|
|
at com.zendesk.maxwell.schema.AbstractSchemaStore.resolveSQL(AbstractSchemaStore.java:49)
|
|
|
|
at com.zendesk.maxwell.schema.MysqlSchemaStore.processSQL(MysqlSchemaStore.java:102)
|
|
|
|
at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:385)
|
|
|
|
at com.zendesk.maxwell.replication.BinlogConnectorReplicator.processQueryEvent(BinlogConnectorReplicator.java:407)
|
|
|
|
at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:735)
|
|
|
|
at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235)
|
|
|
|
at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34)
|
|
|
|
at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302)
|
|
|
|
at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227)
|
|
|
|
at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337)
|
|
|
|
|
|
|
|
>>> mysql -ht4zh2rl5dsfsw.oceanbase.aliyuncs.com -ubdp_nu -p'O_mqMnZVU_(iOohZn8JGs' -e "show binlog events in 'mysql-bin.000149' from 191458712 limit 10"
|
|
|
|
mysql: [Warning] Using a password on the command line interface can be insecure.
|
|
|
|
+------------------+-----------+-------------+------------+-------------+--------------------------------------------------------------------------+
|
|
|
|
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
|
|
|
|
+------------------+-----------+-------------+------------+-------------+--------------------------------------------------------------------------+
|
|
|
|
| mysql-bin.000149 | 191458712 | Query | 1147473732 | 191458822 | use __recyclebin;PURGE TABLE __recycle_$_42100023_1705288380474488 |
|
|
|
|
| mysql-bin.000149 | 191458822 | Gtid | 1147473732 | 191458887 | SET @@SESSION.GTID_NEXT= '801fd65c-3115-11ee-8871-00163e049509:22356149' |
|
|
|
|
| mysql-bin.000149 | 191458887 | Query | 1147473732 | 191458941 | BEGIN |
|
|
|
|
| mysql-bin.000149 | 191458941 | Table_map | 1147473732 | 191459038 | table id: 41399833829172 (bid_cert.tb_rzrk_certificates) |
|
|
|
|
| mysql-bin.000149 | 191459038 | Update_rows | 1147473732 | 191472758 | table_id: 41399833829172 flags: STMT_END_F |
|
|
|
|
| mysql-bin.000149 | 191472758 | Xid | 1147473732 | 191472789 | Xid ID=22356149 |
|
|
|
|
| mysql-bin.000149 | 191472789 | Gtid | 1147473732 | 191472854 | SET @@SESSION.GTID_NEXT= '801fd65c-3115-11ee-8871-00163e049509:22356150' |
|
|
|
|
| mysql-bin.000149 | 191472854 | Query | 1147473732 | 191472908 | BEGIN |
|
|
|
|
| mysql-bin.000149 | 191472908 | Table_map | 1147473732 | 191473005 | table id: 41399833829172 (bid_cert.tb_rzrk_certificates) |
|
|
|
|
| mysql-bin.000149 | 191473005 | Update_rows | 1147473732 | 191482863 | table_id: 41399833829172 flags: STMT_END_F |
|
|
|
|
+------------------+-----------+-------------+------------+-------------+--------------------------------------------------------------------------+
|
|
|
|
|
|
|
|
解决方案: 特定信息解析不的,可以跳过此条,直接进入下一条,比如mysql-bin.000149的191458712这个位置的信息: use __recyclebin;PURGE TABLE __recycle_$_42100023_1705288380474488
|
|
|
|
>>> mysql -h 10.8.6.87 -uroot -proot123 -P3802 -Dmaxwell -e "select * from positions"
|
|
|
|
+-----------+------------------+-----------------+----------+-------------+--------------+---------------------+
|
|
|
|
| server_id | binlog_file | binlog_position | gtid_set | client_id | heartbeat_at | last_heartbeat_read |
|
|
|
|
+-----------+------------------+-----------------+----------+-------------+--------------+---------------------+
|
|
|
|
| 2 | mysql-bin.000149 | 191458822 | NULL | bdp_bid | NULL | 0 |
|
|
|
|
+-----------+------------------+-----------------+----------+-------------+--------------+---------------------+
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
``` |
