2010-09-13 05:27:45 |
Robert Collins |
description |
I got a message to moderate a message in the ubuntu-ar LP list. However when I try to access the page [1] I get a Timeout error (e.g. (Error ID: OOPS-1704EB927)). This is happening since past Sunday (at least).
TIA,
Mariano
[1] https://launchpad.net/~ubuntu-ar/+mailinglist-moderate |
Moderating mailing lists times out.
https://lp-oops.canonical.com/oops.py/?oopsid=1717K407
Branch: launchpad-rev-9760
Revno: 9760
SQL time: 13920 ms
Non-sql time: 2311 ms
Total time: 16231 ms
Statement Count: 1197
https://launchpad.net/%7Eopenjdk/+mailinglist-moderate
Repeated pattern:
main-slave SELECT Message.datecreated, Message.id, Message.owner, Message.parent, Message.raw, Message.rfc822msgid, Message.subject FROM Message WHERE Message.id = %s LIMIT 1
797. 11463 1ms SQL-launchpad-main-slave SELECT LibraryFileAlias.content, LibraryFileAlias.date_created, LibraryFileAlias.expires, LibraryFileAlias.filename, LibraryFileAlias.hits, LibraryFileAlias.id, LibraryFileAlias.last_accessed, LibraryFileAlias.mimetype, LibraryFileAlias.restricted FROM LibraryFileAlias WHERE LibraryFileAlias.id = %s LIMIT 1
798. 11465 1ms SQL-launchpad-main-slave SELECT LibraryFileContent.datecreated, LibraryFileContent.filesize, LibraryFileContent.id, LibraryFileContent.md5, LibraryFileContent.sha1 FROM LibraryFileContent WHERE LibraryFileContent.id = %s LIMIT 1
799. 11467 32ms librarian-connection http://mizuho.canonical.com:8000/....msg
800. 11500 0ms librarian-read http://mizuho.canonical.com:8000/....msg
801. 11503 1ms SQL-launchpad-main-slave SELECT MessageChunk.blob, MessageChunk.content, MessageChunk.id, MessageChunk.message, MessageChunk.sequence FROM MessageChunk WHERE MessageChunk.message = %s ORDER BY MessageChunk.sequence
802. 11507 1ms SQL-launchpad-main-slave SELECT Message.datecreated, Message.id, Message.owner, Message.parent, Message.raw, Message.rfc822msgid, Message.subject FROM Message WHERE Message.id = %s LIMIT 1
803. 11510 1ms SQL-launchpad-main-slave SELECT LibraryFileAlias.content, LibraryFileAlias.date_created, LibraryFileAlias.expires, LibraryFileAlias.filename, LibraryFileAlias.hits, LibraryFileAlias.id, LibraryFileAlias.last_accessed, LibraryFileAlias.mimetype, LibraryFileAlias.restricted FROM LibraryFileAlias WHERE LibraryFileAlias.id = %s LIMIT 1
The LibraryFileContent queries will be gone on edge, because that bug is fixed.
The librarian connection and reads are a considerable amount of time; we probably want to issue many connection-reads at once rather than serialising them all, or as curtis says batch it. Batching is almost certainly needed in extremis anyway, so lets do that first. |
|