reconnect failing in 3.51.12

--=__Part4662C3AF.0__=
Content-Type: multipart/alternative; boundary="=__Part4662C3AF.1__="

--=__Part4662C3AF.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

I've got a linux daemon that logs to myodbc 3.51.12 through unixODBC driver manager. The first time my program receives a command it establishes an entire ODBC environment via the following (abbreviated) code:

int connect()
{
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hsql);
SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);
SQLAllocHandle(SQL_HANDLE_DBC, hsql, &hdbc);
SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS, (SQLCHAR*)user, SQL_NTS, (SQLCHAR*)passwd, SQL_NTS);
SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
SQLPrepare(hstmt, primary_stmt, SQL_NTS);

for (i = 0; i < elemcount(pa); i++)
SQLBindParameter(hstmt, j++, SQL_PARAM_INPUT, pa[i].c_type, pa[i].s_type, pa[i].csize, 0, pa[i].pvp, 0, &ind[i]);
}

void disconnect()
{
if (hstmt != 0)
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
if (hdbc != 0)
{
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
if (hsql != 0)
SQLFreeHandle(SQL_HANDLE_ENV, hsql);
hstmt = hdbc = hsql = 0;
}
Of course, I check all of the error returns in the real code. The daemon monitors for intermittent request traffic and logs things to the database as requests come in. If there's an 8 hour delay between requests, the ODBC connection times out. I expect this condition in the log code as follows:

if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
{
disconnect();
if (connect() != 0)
return -1;
else if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
return -1;
}
My problem is that I cannot re-establish the connection once it's been broken like this. I get errors back from myodbc like this:

(a snippet from my daemon's log file)
[Wed Feb 7 15:26:32 2007] Entering main run loop...

(first request established initial connection)
[Wed Feb 7 15:27:48 2007] xdm_odbc: Connection established. [DSN=xdas;UID=root;PWD=;].

(second request - over 8 hours later - tries to re-establish connection)
[Fri Feb 9 02:52:56 2007] xdm_odbc: the ODBC driver reported -1 during SQLConnect:
[Fri Feb 9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL][ODBC 3.51 Driver]Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)
[Fri Feb 9 02:52:56 2007] xdm_odbc: ODBC Reconnect failed, error -1.
What am I doing wrong? It seems simple enough to me. I noticed on the mailing list that a few folks had trouble using SQLDriverConnect, so I switched to SQLConnect, and now I get other types of errors trying to reconnect - not the least of these are that my daemon segfaults down inside of libmyodbc with the following stack trace:

#0 0xb741dc5d in my_strcasecmp_8bit () from /usr/lib/mysql/libmysqlclient.so.15
#1 0xb741514d in get_charset_number () from /usr/lib/mysql/libmysqlclient.so.15
#2 0xb74151ab in get_charset_by_csname () from /usr/lib/mysql/libmysqlclient.so.15
#3 0xb74320ec in mysql_real_connect () from /usr/lib/mysql/libmysqlclient.so.15
#4 0xb753c15a in SQLConnect (hdbc=0x807fe78, szDSN=0xb7d8df51, cbDSN=-3,
szUID=0xb7d8e270, cbUID=-3, szAuthStr=0xb7d8e1f0, cbAuthStr=-3) at connect.c:253
#5 0xb7d9d394 in SQLConnect (connection_handle=0x80616f0,
server_name=0xb7d8e2f0, name_length1=-3, user_name=0xb7d8e270,
name_length2=-3, authentication=0xb7d8e1f0, name_length3=-3) at SQLConnect.c:3820
#6 0xb7f63c23 in sql_connect () at xdm_odbc.c:322
#7 0xb7f6411a in xdm_append (msg=0x80776a9, msgsz=272) at xdm_odbc.c:394
#8 0x0804a3cf in xdasd_logger_append (msg=0x8077598, msgsz=272) at xdasd_logger.c:175
#9 0x0804a0e2 in bg_logger (unused=0x0) at xdasd_lcache.c:90
#10 0xb7f3b34b in start_thread () from /lib/libpthread.so.0
#11 0xb7ed365e in clone () from /lib/libc.so.6
Any ideas would be appreciated.

Thanks,
John


-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.

--=__Part4662C3AF.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>I've got a linux daemon that logs to myodbc 3.51.12 through unixODBC =
driver manager. The first time my program receives a command it establishes=
an entire ODBC environment via the following (abbreviated) code:</DIV=
>
<DIV> </DIV>
<DIV>   int connect()</DIV>
<DIV>   {</DIV>
<DIV>      SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HAND=
LE, &hsql);</DIV>
<DIV>      SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, =
(void *)SQL_OV_ODBC3, 0);</DIV>
<DIV>      SQLAllocHandle(SQL_HANDLE_DBC, hsql, =
&hdbc);</DIV>
<DIV>      SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS,&nbs=
p;(SQLCHAR*)user, SQL_NTS, (SQLCHAR*)passwd, SQL_NTS);</DIV>
<DIV>      SQLAllocHandle(SQL_HANDLE_STMT, hdbc, =
&hstmt);</DIV>
<DIV>      SQLPrepare(hstmt, primary_stmt, SQL_NTS);</D=
IV>
<DIV> </DIV>
<DIV>      for (i =3D 0; i < elemcount(pa); =
i++)</DIV>
<DIV>         SQLBindParameter(hstmt, j++, =
SQL_PARAM_INPUT, pa[i].c_type, pa[i].s_type, pa[i].csize, 0, =
pa[i].pvp, 0, &ind[i]);</DIV>
<DIV>   }</DIV>
<DIV> </DIV>
<DIV>   void disconnect()<BR>   {<BR>   =
   if (hstmt !=3D 0)<BR>       &nbs=
p; SQLFreeHandle(SQL_HANDLE_STMT, hstmt);<BR>      if =
(hdbc !=3D 0)<BR>      {<BR>     &n=
bsp;   SQLDisconnect(hdbc);<BR>      &nb=
sp;  SQLFreeHandle(SQL_HANDLE_DBC, hdbc);<BR>     =
}<BR>      if (hsql !=3D 0)<BR>    &nbs=
p;    SQLFreeHandle(SQL_HANDLE_ENV, hsql);<BR>   =
   hstmt =3D hdbc =3D hsql =3D 0;<BR>   }<BR></DIV>
