Public bug reported:
Binary package hint: unixodbc
When enabling pooling in /etc/odbcinst.ini file, simple program crashes
when SQLConnect called several times. When pooling is disabled, all
works fine. The "segmentation fault" occurs in the SQLConnect function.
Test program example:
#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>
int main(int argc, char *argv[]) {
SQLHENV henv;
SQLHDBC hdbc;
int i;
while (1) {
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(void*)SQL_OV_ODBC3, SQL_IS_INTEGER);
SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
SQLConnect(hdbc, (SQLCHAR*)"bank", SQL_NTS,
(SQLCHAR*)"dennis", SQL_NTS, (SQLCHAR*)"xxxxxx", SQL_NTS);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
}
}
When investigating this error with ODBCConfig utility I noted that when
pooling is disabled all stats shown as expected (picture 1); otherwise
connections grows unexpectingly and after counters are too big, test
program fails (picture 2).
P.S. On the www.unixodbc.org there is newer version of the library with
many fixes; may be this error already fixed in this version. My current
configuration:
$ lsb_release -rd
Description: Ubuntu 9.04
Release: 9.04
$ apt-cache policy unixodbc
unixodbc:
Installed: 2.2.11-16build3
Candidate: 2.2.11-16build3
Version table:
*** 2.2.11-16build3 0
500 http://ru.archive.ubuntu.com jaunty/main Packages
100 /var/lib/dpkg/status
$ apt-cache policy postgresql
postgresql:
Installed: 8.3.7-1
Candidate: 8.3.7-1
Version table:
*** 8.3.7-1 0
500 http://ru.archive.ubuntu.com jaunty/main Packages
100 /var/lib/dpkg/status
** Affects: unixodbc (Ubuntu)
Importance: Undecided
Status: New
--
segmentation fault on SQLConnect when pooling = yes
https://bugs.launchpad.net/bugs/362595
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
