search

zendesk / maxwell

Maxwell's daemon, a mysql-to-json kafka producer
https://maxwells-daemon.io/
Other
4.05k stars 1.01k forks source link

Couldn't find database #2106

Open eugenetaranov opened 3 months ago

eugenetaranov commented 3 months ago

Hello,

I started fresh maxwell instance and got the error below. Deleted maxwell database, restarted but error is still the same.

java.lang.RuntimeException: Couldn't find database test20

Full log:

 ✔ Container maxwell  Created                                                                                                    0.0s 
Attaching to maxwell
maxwell  | 2024-08-26 13:06:17 INFO  Maxwell - Starting Maxwell. maxMemory: 2057306112 bufferMemoryUsage: 0.25
maxwell  | 2024-08-26 13:06:22 INFO  Maxwell - Maxwell v1.41.2 is booting (StdoutProducer), starting at Position[BinlogPosition[mysql-bin-changelog.232900:37885], lastHeartbeat=1724677252169]
maxwell  | 2024-08-26 13:06:23 INFO  MysqlSavedSchema - Restoring schema id 2 (last modified at Position[BinlogPosition[mysql-bin-changelog.232900:37885], lastHeartbeat=1724677252169])
maxwell  | 2024-08-26 13:06:23 INFO  AbstractSchemaStore - Maxwell is capturing initial schema
maxwell  | 2024-08-26 13:06:24 INFO  BinlogConnectorReplicator - Setting initial binlog pos to: mysql-bin-changelog.232900:37885
maxwell  | 2024-08-26 13:06:25 INFO  BinaryLogClient - Connected to HHHH:3306 at mysql-bin-changelog.232900/37885 (sid:6379, cid:4287)
maxwell  | 2024-08-26 13:06:25 INFO  BinlogConnectorReplicator - Binlog connected.
maxwell  | 2024-08-26 13:06:25 INFO  BinlogConnectorReplicator - Binlog disconnected.
maxwell  | 2024-08-26 13:06:25 INFO  TaskManager - Stopping 3 tasks
maxwell  | 2024-08-26 13:06:25 ERROR TaskManager - cause: 
maxwell  | java.lang.RuntimeException: Couldn't find database test20
maxwell  |      at com.zendesk.maxwell.replication.TableCache.processEvent(TableCache.java:28) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getTransactionRows(BinlogConnectorReplicator.java:592) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:727) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  | 2024-08-26 13:06:25 INFO  TaskManager - Stopping: com.zendesk.maxwell.schema.PositionStoreThread@51897a80
maxwell  | 2024-08-26 13:06:25 INFO  TaskManager - Stopping: com.zendesk.maxwell.bootstrap.BootstrapController@5869ca8c
maxwell  | 2024-08-26 13:06:25 INFO  TaskManager - Stopping: com.zendesk.maxwell.replication.BinlogConnectorReplicator@56e63cbc
maxwell  | java.lang.RuntimeException: Couldn't find database test20
maxwell  |      at com.zendesk.maxwell.replication.TableCache.processEvent(TableCache.java:28)
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getTransactionRows(BinlogConnectorReplicator.java:592)
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:727)
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235)
maxwell  |      at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34)
maxwell  |      at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302)
maxwell  |      at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227)
maxwell  |      at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337)
maxwell  | 2024-08-26 13:06:25 ERROR Maxwell - Maxwell saw an exception and is exiting...
maxwell  | java.lang.RuntimeException: Couldn't find database test20
maxwell  |      at com.zendesk.maxwell.replication.TableCache.processEvent(TableCache.java:28) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getTransactionRows(BinlogConnectorReplicator.java:592) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:727) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:235) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:302) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.start(Maxwell.java:227) ~[maxwell-1.41.2.jar:1.41.2]
maxwell  |      at com.zendesk.maxwell.Maxwell.main(Maxwell.java:337) [maxwell-1.41.2.jar:1.41.2]
maxwell  | 2024-08-26 13:06:25 INFO  TaskManager - Stopped all tasks
maxwell exited with code 1

docker-compose.yaml:

services:
  maxwell:
    image: zendesk/maxwell:latest
    container_name: maxwell
    command: >
      bin/maxwell --user='UUU' --password='PPP' --host='HHH' --recapture_schema=true
      --producer=stdout
    networks:
      - maxwell-network

networks:
  maxwell-network:
    driver: bridge