Hihi,
after Updating to 7.500 I noticed a full load at the postgres service, which extremly slows down my ASG 220.[:S]
Webmin also shows a full load CPU usage (view attachment).
Do you have any suggestion?
Cheers
Astaro Beta Report
--------------------------------
Version: 7.500
Type: BUG
State: ACK
Reporter: n00b
Contributor:
MantisID:
--------------------------------
2009:10:10-02:30:33 GW postgres[10009]: [3-1] WARNING: skipping "pg_authid" --- only table or database owner can vacuum it
2009:10:10-02:30:33 GW postgres[10009]: [4-1] WARNING: skipping "pg_database" --- only table or database owner can vacuum it
2009:10:10-02:30:33 GW postgres[10009]: [5-1] WARNING: skipping "pg_shdepend" --- only table or database owner can vacuum it
2009:10:10-02:30:33 GW postgres[10009]: [6-1] WARNING: skipping "pg_shdescription" --- only table or database owner can vacuum it
2009:10:10-02:30:33 GW postgres[10009]: [7-1] WARNING: skipping "pg_auth_members" --- only table or database owner can vacuum it
2009:10:10-02:30:36 GW postgres[10009]: [8-1] WARNING: skipping "pg_tablespace" --- only table or database owner can vacuum it
2009:10:10-02:30:36 GW postgres[10009]: [9-1] WARNING: skipping "pg_pltemplate" --- only table or database owner can vacuum it
2009:10:10-13:19:49 GW postgres[4442]: [3-1] LOG: unexpected EOF on client connection
2009:10:10-14:19:49 GW postgres[8921]: [3-1] LOG: unexpected EOF on client connection
2009:10:10-14:22:29 GW postgres[9007]: [3-1] LOG: unexpected EOF on client connection
2009:10:10-14:25:23 GW postgres[18590]: [3-1] LOG: relation "mailanon_addrs" TID 10187/95: XMIN_COMMITTED not set for transaction 27113124 --- cannot shrink relation
2009:10:10-14:25:23 GW postgres[18590]: [3-2] STATEMENT: vacuum full mailanon_addrs
2009:10:10-14:28:42 GW postgres[9202]: [3-1] LOG: unexpected EOF on client connection
2009:10:10-14:30:25 GW postgres[9303]: [3-1] LOG: unexpected EOF on client connection
2009:10:10-14:30:31 GW postgres[9316]: [3-1]
postgres 3146 0.0 0.5 48820 5336 ? S Oct09 0:06 /usr/bin/postgres -D /var/storage/pgsql/data
postgres 3152 0.0 3.3 48956 34652 ? Ss Oct09 0:00 postgres: writer process
postgres 3153 0.0 0.0 48820 1024 ? Ss Oct09 0:00 postgres: wal writer process
postgres 3154 0.0 0.1 49092 1316 ? Ss Oct09 0:00 postgres: autovacuum launcher process
postgres 3155 0.0 0.1 6996 1032 ? Ss Oct09 0:02 postgres: stats collector process
postgres 4024 0.0 2.9 49736 29936 ? Ss Oct09 0:08 postgres: reporting reporting [local] idle
postgres 4282 0.0 2.2 50000 22980 ? Ss Oct09 0:04 postgres: postgres smtp 127.0.0.1(50915) idle
postgres 26897 0.0 1.8 50132 19248 ? Ss Oct09 0:00 postgres: postgres smtp 127.0.0.1(48280) idle
postgres 20779 91.6 6.6 86928 68036 ? Rs 18:40 108:17 postgres: reporting reporting [local] DELETE
postgres 27164 0.1 0.4 50036 4812 ? Ss 20:37 0:00 postgres: postgres smtp 127.0.0.1(48065) idle
100 27342 0.0 0.0 1624 520 pts/0 S+ 20:38 0:00 grep postgres