[CONPY-178] Repeated 'cursor.callproc()' calling make entire python process dead without notice. Created: 2021-11-24  Updated: 2022-07-06  Resolved: 2021-11-25

Status: Closed
Project: MariaDB Connector/Python
Component/s: Generic
Affects Version/s: 1.0.8
Fix Version/s: 1.0.9, 1.1.0rc1

Type: Bug Priority: Blocker
Reporter: Mitchell Lee Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None

Python Version: 3.9.8

 Description   

Hi.

With any of Mariadb/python connector, it happends.
Below pseudo code(just repeated loop) make entire python process dead without any message.
just killed.

  • pymysql never dead.
  • the stored procedure has the one OUT parameter.

Please fix it asap.
-----------
for label_c, dic_c in data_f.items():
for label_p, dic_p in dic_c.items():
for s, dic in dic_p.items():
args = (
code,
0
)

cur.callproc('proc_insert_something', args)

-----------

 Comments   
Comment by Georg Richter [ 2021-11-24 ]

Are you sure that 1.1.0 is affected (you reported version number 1.1.0b1) ? . I'm able to repeat the problem with 1.0.8 but not with 1.1.0.

Comment by Mitchell Lee [ 2021-11-24 ]

I have verified it again now,
it also happened on 1.1.0b2 (sorry for the version tag in the ticket, I have fixed.)
so, 1.0.8, 1.1.0b2 has the problem.

and...
Im using it on Windows and the version I can access are below.

ERROR: Could not find a version that satisfies the requirement mariadb==1.0.9 (from versions: 0.9.52, 0.9.53, 0.9.54, 0.9.55, 0.9.56, 0.9.57, 0.9.58, 0.9.59, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 1.0.7, 1.0.8, 1.1.0a1, 1.1.0b1, 1.1.0b2)
ERROR: No matching distribution found for mariadb==1.0.9

Comment by Mitchell Lee [ 2021-11-25 ]

Hi. When it can be used on Windows platform?

Generated at Thu Feb 08 03:30:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.