<?xml version="1.0" encoding="UTF-8" ?>

<bugzilla version="5.2"
          urlbase="https://bugzilla.altlinux.org/"
          
          maintainer="jenya@basealt.ru"
>

    <bug>
          <bug_id>57952</bug_id>
          
          <creation_ts>2026-02-20 13:55:58 +0300</creation_ts>
          <short_desc>падение mariadb-server после обновления 2026-02-20</short_desc>
          <delta_ts>2026-02-24 09:55:53 +0300</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>Branch p11</product>
          <component>mariadb-server</component>
          <version>unspecified</version>
          <rep_platform>x86_64</rep_platform>
          <op_sys>Linux</op_sys>
          <bug_status>CLOSED</bug_status>
          <resolution>DUPLICATE</resolution>
          <dup_id>57864</dup_id>
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>P5</priority>
          <bug_severity>blocker</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Gleb Kulikov">glebus</reporter>
          <assigned_to name="Alexei Takaseev">taf</assigned_to>
          <cc>amakeenk</cc>
    
    <cc>zerg</cc>
          
          <qa_contact name="qa-p11@altlinux.org">qa-p11</qa_contact>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>282372</commentid>
    <comment_count>0</comment_count>
    <who name="Gleb Kulikov">glebus</who>
    <bug_when>2026-02-20 13:55:58 +0300</bug_when>
    <thetext>2026-02-20 обновил систему (p11). Akonadi утратил работоспособность (при загрузки системы с предыдущего снэпшота Akonadi работает нормально):

~/.local/share/akonadi/db_data/mysql.err:

2026-02-20 17:40:48 0 [Note] Starting MariaDB 11.8.6-MariaDB-alt1 source revision  server_uid c3hre+ZoClu89bVg2IrQqQFTDLs= as
process 5854
2026-02-20 17:40:48 0 [Warning] --innodb-file-per-table is deprecated and will be removed in a future release
2026-02-20 17:40:48 0 [Warning] option &apos;innodb-log-buffer-size&apos;: unsigned value 1048576 adjusted to 2097152
2026-02-20 17:40:48 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2026-02-20 17:40:48 0 [Note] InnoDB: Number of transaction pools: 1
2026-02-20 17:40:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2026-02-20 17:40:48 0 [Note] InnoDB: Using Linux native AIO
2026-02-20 17:40:48 0 [Note] InnoDB: innodb_buffer_pool_size_max=128m, innodb_buffer_pool_size=128m
2026-02-20 17:40:48 0 [Note] InnoDB: Initialized memory pressure event listener
2026-02-20 17:40:48 0 [Note] InnoDB: Completed initialization of buffer pool
2026-02-20 17:40:48 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2026-02-20 17:40:48 0 [Note] InnoDB: End of log at LSN=324190365
2026-02-20 17:40:48 0 [Note] InnoDB: Opened 3 undo tablespaces
2026-02-20 17:40:48 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2026-02-20 17:40:48 0 [Note] InnoDB: Removed temporary tablespace data file: &quot;./ibtmp1&quot;
2026-02-20 17:40:48 0 [Note] InnoDB: Setting file &apos;./ibtmp1&apos; size to 12.000MiB. Physically writing the file full; Please wait
...
2026-02-20 17:40:48 0 [Note] InnoDB: File &apos;./ibtmp1&apos; size is now 12.000MiB.
2026-02-20 17:40:48 0 [Note] InnoDB: log sequence number 324190365; transaction id 131222
2026-02-20 17:40:48 0 [Note] Plugin &apos;FEEDBACK&apos; is disabled.
2026-02-20 17:40:48 0 [Note] Plugin &apos;wsrep-provider&apos; is disabled.
2026-02-20 17:40:48 0 [Note] InnoDB: Loading buffer pool(s) from /home/gleb/.local/share/akonadi/db_data/ib_buffer_pool
2026-02-20 17:40:48 0 [Note] Recovering after a crash using tc.log
2026-02-20 17:40:48 0 [Note] Starting table crash recovery...
2026-02-20 17:40:48 0 [Note] Crash table recovery finished.
2026-02-20 17:40:48 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: &apos;11.8.6-MariaDB-alt1&apos;  socket: &apos;/run/user/500/akonadi/mysql.socket&apos;  port: 0  (ALT p11)
2026-02-20 17:40:48 0 [Note] InnoDB: Buffer pool(s) load completed at 260220 17:40:48
260220 17:40:48 [ERROR] /usr/sbin/mysqld got signal 11 ;
Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the
information below.

Server version: 11.8.6-MariaDB-alt1 source revision:

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
contains instructions to obtain a better version of the backtrace below.
Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.
(note: Retrieving this information may fail)

Thread pointer: 0x7ffb94000c68
stack_bottom = 0x7ffbd25be000 thread_stack 0x49000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x55f7dc296bfc]
/usr/sbin/mysqld(handle_fatal_signal+0x213)[0x55f7dbdf25a3]
/lib64/libc.so.6(+0x3da20)[0x7ffbe1a30a20]

Connection ID (thread ID): 6
Status: NOT_KILLED
Query (0x7ffb94167d98): SELECT information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME, information_schema.KEY_COLUMN_USAGE
.COLUMN_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN
_NAME, information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE, information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM inf
ormation_schema.REFERENTIAL_CONSTRAINTS INNER JOIN information_schema.KEY_COLUMN_USAGE ON ( information_schema.REFERENTIAL_CON
STRAINTS.CONSTRAINT_NAME = information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE ( information_schema.KEY_COLUMN_USAGE.T
ABLE_SCHEMA = ? AND information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ? )

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_i
ntersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=o
n,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_base
d=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_ca
che_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condi
tion_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=on,sargable_casefold=on

Writing a core file...
Working directory at /home/gleb/.local/share/akonadi/db_data
Resource Limits (excludes unlimited resources):
Limit                     Soft Limit           Hard Limit           Units
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max processes             4096                 5120                 processes
Max open files            3503                 3503                 files
Max locked memory         1048576              2097152              bytes
Max pending signals       39571                39571                signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0
Max realtime priority     0                    0
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %d %F

Kernel version: Linux version 6.12.68-6.12-alt1 (builder@localhost.localdomain) (gcc-13 (GCC) 13.2.1 20240128 (ALT Sisyphus 13
.2.1-alt3), GNU ld (GNU Binutils) 2.41.0.20230826) #1 SMP PREEMPT_DYNAMIC Fri Feb  6 20:37:37 UTC 2026</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>282378</commentid>
    <comment_count>1</comment_count>
    <who name="Alexander Makeenkov">amakeenk</who>
    <bug_when>2026-02-20 14:59:06 +0300</bug_when>
    <thetext>Покажите `cat /etc/os-release`.

В p11 akonadi работает с MySQL:

$ head -1 ~/.local/share/akonadi/db_data/mysql.err
2026-02-06T10:02:45.547755Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.42-alt1) starting as process 4096</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>282381</commentid>
    <comment_count>2</comment_count>
    <who name="Gleb Kulikov">glebus</who>
    <bug_when>2026-02-20 15:10:27 +0300</bug_when>
    <thetext>ситуация в точности одинакова на K-станции и Starterkit.

NAME=&quot;ALT Linux&quot;
VERSION=&quot;11&quot;
ID=altlinux
VERSION_ID=11
PRETTY_NAME=&quot;ALT Starterkit 11 (Salvia)&quot;
ANSI_COLOR=&quot;1;33&quot;
CPE_NAME=&quot;cpe:/o:alt:starterkit:11&quot;
BUILD_ID=&quot;ALT 11.1&quot;
ALT_BRANCH_ID=&quot;p11&quot;
HOME_URL=&quot;https://en.altlinux.org/starterkits&quot;
BUG_REPORT_URL=&quot;https://bugs.altlinux.org/&quot;
LOGO=altlinux

Да, я в курсе. Однако, рабочее окружение унаследовано (много лет!). Когда-то менялось на maria, когда-то на mysql. Терять наработанную почту невозможно, приходится в любом случае переключаться на maria. До последнего обновления (в т.ч. в Сизифе) это проблем не вызывало, Аконади работало нормально. 
После сегодняшнего обновления -- падение сервера. При перезагрузке с предыдущим снэпшотом системы (mariadb-server-10.11.15-alt1.x86_64) никаких проблем не замечено.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>282382</commentid>
    <comment_count>3</comment_count>
    <who name="Alexander Makeenkov">amakeenk</who>
    <bug_when>2026-02-20 15:28:38 +0300</bug_when>
    <thetext>https://packages.altlinux.org/ru/tasks/408663/ попробуйте обновиться до этого задания.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>282413</commentid>
    <comment_count>4</comment_count>
    <who name="Alexei Takaseev">taf</who>
    <bug_when>2026-02-21 07:28:28 +0300</bug_when>
    <thetext>

*** This bug has been marked as a duplicate of bug 57864 ***</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>282534</commentid>
    <comment_count>5</comment_count>
    <who name="Gleb Kulikov">glebus</who>
    <bug_when>2026-02-24 09:55:53 +0300</bug_when>
    <thetext>(Ответ для Alexander Makeenkov на комментарий #3)
&gt; https://packages.altlinux.org/ru/tasks/408663/ попробуйте обновиться до
&gt; этого задания.

похоже, это работает.
в течении дня буду смотреть подробнее</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>