[MDEV-34393] MariaDB server installation reports error "mysqld got signal 11" on a FIPS-enabled host - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 11.4.2
Fix Version/s: 10.11, 11.4
Component/s: None
Labels:
None
Environment:
Linux ubuntu-22-04-4 5.15.0-111-fips #121+fips1-Ubuntu SMP Tue May 21 15:38:42 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux

Description

Unable to successfully install MariaDB Server on FIPS-enabled Ubuntu 22.04 server.
The `mariadb-server.postinst` reports an error "[ERROR] mysqld got signal 11 ;" (please see full log bellow).

It doesn't matter if install MariaDB server from the latest available 11.4 downloaded release or use whatever is provided by Canonical for Ubuntu systems via `apt` package manager (version 10.6) - got the same error.

Steps to reproduce

Deploy a new VM using Ubuntu 22.04.4 Server live CD

Attach to Ubuntu PRO subscription (required to enable FIPS):

sudo apt-get update

sudo apt install -y ubuntu-advantage-tools

sudo pro attach <your_token>

sudo reboot

Enable FIPS and disable livepatch for the kernel

sudo pro enable fips-updates

sudo pro disable livepatch

sudo reboot

Checks

~$ pro status

SERVICE          ENTITLED  STATUS       DESCRIPTION

anbox-cloud      yes       disabled     Scalable Android in the cloud

esm-apps         yes       enabled      Expanded Security Maintenance for Applications

esm-infra        yes       enabled      Expanded Security Maintenance for Infrastructure

fips-updates     yes       enabled      FIPS compliant crypto packages with stable security updates

livepatch        yes       disabled     Current kernel is not supported

realtime-kernel* yes       disabled     Ubuntu kernel with PREEMPT_RT patches integrated

usg              yes       disabled     Security compliance and audit tools

~$ openssl list -providers

Providers:

  base

    name: OpenSSL Base Provider

    version: 3.0.2

    status: active

  fips

    name: Ubuntu 22.04 OpenSSL Cryptographic Module

    version: 3.0.5-0ubuntu0.1+Fips2.1

    status: active

Install MariDB Server (follow official instructions)

wget https://dlm.mariadb.com/3824156/MariaDB/mariadb-11.4.2/repo/ubuntu/mariadb-11.4.2-ubuntu-jammy-amd64-debs.tar

tar xf mariadb-11.4.2-ubuntu-jammy-amd64-debs.tar

cd mariadb-11.4.2-ubuntu-jammy-amd64-debs

sudo ./setup_repository

sudo apt-get update

sudo apt-get install --yes mariadb-server

Service status

● mariadb.service - MariaDB 11.4.2 database server

     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)

    Drop-In: /etc/systemd/system/mariadb.service.d

             └─migrated-from-my.cnf-settings.conf

     Active: active (running) since Fri 2024-06-14 09:50:26 UTC; 53s ago

       Docs: man:mariadbd(8)

             https://mariadb.com/kb/en/library/systemd/

    Process: 3882 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)

    Process: 3883 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

    Process: 3885 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, >

    Process: 3927 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

    Process: 3929 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)

   Main PID: 3914 (mariadbd)

     Status: "Taking your SQL requests now..."

      Tasks: 13 (limit: 61952)

     Memory: 81.4M

        CPU: 1.386s

     CGroup: /system.slice/mariadb.service

             └─3914 /usr/sbin/mariadbd

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: Version: '11.4.2-MariaDB-ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Jun 14 09:50:26 ubuntu-22-04-4 systemd[1]: Started MariaDB 11.4.2 database server.

Jun 14 09:50:26 ubuntu-22-04-4 /etc/mysql/debian-start[3931]: Upgrading MySQL tables if necessary.

Jun 14 09:50:27 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:27 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: FATAL ERROR: Upgrade failed

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3944]: Checking for insecure root accounts.

