Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.26, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
Debian 9.2 running on AMD Phenom(tm) II X4 955 Processor
Description
I am currently running MariaDB version 10.1.26-MariaDB-0+deb9u1 on Debian 9.2. aria_pack is failing with the "Segmentation fault" when the table as 39639 or more, aria_pack fails as per below output.
aria_pack -t /var/lib/mysql/mygoweekly/term_pkonly
Compressing /var/lib/mysql/mygoweekly/term_pkonly.MAD: (39639 records)
Calculating statisticsnormal: 3 empty-space: 0 empty-zero: 0 empty-fill: 1
pre-space: 0 end-space: 0 intervall-fields: 1 zero: 0
Original trees: 7 After join: 7
Compressing file
Segmentation fault
Test case:
- create term table and load data from attachment (term.sql & term.txt)
- create test table using term_pkonly.sql (it creates table and populates it from table term)
- shutdown mariadb
- aria_chk -z /var/lib/mysql/$db/term_pkonly
- aria_pack -t /var/lib/mysql/$db/term_pkonly
Server config:
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --lc-messages-dir=/usr/share/mysql --skip-external-locking --bind-address=127.0.0.1 --key_buffer_size=256M --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --tmpdir=/dev/shm/mysqltmp --myisam_recover_options=BACKUP --query_cache_limit=1M --query_cache_size=16M --log_error=/var/log/mysql/error.log --expire_logs_days=10 --max_binlog_size=100M --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci --sort_buffer_size=256M --aria-pagecache-buffer_size=512M --read_buffer_size=256M --aria_sort_buffer_size=256M