API tools faq
paste
Advertisement
Eu_Sh

ch_pg_error_ssl

Eu_Sh
Jun 3rd, 2023
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.98 KB | Fixit | 0 0
raw download clone embed print report
  1. [errors.log]
  2.  
  3. 2023.06.03 16:04:01.682347 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  4. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  5.  
  6. 2023.06.03 16:04:04.005512 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  7. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  8.  
  9. 2023.06.03 16:04:06.239560 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  10. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  11.  
  12. 2023.06.03 16:04:08.650718 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  13. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  14.  
  15. 2023.06.03 16:04:11.149165 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  16. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  17.  
  18. 2023.06.03 16:04:11.157891 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> executeQuery: Code: 614. DB::Exception: Try 5. Connection to `postgresql_server.local:6432` failed with error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  19. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  20.  
  21. . (POSTGRESQL_CONNECTION_FAILURE) (version 23.4.2.11 (official build)) (from [::ffff:127.0.0.1]:34920) (in query: CREATE TABLE IF NOT EXISTS pg_transaction_PRODUCTION AS postgresql('postgresql_server.local:6432', 'user_local', 'transaction', 'active', '[HIDDEN]')), Stack trace (when copying this message, always include the lines below):
  22.  
  23. 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe3bb175 in /usr/bin/clickhouse
  24. 1. ? @ 0x12463f2c in /usr/bin/clickhouse
  25. 2. postgres::PoolWithFailover::get() @ 0x1272382b in /usr/bin/clickhouse
  26. 3. DB::TableFunctionPostgreSQL::getActualTableStructure(std::shared_ptr<DB::Context const>) const @ 0x124b098a in /usr/bin/clickhouse
  27. 4. DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&) const @ 0x1396946a in /usr/bin/clickhouse
  28. 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x1397142c in /usr/bin/clickhouse
  29. 6. DB::InterpreterCreateQuery::execute() @ 0x1397fa14 in /usr/bin/clickhouse
  30. 7. ? @ 0x13f00be7 in /usr/bin/clickhouse
  31. 8. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13f06b4c in /usr/bin/clickhouse
  32. 9. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x14c7f9fa in /usr/bin/clickhouse
  33. 10. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14c83c6e in /usr/bin/clickhouse
  34. 11. DB::HTTPServerConnection::run() @ 0x14cf2e1d in /usr/bin/clickhouse
  35. 12. Poco::Net::TCPServerConnection::start() @ 0x17c5cab4 in /usr/bin/clickhouse
  36. 13. Poco::Net::TCPServerDispatcher::run() @ 0x17c5dcdb in /usr/bin/clickhouse
  37. 14. Poco::PooledThread::run() @ 0x17ddb087 in /usr/bin/clickhouse
  38. 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x17dd8abd in /usr/bin/clickhouse
  39. 16. ? @ 0x7f3ff1ad1b43 in ?
  40. 17. clone @ 0x7f3ff1b62bb4 in ?
  41.  
  42. 2023.06.03 16:04:11.158269 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> DynamicQueryHandler: Code: 614. DB::Exception: Try 5. Connection to `postgresql_server.local:6432` failed with error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  43. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  44.  
  45. . (POSTGRESQL_CONNECTION_FAILURE), Stack trace (when copying this message, always include the lines below):
  46.  
  47. 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe3bb175 in /usr/bin/clickhouse
  48. 1. ? @ 0x12463f2c in /usr/bin/clickhouse
  49. 2. postgres::PoolWithFailover::get() @ 0x1272382b in /usr/bin/clickhouse
  50. 3. DB::TableFunctionPostgreSQL::getActualTableStructure(std::shared_ptr<DB::Context const>) const @ 0x124b098a in /usr/bin/clickhouse
  51. 4. DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&) const @ 0x1396946a in /usr/bin/clickhouse
  52. 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x1397142c in /usr/bin/clickhouse
  53. 6. DB::InterpreterCreateQuery::execute() @ 0x1397fa14 in /usr/bin/clickhouse
  54. 7. ? @ 0x13f00be7 in /usr/bin/clickhouse
  55. 8. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13f06b4c in /usr/bin/clickhouse
  56. 9. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x14c7f9fa in /usr/bin/clickhouse
  57. 10. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14c83c6e in /usr/bin/clickhouse
  58. 11. DB::HTTPServerConnection::run() @ 0x14cf2e1d in /usr/bin/clickhouse
  59. 12. Poco::Net::TCPServerConnection::start() @ 0x17c5cab4 in /usr/bin/clickhouse
  60. 13. Poco::Net::TCPServerDispatcher::run() @ 0x17c5dcdb in /usr/bin/clickhouse
  61. 14. Poco::PooledThread::run() @ 0x17ddb087 in /usr/bin/clickhouse
  62. 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x17dd8abd in /usr/bin/clickhouse
  63. 16. ? @ 0x7f3ff1ad1b43 in ?
  64. 17. clone @ 0x7f3ff1b62bb4 in ?
  65. (version 23.4.2.11 (official build))
  66.  
  67.  
  68.  
  69. [server.log]
  70.  
  71. 2023.06.03 16:03:59.046128 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Debug> executeQuery: (from [::ffff:127.0.0.1]:34920) CREATE TABLE IF NOT EXISTS pg_transaction_PRODUCTION AS postgresql('postgresql_server.local:6432', 'user_local', 'transaction', 'active', '[HIDDEN]') (stage: Complete)
  72. 2023.06.03 16:03:59.046149 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON default.pg_transaction_PRODUCTION
  73. 2023.06.03 16:03:59.046176 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Trace> PostgreSQLConnectionPool: PostgreSQL connection pool size: 16, connection wait timeout: 5000, max failover tries: 5
  74. 2023.06.03 16:03:59.046180 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Debug> PostgreSQLPoolWithFailover: Adding address host: postgresql_server.local, port: 6432 to connection pool
  75. 2023.06.03 16:03:59.046186 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Debug> PostgreSQLConnectionPool: New connection to postgresql_server.local:6432
  76.  
  77. 2023.06.03 16:04:01.682347 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  78. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  79.  
  80. 2023.06.03 16:04:04.005512 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  81. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  82.  
  83. 2023.06.03 16:04:06.239560 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  84. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  85.  
  86. 2023.06.03 16:04:08.650718 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  87. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  88.  
  89. 2023.06.03 16:04:11.149165 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> PostgreSQLConnectionPool: Connection error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  90. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  91.  
  92. 2023.06.03 16:04:11.157891 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> executeQuery: Code: 614. DB::Exception: Try 5. Connection to `postgresql_server.local:6432` failed with error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  93. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  94.  
  95. . (POSTGRESQL_CONNECTION_FAILURE) (version 23.4.2.11 (official build)) (from [::ffff:127.0.0.1]:34920) (in query: CREATE TABLE IF NOT EXISTS pg_transaction_PRODUCTION AS postgresql('postgresql_server.local:6432', 'user_local', 'transaction', 'active', '[HIDDEN]')), Stack trace (when copying this message, always include the lines below):
  96.  
  97. 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe3bb175 in /usr/bin/clickhouse
  98. 1. ? @ 0x12463f2c in /usr/bin/clickhouse
  99. 2. postgres::PoolWithFailover::get() @ 0x1272382b in /usr/bin/clickhouse
  100. 3. DB::TableFunctionPostgreSQL::getActualTableStructure(std::shared_ptr<DB::Context const>) const @ 0x124b098a in /usr/bin/clickhouse
  101. 4. DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&) const @ 0x1396946a in /usr/bin/clickhouse
  102. 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x1397142c in /usr/bin/clickhouse
  103. 6. DB::InterpreterCreateQuery::execute() @ 0x1397fa14 in /usr/bin/clickhouse
  104. 7. ? @ 0x13f00be7 in /usr/bin/clickhouse
  105. 8. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13f06b4c in /usr/bin/clickhouse
  106. 9. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x14c7f9fa in /usr/bin/clickhouse
  107. 10. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14c83c6e in /usr/bin/clickhouse
  108. 11. DB::HTTPServerConnection::run() @ 0x14cf2e1d in /usr/bin/clickhouse
  109. 12. Poco::Net::TCPServerConnection::start() @ 0x17c5cab4 in /usr/bin/clickhouse
  110. 13. Poco::Net::TCPServerDispatcher::run() @ 0x17c5dcdb in /usr/bin/clickhouse
  111. 14. Poco::PooledThread::run() @ 0x17ddb087 in /usr/bin/clickhouse
  112. 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x17dd8abd in /usr/bin/clickhouse
  113. 16. ? @ 0x7f3ff1ad1b43 in ?
  114. 17. clone @ 0x7f3ff1b62bb4 in ?
  115.  
  116. 2023.06.03 16:04:11.158269 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Error> DynamicQueryHandler: Code: 614. DB::Exception: Try 5. Connection to `postgresql_server.local:6432` failed with error: connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SASL authentication failed
  117. connection to server at "postgresql_server.local" (121.121.121.121), port 6432 failed: FATAL: SSL required
  118.  
  119. . (POSTGRESQL_CONNECTION_FAILURE), Stack trace (when copying this message, always include the lines below):
  120.  
  121. 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0xe3bb175 in /usr/bin/clickhouse
  122. 1. ? @ 0x12463f2c in /usr/bin/clickhouse
  123. 2. postgres::PoolWithFailover::get() @ 0x1272382b in /usr/bin/clickhouse
  124. 3. DB::TableFunctionPostgreSQL::getActualTableStructure(std::shared_ptr<DB::Context const>) const @ 0x124b098a in /usr/bin/clickhouse
  125. 4. DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&) const @ 0x1396946a in /usr/bin/clickhouse
  126. 5. DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x1397142c in /usr/bin/clickhouse
  127. 6. DB::InterpreterCreateQuery::execute() @ 0x1397fa14 in /usr/bin/clickhouse
  128. 7. ? @ 0x13f00be7 in /usr/bin/clickhouse
  129. 8. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x13f06b4c in /usr/bin/clickhouse
  130. 9. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x14c7f9fa in /usr/bin/clickhouse
  131. 10. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x14c83c6e in /usr/bin/clickhouse
  132. 11. DB::HTTPServerConnection::run() @ 0x14cf2e1d in /usr/bin/clickhouse
  133. 12. Poco::Net::TCPServerConnection::start() @ 0x17c5cab4 in /usr/bin/clickhouse
  134. 13. Poco::Net::TCPServerDispatcher::run() @ 0x17c5dcdb in /usr/bin/clickhouse
  135. 14. Poco::PooledThread::run() @ 0x17ddb087 in /usr/bin/clickhouse
  136. 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x17dd8abd in /usr/bin/clickhouse
  137. 16. ? @ 0x7f3ff1ad1b43 in ?
  138. 17. clone @ 0x7f3ff1b62bb4 in ?
  139. (version 23.4.2.11 (official build))
  140. 2023.06.03 16:04:11.158635 [ 50 ] {0a0740e3-5761-441d-81ad-5ce5731d4e99} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B.
  141.  
  142.  
  143.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!