MySQL Bugs: #60671: mysql odbc(5.1.8) using oracle Dg4odbc on Linux x86-64 Hangs

Bug #60671	mysql odbc(5.1.8) using oracle Dg4odbc on Linux x86-64 Hangs - Error 942
Submitted:	28 Mar 2011 8:43	Modified:	16 Jun 2011 11:26
Reporter:	zhong li	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.1.8	OS:	Linux (centos5.3)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any
Tags:	Dg4odbc and mysql odbc

Description:
Using Database Gateway for ODBC (DG4ODBC) 11.1.0.6 from Linux x86-64 to execute DBMS_HS_PASSTHROUGH  against a MySQL database with the MySQL ODBC driver version 3.51.12 hangs.
A DG4ODBC debug trace ends with the statements -

Entered hgopdsc at 2008/10/24-13:38:24 
Describing procedure username.DBMS_HS_PASSTHROUGH 
Output hoada 
hgopdsc, line 1222: NO hoada to print 
Exiting hgopdsc, rc=942 at 2008/10/24-13:38:24 
Entered hgodtab at 2008/10/24-13:38:24 
count:1 
table: username.DBMS_HS_PASSTHROUGH 

How to repeat:
please refer to oracle metalink url:

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=748610.1

hgodtab, line 876: NO hoada to print
Exiting hgodtab, rc=0 at 2011/03/28-07:25:00
Entered hgopars, cursor id 2 at 2011/03/28-07:25:00
 type:0
SQL text from hgopars, id=2, len=33 ...
     00: 53454C45 4354202A 2046524F 4D204442  [SELECT * FROM DB]
     10: 4D535F48 535F5041 53535448 524F5547  [MS_HS_PASSTHROUG]
     20: 48                                   [H]
Entered hgopoer at 2011/03/28-07:25:00
hgopoer, line 233: got native error 1146 and sqlstate 42S02; message follows...
[MySQL][ODBC 5.1 Driver][mysqld-5.1.55-webex--with-unix-socket-path=/home-log]Table 'userregistry.dbms_hs_passthrough' doesn't exist {42S02,NativeErr = 1146}
Exiting hgopoer, rc=0 at 2011/03/28-07:25:00
hgopars, line 526: calling SQLNumResultCols got sqlstate 42S02
Exiting hgopars, rc=942 at 2011/03/28-07:25:00
Entered hgodtab at 2011/03/28-07:25:00

Describing procedure DUAL
Output hoada
hgopdsc, line 1406: NO hoada to print
Exiting hgopdsc, rc=942 at 2011/03/28-07:25:00
The hoada for table DUAL follows...
hgodtab, line 876: NO hoada to print
Exiting hgodtab, rc=0 at 2011/03/28-07:25:00
Entered hgopars, cursor id 2 at 2011/03/28-07:25:00
 type:0
SQL text from hgopars, id=2, len=18 ...
     00: 53454C45 4354202A 2046524F 4D204455  [SELECT * FROM DU]
     10: 414C                                 [AL]
Entered hgopoer at 2011/03/28-07:25:00
hgopoer, line 233: got native error 1096 and sqlstate HY000; message follows...
[MySQL][ODBC 5.1 Driver][mysqld-5.1.55-webex--with-unix-socket-path=/home-log]No tables used {HY000,NativeErr = 1096}
Exiting hgopoer, rc=0 at 2011/03/28-07:25:00
hgopars, line 526: calling SQLNumResultCols got sqlstate HY000

Hi Zhong,

I see you upgraded your ODBC driver 3.51.12 to 5.1.8 in order to fix the hangs in the driver module.

Is it still hanging with Connector/ODBC 5.1.8?

What is this error message?

[MySQL][ODBC 5.1 Driver][mysqld-5.1.55-webex--with-unix-socket-path=/home-log]Table 'userregistry.dbms_hs_passthrough' doesn't exist {42S02,NativeErr = 1146}

Are you trying to select from non-existing table? It could happen that the table exists, but the table has been referenced in uppercase when created in lowercase.

Also, similar errors might occur when trying to load the driver directly (without the driver manager). Can you please provide your init<SID_NAME>.ora file?
Thanks.

Zhong, any news on this bug?

HI Bogdan,

please colse this bug , because the oracle dgodbc does not suport the two-phase commit,so when use the DGODBC+MYSQL+UNIXODBC by oracle trigger, it will raise this error.

Thanks Zhong, closing the bug.