search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
247 stars 88 forks source link

Connect error (ODBC: ERROR [HY000] No message received”) to Power BI since Release 1.0.0.20190523 #301

Open huangxp12 opened 4 years ago

huangxp12 commented 4 years ago

I have meet such error after Release 1.0.0.20190523 (so I still use the old version )。 I have tested some simple SQL queries such as 'select 1+1' or 'select * from XX ' but all cannot connect, with such error “ ERROR [HY000] No message received”； I checked system.query_log and find the server didn't receive the SQL query 。 This is my settings. image

huangxp12 commented 4 years ago

environment OS：win10 Professional 1909 , Build 18363.836 driver：clickhouse-odbc-1.1.7-win64.msi

Slach commented 4 years ago

@huangxp12 could you change port from 80 to 8123 and check again?

traceon commented 4 years ago

Can you please enable ODBC Driver Manager Tracing, retry, and post the resulting log here? See this entry in the README.md

huangxp12 commented 4 years ago

@traceon quite long , suppose I have done it right, if

pbidesktop 1d48-8ee8 ENTER SQLAllocHandle SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x00000182D386CB90

pbidesktop 1d48-8ee8 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x00000182D386CB90 ( 0x00000182D0A4BAE0)

pbidesktop 1d48-8ee8 ENTER SQLSetEnvAttr SQLHENV 0x00000182D0A4BAE0 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

pbidesktop 1d48-8ee8 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x00000182D0A4BAE0 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

pbidesktop 1d48-8ee8 ENTER SQLSetEnvAttr SQLHENV 0x00000182D0A4BAE0 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

pbidesktop 1d48-8ee8 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x00000182D0A4BAE0 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

Data" 7cf4-8e0c ENTER SQLAllocHandle SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x000001E49D45A3B8

Data" 7cf4-8e0c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x000001E49D45A3B8 ( 0x000001E49460D620)

Data" 7cf4-8e0c ENTER SQLSetEnvAttr SQLHENV 0x000001E49460D620 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

Data" 7cf4-8e0c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x000001E49460D620 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

Data" 7cf4-8e0c ENTER SQLSetEnvAttr SQLHENV 0x000001E49460D620 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

Data" 7cf4-8e0c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x000001E49460D620 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x000002270C8F0628

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 SQLHANDLE 0x0000000000000000 SQLHANDLE * 0x000002270C8F0628 ( 0x000002270AA09150)

Microsoft.Mashu ef4-8a40 ENTER SQLSetEnvAttr SQLHENV 0x000002270AA09150 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

Microsoft.Mashu ef4-8a40 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x000002270AA09150 SQLINTEGER 200 SQLPOINTER 3 SQLINTEGER -6

Microsoft.Mashu ef4-8a40 ENTER SQLSetEnvAttr SQLHENV 0x000002270AA09150 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

Microsoft.Mashu ef4-8a40 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 0x000002270AA09150 SQLINTEGER 201 SQLPOINTER 2 SQLINTEGER -6

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270C976EB0

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270C976EB0 ( 0x000002270AA09230)

Microsoft.Mashu ef4-8a40 ENTER SQLSetConnectAttrW SQLHDBC 0x000002270AA09230 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x000002270AA09230 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 ENTER SQLDriverConnectW HDBC 0x000002270AA09230 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 <Invalid buffer length!> [-3] SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270C97D6F0 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270C97D6F0 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFD8FC (38)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 7 PTR 0x000002270C97EAB8 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 7 PTR 0x000002270C97EAB8 [ 28] "1.1.7.20200414" SWORD 100 SWORD * 0x00000081E1BFD8FC (28)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 17 PTR 0x000002270C97FE88 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 17 PTR 0x000002270C97FE88 [ 20] "ClickHouse" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 18 PTR 0x000002270C981248 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 18 PTR 0x000002270C981248 [ 20] "01.00.0000" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA09230 SQLHANDLE * 0x000002270C984098

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA09230 SQLHANDLE * 0x000002270C984098 ( 0x000002270AA0AD10)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 77 PTR 0x000002270C9840E8 SWORD 100 SWORD * 0x00000081E1BFDA4C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 77 PTR 0x000002270C9840E8 [ 10] "03.80" SWORD 100 SWORD * 0x00000081E1BFDA4C (10)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270C9841E0 SWORD 100 SWORD * 0x00000081E1BFDA8C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270C9841E0 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFDA8C (38)

