import mariadb

dbconfig= {"db": "test", "user" : "root",  
           "host" : "127.0.0.1", "port" : 19000}

conn1= mariadb.connect(**dbconfig)
cursor1= conn1.cursor()

conn2= mariadb.connect(**dbconfig)
cursor2= conn2.cursor()

print("executemany")

cursor1.execute("DROP TABLE IF EXISTS t1")
cursor1.execute("CREATE TABLE t1 (a int)")

cursor2.executemany("INSERT INTO t1 (a) VALUES (?)", [(1,), (2,)])
conn2.commit()

cursor1.execute("ALTER TABLE t1 ADD xx INT")

try:
  cursor2.executemany("INSERT INTO t1 (a) VALUES (?)", [(1,), (2,)])
except Exception as e:
   print("Exception occured")
   if e.errno == 0:
       print("Server sent error code 0")
   conn2.rollback()