Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11176

FTWRL on a non-replication server reports state "Waiting while replication worker thread pool is busy"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 11.4.5, 11.7.2
    • Locking, Replication
    • None

    Description

      The test case is for reproducing purposes only, don't put it into the regression suite!

      --connect(con1,localhost,root,,)
      --let $conid= `select connection_id()`
      --delimiter $
      --send
        LOOP FLUSH TABLES WITH READ LOCK ; END LOOP $
      --delimiter ;
       
      --connection default
       
      while (! $res)
      {
        --let $res= `select * from information_schema.processlist where state = 'Waiting while replication worker thread pool is busy'`
      }
       
      --echo $res
      --eval kill $conid
      

      10.5 7c052cdf

      connect con1,localhost,root,,;
      LOOP FLUSH TABLES WITH READ LOCK ; END LOOP $
      connection default;
      5	root	localhost	test	Query	0	Waiting while replication worker thread pool is busy	FLUSH TABLES WITH READ LOCK	0.060	0	0	0.000	75928	81072	0	186	FLUSH TABLES WITH READ LOCK	2476401
      kill 5;
      

      I don't know whether it should be happening, it seems weird.

      Attachments

        Activity

          People

            knielsen Kristian Nielsen
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.