<DIV>Of course, I check all of the error returns in the real code. The =
daemon monitors for intermittent request traffic and logs things to the =
database as requests come in. If there's an 8 hour delay between requests, =
the ODBC connection times out. I expect this condition in the log code as =
follows:</DIV>
<DIV> </DIV>
<DIV>   if (!SQL_SUCCEEDED(SQLExecute(hstmt)))<BR>   =
{<BR>      disconnect();<BR>   &nbs=
p;  if (connect() !=3D 0)<BR>       =
;  return -1;<BR>      else if (!SQL_SUCCEEDE=
D(SQLExecute(hstmt)))<BR>        &n=
bsp;return -1;<BR>   }<BR></DIV>
<DIV>My problem is that I cannot re-establish the connection once it's =
been broken like this. I get errors back from myodbc like this:</DIV>
<DIV> </DIV>
<DIV>   (a snippet from my daemon's log file)</DIV>
<DIV>   [Wed Feb  7 15:26:32 2007] Entering main run =
loop...</DIV>
<DIV> </DIV>
<DIV>   (first request established initial connection)<=
BR>   [Wed Feb  7 15:27:48 2007] xdm_odbc: Connection =
established. [DSN=3Dxdas;UID=3Droot;PWD=3D;].</DIV>
<DIV> </DIV>
<DIV>   (second request - over 8 hours later - tries =
to re-establish connection)<BR>   [Fri Feb  9 02:52:56 =
2007] xdm_odbc: the ODBC driver reported -1 during SQLConnect:<BR> &nb=
sp; [Fri Feb  9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL=
][ODBC 3.51 Driver]Can't initialize character set latin1 (path: /usr/share/=
mysql/charsets/)<BR>   [Fri Feb  9 02:52:56 2007] xdm_odbc: =
ODBC Reconnect failed, error -1.<BR></DIV>
<DIV>What am I doing wrong? It seems simple enough to me. I noticed on the =
mailing list that a few folks had trouble using SQLDriverConnect, so I =
switched to SQLConnect, and now I get other types of errors trying to =
reconnect - not the least of these are that my daemon segfaults down =
inside of libmyodbc with the following stack trace:</DIV>
<DIV> </DIV>
<DIV>#0  0xb741dc5d in my_strcasecmp_8bit () from /usr/lib/mysql/libmy=
sqlclient.so.15<BR>#1  0xb741514d in get_charset_number () from =
/usr/lib/mysql/libmysqlclient.so.15<BR>#2  0xb74151ab in get_charset_b=
y_csname () from /usr/lib/mysql/libmysqlclient.so.15<BR>#3  0xb74320ec=
in mysql_real_connect () from /usr/lib/mysql/libmysqlclient.so.15<BR>#4&nb=
sp; 0xb753c15a in SQLConnect (hdbc=3D0x807fe78, szDSN=3D0xb7d8df51, =
cbDSN=3D-3,<BR>    szUID=3D0xb7d8e270, cbUID=3D-3, =
szAuthStr=3D0xb7d8e1f0, cbAuthStr=3D-3) at connect.c:253<BR>#5  =
0xb7d9d394 in SQLConnect (connection_handle=3D0x80616f0,<BR>  &nb=
sp; server_name=3D0xb7d8e2f0, name_length1=3D-3, user_name=3D0xb7d8e270,<BR=
>    name_length2=3D-3, authentication=3D0xb7d8e1f0, =
name_length3=3D-3) at SQLConnect.c:3820<BR>#6  0xb7f63c23 in =
sql_connect () at xdm_odbc.c:322<BR>#7  0xb7f6411a in xdm_append =
(msg=3D0x80776a9, msgsz=3D272) at xdm_odbc.c:394<BR>#8  0x0804a3cf in =
xdasd_logger_append (msg=3D0x8077598, msgsz=3D272) at xdasd_logger.c:175<BR=
>#9  0x0804a0e2 in bg_logger (unused=3D0x0) at xdasd_lcache.c:90<BR>#1=
0 0xb7f3b34b in start_thread () from /lib/libpthread.so.0<BR>#11 0xb7ed365e=
in clone () from /lib/libc.so.6<BR></DIV>
<DIV>Any ideas would be appreciated.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>John</DIV>
<DIV> </DIV>
<DIV> </DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. =
Software Engineeer<BR>Novell, Inc.<BR></BODY></HTML>

--=__Part4662C3AF.1__=--

--=__Part4662C3AF.0__=
Content-Type: text/plain; name="John Calcote.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="John Calcote.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=3DQUOTED-PRINTABLE:Joh n Calcote=3D0A=
=3D
PRV-H-511=3D0A=3D
Provo
END:VCARD



--=__Part4662C3AF.0__=
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=__Part4662C3AF.0__=--
John Calcote [ Sa, 10 Februar 2007 00:54 ] [ ID #1624198 ]

RE: reconnect failing in 3.51.12

------=_NextPart_000_0001_01C74C88.FEA507C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

John,



Lawson Cronlundlawson [at] vrtinc.com

+1(480)308-0641 (voice)

+1(602)996-0376 (fax)



_____

From: John Calcote [mailto:jcalcote [at] novell.com]
Sent: Friday, February 09, 2007 4:55 PM
To: myodbc [at] lists.mysql.com
Subject: reconnect failing in 3.51.12



I've got a linux daemon that logs to myodbc 3.51.12 through unixODBC driver
manager. The first time my program receives a command it establishes an
entire ODBC environment via the following (abbreviated) code:



int connect()

{

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hsql);

SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);

SQLAllocHandle(SQL_HANDLE_DBC, hsql, &hdbc);

SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS, (SQLCHAR*)user, SQL_NTS,
(SQLCHAR*)passwd, SQL_NTS);

SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

SQLPrepare(hstmt, primary_stmt, SQL_NTS);



for (i = 0; i < elemcount(pa); i++)

SQLBindParameter(hstmt, j++, SQL_PARAM_INPUT, pa[i].c_type,
pa[i].s_type, pa[i].csize, 0, pa[i].pvp, 0, &ind[i]);

}



