assign issue to non agent

com.atlassian.cache.CacheException: java.lang.IllegalArgumentException: owner must be null for system avatars
com.atlassian.cache.CacheException: java.lang.IllegalArgumentException: owner must be null for system avatars
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:217) [atlassian-cache-memory-2.13.3.jar:?]
at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:168) [atlassian-cache-memory-2.13.3.jar:?]
at com.atlassian.jira.avatar.CachingTaggingAvatarStore.getById(CachingTaggingAvatarStore.java:99) [classes/:?]
at com.atlassian.jira.avatar.AvatarManagerImpl.getById(AvatarManagerImpl.java:95) [classes/:?]
at com.atlassian.jira.avatar.AvatarServiceImpl.getAvatarImpl(AvatarServiceImpl.java:104) [classes/:?]
at com.atlassian.jira.avatar.AvatarServiceImpl.isUsingExternalAvatar(AvatarServiceImpl.java:406) [classes/:?]
at com.atlassian.jira.avatar.AvatarServiceImpl.getAvatarURLImpl(AvatarServiceImpl.java:202) [classes/:?]
at com.atlassian.jira.avatar.AvatarServiceImpl.getAvatarURL(AvatarServiceImpl.java:217) [classes/:?]
at com.atlassian.jira.plugins.auditing.rest.responses.UserResponse$.String2UserResponse(UserResponse.scala:38) [?:?]
at com.atlassian.jira.plugins.auditing.rest.responses.RecordTransformer$$anonfun$fromAuditRecord$1.apply(RecordTransformer.scala:47) [?:?]
at com.atlassian.jira.plugins.auditing.rest.responses.RecordTransformer$$anonfun$fromAuditRecord$1.apply(RecordTransformer.scala:37) [?:?]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) [?:?]
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) [?:?]
at scala.collection.Iterator$class.foreach(Iterator.scala:727) [?:?]
at scala.collection.AbstractIterator.foreach(Iterator.scala:1157) [?:?]
at scala.collection.IterableLike$class.foreach(IterableLike.scala:72) [?:?]
at scala.collection.AbstractIterable.foreach(Iterable.scala:54) [?:?]
at scala.collection.TraversableLike$class.map(TraversableLike.scala:244) [?:?]
at scala.collection.AbstractTraversable.map(Traversable.scala:105) [?:?]
at com.atlassian.jira.plugins.auditing.RecordsProvider.getViewResponse(RecordsProvider.scala:121) [?:?]
at com.atlassian.jira.plugins.auditing.actions.ViewRecords.doGetRecords(ViewRecords.scala:101) [?:?]
at com.atlassian.jira.plugins.auditing.actions.ViewRecords.doExecute(ViewRecords.scala:54) [?:?]
at webwork.action.ActionSupport.execute(ActionSupport.java:165) [webwork-1.4-atlassian-30.jar:?]
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) [jira-api-7.4.2.jar:?]
at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) [webwork-1.4-atlassian-30.jar:?]
at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) [webwork-1.4-atlassian-30.jar:?]
at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) [webwork-1.4-atlassian-30.jar:?]
at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) [webwork-1.4-atlassian-30.jar:?]
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225) [webwork-1.4-atlassian-30.jar:?]
at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:154) [webwork-1.4-atlassian-30.jar:?]
at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:138) [classes/:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) [catalina.jar:8.5.6]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.6]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
at com.atlassian.jira.web.filters.JiraLastFilter.lambda$doFilter$0(JiraLastFilter.java:39) [classes/:?]

1 answer

1 accepted

0 votes

Hi Ruben,

That is a very strange error to see.  Could you let me know what happened to cause this?  Was Jira upgraded recently? Did this happen during a startup of Jira? Have there been any problems with the database of Jira recently?

Could you also please run the following SQL query against your Jira database?

select * from avatar where systemavatar=1;

The error message we see at the top of that log seems to indicate that a user account has a system avatar in a scenario when this value should be NULL.  I expect that the results of that query should be able to tell us more about what account has this problem.  And from there perhaps we can offer some next steps to take to try to resolve this.

Regards,
Andy

Dear, I've actually updated to the latest version, the query:

