[PageOneX] [dev] Urgent: PageOneX is down

Rafael Porres Molina rporres at gmail.com
Wed Jan 8 17:55:01 EST 2014


Hi,

I'd be happy to join if I can be of any help.

Pablo: We could arrange a previous hangout between you and me so that you
can give me some context to be more helpful.

Regards,

Rafa


2014/1/8 Edward Platt <elplatt at media.mit.edu>

> Works for me, talk then!
>
>
> On Wed, Jan 8, 2014 at 5:21 PM, pablo rey <pablo at basurama.org> wrote:
>
>> 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>
>>>
>>
>>
>
>
> --
> 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/20140108/8d735c8d/attachment-0001.htm


More information about the Pageonexdev mailing list