Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

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.