Uploaded image for project: 'MariaDB Connector/Python'
  1. MariaDB Connector/Python
  2. CONPY-129

"Commands out of sync; you can't run this command now" when call system tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Not a Bug
    • Affects Version/s: 1.0.4
    • Fix Version/s: N/A
    • Component/s: DBAPI 2.0
    • Labels:
      None
    • Environment:
      MariaDB 10.5.7

      Description

      When I try to get system tables with this sample:

      db_connection = db_connector.connect(....)
      		 
      db_cursor = db_connection.cursor(prepared=True)
      		 
      db_cursor.execute("select version()")
      		 
      server_version = Version(db_cursor.fetchone()[0])
      		 
      db_cursor.execute("SHOW VARIABLES like 'have_ssl'")
      		 
      have_ssl = str2bool(db_cursor.fetchone()[1], raise_exc=True)
      		 
      query = "select TABLE_NAME from information_schema.tables where TABLE_SCHEMA=%s and TABLE_NAME=%s"
      		 
      try:
      		 
          db_cursor.execute(query, ("mysql", "global_priv"))

      If fails with:
      Commands out of sync; you can't run this command now
      Using the same code with the MySQL python connector will work.

        Attachments

          Activity

            People

            Assignee:
            georg Georg Richter
            Reporter:
            mariaTux Frank
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.