This is Ubuntu 14.04.1 LTS with postgresql 9.3 in production, Now i got this below error's in log.
# tail -f /var/log/postgresql/postgresql-9.3-main.log
2015-01-08 14:10:16 IST CONTEXT: automatic vacuum of table "lms_production.pg_toast.pg_toast_17005"
2015-01-08 14:10:29 IST LOG: incomplete startup packet
2015-01-08 14:11:10 IST ERROR: invalid page in block 105 of relation base/16385/17407
2015-01-08 14:11:10 IST STATEMENT: select count(*) from report_snapshots;
2015-01-08 14:11:16 IST ERROR: invalid page in block 632 of relation base/16385/17010
2015-01-08 14:11:16 IST CONTEXT: automatic vacuum of table "lms_production.pg_toast.pg_toast_17005"
2015-01-08 14:11:29 IST LOG: incomplete startup packet
2015-01-08 14:12:16 IST ERROR: invalid page in block 632 of relation base/16385/17010
2015-01-08 14:12:16 IST CONTEXT: automatic vacuum of table "lms_production.pg_toast.pg_toast_17005"
2015-01-08 14:12:29 IST LOG: incomplete startup packet
2015-01-08 14:13:16 IST ERROR: invalid page in block 632 of relation base/16385/17010
2015-01-08 14:13:16 IST CONTEXT: automatic vacuum of table "lms_production.pg_toast.pg_toast_17005"
2015-01-08 14:13:29 IST LOG: incomplete startup packet
While checking for error reports in postgres it shows the count fine.
# select count(*) from error_reports;
count
-------
5345
(1 row)
While checking for report_snapshots it's throwing the above error.
# select count(*) from report_snapshots;
ERROR: invalid page in block 105 of relation base/16385/17407
While googling found that someone says it's disk problem but here we use dedicated server and this database running machine is one of the virtual machine for production. Disk have enough space and nothing issue with disk, Other virtual machine running in host are working without any issue's. Any one there to fix this issue ?
Aucun commentaire:
Enregistrer un commentaire