[PageOneX] [dev] Urgent: PageOneX is down

Wed Dec 25 20:31:32 EST 2013

Thanks for the update Pablo.  I don't see anything telling in the logs
you've sent.  The mysql problems may be unrelated to PageOneX as the server
is shared.  It's also possible that the performance problems we were seeing
before are somehow causing this.  I've been working out how to best fix
those, but there doesn't seem to be a quick fix.  It's on our radar!

-Ed

On Wed, Dec 25, 2013 at 4:06 PM, pablo rey <pablo at basurama.org> wrote:

> I had to restart the mysql again today!
>
> This time it crashed after:
> Started GET "/about" for 91.206.178.40 at 2013-12-24 23:20:01 +0000
> Processing by HomeController#about as HTML
>   Rendered home/about.html.erb within layouts/application (39.1ms)
> Completed 200 OK in 340ms (Views: 268.5ms | ActiveRecord: 0.0ms)
> Started GET "/numeroteca/corrupcion-espana-diciembre-2013/" for
> 91.206.178.40 at 2013-12-24 23:20:02 +0000
> Processing by CodingController#display as HTML
>   Parameters: {"username"=>"numeroteca",
> "thread_name"=>"corrupcion-espana-diciembre-2013"}
>   Rendered coding/_coding_footer.html.erb (0.3ms)
>   Rendered coding/display.html.erb within layouts/application (5064.0ms)
> Completed 200 OK in 5614ms (Views: 2025.2ms | ActiveRecord: 3365.2ms)
> Started GET "/users/sign_up" for 91.206.178.40 at 2013-12-24 23:20:09 +0000
> Processing by Devise::RegistrationsController#new as HTML
>   Rendered devise/_links.erb (9758.9ms)
>   Rendered devise/registrations/new.html.erb within layouts/application
> (18132.6ms)
> Completed 200 OK in 18877ms (Views: 18569.0ms | ActiveRecord: 0.0ms)
> Started GET "/users/sign_in" for 91.206.178.40 at 2013-12-24 23:20:29 +0000
> Processing by Devise::SessionsController#new as HTML
>   Rendered devise/_links.erb (1.2ms)
>   Rendered devise/sessions/new.html.erb within layouts/application
> (102.2ms)
> Completed 200 OK in 477ms (Views: 272.0ms | ActiveRecord: 0.0ms)
>
> Connecting to database specified by database.yml
> Connecting to database specified by database.yml
>
>
>
> On Sun, Dec 22, 2013 at 11:57 PM, pablo rey <pablo at basurama.org> wrote:
>
>> I had to restart mysql again minutes ago.
>>
>> This is the rails log before crashing:
>> Started GET "/numeroteca/local-national-world-news/coding" for
>> 5.10.83.101 at 2013-12-22 19:11:02 +0000
>> Processing by CodingController#process_images as */*
>>   Parameters: {"username"=>"numeroteca",
>> "thread_name"=>"local-national-world-news"}
>>   Rendered coding/_coding_footer.html.erb (0.1ms)
>>   Rendered coding/process_images.html.erb within layouts/application
>> (3323.2ms)
>> Completed 200 OK in 3331ms (Views: 1658.8ms | ActiveRecord: 1668.8ms)
>> Started GET "/" for 67.23.226.7 at 2013-12-22 19:11:10 +0000
>> Processing by HomeController#index as HTML
>>   Rendered home/index.html.erb within layouts/application (184.1ms)
>> Completed 200 OK in 284ms (Views: 163.3ms | ActiveRecord: 120.0ms)
>> Started GET "/assets/application.css" for 67.23.226.7 at 2013-12-22
>> 19:11:16 +0000
>> Served asset /application.css - 304 Not Modified (522ms)
>> Started GET "/Donna/juicio-marita-veron-cronica/export.ods" for
>> 5.10.83.105 at 2013-12-22 19:11:17 +0000
>> Processing by ThreadsController#export as ODS
>>   Parameters: {"username"=>"Donna",
>> "thread_name"=>"juicio-marita-veron-cronica"}
>> Sent file /tmp/export20131222-12134-1228f0a.ods (0.1ms)
>> Completed 200 OK in 167ms (ActiveRecord: 95.3ms)
>> Started GET "/davidmbusto/dragado-en-bahia-blanca/export.json" for
>> 180.76.5.75 at 2013-12-22 19:11:17 +0000
>> Processing by ThreadsController#export as JSON
>>   Parameters: {"username"=>"davidmbusto", "thread_name"=>"davidmbusto"}
>> Completed 200 OK in 93ms (Views: 0.2ms | ActiveRecord: 4.6ms)
>> Started GET "/threads/" for 67.23.226.7 at 2013-12-22 19:11:19 +0000
>> Processing by ThreadsController#index as HTML
>> Connecting to database specified by database.yml
>> Connecting to database specified by database.yml
>>
>> After restarting pagination in the thread list  is not working again<https://github.com/numeroteca/pageonex/issues/182>.
>> I mention it as pageonex crashed after a GET "/threads/" request. What
>> could be the cause for making mysql die? Listing the threads doesn't seem
>> very problematic.
>>
>>
>> Besides, I was trying to get a sense of the usage of PageOneX web site
>> using the Piwik statistics. According to Piwik only 4 visits to the site
>> today. According to the logs many many more. I assume many people have the
>> stats blocked but the difference isway  too high... guesses?
>>
>> Happy holidays!
>> p
>>
>>
>>
>>
>>
>> On Sun, Dec 15, 2013 at 1:53 AM, Edward Platt <elplatt at media.mit.edu>wrote:
>>
>>> Should be fixed now.  Mysql wasn't running, not sure why and there are
>>> no relevant log entries.  If you ever feel the need to restart mysql,
>>> please go ahead.
>>>
>>> -Ed
>>>
>>>
>>> On Sat, Dec 14, 2013 at 3:52 PM, pablo rey <pablo at basurama.org> wrote:
>>>
>>>> Should I just restart the mysql server?
>>>>   sudo service mysql restart
>>>>
>>>>
>>>> On Sat, Dec 14, 2013 at 9:09 PM, pablo rey <pablo at basurama.org> wrote:
>>>>
>>>>> Rahul and Ed!The home page returns a passenger message: Ruby (Rack)
>>>>> application could not be started
>>>>>
>>>>> Error message: Can't connect to local MySQL server through socket
>>>>> '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)Exception class:
>>>>> PhusionPassenger::UnknownError
>>>>>
>>>>>
>>>>> Which is the same message I was getting and reported at
>>>>> https://github.com/numeroteca/pageonex/issues/179#issuecomment-30275654(but didn't make the app crashed).
>>>>>
>>>>> It looks like it's been down since yesterday.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> p
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Pageonexdev mailing list
>>>> Pageonexdev at mit.edu
>>>> http://mailman.mit.edu/mailman/listinfo/pageonexdev
>>>>
>>>>
>>>
>>>
>>> --
>>> Edward L. Platt
>>> Civic Technology Programmer
>>> MIT Center for Civic Media
>>> E15-348
>>> http://civic.mit.edu
>>> http://elplatt.com
>>> @elplatt <http://twitter.com/elplatt>
>>>
>>> _______________________________________________
>>> Pageonexdev mailing list
>>> Pageonexdev at mit.edu
>>> http://mailman.mit.edu/mailman/listinfo/pageonexdev
>>>
>>>
>>
>

-- 
Edward L. Platt
Civic Technology Programmer
MIT Center for Civic Media
E15-348
http://civic.mit.edu
http://elplatt.com
@elplatt <http://twitter.com/elplatt>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/pageonexdev/attachments/20131225/c9db0812/attachment-0001.htm