MySQL Forums
Forum List  »  Connector/ODBC

Re: MySql ODBC Memory Leak?
Posted by: M K
Date: November 28, 2017 02:42PM

Below is the ODBC trace file. I notice references to SQLFreeConnect & SQLFreeEnv which have were previously deprecated by Microsoft?




xxx 2740-1184 ENTER SQLAllocEnv
HENV * 0x008FDA2C

xxx 2740-1184 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x008FDA2C ( 0x0E323138)

xxx 2740-1184 ENTER SQLAllocConnect
HENV 0x0E323138
HDBC * 0x008FD958

xxx 2740-1184 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x0E323138
HDBC * 0x008FD958 ( 0x0E344A70)

xxx 2740-1184 ENTER SQLSetConnectOptionW
HDBC 0x0E344A70
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 20

xxx 2740-1184 EXIT SQLSetConnectOptionW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 20

xxx 2740-1184 ENTER SQLSetConnectAttrW
SQLHDBC 0x0E344A70
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

xxx 2740-1184 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x0E344A70
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3

xxx 2740-1184 ENTER SQLDriverConnectW
HDBC 0x0E344A70
HWND 0x00082148
WCHAR * 0x659322F0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x659322F0
SWORD -3
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

xxx 2740-1184 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
HWND 0x00082148
WCHAR * 0x659322F0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x659322F0 <Invalid buffer length!> [-3]
SWORD -3
SWORD * 0x00000000
UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x008FD950
SWORD 2
SWORD * 0x008FD954

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x008FD950 (1) <SQL_OAC_LEVEL1>
SWORD 2
SWORD * 0x008FD954 (2)

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x008FD95C
SWORD 200
SWORD * 0x008FD954

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x008FD95C [ 24] "myodbc5a.dll"
SWORD 200
SWORD * 0x008FD954 (24)

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x008FD50C
SWORD 2
SWORD * 0x008FD4C0

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x008FD50C (3) <SQL_TC_DDL_COMMIT>
SWORD 2
SWORD * 0x008FD4C0 (2)

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x146F82CC
SWORD 2
SWORD * 0x008FD4C0

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x146F82CC (2) <SQL_CB_PRESERVE>
SWORD 2
SWORD * 0x008FD4C0 (2)

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x146F82CE
SWORD 2
SWORD * 0x008FD4C0

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x146F82CE (2) <SQL_CB_PRESERVE>
SWORD 2
SWORD * 0x008FD4C0 (2)

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x008FD510
SWORD 2
SWORD * 0x008FD4EC

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x008FD510 (0)
SWORD 2
SWORD * 0x008FD4EC (2)

xxx 2740-1184 ENTER SQLAllocStmt
HDBC 0x0E344A70
HSTMT * 0x008FD4C8

xxx 2740-1184 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
HSTMT * 0x008FD4C8 ( 0x0E344DB8)

xxx 2740-1184 ENTER SQLGetStmtAttrW
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FD46C
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FD46C (0)
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 ENTER SQLExecDirectW
HSTMT 0x0E344DB8
WCHAR * 0x5FD6C990 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
SDWORD -3

xxx 2740-1184 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x0E344DB8
WCHAR * 0x5FD6C990 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"
SDWORD -3

DIAG [S0002] [MySQL][ODBC 5.3(a) Driver][mysqld-5.7.20-log]Table 'xxx.msysconf' doesn't exist (1146)

xxx 2740-1184 ENTER SQLErrorW
HENV 0x0E323138
HDBC 0x0E344A70
HSTMT 0x0E344DB8
WCHAR * 0x008FD430
SDWORD * 0x008FD3F8
WCHAR * 0x0FAEF6F0
SWORD 4095
SWORD * 0x008FD3EC

xxx 2740-1184 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x0E323138
HDBC 0x0E344A70
HSTMT 0x0E344DB8
WCHAR * 0x008FD430 [ 5] "S0002"
SDWORD * 0x008FD3F8 (1146)
WCHAR * 0x0FAEF6F0 [ 88] "[MySQL][ODBC 5.3(a) Driver][mysqld-5.7.20-log]Table 'xxx.msysconf' doesn't exist"
SWORD 4095
SWORD * 0x008FD3EC (88)

xxx 2740-1184 ENTER SQLErrorW
HENV 0x0E323138
HDBC 0x0E344A70
HSTMT 0x0E344DB8
WCHAR * 0x008FD430
SDWORD * 0x008FD3F8
WCHAR * 0x0FAEF7B8
SWORD 3995
SWORD * 0x008FD3EC

xxx 2740-1184 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 0x0E323138
HDBC 0x0E344A70
HSTMT 0x0E344DB8
WCHAR * 0x008FD430
SDWORD * 0x008FD3F8
WCHAR * 0x0FAEF7B8
SWORD 3995
SWORD * 0x008FD3EC

xxx 2740-1184 ENTER SQLFreeStmt
HSTMT 0x0E344DB8
UWORD 1 <SQL_DROP>

xxx 2740-1184 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x0E344DB8
UWORD 1 <SQL_DROP>

xxx 2740-1184 ENTER SQLGetInfoW
HDBC 0x0E344A70
UWORD 17 <SQL_DBMS_NAME>
PTR 0x008FE1E8
SWORD 200
SWORD * 0x008FE1E4

xxx 2740-1184 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
UWORD 17 <SQL_DBMS_NAME>
PTR 0x008FE1E8 [ 10] "MySQL"
SWORD 200
SWORD * 0x008FE1E4 (10)

xxx 2740-1184 ENTER SQLAllocStmt
HDBC 0x0E344A70
HSTMT * 0x1B2F1040

xxx 2740-1184 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
HSTMT * 0x1B2F1040 ( 0x0E344DB8)

