This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Mariadb Crash importing tablespace

I am trying to recover a database but while importing tablespace mariadb gets crashed Getting below logs, tried modifying the wait_timeout, innodb buffer, log size

innoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-09-21 10:20:23 0 [Note] InnoDB: Waiting for purge to start
2021-09-21 10:20:23 0 [Note] InnoDB: 10.4.11 started; log sequence number 6929076; transaction id 5646
2021-09-21 10:20:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-09-21 10:20:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-21 10:20:23 0 [Note] InnoDB: Buffer pool(s) load c:\xampp\mysql\bin\mysqld.exe, Version: 10.4.11-MariaDB-log (mariadb.org binary distribution). started with:
TCP Port: 3306, Named Pipe: C:/xampp/mysql/mysql.sock
Time		    Id Command	Argument
completed at 210921 10:20:23
2021-09-21 10:20:23 0 [Note] Server socket created on IP: '::'.

Below is the my.ini config

# The MySQL server
default-character-set=utf8mb4
[mysqld]
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
# enable-named-pipe
#key_buffer=8128M
max_allowed_packet=512M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"
general_log_file="mysql_error.log"
general_log=1

wait_timeout=9000
net_read_timeout=9000
net_write_timeout=9000
interactive_timeout=9000
connect_timeout=9000

# Where do all the plugins live
plugin_dir="C:/xampp/mysql/lib/plugin/"

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	=1

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir="C:/xampp/mysql/data"
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir="C:/xampp/mysql/data"

innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 512M
innodb_log_file_size = 1G
innodb_write_io_threads = 32
innodb_flush_log_at_trx_commit = 0

sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
log_bin_trust_function_creators=1

character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
[mysqldump]
max_allowed_packet=512M

[mysql]
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]

Answer Answered by Ian Gilfillan in this comment.

There's no information about a crash in what you've provided above? (I've formatted your text to make it readable)

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.