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.