YOU CAN EDIT THIS PAGE! Just click any blue "Edit" link and start writing!

Tech:Database lock timeout

From Wikitravel Shared
Revision as of 02:29, 11 July 2012 by Dguillaime (talk | contribs) (open -> fixed)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

What happens[edit]

Requesting certain files on shared such as File:US-26.png results in the following error message after approximately ten minutes:

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last
attempted database query was:
(SQL query hidden)
from within function "LocalFile::upgradeRow". Database returned error "1205: Lock wait timeout
exceeded; try restarting transaction (wikitraveldb1-new)".

This problem previously existed with File:Brussels_Map.png, but that file worked when I tried accessing it just now.

When it happens[edit]

Click on File:US-26.png and you should be able to generate the referenced error. Other files that may demonstrate this error:

What should happen[edit]

How to fix it[edit]

Additional comments[edit]

Tech has been aware of this and is working on it; reported to tech 6/29; unsure if it will resolve with cache replacement on 7/9/12, but will continue to address.--IBobi 19:50, 6 July 2012 (EDT)

Resolved.--IBobi 19:35, 10 July 2012 (EDT)

Sign below, please[edit]

Ryan 02:47, 29 June 2012 (EDT)