# \[solved\] New entery in log file every 10 seconds

**URL:** <https://forum.gitea.com/t/solved-new-entery-in-log-file-every-10-seconds/2557>\
**Category:** Install/Maintain/Configure\
**Created:** [October 6, 2020, 8:16am UTC](https://forum.gitea.com/t/solved-new-entery-in-log-file-every-10-seconds/2557 "2020-10-06T08:16:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nixmd](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/nixmd/32/4948_2.png) [@nixmd](https://forum.gitea.com/u/nixmd)\
**Post date:** [October 6, 2020, 8:16am UTC](https://forum.gitea.com/t/solved-new-entery-in-log-file-every-10-seconds/2557/1 "2020-10-06T08:16:47Z")

</div>

I’ve just installed gitea 1.12.4 on ubuntu using SQLite db.  
Today I was checking log file and I have noticed there’s a new log entery in every 10 seconds while server was idle. Here’s a part of it:

```
2020/10/06 11:25:04 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970892 1601970902 1] - 523.744µs
2020/10/06 11:25:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970902 1601970912 1] - 406.76µs
2020/10/06 11:25:24 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970912 1601970922 1] - 527.027µs
2020/10/06 11:25:34 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970922 1601970932 1] - 589.465µs
2020/10/06 11:25:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970932 1601970942 1] - 531.567µs
2020/10/06 11:25:54 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970942 1601970952 1] - 531.986µs
2020/10/06 11:26:04 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970952 1601970962 1] - 548.609µs
2020/10/06 11:26:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970962 1601970972 1] - 572.005µs
2020/10/06 11:26:24 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970972 1601970982 1] - 631.231µs
2020/10/06 11:26:34 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970982 1601970992 1] - 578.575µs
2020/10/06 11:26:44 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601970992 1601971002 1] - 621.109µs
2020/10/06 11:26:54 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601971002 1601971012 1] - 529.476µs
2020/10/06 11:27:04 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601971012 1601971022 1] - 530.314µs
2020/10/06 11:27:14 ...m.io/xorm/core/db.go:154:QueryContext() [I] [SQL] SELECT user_id, count(*) AS count FROM notification WHERE user_id IN (SELECT user_id FROM notification WHERE updated_unix >= ? AND updated_unix < ?) AND status = ? GROUP BY user_id [1601971022 1601971032 1] - 509.501µs

```

What’s this and why is this query executed every 10 seconds? Is this normal?

---

<div class="post-metadata">

**Author:** ![lunny](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/lunny/32/4701_2.png) [@lunny](https://forum.gitea.com/u/lunny)\
**Post date:** [October 8, 2020, 1:46pm UTC](https://forum.gitea.com/t/solved-new-entery-in-log-file-every-10-seconds/2557/2 "2020-10-08T13:46:29Z")

</div>

It’s normal when a user stays in the notification interface.

---

<div class="post-metadata">

**Author:** ![techknowlogick](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/techknowlogick/32/4706_2.png) [@techknowlogick](https://forum.gitea.com/u/techknowlogick)\
**Post date:** [October 14, 2020, 2:08am UTC](https://forum.gitea.com/t/solved-new-entery-in-log-file-every-10-seconds/2557/3 "2020-10-14T02:08:31Z")

</div>