Correlation event JSON appears messed-up

hburrows commented 12 years ago

Connect to staging database (mi_staging) and execute the following select: select json from service_event where service_id = 1 and json is not null limit 1;

The result does not look at all correct. I haven't attempted to look for others but I would guess there's a pattern.

jsancio commented 12 years ago

Yeah. Looks weird. That specific event has an id of 0KDADmoucmpRFKtUlBaVMDGcfcoSpHTewcnzgBY99ls. There seem to be a lot events that seem to be correlating:

select count(_) from service_event where correlationid = '0KDADmoucmpRFKtUlBaVMDGcfcoSpHTewcnzgBY99ls'; +----------+ | count() | +----------+ | 1369 | +----------+ 1 row in set (0.11 sec)

jsancio commented 12 years ago

Looking at the JSON for some of those events it doesn't look like they should be correlating:

json: {"comments":{"count":0},"created_time":"2012-07-03T22:13:33+0000","from":{"id":"730063841","name":"Philip Goffin"},"id":"730063841_10150938000128842","link":"http://www.facebook.com/robert.g.foley?ref=nf_fr","picture":"http://profile.ak.fbcdn.net/hprofile-ak-ash2/369712_676221587_1984754593_q.jpg","story":"Philip Goffin is now friends with Robert Foley and 3 other people.","story_tags":{"0":[{"id":730063841,"length":13,"name":"Philip Goffin","offset":0,"type":"user"}],"34":[{"id":676221587,"length":12,"name":"Robert Foley","offset":34,"type":"user"}],"51":[{"id":100002175000990,"length":14,"name":"Ashley Foley","offset":51,"type":"user"},{"id":678978928,"length":14,"name":"Ken Lenga","offset":51,"type":"user"},{"id":571706538,"length":14,"name":"Aliza Patell","offset":51,"type":"user"}]},"type":"link","updated_time":"2012-07-03T22:13:33+0000"} *** 2. row *** json: {"comments":{"count":0},"created_time":"2012-03-13T13:02:21+0000","from":{"id":"538781807","name":"Tina Galve"},"id":"538781807_10150739537731808","link":"http://www.facebook.com/jacque216?ref=nf_fr","picture":"http://profile.ak.fbcdn.net/hprofile-ak-snc4/157858_529811639_96447643_q.jpg","story":"Tina Galve is now friends with Jacq Wong and 4 other people.","story_tags":{"0":[{"id":538781807,"length":10,"name":"Tina Galve","offset":0,"type":"user"}],"31":[{"id":529811639,"length":9,"name":"Jacq Wong","offset":31,"type":"user"}],"45":[{"id":619460473,"length":14,"name":"Gladys Gatchalian","offset":45,"type":"user"},{"id":537776521,"length":14,"name":"Kimby Robles","offset":45,"type":"user"},{"id":1388306053,"length":14,"name":"Lean Karlo Corpuz","offset":45,"type":"user"},{"id":538389047,"length":14,"name":"Carmi Charise Lim","offset":45,"type":"user"}]},"type":"link","updated_time":"2012-03-13T13:02:21+0000"} *** 3. row *** json: {"comments":{"count":0},"created_time":"2012-05-04T17:34:14+0000","from":{"id":"224258","name":"Loree Draude Hirschman"},"id":"224258_10100252503647463","link":"http://www.facebook.com/vidhyanarayanan?ref=nf_fr","picture":"http://profile.ak.fbcdn.net/hprofile-ak-snc4/260626_560342994_186997424_q.jpg","story":"Loree Draude Hirschman is now friends with Srividhya Narayanan and 3 other people.","story_tags":{"0":[{"id":224258,"length":22,"name":"Loree Draude Hirschman","offset":0,"type":"user"}],"43":[{"id":560342994,"length":19,"name":"Srividhya Narayanan","offset":43,"type":"user"}],"67":[{"id":12001669,"length":14,"name":"Nick Ralston","offset":67,"type":"user"},{"id":100001065023708,"length":14,"name":"Ben Budde","offset":67,"type":"user"},{"id":500016821,"length":14,"name":"Hiten Shah","offset":67,"type":"user"}]},"type":"link","updated_time":"2012-05-04T17:34:14+0000"}

Thisisdotme / thisis.me

Correlation event JSON appears messed-up #102