Jun 14 09:50:27 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:27 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Jun 14 09:50:27 ubuntu-22-04-4 debian-start[3948]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Logs from journalctl

Jun 14 09:48:36 ubuntu-22-04-4 sudo[2280]: osobkovych : TTY=pts/0 ; PWD=/home/osobkovych/mariadb-11.4.2-ubuntu-jammy-amd64-debs ; USER=root ; COMMAND=./setup_repository

Jun 14 09:49:02 ubuntu-22-04-4 sudo[2529]: osobkovych : TTY=pts/0 ; PWD=/home/osobkovych/mariadb-11.4.2-ubuntu-jammy-amd64-debs ; USER=root ; COMMAND=/usr/bin/apt-get update

Jun 14 09:50:13 ubuntu-22-04-4 sudo[3311]: osobkovych : TTY=pts/0 ; PWD=/home/osobkovych/mariadb-11.4.2-ubuntu-jammy-amd64-debs ; USER=root ; COMMAND=/usr/bin/apt-get install --yes mariadb-server

Jun 14 09:50:18 ubuntu-22-04-4 groupadd[3487]: group added to /etc/group: name=mysql, GID=119

Jun 14 09:50:18 ubuntu-22-04-4 groupadd[3487]: group added to /etc/gshadow: name=mysql

Jun 14 09:50:18 ubuntu-22-04-4 groupadd[3487]: new group: name=mysql, GID=119

Jun 14 09:50:18 ubuntu-22-04-4 useradd[3495]: new user: name=mysql, UID=114, GID=119, home=/nonexistent, shell=/bin/false, from=none

Jun 14 09:50:18 ubuntu-22-04-4 chage[3502]: changed password expiry for mysql

