Comments (6)
huh. what version of mysql? I can certainly add this to the blacklist as Maxwell doesn't care about temporary tables, but according to https://dev.mysql.com/doc/refman/5.6/en/replication-features-temptables.html this isn't supposed to happen with row-based replication.
from maxwell.
SELECT VERSION()
tells me 5.6.25-enterprise-commercial-advanced-log
from maxwell.
I also got this error today. removed private data from query
12:45:12,219 ERROR SchemaChange - Error parsing SQL: 'CREATE OR REPLACE xyz=UNDEFINED DEFINER=`xyz`@`%` SQL zyz VIEW `zyz` AS SELECT a.ztzAS xyz, a.zyzAS zyx, a.xyzAS xyz, a.xyzAS xyz, b.xyzAS xyz, b.xyzAS xyz, b.xyzAS xyz, b.xyzAS blab , FROM xyz AS a, xyx AS b WHERE a.xyz= b.xyz'
com.zendesk.maxwell.schema.ddl.MaxwellSQLSyntaxError: CREATE
at com.zendesk.maxwell.schema.ddl.MysqlParserListener.visitErrorNode(MysqlParserListener.java:85)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:41)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)
at com.zendesk.maxwell.schema.ddl.SchemaChange.parse(SchemaChange.java:67)
at com.zendesk.maxwell.MaxwellReplicator.processQueryEvent(MaxwellReplicator.java:274)
at com.zendesk.maxwell.MaxwellReplicator.getRow(MaxwellReplicator.java:254)
at com.zendesk.maxwell.MaxwellReplicator.work(MaxwellReplicator.java:87)
at com.zendesk.maxwell.RunLoopProcess.runLoop(RunLoopProcess.java:31)
at com.zendesk.maxwell.Maxwell.run(Maxwell.java:89)
at com.zendesk.maxwell.Maxwell.main(Maxwell.java:95)
12:45:12,220 INFO SchemaPosition - Storing final position: BinlogPosition[binarylog.023492:6773]
from maxwell.
@xmlking, I opened https://github.com/zendesk/maxwell/pull/185/files the other day for view creation. @jpeyper has got himself a very odd config in which he's getting some row-based and some statement-based stuff.
Also, I'm doing what I've needed to do for awhile which is run maxwell against the mysql test suite and fix a bunch of the lingering parse problems.
from maxwell.
Thanks @osheroff . Appreciate your work and support.
from maxwell.
both issues fixed in v0.16.1
from maxwell.
Related Issues (20)
- Unable to start Maxwell container along with mysql HOT 1
- Schema capturing in maxwell HOT 1
- filtering pattern not work, the docker container panic HOT 8
- when db failover, and set Read_only=true, what exception maxwell will throw? HOT 1
- parse error on algorithm=NOCOPY
- Reduce memory overhead on startup (OOM) HOT 9
- Allow persistent variables in Javascript filters HOT 4
- User sessions
- Failed to deserialize data of EventHeaderV4 HOT 4
- NOT FOUND mysqlBaseListener class HOT 1
- Maxwell Sending final heartbeat: 1706848518690
- row_query_max_length - variable type error
- Request to fix CVEs found in Maxwell v1.41.0 HOT 1
- Need help using javascript filter
- maxwell uses utc to convert timestamp, but not converting datetime. How can we convert datetime by utc as well?
- maxwell 1.13.2 夜里突然无响应,binlog不能产生kafka消息了 HOT 1
- I use maxwell to synchronize MySQL data to Redis, but there is a delay of nearly 30 minutes. How can I improve Maxwell's performance HOT 3
- crash in alters
- parse error on WAIT=30
- Couldn't find chained schema HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from maxwell.