{"action":"opened","issue":{"url":"https://api.github.com/repos/rmcdonough/GELF-Daemon/issues/2","labels_url":"https://api.github.com/repos/rmcdonough/GELF-Daemon/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/rmcdonough/GELF-Daemon/issues/2/comments","events_url":"https://api.github.com/repos/rmcdonough/GELF-Daemon/issues/2/events","html_url":"https://github.com/rmcdonough/GELF-Daemon/issues/2","id":104877564,"number":2,"title":"mysql slowlog message is not sending as a single msg to graylog if its been logged with \\t inside","user":{"login":"vladzu","id":6085951,"avatar_url":"https://avatars.githubusercontent.com/u/6085951?v=3","gravatar_id":"","url":"https://api.github.com/users/vladzu","html_url":"https://github.com/vladzu","followers_url":"https://api.github.com/users/vladzu/followers","following_url":"https://api.github.com/users/vladzu/following{/other_user}","gists_url":"https://api.github.com/users/vladzu/gists{/gist_id}","starred_url":"https://api.github.com/users/vladzu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vladzu/subscriptions","organizations_url":"https://api.github.com/users/vladzu/orgs","repos_url":"https://api.github.com/users/vladzu/repos","events_url":"https://api.github.com/users/vladzu/events{/privacy}","received_events_url":"https://api.github.com/users/vladzu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-04T12:02:20Z","updated_at":"2015-09-04T12:02:20Z","closed_at":null,"body":"The slowlog that came into a slowlog with tab instead of newline, for example\r\n# User@Host: user[user] @  []  Id: 23861753\r\n# Schema: db  Last_errno: 0  Killed: 0\r\n# Query_time: 2.326951  Lock_time: 0.000422  Rows_sent: 0  Rows_examined: 1321598  Rows_affected: 1\r\n# Bytes_sent: 52\r\nuse db;\r\nSET timestamp=1441366884;\r\nUPDATE people SET\r\n                                email_messages_count = IFNULL(\r\n                                (\r\n                                        SELECT COUNT(ep.id)\r\n                                        FROM email_parties AS ep\r\n                                                JOIN email_parties_in_messages AS em ON em.party_id = ep.id\r\n                                                JOIN email_messages AS ems ON ems.id = em.message_id AND ems.active_flag = 1\r\n                                        WHERE ep.person_id = people.id\r\n                                        GROUP BY ep.person_id\r\n                                ), 0),\r\n                                files_count = IFNULL(\r\n                                        (SELECT COUNT(id) FROM files WHERE files.person_id = people.id AND files.active_flag = 1)\r\n                                        +\r\n                                        (SELECT SUM(email_messages.attachment_count)\r\n                                                FROM email_messages\r\n                                                JOIN email_parties_in_messages AS epim ON epim.message_id=email_messages.id\r\n                                                JOIN email_parties AS ep ON ep.id=epim.party_id\r\n                                                WHERE email_messages.active_flag = 1 AND ep.person_id=people.id), 0)\r\n                        WHERE id=357;\r\nlooks in gelfDaemon.log:\r\n{\"version\": \"1.0\", \"facility\": \"mysql/slow\", \"level\": \"4\", \"host\": \"db1291l\", \"full_message\": \"use company_131678; SET timestamp=1441366884; UPDATE people SET \\t\\t\\t\\temail_messages_count = IFNULL( \\t\\t\\t\\t( \\t\\t\\t\\t\\tSELECT COUNT(ep.id) \\t\\t\\t\\t\\tFROM email_parties AS ep \\t\\t\\t\\t\\t\\tJOIN email_parties_in_messages AS em ON em.party_id = ep.id \\t\\t\\t\\t\\t\\tJOIN email_messages AS ems ON ems.id = em.message_id AND ems.active_flag = 1 \\t\\t\\t\\t\\tWHERE ep.person_id = people.id \\t\\t\\t\\t\\tGROUP BY ep.person_id \\t\\t\\t\\t), 0), \\t\\t\\t\\tfiles_count = IFNULL( \\t\\t\\t\\t\\t(SELECT COUNT(id) FROM files WHERE files.person_id = people.id AND files.active_flag = 1) \\t\\t\\t\\t\\t+ \\t\\t\\t\\t\\t(SELECT SUM(email_messages.attachment_count) \\t\\t\\t\\t\\t\\tFROM email_messages \\t\\t\\t\\t\\t\\tJOIN email_parties_in_messages AS epim ON epim.message_id=email_messages.id \\t\\t\\t\\t\\t\\tJOIN email_parties AS ep ON ep.id=epim.party_id \\t\\t\\t\\t\\t\\tWHERE email_messages.active_flag = 1 AND ep.person_id=people.id), 0) \\t\\t\\tWHERE id=357;\", \"file\": \"/var/log/mysql/mysql-slow.log\", \"short_message\": \"use company_131678; SET timestamp=1441366884; UPDATE people \"}\r\nis sending to a graylog like a bunch of msgs \r\n\r\ngelfDaemon conf:\r\n[mysql_slow]\r\npath = /var/log/mysql/mysql-slow.log\r\nlevel = 4\r\nregex = .*\r\nfacility = mysql/slow\r\nshort_message_regex = ^.{1,60}\r\nconcatenate_on = ^\\#.*"}}