Postrgesql error?

Discussion in '3CX Phone System - General' started by Tony Ayre, Dec 14, 2017.

Thread Status:
Not open for further replies.
  1. Tony Ayre

    Joined:
    Feb 22, 2017
    Messages:
    14
    Likes Received:
    0
    We had an unexpected reboot on our 3CX server and I'm now receiving the following:

    "ERROR: invalid page header in block 8 of relation base/16451/127448
    STATEMENT: truncate table eventlog"

    The phones are working, but the Windows event log is filling up with this (about 10 per second).

    How do I remedy this?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Tony Ayre

    Joined:
    Feb 22, 2017
    Messages:
    14
    Likes Received:
    0
    Well, I followed some advice at a Postgresql forum and ran:

    SET zero_damaged_pages = on;
    VACUUM full eventlog;


    So the errors have stopped.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.