Hi,
We have a multi-threaded Windows server process (C++) that writes data to a PostgreSQL database server using the 11.1 PostgreSQL ODBC driver.
This works smoothly pretty much everywhere except for one system, where the server process seems to crash on a regular basis inside the PostgreSQL ODBC driver, about every 10 minutes.
We have a crash dump that I've been looking at, but since I don't have access to the symbols (I tried this approach, without success), I can't determine why/how the driver is crashing. I do however see in the stack trace that crash is happening in the ConfigDriver() function:
psqlodbc35w!ConfigDriver
The full stack trace of the crashing thread below:
Good on you for getting a stack.
How was that obtained?
Can you please repeat it with debug symbols? The .pdb files for postgres itself are in the PostgreSQL install directory. I don't recall off the top of my head where the psqlODBC ones are, but likely the same. Make sure these are on your NT_SYMBOL_PATH or configured to be searched by your debugger.
If you can't get symbols, export a minidump of the crashed process and upload it somewhere. But you will need to understand that the minidump may contain sensitive information including usernames, passwords, queries, user data, etc. I can't offer you a private 1:1 way to exchange this info when I'm doing public mailing list help. So it'd be much better for you to debug the minidump yourself.
Since the issue is system specific, I suggest checking the linker path to ensure there aren't any issues with the wrong libpq or ssl libraries etc being loaded. The "depends.exe" tool from the Sysinternals suite can help with this, or you can examine the loaded libraries in the debugger session.
Also check your ini files and registry to see if there's anything funky and different in the config on the machine.