Jun 14 09:50:18 ubuntu-22-04-4 chfn[3506]: changed user 'mysql' information

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: 240614  9:50:21 [ERROR] mysqld got signal 11 ;

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Sorry, we probably made a mistake, and this is a bug.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Your assistance in bug reporting will enable us to fix this for the next release.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: We will try our best to scrape up some info that will hopefully help

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: diagnose the problem, but since we have already crashed,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: something is definitely wrong and this may fail.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Server version: 11.4.2-MariaDB-ubu2204 source revision: 3fca5ed772fb75e3e57c507edef2985f8eba5b12

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: key_buffer_size=134217728

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: read_buffer_size=131072

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: max_used_connections=0

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: max_threads=153

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: thread_count=1

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: It is possible that mysqld could use up to

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 468066 K  bytes of memory

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Hope that's ok; if not, decrease some variables in the equation.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Thread pointer: 0x56083c189e88

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Attempting backtrace. You can use the following information to find out

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: where mysqld died. If you see no messages after this, something went

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: terribly wrong...

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: stack_bottom = 0x7ffc05ca8248 thread_stack 0x49000

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: /usr/sbin/mariadbd(my_print_stacktrace+0x32)[0x5608391727d2]

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: /usr/sbin/mariadbd(handle_fatal_signal+0x478)[0x560838c400f8]

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: /lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7fbec67c1520]

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Trying to get some variables.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Some pointers may be invalid and cause the dump to abort.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Query (0x56083c1ac4c0): CREATE DEFINER='mariadb.sys'@'localhost' SQL SECURITY DEFINER VIEW IF NOT EXISTS user AS SELECT

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   Host,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   User,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.plugin') IN ('mysql_native_password', 'mysql_old_password'), IFNULL(JSON_VALUE(Priv, '$.authentication_string'), ''), '') AS Password,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &         1, 'Y', 'N') AS Select_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &         2, 'Y', 'N') AS Insert_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &         4, 'Y', 'N') AS Update_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &         8, 'Y', 'N') AS Delete_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &        16, 'Y', 'N') AS Create_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &        32, 'Y', 'N') AS Drop_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &        64, 'Y', 'N') AS Reload_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &       128, 'Y', 'N') AS Shutdown_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &       256, 'Y', 'N') AS Process_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &       512, 'Y', 'N') AS File_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &      1024, 'Y', 'N') AS Grant_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &      2048, 'Y', 'N') AS References_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &      4096, 'Y', 'N') AS Index_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &      8192, 'Y', 'N') AS Alter_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &     16384, 'Y', 'N') AS Show_db_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &     32768, 'Y', 'N') AS Super_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &     65536, 'Y', 'N') AS Create_tmp_table_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &    131072, 'Y', 'N') AS Lock_tables_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &    262144, 'Y', 'N') AS Execute_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &    524288, 'Y', 'N') AS Repl_slave_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &   1048576, 'Y', 'N') AS Repl_client_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &   2097152, 'Y', 'N') AS Create_view_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &   4194304, 'Y', 'N') AS Show_view_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &   8388608, 'Y', 'N') AS Create_routine_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &  16777216, 'Y', 'N') AS Alter_routine_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &  33554432, 'Y', 'N') AS Create_user_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') &  67108864, 'Y', 'N') AS Event_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') & 134217728, 'Y', 'N') AS Trigger_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') & 268435456, 'Y', 'N') AS Create_tablespace_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(JSON_VALUE(Priv, '$.access') & 536870912, 'Y', 'N') AS Delete_history_priv,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   ELT(IFNULL(JSON_VALUE(Priv, '$.ssl_type'), 0) + 1, '', 'ANY','X509', 'SPECIFIED') AS ssl_type,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.ssl_cipher'), '') AS ssl_cipher,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.x509_issuer'), '') AS x509_issuer,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.x509_subject'), '') AS x509_subject,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   CAST(IFNULL(JSON_VALUE(Priv, '$.max_questions'), 0) AS UNSIGNED) AS max_questions,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   CAST(IFNULL(JSON_VALUE(Priv, '$.max_updates'), 0) AS UNSIGNED) AS max_updates,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   CAST(IFNULL(JSON_VALUE(Priv, '$.max_connections'), 0) AS UNSIGNED) AS max_connections,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   CAST(IFNULL(JSON_VALUE(Priv, '$.max_user_connections'), 0) AS SIGNED) AS max_user_connections,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.plugin'), '') AS plugin,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.authentication_string'), '') AS authentication_string,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IF(IFNULL(JSON_VALUE(Priv, '$.password_last_changed'), 1) = 0, 'Y', 'N') AS password_expired,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   ELT(IFNULL(JSON_VALUE(Priv, '$.is_role'), 0) + 1, 'N', 'Y') AS is_role,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   IFNULL(JSON_VALUE(Priv, '$.default_role'), '') AS default_role,

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   CAST(IFNULL(JSON_VALUE(Priv, '$.max_statement_time'), 0.0) AS DECIMAL(12,6)) AS max_statement_time

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:   FROM global_priv;

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Connection ID (thread ID): 1

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Status: NOT_KILLED

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=off,sargable_casefold=on

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: information that should help you find out what is causing the crash.

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Writing a core file...

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Working directory at /var/lib/mysql

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Resource Limits:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Limit                     Soft Limit           Hard Limit           Units

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max cpu time              unlimited            unlimited            seconds

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max file size             unlimited            unlimited            bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max data size             unlimited            unlimited            bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max stack size            8388608              unlimited            bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max core file size        0                    0                    bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max resident set          unlimited            unlimited            bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max processes             31289                31289                processes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max open files            32186                32186                files

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max locked memory         1040343040           1040343040           bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max address space         unlimited            unlimited            bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max file locks            unlimited            unlimited            locks

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max pending signals       31289                31289                signals

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max msgqueue size         819200               819200               bytes

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max nice priority         0                    0

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max realtime priority     0                    0

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Max realtime timeout      unlimited            unlimited            us

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -- %E

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]: Kernel version: Linux version 5.15.0-111-fips (buildd@lcy02-amd64-059) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #121+fips1-Ubuntu SMP Tue May 21 15:38:42 UTC 2024

