[PageOneX] [dev] Urgent: PageOneX is down
pablo rey
pablo at basurama.org
Wed Jan 8 17:21:16 EST 2014
Given the 6 hours of difference Jan 23rd 4.30pm EST (10.30pm CET, Spain) is
good for me.
On Wed, Jan 8, 2014 at 11:17 PM, Edward Platt <elplatt at media.mit.edu> wrote:
> Woks for me, my day should be open so far. What time's good for you?
>
>
> On Wed, Jan 8, 2014 at 5:13 PM, pablo rey <pablo at basurama.org> wrote:
>
>> Let's set another date, then. Thursday Jan 23rd?
>>
>>
>> On Wed, Jan 8, 2014 at 9:05 PM, Edward Platt <elplatt at media.mit.edu>wrote:
>>
>>> Touching base sounds good. After Jan 22 would be best.
>>>
>>> -Ed
>>>
>>>
>>> On Wed, Jan 8, 2014 at 2:58 PM, pablo rey <pablo at basurama.org> wrote:
>>>
>>>> Thanks Ed,
>>>> I had to restart mysql again minutes ago :-/
>>>> The problem with this issue and specially with #179<https://github.com/numeroteca/pageonex/issues/179>is that early adopters do not come back after a first failed attempt to
>>>> create a thread.
>>>>
>>>> I would suggest to set up a google hangout during IAP (=January for non
>>>> MIT folks!) to brainstorm together on this.
>>>> What do you think? anyone interested?
>>>> Which other sites are hosted in that server?
>>>>
>>>> How about next Monday Jan 13th at 4.30pm EST (10.30pm CET, Spain)?
>>>>
>>>> Best,
>>>> p
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Dec 26, 2013 at 2:31 AM, Edward Platt <elplatt at media.mit.edu>wrote:
>>>>
>>>>> 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>
>>>>>
>>>>> _______________________________________________
>>>>> 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>
>>>
>>
>>
>
>
> --
> 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/20140108/c24c4a32/attachment.htm
More information about the Pageonexdev
mailing list