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