Microsoft.Mashu ef4-8a40 ENTER SQLExecDirectW HSTMT 0x000002270AA0AD10 WCHAR * 0x000002270C4233DC [ -3] "select 1\ 0" SDWORD -3

Microsoft.Mashu ef4-8a40 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 0x000002270AA0AD10 WCHAR * 0x000002270C4233DC [ -3] "select 1\ 0" SDWORD -3

    DIAG [HY000] No message received (1)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF0690 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 [ 5] "HY000" SQLINTEGER 0x00000081E1BFDA60 (1) SQLWCHAR 0x0000022724EF0690 [ 19] "No message received" SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58 (19)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF0690 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF0690 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10

Microsoft.Mashu ef4-8a40 ENTER SQLDisconnect HDBC 0x000002270AA09230

Microsoft.Mashu ef4-8a40 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA09230

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA09230

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270CB26950

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270CB26950 ( 0x000002270AA09230)

Microsoft.Mashu ef4-8a40 ENTER SQLSetConnectAttrW SQLHDBC 0x000002270AA09230 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x000002270AA09230 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 ENTER SQLDriverConnectW HDBC 0x000002270AA09230 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 <Invalid buffer length!> [-3] SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270CB28598 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270CB28598 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFD8FC (38)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 7 PTR 0x000002270CB29978 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 7 PTR 0x000002270CB29978 [ 28] "1.1.7.20200414" SWORD 100 SWORD * 0x00000081E1BFD8FC (28)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 17 PTR 0x000002270CB2AD30 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 17 PTR 0x000002270CB2AD30 [ 20] "ClickHouse" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 18 PTR 0x000002270CB2C0F0 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 18 PTR 0x000002270CB2C0F0 [ 20] "01.00.0000" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA09230 SQLHANDLE * 0x000002270CB2EC28

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA09230 SQLHANDLE * 0x000002270CB2EC28 ( 0x000002270AA0B880)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 77 PTR 0x000002270CB2EC78 SWORD 100 SWORD * 0x00000081E1BFDA4C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 77 PTR 0x000002270CB2EC78 [ 10] "03.80" SWORD 100 SWORD * 0x00000081E1BFDA4C (10)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270CB2ED40 SWORD 100 SWORD * 0x00000081E1BFDA8C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230 UWORD 6 PTR 0x000002270CB2ED40 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFDA8C (38)

Microsoft.Mashu ef4-8a40 ENTER SQLExecDirectW HSTMT 0x000002270AA0B880 WCHAR * 0x000002270C4233DC [ -3] "select 1\ 0" SDWORD -3

Microsoft.Mashu ef4-8a40 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 0x000002270AA0B880 WCHAR * 0x000002270C4233DC [ -3] "select 1\ 0" SDWORD -3

    DIAG [HY000] No message received (1)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF1320 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 [ 5] "HY000" SQLINTEGER 0x00000081E1BFDA60 (1) SQLWCHAR 0x0000022724EF1320 [ 19] "No message received" SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58 (19)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF1320 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724EF1320 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880

Microsoft.Mashu ef4-8a40 ENTER SQLDisconnect HDBC 0x000002270AA09230

Microsoft.Mashu ef4-8a40 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA09230

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA09230

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA09230

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270C8DCA58

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA09150 SQLHANDLE * 0x000002270C8DCA58 ( 0x000002270AA0AD10)

Microsoft.Mashu ef4-8a40 ENTER SQLSetConnectAttrW SQLHDBC 0x000002270AA0AD10 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 0x000002270AA0AD10 SQLINTEGER 103 SQLPOINTER 15 SQLINTEGER -5

Microsoft.Mashu ef4-8a40 ENTER SQLDriverConnectW HDBC 0x000002270AA0AD10 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 HWND 0x0000000000000000 WCHAR * 0x00007FFAA4C821A0 [ -3] "**\ 0" SWORD -3 WCHAR 0x00007FFAA4C821A0 <Invalid buffer length!> [-3] SWORD -3 SWORD 0x0000000000000000 UWORD 0

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 6 PTR 0x000002270C8E2E28 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 6 PTR 0x000002270C8E2E28 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFD8FC (38)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 7 PTR 0x000002270C8E4208 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 7 PTR 0x000002270C8E4208 [ 28] "1.1.7.20200414" SWORD 100 SWORD * 0x00000081E1BFD8FC (28)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 17 PTR 0x000002270C8E55C0 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 17 PTR 0x000002270C8E55C0 [ 20] "ClickHouse" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 18 PTR 0x000002270C8E6980 SWORD 100 SWORD * 0x00000081E1BFD8FC

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 18 PTR 0x000002270C8E6980 [ 20] "01.00.0000" SWORD 100 SWORD * 0x00000081E1BFD8FC (20)

