Обсуждение: Unknown exceptions possibly originating from psqlodbc

On 04/29/2015 06:17 AM, Brent Smith wrote:
> Hello,
>
> I am a software engineer working for Kepware Technologies. We provide
> control and monitoring software for automation devices. One of our
> products is an application that stores device data into a customer’s
> database. We support various database products, Postgres among them.
>
> I was given your contact information by one of our customers, John
> Psihos at ProcessLinx.
>
> We have been working on an issue with him for several months now, where
> we are intermittently receiving an unknown exception when trying to
> update a record set (an MFC call that ultimately goes to the ODBC
> driver). We have tested our code, as well as MFC (as much as possible)
> and have found no issues. The most likely area left seems to be the ODBC
> driver. We are using version 9.3.400 of the ODBC driver, and PostgreSQL
> 9.4. Once we receive this unknown exception from the record set, it is
> unusuable (as if it’s internal state is bad, although I haven’t been
> able to discover any evidence of this on my side), and generates further
> unknown exceptions when I try to close or delete it.

For my clarification, does unknown = no trace?
In other words, is there evidence available that it even happens?
If there is evidence, can you post it here?

>
> My primary question is, do you have any insight into what exceptions you
> might throw in the case of a record set update? Further, are there any
> tools, header files, debug versions, logging utilities, etc. that you
> could provide to help us diagnose this problem?

https://odbc.postgresql.org/faq.html#2.4

>
> Any help you could provide in this matter would be appreciated.
>
> Regards,
>
> *Brent Smith***
>
> Senior Software Engineer | Kepware Technologies <http://www.kepware.com/>
>
> Email: Brent.Smith@kepware.com <mailto:Brent.Smith@kepware.com>
>
> Follow Us: Facebook <https://www.facebook.com/kepware> | Twitter
> <https://twitter.com/Kepware> | LinkedIn
> <http://www.linkedin.com/company/kepware-technologies> | YouTube
> <http://www.youtube.com/user/kepware>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 29 April 2015 at 21:17, Brent Smith <brent.smith@kepware.com> wrote:


> My primary question is, do you have any insight into what exceptions you
> might throw in the case of a record set update? Further, are there any
> tools, header files, debug versions, logging utilities, etc. that you could
> provide to help us diagnose this problem?

I strongly recommend that you check out the psqlODBC sources from git
and do a debug build.

You should then set up the post-mortem debugger on the problem system
to generate minidumps, or to trap directly into Visual Studio if
practical. Alternately you can just attach VS to the problem process
(if it's just one) and wait for the problem to arise.

Using a debug build of the driver will make life a lot easier.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services