ClickHouse / ClickHouse/odbc-bridge
ODBC Table Function with Oracle ODBC Driver Causes [Oracle][ODBC] Timeout Expired
- Dominant language
- C++
- Stars
- 4
- Forks
- 4
- PR merge metrics
- No merged PRs in 30d
Description
I am trying to use the clickhouse-odbc-bridge to get data from an Oracle database. The driver is correctly installed, as I can query using SQLPlus and isql. Additionally, creating a table with the ODBC engine works fine. However, the only thing that doesn't work is the ODBC table function.
When trying to run SELECT * FROM odbc('dsn', 'schema', 'table'), I encounter the following issue:
2024.08.06 13:44:03.408732 [ 1328 ] {} ODBCColumnsInfoHandler: Request URI: /columns_info?use_connection_pooling=1&version=1&connection_string=DSN%3DEMAGA%3BLoginTimeout%3D60%3BQueryTimeout%3D120&schema=CONCORDE&table=LOC&external_table_functions_use_nulls=1
2024.08.06 13:44:03.408992 [ 1328 ] {} ODBCColumnsInfoHandler: Got connection str 'DSN=EMAGA;LoginTimeout=60;QueryTimeout=120'
2024.08.06 13:44:03.646542 [ 1328 ] {} ODBCConnection: ODBC query failed with error: contrib/nanodbc/nanodbc/nanodbc.cpp:4813: HYT0: [Oracle][ODBC]Timeout expired. , state: HYT0, native code: 0
2024.08.06 13:44:03.646681 [ 1328 ] {} ODBCColumnsInfoHandler: Error getting columns from ODBC 'std::exception. Code: 1001, type: nanodbc::database_error, e.what() = contrib/nanodbc/nanodbc/nanodbc.cpp:4813: HYT0: [Oracle][ODBC]Timeout expired. (version 23.11.3.23 (official build))'
2024.08.06 13:44:03.646796 [ 1328 ] {} ODBCColumnsInfoHandler: std::exception. Code: 1001, type: nanodbc::database_error, e.what() = contrib/nanodbc/nanodbc/nanodbc.cpp:4813: HYT0: [Oracle][ODBC]Timeout expired. , Stack trace (when copying this message, always include the lines below):
0. nanodbc::database_error::database_error(void*, short, String const&) @ 0x000000000656cc8b in /usr/bin/clickhouse-odbc-bridge
1. nanodbc::catalog::find_tables(String const&, String const&, String const&, String const&) @ 0x000000000656f439 in /usr/bin/clickhouse-odbc-bridge
2. nanodbc::catalog::columns std::__function::__policy_invoker::__call_impl>(std::__function::__policy_storage const*, nanodbc::connection&) @ 0x0000000003c06e74 in /usr/bin/clickhouse-odbc-bridge
3. DB::ODBCColumnsInfoHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x0000000003bff4cf in /usr/bin/clickhouse-odbc-bridge
4. DB::HTTPServerConnection::run() @ 0x000000000638c212 in /usr/bin/clickhouse-odbc-bridge
5. Poco::Net::TCPServerConnection::start() @ 0x00000000085beb92 in /usr/bin/clickhouse-odbc-bridge
6. Poco::Net::TCPServerDispatcher::run() @ 0x00000000085bf991 in /usr/bin/clickhouse-odbc-bridge
7. Poco::PooledThread::run() @ 0x000000000867a367 in /usr/bin/clickhouse-odbc-bridge
8. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000008678b5c in /usr/bin/clickhouse-odbc-bridge
9. ? @ 0x00007f4047759609 in ?
10. ? @ 0x00007f404767e353 in ?
I'm using Clickhouse version 23.11.3.23 and Oracle ODBC driver 19.24
Contributor guide
Assessment
This issue has not been assessed yet.