Jun 14 09:50:21 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: /usr/bin/mariadb-install-db: line 561:  3780 Segmentation fault      (core dumped) "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" "--plugin-dir=${plugindir}" $args --max_allowed_packet=8M --net_buffer_length=16K

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: Installation of system tables failed!  Examine the logs in

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: /var/lib/mysql for more information.

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: The problem could be conflicting information in an external

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: my.cnf files. You can ignore these by doing:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:     shell> /usr/bin/mariadb-install-db --defaults-file=~/.my.cnf

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: You can also try to start the mariadbd daemon with:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:     shell> /usr/sbin/mariadbd --skip-grant-tables --general-log &

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: and use the command line tool /usr/bin/mariadb

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: to connect to the mysql database and look at the grant tables:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:     shell> /usr/bin/mariadb -u root mysql

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:     MariaDB> show tables;

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: Try '/usr/sbin/mariadbd --help' if you have problems with paths.  Using

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: --general-log gives you a log in /var/lib/mysql that may be helpful.

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: The latest information about mariadb-install-db is available at

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: You can find the latest source at https://downloads.mariadb.org and

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: the maria-discuss email list at https://launchpad.net/~maria-discuss

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: Please check all of the above before submitting a bug report

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]: at https://mariadb.org/jira

Jun 14 09:50:24 ubuntu-22-04-4 mariadb-server.postinst[3758]:

Jun 14 09:50:24 ubuntu-22-04-4 audit[3805]: AVC apparmor="STATUS" operation="profile_remove" info="profile does not exist" error=-2 profile="unconfined" name="/usr/sbin/mariadbd" pid=3805 comm="apparmor_parser"

Jun 14 09:50:24 ubuntu-22-04-4 kernel: audit: type=1400 audit(1718358624.081:76): apparmor="STATUS" operation="profile_remove" info="profile does not exist" error=-2 profile="unconfined" name="/usr/sbin/mariadbd" pid=3805 comm="apparmor_parser"

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Starting MariaDB 11.4.2-MariaDB-ubu2204 source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 3914

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] mariadbd: Aria engine: starting recovery

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: recovered pages: 0% 38% 100% (0.0 seconds);

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] mariadbd: Aria engine: recovery done

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Number of transaction pools: 1

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Initialized memory pressure event listener

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Completed initialization of buffer pool

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=17990

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: End of log at LSN=37182

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: To recover: 146 pages

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Opened 3 undo tablespaces

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: log sequence number 37182; transaction id 4

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Plugin 'FEEDBACK' is disabled.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Plugin 'wsrep-provider' is disabled.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Recovering after a crash using tc.log

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Starting table crash recovery...

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Crash table recovery finished.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] Server socket created on IP: '127.0.0.1'.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Can't open the mysql.func table. Please run mysql_upgrade to create it.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] Cannot open mysql.event

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:26 0 [Note] /usr/sbin/mariadbd: ready for connections.

Jun 14 09:50:26 ubuntu-22-04-4 mariadbd[3914]: Version: '11.4.2-MariaDB-ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Jun 14 09:50:26 ubuntu-22-04-4 /etc/mysql/debian-start[3931]: Upgrading MySQL tables if necessary.

Jun 14 09:50:27 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:27 3 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3936]: FATAL ERROR: Upgrade failed

Jun 14 09:50:27 ubuntu-22-04-4 /etc/mysql/debian-start[3944]: Checking for insecure root accounts.

Jun 14 09:50:27 ubuntu-22-04-4 mariadbd[3914]: 2024-06-14  9:50:27 4 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

core.3500.tgz
1.10 MB
2024-06-17 11:20
core.4198.tgz
1.09 MB
2024-06-14 14:37

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Oleksandr Sobkovych

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2024-06-14 10:32

Updated:: 2024-07-23 14:18

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.