ID FILENAME CONTENTTYPE AVATARTYPE OWNER SYSTEMAVATAR
----- ---------------------------------------- ------------- ---------- -------- ------------
10120 Avatar-21.png image/png user (null) 1
10121 Avatar-22.png image/png user (null) 1
10322 feedback.svg image/svg+xml issuetype (null) 1
10122 Avatar-default.svg image/svg+xml user (null) 1
10000 codegeist.png image/png project (null) 1
10123 Avatar-unknown.png image/png user (null) 1
10323 request_access.svg image/svg+xml issuetype (null) 1
10200 cloud.svg image/svg+xml project (null) 1
10201 spanner.svg image/svg+xml project (null) 1
10324 default.svg image/svg+xml project (null) 1
10202 cd.svg image/svg+xml project (null) 1
10325 code.svg image/svg+xml project (null) 1
10203 money.svg image/svg+xml project (null) 1
10326 coffee.svg image/svg+xml project (null) 1
10327 design.svg image/svg+xml project (null) 1
10204 mouse-hand.svg image/svg+xml project (null) 1
10328 drill.svg image/svg+xml project (null) 1
10205 yeti.svg image/svg+xml project (null) 1
10206 power.svg image/svg+xml project (null) 1
10001 bird.svg image/svg+xml project (null) 1
10207 refresh.svg image/svg+xml project (null) 1
10002 jm_black.png image/png project (null) 1
10208 phone.svg image/svg+xml project (null) 1
10329 food.svg image/svg+xml project (null) 1
10209 settings.svg image/svg+xml project (null) 1
10003 jm_brown.png image/png project (null) 1
10210 storm.svg image/svg+xml project (null) 1
10330 notes.svg image/svg+xml project (null) 1
10211 plane.svg image/svg+xml project (null) 1
10004 jm_orange.png image/png project (null) 1
10300 genericissue.svg image/svg+xml issuetype (null) 1
10005 jm_red.png image/png project (null) 1
10303 bug.svg image/svg+xml issuetype (null) 1
10006 jm_white.png image/png project (null) 1
10304 defect.svg image/svg+xml issuetype (null) 1
10007 jm_yellow.png image/png project (null) 1
10306 documentation.svg image/svg+xml issuetype (null) 1
10008 monster.png image/png project (null) 1
10307 epic.svg image/svg+xml issuetype (null) 1
10009 nature.svg image/svg+xml project (null) 1
10010 koala.svg image/svg+xml project (null) 1
10308 exclamation.svg image/svg+xml issuetype (null) 1
10011 rocket.svg image/svg+xml project (null) 1
10100 Avatar-1.png image/png user (null) 1
10331 red-flag.svg image/svg+xml project (null) 1
10101 Avatar-2.png image/png user (null) 1
10309 design_task.svg image/svg+xml issuetype (null) 1
10102 Avatar-3.png image/png user (null) 1
10332 science.svg image/svg+xml project (null) 1
10310 improvement.svg image/svg+xml issuetype (null) 1
10333 support.svg image/svg+xml project (null) 1
10311 newfeature.svg image/svg+xml issuetype (null) 1
10334 bull.svg image/svg+xml user (null) 1
10312 remove_feature.svg image/svg+xml issuetype (null) 1
10103 Avatar-4.png image/png user (null) 1
10313 requirement.svg image/svg+xml issuetype (null) 1
10335 cat.svg image/svg+xml user (null) 1
10314 sales.svg image/svg+xml issuetype (null) 1
10336 dog.svg image/svg+xml user (null) 1
10315 story.svg image/svg+xml issuetype (null) 1
10337 female_1.svg image/svg+xml user (null) 1
10316 subtask.svg image/svg+xml issuetype (null) 1
10338 female_2.svg image/svg+xml user (null) 1
10318 task.svg image/svg+xml issuetype (null) 1
10339 female_3.svg image/svg+xml user (null) 1
10320 question.svg image/svg+xml issuetype (null) 1
10340 female_4.svg image/svg+xml user (null) 1
10341 ghost.svg image/svg+xml user (null) 1
10500 IMG_FIRMAjrvtg.png image/png user debugsac 1
10342 male_1.svg image/svg+xml user (null) 1
10343 male_2.svg image/svg+xml user (null) 1
10344 male_3.svg image/svg+xml user (null) 1
10345 male_4.svg image/svg+xml user (null) 1
10104 Avatar-5.png image/png user (null) 1
10346 male_5.svg image/svg+xml user (null) 1
10347 male_6.svg image/svg+xml user (null) 1
10348 male_8.svg image/svg+xml user (null) 1
10503 bb5cc71d-6bbd-4834-86cf-6a54414d56bf.png image/png project 10103 1
10349 owl.svg image/svg+xml user (null) 1
10350 pirate.svg image/svg+xml user (null) 1
10351 robot.svg image/svg+xml user (null) 1
10352 vampire.svg image/svg+xml user (null) 1
10105 Avatar-6.png image/png user (null) 1
10106 Avatar-7.png image/png user (null) 1
10107 Avatar-8.png image/png user (null) 1
10108 Avatar-9.png image/png user (null) 1
10109 Avatar-10.png image/png user (null) 1
10110 Avatar-11.png image/png user (null) 1
10111 Avatar-12.png image/png user (null) 1
10112 Avatar-13.png image/png user (null) 1
10113 Avatar-14.png image/png user (null) 1
10114 Avatar-15.png image/png user (null) 1
10115 Avatar-16.png image/png user (null) 1
10116 Avatar-17.png image/png user (null) 1
10117 Avatar-18.png image/png user (null) 1
10118 Avatar-19.png image/png user (null) 1
10119 Avatar-20.png image/png user (null) 1
10321 development_task.svg image/svg+xml issuetype (null) 1

For some reason your instance appears to have 2 entries in this avatars table that marked these as system avatars, but they have an owner for some reason.

10500 IMG_FIRMAjrvtg.png image/png user debugsac 1
10503 bb5cc71d-6bbd-4834-86cf-6a54414d56bf.png image/png project 10103 1

 I would recommend that you first create a backup of your SQL database.  Then stop Jira, from there try to run these two update commands in SQL to adjust these values:

update avatar set owner = NULL where id = 10500; 
update avatar set systemavatar=0 where id = 10503;

You can then start Jira again.   I am not sure how or why this might have happened, but I believe that we can correct these by setting the one to have a null owner and changing the other to no longer be a system avatar.   

thanks, indeed that is one of the reasons, additionally I had to delete the files inside the avatar folder and clean the UPM, I had to check the logs and verify the exceptions with that I could finish solving.

Hi Ruben,

Thanks for letting us know that this helped, and for the additional steps you took in your environment.  Since it looks like this has been resolved, I will mark this issue as solved.  If that isn't the case, just reply back and let us know the current state.

Thanks,

Andy

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

730 views 5 16
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot