Analytics: Error when attempting COUNT and GROUP BY on webrequest_mobile
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	Ironholds
	Jan 29 2014, 12:10 AM

Description

Error log

Something to do with the fact that it's a JSON table? Full log attached.

Version: unspecified
Severity: normal

Attached:

file_60549.txt9 KBDownload

Details

Reference: bz60549

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:52 AM

• bzimport added a project: Analytics-General-or-Unknown.

• bzimport set Reference to bz60549.

• bzimport added a subscriber: Unknown Object (MLST).

Ironholds created this task.Jan 29 2014, 12:10 AM

bingle-admin wrote:

Prioritization and scheduling of this bug is tracked on Mingle card https://wikimedia.mingle.thoughtworks.com/projects/analytics/cards/cards/1417

Taking a brief look at the error log, it seems the culprit is again an
unquoted nan as value (see time_firstbyte):

{"hostname":"cp1046.eqiad.wmnet","sequence":952664769,"dt":"2014-01-04T07:02:58","time_firstbyte":nan,[...]

which causes the root exception

Caused by: org.codehaus.jackson.JsonParseException: Unrecognized token 'na': was expecting 'null', 'true' or 'false'

@Ottomata: As that log line is from 2014-01-04 (which is before the
nan-fix IIRC), should we correct this data by hand, or just drop the
data up to when the fix went in.

Analytics: Error when attempting COUNT and GROUP BY on webrequest_mobileClosed, DeclinedPublicActions

Description

Details

Event Timeline

Analytics: Error when attempting COUNT and GROUP BY on webrequest_mobile
Closed, DeclinedPublic
Actions