Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
6.3.0
-
None
Description
From mailing list: https://lists.apache.org/thread/76tz2r8n77s9w04v4m8jnmhdd8s0cpgf
Steps to reproduce:
ADDITIONAL TESTING:
STEP 1:
I added 13 whiteboards in the "Files"section as stated above
Indices:
0,1,2,3,4,5,6,7,8,9,10,11,12
STEP 2:
Stop/start OM-Tomcat
STEP 3:
Starting the client.
Missing indeces:
4, 8, 10
STEP 4:
Stop/start OM-Tomcat
STEP 5:
Starting the client.
Missing indeces:
6,4
STEP 6:
Stop/start OM-Tomcat
STEP 7:
Starting the client.
Missing indeces:
5,8,9
STEP 8:
Stop/start OM-Tomcat
STEP 9:
Starting the client.
Missing indeces:
12
NOTE:
Missing index always means that
the whiteboard is visible but it's empty.
EVALUATION:
The probability is rather high
that this is not a database inconsistency
problem.
ACTION PLAN:
I'm going to install a clean and latest
OM on a local Ubuntu server in one or two weeks.
If you can tell me which is the relevant Java module
maybe I can test it earlier than that.
This was the room table for my test:
-------------------------+
| id | room_id | wb_idx | file_id |
-------------------------+
| 1 | 2 | 2 | 125 |
| 2 | 9 | 1 | 126 |
| 89 | 11 | 0 | 151 |
| 90 | 11 | 1 | 152 |
| 91 | 11 | 2 | 153 |
| 92 | 11 | 3 | 154 |
| 93 | 11 | 4 | 155 |
| 94 | 11 | 5 | 156 |
| 98 | 11 | 9 | 162 |
| 99 | 11 | 10 | 163 |
| 100 | 11 | 11 | 165 |
| 101 | 11 | 12 | 166 |
| 102 | 11 | 13 | 167 |
| 103 | 11 | 8 | 161 |
| 104 | 11 | 14 | 168 |
| 105 | 11 | 15 | 169 |
| 106 | 11 | 16 | 170 |
| 107 | 11 | 17 | 171 |
| 108 | 11 | 18 | 172 |
| 109 | 11 | 19 | 173 |
| 130 | 7 | 0 | 198 |
| 131 | 7 | 1 | 199 |
| 132 | 7 | 2 | 201 |
| 133 | 7 | 3 | 200 |
| 134 | 7 | 4 | 202 |
| 135 | 7 | 5 | 203 |
| 136 | 7 | 6 | 204 |
| 137 | 7 | 7 | 205 |
| 138 | 7 | 8 | 206 |
| 139 | 7 | 9 | 207 |
| 152 | 8 | 0 | 23 |
| 170 | 8 | 1 | 7 |
| 171 | 8 | 2 | 12 |
| 172 | 8 | 3 | 13 |
| 173 | 8 | 4 | 212 |
| 174 | 8 | 5 | 183 |
| 175 | 8 | 6 | 184 |
| 176 | 8 | 7 | 209 |
| 183 | 8 | 8 | 186 |
| 184 | 8 | 9 | 187 |
| 185 | 8 | 10 | 188 |
| 186 | 8 | 11 | 189 |
| 187 | 8 | 12 | 55 |
-------------------------+
The table above contains the initial state
after restarting OM-Tomcat.
Where do we store the information about
the set of whiteboards that are actually
on the wall in a given classroom.
I mean the the list of active whiteboards
in a given room.