Microsoft.Mashu ef4-8a40 ENTER SQLAllocHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLHANDLE * 0x000002270C8E94B8

Microsoft.Mashu ef4-8a40 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0AD10 SQLHANDLE * 0x000002270C8E94B8 ( 0x000002270AA0B880)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 77 PTR 0x000002270C8E9508 SWORD 100 SWORD * 0x00000081E1BFDA4C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 77 PTR 0x000002270C8E9508 [ 10] "03.80" SWORD 100 SWORD * 0x00000081E1BFDA4C (10)

Microsoft.Mashu ef4-8a40 ENTER SQLGetInfoW HDBC 0x000002270AA0AD10 UWORD 6 PTR 0x000002270C8E95D0 SWORD 100 SWORD * 0x00000081E1BFDA8C

Microsoft.Mashu ef4-8a40 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10 UWORD 6 PTR 0x000002270C8E95D0 [ 38] "CLICKHOUSEODBCW.DLL" SWORD 100 SWORD * 0x00000081E1BFDA8C (38)

Microsoft.Mashu ef4-8a40 ENTER SQLExecDirectW HSTMT 0x000002270AA0B880 WCHAR * 0x000002270C411CF4 [ -3] "select 1\ 0" SDWORD -3

Microsoft.Mashu ef4-8a40 EXIT SQLExecDirectW with return code -1 (SQL_ERROR) HSTMT 0x000002270AA0B880 WCHAR * 0x000002270C411CF4 [ -3] "select 1\ 0" SDWORD -3

    DIAG [HY000] No message received (1)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724E0CF80 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 1 SQLWCHAR 0x00000081E1BFD890 [ 5] "HY000" SQLINTEGER 0x00000081E1BFDA60 (1) SQLWCHAR 0x0000022724E0CF80 [ 19] "No message received" SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58 (19)

Microsoft.Mashu ef4-8a40 ENTER SQLGetDiagRecW SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724E0CF80 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880 SQLSMALLINT 2 SQLWCHAR 0x00000081E1BFD890 SQLINTEGER 0x00000081E1BFDA60 SQLWCHAR 0x0000022724E0CF80 SQLSMALLINT 1024 SQLSMALLINT 0x00000081E1BFDA58

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 0x000002270AA0B880

Microsoft.Mashu ef4-8a40 ENTER SQLDisconnect HDBC 0x000002270AA0AD10

Microsoft.Mashu ef4-8a40 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS) HDBC 0x000002270AA0AD10

Microsoft.Mashu ef4-8a40 ENTER SQLFreeHandle SQLSMALLINT 2 SQLHANDLE 0x000002270AA0AD10

Microsoft.Mashu ef4-8a40 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 0x000002270AA0AD10

Can you please enable ODBC Driver Manager Tracing, retry, and post the resulting log here? See this entry in the README.md

huangxp12 commented 4 years ago

@huangxp12 could you change port from 80 to 8123 and check again?

Thank you , but it also doesn't work unfortunately.

traceon commented 4 years ago

@huangxp12 can you also enable driver's own logging and send the generated log? Please, see DriverLog and DriverLogFile DSN parameters here.

huangxp12 commented 4 years ago

@huangxp12 can you also enable driver's own logging and send the generated log? Please, see DriverLog and DriverLogFile DSN parameters here.

I read the links you provided, confused by "DriverLog ：on if CMAKE_BUILD_TYPE is Debug, off otherwise"，so I need to build from source code？I'm not famaliar with CMAKE /sigh

traceon commented 4 years ago

That's just an explanation of what the default value would be. You can use the same driver you are using. Just put

DriverLog = on
DriverLogFile = C:/path/to/odbc_driver.log

in your DSN. You will need to add it as a string entry in the corresponding registry key. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI plus the name of the DSN you are using (system DSNs). Similar key can be found under HKEY_CURRENT_USER for user DSNs.

huangxp12 commented 4 years ago

