Cannot return null for non-nullable field WorkltemTimelog.user

Summary

We use the Graphql API to get all the timelog entries from the issues to feed our worktime solution. After the deletion of an user which had spend some time on an issue, we see now errors in the UI when we open such an issue.

Steps to reproduce

Create a new user
Log time to an issue
Delete the user
Open the issue

Example Project

I created another user now I'm waiting for the deletion:

asta1992/test#1

What is the current bug behavior?

UI error as soon the User deletion is done. See the screenshot from below.

What is the expected correct behavior?

The Ghost User should be valid as timelog entry.

Relevant logs and/or screenshots

Output of checks

Results of GitLab environment info

Expand for output related to GitLab environment info


(For installations with omnibus-gitlab package run and paste the output of:
`sudo gitlab-rake gitlab:env:info`)
Helm installation:

```
System:
Current User:	git
Using RVM:	no
Ruby Version:	3.1.5p253
Gem Version:	3.5.11
Bundler Version:2.5.11
Rake Version:	13.0.6
Redis Version:	7.0.15
Sidekiq Version:7.1.6
Go Version:	unknown

GitLab information
Version:	17.1.2-ee
Revision:	91c6434080c
Directory:	/srv/gitlab
DB Adapter:	PostgreSQL
DB Version:	14.8
URL:		https://gitlab.
HTTP Clone URL:	https://gitlab./some-group/some-project.git
SSH Clone URL:	git@gitlab.:some-group/some-project.git
Elasticsearch:	no
Geo:		no
Using LDAP:	yes
Using Omniauth:	no

GitLab Shell
Version:	14.36.0
Repository storages:
- default: 	tcp://gitlab-gitaly-0.gitlab-gitaly.gitlab.svc:8075
GitLab Shell path:		/home/git/gitlab-shell

Gitaly
- default Address: 	tcp://gitlab-gitaly-0.gitlab-gitaly.gitlab.svc:8075
- default Version: 	17.1.2
- default Git Version: 	2.45.1
```


(For installations from source run and paste the output of:
`sudo -u git -H bundle exec rake gitlab:env:info RAILS_ENV=production`)

Results of GitLab application Check

Expand for output related to the GitLab application check

(For installations with omnibus-gitlab package run and paste the output of: sudo gitlab-rake gitlab:check SANITIZE=true)

Helm installation:

git@gitlab-toolbox-6f65c58db6-dc2k5:/$ gitlab-rake gitlab:check SANITIZE=true
Checking GitLab subtasks ...

Checking GitLab Shell ...

GitLab Shell: ... GitLab Shell version >= 14.36.0 ? ... OK (14.36.0)
Running /home/git/gitlab-shell/bin/check
gitlab-shell self-check failed
  Try fixing it:
  Make sure GitLab is running;
  Check the gitlab-shell configuration file:
  sudo -u git -H editor /home/git/gitlab-shell/config.yml
  Please fix the error above and rerun the checks.

Checking GitLab Shell ... Finished

Checking Gitaly ...

Gitaly: ... default ... OK

Checking Gitaly ... Finished

Checking Sidekiq ...

Sidekiq: ... Running? ... no
  Try fixing it:
  sudo -u git -H RAILS_ENV=production bin/background_jobs start
  For more information see:
  doc/install/installation.md in section "Install Init Script"
  see log/sidekiq.log for possible errors
  Please fix the error above and rerun the checks.

Checking Sidekiq ... Finished

Checking Incoming Email ...

Incoming Email: ... Reply by email is disabled in config/gitlab.yml

Checking Incoming Email ... Finished

Checking LDAP ...

LDAP: ... Server: ldapmain
not verifying SSL hostname of LDAPS server 'ldapproxy....:636'
LDAP authentication... Success
LDAP users with access to your GitLab server (only showing the first 100 results)
	User output sanitized. Found 28 users of 100 limit.

Checking LDAP ... Finished

Checking GitLab App ...

Database config exists? ... yes
Tables are truncated? ... skipped
All migrations up? ... yes
Database contains orphaned GroupMembers? ... no
GitLab config exists? ... yes
GitLab config up to date? ... yes
Cable config exists? ... yes
Resque config exists? ... yes
Log directory writable? ... yes
Tmp directory writable? ... yes
Uploads directory exists? ... yes
Uploads directory has correct permissions? ... yes
Uploads directory tmp has correct permissions? ... skipped (no tmp uploads folder yet)
Systemd unit files or init script exist? ... no
  Try fixing it:
  Install the Service
  For more information see:
  doc/install/installation.md in section "Install the Service"
  Please fix the error above and rerun the checks.
