Python for Windows Extensions / Old Bugs - new issues at https://github.com/mhammond/pywin32/issues / #548 adodbapi - Subtle crash

#548 adodbapi - Subtle crash

Status: closed-fixed

Owner: Vernon Cole

Labels: adodbapi (2)

Priority: 5

Updated: 2011-04-30

Created: 2011-04-25

Creator: Anonymous

Private: No

There is a subtle crash that can occur related to time.sleep(>10) and adodbapi.connect() calls, the second time will crash,
attached there is the simplest test case to crash it and various comments explaining the crash behavior test enviroement and stacktraces.

i hope will be useful to find the right solution, i've only found a bad workarond, without calling adodbapi.close() the crash doesn't happens.

thank you in advice

Discussion

Comment has been marked as spam.
Undo

View and moderate all "bugs Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Old Bugs - new issues at https://github.com/mhammond/pywin32/issues"

Anonymous - 2011-04-25

crash test case

crash test case

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

adodbapi_crashtest_simple.py

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Hammond - 2011-04-26

labels: 518338 --> adodbapi

assigned_to: nobody --> kf7xm

summary: Subtle crash --> adodbapi - Subtle crash
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Hammond - 2011-04-26

I haven't had a chance to repro this yet as the connection string doesn't work on my dev box.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Comment has been marked as spam.
Undo

View and moderate all "bugs Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Old Bugs - new issues at https://github.com/mhammond/pywin32/issues"

Anonymous - 2011-04-26

The connection string needs sqlserver express installed on the machine, but the same happens also with oracle oledb provider, this are the two providers i've tested on, but could be the crash occurs with any provider

The connection string needs sqlserver express installed on the machine, but the same happens also with oracle oledb provider, this are the two providers i've tested on, but could be the crash occurs with any provider

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Vernon Cole - 2011-04-28

Crash duplicated on Windows Vista 32 bit with SQL Server (local).
Does NOT crash in IronPython, indicating that this is probably a pywin32 error.
Investigation continues.
--
Vernon

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Vernon Cole - 2011-04-28

status: open --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Vernon Cole - 2011-04-30

fixed by removing CoUninitialize() and removing reference to Dispatch structure after closing.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Vernon Cole - 2011-04-30

status: open-accepted --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Vernon Cole - 2011-04-30

status: open-fixed --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link: