[tahoe-lafs-trac-stream] [tahoe-lafs] #2058: trac sqlite db accesses taking a long time
tahoe-lafs
trac at tahoe-lafs.org
Mon Aug 12 21:35:24 UTC 2013
#2058: trac sqlite db accesses taking a long time
--------------------------------+------------------------------------
Reporter: zooko | Owner:
Type: defect | Status: new
Priority: normal | Milestone: soon (release n/a)
Component: dev-infrastructure | Version: 1.10.0
Keywords: | Launchpad Bug:
--------------------------------+------------------------------------
When I click on the "list all users" function of the Admin interface to
trac, it takes many minutes, during which time the whole https://tahoe-
lafs.org is locked.
Also other operations seem to be taking a long time, such as looking at
the Timeline.
Here is the current tail of {{{/var/log/nginx/error.log}}}:
{{{
2013/08/12 20:01:34 [error] 9225#0: *194257 open()
"/var/www/debian/dists/etch/tahoe/binary-i386/allmydata-
tahoe_1.4.1-r3916_all.deb" failed (2: No such file or directory), client:
173.199.115.107, server: tahoe-lafs.org, request: "GET
/debian/dists/etch/tahoe/binary-i386/allmydata-tahoe_1.4.1-r3916_all.deb
HTTP/1.1", host: "tahoe-lafs.org"
2013/08/12 20:17:15 [error] 9225#0: *194653 open() "/var/www/apple-touch-
icon-precomposed.png" failed (2: No such file or directory), client:
37.183.112.149, server: tahoe-lafs.org, request: "GET /apple-touch-icon-
precomposed.png HTTP/1.1", host: "tahoe-lafs.org"
2013/08/12 20:17:15 [error] 9225#0: *194653 open() "/var/www/apple-touch-
icon.png" failed (2: No such file or directory), client: 37.183.112.149,
server: tahoe-lafs.org, request: "GET /apple-touch-icon.png HTTP/1.1",
host: "tahoe-lafs.org"
2013/08/12 20:25:03 [error] 9225#0: *194880 open()
"/var/www/json/builders/Atlas ubuntu natty/builds" failed (2: No such file
or directory), client: 66.249.74.232, server: tahoe-lafs.org, request:
"GET
/json/builders/Atlas%20ubuntu%20natty/builds?select=-1&select=-2&as_text=1
HTTP/1.1", host: "www.tahoe-lafs.org"
2013/08/12 20:35:07 [error] 9225#0: *195163 open()
"/var/www/json/builders/Atlas ubuntu natty/slaves" failed (2: No such file
or directory), client: 66.249.74.232, server: tahoe-lafs.org, request:
"GET /json/builders/Atlas%20ubuntu%20natty/slaves?as_text=1 HTTP/1.1",
host: "www.tahoe-lafs.org"
2013/08/12 20:56:30 [error] 9225#0: *195773 open() "/var/www/buildbot-
zfecbuilders/MM netbsd5 i386 warp" failed (2: No such file or directory),
client: 66.249.74.45, server: tahoe-lafs.org, request: "GET /buildbot-
zfecbuilders/MM%20netbsd5%20i386%20warp HTTP/1.1", host: "tahoe-lafs.org"
2013/08/12 21:19:21 [error] 9225#0: *196351 upstream timed out (110:
Connection timed out) while reading response header from upstream, client:
66.249.74.45, server: tahoe-lafs.org, request: "GET /buildbot-tahoe-
lafs/builders/Francois%20lenny-
armv5tel/builds/159/steps/build/logs/stdio/text HTTP/1.1", upstream:
"http://127.0.0.1:8015/builders/Francois%20lenny-
armv5tel/builds/159/steps/build/logs/stdio/text", host: "tahoe-lafs.org"
2013/08/12 21:26:06 [error] 9225#0: *196463 open() "/var/www/~zooko
/network-and-reliance-topology.png" failed (2: No such file or directory),
client: 92.143.240.64, server: tahoe-lafs.org, request: "GET /~zooko
/network-and-reliance-topology.png HTTP/1.1", host: "tahoe-lafs.org",
referrer: "http://doc.ubuntu-fr.org/tahoe-lafs"
2013/08/12 21:26:52 [error] 9225#0: *196521 open() "/var/www/~zooko
/network-and-reliance-topology.png" failed (2: No such file or directory),
client: 92.143.240.64, server: tahoe-lafs.org, request: "GET /~zooko
/network-and-reliance-topology.png HTTP/1.1", host: "tahoe-lafs.org",
referrer: "http://doc.ubuntu-fr.org/tahoe-lafs"
2013/08/12 21:27:33 [error] 9225#0: *196266 upstream timed out (110:
Connection timed out) while reading response header from upstream, client:
97.118.93.160, server: tahoe-lafs.org, request: "GET /trac/tahoe-
lafs/admin/accounts/users HTTP/1.1", upstream:
"uwsgi://unix:///home/trac/protected/uwsgi.sock", host: "tahoe-lafs.org",
referrer: "https://tahoe-lafs.org/trac/tahoe-lafs/admin"
}}}
--
Ticket URL: <https://tahoe-lafs.org/trac/tahoe-lafs/ticket/2058>
tahoe-lafs <https://tahoe-lafs.org>
secure decentralized storage
More information about the tahoe-lafs-trac-stream
mailing list