[PageOneX] [dev] Urgent: PageOneX is down

[pablo rey]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/pageonexdev/attachments/20131222/6701d6c8/attachment.htm