Systemd unit files or init script up-to-date? ... can't check because of previous errors
Projects have namespace: ...
2/1 ... yes
5/2 ... yes
5/3 ... yes
5/7 ... yes
5/8 ... yes
5/9 ... yes
5/10 ... yes
305/11 ... yes
305/12 ... yes
5/14 ... yes
307/15 ... yes
554/19 ... yes
252/20 ... yes
252/21 ... yes
298/26 ... yes
10/33 ... yes
10/34 ... yes
10/35 ... yes
10/36 ... yes
10/38 ... yes
308/49 ... yes
78/50 ... yes
78/51 ... yes
78/52 ... yes
78/53 ... yes
78/54 ... yes
78/57 ... yes
78/58 ... yes
78/60 ... yes
78/61 ... yes
78/63 ... yes
5/65 ... yes
5/66 ... yes
554/70 ... yes
329/73 ... yes
7/74 ... yes
117/75 ... yes
78/76 ... yes
78/77 ... yes
78/82 ... yes
78/83 ... yes
131/84 ... yes
131/85 ... yes
131/86 ... yes
1096/87 ... yes
131/88 ... yes
131/89 ... yes
131/90 ... yes
131/91 ... yes
140/92 ... yes
140/93 ... yes
140/94 ... yes
140/95 ... yes
140/96 ... yes
140/97 ... yes
140/98 ... yes
140/99 ... yes
140/100 ... yes
140/101 ... yes
140/102 ... yes
140/103 ... yes
140/104 ... yes
140/105 ... yes
140/106 ... yes
140/107 ... yes
99/108 ... yes
165/114 ... yes
897/115 ... yes
897/116 ... yes
897/117 ... yes
165/118 ... yes
897/119 ... yes
897/120 ... yes
140/121 ... yes
332/122 ... yes
180/123 ... yes
180/124 ... yes
5/125 ... yes
329/126 ... yes
306/127 ... yes
99/128 ... yes
330/130 ... yes
140/134 ... yes
195/135 ... yes
198/136 ... yes
140/137 ... yes
5/138 ... yes
113/142 ... yes
131/143 ... yes
110/144 ... yes
140/145 ... yes
897/146 ... yes
73/147 ... yes
214/148 ... yes
547/149 ... yes
217/150 ... yes
105/152 ... yes
10/153 ... yes
10/154 ... yes
10/155 ... yes
10/156 ... yes
10/157 ... yes
10/158 ... yes
10/159 ... yes
10/160 ... yes
10/161 ... yes
10/162 ... yes
10/164 ... yes
10/165 ... yes
10/166 ... yes
10/167 ... yes
10/168 ... yes
10/169 ... yes
292/170 ... yes
292/171 ... yes
246/173 ... yes
117/174 ... yes
250/176 ... yes
159/177 ... yes
179/178 ... yes
298/179 ... yes
131/182 ... yes
5/183 ... yes
5/184 ... yes
5/185 ... yes
268/187 ... yes
270/188 ... yes
5/189 ... yes
277/191 ... yes
277/192 ... yes
281/193 ... yes
281/196 ... yes
195/198 ... yes
281/199 ... yes
281/200 ... yes
113/202 ... yes
113/203 ... yes
214/205 ... yes
292/206 ... yes
110/207 ... yes
311/208 ... yes
5/210 ... yes
5/211 ... yes
331/213 ... yes
217/214 ... yes
5/216 ... yes
319/217 ... yes
281/218 ... yes
311/219 ... yes
83/220 ... yes
131/221 ... yes
10/222 ... yes
10/223 ... yes
198/224 ... yes
198/225 ... yes
198/226 ... yes
198/227 ... yes
281/228 ... yes
338/229 ... yes
340/230 ... yes
340/231 ... yes
340/232 ... yes
340/233 ... yes
340/234 ... yes
346/235 ... yes
10/236 ... yes
19/238 ... yes
116/239 ... yes
298/240 ... yes
281/242 ... yes
109/244 ... yes
140/245 ... yes
214/246 ... yes
109/247 ... yes
110/248 ... yes
131/249 ... yes
214/250 ... yes
319/251 ... yes
292/252 ... yes
373/253 ... yes
140/254 ... yes
376/255 ... yes
464/256 ... yes
528/257 ... yes
110/258 ... yes
180/259 ... yes
416/260 ... yes
387/261 ... yes
131/262 ... yes
305/263 ... yes
217/264 ... yes
330/265 ... yes
387/266 ... yes
201/267 ... yes
10/268 ... yes
10/270 ... yes
305/273 ... yes
473/274 ... yes
354/275 ... yes
195/277 ... yes
281/278 ... yes
412/279 ... yes
414/280 ... yes
416/281 ... yes
140/282 ... yes
311/283 ... yes
140/289 ... yes
140/290 ... yes
83/291 ... yes
414/292 ... yes
110/293 ... yes
458/294 ... yes
523/295 ... yes
198/297 ... yes
198/298 ... yes
442/299 ... yes
442/300 ... yes
445/301 ... yes
38/302 ... yes
4/303 ... yes
217/304 ... yes
4/305 ... yes
452/306 ... yes
62/307 ... yes
195/308 ... yes
458/309 ... yes
454/310 ... yes
265/311 ... yes
281/312 ... yes
464/313 ... yes
8/314 ... yes
454/316 ... yes
5/317 ... yes
198/319 ... yes
463/320 ... yes
10/323 ... yes
454/324 ... yes
10/325 ... yes
19/326 ... yes
5/327 ... yes
338/328 ... yes
5/329 ... yes
493/330 ... yes
40/331 ... yes
442/333 ... yes
499/334 ... yes
499/335 ... yes
502/336 ... yes
214/337 ... yes
308/338 ... yes
307/339 ... yes
198/340 ... yes
5/341 ... yes
454/342 ... yes
454/343 ... yes
512/344 ... yes
512/345 ... yes
552/346 ... yes
5/347 ... yes
131/348 ... yes
311/349 ... yes
346/350 ... yes
414/351 ... yes
346/352 ... yes
523/353 ... yes
311/354 ... yes
493/355 ... yes
109/356 ... yes
528/357 ... yes
292/358 ... yes
564/359 ... yes
281/360 ... yes
265/361 ... yes
109/362 ... yes
5/363 ... yes
537/364 ... yes
564/366 ... yes
201/367 ... yes
140/368 ... yes
117/369 ... yes
8/370 ... yes
109/371 ... yes
555/372 ... yes
555/373 ... yes
554/374 ... yes
109/375 ... yes
110/377 ... yes
565/378 ... yes
330/379 ... yes
554/382 ... yes
554/383 ... yes
554/384 ... yes
575/385 ... yes
575/386 ... yes
575/387 ... yes
575/388 ... yes
554/389 ... yes
554/390 ... yes
554/391 ... yes
554/392 ... yes
40/393 ... yes
575/394 ... yes
575/395 ... yes
575/396 ... yes
555/397 ... yes
19/398 ... yes
565/399 ... yes
555/400 ... yes
555/401 ... yes
555/402 ... yes
311/403 ... yes
595/404 ... yes
292/406 ... yes
78/407 ... yes
602/408 ... yes
602/409 ... yes
602/410 ... yes
602/411 ... yes
602/412 ... yes
602/414 ... yes
602/415 ... yes
602/416 ... yes
10/417 ... yes
575/418 ... yes
602/419 ... yes
5/420 ... yes
131/421 ... yes
602/422 ... yes
5/423 ... yes
5/424 ... yes
376/425 ... yes
376/426 ... yes
165/427 ... yes
165/428 ... yes
165/429 ... yes
575/430 ... yes
554/431 ... yes
641/432 ... yes
454/433 ... yes
311/434 ... yes
110/435 ... yes
7/436 ... yes
311/437 ... yes
575/438 ... yes
575/439 ... yes
575/440 ... yes
982/441 ... yes
555/442 ... yes
311/443 ... yes
270/444 ... yes
330/446 ... yes
575/448 ... yes
547/449 ... yes
665/450 ... yes
547/451 ... yes
104/452 ... yes
104/453 ... yes
104/454 ... yes
307/455 ... yes
307/456 ... yes
270/457 ... yes
270/458 ... yes
131/459 ... yes
103/460 ... yes
319/461 ... yes
664/462 ... yes
78/463 ... yes
78/464 ... yes
665/465 ... yes
575/466 ... yes
195/467 ... yes
641/469 ... yes
575/470 ... yes
555/471 ... yes
195/472 ... yes
195/473 ... yes
4/474 ... yes
680/475 ... yes
682/476 ... yes
10/477 ... yes
575/479 ... yes
575/480 ... yes
546/481 ... yes
493/482 ... yes
554/483 ... yes
554/484 ... yes
554/485 ... yes
198/486 ... yes
555/487 ... yes
546/488 ... yes
319/489 ... yes
554/490 ... yes
387/491 ... yes
554/492 ... yes
40/493 ... yes
704/494 ... yes
704/495 ... yes
575/496 ... yes
709/497 ... yes
707/498 ... yes
330/499 ... yes
714/500 ... yes
554/501 ... yes
717/502 ... yes
680/503 ... yes
680/504 ... yes
493/506 ... yes
717/507 ... yes
717/508 ... yes
641/509 ... yes
717/510 ... yes
717/511 ... yes
281/512 ... yes
319/513 ... yes
575/514 ... yes
575/515 ... yes
575/516 ... yes
575/517 ... yes
554/520 ... yes
319/521 ... yes
493/523 ... yes
493/524 ... yes
493/525 ... yes
554/526 ... yes
493/527 ... yes
493/528 ... yes
493/529 ... yes
493/530 ... yes
493/531 ... yes
641/532 ... yes
493/533 ... yes
493/534 ... yes
493/535 ... yes
307/536 ... yes
268/537 ... yes
764/538 ... yes
10/539 ... yes
198/540 ... yes
575/542 ... yes
554/543 ... yes
7/544 ... yes
198/545 ... yes
641/546 ... yes
641/547 ... yes
641/548 ... yes
641/549 ... yes
256/550 ... yes
707/551 ... yes
707/552 ... yes
641/553 ... yes
641/554 ... yes
641/555 ... yes
641/556 ... yes
641/557 ... yes
641/558 ... yes
641/559 ... yes
641/560 ... yes
641/561 ... yes
641/562 ... yes
641/563 ... yes
641/564 ... yes
257/565 ... yes
641/566 ... yes
641/567 ... yes
641/568 ... yes
641/569 ... yes
641/570 ... yes
641/571 ... yes
641/572 ... yes
641/573 ... yes
641/574 ... yes
641/575 ... yes
641/576 ... yes
641/577 ... yes
641/578 ... yes
641/579 ... yes
641/580 ... yes
641/581 ... yes
641/582 ... yes
641/583 ... yes
641/584 ... yes
641/585 ... yes
641/586 ... yes
641/587 ... yes
641/588 ... yes
641/589 ... yes
641/590 ... yes
641/591 ... yes
641/592 ... yes
641/593 ... yes
641/594 ... yes
641/595 ... yes
641/596 ... yes
641/597 ... yes
641/598 ... yes
641/599 ... yes
641/600 ... yes
641/601 ... yes
641/602 ... yes
641/603 ... yes
641/604 ... yes
641/605 ... yes
641/606 ... yes
641/607 ... yes
641/608 ... yes
641/609 ... yes
641/610 ... yes
641/611 ... yes
641/612 ... yes
641/613 ... yes
641/614 ... yes
641/615 ... yes
641/616 ... yes
641/617 ... yes
641/618 ... yes
641/619 ... yes
641/620 ... yes
641/621 ... yes
641/622 ... yes
641/623 ... yes
641/624 ... yes
641/625 ... yes
641/626 ... yes
641/627 ... yes
641/628 ... yes
641/629 ... yes
641/630 ... yes
641/631 ... yes
641/632 ... yes
641/633 ... yes
641/634 ... yes
641/635 ... yes
641/636 ... yes
641/637 ... yes
641/638 ... yes
641/639 ... yes
641/640 ... yes
641/641 ... yes
641/642 ... yes
641/643 ... yes
641/644 ... yes
641/645 ... yes
641/646 ... yes
641/647 ... yes
641/648 ... yes
641/649 ... yes
641/650 ... yes
641/651 ... yes
641/652 ... yes
882/653 ... yes
882/654 ... yes
680/655 ... yes
110/656 ... yes
268/657 ... yes
40/658 ... yes
641/659 ... yes
641/660 ... yes
5/661 ... yes
354/662 ... yes
195/664 ... yes
131/665 ... yes
901/666 ... yes
10/667 ... yes
387/668 ... yes
905/669 ... yes
376/670 ... yes
376/671 ... yes
257/672 ... yes
195/673 ... yes
554/675 ... yes
554/676 ... yes
554/677 ... yes
915/678 ... yes
165/679 ... yes
554/680 ... yes
5/681 ... yes
307/682 ... yes
921/683 ... yes
921/684 ... yes
547/685 ... yes
547/686 ... yes
547/687 ... yes
547/688 ... yes
547/689 ... yes
982/690 ... yes
7/691 ... yes
547/692 ... yes
547/693 ... yes
547/695 ... yes
547/696 ... yes
554/698 ... yes
198/699 ... yes
547/700 ... yes
547/701 ... yes
547/702 ... yes
547/703 ... yes
547/704 ... yes
547/705 ... yes
547/706 ... yes
547/707 ... yes
547/708 ... yes
547/709 ... yes
547/710 ... yes
547/711 ... yes
547/712 ... yes
547/713 ... yes
547/714 ... yes
547/715 ... yes
547/716 ... yes
547/717 ... yes
547/718 ... yes
547/719 ... yes
547/720 ... yes
547/721 ... yes
547/722 ... yes
547/723 ... yes
547/724 ... yes
547/725 ... yes
547/726 ... yes
547/727 ... yes
547/728 ... yes
547/729 ... yes
547/730 ... yes
547/731 ... yes
319/732 ... yes
131/733 ... yes
195/734 ... yes
265/735 ... yes
311/736 ... yes
311/737 ... yes
311/738 ... yes
311/739 ... yes
311/740 ... yes
982/742 ... yes
986/743 ... yes
201/744 ... yes
19/745 ... yes
195/746 ... yes
276/747 ... yes
707/748 ... yes
73/749 ... yes
73/750 ... yes
73/751 ... yes
105/752 ... yes
105/753 ... yes
105/754 ... yes
105/755 ... yes
105/756 ... yes
105/757 ... yes
105/758 ... yes
105/759 ... yes
272/760 ... yes
40/761 ... yes
40/762 ... yes
40/763 ... yes
40/764 ... yes
40/765 ... yes
40/766 ... yes
40/767 ... yes
40/768 ... yes
40/769 ... yes
40/770 ... yes
40/771 ... yes
40/772 ... yes
40/773 ... yes
40/774 ... yes
40/775 ... yes
40/776 ... yes
116/777 ... yes
116/778 ... yes
116/779 ... yes
116/780 ... yes
116/781 ... yes
354/782 ... yes
99/783 ... yes
99/784 ... yes
62/785 ... yes
62/786 ... yes
109/787 ... yes
109/788 ... yes
109/789 ... yes
109/790 ... yes
729/791 ... yes
729/792 ... yes
729/793 ... yes
7/794 ... yes
7/795 ... yes
7/796 ... yes
7/797 ... yes
7/798 ... yes
7/799 ... yes
114/800 ... yes
114/801 ... yes
114/802 ... yes
114/803 ... yes
114/804 ... yes
187/805 ... yes
187/806 ... yes
38/807 ... yes
626/808 ... yes
626/809 ... yes
626/810 ... yes
626/811 ... yes
626/812 ... yes
626/813 ... yes
276/814 ... yes
258/815 ... yes
371/816 ... yes
289/817 ... yes
986/818 ... yes
281/819 ... yes
680/820 ... yes
1073/821 ... yes
1075/822 ... yes
270/823 ... yes
454/824 ... yes
4/825 ... yes
195/826 ... yes
1081/827 ... yes
1083/828 ... yes
1083/829 ... yes
1083/830 ... yes
1081/831 ... yes
268/832 ... yes
29/834 ... yes
319/835 ... yes
38/836 ... yes
1096/837 ... yes
73/838 ... yes
78/839 ... yes
882/840 ... yes
195/841 ... yes
307/842 ... yes
311/843 ... yes
7/844 ... yes
982/845 ... yes
Redis version >= 6.2.14? ... no
  Try fixing it:
  Your Redis version 6.2.7 has reached end-of-life (EOL). Update your Redis server to a version >= 6.2.14
  For more information see:
  doc/administration/redis/index.html#redis-replication-and-failover-using-the-non-bundled-redis
  Please fix the error above and rerun the checks.
Ruby version >= 3.0.6 ? ... yes (3.1.5)
Git user has default SSH configuration? ... yes
Active users: ... 89
Is authorized keys file accessible? ... skipped (authorized keys not enabled)
GitLab configured to store new projects in hashed storage? ... yes
All projects are in hashed storage? ... yes
Elasticsearch version 7.x-8.x or OpenSearch version 1.x ... skipped (Advanced Search is disabled)
All migrations must be finished before doing a major upgrade ... skipped (Advanced Search is disabled)

Checking GitLab App ... Finished


Checking GitLab subtasks ... Finished

(we will only investigate if the tests are passing)