indigo-iam/iam

The content of authorization_code table is never cleaned up

Opened this issue · 0 comments

From IAM escape data:

mysql> select count(*) from authorization_code where expiration < NOW();
+----------+
| count(*) |
+----------+
|     2336 |
+----------+
1 row in set (0,01 sec)
mysql> select expiration, count(*) from authorization_code group by expiration ASC limit 10;
+---------------------+----------+
| expiration          | count(*) |
+---------------------+----------+
| 2019-08-15 01:52:23 |        1 |
| 2019-08-15 15:55:04 |        1 |
| 2019-08-15 15:55:21 |        1 |
| 2019-08-15 15:56:48 |        1 |
| 2019-08-15 16:00:20 |        1 |
| 2019-08-15 16:01:18 |        1 |
| 2019-08-15 16:03:50 |        1 |
| 2019-08-15 16:06:44 |        1 |
| 2019-08-15 16:17:39 |        1 |
| 2019-08-15 16:18:16 |        1 |
+---------------------+----------+
10 rows in set, 1 warning (0,03 sec)