### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [10월 5, 2016, 10:22오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/6 "2016-10-05T22:22:25Z")
Looks like this instance has been upgraded a few times and now somehow a bunch of data ins missing in the user summary table or something.
So first step, can you update to latest
```plaintext
cd /var/discourse
git pull
./launcher rebuild app
```
If still an issue after upgrade
```plaintext
./launcher enter app
rails c
% u = User.find(USER_ID_HERE)
% u.build_user_stat.save
```
Where USER\_ID\_HERE is the id of the problem user.
---
### Author:  [@corillian](https://meta.discourse.org/u/corillian)
#### Post date: [10월 5, 2016, 10:34오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/7 "2016-10-05T22:34:13Z")
Yeah it’s been around 2-3 years now - since the beta. I just rebuilt/upgraded Discourse to the latest commit this morning so all of the logs I posted are from that version. After entering my app I tried executing the code you provided both on bash and in irb and both gave me errors:
bash:
```plaintext
/var/www/discourse# u = User.find(3530)
bash: syntax error near unexpected token `('
```
irb:
```plaintext
irb(main):002:0> u = User.find(3530)
NameError: uninitialized constant User
from (irb):2
from /usr/local/bin/irb:11:in `'
```
Where and with what exactly am I supposed to execute those commands?
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [10월 5, 2016, 10:50오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/8 "2016-10-05T22:50:15Z")
Sorry, forgot a rails c there, fixed it up 🙂
---
### Author:  [@corillian](https://meta.discourse.org/u/corillian)
#### Post date: [10월 5, 2016, 11:06오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/9 "2016-10-05T23:06:17Z")
Ah thank you that worked =). Unfortunately I got another error once I executed `u.build_user_stat.save`:
```plaintext
ActiveRecord::StatementInvalid: PG::NotNullViolation: ERROR: null value in colu mn "new_since" violates not-null constraint
DETAIL: Failing row contains (3530, 0, 0, 0, 0, 0, 0, 0, null, null, null, 0, 0 , 0, null).
: INSERT INTO "user_stats" ("user_id") VALUES (3530) RETURNING "user_id"
from /var/www/discourse/vendor/bundle/ruby/2.3.0/gems/rack-mini-profiler-0.10.1/ lib/patches/db/pg.rb:90:in `exec'
```
For what it’s worth I checked `user_stats` and the user already has an entry in the table. I tried to locate `build_user_stat` in the Discourse code but I couldn’t find it anywhere?
---
### Author:  [@corillian](https://meta.discourse.org/u/corillian)
#### Post date: [10월 6, 2016, 4:29오전 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/10 "2016-10-06T04:29:06Z")
Ok I found the answer to my question about `build_user_stat` here: [http://stackoverflow.com/questions/783584/ruby-on-rails-how-do-i-use-the-active-record-build-method-in-a-belongs-to-rel](http://stackoverflow.com/questions/783584/ruby-on-rails-how-do-i-use-the-active-record-build-method-in-a-belongs-to-rel)
After investigating this some more it does seem that most of the problems are with the `user_stat` table. What I don’t understand is that this problem is affecting only one user and on top of that he’s had an entry in `user_stat` the entire time. In fact he was one of my most active users up until Discourse recently decided it had enough of him 😛.
What’s more disturbing is that it looks like whatever is causing his `user_stat` to fail to load is inside of the black box that is the Rails ActiveRecord ORM. This seems to even apply to creating a new entry via your suggested `build_user_stat.save`. I don’t see any obvious point of conflict in the logic of Discourse code.
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [10월 6, 2016, 6:52오전 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/11 "2016-10-06T06:52:37Z")
I have never seen this issue and it is very hard for me to diagnose without a DB dump. Is said user banned or deleted or something?
---
### Author:  [@corillian](https://meta.discourse.org/u/corillian)
#### Post date: [10월 6, 2016, 9:02오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/12 "2016-10-06T21:02:29Z")
The user was neither banned or deleted - again he’s one of our most active users. I can provide you with a DB dump, how would you like to handle that?
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [11월 16, 2016, 11:24오후 UTC](https://meta.discourse.org/t/sidekiq-jobs-are-failing-for-1-of-my-users/51143/13 "2016-11-16T23:24:03Z")
Database was apparently corrupted. @corillian managed to restore it on another server and everything is fine now.