xxx 2740-1184 ENTER SQLGetStmtAttrW
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FE240
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FE240 (0)
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E344DB8
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 ENTER SQLExecDirectW
HSTMT 0x0E344DB8
WCHAR * 0x1B2F10FC [ -3] "SELECT `control`.`ID` FROM `control` \ 0"
SDWORD -3

xxx 2740-1184 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS)
HSTMT 0x0E344DB8
WCHAR * 0x1B2F10FC [ -3] "SELECT `control`.`ID` FROM `control` \ 0"
SDWORD -3

xxx 2740-1184 ENTER SQLFetch
HSTMT 0x0E344DB8

xxx 2740-1184 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 0x0E344DB8

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E344DB8
UWORD 1
SWORD 99 <SQL_C_DEFAULT>
PTR <unknown type>
SQLLEN 508
SQLLEN * 0x008FDFA0

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E344DB8
UWORD 1
SWORD 99 <SQL_C_DEFAULT>
PTR <unknown type>
SQLLEN 508
SQLLEN * 0x008FDFA0 (4)

xxx 2740-1184 ENTER SQLAllocStmt
HDBC 0x0E344A70
HSTMT * 0x1B2F1230

xxx 2740-1184 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70
HSTMT * 0x1B2F1230 ( 0x0E345128)

xxx 2740-1184 ENTER SQLGetStmtAttrW
SQLHSTMT 0x0E345128
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FC72C
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E345128
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x008FC72C (0)
SQLINTEGER -5
SQLINTEGER * 0x00000000

xxx 2740-1184 ENTER SQLSetStmtAttrW
SQLHSTMT 0x0E345128
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x0E345128
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 60
SQLINTEGER -5

xxx 2740-1184 ENTER SQLPrepareW
HSTMT 0x0E345128
WCHAR * 0x1B2F17BC [ -3] "SELECT `ID`,`boolStopLoop`,`boolDebugMode`,`strDebugFileName` FROM `control` WHERE `ID` = ?\ 0"
SDWORD -3

xxx 2740-1184 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
WCHAR * 0x1B2F17BC [ -3] "SELECT `ID`,`boolStopLoop`,`boolDebugMode`,`strDebugFileName` FROM `control` WHERE `ID` = ?\ 0"
SDWORD -3

xxx 2740-1184 ENTER SQLBindParameter
HSTMT 0x0E345128
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x008FCFF8
SQLLEN 0
SQLLEN * 0x008FCFF4

xxx 2740-1184 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x008FCFF8
SQLLEN 0
SQLLEN * 0x008FCFF4 (4)

xxx 2740-1184 ENTER SQLExecute
HSTMT 0x0E345128

xxx 2740-1184 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128

xxx 2740-1184 ENTER SQLFetch
HSTMT 0x0E345128

xxx 2740-1184 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468 (4)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 2
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 2
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468 (2)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 3
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 3
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FC468 (2)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x008FC52C
SQLLEN 512
SQLLEN * 0x008FC468

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x008FC52C [ 80] "debug.log"
SQLLEN 512
SQLLEN * 0x008FC468 (80)

xxx 2740-1184 ENTER SQLFreeStmt
HSTMT 0x0E345128
UWORD 0 <SQL_CLOSE>

xxx 2740-1184 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 0 <SQL_CLOSE>

xxx 2740-1184 ENTER SQLBindParameter
HSTMT 0x0E345128
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x008FE270
SQLLEN 0
SQLLEN * 0x008FE26C

xxx 2740-1184 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x008FE270
SQLLEN 0
SQLLEN * 0x008FE26C (4)

xxx 2740-1184 ENTER SQLExecute
HSTMT 0x0E345128

xxx 2740-1184 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128

xxx 2740-1184 ENTER SQLFetch
HSTMT 0x0E345128

xxx 2740-1184 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0 (4)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 2
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 2
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0 (2)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 3
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 3
SWORD 5 <SQL_C_SHORT>
PTR <unknown type>
SQLLEN 512
SQLLEN * 0x008FD6E0 (2)

xxx 2740-1184 ENTER SQLGetData
HSTMT 0x0E345128
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x008FD7A4
SQLLEN 512
SQLLEN * 0x008FD6E0

xxx 2740-1184 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x008FD7A4 [ 80] "debug.log"
SQLLEN 512
SQLLEN * 0x008FD6E0 (80)

xxx 2740-1184 ENTER SQLFreeStmt
HSTMT 0x0E345128
UWORD 0 <SQL_CLOSE>

xxx 2740-1184 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 0 <SQL_CLOSE>

xxx 2740-1184 ENTER SQLFreeStmt
HSTMT 0x0E345128
UWORD 1 <SQL_DROP>

xxx 2740-1184 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x0E345128
UWORD 1 <SQL_DROP>

xxx 2740-1184 ENTER SQLFreeStmt
HSTMT 0x0E344DB8
UWORD 1 <SQL_DROP>

xxx 2740-1184 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x0E344DB8
UWORD 1 <SQL_DROP>

xxx 2740-1184 ENTER SQLDisconnect
HDBC 0x0E344A70

xxx 2740-1184 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70

xxx 2740-1184 ENTER SQLFreeConnect
HDBC 0x0E344A70

xxx 2740-1184 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 0x0E344A70

xxx 2740-1184 ENTER SQLFreeEnv
HENV 0x0E323138

xxx 2740-1184 EXIT SQLFreeEnv with return code 0 (SQL_SUCCESS)
HENV 0x0E323138

Options: ReplyQuote


Subject
Written By
Posted
M K
November 28, 2017 01:36PM
Re: MySql ODBC Memory Leak?
M K
November 28, 2017 02:42PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.