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/:?]
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) 110121 Avatar-22.png image/png user (null) 110322 feedback.svg image/svg+xml issuetype (null) 110122 Avatar-default.svg image/svg+xml user (null) 110000 codegeist.png image/png project (null) 110123 Avatar-unknown.png image/png user (null) 110323 request_access.svg image/svg+xml issuetype (null) 110200 cloud.svg image/svg+xml project (null) 110201 spanner.svg image/svg+xml project (null) 110324 default.svg image/svg+xml project (null) 110202 cd.svg image/svg+xml project (null) 110325 code.svg image/svg+xml project (null) 110203 money.svg image/svg+xml project (null) 110326 coffee.svg image/svg+xml project (null) 110327 design.svg image/svg+xml project (null) 110204 mouse-hand.svg image/svg+xml project (null) 110328 drill.svg image/svg+xml project (null) 110205 yeti.svg image/svg+xml project (null) 110206 power.svg image/svg+xml project (null) 110001 bird.svg image/svg+xml project (null) 110207 refresh.svg image/svg+xml project (null) 110002 jm_black.png image/png project (null) 110208 phone.svg image/svg+xml project (null) 110329 food.svg image/svg+xml project (null) 110209 settings.svg image/svg+xml project (null) 110003 jm_brown.png image/png project (null) 110210 storm.svg image/svg+xml project (null) 110330 notes.svg image/svg+xml project (null) 110211 plane.svg image/svg+xml project (null) 110004 jm_orange.png image/png project (null) 110300 genericissue.svg image/svg+xml issuetype (null) 110005 jm_red.png image/png project (null) 110303 bug.svg image/svg+xml issuetype (null) 110006 jm_white.png image/png project (null) 110304 defect.svg image/svg+xml issuetype (null) 110007 jm_yellow.png image/png project (null) 110306 documentation.svg image/svg+xml issuetype (null) 110008 monster.png image/png project (null) 110307 epic.svg image/svg+xml issuetype (null) 110009 nature.svg image/svg+xml project (null) 110010 koala.svg image/svg+xml project (null) 110308 exclamation.svg image/svg+xml issuetype (null) 110011 rocket.svg image/svg+xml project (null) 110100 Avatar-1.png image/png user (null) 110331 red-flag.svg image/svg+xml project (null) 110101 Avatar-2.png image/png user (null) 110309 design_task.svg image/svg+xml issuetype (null) 110102 Avatar-3.png image/png user (null) 110332 science.svg image/svg+xml project (null) 110310 improvement.svg image/svg+xml issuetype (null) 110333 support.svg image/svg+xml project (null) 110311 newfeature.svg image/svg+xml issuetype (null) 110334 bull.svg image/svg+xml user (null) 110312 remove_feature.svg image/svg+xml issuetype (null) 110103 Avatar-4.png image/png user (null) 110313 requirement.svg image/svg+xml issuetype (null) 110335 cat.svg image/svg+xml user (null) 110314 sales.svg image/svg+xml issuetype (null) 110336 dog.svg image/svg+xml user (null) 110315 story.svg image/svg+xml issuetype (null) 110337 female_1.svg image/svg+xml user (null) 110316 subtask.svg image/svg+xml issuetype (null) 110338 female_2.svg image/svg+xml user (null) 110318 task.svg image/svg+xml issuetype (null) 110339 female_3.svg image/svg+xml user (null) 110320 question.svg image/svg+xml issuetype (null) 110340 female_4.svg image/svg+xml user (null) 110341 ghost.svg image/svg+xml user (null) 110500 IMG_FIRMAjrvtg.png image/png user debugsac 110342 male_1.svg image/svg+xml user (null) 110343 male_2.svg image/svg+xml user (null) 110344 male_3.svg image/svg+xml user (null) 110345 male_4.svg image/svg+xml user (null) 110104 Avatar-5.png image/png user (null) 110346 male_5.svg image/svg+xml user (null) 110347 male_6.svg image/svg+xml user (null) 110348 male_8.svg image/svg+xml user (null) 110503 bb5cc71d-6bbd-4834-86cf-6a54414d56bf.png image/png project 10103 110349 owl.svg image/svg+xml user (null) 110350 pirate.svg image/svg+xml user (null) 110351 robot.svg image/svg+xml user (null) 110352 vampire.svg image/svg+xml user (null) 110105 Avatar-6.png image/png user (null) 110106 Avatar-7.png image/png user (null) 110107 Avatar-8.png image/png user (null) 110108 Avatar-9.png image/png user (null) 110109 Avatar-10.png image/png user (null) 110110 Avatar-11.png image/png user (null) 110111 Avatar-12.png image/png user (null) 110112 Avatar-13.png image/png user (null) 110113 Avatar-14.png image/png user (null) 110114 Avatar-15.png image/png user (null) 110115 Avatar-16.png image/png user (null) 110116 Avatar-17.png image/png user (null) 110117 Avatar-18.png image/png user (null) 110118 Avatar-19.png image/png user (null) 110119 Avatar-20.png image/png user (null) 110321 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 110503 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.
It looks like you're new here. Sign in or register to get started.