[jira] [Created] (OPENMEETINGS-2745) RoomFiles are missing some times

[Maxim Solodovnik (Jira)]

Title: Message Title

Maxim Solodovnik created an issue   Openmeetings / OPENMEETINGS-2745 RoomFiles are missing some times Issue Type: Bug Affects Versions: 6.3.0 Assignee: Maxim Solodovnik Components: Room, WhiteBoard Created: 28/Jun/22 08:48 Fix Versions: 7.0.0 Priority: Major Reporter: Maxim Solodovnik 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   This message was sent by Atlassian Jira (v8.20.10#820010-sha1:ace47f9)