I also run topbeat, packbeat, transfer to logstash, accept the data on the ES side, reported the following error
[2016-03-01 02:33:49,810][DEBUG][action.bulk ] [node-1] [logstash-2016.02.29][4] failed to execute bulk item (index) index {[logstash-2016.02.29][mysql][AVMuTs3DYEsGBQRKvfBP], source[{"@timestamp":"2016-02-29T18:33:48.342Z","beat":{"hostname":"server1","name":"server1"},"bytes_in":51,"bytes_out":51,"client_ip":"192.168.51.105","client_port":57663,"client_proc":"","client_server":"","count":1,"direction":"in","ip":"192.168.4.12","method":"INSERT","mysql":{"affected_rows":0,"error_code":1054,"error_message":"42S22: Unknown column 'aaaaa' in 'field list'","insert_id":0,"iserror":true,"num_fields":0,"num_rows":0},"path":"","port":3306,"proc":"","query":"insert into test(id,title) values(aaaaa,'987')","responsetime":0,"server":"","status":"Error","type":"mysql","@version":"1","host":"server1","tags":["beats_input_raw_event"]}]}
java.lang.IllegalArgumentException: Field [proc] is defined as a field in mapping [mysql] but this name is already used for an object in other types
at org.elasticsearch.index.mapper.MapperService.checkMappersCompatibility(MapperService.java:398)
at org.elasticsearch.index.mapper.MapperService.checkMappersCompatibility(MapperService.java:411)
Topbeat inside the proc (proc.ppid etc) is a digital type, but the MySQL proc is a string type?
Thanks.