void disconnect()
{
if (hstmt != 0)
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
if (hdbc != 0)
{
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
if (hsql != 0)
SQLFreeHandle(SQL_HANDLE_ENV, hsql);
hstmt = hdbc = hsql = 0;
}

Of course, I check all of the error returns in the real code. The daemon
monitors for intermittent request traffic and logs things to the database as
requests come in. If there's an 8 hour delay between requests, the ODBC
connection times out. I expect this condition in the log code as follows:



if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
{
disconnect();
if (connect() != 0)
return -1;
else if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
return -1;
}

My problem is that I cannot re-establish the connection once it's been
broken like this. I get errors back from myodbc like this:



(a snippet from my daemon's log file)

[Wed Feb 7 15:26:32 2007] Entering main run loop...



(first request established initial connection)
[Wed Feb 7 15:27:48 2007] xdm_odbc: Connection established.
[DSN=xdas;UID=root;PWD=;].



(second request - over 8 hours later - tries to re-establish connection)
[Fri Feb 9 02:52:56 2007] xdm_odbc: the ODBC driver reported -1 during
SQLConnect:
[Fri Feb 9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL][ODBC
3.51 Driver]Can't initialize character set latin1 (path:
/usr/share/mysql/charsets/)
[Fri Feb 9 02:52:56 2007] xdm_odbc: ODBC Reconnect failed, error -1.

What am I doing wrong? It seems simple enough to me. I noticed on the
mailing list that a few folks had trouble using SQLDriverConnect, so I
switched to SQLConnect, and now I get other types of errors trying to
reconnect - not the least of these are that my daemon segfaults down inside
of libmyodbc with the following stack trace:



#0 0xb741dc5d in my_strcasecmp_8bit () from
/usr/lib/mysql/libmysqlclient.so.15
#1 0xb741514d in get_charset_number () from
/usr/lib/mysql/libmysqlclient.so.15
#2 0xb74151ab in get_charset_by_csname () from
/usr/lib/mysql/libmysqlclient.so.15
#3 0xb74320ec in mysql_real_connect () from
/usr/lib/mysql/libmysqlclient.so.15
#4 0xb753c15a in SQLConnect (hdbc=0x807fe78, szDSN=0xb7d8df51, cbDSN=-3,
szUID=0xb7d8e270, cbUID=-3, szAuthStr=0xb7d8e1f0, cbAuthStr=-3) at
connect.c:253
#5 0xb7d9d394 in SQLConnect (connection_handle=0x80616f0,
server_name=0xb7d8e2f0, name_length1=-3, user_name=0xb7d8e270,
name_length2=-3, authentication=0xb7d8e1f0, name_length3=-3) at
SQLConnect.c:3820
#6 0xb7f63c23 in sql_connect () at xdm_odbc.c:322
#7 0xb7f6411a in xdm_append (msg=0x80776a9, msgsz=272) at xdm_odbc.c:394
#8 0x0804a3cf in xdasd_logger_append (msg=0x8077598, msgsz=272) at
xdasd_logger.c:175
#9 0x0804a0e2 in bg_logger (unused=0x0) at xdasd_lcache.c:90
#10 0xb7f3b34b in start_thread () from /lib/libpthread.so.0
#11 0xb7ed365e in clone () from /lib/libc.so.6

Any ideas would be appreciated.



Thanks,

John





-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.


------=_NextPart_000_0001_01C74C88.FEA507C0--
Lawson Cronlund [ Sa, 10 Februar 2007 04:29 ] [ ID #1625097 ]

RE: reconnect failing in 3.51.12

------=_NextPart_000_0009_01C74C89.5FFEE7C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

John,

My approach to this problem was to keep track of the amount of time between
queries to the MySQL database. If it got to be more than 4 hours
(approximately, I made a "do nothing" query to the database to reset its
no-activity timer.

Kind of dirty but it's worked for over a year now.

Regards,



Lawson Cronlund

lawson [at] vrtinc.com

+1(480)308-0641 (voice)

+1(602)996-0376 (fax)



_____

From: John Calcote [mailto:jcalcote [at] novell.com]
Sent: Friday, February 09, 2007 4:55 PM
To: myodbc [at] lists.mysql.com
Subject: reconnect failing in 3.51.12



I've got a linux daemon that logs to myodbc 3.51.12 through unixODBC driver
manager. The first time my program receives a command it establishes an
entire ODBC environment via the following (abbreviated) code:



int connect()

{

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hsql);

SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);

SQLAllocHandle(SQL_HANDLE_DBC, hsql, &hdbc);

SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS, (SQLCHAR*)user, SQL_NTS,
(SQLCHAR*)passwd, SQL_NTS);

SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

SQLPrepare(hstmt, primary_stmt, SQL_NTS);



for (i = 0; i < elemcount(pa); i++)

SQLBindParameter(hstmt, j++, SQL_PARAM_INPUT, pa[i].c_type,
pa[i].s_type, pa[i].csize, 0, pa[i].pvp, 0, &ind[i]);

}



void disconnect()
{
if (hstmt != 0)
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
if (hdbc != 0)
{
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
if (hsql != 0)
SQLFreeHandle(SQL_HANDLE_ENV, hsql);
hstmt = hdbc = hsql = 0;
}

Of course, I check all of the error returns in the real code. The daemon
monitors for intermittent request traffic and logs things to the database as
requests come in. If there's an 8 hour delay between requests, the ODBC
connection times out. I expect this condition in the log code as follows:



if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
{
disconnect();
if (connect() != 0)
return -1;
else if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
return -1;
}

My problem is that I cannot re-establish the connection once it's been
broken like this. I get errors back from myodbc like this:



(a snippet from my daemon's log file)

[Wed Feb 7 15:26:32 2007] Entering main run loop...



(first request established initial connection)
[Wed Feb 7 15:27:48 2007] xdm_odbc: Connection established.
[DSN=xdas;UID=root;PWD=;].



(second request - over 8 hours later - tries to re-establish connection)
[Fri Feb 9 02:52:56 2007] xdm_odbc: the ODBC driver reported -1 during
SQLConnect:
[Fri Feb 9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL][ODBC
3.51 Driver]Can't initialize character set latin1 (path:
/usr/share/mysql/charsets/)
[Fri Feb 9 02:52:56 2007] xdm_odbc: ODBC Reconnect failed, error -1.

What am I doing wrong? It seems simple enough to me. I noticed on the
mailing list that a few folks had trouble using SQLDriverConnect, so I
switched to SQLConnect, and now I get other types of errors trying to
reconnect - not the least of these are that my daemon segfaults down inside
of libmyodbc with the following stack trace:



#0 0xb741dc5d in my_strcasecmp_8bit () from
/usr/lib/mysql/libmysqlclient.so.15
#1 0xb741514d in get_charset_number () from
/usr/lib/mysql/libmysqlclient.so.15
#2 0xb74151ab in get_charset_by_csname () from
/usr/lib/mysql/libmysqlclient.so.15
#3 0xb74320ec in mysql_real_connect () from
/usr/lib/mysql/libmysqlclient.so.15
#4 0xb753c15a in SQLConnect (hdbc=0x807fe78, szDSN=0xb7d8df51, cbDSN=-3,
szUID=0xb7d8e270, cbUID=-3, szAuthStr=0xb7d8e1f0, cbAuthStr=-3) at
connect.c:253
#5 0xb7d9d394 in SQLConnect (connection_handle=0x80616f0,
server_name=0xb7d8e2f0, name_length1=-3, user_name=0xb7d8e270,
name_length2=-3, authentication=0xb7d8e1f0, name_length3=-3) at
SQLConnect.c:3820
#6 0xb7f63c23 in sql_connect () at xdm_odbc.c:322
#7 0xb7f6411a in xdm_append (msg=0x80776a9, msgsz=272) at xdm_odbc.c:394
#8 0x0804a3cf in xdasd_logger_append (msg=0x8077598, msgsz=272) at
xdasd_logger.c:175
#9 0x0804a0e2 in bg_logger (unused=0x0) at xdasd_lcache.c:90
#10 0xb7f3b34b in start_thread () from /lib/libpthread.so.0
#11 0xb7ed365e in clone () from /lib/libc.so.6

