https://redmine.documentfoundation.org/https://redmine.documentfoundation.org/favicon.ico?16960560022017-01-17T07:24:13ZThe Document Foundation RedmineInfrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=114782017-01-17T07:24:13ZFlorian Effenbergerfloeff@documentfoundation.org
<ul></ul><blockquote>
<p>Hi, I'm sometimes getting an "Internal server error" when I try to use<br />ask.libreoffice.org.</p>
<p>For example, I can't add an answer or comment to this page without<br />getting this fatal error (see attached screen shots).</p>
<p><a class="external" href="https://ask.libreoffice.org/en/question/85130/loba-find-the-record-number-from-an-id-or-other-query-search/">https://ask.libreoffice.org/en/question/85130/loba-find-the-record-number-from-an-id-or-other-query-search/</a></p>
<p>Also I can't seem to search at times using the search box at the top<br />without a similar error.</p>
</blockquote>
<p>Do you have an exact date and time, so we can see in the server logs?</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=114802017-01-17T16:12:30ZH JBridgeportContractor@gmail.com
<ul><li><strong>File</strong> <a href="/attachments/1650">screenshot-window-2017-01-17-071117.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/1650/screenshot-window-2017-01-17-071117.png">screenshot-window-2017-01-17-071117.png</a> added</li></ul><p>Florian Effenberger wrote:</p>
<blockquote>
<p>Do you have an exact date and time, so we can see in the server logs?</p>
</blockquote>
<p>Florian, for one, it's still giving me an "Internal server error" right now, that's Tuesday, January 17 at 5.01 pm GMT, when I enter something, anything, in the "Search or Ask your Question" box at the top, and then hit enter to search. See attached.</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=114832017-01-19T07:45:45ZFlorian Effenbergerfloeff@documentfoundation.org
<ul></ul><p>Evgeny looking into this now<br />Seems also that (at least the) German site has a general server error</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=114872017-01-19T17:00:27ZEvgeny Fadeevevgeny.fadeev@gmail.com
<ul></ul><p>I've made some database repairs, could you please test with real content? I'm not comfortable making test posts on the live site.</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=115102017-01-23T16:36:16ZH JBridgeportContractor@gmail.com
<ul></ul><p>Evgeny Fadeev wrote:</p>
<blockquote>
<p>I've made some database repairs, could you please test with real content? I'm not comfortable making test posts on the live site.</p>
</blockquote>
<p>So far so good. Seems like what you did fixed this. Thanks</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=115442017-01-27T15:26:29ZGuilhem Moulinguilhem@libreoffice.org
<ul><li><strong>Assignee</strong> set to <i>Guilhem Moulin</i></li></ul><p>Hmm, I noticed there were dozens of thousands of dead rows in the "django_session" and (more surprising) "askbot_thread" tables. I did a manual VACUUM FULL, but only 2.5h later we back at</p>
<pre><code>INFO: "django_session": scanned 30000 of 61128 pages, containing 1292950 live rows and 5141 dead rows; 30000 rows in sample, 2640563 estimated total rows<br /> INFO: "askbot_thread": scanned 3187 of 3187 pages, containing 25612 live rows and 3247 dead rows; 25612 rows in sample, 25612 estimated total rows</code></pre>
<p>Evgeny, the number of rows in "django_session" is surprisingly high isn't it? If that's expected I guess storing them in shared memory instead would improve performance? Also, I'm a bit puzzled at the ever increasing dead rows in "askbot_thread". Is that normal behavior? Perhaps we just need a more aggressive autovacuum policy on these tables?</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=116502017-02-13T13:54:59ZEvgeny Fadeevevgeny.fadeev@gmail.com
<ul></ul><p>Sessions are created for any new visitor, so not that surprising. There is a cron job that regularly clears expired sessions, they expire in quite a while, so many will accumulate.</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=117182017-02-20T13:13:27ZFlorian Effenbergerfloeff@documentfoundation.org
<ul><li><strong>Target version</strong> set to <i>Pool</i></li></ul><p>Is this ticket dealt with?</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=118062017-02-27T12:59:22ZFlorian Effenbergerfloeff@documentfoundation.org
<ul></ul><p>Ping Guilhem? ;-)</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=118092017-02-27T13:17:08ZGuilhem Moulinguilhem@libreoffice.org
<ul><li><strong>Tags</strong> deleted (<del><i>EasyHack</i></del>)</li></ul><p>I didn't hear loud complains in a while, but I think the PostgreSQL database needs a more aggressive VACUUM policy on some tables to avoid clogging up the database. I'm still monitoring the progression of dead rows to see how to fine-tune that policy.</p> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=118172017-02-28T16:31:33ZH JBridgeportContractor@gmail.com
<ul></ul><p>Thanks. ask.libreoffice.org seems to be working better now. Looks like <br />at least for the page failures I first referenced below, they are now <br />fixed. Good work! It's great to have ask.libreoffice.org.</p>
<p>On 2/20/2017 4:13 AM, The Document Foundation Redmine wrote:</p>
<blockquote>
</blockquote> Infrastructure - Task #2140: ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pageshttps://redmine.documentfoundation.org/issues/2140?journal_id=120642017-04-11T11:26:28ZFlorian Effenbergerfloeff@documentfoundation.org
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li></ul><p>Closing, as this seems to be solved now</p>