Closed Bug 1052207 Opened 11 years ago Closed 11 years ago

MariaDB Slow Query Log Decoder not correctly parsing all messages

Categories

(Cloud Services :: Operations: Metrics/Monitoring, task)

Product:
Cloud Services
Component:
Operations: Metrics/Monitoring
Platform:
x86
All
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: bobm, Assigned: whd)

Details

The MariaDB slow query log decoder is not correctly parsing the slow query logs on Sync 1.5 servers, in production and stage, in all cases. Example error from Stage (Note table sharding is on, hence bso3): 2014/08/11 22:36:47 Decoder 'Sync-1_5-SlowQuery-MySqlSlowQueryDecoder' error: Failed parsing: # User@Host: user[user] @ [127.0.0.1] # Thread_id: 3408 Schema: weave0 QC_hit: No # Query_time: 1.182455 Lock_time: 0.000873 Rows_sent: 0 Rows_examined: 0 SET timestamp=1407796606; /* [queryName=UPSERT_bso] */ INSERT INTO bso3 (payload_size,userid,modified,collection,id,payload) VALUES (416,337303,1407796605050,3, ...
Fixed in https://github.com/mozilla-services/lua_sandbox/pull/45 and https://github.com/mozilla-services/puppet-config/pull/807.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.