Any ideas would be appreciated.



Thanks,

John





-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.


------=_NextPart_000_0009_01C74C89.5FFEE7C0--
Lawson Cronlund [ Sa, 10 Februar 2007 04:32 ] [ ID #1625098 ]

RE: reconnect failing in 3.51.12

--=__PartBF9B394B.0__=
Content-Type: multipart/alternative; boundary="=__PartBF9B394B.1__="

--=__PartBF9B394B.1__=
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Lawson,

Thanks for the feedback.

I had a horrible feeling it might come down to something like this. :) If =
you don't mind, I'll hold out for a few more answers, just in case - we =
might both learn something. But in the end, I'll have to do what you =
suggest if the folks at MySQL don't see the need to fix the issue - or at =
least give us a decent work-around.

Regards,

John

-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.


>>> On Fri, Feb 9, 2007 at 8:32 PM, in message <000801c74cc4$0c5dbfc0$6500=
a8c0 [at] winxppro>, "Lawson Cronlund" <lawson [at] vrtinc.com> wrote:

John,
My approach to this problem was to keep track of the amount of time =
between queries to the MySQL database. If it got to be more than 4 hours =
(approximately, I made a *do nothing* query to the database to reset its =
no-activity timer.
Kind of dirty but it*s worked for over a year now.
Regards,


Lawson Cronlund
lawson [at] vrtinc.com
+1(480)308-0641 (voice)
+1(602)996-0376 (fax)



From:John Calcote [mailto:jcalcote [at] novell.com]
Sent: Friday, February 09, 2007 4:55 PM
To: myodbc [at] lists.mysql.com
Subject: reconnect failing in 3.51.12



I've got a linux daemon that logs to myodbc 3.51.12 through unixODBC =
driver manager. The first time my program receives a command it establishes=
an entire ODBC environment via the following (abbreviated) code:



int connect()

{

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hsql);

SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);

SQLAllocHandle(SQL_HANDLE_DBC, hsql, &hdbc);

SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS, (SQLCHAR*)user, SQL_NTS, =
(SQLCHAR*)passwd, SQL_NTS);

SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

SQLPrepare(hstmt, primary_stmt, SQL_NTS);



for (i =3D 0; i < elemcount(pa); i++)

SQLBindParameter(hstmt, j++, SQL_PARAM_INPUT, pa[i].c_type, =
pa[i].s_type, pa[i].csize, 0, pa[i].pvp, 0, &ind[i]);

}



void disconnect()
{
if (hstmt !=3D 0)
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
if (hdbc !=3D 0)
{
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
if (hsql !=3D 0)
SQLFreeHandle(SQL_HANDLE_ENV, hsql);
hstmt =3D hdbc =3D hsql =3D 0;
}

Of course, I check all of the error returns in the real code. The daemon =
monitors for intermittent request traffic and logs things to the database =
as requests come in. If there's an 8 hour delay between requests, the ODBC =
connection times out. I expect this condition in the log code as follows:



if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
{
disconnect();
if (connect() !=3D 0)
return -1;
else if (!SQL_SUCCEEDED(SQLExecute(hstmt)))
return -1;
}

My problem is that I cannot re-establish the connection once it's been =
broken like this. I get errors back from myodbc like this:



(a snippet from my daemon's log file)

[Wed Feb 7 15:26:32 2007] Entering main run loop...



(first request established initial connection)
[Wed Feb 7 15:27:48 2007] xdm_odbc: Connection established. [DSN=3Dxdas=
;UID=3Droot;PWD=3D;].



(second request - over 8 hours later - tries to re-establish connection)=

[Fri Feb 9 02:52:56 2007] xdm_odbc: the ODBC driver reported -1 during =
SQLConnect:
[Fri Feb 9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL][ODBC=
3.51 Driver]Can't initialize character set latin1 (path: /usr/share/mysql/=
charsets/)
[Fri Feb 9 02:52:56 2007] xdm_odbc: ODBC Reconnect failed, error -1.

What am I doing wrong? It seems simple enough to me. I noticed on the =
mailing list that a few folks had trouble using SQLDriverConnect, so I =
switched to SQLConnect, and now I get other types of errors trying to =
reconnect - not the least of these are that my daemon segfaults down =
inside of libmyodbc with the following stack trace:



#0 0xb741dc5d in my_strcasecmp_8bit () from /usr/lib/mysql/libmysqlclient.=
so.15
#1 0xb741514d in get_charset_number () from /usr/lib/mysql/libmysqlclient.=
so.15
#2 0xb74151ab in get_charset_by_csname () from /usr/lib/mysql/libmysqlclie=
nt.so.15
#3 0xb74320ec in mysql_real_connect () from /usr/lib/mysql/libmysqlclient.=
so.15
#4 0xb753c15a in SQLConnect (hdbc=3D0x807fe78, szDSN=3D0xb7d8df51, =
cbDSN=3D-3,
szUID=3D0xb7d8e270, cbUID=3D-3, szAuthStr=3D0xb7d8e1f0, cbAuthStr=3D-3)=
at connect.c:253
#5 0xb7d9d394 in SQLConnect (connection_handle=3D0x80616f0,
server_name=3D0xb7d8e2f0, name_length1=3D-3, user_name=3D0xb7d8e270,
name_length2=3D-3, authentication=3D0xb7d8e1f0, name_length3=3D-3) at =
SQLConnect.c:3820
#6 0xb7f63c23 in sql_connect () at xdm_odbc.c:322
#7 0xb7f6411a in xdm_append (msg=3D0x80776a9, msgsz=3D272) at xdm_odbc.c:3=
94
#8 0x0804a3cf in xdasd_logger_append (msg=3D0x8077598, msgsz=3D272) at =
xdasd_logger.c:175
#9 0x0804a0e2 in bg_logger (unused=3D0x0) at xdasd_lcache.c:90
#10 0xb7f3b34b in start_thread () from /lib/libpthread.so.0
#11 0xb7ed365e in clone () from /lib/libc.so.6

Any ideas would be appreciated.



Thanks,

John





-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.

--=__PartBF9B394B.1__=
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>

