Closed xmlking closed 8 years ago
what's the schema for the table you're trying to bootstrap? and what version of mysql?
The second error makes a certain degree of sense, maybe something up with different versions of mysql server / java client.
The first error is completely baffling. There should really be no way that that line triggers a lock-wait timeout, as it's just:
List<String> cols = query.getFirst("SELECT @@global.binlog_checksum");
Environment
innodb_version 5.6.24-72.2
version 5.6.24-72.2-25.11-log
version_comment Percona XtraDB Cluster binary (GPL) 5.6.24-25.11, Revision, wsrep_25.11
version_compile_machine x86_64
version_compile_os Linux
Maxwell's config.properties
log_level=INFO
user=maxwell
password=xxxxxxxxxx
host=mysql_host
port=3306
producer=kafka
kafka.acks=1
kafka.bootstrap.servers=kafka_host1:9092,kafka_host2:9092,kafka_host3:9092
kafka_topic=maxwell
include_dbs=mydb
bootstrapper=async
Table 1 schema: (first error) has 80k records
CREATE TABLE zipcode
(
zip CHAR(5) DEFAULT '' NOT NULL,
city VARCHAR(50) DEFAULT '' NOT NULL,
countyFIPS CHAR(5) DEFAULT '' NOT NULL,
state CHAR(2),
latitudeDeg DECIMAL(20,14),
longitudeDeg DECIMAL(20,14),
metroServiceArea CHAR(4),
areaCode VARCHAR(16),
stateName VARCHAR(64),
zipType CHAR(1),
timeZone VARCHAR(16),
utc DECIMAL(3,1),
dst CHAR(1),
stateFIPS CHAR(2),
countyName VARCHAR(64),
cityType CHAR(1),
changeDateTime TIMESTAMP(3) DEFAULT 'CURRENT_TIMESTAMP(3)' NOT NULL,
changeUserID VARCHAR(20),
createDateTime TIMESTAMP(3) DEFAULT '0000-00-00 00:00:00.000' NOT NULL,
createUserID VARCHAR(20),
updateVersion INT(10),
CONSTRAINT `PRIMARY` PRIMARY KEY (zip, city, countyFIPS)
);
CREATE INDEX zipCodeCity ON zipcode (city);
CREATE INDEX zipCodeZip ON zipcode (zip);
CREATE INDEX zipCode_CD ON zipcode (changeDateTime);
CREATE INDEX zipcode_idx1 ON zipcode (city, state, zip);
CREATE INDEX zipCounty ON zipcode (countyFIPS);
CREATE INDEX zipMSA ON zipcode (metroServiceArea);
CREATE INDEX zipState ON zipcode (state);
Table 2 schema has 20 ecords
CREATE TABLE user_tab
(
userGroupID VARCHAR(100) PRIMARY KEY NOT NULL,
userGroupDesc VARCHAR(200),
mainMenu VARCHAR(60),
changeDateTime TIMESTAMP(3) DEFAULT 'CURRENT_TIMESTAMP(3)' NOT NULL,
changeUserID VARCHAR(20),
createDateTime TIMESTAMP(3) DEFAULT '0000-00-00 00:00:00.000' NOT NULL,
createUserID VARCHAR(20),
updateVersion INT(10)
);
CREATE INDEX user_tab_CD ON user_tab (changeDateTime);
Anybody facing crash issues with bootstrap with Maxwell v1.1.1? it used to work fine in previous releases. CDC works fine but I cannot bootstrap tables that has timestamp :(
java.sql.SQLException: Cannot convert value '2016-05-26 08:06:40.000' from column 22 to TIMESTAMP.
@xmlking Ok, I can repro your error if I install that precise binary. will see about a fix.
https://github.com/zendesk/maxwell/pull/370 seems to fix it for me locally
released in v1.1.2
When try to bootstrap a table by inserting record into
maxwell.bootstrap
table ,Maxwell crashed with following errors: We are using Maxwell 1.1.1 wonder if it a bug or specific to my environment? Any help is appreciated -SumoOther bootstrap error:
Other bootstrap error: