We just completed a major upgrade from 7.3.6 to 8.5.3 with new VM app servers, new SQL server
I'm seeing 100's of thousands of SQL error messages - I think these are related to some enhanced JQL dashboard queries which get translated into some internal SQL queries, etc... Old version seemed to handle this differently than the new version of JIRA. Any ideas on how to resolve this? We have opened an support request
Examples:
NEW 8.5.3 JIRA:
the internal sql that gets called, ends up with multiple results coming back... thus causing this error in the log.
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
OLD 7.3.6 JIRA:
when I ran the same query on old system, I see an error in the log - but it is different
2020-05-05 19:58:15,872 http-nio-8080-exec-17 WARN jskipper 1198x15337x1 1qzbrfs 10.25.18.146 /secure/QueryComponent!Jql.jspa [c.x.raven.c.b] More than one issue link type with GreenHopper link style – using first
2020-05-05 19:58:15,872 http-nio-8080-exec-5 WARN jskipper 1198x15338x2 1qzbrfs 10.25.18.146 /rest/issueNav/1/issueTable [c.x.raven.c.b] More than one issue link type with GreenHopper link style – using first
