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/build.log

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

Purkyňova 115 (TPB-C)
612 00 Brno - Královo Pole

ljavorsk@redhat.com