Page MenuHomePhabricator

Perfromance issues potentially caused by locks and timeouts
Closed, DeclinedPublic

Description

Author: tim.trent

Description:
We run PostgreSQL 8.1

Apparently at random the system appears to hang while waiting for an event that
never happens. In general the server is idle at this point, though random
activity takes places.

To cause the hangs/pseudo-hangs we will do one of the following:

Run a search and attempt to edit. Result: Either or both of the search takes
for ever to reach EOJ or an edit may open fast but take up to 60 seconds to submit

Edit several pages simultaneously (tabbed browser) and submit edits as near
simultaneously as posisble. Result: Edits Do submit, but take of the order of
60 seconds

Server is very lightly loaded indeed (we are in the startup phase)


Version: 1.9.x
Severity: normal
URL: http://train.spottingworld.com

Details

Reference
bz9066

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
DeclinedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:37 PM
bzimport set Reference to bz9066.
bzimport added a subscriber: Unknown Object (MLST).

Could not duplicate. Can you try and figure out what is locking or taking so
long? Use the Postgres server logs, and/or check the output of:
select pid, relation:regclass, locktype, granted from pg_locks;
select * from pg_stat_activity;

Also, how many pages do you have, and how long does a search usually take?

Changing to "worksforme". If the submitter has more information, please reopen
the bug.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.