[python-win32] Fw: [ pywin32-Bugs-3292681 ] adodbapi - Subtle crash

Vernon Cole vernondcole at gmail.com
Thu Apr 28 21:02:18 CEST 2011

I am cross-posting this message from the sourceforge bugtracker, so that
everyone will know about it. Perhaps someone will have a clue what might be
causing it. It's pretty weird...
v v v v v v v v v v v
From: SourceForge.net <noreply at sourceforge.net>
Subject: [ pywin32-Bugs-3292681 ] adodbapi - Subtle crash
To: noreply at sourceforge.net
Date: Tuesday, April 26, 2011, 3:11 PM

Bugs item #3292681, was opened at 2011-04-25 15:51
[... snip ...]
Category: adodbapi
Group: None
Status: [Accepted]
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Vernon Cole (kf7xm)
Summary: adodbapi - Subtle crash

Initial Comment:
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


>Comment By: https://www.google.com/accounts ()
Date: 2011-04-26 21:11

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
Comment By: Mark Hammond (mhammond)
Date: 2011-04-26 03:19

I haven't had a chance to repro this yet as the connection string doesn't
work on my dev box.
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
I have downloaded the code and determined that it also crashes on my Vista
32 bit laptop, running either Python 2.7 or 3.2.
It also crashes when using the JET data provider to open an ACCESS .mdb
database, so the problem is not specific to any provider.
It DOES NOT crash when using IronPython.
It DOES NOT crash if you have made opened and closed a connection for less
than 10 seconds before you try it with the 10 second pause.
It also crashes if the time.sleep(10) call is replaced by
sys.stdin.readline() and counting ten seconds, so it's not an interaction
with the time() module.

I'll continue looking, but frankly don't have a clue where to start.
Brilliant helpers are invited to contribute.

Overall rating
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20110428/a1fd545b/attachment.html>

More information about the python-win32 mailing list