Opened on 07/10/2015 at 05:41:30 PM
Closed on 07/14/2015 at 02:28:44 PM
Last modified on 07/14/2015 at 02:29:03 PM
#2771 closed defect (fixed)
Repair and clean-up Trac database
Reported by: | matze | Assignee: | matze |
---|---|---|---|
Priority: | P3 | Milestone: | |
Module: | Infrastructure | Keywords: | |
Cc: | fred, Kirill | Blocked By: | #2586 |
Blocking: | Platform: | Unknown / Cross platform | |
Ready: | yes | Confidential: | no |
Tester: | Unknown | Verified working: | no |
Review URL(s): |
Description
During #2586, we've discovered that our trac database records are not consistent. It seems like there are some minor discrepancies, e.g.:
mysql> select count(sid), name from session_attribute where name in ("name", "password", "email") group by name; +------------+--------------------------+ | count(sid) | name | +------------+--------------------------+ | 40475 | email | | 40175 | name | | 40474 | password | +------------+--------------------------+ 5 rows in set (4.23 sec)
One would expect the count to be equal here. While this can probably be explained with some network issues and bugs over the years and may not require an in-depth investigation, but we should try to fix the records, at least.
Attachments (0)
Change History (4)
comment:1 Changed on 07/14/2015 at 02:26:45 PM by matze
- Owner set to matze
comment:2 Changed on 07/14/2015 at 02:28:33 PM by matze
comment:3 Changed on 07/14/2015 at 02:28:44 PM by matze
- Resolution set to fixed
- Status changed from new to closed
comment:4 Changed on 07/14/2015 at 02:29:03 PM by matze
- Ready set
Note: See
TracTickets for help on using
tickets.
After #2586, cleanup was quite easy. All accounts now have both a email and a password:
Not every one has a name though.