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

MariaDB Cluster limit with subqueries

Details

    Description

      We are experiencing issues with creating view with multiple subqueries. The create view statement is in create_view_query.sql. It ran fine when I directly run the select statement against the cluster. When I ran the create view statement, I can select but other actions will hang and timeout. I have to rebuild the cluster in order to fix it. I have tried the method state in this link:
      http://galeracluster.com/documentation-webpages/clusterstallonalter.html

      but it doesn't help.

      Is there any limitation on creating view with multiple subqueries in select statement?

      I have attach all tables' schema as create_view_issue.sql and the server setup as variables.txt.

      Thanks

      Attachments

        Activity

          Descending order - Click to sort in ascending order
          hyphen1370 Xiyi Zhu added a comment -

          Yes, and I also can perform select action against other tables too. However, I couldn't do any insert, update, delete action. They will all hand and execution timeout.

          hyphen1370 Xiyi Zhu added a comment - Yes, and I also can perform select action against other tables too. However, I couldn't do any insert, update, delete action. They will all hand and execution timeout.
          alice Alice Sherepa added a comment -

          Please explain more about your workflow.
          "When I ran the create view statement, I can select but other actions will hang and timeout." - does it mean that the view is created and then select from that view executed without problems? What other actions have you performed?

          alice Alice Sherepa added a comment - Please explain more about your workflow. "When I ran the create view statement, I can select but other actions will hang and timeout." - does it mean that the view is created and then select from that view executed without problems? What other actions have you performed?

          People

            sanja Oleksandr Byelkin
            hyphen1370 Xiyi Zhu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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