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.
3.x
This is MySQL config issue
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