maria-discuss team mailing list archive

[Lukas Javorsky <ljavorsk@xxxxxxxxxx>]

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@xxxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxxxx
>>
>>
>
> --
> 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@xxxxxxxxxx
> <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@xxxxxxxxxx
<https://www.redhat.com>