That's just an explanation of what the default value would be. You can use the same driver you are using. Just put

DriverLog = on
DriverLogFile = C:/path/to/odbc_driver.log

in your DSN. You will need to add it as a string entry in the corresponding registry key. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI plus the name of the DSN you are using (system DSNs). Similar key can be found under HKEY_CURRENT_USER for user DSNs.

Thanks , as I have rolled back to Release 1.0.0.20290523 ,I will try it this weekend.

huangxp12 commented 4 years ago

That's just an explanation of what the default value would be. You can use the same driver you are using. Just put

DriverLog = on
DriverLogFile = C:/path/to/odbc_driver.log

in your DSN. You will need to add it as a string entry in the corresponding registry key. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI plus the name of the DSN you are using (system DSNs). Similar key can be found under HKEY_CURRENT_USER for user DSNs.

==================== ODBC Driver logging session started (2020-06-21 21:20:13 ?D1ú±ê×?ê±??) ==================== ClickHouse ODBC Driver VERSION=1.1.7.20200414 SYSTEM=Windows-10.0.18363 MDAC UNICODE ODBCVER=380 sizeof(void *)=8 sizeof(SQLTCHAR)=2 sizeof(wchar_t)=2 1592745613654546 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\connection.cpp:113 in connect: Creating session with http://rdmint-ck.baicizhan.com:80 1592745613654746 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:1285 in SQLGetFunctions: SQLGetFunctions:1285 id=999 ptr=000000E91B1FBB80 1592745613654961 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 23, out_value_max_length: 2 1592745613654989 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:197 in operator (): GetInfo SQL_CURSOR_COMMIT_BEHAVIOR, type: SQLUSMALLINT, value: SQL_CB_PRESERVE = 2 1592745613655011 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 24, out_value_max_length: 2 1592745613655025 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:197 in operator (): GetInfo SQL_CURSOR_ROLLBACK_BEHAVIOR, type: SQLUSMALLINT, value: SQL_CB_PRESERVE = 2 1592745613655040 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 81, out_value_max_length: 4 1592745613655054 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:217 in operator (): GetInfo SQL_GETDATA_EXTENSIONS, type: SQLUINTEGER, value: SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER | SQL_GD_BOUND = 11 1592745613655072 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 1750, out_value_max_length: 4 1592745613655129 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver/driver.h:250 in operator (): HY000 (Unsupported info type: 1750) 1592745613657692 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 6, out_value_max_length: 100 1592745613660333 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 7, out_value_max_length: 100 1592745613663286 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 17, out_value_max_length: 100 1592745613666338 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 18, out_value_max_length: 100 1592745613669144 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 29, out_value_max_length: 100 1592745613671859 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 91, out_value_max_length: 4 1592745613672005 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:361 in operator (): GetInfo SQL_SCHEMA_USAGE, type: SQLUINTEGER, value: 0 = 0 1592745613674700 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 92, out_value_max_length: 4 1592745613674751 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:204 in operator (): GetInfo SQL_CATALOG_USAGE, type: SQLUINTEGER, value: SQL_CU_DML_STATEMENTS | SQL_CU_TABLE_DEFINITION = 5 1592745613677005 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 41, out_value_max_length: 100 1592745613679518 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 114, out_value_max_length: 4 1592745613679553 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:190 in operator (): GetInfo SQL_CATALOG_LOCATION, type: SQLUSMALLINT, value: SQL_CL_START = 1 1592745613681895 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 118, out_value_max_length: 4 1592745613681932 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:184 in operator (): GetInfo SQL_SQL_CONFORMANCE, type: SQLUINTEGER, value: SQL_SC_SQL92_ENTRY = 1 1592745613684314 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 99, out_value_max_length: 4 1592745613684353 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_COLUMNS_IN_ORDER_BY, type: SQLUSMALLINT, value: 0 = 0 1592745613686758 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 10005, out_value_max_length: 4 1592745613686808 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_IDENTIFIER_LEN, type: SQLUSMALLINT, value: 0 = 0 1592745613689200 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 97, out_value_max_length: 4 1592745613689245 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_COLUMNS_IN_GROUP_BY, type: SQLUSMALLINT, value: 0 = 0 1592745613692301 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 100, out_value_max_length: 4 1592745613692358 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_COLUMNS_IN_SELECT, type: SQLUSMALLINT, value: 0 = 0 1592745613694663 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 90, out_value_max_length: 100 1592745613697058 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 50, out_value_max_length: 4 1592745613697095 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:298 in operator (): GetInfo SQL_STRING_FUNCTIONS, type: SQLUINTEGER, value: SQL_FN_STR_ASCII | SQL_FN_STR_BIT_LENGTH | SQL_FN_STR_CHAR | SQL_FN_STR_CHAR_LENGTH | SQL_FN_STR_CHARACTER_LENGTH | SQL_FN_STR_CONCAT | SQL_FN_STR_DIFFERENCE | SQL_FN_STR_INSERT | SQL_FN_STR_LCASE | SQL_FN_STR_LEFT | SQL_FN_STR_LENGTH | SQL_FN_STR_LOCATE | SQL_FN_STR_LTRIM | SQL_FN_STR_OCTET_LENGTH | SQL_FN_STR_POSITION | SQL_FN_STR_REPEAT | SQL_FN_STR_REPLACE | SQL_FN_STR_RIGHT | SQL_FN_STR_RTRIM | SQL_FN_STR_SOUNDEX | SQL_FN_STR_SPACE | SQL_FN_STR_SUBSTRING | SQL_FN_STR_UCASE = 16711679 1592745613699498 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 169, out_value_max_length: 4 1592745613699541 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:207 in operator (): GetInfo SQL_AGGREGATE_FUNCTIONS, type: SQLUINTEGER, value: SQL_AF_ALL | SQL_AF_AVG | SQL_AF_COUNT | SQL_AF_DISTINCT | SQL_AF_MAX | SQL_AF_MIN | SQL_AF_SUM = 127 1592745613702030 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 160, out_value_max_length: 4 1592745613702096 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:271 in operator (): GetInfo SQL_SQL92_PREDICATES, type: SQLUINTEGER, value: SQL_SP_BETWEEN | SQL_SP_COMPARISON | SQL_SP_EXISTS | SQL_SP_IN | SQL_SP_ISNOTNULL | SQL_SP_ISNULL | SQL_SP_LIKE | SQL_SP_MATCH_FULL | SQL_SP_MATCH_PARTIAL | SQL_SP_MATCH_UNIQUE_FULL | SQL_SP_MATCH_UNIQUE_PARTIAL | SQL_SP_OVERLAPS | SQL_SP_QUANTIFIED_COMPARISON | SQL_SP_UNIQUE = 16383 1592745613704925 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 161, out_value_max_length: 4 1592745613705028 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:277 in operator (): GetInfo SQL_SQL92_RELATIONAL_JOIN_OPERATORS, type: SQLUINTEGER, value: SQL_SRJO_CROSS_JOIN | SQL_SRJO_FULL_OUTER_JOIN | SQL_SRJO_INNER_JOIN | SQL_SRJO_LEFT_OUTER_JOIN | SQL_SRJO_RIGHT_OUTER_JOIN = 346 1592745613707839 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 87, out_value_max_length: 100 1592745613711302 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 88, out_value_max_length: 4 1592745613711370 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:189 in operator (): GetInfo SQL_GROUP_BY, type: SQLUSMALLINT, value: SQL_GB_GROUP_BY_CONTAINS_SELECT = 2 1592745613714281 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 49, out_value_max_length: 4 1592745613714349 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:256 in operator (): GetInfo SQL_NUMERIC_FUNCTIONS, type: SQLUINTEGER, value: SQL_FN_NUM_ABS | SQL_FN_NUM_ACOS | SQL_FN_NUM_ASIN | SQL_FN_NUM_ATAN | SQL_FN_NUM_ATAN2 | SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_COT | SQL_FN_NUM_DEGREES | SQL_FN_NUM_EXP | SQL_FN_NUM_FLOOR | SQL_FN_NUM_LOG | SQL_FN_NUM_LOG10 | SQL_FN_NUM_MOD | SQL_FN_NUM_PI | SQL_FN_NUM_POWER | SQL_FN_NUM_RADIANS | SQL_FN_NUM_RAND | SQL_FN_NUM_ROUND | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN | SQL_FN_NUM_SQRT | SQL_FN_NUM_TAN | SQL_FN_NUM_TRUNCATE = 16777215 1592745613717195 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 52, out_value_max_length: 4 1592745613717255 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:319 in operator (): GetInfo SQL_TIMEDATE_FUNCTIONS, type: SQLUINTEGER, value: SQL_FN_TD_CURRENT_DATE | SQL_FN_TD_CURRENT_TIME | SQL_FN_TD_CURRENT_TIMESTAMP | SQL_FN_TD_CURDATE | SQL_FN_TD_CURTIME | SQL_FN_TD_DAYNAME | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_EXTRACT | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_MONTH | SQL_FN_TD_MONTHNAME | SQL_FN_TD_NOW | SQL_FN_TD_QUARTER | SQL_FN_TD_SECOND | SQL_FN_TD_TIMESTAMPADD | SQL_FN_TD_TIMESTAMPDIFF | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR = 2097151 1592745613719702 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 51, out_value_max_length: 4 1592745613719752 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:361 in operator (): GetInfo SQL_SYSTEM_FUNCTIONS, type: SQLUINTEGER, value: 0 = 0 1592745613722267 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 109, out_value_max_length: 4 1592745613722323 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:307 in operator (): GetInfo SQL_TIMEDATE_ADD_INTERVALS, type: SQLUINTEGER, value: SQL_FN_TSI_FRAC_SECOND | SQL_FN_TSI_SECOND | SQL_FN_TSI_MINUTE | SQL_FN_TSI_HOUR | SQL_FN_TSI_DAY | SQL_FN_TSI_WEEK | SQL_FN_TSI_MONTH | SQL_FN_TSI_QUARTER | SQL_FN_TSI_YEAR = 511 1592745613724901 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 110, out_value_max_length: 4 1592745613724959 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:312 in operator (): GetInfo SQL_TIMEDATE_DIFF_INTERVALS, type: SQLUINTEGER, value: SQL_FN_TSI_FRAC_SECOND | SQL_FN_TSI_SECOND | SQL_FN_TSI_MINUTE | SQL_FN_TSI_HOUR | SQL_FN_TSI_DAY | SQL_FN_TSI_WEEK | SQL_FN_TSI_MONTH | SQL_FN_TSI_QUARTER | SQL_FN_TSI_YEAR = 511 1592745613727930 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 22, out_value_max_length: 4 1592745613728015 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:194 in operator (): GetInfo SQL_CONCAT_NULL_BEHAVIOR, type: SQLUSMALLINT, value: SQL_CB_NULL = 0 1592745613730921 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 10003, out_value_max_length: 100 1592745613733597 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 42, out_value_max_length: 100 1592745613736126 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 39, out_value_max_length: 100 1592745613738724 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 152, out_value_max_length: 4 1592745613738776 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:173 in operator (): GetInfo SQL_ODBC_INTERFACE_CONFORMANCE, type: SQLUINTEGER, value: SQL_OIC_CORE = 1 1592745613741217 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 14, out_value_max_length: 100 1592745613743896 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 48, out_value_max_length: 4 1592745613743940 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:211 in operator (): GetInfo SQL_CONVERT_FUNCTIONS, type: SQLUINTEGER, value: SQL_FN_CVT_CONVERT = 1 1592745613746687 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 53, out_value_max_length: 4 1592745613746728 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_BIGINT, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613749384 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 54, out_value_max_length: 4 1592745613749420 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_BINARY, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613751652 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 55, out_value_max_length: 4 1592745613751687 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_BIT, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613753974 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 56, out_value_max_length: 4 1592745613754014 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_CHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613756413 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 58, out_value_max_length: 4 1592745613756456 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_DECIMAL, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613758742 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 59, out_value_max_length: 4 1592745613758776 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_DOUBLE, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613761255 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 60, out_value_max_length: 4 1592745613761316 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_FLOAT, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613763773 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 173, out_value_max_length: 4 1592745613763804 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_GUID, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613766383 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 61, out_value_max_length: 4 1592745613766413 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_INTEGER, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613768588 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 71, out_value_max_length: 4 1592745613768619 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_LONGVARBINARY, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613770927 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 62, out_value_max_length: 4 1592745613770973 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_LONGVARCHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613773367 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 63, out_value_max_length: 4 1592745613773412 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_NUMERIC, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613775738 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 64, out_value_max_length: 4 1592745613775779 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_REAL, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613778358 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 65, out_value_max_length: 4 1592745613778388 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_SMALLINT, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613780880 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 67, out_value_max_length: 4 1592745613780909 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_TIMESTAMP, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613783455 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 68, out_value_max_length: 4 1592745613783497 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_TINYINT, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613785756 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 57, out_value_max_length: 4 1592745613785786 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_DATE, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613788030 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 66, out_value_max_length: 4 1592745613788064 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_TIME, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613790180 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 69, out_value_max_length: 4 1592745613790214 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_VARBINARY, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613792669 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 70, out_value_max_length: 4 1592745613792702 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_VARCHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613795108 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 122, out_value_max_length: 4 1592745613795136 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_WCHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613797453 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 125, out_value_max_length: 4 1592745613797490 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_WLONGVARCHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613799709 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 126, out_value_max_length: 4 1592745613799743 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:249 in operator (): GetInfo SQL_CONVERT_WVARCHAR, type: SQLUINTEGER, value: mask_common_CONVERT_dest = 33554431 1592745613801870 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 94, out_value_max_length: 100 1592745613804249 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 180, out_value_max_length: 4 1592745613804311 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver/driver.h:250 in operator (): HY000 (Unsupported info type: 180) 1592745613816598 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 1, out_value_max_length: 2 1592745613816649 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_CONCURRENT_ACTIVITIES, type: SQLUSMALLINT, value: 0 = 0 1592745613816672 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:812 in SQLDisconnect: SQLDisconnect 1592745613816690 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:56 in SQLFreeHandle: SQLFreeHandle handleType=2 handle=0000021A900ABC40 1592745613816724 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:56 in SQLFreeHandle: SQLFreeHandle handleType=1 handle=0000021A900ED020 1592745613838431 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:38 in SQLAllocHandle: SQLAllocHandle handle_type=1 input_handle=0000000000000000 1592745613838485 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:91 in operator (): SetEnvAttr: 200 1592745613838501 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:109 in operator (): Set ODBC version to 3 1592745613838762 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:38 in SQLAllocHandle: SQLAllocHandle handle_type=2 input_handle=0000021A900ED480 1592745613838814 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 77, out_value_max_length: 12 1592745613839034 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 10023, out_value_max_length: 4 1592745613839059 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:391 in operator (): GetInfo SQL_ASYNC_DBC_FUNCTIONS, type: SQLUINTEGER, value: 0 = 0 1592745613839075 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 10025, out_value_max_length: 4 1592745613839090 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:176 in operator (): GetInfo SQL_ASYNC_NOTIFICATION, type: SQLUINTEGER, value: SQL_ASYNC_NOTIFICATION_NOT_CAPABLE = 0 1592745613839106 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:158 in operator (): SetConnectAttr: 115 = 0000000000000000 (-5) 1592745613839131 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 1, out_value_max_length: 2 1592745613839147 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_CONCURRENT_ACTIVITIES, type: SQLUSMALLINT, value: 0 = 0 1592745613839162 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:158 in operator (): SetConnectAttr: 103 = 000000000000000F (-5) 1592745613860553 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\connection.cpp:113 in connect: Creating session with http://rdmint-ck.baicizhan.com:80 1592745613860752 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:1285 in SQLGetFunctions: SQLGetFunctions:1285 id=999 ptr=000000E91B1FBDC0 1592745613860779 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 23, out_value_max_length: 2 1592745613860795 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:197 in operator (): GetInfo SQL_CURSOR_COMMIT_BEHAVIOR, type: SQLUSMALLINT, value: SQL_CB_PRESERVE = 2 1592745613860811 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 24, out_value_max_length: 2 1592745613860826 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:197 in operator (): GetInfo SQL_CURSOR_ROLLBACK_BEHAVIOR, type: SQLUSMALLINT, value: SQL_CB_PRESERVE = 2 1592745613860841 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 81, out_value_max_length: 4 1592745613860855 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:217 in operator (): GetInfo SQL_GETDATA_EXTENSIONS, type: SQLUINTEGER, value: SQL_GD_ANY_COLUMN | SQL_GD_ANY_ORDER | SQL_GD_BOUND = 11 1592745613860873 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 1750, out_value_max_length: 4 1592745613860924 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver/driver.h:250 in operator (): HY000 (Unsupported info type: 1750) 1592745613864123 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 6, out_value_max_length: 100 1592745613867013 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 7, out_value_max_length: 100 1592745613869985 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 17, out_value_max_length: 100 1592745613873562 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 18, out_value_max_length: 100 1592745613876500 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:38 in SQLAllocHandle: SQLAllocHandle handle_type=3 input_handle=0000021A900ABC40 1592745613876583 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:446 in operator (): GetStmtAttr: 10010 out_value=0000021A9040B2B0 out_value_max_length=-4 1592745613876606 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:446 in operator (): GetStmtAttr: 10011 out_value=0000021A9040B3B8 out_value_max_length=-4 1592745613876624 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:446 in operator (): GetStmtAttr: 10012 out_value=0000021A9040B4C0 out_value_max_length=-4 1592745613876642 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\impl\impl.cpp:446 in operator (): GetStmtAttr: 10013 out_value=0000021A9040B5C8 out_value_max_length=-4 1592745613881680 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 6, out_value_max_length: 100 1592745613884425 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:511 in SQLExecDirectW: SQLExecDirectW statement_text_size=-3 statement_text=0000021A92164F5C 1592745613884620 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:147 in requestNextPackOfResultSets: POST rdmint-ck.baicizhan.com?default_format=ODBCDriver2&database=mint_ck body=select event_date, count(order_id) as sell_amt from mint_ck.fact_order_tracks_v where status = 2 and event_date>='2020-01-01' group by event_date UA=clickhouse-odbc/1.1.7.20200414 (Windows-10.0.18363) UNICODE 1592745613978778 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=1/3 failed: No message received: 1592745614061254 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=2/3 failed: No message received: 1592745614152764 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=3/3 failed: No message received: 1592745614255844 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=4/3 failed: No message received: 1592745614256058 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver/driver.h:244 in operator (): HY000 (No message received) 1592745614265754 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:56 in SQLFreeHandle: SQLFreeHandle handleType=3 handle=0000021AAA85D350 1592745614268441 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 1, out_value_max_length: 2 1592745614268517 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:380 in operator (): GetInfo SQL_MAX_CONCURRENT_ACTIVITIES, type: SQLUSMALLINT, value: 0 = 0 1592745614268580 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:812 in SQLDisconnect: SQLDisconnect 1592745614268638 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:56 in SQLFreeHandle: SQLFreeHandle handleType=2 handle=0000021A900ABC40 1592745614268736 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\api\odbc.cpp:56 in SQLFreeHandle: SQLFreeHandle handleType=1 handle=0000021A900ED480

