knightvv commented on issue #3139:
URL: https://github.com/apache/doris/issues/3139#issuecomment-1498246793
I'm hitting this same problem still. Repro code:
` conn = mysql.connector.connect(
host=MYSQL_HOST,
user=MYSQL_USER,
password=MYSQL_PSWD,
port=MYSQL_PORT
)
# Create a database
cursor = conn.cursor()
# For mysql, need to create db first
cursor.execute(f"CREATE DATABASE IF NOT EXISTS {MYSQL_DB_NAME} DEFAULT
CHARACTER SET 'utf8mb4';\
USE {MYSQL_DB_NAME};SHOW DATABASES;",
multi=True)
# fetch results
res = cursor.fetchall()
conn.commit() # <--- throws MySQLInterfaceError: Commands out of sync;
you can't run this command now`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]