Web Help Desk Site is inaccessible, getting an error: "ERROR: missing chunk number 0 for toast value 238582 in pg_toast_2619"

In this issue, the Web Help Desk Techs and Clients are suddenly unable to access the Web Help Desk Console.

When the Administrator restarts the services and accesses the site, it's throwing an error:

“EvaluateExpression failed::Next exception SQL State:XX000 –error code: 0 – msg: ERROR: missing chunk number 0 for toast value 238582 in pg_toast_2619”

The current Database used in the Application is the embedded PostgreSQL.

When checking the postgresql.log, seeing the repetitive error below:

ERROR:  missing chunk number 0 for toast value 101833 in pg_toast_2619
STATEMENT:  SELECT t0.ADDITIONAL_INFO, t0.CC_RECIPIENTS, t0.DATE_CREATED, t0.DATE_RECEIVED, t0.DATE_SENT, t0.EMAIL_HISTORY_ENTRY_ID, t0.FROM_RECIPIENT, t0.ID, t0.MESSAGE_BODY, t0.PROCESSING_RESULT_TYPE_ID, t0.RAW_EMAIL, t0.SUBJECT, t0.SUBSCRIBER_ID, t0.TICKET_HISTORY_ENTRY_ID, t0.TO_RECIPIENTS FROM EMAIL_DATA_OBJECT t0 WHERE t0.EMAIL_HISTORY_ENTRY_ID = $1
LOG:  received smart shutdown request

Resolution 1:
Perform Maintenance and REINDEX the Database

Pre-Implementation Steps:
1. Current Database Backup of your WHD --- THIS IS IMPORTANT
2. Create a Server Snapshot --- THIS IS IMPORTANT

Implementation Steps:
1. Remote into the Web Help Desk Server
2. Stop the Web Help Desk Services
3. Launched the PgAdmin Application
4. Under the Databases, find the database: whd
5. Right-click whd > Maintenance
6. Select REINDEX and hit OK

7. Start the Web Help Desk Services
8. Launched the Web Help Desk and verify if the console is now accessible.


Resolution 2:
Find a recent copy of the Database and perform Restoration

Pre-Implementation Steps:
1. Create a Server Snapshot --- THIS IS IMPORTANT

Implementation Steps:
1. Remote into the Web Help Desk Server
2. Stop the Web Help Desk Services
3. Launched the PgAdmin Application
4. Under the Databases, find the database: whd
5. Rename the database whd to whd_old (right-click>properties) and click Ok.
6. Then create new:
Right Click Databases>new database
Name: whd
Owner: whd
Tablespace: pg_default
Collation: English_United States.1252
Character_Type: English_United States.1252
Click Ok
7. Right-click whd, restore the database (locate where you save the whd database recent backup)
8. Start the Web Help Desk Services
9. Launched the Web Help Desk and verify if the console is now accessible.