owncloud 引起 postgresql cpu100%

2017-12-22 14:29:05 +08:00
 ttgo

使用的好好的 owncloud 突然不能登录了,并且服务器其他东西也变得狂慢。

在服务器上看了一下,每一个 owncloud 有关的 postgres 进程都几乎 cpu 100%。

我不太懂数据库。。当初是按着 owncloud 的说明一步一步配的。

在日志里看,只要有连接访问 owncloud,就会有大量大量大量下面这样的 log:

Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  execute <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.019 ms
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.037 ms  parse <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.076 ms  bind <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  execute <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.031 ms
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.038 ms  parse <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.074 ms  bind <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  execute <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: DETAIL:  parameters: $1 = '72431', $2 = '1'
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.019 ms
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.038 ms  parse <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2
Dec 22 15:13:07 xxx postgres[15124]: LOG:  duration: 0.076 ms  bind <unnamed>: SELECT "path" FROM "oc_filecache" WHERE "fileid" = $1 AND "storage" = $2

请问有人能看出点思路么?大概啥出问题了啊?

1189 次点击
所在节点    问与答
1 条回复
ttgo
2017-12-22 14:30:25 +08:00
擦,为啥刚发的贴就是 1 天前??

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/416825

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX