gistfile1.txt

I, [2013-10-24T15:51:39.548194 #20420]  INFO -- : (0.190697s) SELECT * FROM `clients` WHERE (`id` = 493) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:51:39.649928 #20420]  INFO -- : (0.100140s) SELECT * FROM `seeds` WHERE (`id` = 6454) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:51:39.752148 #20420]  INFO -- : (0.100764s) SELECT * FROM `fetches` WHERE (`id` = 105767189) ORDER BY `fetched_at` LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:51:39.855099 #20420]  INFO -- : (0.100289s) DESCRIBE `mentions_client_493`
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:34:in `block in make_class' */
I, [2013-10-24T15:51:39.957995 #20420]  INFO -- : (0.093005s) SELECT * FROM `mentions_client_493` WHERE (`url` = 'http://facebook.com/640120142/posts/10151705129185143?comment_id=27046168_') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:20:in `block (2 levels) in <class:API_v2>' */
I, [2013-10-24T15:51:40.059535 #20420]  INFO -- : (0.089560s) SELECT * FROM `users` WHERE ((`name` = 'Manuel Alonso') AND (`url` = 'http://www.facebook.com/profile.php?id=640120142_')) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:51:40.161468 #20420]  INFO -- : (0.099507s) BEGIN
I, [2013-10-24T15:51:40.264403 #20420]  INFO -- : (0.101357s) INSERT INTO `users` (`name`, `url`, `guid`) VALUES ('Manuel Alonso', 'http://www.facebook.com/profile.php?id=640120142_', 'http://www.facebook.com/profile.php?id=640120142_')
I, [2013-10-24T15:51:40.366629 #20420]  INFO -- : (0.100411s) SELECT * FROM `users` WHERE (`id` = 22065139) LIMIT 1
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:40.468720 #20420]  INFO -- : (0.101386s) COMMIT
I, [2013-10-24T15:51:40.571420 #20420]  INFO -- : (0.101307s) SELECT * FROM `journals` WHERE ((`name` = 'Manuel Alonso') AND (`url` = 'http://www.facebook.com/profile.php?id=640120142_') AND (`kind_class` = 'user')) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:51:40.673516 #20420]  INFO -- : (0.100324s) BEGIN
I, [2013-10-24T15:51:40.776026 #20420]  INFO -- : (0.101438s) INSERT INTO `journals` (`name`, `url`, `kind_class`, `guid`) VALUES ('Manuel Alonso', 'http://www.facebook.com/profile.php?id=640120142_', 'user', 'http://www.facebook.com/profile.php?id=640120142_')
I, [2013-10-24T15:51:40.878597 #20420]  INFO -- : (0.101115s) SELECT * FROM `journals` WHERE (`id` = 14556034) LIMIT 1
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:40.980817 #20420]  INFO -- : (0.101389s) COMMIT
I, [2013-10-24T15:51:41.083332 #20420]  INFO -- : (0.099412s) SELECT * FROM `platforms` WHERE (`url` = 'http://facebook.com') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/platform.rb:20:in `by_url' */
I, [2013-10-24T15:51:41.185631 #20420]  INFO -- : (0.098487s) SELECT count(*) AS `count` FROM `mentions_client_493` WHERE (`url` = 'http://facebook.com/640120142/posts/10151705129185143?comment_id=27046168_') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:79:in `validate' */
I, [2013-10-24T15:51:41.274098 #20420]  INFO -- : (0.087737s) BEGIN
I, [2013-10-24T15:51:41.733858 #20420]  INFO -- : (0.136517s) INSERT INTO `mentions_client_493` (`kind_class`, `url`, `created_at`, `author_id`, `journal_id`, `platform_id`, `author_guid`, `author_name`, `author_readers_count`, `author_url`, `platform_guid`, `platform_name`, `platform_url`, `journal_kind_class`, `journal_guid`, `journal_name`, `journal_url`, `journal_is_client_journal`, `mongodb_fk`, `lingua_language`, `is_spam`) VALUES ('post', 'http://facebook.com/640120142/posts/10151705129185143?comment_id=27046168_', '2013-10-24 03:06:52', 22065139, 14556034, 16, 'http://www.facebook.com/profile.php?id=640120142_', 'Manuel Alonso', NULL, 'http://www.facebook.com/profile.php?id=640120142_', 'facebook.com', 'Facebook', 'http://facebook.com', 'user', 'http://www.facebook.com/profile.php?id=640120142_', 'Manuel Alonso', 'http://www.facebook.com/profile.php?id=640120142_', 0, '526917ddd293c94fc4000001', 'ru', 0)
I, [2013-10-24T15:51:41.836177 #20420]  INFO -- : (0.100579s) SELECT * FROM `mentions_client_493` WHERE (`id` = 2382187) LIMIT 1
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:41.936858 #20420]  INFO -- : (0.100126s) COMMIT
I, [2013-10-24T15:51:42.030140 #20420]  INFO -- : (0.089790s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 6454))
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:31:in `block in <class:API_v2>' */
I, [2013-10-24T15:51:42.209637 #20420]  INFO -- : (0.177999s) SELECT * FROM `mention_details` WHERE ((`client_id` = 493) AND (`mention_id` = 2382187) AND (`label_id` = 4243)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:33:in `block (3 levels) in <class:API_v2>' */
I, [2013-10-24T15:51:42.313598 #20420]  INFO -- : (0.099784s) SELECT count(*) AS `count` FROM `mention_details` WHERE ((`client_id` = 493) AND (`mention_id` = 2382187) AND (`label_id` = 4243)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention_topic.rb:24:in `validate' */
I, [2013-10-24T15:51:42.414127 #20420]  INFO -- : (0.099737s) BEGIN
I, [2013-10-24T15:51:42.517301 #20420]  INFO -- : (0.101367s) INSERT INTO `mention_details` (`client_id`, `mention_id`, `label_id`, `fetch_id`, `seed_id`, `tonality`, `fetch_origin`, `stored_at`, `is_competitor`, `snippet`) VALUES (493, 2382187, 4243, 105767189, 6454, 0, 'facebook-corpus', '2013-10-24 12:51:42', 0, 'aaaaay dios man... si si me la se con lo de adidas y bla bla bla...')
I, [2013-10-24T15:51:42.619990 #20420]  INFO -- : (0.101317s) SELECT * FROM `mention_details` WHERE (`id` = 636033) LIMIT 1
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:42.721583 #20420]  INFO -- : (0.100731s) COMMIT
I, [2013-10-24T15:51:42.824409 #20420]  INFO -- : (0.101540s) SELECT * FROM `mention_details` WHERE (`id` = 636033) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:51:42.926620 #20420]  INFO -- : (0.100080s) SELECT * FROM `labels` WHERE `id` = 4243
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.029551 #20420]  INFO -- : (0.101057s) SELECT * FROM `seeds` WHERE `id` = 6454
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.131860 #20420]  INFO -- : (0.097233s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 6454))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.233760 #20420]  INFO -- : (0.100069s) SELECT * FROM `fetches` WHERE `id` = 105767189
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.235429 #20420]  INFO -- : bsp.topic.v2[testme.mention:topic.create]: {id: 636033, mention_id: 2382187, client_id: 493, stored_at: "2013-10-24T12:51:42Z", snippet: "aaaaay dios man... si si me la se con lo de adidas y bla bla bla...", lingua_tonality: nil, manual_tonality: nil, tonality: 0, is_competitor: false, is_processed: false, label: {id: 4243, label: "Adidas", is_competitor: false, is_default: false}, seed: {id: 6454, client_id: 493, name: "Adidas", keywords: ["Adidas", "adidas", "addidas", "adedas", "адидас", "аддидас", "адедас", "одидас"], context: [], stopwords: [], labels: [{id: 4243, label: "Adidas", is_competitor: false, is_default: false}], is_competitor: false}, fetch: {id: 105767189, url: "http://bspv2-app5.sterno.ru:5900/search.json?fetched_after=Thu%2C%2024%20Oct%202013%2005%3A55%3A02%20GMT&keywords=adidas&page=1&published_after=Sun%2C%2020%20Oct%202013%2020%3A00%3A00%20GMT&synonyms=adidas%2Caddidas%2Cadedas%2C%D0%B0%D0%B4%D0%B8%D0%B4%D0%B0%D1%81%2C%D0%B0%D0%B4%D0%B4%D0%B8%D0%B4%D0%B0%D1%81%2C%D0%B0%D0%B4%D0%B5%D0%B4%D0%B0%D1%81%2C%D0%BE%D0%B4%D0%B8%D0%B4%D0%B0%D1%81<...>", origin: "facebook-corpus", fetched_at: "2013-10-24T10:55:36Z"}}
I, [2013-10-24T15:51:43.337343 #20420]  INFO -- : (0.099536s) SELECT * FROM `mentions_client_493` WHERE (`id` = 2382187) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:39:in `block in <class:API_v2>' */
I, [2013-10-24T15:51:43.439788 #20420]  INFO -- : (0.101025s) SELECT * FROM `mentions_client_493` WHERE (`id` = 2382187) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:51:43.541062 #20420]  INFO -- : (0.098196s) SELECT * FROM `platforms` WHERE `id` = 16
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.643352 #20420]  INFO -- : (0.100749s) SELECT * FROM `users` WHERE `id` = 22065139
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.745915 #20420]  INFO -- : (0.100964s) SELECT * FROM `journals` WHERE `id` = 14556034
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.848965 #20420]  INFO -- : (0.100667s) SELECT * FROM `mention_details` WHERE ((`client_id` = 493) AND (`mention_details`.`mention_id` = 2382187))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:43.950694 #20420]  INFO -- : (0.099156s) SELECT * FROM `labels` WHERE `id` = 4243
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:44.058055 #20420]  INFO -- : (0.105277s) SELECT * FROM `seeds` WHERE `id` = 6454
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:44.155485 #20420]  INFO -- : (0.094012s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 6454))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:44.257724 #20420]  INFO -- : (0.100357s) SELECT * FROM `fetches` WHERE `id` = 105767189
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:51:44.259451 #20420]  INFO -- : bsp.topic.v2[testme.mention.create]: {id: 2382187, client_id: 493, kind_class: "post", url: "http://facebook.com/640120142/posts/10151705129185143?comment_id=27046168_", created_at: "2013-10-24T03:06:52Z", body: "aaaaay dios man... si si me la se con lo de adidas y bla bla bla...", lingua_language: "ru", is_spam: false, platform: {id: 16, url: "http://facebook.com", name: "Facebook"}, author: {id: 22065139, url: "http://www.facebook.com/profile.php?id=640120142_", name: "Manuel Alonso"}, journal: {id: 14556034, url: "http://www.facebook.com/profile.php?id=640120142_", name: "Manuel Alonso"}, topics: [{id: 636033, mention_id: 2382187, client_id: 493, stored_at: "2013-10-24T12:51:42Z", snippet: "aaaaay dios man... si si me la se con lo de adidas y bla bla bla...", lingua_tonality: nil, manual_tonality: nil, tonality: 0, is_competitor: false, is_processed: false, label: {id: 4243, label: "Adidas", is_competitor: false, is_default: false}, seed: {id: 6454, client_id: 493, name: "Adidas", keywords: ["Adidas", "adidas", "addidas", "adedas", "адидас", "аддидас", "адедас", "одидас"], context: [], stopwords: [], labels: [{id: 4243, label: "Adidas", is_competitor: false, is_default: false}], is_competitor: false}, fetch: {id: 105767189, url: "http://bspv2-app5.sterno.ru:5900/search.json?fetched_after=Thu%2C%2024%20Oct%202013%2005%3A55%3A02%20GMT&keywords=adidas&page=1&published_after=Sun%2C%2020%20Oct%202013%2020%3A00%3A00%20GMT&synonyms=adidas%2Caddidas%2Cadedas%2C%D0%B0%D0%B4%D0%B8%D0%B4%D0%B0%D1%81%2C%D0%B0%D0%B4%D0%B4%D0%B8%D0%B4%D0%B0%D1%81%2C%D0%B0%D0%B4%D0%B5%D0%B4%D0%B0%D1%81%2C%D0%BE%D0%B4%D0%B8%D0%B4%D0%B0%D1%81<...>", origin: "facebook-corpus", fetched_at: "2013-10-24T10:55:36Z"}}]}
I, [2013-10-24T15:51:44.363119 #20420]  INFO -- : (0.101405s) SELECT * FROM `clients` WHERE `id` = 493
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:44.566055 #20420]  INFO -- : (0.197678s) SELECT * FROM `mentions_client_493` WHERE ((`url` = 'http://facebook.com/640120142/posts/10151705129185143?comment_id=27046168_') AND (`seed_id` = 6454)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/compatibility/api_v2.rb:20:in `find_existing_mention' */
I, [2013-10-24T15:51:44.661579 #20420]  INFO -- : (0.093692s) SELECT * FROM `mentions_client_493` WHERE `id` = 2382187
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:44.751865 #20420]  INFO -- : (0.088324s) UPDATE `mentions_client_493` SET `seed_id` = 6454, `fetch_id` = 105767189, `lingua_excerpt` = '', `lingua_tonality` = 0, `manual_tonality` = NULL WHERE (`id` = 2382187) LIMIT 1
I, [2013-10-24T15:51:44.851221 #20420]  INFO -- : (0.097991s) SELECT * FROM `mentions_client_493` WHERE (`id` = 2382187) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:51:44.971419 #20420]  INFO -- : (0.118043s) SELECT * FROM `clients` WHERE `id` = 493
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/newrelic_rpm-3.6.7.152/lib/new_relic/agent/method_tracer.rb:259:in `trace_execution_scoped' */
I, [2013-10-24T15:51:45.076983 #20420]  INFO -- : (0.104084s) SELECT * FROM `seeds` WHERE `id` = 6454
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */