nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira suddenly throwing errors

David Lee_y8pykp

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

Accepted answers

J van Leeuwen

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

All comments

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.

J van Leeuwen

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.))

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

- Jennifer

David Lee_y8pykp

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software