[MDEV-22658] feedback_plugin_send failed in buildbot Created: 2020-05-21  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Anel Husakovic Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: KVM, buildbot, plugins, tests

Attachments: PNG File feedback-ssl-wireshark.png    

 Description   

With WITH_SSL=OFF test is passing

==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
plugins.feedback_plugin_send             [ pass ]  311834
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 311.834 of 316 seconds executing testcases
 
Completed: All 1 tests were successful.

With option WITH_SSL=bundled failure is reproducible as in case of kvm-asan builder:

MTR_FEEDBACK_PLUGIN=1 ./mysql-test/mtr feedback_plugin_send
Logging: /home/anel/mariadb/10.2/mysql-test/mysql-test-run.pl  feedback_plugin_send
vardir: /home/anel/mariadb/builds/10.2/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/anel/mariadb/builds/10.2/mysql-test/var'...
Checking supported features...
MariaDB Version 10.2.33-MariaDB-debug
 - SSL connections supported
 - binaries are debug compiled
 - binaries built with wsrep patch
Collecting tests...
Installing system database...
 
==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
plugins.feedback_plugin_send             [ fail ]
        Test ended at 2020-05-21 12:58:15
 
CURRENT_TEST: plugins.feedback_plugin_send
--- /home/anel/mariadb/10.2/mysql-test/suite/plugins/r/feedback_plugin_send.result  2020-02-05 15:08:23.733964260 +0100
+++ /home/anel/mariadb/10.2/mysql-test/suite/plugins/r/feedback_plugin_send.reject  2020-05-21 12:58:15.140576150 +0200
@@ -25,5 +25,4 @@
 1  Collation used utf8_bin
 1  Collation used utf8_general_ci
 set global sql_mode=ONLY_FULL_GROUP_BY;
-6: feedback plugin: report to 'http://mariadb.org/feedback_plugin/post' was sent
-6: feedback plugin: server replied 'ok'
+6: feedback plugin: ssl failed for url 'http://mariadb.org/feedback_plugin/post' unknown error number
 
mysqltest: Result length mismatch
 
 - saving '/home/anel/mariadb/builds/10.2/mysql-test/var/log/plugins.feedback_plugin_send/' to '/home/anel/mariadb/builds/10.2/mysql-test/var/log/plugins.feedback_plugin_send/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 315 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): plugins.feedback_plugin_send

WITH_SSL=bundled defined in cmake/ssl.cmake

# - "bundled" uses source code in <source dir>/extra/yassl
# - "system"  (typically) uses headers/libraries in /usr/lib and /usr/lib64
# - a custom installation of openssl can be used like this
#     - cmake -DCMAKE_PREFIX_PATH=</path/to/custom/openssl> -DWITH_SSL="system"
#   or
#     - cmake -DWITH_SSL=</path/to/custom/openssl>
#
# The default value for WITH_SSL is "bundled"

Relevant history of the test:

KB
mariadb.org-feedback



 Comments   
Comment by Anel Husakovic [ 2020-05-21 ]

(gdb) bt
+bt
#0  sql_print_error (format=0x55555682af60 "feedback plugin: ssl failed for url '%s' %s") at /home/anel/mariadb/10.2/sql/log.cc:8766
#1  0x000055555642fc73 in feedback::Url_http::send (this=0x555557982390, data=0x7fffec0031f0 "FEEDBACK_SERVER_UID\tIRsVcOrMeYVEMbqoOUByCp8re4E=\nFEEDBACK_WHEN\tstartup\nFEEDBACK_USER_INFO\tmysql-test\n\n", '\245' <repeats 14898 times>..., data_length=102) at /home/anel/mariadb/10.2/plugin/feedback/url_http.cc:233
#2  0x000055555642f0f9 in feedback::send_report (when=0x55555682ab3f "startup") at /home/anel/mariadb/10.2/plugin/feedback/sender_thread.cc:243
#3  0x000055555642f366 in feedback::background_thread (arg=0x0) at /home/anel/mariadb/10.2/plugin/feedback/sender_thread.cc:286
#4  0x00007ffff75646db in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#5  0x00007ffff694e88f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Possible problem with

#0  sslconnect (ptr=0x7fffec00b230, vio=0x7fffec00afc0, timeout=60, errptr=0x7ffff4d90398) at /home/anel/mariadb/10.2/vio/viossl.c:417

generated from

yaSSL::yaERR_error_string_n (e=70, buf=0x7ffff4d90400 "unknown error number", len=1024) at /home/anel
/mariadb/10.2/extra/yassl/src/ssl.cpp:1295

Comment by Marko Mäkelä [ 2020-05-22 ]

As far as I can tell, the test fails also on 10.1. It currently is the only 10.1 failure on Mac OS X. See http://buildbot.askmonty.org/buildbot/builders/mac-1012-bintar/builds/7203 for a recent example. That compilation appears to use a bundled SSL library.

Comment by Daniel Black [ 2020-06-19 ]

10.1-bf74f7f9ff40f8a17e739e9ab6f5c906ccb9e892-WITH_SSL:STRING=bundled connects with TLS-1.1 which isn't supported by the server.

ref: https://www.ssllabs.com/ssltest/analyze.html?d=mariadb.org&s=2a01%3a4f8%3a121%3a3039%3a0%3a0%3a0%3a2

with newer ssl
openssl-devel.x86_64 1:1.1.1g-1.fc31

on 10.1 branch:
cmake -DWITH_SSL=system won't compile as it expects the old openssl API (OLD_OPENSSL_API fails)

Comment by Daniel Black [ 2020-06-19 ]

see MDEV-21881 for more detailed TLS/SSL compatibility per branch.

Generated at Thu Feb 08 09:16:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.