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

CONNECT engine table_type=JDBC very broken on 10.1.27 hangs SUSPECT POOLING

Details

    Description

      I just upgraded from 10.1.26 (very stable) to 10.1.27 and CONNECT with JDBC table types is now hanging The first few requests work, but then it hangs. Suspect this is somehow related to pooling (ApacheWrapper) since recreating the tables without pooling seems to eliminate the error.

      With pooling ON it seems to hang after maybe 8 to 10 queries. No error, just never returns. This would seem to correspond roughly to the default number of connections in the Apache pool. So suspect connections are no longer being free'ed aka closed.

      Non-connect tables CAN be queried.

      When I turn OFF pooling for the tables - i.e. recreate them without using the ApacheWrapper the system does not appear to hang (50 queries and still ok). So my wild guess is that something changed with how ApacheWrapper works, or possibly since the connections need to go back in the pool, maybe the connections in 10.1.27 are not getting a connection.close() or something.

      Attachments

        Activity

          Version 10.1.27 was recalled because of regression errors. Stay with MariaDB 10.1.26 until 10.1.28 is released.

          bertrandop Olivier Bertrand added a comment - Version 10.1.27 was recalled because of regression errors. Stay with MariaDB 10.1.26 until 10.1.28 is released.

          Indeed, this is a regression bug. Thanks for reporting, it will be fixed asap.

          bertrandop Olivier Bertrand added a comment - Indeed, this is a regression bug. Thanks for reporting, it will be fixed asap.
          bertrandop Olivier Bertrand added a comment - - edited

          Will be fixed later for 10.2 and 10.3 because of other pending changes.
          Done.

          bertrandop Olivier Bertrand added a comment - - edited Will be fixed later for 10.2 and 10.3 because of other pending changes. Done.

          People

            bertrandop Olivier Bertrand
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.