Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,363,997
Community Members
 
Community Events
168
Community Groups

Database error regarding empty table

Good morning,

 

We are seeing this error in our JIRA instance and it seems to be writing to a table that doesn't exist, I just wanted someone to take a look at this and see maybe what we could do to remedy it. It's not affecting functionality, but our DB Admins are seeing this error very frequently;

 

...Current username=SERVICE_DESK

...Application: JDBC Thin Client Action:

2022-08-24T07:49:05.626567-04:00

WARNING: too many parse errors, count=1953900 SQL hash=0x018df152

PARSE ERROR: ospid=6576, error=904 for statement:

2022-08-24T07:49:05.626652-04:00

select "MIGRATION"."MIGRATION_ID", "MIGRATION"."PLAN_ID", "MIGRATION"."START_MIGRATION_CONTEXT_JSON", "MIGRATION"."IN_PROGRESS_STATUS_JSON", "MIGRATION"."OUTCOME_JSON", "MIGRATION"."APP_OUTCOME_JSON", "MIGRATION"."STARTED_BY", "MIGRATION"."CREATED_TIMESTAMP", "MIGRATION"."UPDATED_TIMESTAMP", "MIGRATION"."PROTOCOL_JSON" from "AO_6FF49D_MIGRATION_ENTITY" "MIGRATION" where "MIGRATION"."OUTCOME_JSON" is null and "MIGRATION"."UPDATED_TIMESTAMP" > :1

Additional information: hd=0x954a2de8 phd=0x954a4540 flg=0x100476 cisid=658 sid=658 ciuid=658 uid=658 sqlid=98d3rb80svwak

...Current username=SERVICE_DESK

 

I think we traced some of it back to the migration assistant which we've disabled but still see the error. Any guidance would be appreciated, thanks!

Harry Aiken

Systems Administrator II

404-651-8843

Georgia Dept of Audits and Accounts

Information Technology Division

 

 

 

1 answer

0 votes
Clark Everson Community Leader Sep 21, 2022

Hi @Harry Aiken 

Have you checked if you have custom fields tied to the migration assistance app? The custom fields don't tend to get removed even if an app is disabled.

There could be other artifacts as well but many apps add artifacts in random schemes throughout Jira

Best,

Clark

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
9.2
TAGS

Atlassian Community Events