maxwell down because of the creating table operation of mysql database

[yester354]

Hi:
I created a table in mysql. then maxwell down .i don't know how to make it works normal.and the error log as below:
10:37:55,677 DEBUG SchemaChange - SQL_PARSE <- "CREATE TABLE emon.chk ( group_name VARCHAR(8) NOT NULL, group_key NUMERIC(19) NOT NULL, seqno NUMERIC(10), rba NUMERIC(19) NOT NULL, audit_ts VARCHAR(29), create_ts DATETIME NOT NULL, last_update_ts DATETIME NOT NULL, current_dir VARCHAR(255) NOT NULL, PRIMARY KEY (group_name, group_key))"
line 1:78 mismatched input ')' expecting ','
line 1:80 mismatched input 'NOT' expecting {, AUTO_INCREMENT, AVG_ROW_LENGTH, CHARACTER, CHARSET, CHECKSUM, COLLATE, COMMENT, CONNECTION, DATA, DEFAULT, DELAY_KEY_WRITE, ENGINE, INDEX, INSERT_METHOD, KEY_BLOCK_SIZE, MAX_ROWS, MIN_ROWS, PACK_KEYS, PASSWORD, ROW_FORMAT, TABLESPACE, UNION}
java.lang.IllegalArgumentException: unsupported column type numeric
at com.zendesk.maxwell.schema.columndef.ColumnDef.build(ColumnDef.java:80)
at com.zendesk.maxwell.schema.ddl.MysqlParserListener.exitColumn_definition(MysqlParserListener.java:273)
at com.zendesk.maxwell.schema.ddl.mysqlParser$Column_definitionContext.exitRule(mysqlParser.java:4370)
at org.antlr.v4.runtime.tree.ParseTreeWalker.exitRule(ParseTreeWalker.java:71)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:54)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)
at org.antlr.v4.runtime.tree.ParseTreeWalker.walk(ParseTreeWalker.java:52)
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.MaxwellParser.processQueryEvent(MaxwellParser.java:206)
at com.zendesk.maxwell.MaxwellParser.getEvent(MaxwellParser.java:192)
at com.zendesk.maxwell.MaxwellParser.getEvent(MaxwellParser.java:198)
at com.zendesk.maxwell.MaxwellParser.run(MaxwellParser.java:98)
at com.zendesk.maxwell.Maxwell.run(Maxwell.java:69)
at com.zendesk.maxwell.Maxwell.main(Maxwell.java:75)

[osheroff]

Hi @yester354, I'll take a look at this today.

[osheroff]

this is fixed in version 0.10.0.