You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openmeetings.apache.org by "Maxim Solodovnik (Jira)" <ji...@apache.org> on 2022/06/28 08:49:00 UTC
[jira] [Created] (OPENMEETINGS-2745) RoomFiles are missing some times
| ![](cid:jira-generated-image-avatar-9911af25-b23b-408c-84f6-2fdad3fd2a7c) |
[Maxim
Solodovnik](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=solomax)
**created** an issue
---|---
|
---
| [Openmeetings](https://issues.apache.org/jira/browse/OPENMEETINGS) /
[![Bug](cid:jira-generated-image-
avatar-e2bcd1c1-dc69-496f-835a-c3b1c3f67e03)](https://issues.apache.org/jira/browse/OPENMEETINGS-2745)
[OPENMEETINGS-2745](https://issues.apache.org/jira/browse/OPENMEETINGS-2745)
---
[RoomFiles are missing some
times](https://issues.apache.org/jira/browse/OPENMEETINGS-2745)
| Issue Type: | ![Bug](cid:jira-generated-image-
avatar-e2bcd1c1-dc69-496f-835a-c3b1c3f67e03) Bug
---|---
Affects Versions: | 6.3.0
Assignee: | [Maxim
Solodovnik](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=solomax)
Components: | Room, WhiteBoard
Created: | 28/Jun/22 08:48
Fix Versions: | 7.0.0
Priority: | ![Major](cid:jira-generated-image-static-
major-7bae9568-dd85-41ff-b217-ce30618f5e2e) Major
Reporter: | [Maxim
Solodovnik](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=solomax)
|
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.
| | [ ![Add Comment](cid:jira-generated-image-static-comment-
icon-e4119668-8a6c-4f94-8e52-155cd2eaeeb4)
](https://issues.apache.org/jira/browse/OPENMEETINGS-2745#add-comment "Add
Comment") | [Add
Comment](https://issues.apache.org/jira/browse/OPENMEETINGS-2745#add-comment
"Add Comment")
---|---
| This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9) | |
![Atlassian logo](https://issues.apache.org/jira/images/mail/atlassian-email-
logo.png)
---