Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38669

Startup hangs waiting for table metadata lock when auto.ddl=true

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.8 [Tentative]
    • Fix Version/s: 11.5 [Tentative], 12.0
    • Component/s: Kernel
    • Labels:
      None
    • 11 status:
      Resolved
    • 10 status:
      Please Merge
    • Previous Issue Keys:
      KNL-1478

      Description

      This appears to be a regression in 10.x from r325297 from KNL-1436.

      When auto.ddl = true, Sakai startup hangs because of a mysql lock:

      Query | 21 | Waiting for table metadata lock | CREATE TABLE SAKAI_SESSION ( SESSION_ID VARCHAR (36), SESSION_SERVER VARCHAR (64), SESSION_USER VARCHAR (99), SESSION_IP VARCHAR (128), SESSION_HOSTNAME VARCHAR (255), SESSION_USER_AGENT VARCHAR (255), SESSION_START TIMESTAMP, SESSION_END TIMESTAMP, SESSION_ACTIVE tinyint(1) ) |

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  k1team KERNEL TEAM (Inactive)
                  Reporter:
                  smarquard Stephen Marquard
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code