<div dir="ltr"><div><div><div>Thanks Ed,<br>I had to restart mysql again minutes ago :-/<br>The problem with this issue and specially with <a href="https://github.com/numeroteca/pageonex/issues/179">#179</a> is that early adopters do not come back after a first failed attempt to create a thread.<br>
<br></div>I would suggest to set up a google hangout during IAP (=January for non MIT folks!) to brainstorm together on this. <br>What do you think? anyone interested? <br>Which other sites are hosted in that server?<br><br>
</div>How about next Monday Jan 13th at 4.30pm EST (10.30pm CET, Spain)? <br><br></div>Best,<br>p<br><div><div><br><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Dec 26, 2013 at 2:31 AM, Edward Platt <span dir="ltr"><<a href="mailto:elplatt@media.mit.edu" target="_blank">elplatt@media.mit.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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!<div>
<br></div><div>-Ed</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Dec 25, 2013 at 4:06 PM, pablo rey <span dir="ltr"><<a href="mailto:pablo@basurama.org" target="_blank">pablo@basurama.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I had to restart the mysql again today!<br><br></div>This time it crashed after:<br><div style="margin-left:40px">
Started GET "/about" for 91.206.178.40 at 2013-12-24 23:20:01 +0000<br>Processing by HomeController#about as HTML<br>
Rendered home/about.html.erb within layouts/application (39.1ms)<br>Completed 200 OK in 340ms (Views: 268.5ms | ActiveRecord: 0.0ms)<br>Started GET "/numeroteca/corrupcion-espana-diciembre-2013/" for 91.206.178.40 at 2013-12-24 23:20:02 +0000<br>
Processing by CodingController#display as HTML<br> Parameters: {"username"=>"numeroteca", "thread_name"=>"corrupcion-espana-diciembre-2013"}<br> Rendered coding/_coding_footer.html.erb (0.3ms)<br>
Rendered coding/display.html.erb within layouts/application (5064.0ms)<br>Completed 200 OK in 5614ms (Views: 2025.2ms | ActiveRecord: 3365.2ms)<br>Started GET "/users/sign_up" for 91.206.178.40 at 2013-12-24 23:20:09 +0000<br>
Processing by Devise::RegistrationsController#new as HTML<br> Rendered devise/_links.erb (9758.9ms)<br> Rendered devise/registrations/new.html.erb within layouts/application (18132.6ms)<br>Completed 200 OK in 18877ms (Views: 18569.0ms | ActiveRecord: 0.0ms)<br>
Started GET "/users/sign_in" for 91.206.178.40 at 2013-12-24 23:20:29 +0000<br>Processing by Devise::SessionsController#new as HTML<br> Rendered devise/_links.erb (1.2ms)<br> Rendered devise/sessions/new.html.erb within layouts/application (102.2ms)<br>
Completed 200 OK in 477ms (Views: 272.0ms | ActiveRecord: 0.0ms)<div><br>Connecting to database specified by database.yml<br>Connecting to database specified by database.yml<br></div></div><br></div><div>
<div><div class="gmail_extra"><br><br>
<div class="gmail_quote">On Sun, Dec 22, 2013 at 11:57 PM, pablo rey <span dir="ltr"><<a href="mailto:pablo@basurama.org" target="_blank">pablo@basurama.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div>I had to restart mysql again minutes ago.<br><br></div>This is the rails log before crashing:<br><div style="margin-left:40px">Started GET "/numeroteca/local-national-world-news/coding" for 5.10.83.101 at 2013-12-22 19:11:02 +0000<br>
Processing by CodingController#process_images as */*<br> Parameters: {"username"=>"numeroteca", "thread_name"=>"local-national-world-news"}<br> Rendered coding/_coding_footer.html.erb (0.1ms)<br>
Rendered coding/process_images.html.erb within layouts/application (3323.2ms) <br>Completed 200 OK in 3331ms (Views: 1658.8ms | ActiveRecord: 1668.8ms)<br>Started GET "/" for 67.23.226.7 at 2013-12-22 19:11:10 +0000<br>
Processing by HomeController#index as HTML<br> Rendered home/index.html.erb within layouts/application (184.1ms)<br>Completed 200 OK in 284ms (Views: 163.3ms | ActiveRecord: 120.0ms)<br>Started GET "/assets/application.css" for 67.23.226.7 at 2013-12-22 19:11:16 +0000<br>
Served asset /application.css - 304 Not Modified (522ms)<br>Started GET "/Donna/juicio-marita-veron-cronica/export.ods" for 5.10.83.105 at 2013-12-22 19:11:17 +0000<br>Processing by ThreadsController#export as ODS<br>
Parameters: {"username"=>"Donna", "thread_name"=>"juicio-marita-veron-cronica"}<br>Sent file /tmp/export20131222-12134-1228f0a.ods (0.1ms)<br>Completed 200 OK in 167ms (ActiveRecord: 95.3ms)<br>
Started GET "/davidmbusto/dragado-en-bahia-blanca/export.json" for 180.76.5.75 at 2013-12-22 19:11:17 +0000<br>Processing by ThreadsController#export as JSON<br> Parameters: {"username"=>"davidmbusto", "thread_name"=>"davidmbusto"}<br>
Completed 200 OK in 93ms (Views: 0.2ms | ActiveRecord: 4.6ms)<br>Started GET "/threads/" for 67.23.226.7 at 2013-12-22 19:11:19 +0000<br>Processing by ThreadsController#index as HTML<br>Connecting to database specified by database.yml<br>
Connecting to database specified by database.yml<br></div><br>After restarting <a href="https://github.com/numeroteca/pageonex/issues/182" target="_blank">pagination in the thread list is not working again</a>. 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.<br>
<br><br></div>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?<br>
<br></div>Happy holidays!<span><font color="#888888"><br>p<br><div><div><br><div><br><br></div></div></div></font></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Sun, Dec 15, 2013 at 1:53 AM, Edward Platt <span dir="ltr"><<a href="mailto:elplatt@media.mit.edu" target="_blank">elplatt@media.mit.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div>
<br></div><div>-Ed</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote"><div><div>On Sat, Dec 14, 2013 at 3:52 PM, pablo rey <span dir="ltr"><<a href="mailto:pablo@basurama.org" target="_blank">pablo@basurama.org</a>></span> wrote:<br></div></div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<div dir="ltr">Should I just restart the mysql server?<br> sudo service mysql restart<br></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Dec 14, 2013 at 9:09 PM, pablo rey <span dir="ltr"><<a href="mailto:pablo@basurama.org" target="_blank">pablo@basurama.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><dl><dt>Rahul and Ed!</dt><dt>The home page returns a passenger message: Ruby (Rack) application could not be started<br>
</dt><dd><span style="font-family:courier new,monospace"><br></span></dd><dt><span style="font-family:courier new,monospace">Error message:</span></dt>
<dd><span style="font-family:courier new,monospace">Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)</span></dd><dt><span style="font-family:courier new,monospace">Exception class:</span></dt>
<dd><span style="font-family:courier new,monospace">PhusionPassenger::UnknownError</span></dd></dl><p><br></p><p>Which is the same message I was getting and reported at <a href="https://github.com/numeroteca/pageonex/issues/179#issuecomment-30275654" target="_blank">https://github.com/numeroteca/pageonex/issues/179#issuecomment-30275654</a> (but didn't make the app crashed).</p>
<p></p><p>It looks like it's been down since yesterday.</p><p>Thanks,<br></p><p>p<br></p></div>
</blockquote></div><br></div>
</div></div><br></div></div>_______________________________________________<br>
Pageonexdev mailing list<br>
<a href="mailto:Pageonexdev@mit.edu" target="_blank">Pageonexdev@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/pageonexdev" target="_blank">http://mailman.mit.edu/mailman/listinfo/pageonexdev</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Edward L. Platt<br></div><div>Civic Technology Programmer</div><div>MIT Center for Civic Media</div>
<div>E15-348</div><div><a href="http://civic.mit.edu" target="_blank">http://civic.mit.edu</a></div>
<div><a href="http://elplatt.com" target="_blank">http://elplatt.com</a></div><div><a href="http://twitter.com/elplatt" target="_blank">@elplatt</a></div></div>
</font></span></div>
<br>_______________________________________________<br>
Pageonexdev mailing list<br>
<a href="mailto:Pageonexdev@mit.edu" target="_blank">Pageonexdev@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/pageonexdev" target="_blank">http://mailman.mit.edu/mailman/listinfo/pageonexdev</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Edward L. Platt<br></div><div>Civic Technology Programmer</div><div>MIT Center for Civic Media</div><div>E15-348</div><div><a href="http://civic.mit.edu" target="_blank">http://civic.mit.edu</a></div>
<div><a href="http://elplatt.com" target="_blank">http://elplatt.com</a></div><div><a href="http://twitter.com/elplatt" target="_blank">@elplatt</a></div></div>
</div>
</div></div><br>_______________________________________________<br>
Pageonexdev mailing list<br>
<a href="mailto:Pageonexdev@mit.edu">Pageonexdev@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/pageonexdev" target="_blank">http://mailman.mit.edu/mailman/listinfo/pageonexdev</a><br>
<br></blockquote></div><br></div>