Skip to Content.
Sympa Menu

freetds - [freetds] Failure to receive xml query result larger than 2GB

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Tille, Andreas" <TilleA AT rki.de>
  • To: "FreeTDS AT lists.ibiblio.org" <FreeTDS AT lists.ibiblio.org>
  • Subject: [freetds] Failure to receive xml query result larger than 2GB
  • Date: Thu, 30 Sep 2021 09:25:29 +0000

Hi,

I have a query which returns a result as XML which is larger than 2GB. When
doing this on Windows via

sqlcmd -S myserver -d mydb -E -i myquery.sql > myresult.xml

a 2.7GB XML file myresult.xml is created.

If I try this with freetds 1.2.3 under Debian 11 I get:

sqsh -w 256 -h -S myserver -U myuser -D mydb -i myquery.sql -o myresult.xml

I get

Msg 6365, Level 16, State 1
Server 'myserver', Line 70
An XML operation resulted an XML data type exceeding 2GB in size. Operation
aborted.


I used this query successfully a long time but I used a Python3 script to run
it. This stopped working some days ago when the amount of data seemed to
exceed some limit. The actual error message that was thrown by the Python3
script is


An XML operation resulted an XML data type exceeding 2GB in size. Operation
aborted.
DB-Lib error message 20018, severity 16:
General SQL Server error: Check messages from the SQL Server


Any idea why sqlcmd on Windows is succeeding here why sqsh and Python3 are
throwing this error?

Kind regards

Andreas.


  • [freetds] Failure to receive xml query result larger than 2GB, Tille, Andreas, 09/30/2021

Archive powered by MHonArc 2.6.24.

Top of Page