Hi Sergei, I've somehow managed to get onto another problem and that is the start of the mariadb.service. I'm trying to reproduce one of the tests " encryption.innodb-checksum-algorithm" The error I'm getting (cat /var/log/mariadb/mysqld.1.err) is this: 2021-11-08 4:06:46 0 [Warning] /usr/libexec/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20' 2021-11-08 4:06:46 0 [Warning] /usr/libexec/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60' 2021-11-08 4:06:46 0 [Warning] /usr/libexec/mariadbd: unknown variable 'loose-feedback-debug-interval=60' 2021-11-08 4:06:46 0 [Warning] /usr/libexec/mariadbd: unknown option '--loose-pam-debug' 2021-11-08 4:06:46 0 [Warning] /usr/libexec/mariadbd: unknown option '--loose-aria' 2021-11-08 4:06:46 0 [Warning] Failed to setup SSL 2021-11-08 4:06:46 0 [Warning] SSL error: SSL_CTX_set_default_verify_paths failed 2021-11-08 4:06:46 0 [Warning] SSL error: error:80000002:system library::No such file or directory 2021-11-08 4:06:46 0 [Warning] SSL error: error:10000080:BIO routines::no such file 2021-11-08 4:06:46 0 [Warning] SSL error: error:05880002:x509 certificate routines::system lib 2021-11-08 4:06:46 0 [Note] Server socket created on IP: '127.0.0.1'. 2021-11-08 4:06:46 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 13: Permission denied 2021-11-08 4:06:46 0 [ERROR] Do you already have another mysqld server running on port: 16020 ? 2021-11-08 4:06:46 0 [ERROR] Aborting Do you have any idea what could cause this? I'm not sure how to go further with this reproducer unless I fix this error. I would be so grateful for even multiple ideas where the problem could be, so I can check them. Thank you for your response. Lukas On Tue, Nov 2, 2021 at 11:08 AM Lukas Javorsky <ljavorsk@redhat.com> wrote:
Hi Sergei,
I'm sorry for the late reply.
I've attached the mysqld.1.err from '/home/user/encryption/1/log/mysqld.1.err'. I'm not sure how to read those test results, could you please give me more insight into these logs and files? E.g. what are those 1-7 directories?
I'm testing the 'suite/encryption/t/innodb-checksum-algorithm.test'. I'm using the '--verbose' and '--vardir=/home/user/encryption/' options.
The structure is quite unique, and I'm not sure which files could be helpful to me. I've attached the structure to this email (structure.txt) - command "tree /home/user/encryption"
On Wed, Oct 13, 2021 at 3:58 PM Sergei Golubchik <serg@mariadb.org> wrote:
Hi, Lukas!
On Oct 13, Lukas Javorsky wrote:
Hi Sergei,
How do these tests fail? For example: Test = encryption.corrupted_during_recovery Error: "mysqltest: At line 25: query 'INSERT INTO t1 VALUES(2)' failed: 1932: Table 'test.t1' doesn't exist in engine"
For the full log you can view it here:
https://kojihub.stream.rdu2.redhat.com/kojifiles/work/tasks/7208/367208/buil...
I cannot see it, the host doesn't even resolve.
Can you share the error log? it's somewhere in var/*/mysqld.1.err and var is normally in mysql-test/ unless you used mysql-test-run.pl --vardir=xxx
What do you need as a reproducer, a small standalone program? The best way is to create some kind of script where you can see all of the options that are passed to the server when the service is initialized. And the following SQL commands that are executed to the server (or if the test is not executing any commands in the server, then whatever it's executed after the server is started).
But that's just mysql-test-run, you have it. --verbose will show all options that are passed to the server. var/my.cnf is the config file.
One can probably even use ltrace to get all calls into libssl.so, but I personally haven't tried that.
Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
-- S pozdravom/ Best regards
Lukáš Javorský
Associate Software Engineer, Core service - Databases
Red Hat <https://www.redhat.com>
Purkyňova 115 (TPB-C)
612 00 Brno - Královo Pole
ljavorsk@redhat.com <https://www.redhat.com>
-- S pozdravom/ Best regards Lukáš Javorský Associate Software Engineer, Core service - Databases Red Hat <https://www.redhat.com> Purkyňova 115 (TPB-C) 612 00 Brno - Královo Pole ljavorsk@redhat.com <https://www.redhat.com>