Skip site navigation (1) Skip section navigation (2)

Error reporting goes into an infinite loop when compiled --with-odbcver=0x0250

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Hiroshi Saito <hiroshi(at)winpg(dot)jp>, pgsql-odbc(at)postgresql(dot)org
Cc: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
Subject: Error reporting goes into an infinite loop when compiled --with-odbcver=0x0250
Date: 2012-08-31 11:21:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

we had to recently test psqlODBC with an older application
which doesn't expect ODBC 3.x.

The problem is that the client locks up as soon as it encounters
an error of any kind, like restarting the server from under the client
or simply executing a bad query.

After debugging the problem and reading the code of both
unixODBC 2.3.1 and psqlODBC (version 09.00.0310 and 09.01.0200),
I discovered that the DriverManager calls the driver's SQLError()
and SQLGetDiagRec() in a loop and expects it to return the error
message in pieces and when there is nothing left to return,
these driver methods must return some SQL error instead of
SQL_SUCCESS[_WITH_INFO]. SQLGetDiagRec() does this properly
because the DriverManager keeps track of the pieces via the
RecNumber argument but SQLError() calls PGAPI_StmtError()
with RecNumber == -1 every time. Instead, it uses the internal
error structure to keep track of the string left to return. SQLError()
calls PGAPI_StmtError() with
which means that ER_ReturnError() may free the error structure.

The interaction between the looping and the freeing of the error
structure is buggy, the error makes it go into an infinite loop.

The attached patch fixes this problem. Though, I am not sure about
whether the (stapos > msglen) and (error->errorpos >= msglen)
checks are redundant or not.

Best regards,
Zoltán Böszörményi

Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria

Attachment: psqlodbc-odbc2.5-fix.patch
Description: text/x-patch (1.0 KB)


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2012-09-01 09:19:55
Subject: Re: Error reporting goes into an infinite loop when compiled --with-odbcver=0x0250
Previous:From: Alexandre - Aldeia DigitalDate: 2012-08-27 18:22:18
Subject: Re: psqlODBC 09.01.0200 Released

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group