huangxp12 commented 4 years ago

CK version 19.16.14.65. Does that matter?

traceon commented 4 years ago

It looks like around this place, server stopped sending data:

1592745613884620 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:147 in requestNextPackOfResultSets: POST rdmint-ck.baicizhan.com?default_format=ODBCDriver2&database=mint_ck body=select event_date, count(order_id) as sell_amt
from mint_ck.fact_order_tracks_v
where status = 2
and event_date>='2020-01-01'
group by event_date UA=clickhouse-odbc/1.1.7.20200414 (Windows-10.0.18363) UNICODE
1592745613978778 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=1/3 failed: No message received:
1592745614061254 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=2/3 failed: No message received:
1592745614152764 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=3/3 failed: No message received:
1592745614255844 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=4/3 failed: No message received:

What do log messages at the ClickHouse server look like for this query? Also, have you installed VS2019 runtime?

huangxp12 commented 4 years ago

It looks like around this place, server stopped sending data:

1592745613884620 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:147 in requestNextPackOfResultSets: POST rdmint-ck.baicizhan.com?default_format=ODBCDriver2&database=mint_ck body=select event_date, count(order_id) as sell_amt
from mint_ck.fact_order_tracks_v
where status = 2
and event_date>='2020-01-01'
group by event_date UA=clickhouse-odbc/1.1.7.20200414 (Windows-10.0.18363) UNICODE
1592745613978778 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=1/3 failed: No message received:
1592745614061254 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=2/3 failed: No message received:
1592745614152764 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=3/3 failed: No message received:
1592745614255844 [23112:45596] Z:\denis\dev\altinity\clickhouse-odbc-canonical\driver\statement.cpp:174 in requestNextPackOfResultSets: Http request try=4/3 failed: No message received:

What do log messages at the ClickHouse server look like for this query? Also, have you installed VS2019 runtime?

I searched system.query_log but 0 rows received. SELECT t.* FROM system.query_log t WHERE http_user_agent like '%1.1.7.20200414%' ORDER BY event_date DESC LIMIT

traceon commented 4 years ago

You can reproduce it with client, and monitor server's log simultaneously.