Advisory: Sophos Endpoint - "Your connection isn't private." We're aware of a certificate issue and are actively working to resolve it. Please see: KB-000045954 for the latest updates.

[7.500][BUG][ACK] postgres at full load!

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: 
    --------------------------------
  • could you please take a look to /var/log/system.log are there any error messages?

    could please also report the output:

    ps aux | grep postgres

    greetings
    andreas
  • system.log



    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] 



    ps aux | grep postgres:

    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