Jira application does not start up - missing chunk number 0 for toast value 3995689 in pg_toast
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When a user tries to start the Jira application, it does not start up and throws an error.
Environment
Jira Software v8.x and above.
Diagnosis
On reviewing the Atlassian-jira.log, "ERROR: missing chunk number 0 for toast value 3995689 in pg_toast_2619 " observed:
1
2
3
4
5
6
7
8
9
10
11
12
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, JOB_ID, JOB_RUNNER_KEY, SCHED_TYPE, INTERVAL_MILLIS, FIRST_RUN, CRON_EXPRESSION, TIME_ZONE, NEXT_RUN, VERSION, PARAMETERS FROM public.clusteredjob WHERE JOB_ID=? *(ERROR: missing chunk number 0 for toast value 3995689 in pg_toast_2619)
* at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:881)
... 33 more
Caused by: org.postgresql.util.PSQLException: ERROR: missing chunk number 0 for toast value 3995689 in pg_toast_2619 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
... 38 more
2022-02-28 11:53:28,392+0530 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We couldn't start JIRACause
Corrupted index on tables/data corruption in TOAST tables. corruption in your TOAST tables.
Solution
The error does seem to indicate that something is not right on the database side. please refer to:
Was this helpful?