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

After #2586, cleanup was quite easy. All accounts now have both a email and a password:

mysql> select count(sid), name from session_attribute where authenticated=1 and name in ("name", "email", "password") group by name;
+------------+----------+
| count(sid) | name     |
+------------+----------+
|       5702 | email    |
|       5425 | name     |
|       5702 | password |
+------------+----------+

Not every one has a name though.

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

Add Comment

Modify Ticket

Change Properties
Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from matze.
 
Note: See TracTickets for help on using tickets.