<STYLE>
<!--
/* Font Definitions */
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";
mso-believe-normal-left:yes;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</STYLE>
Lawson,</DIV>
<DIV> </DIV>
<DIV>Thanks for the feedback. </DIV>
<DIV> </DIV>
<DIV>I had a horrible feeling it might come down to something like this. =
:) If you don't mind, I'll hold out for a few more answers, just in case - =
we might both learn something. But in the end, I'll have to do what you =
suggest if the folks at MySQL don't see the need to fix the issue - or at =
least give us a decent work-around.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV>John</DIV>
<DIV> </DIV>
<DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. Software Engineeer<=
BR>Novell, Inc.<BR><BR><BR>>>> On Fri, Feb 9, 2007 at  8:32 =
PM, in message <000801c74cc4$0c5dbfc0$6500a8c0 [at] winxppro>, "Lawson =
Cronlund" <lawson [at] vrtinc.com> wrote:<BR></DIV>
<DIV style=3D"PADDING-LEFT: 7px; MARGIN: 0px 0px 0px 15px; BORDER-LEFT: =
#050505 1px solid; BACKGROUND-COLOR: #f3f3f3">
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">John,<?xml:names=
pace prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office" =
/><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">My approach to =
this problem was to keep track of the amount of time between queries to =
the MySQL database.  If it got to be more than 4 hours (approximately,=
I made a "do nothing" query to the database to reset its no-activity =
timer.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Kind of dirty =
but it's worked for over a year now.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,<o:p></o=
:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p=
></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal><?xml:namespace prefix =3D st1 ns =3D "urn:schemas-mic=
rosoft-com:office:smarttags" /><st1:PersonName w:st=3D"on"><FONT face=3DAri=
al color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
FONT-FAMILY: Arial">Lawson Cronlund</SPAN></FONT></st1:PersonName><FONT =
color=3Dnavy><SPAN style=3D"COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><A href=3D"mailt=
o:lawson [at] vrtinc.com">lawson [at] vrtinc.com</A></SPAN></FONT><FONT color=3Dnavy>=
<SPAN style=3D"COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">+1(480)308-0641 =
(voice)</SPAN></FONT><FONT color=3Dnavy><SPAN style=3D"COLOR: navy"><o:p></=
o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">+1(602)996-0376 =
(fax)</SPAN></FONT><FONT color=3Dnavy><SPAN style=3D"COLOR: navy"><o:p></o:=
p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" color=3Dnavy size=3D3><=
SPAN style=3D"FONT-SIZE: 12pt; COLOR: navy"> </SPAN></FONT><o:p></o:p>=
</P></DIV>
<DIV>
<DIV class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt; TEXT-ALIGN: center" =
align=3Dcenter><FONT face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-=
SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><B><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT face=3DTahoma size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> John Calcote [mailto:jcalco=
te [at] novell.com] <BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Friday, February 09, 2007 4:55 PM<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">To:</SPAN></B> myodbc [at] lists.mysql.com<BR><B><SPAN style=3D"FONT-WEIGH=
T: bold">Subject:</SPAN></B> reconnect failing in 3.51.12</SPAN></FONT><o:p=
></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">I've got a =
linux daemon that logs to myodbc 3.51.12 through unixODBC driver manager. =
The first time my program receives a command it establishes an entire ODBC =
environment via the following (abbreviated) code:<o:p></o:p></SPAN></F=
ONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
int connect()<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
{<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hsql);<o:=
p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLSetEnvAttr(hsql, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC=
3, 0);<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLAllocHandle(SQL_HANDLE_DBC, hsql, &hdbc);<o:p></o:p></S=
PAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLConnect(hdbc, (SQLCHAR*)dsn, SQL_NTS, (SQLCHAR*)user, =
SQL_NTS, (SQLCHAR*)passwd, SQL_NTS);<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);<o:p></o:p><=
/SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   SQLPrepare(hstmt, primary_stmt, SQL_NTS);<o:p></o:p></SPAN></F=
ONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
   for (i =3D 0; i < elemcount(pa); i++)<o:p></o:p></SPAN></FO=
NT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
      SQLBindParameter(hstmt, j++, SQL_PARAM_INPUT,&nbs=
p;pa[i].c_type, pa[i].s_type, pa[i].csize, 0, pa[i].pvp, 0, &ind[i]);<o=
:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
}<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
void disconnect()<BR>   {<BR>      if (hstmt =
!=3D 0)<BR>         SQLFreeHandle(SQL_HA=
NDLE_STMT, hstmt);<BR>      if (hdbc !=3D 0)<BR> &=
nbsp;    {<BR>         =
SQLDisconnect(hdbc);<BR>         =
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);<BR>      =
}<BR>      if (hsql !=3D 0)<BR>     =
;    SQLFreeHandle(SQL_HANDLE_ENV, hsql);<BR>   =
   hstmt =3D hdbc =3D hsql =3D 0;<BR>   }<o:p></o:p></S=
PAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Of course, I =
check all of the error returns in the real code. The daemon monitors for =
intermittent request traffic and logs things to the database as requests =
come in. If there's an 8 hour delay between requests, the ODBC connection =
times out. I expect this condition in the log code as follows:<o:p></o:p></=
SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
if (!SQL_SUCCEEDED(SQLExecute(hstmt)))<BR>   {<BR>  &nb=
sp;   disconnect();<BR>      if =
(connect() !=3D 0)<BR>         =
return -1;<BR>      else if (!SQL_SUCCEEDED(SQLExe=
cute(hstmt)))<BR>         retu=
rn -1;<BR>   }<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">My problem =
is that I cannot re-establish the connection once it's been broken like =
this. I get errors back from myodbc like this:<o:p></o:p></SPAN></FONT></P>=
</DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
(a snippet from my daemon's log file)<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
[Wed Feb  7 15:26:32 2007] Entering main run loop...<o:p></o:p></SPAN>=
</FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">  &=
nbsp;(first request established initial connection)<BR>   =
[Wed Feb  7 15:27:48 2007] xdm_odbc: Connection established. =
[DSN=3Dxdas;UID=3Droot;PWD=3D;].<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">   =
(second request - over 8 hours later - tries to re-establish =
connection)<BR>   [Fri Feb  9 02:52:56 2007] xdm_odbc: the =
ODBC driver reported -1 during SQLConnect:<BR>   [Fri Feb  =
9 02:52:56 2007] xdm_odbc: HYT00:1:2019:[unixODBC][MySQL][ODBC 3.51 =
Driver]Can't initialize character set latin1 (path: /usr/share/mysql/charse=
ts/)<BR>   [Fri Feb  9 02:52:56 2007] xdm_odbc: ODBC =
Reconnect failed, error -1.<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">What am I =
doing wrong? It seems simple enough to me. I noticed on the mailing list =
that a few folks had trouble using SQLDriverConnect, so I switched to =
SQLConnect, and now I get other types of errors trying to reconnect - not =
the least of these are that my daemon segfaults down inside of libmyodbc =
with the following stack trace:<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">#0  =
0xb741dc5d in my_strcasecmp_8bit () from /usr/lib/mysql/libmysqlclient.so.1=
5<BR>#1  0xb741514d in get_charset_number () from /usr/lib/mysql/libmy=
sqlclient.so.15<BR>#2  0xb74151ab in get_charset_by_csname () from =
/usr/lib/mysql/libmysqlclient.so.15<BR>#3  0xb74320ec in mysql_real_co=
nnect () from /usr/lib/mysql/libmysqlclient.so.15<BR>#4  0xb753c15a =
in SQLConnect (hdbc=3D0x807fe78, szDSN=3D0xb7d8df51, cbDSN=3D-3,<BR> &=
nbsp;  szUID=3D0xb7d8e270, cbUID=3D-3, szAuthStr=3D0xb7d8e1f0, =
cbAuthStr=3D-3) at connect.c:253<BR>#5  0xb7d9d394 in SQLConnect =
(connection_handle=3D0x80616f0,<BR>    server_name=3D0xb7d8e=
2f0, name_length1=3D-3, user_name=3D0xb7d8e270,<BR>    =
name_length2=3D-3, authentication=3D0xb7d8e1f0, name_length3=3D-3) at =
SQLConnect.c:3820<BR>#6  0xb7f63c23 in sql_connect () at xdm_odbc.c:32=
2<BR>#7  0xb7f6411a in xdm_append (msg=3D0x80776a9, msgsz=3D272) at =
xdm_odbc.c:394<BR>#8  0x0804a3cf in xdasd_logger_append (msg=3D0x80775=
98, msgsz=3D272) at xdasd_logger.c:175<BR>#9  0x0804a0e2 in bg_logger =
(unused=3D0x0) at xdasd_lcache.c:90<BR>#10 0xb7f3b34b in start_thread () =
from /lib/libpthread.so.0<BR>#11 0xb7ed365e in clone () from /lib/libc.so.6=
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Any ideas =
would be appreciated.<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thanks,<o:p><=
/o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">John<o:p></o:=
p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <o:p></=
o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DTahoma =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----<BR>John=
Calcote (jcalcote [at] novell.com)<BR>Sr. Software Engineeer<BR>Novell, =
Inc.<o:p></o:p></SPAN></FONT></P></DIV></DIV></BODY></HTML>

--=__PartBF9B394B.1__=--

--=__PartBF9B394B.0__=
Content-Type: text/plain; name="John Calcote.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="John Calcote.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=3DQUOTED-PRINTABLE:Joh n Calcote=3D0A=
=3D
PRV-H-511=3D0A=3D
Provo
END:VCARD



