ConnectALL "Server not running" error with MySQL database for core service

Products

• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

ConnectALL Core service has startup issue and below error is shown in ../Core/logs/connectall.log

[main] com.go2group.connectall.config.dao.DatabasePersistence: Error during database select: Select automation from application_link_version where is_current = ? order by application_link_version_id
java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size

Due to this error automations won't load and ConnectALL Dashboard will show "Server not running" error.

Environment

3.x

Cause

This is MySQL config issue

Resolution

Need to increase the sort_buffer_size value

Windows:

To increase the sort buffer size in MySQL on Windows, you need to modify the sort_buffer_size variable within your MySQL configuration file (C:\ProgramData\MySQL\MySQL Server 8.0\my.ini) by adding a line like sort_buffer_size = <desired_size> or modifying the existing value and then restarting the MySQL service; remember to specify the size in bytes, using units like 'K' for kilobytes or 'M' for megabytes. 

Recommended size in 256K - 5M

 

Linux:

sudo root

vi /etc/mysql/mysql.conf.d/mysqld.cnf

set sort_buffer_size = <desired_size> 

sudo service mysql restart