mariadb service keep restart over again
dragon lu
Hi, I initially intended to add a column to my table (using the Columnstore engine). This table contains around 400 million records, and there are clients connected to the MariaDB server performing operations on the same table. While attempting to add the new column using the ALTER TABLE command, I realized that the execution time of this ALTER query was too long for me to tolerate. Consequently, I cancelled the ALTER query. After cancelling the query, I noticed that all clients, including the local server, were unable to connect to the MariaDB server. The error message "ERROR 2002 (HY000): Can't connect to local server through socket '/var/lib/mysql/mysql.sock(111)'" was displayed. Subsequently, I executed 'systemctl stop mariadb' and 'systemctl stop mariadb-columnstore' without encountering any error messages, and then proceeded to reboot.
After the reboot, I observed that the mariadb.service was continuously restarting. I entered 'journalctl -xeu mariadb' to inspect the logs and found that the logs started showing messages like 'mariadb.service: main process exited, code=dumped, status=11/SEGV' and 'mariadb.service: Failed with result 'core-dump'.' Additionally, there was a message stating 'Process 15855 (mariadb) of user 990 dumped core.'
I imported data using the 'LOAD DATA INFILE' method. The version of the MariaDB database server is 10.11.3.
I would like to inquire if there are any solutions available to address the issue of the infinite service restarts. Thank you.
Faisal Saeed
--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/945a081b-8b08-44a5-861a-c56d32b5803cn%40googlegroups.com.
