Project

General

Profile

Task #2140

ask.libreoffice.org is reporting "Internal server error" when trying to add an answer or comment to some pages

Added by H J 11 months ago. Updated 8 months ago.

Status:
Closed
Priority:
High
Category:
-
Target version:
Team - Pool
Start date:
Due date:
% Done:

0%

Estimated time:
Tags:
URL:

Description

Hi, I'm sometimes getting an "Internal server error" when I try to use ask.libreoffice.org.

For example, I can't add an answer or comment to this page without getting this fatal error (see attached screen shots).

https://ask.libreoffice.org/en/question/85130/loba-find-the-record-number-from-an-id-or-other-query-search/

Also I can't seem to search at times using the search box at the top without a similar error.

History

#1 Updated by Florian Effenberger 11 months ago

Hi, I'm sometimes getting an "Internal server error" when I try to use
ask.libreoffice.org.

For example, I can't add an answer or comment to this page without
getting this fatal error (see attached screen shots).

https://ask.libreoffice.org/en/question/85130/loba-find-the-record-number-from-an-id-or-other-query-search/

Also I can't seem to search at times using the search box at the top
without a similar error.

Do you have an exact date and time, so we can see in the server logs?

#2 Updated by H J 11 months ago

Florian Effenberger wrote:

Do you have an exact date and time, so we can see in the server logs?

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.

#3 Updated by Florian Effenberger 11 months ago

Evgeny looking into this now
Seems also that (at least the) German site has a general server error

#4 Updated by Evgeny Fadeev 11 months ago

I've made some database repairs, could you please test with real content? I'm not comfortable making test posts on the live site.

#5 Updated by H J 11 months ago

Evgeny Fadeev wrote:

I've made some database repairs, could you please test with real content? I'm not comfortable making test posts on the live site.

So far so good. Seems like what you did fixed this. Thanks

#6 Updated by Guilhem Moulin 11 months ago

  • Assignee set to Guilhem Moulin

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

INFO:  "django_session": scanned 30000 of 61128 pages, containing 1292950 live rows and 5141 dead rows; 30000 rows in sample, 2640563 estimated total rows
INFO: "askbot_thread": scanned 3187 of 3187 pages, containing 25612 live rows and 3247 dead rows; 25612 rows in sample, 25612 estimated total rows

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?

#7 Updated by Evgeny Fadeev 10 months ago

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.

#8 Updated by Florian Effenberger 10 months ago

  • Target version set to Pool

Is this ticket dealt with?

#9 Updated by Florian Effenberger 10 months ago

Ping Guilhem? ;-)

#10 Updated by Guilhem Moulin 10 months ago

  • Tags deleted (EasyHack)

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.

#11 Updated by H J 10 months ago

Thanks. ask.libreoffice.org seems to be working better now. Looks like
at least for the page failures I first referenced below, they are now
fixed. Good work! It's great to have ask.libreoffice.org.

On 2/20/2017 4:13 AM, The Document Foundation Redmine wrote:

#12 Updated by Florian Effenberger 8 months ago

  • Status changed from New to Closed

Closing, as this seems to be solved now

Also available in: Atom PDF