--=__PartBF9B394B.0__=
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=__PartBF9B394B.0__=--
John Calcote [ Sa, 10 Februar 2007 20:04 ] [ ID #1625099 ]

RE: reconnect failing in 3.51.12

--=__Part9CB804C7.0__=
Content-Type: multipart/alternative; boundary="=__Part9CB804C7.1__="

--=__Part9CB804C7.1__=
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Oh, I completely understand the necessity for the timeout. Frankly, I'm =
surprised the default isn't more like 30 minutes rather than 8 hours. My =
problem is that I can't seem to (manually) reconnect within the process =
after a timeout without corrupting the process - ultimately causing either =
a failure to reconnect, or a segfault (and subsequent crash).

John

-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.


>>> On Sat, Feb 10, 2007 at 7:04 PM, in message <003701c74d80$ef84d100$650=
0a8c0 [at] winxppro>, "Lawson Cronlund" <lawson [at] vrtinc.com> wrote:

John,
My interpretation was that the no-activity timeout operation is actually a =
protection that should be in the MySQL server. It*s a protection that =
retires connections that are not properly terminated. If nothing else was =
done, in a poorly implemented system, connections might be left *hanging* =
with random failures on maximum allowed connections.
The documentation seems to say that this timeout interval can be set in =
the configuration file(s) but any changes that I made didn*t seem to =
affect the timeout interval * so I gave up and did the dirty implementation=
which could be viewed as a sort of watchdog to tell me if my application =
was messing up if the connection ever terminated unilaterally.
The result was that my application was improved since it led me to using =
the technique for the watchdog program in my application that monitors the =
alive/dead status of the other application programs in the system.
I guess what I*m saying is that I think that the no-activity connection =
timeout in MySQL is a good thing but I would have liked it if I could have =
found the method for changing the timeout value.
Regards,


--=__Part9CB804C7.1__=
Content-Type: text/html; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Oh, I completely understand the necessity for the timeout. Frankly, =
I'm surprised the default isn't more like 30 minutes rather than 8 hours. =
My problem is that I can't seem to (manually) reconnect within the process =
after a timeout without corrupting the process - ultimately causing either =
a failure to reconnect, or a segfault (and subsequent crash).</DIV>
<DIV> </DIV>
<DIV>John</DIV>
<DIV> </DIV>
<DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. Software Engineeer<=
BR>Novell, Inc.<BR><BR><BR>>>> On Sat, Feb 10, 2007 at  7:04 =
PM, in message <003701c74d80$ef84d100$6500a8c0 [at] winxppro>, "Lawson =
Cronlund" <lawson [at] vrtinc.com> wrote:<BR></DIV>
<DIV style=3D"PADDING-LEFT: 7px; MARGIN: 0px 0px 0px 15px; BORDER-LEFT: =
#050505 1px solid; BACKGROUND-COLOR: #f3f3f3">
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">John,<?xml:names=
pace prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office" =
/><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">My interpretatio=
n was that the no-activity timeout operation is actually a protection that =
should be in the MySQL server.  It's a protection that retires =
connections that are not properly terminated.  If nothing else was =
done, in a poorly implemented system, connections might be left "hanging" =
with random failures on maximum allowed connections.<o:p></o:p></SPAN></FON=
T></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">The documentatio=
n seems to say that this timeout interval can be set in the configuration =
file(s) but any changes that I made didn't seem to affect the timeout =
interval - so I gave up and did the dirty implementation which could be =
viewed as a sort of watchdog to tell me if my application was messing up =
if the connection ever terminated unilaterally.<o:p></o:p></SPAN></FONT></P=
>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">The result was =
that my application was improved since it led me to using the technique =
for the watchdog program in my application that monitors the alive/dead =
status of the other application programs in the system.<o:p></o:p></SPAN></=
FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">I guess what =
I'm saying is that I think that the no-activity connection timeout in =
MySQL is a good thing but I would have liked it if I could have found the =
method for changing the timeout value.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial">Regards,<o:p></o=
:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE:=
10pt; FONT-FAMILY: Tahoma"><o:p></o:p></SPAN></FONT> </P></DIV></DIV>=
</BODY></HTML>

--=__Part9CB804C7.1__=--

--=__Part9CB804C7.0__=
Content-Type: text/plain; name="John Calcote.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="John Calcote.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=3DQUOTED-PRINTABLE:Joh n Calcote=3D0A=
=3D
PRV-H-511=3D0A=3D
Provo
END:VCARD



--=__Part9CB804C7.0__=
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=__Part9CB804C7.0__=--
John Calcote [ Mo, 12 Februar 2007 18:41 ] [ ID #1626417 ]

Re: reconnect failing in 3.51.12

Stay-alive messages definitely have their place.

I have a serial port device that times out after one _second_ of
inactivity, so I use a timer to send it a specific message to keep the
port open.

Re: the process' crashing, perhaps very few people try to keep a
connection open for so long, so fixing the bug isn't worth the effort .
.. . especially since a workaround is to "do nothing" once in a while.

-- Jordan Bradford
----------------------------
BrownBoots Interactive, Inc.
108 South Main St.
Fond du Lac, WI 54935
920-906-9175
http://www.brownboots.com/


John Calcote wrote:
> Oh, I completely understand the necessity for the timeout. Frankly, I'm
> surprised the default isn't more like 30 minutes rather than 8 hours. My
> problem is that I can't seem to (manually) reconnect within the process
> after a timeout without corrupting the process - ultimately causing
> either a failure to reconnect, or a segfault (and subsequent crash).
>
> John
>
> -----
> John Calcote (jcalcote [at] novell.com)
> Sr. Software Engineeer
> Novell, Inc.
>
>
>>>> On Sat, Feb 10, 2007 at 7:04 PM, in message
> <003701c74d80$ef84d100$6500a8c0 [at] winxppro>, "Lawson Cronlund"
> <lawson [at] vrtinc.com> wrote:
>
> John,
>
> My interpretation was that the no-activity timeout operation is actually
> a protection that should be in the MySQL server. It's a protection that
> retires connections that are not properly terminated. If nothing else
> was done, in a poorly implemented system, connections might be left
> "hanging" with random failures on maximum allowed connections.
>
> The documentation seems to say that this timeout interval can be set in
> the configuration file(s) but any changes that I made didn't seem to
> affect the timeout interval - so I gave up and did the dirty
> implementation which could be viewed as a sort of watchdog to tell me if
> my application was messing up if the connection ever terminated
> unilaterally.
>
> The result was that my application was improved since it led me to using
> the technique for the watchdog program in my application that monitors
> the alive/dead status of the other application programs in the system.
>
> I guess what I'm saying is that I think that the no-activity connection
> timeout in MySQL is a good thing but I would have liked it if I could
> have found the method for changing the timeout value.
>
> Regards,
>
>
>
>
> ------------------------------------------------------------ ------------
>
> BEGIN:VCARD
> VERSION:2.1
> X-GWTYPE:USER
> FN:John Calcote
> TEL;WORK:1-801-861-7517
> ORG:;Unified Identity System Eng TE
> TEL;PREF;FAX:801/861-2292
> EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
> N:Calcote;John;;Sr. Software Engineer
> TITLE:Sr. Software Engineer
> ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
> LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:John Calcote=0A=
> PRV-H-511=0A=
> Provo
> END:VCARD
>
>
>
>
> ------------------------------------------------------------ ------------
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Jordan Bradford [ Mo, 12 Februar 2007 20:42 ] [ ID #1626418 ]

RE: reconnect failing in 3.51.12

--=__Part684CF066.0__=
Content-Type: multipart/alternative; boundary="=__Part684CF066.1__="

--=__Part684CF066.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Just wanted everyone to know the resolution to this problem. There's an option that can be specified in the (unixODBC) odbc.ini file to enable an option called "auto-reconnect". This option supposedly allows transparent reconnection with a few caveats.

(/etc/unixODBC/odbc.ini)
...
options = 4194304
...

The value 4194304 is decimal for the hex value 0x400000, which makes a little more sense - it's a bit flag that indicates an option to the myodbc driver.

Using this option, my ODBC client app no longer crashes (yet). To me this is quirky behavior anyway because this option should not be related to the way I was reconnecting anyway. In reality, it's a work-around - allow the underlying driver to reconnect rather than doing it in the app.

I'll let you all know if this status changes.

Thanks for the suggestions,
John



-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.

--=__Part684CF066.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Just wanted everyone to know the resolution to this problem. There's =
an option that can be specified in the (unixODBC) odbc.ini file to enable =
an option called "auto-reconnect". This option supposedly allows transparen=
t reconnection with a few caveats. </DIV>
<DIV> </DIV>
<DIV>   (/etc/unixODBC/odbc.ini)</DIV>
<DIV>   ...</DIV>
<DIV>   options =3D 4194304</DIV>
<DIV>   ...</DIV>
<DIV> </DIV>
<DIV>The value 4194304 is decimal for the hex value 0x400000, which makes =
a little more sense - it's a bit flag that indicates an option to the =
myodbc driver.</DIV>
<DIV> </DIV>
<DIV>Using this option, my ODBC client app no longer crashes (yet). To me =
this is quirky behavior anyway because this option should not be related =
to the way I was reconnecting anyway. In reality, it's a work-around - =
allow the underlying driver to reconnect rather than doing it in the =
app.</DIV>
<DIV> </DIV>
<DIV>I'll let you all know if this status changes.</DIV>
<DIV> </DIV>
<DIV>Thanks for the suggestions,</DIV>
<DIV>John<BR><BR></DIV>
<DIV> </DIV>
<DIV> </DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. =
Software Engineeer<BR>Novell, Inc.<BR></BODY></HTML>

--=__Part684CF066.1__=--

--=__Part684CF066.0__=
Content-Type: text/plain; name="John Calcote.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="John Calcote.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=3DQUOTED-PRINTABLE:Joh n Calcote=3D0A=
=3D
PRV-H-511=3D0A=3D
Provo
END:VCARD



--=__Part684CF066.0__=
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=__Part684CF066.0__=--
John Calcote [ Di, 13 Februar 2007 00:08 ] [ ID #1626420 ]

RE: reconnect failing in 3.51.12

--=__PartFDD96728.0__=
Content-Type: multipart/alternative; boundary="=__PartFDD96728.1__="

--=__PartFDD96728.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

A final note on this issue - I noticed I didn't have the problem at all on my SuSE 10.2 machine.

In order to truely keep my ODBC client app from crashing during reconnect, I had to upgrade to the following revisions of rpm packages on my SuSE 10.1 box:


unixODBC-2.2.12-13.i586.rpm (from 2.2.11-19)
mysql-5.0.26-12.i586.rpm (from 5.0.18-20.8)
mysql-client-5.0.26-12.i586.rpm (from 5.0.18-16)
mysql-shared-5.0.26-12.i586.rpm (from 5.0.18-16)
MyODBC-unixODBC-3.51.12-33 (from 3.51.12-11)


The upgrade of unixODBC did nothing. Upgrading to mysql 5.0.26 and MyODBC 3.51.12-33 is what fixed the problem for me. I'm now able to completely reconnect with no trouble.

I checked the ChangeLog on MyODBC 3.51.12-33 - apparently the only difference between 3.51.12-11 and 3.51.12-33 is that make -j was used to build (multi-threaded make). Should have been a harmless build process change. I believe ultimately it made no difference.

I'm guessing the problem was fixed between mysql 5.0.18 and 5.0.26.

Question: Why couldn't someone from MySQL have told me this? It's not like there's a lot of traffic on this list. Don't they monitor?

John

-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.


>>> On Mon, Feb 12, 2007 at 4:08 PM, in message <45D09106.37FF.0081.0 [at] novell.com>, "John Calcote" <jcalcote [at] novell.com> wrote:
Just wanted everyone to know the resolution to this problem. There's an option that can be specified in the (unixODBC) odbc.ini file to enable an option called "auto-reconnect". This option supposedly allows transparent reconnection with a few caveats.

(/etc/unixODBC/odbc.ini)
...
options = 4194304
...

The value 4194304 is decimal for the hex value 0x400000, which makes a little more sense - it's a bit flag that indicates an option to the myodbc driver.

Using this option, my ODBC client app no longer crashes (yet). To me this is quirky behavior anyway because this option should not be related to the way I was reconnecting anyway. In reality, it's a work-around - allow the underlying driver to reconnect rather than doing it in the app.

I'll let you all know if this status changes.

Thanks for the suggestions,
John



-----
John Calcote (jcalcote [at] novell.com)
Sr. Software Engineeer
Novell, Inc.

--=__PartFDD96728.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>A final note on this issue - I noticed I didn't have the problem =
at all on my SuSE 10.2 machine. </DIV>
<DIV> </DIV>
<DIV>In order to truely keep my ODBC client app from crashing during =
reconnect, I had to upgrade to the following revisions of rpm =
packages on my SuSE 10.1 box:</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>   unixODBC-2.2.12-13.i586.rpm (from 2.2.11-19)<BR> &nb=
sp; mysql-5.0.26-12.i586.rpm (from 5.0.18-20.8)<BR>   mysql-clien=
t-5.0.26-12.i586.rpm (from 5.0.18-16)<BR>   mysql-shared-5.0.26-1=
2.i586.rpm (from 5.0.18-16)<BR>   MyODBC-unixODBC-3.51.12-33 =
(from 3.51.12-11)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>The upgrade of unixODBC did nothing. Upgrading to mysql 5.0.26 and =
MyODBC 3.51.12-33 is what fixed the problem for me. I'm now able to =
completely reconnect with no trouble. </DIV>
<DIV> </DIV>
<DIV>I checked the ChangeLog on MyODBC 3.51.12-33 - apparently the only =
difference between 3.51.12-11 and 3.51.12-33 is that make -j was used to =
build (multi-threaded make). Should have been a harmless build process =
change. I believe ultimately it made no difference.</DIV>
<DIV> </DIV>
<DIV>I'm guessing the problem was fixed between mysql 5.0.18 and 5.0.26.</D=
IV>
<DIV> </DIV>
<DIV>Question: Why couldn't someone from MySQL have told me this? It's not =
like there's a lot of traffic on this list. Don't they monitor? </DIV>
<DIV> </DIV>
<DIV>John</DIV>
<DIV> </DIV>
<DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. Software Engineeer<=
BR>Novell, Inc.<BR><BR><BR>>>> On Mon, Feb 12, 2007 at  4:08 =
PM, in message <45D09106.37FF.0081.0 [at] novell.com>, "John Calcote" =
<jcalcote [at] novell.com> wrote:<BR></DIV>
<DIV style=3D"PADDING-LEFT: 7px; MARGIN: 0px 0px 0px 15px; BORDER-LEFT: =
#050505 1px solid; BACKGROUND-COLOR: #f3f3f3">
<DIV>Just wanted everyone to know the resolution to this problem. There's =
an option that can be specified in the (unixODBC) odbc.ini file to enable =
an option called "auto-reconnect". This option supposedly allows transparen=
t reconnection with a few caveats. </DIV>
<DIV> </DIV>
<DIV>   (/etc/unixODBC/odbc.ini)</DIV>
<DIV>   ...</DIV>
<DIV>   options =3D 4194304</DIV>
<DIV>   ...</DIV>
<DIV> </DIV>
<DIV>The value 4194304 is decimal for the hex value 0x400000, which makes =
a little more sense - it's a bit flag that indicates an option to the =
myodbc driver.</DIV>
<DIV> </DIV>
<DIV>Using this option, my ODBC client app no longer crashes (yet). To me =
this is quirky behavior anyway because this option should not be related =
to the way I was reconnecting anyway. In reality, it's a work-around - =
allow the underlying driver to reconnect rather than doing it in the =
app.</DIV>
<DIV> </DIV>
<DIV>I'll let you all know if this status changes.</DIV>
<DIV> </DIV>
<DIV>Thanks for the suggestions,</DIV>
<DIV>John<BR><BR></DIV>
<DIV> </DIV>
<DIV> </DIV>-----<BR>John Calcote (jcalcote [at] novell.com)<BR>Sr. =
Software Engineeer<BR>Novell, Inc.<BR></DIV></BODY></HTML>

--=__PartFDD96728.1__=--

--=__PartFDD96728.0__=
Content-Type: text/plain; name="John Calcote.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="John Calcote.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:John Calcote
TEL;WORK:1-801-861-7517
ORG:;Unified Identity System Eng TE
TEL;PREF;FAX:801/861-2292
EMAIL;WORK;PREF;NGW:JCALCOTE [at] novell.com
N:Calcote;John;;Sr. Software Engineer
TITLE:Sr. Software Engineer
ADR;DOM;WORK;PARCEL;POSTAL:;PRV-H-511;;Provo
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=3DQUOTED-PRINTABLE:Joh n Calcote=3D0A=
=3D
PRV-H-511=3D0A=3D
Provo
END:VCARD



--=__PartFDD96728.0__=
Content-Type: text/plain; charset=us-ascii


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=__PartFDD96728.0__=--
John Calcote [ Di, 13 Februar 2007 22:14 ] [ ID #1627698 ]
Datenbanken » gmane.comp.db.mysql.odbc » reconnect failing in 3.51.12

Vorheriges Thema: 3.51.06-stable
Nächstes Thema: ODBC connector 3.51/5.0

[ Startseite ] [ Administrator ] [ Suche ] [ Hinweise ] [ Impressum ]

Powered by FudForum