Skip to content

filtering pattern not work, filter=exclude:*.*,include:gateway.* #1627

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
lijiawen opened this issue Jan 18, 2021 · 2 comments
Open

filtering pattern not work, filter=exclude:*.*,include:gateway.* #1627

lijiawen opened this issue Jan 18, 2021 · 2 comments

Comments

@lijiawen
Copy link

lijiawen commented Jan 18, 2021

this pattern means only replicate database 'gateway', but it will not work.

only with blacklist config, it will work well, like this:

filter= blacklist:A1.*,A2.*,....A100.*,exclude:*.*,include:B.*

but i have 100+ databases, the config looks so unfriendly, and i only have 3 databases read permission.

my maxwell version:1.29.1

the error message:

17:15:03,337 DEBUG TaskManager - Awaiting stop of: com.zendesk.maxwell.schema.PositionStoreThread@6de45d9d
java.lang.RuntimeException: Couldn't find database funds
	at com.zendesk.maxwell.replication.TableCache.processEvent(TableCache.java:26)
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getTransactionRows(BinlogConnectorReplicator.java:502)
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.getRow(BinlogConnectorReplicator.java:626)
	at com.zendesk.maxwell.replication.BinlogConnectorReplicator.work(BinlogConnectorReplicator.java:178)
	at com.zendesk.maxwell.util.RunLoopProcess.runLoop(RunLoopProcess.java:34)
	at com.zendesk.maxwell.Maxwell.startInner(Maxwell.java:255)
	at com.zendesk.maxwell.Maxwell.start(Maxwell.java:183)
	at com.zendesk.maxwell.Maxwell.main(Maxwell.java:286)
@lijiawen
Copy link
Author

@takeo , @nickpad , @baxter , @zdennis , please have a look ,thanks so much.

@wenyisheng
Copy link

wenyisheng commented Jan 28, 2021

@lijiawen
I had the same problem, RuntimeException: Couldn't find database, but it has been sloved.
Please try this: http://maxwells-daemon.io/quickstart/ ->
mysql> GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON . TO 'maxwell'@'%';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants