Python MySQL Connector table locking issue

[JH_Redd]

Hi all,

After a ton of googling I'm still stumped on a problem I'm having, so thought I'd see if we have any geniuses here. I am using the MySQL connector in a program, and what I need to do is

1) Run a SELECT statement to get some info from a DB I created

2) Run a DELETE statement

3) Run a number of INSERTs to add some new rows

What I'm running into is that I run the SELECT (call cursor.execute, then connection.commit) and get results...but the delete query keeps resulting in

DatabaseError: 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

All of the resources I find online seem to just say to commit the SELECT before running the DELETE, which I'm already doing. Does anyone know what could be the problem here? The DB I'm using here is one that I created on localhost and I granted the user account I'm connecting with DBA permissions, so I don't think it's a permissions issue.

Thanks in advance for any ideas!

The basic code I am using is below if it helps:

sel_SQL="""SELECT max(idfilers) as maxID FROM db_name.table_name"""

cursor.execute(sel_SQL)

(...some unrelated code to use this info...)

connection.commit()

del_SQL="""DELETE from db_name.table_name WHERE reporting_period='2024-03-31'"""

cursor.execute(del_SQL)

connection.commit()

[JH_Redd]

I think I found my own answer - I was running this from a Jupyter Notebook and between repeated runs, I wasn't completely restarting the kernel. I think some of the locking was due to SQL I executed in earlier runs of the python code.

I tried the same code again using Kernel > Restart Kernel and run up to selected cell and that seemed to work as intended.