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.