Uploaded image for project: 'Openmeetings'
  1. Openmeetings
  2. OPENMEETINGS-2745

RoomFiles are missing some times

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 6.3.0
    • 7.0.0
    • Room, WhiteBoard
    • 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.

      Attachments

        Activity

          People

            solomax Maxim Solodovnik
            solomax Maxim Solodovnik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: