Jira suddenly throwing errors

[David Lee]

Hi Jira Support,

Our server suddenly is throwing the below errors. Need HELP. Thanks.

Technical details
Log's referral number: 31c45323-2cac-4653-b515-92d2d47263e2

Cause
Referer URL: http://192.168.11.202:8080/secure/RapidBoard.jspa?rapidView=1&view=planning&selectedIssue=NI-83&selectedEpic=NI-65

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][issue,10088][author,david.lee][created,2018-08-21 16:07:30.464][id,10302] (SQL Exception while executing the following:INSERT INTO public.changegroup (ID, issueid, AUTHOR, CREATED) VALUES (?, ?, ?, ?) (ERROR: index "chggroup_author_created" contains unexpected zero page at block 2
Hint: Please REINDEX it.))
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][issue,10088][author,david.lee][created,2018-08-21 16:07:30.464][id,10302] (SQL Exception while executing the following:INSERT INTO public.changegroup (ID, issueid, AUTHOR, CREATED) VALUES (?, ?, ?, ?) (ERROR: index "chggroup_author_created" contains unexpected zero page at block 2
Hint: Please REINDEX it.))
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:299) [classes/:?]
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:172) [classes/:?]
at com.atlassian.jira.issue.history.ChangeLogUtils.createChangeGroup(ChangeLogUtils.java:86) [classes/:?]
at com.atlassian.jira.issue.util.DefaultIssueUpdater.storeModifiedFields(DefaultIssueUpdater.java:92) [classes/:?]
at 

[J van Leeuwen · Accepted solution]

Hi @David Lee - 

It looks like you may have some issues on your database index. Note the error:

 (ERROR: index "chggroup_author_created" contains unexpected zero page at block 2
Hint: Please REINDEX it.))

Are you using Postgres? I would recommend working with your DBA to have them fix the index on the database side. If it is indeed postgres, you may want to  refer them to this StackOverflow article which I believe will help:  https://stackoverflow.com/questions/47510124/postgres-index-contains-unexpected-zero-page-at-block-exceptions

Based on the error message, it doesn't look like you are dealing with duplicate constraints. Hope this helps!

- Jennifer

[David Lee]

Hi Jennifer,

Yes, it was a Postgres database error. We had the problem "index" re-indexed and the problem was solved.

Thank you for your help.
Regards, David.

[J van Leeuwen]

Hi David, 

Wonderful to hear! Hope you have a great day. 

- Jennifer

[Mirek]

HI @David Lee

You might be facing this problem

https://confluence.atlassian.com/jirakb/duplicated-entry-unique-constraint-violated-397808094.html

Please read and diagnose on your side. Just use "ChangeGroup" instead od "Membership" in the queries where you put entities.