My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 239: SQL Server XML data fields over a certain length produce MemoryError
1 person starred this issue and may be notified of changes. Back to list
Status:  Complete
Owner:  ----
Closed:  Jun 2012


 
Reported by randall....@gmail.com, Feb 17, 2012
What steps will reproduce the problem?
1. Create table in SQL Server (testing on 2008 R2) with an XML data type of length unlimited
2. Populate field with a large amount (512K-ish?) worth of data
3. Establish a connection to the database and attempt to .fetchone() one of the records from that table. 

What is the expected output? What do you see instead?
I expect to see the XML output. Instead I get:
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
MemoryError

What version of the product are you using? On what operating system?
Python 2.7.2 (32 bit) with Pyodbc 3.0.2 on Server 2008 R2 SQL Server 2008 R2.  


Please provide any additional information below.


Feb 19, 2012
#1 randall....@gmail.com
I still haven't been able to narrow down exactly how big the XML has to be to trigger the issue. I have re-tested on 64bit and I don't get a MemoryError, instead I get an APPCRASH. Willing to test or provide any additional information needed. 
Jun 23, 2012
Project Member #2 mkleehammer
Good catch.  Fixed in 3.0.6-beta07

I've added XML unit tests to the SQL Server file.
Status: Complete

Powered by Google Project Hosting