Hi folks, since 3 month we have random server crash, we have found that was linked to a SQL temp folder issue who is full (error 28), but this seem also linked to a RS firewall event, (i'll asked several time and support told me there is no link) we moved from a mutualised to a VPS 4 go server because joomlart told that the error was possibly linked to the capacity of the server, because this crash is also linked to a SQL request.
but the random crash continue....
on the event log of the server here is the issue :
2023-09-06T09:05:35+00:00 WARNING 136.243.212.93 jerror Impossible de supprimer le dossier. Chemin : [ROOT]/administrator/cache/_media_version
2023-09-06T09:05:45+00:00 CRITICAL 54.36.148.91 error Uncaught Throwable of type mysqli_sql_exception thrown with message "Can't create/write to file '/var/cache/mysql/#sql-temptable-96d-29fe1-13ba1.MAI' (Errcode: 28 "No space left on device")". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(137): mysqli->prepare('SHOW FULL COLUM...')
#1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1089): Joomla\Database\Mysqli\MysqliStatement->__construct(Object(mysqli), 'SHOW FULL COLUM...')
#2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1900): Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SHOW FULL COLUM...')
#3 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(625): Joomla\Database\DatabaseDriver->setQuery(Object(Joomla\Database\Mysqli\MysqliQuery))
#4 [ROOT]/libraries/src/Table/Table.php(248): Joomla\Database\Mysqli\MysqliDriver->getTableColumns('#__rsfirewall_l...', false)
#5 [ROOT]/libraries/src/Table/Table.php(193): Joomla\CMS\Table\Table->getFields()
#6 [ROOT]/administrator/components/com_rsfirewall/tables/logs.php(36): Joomla\CMS\Table\Table->__construct('#__rsfirewall_l...', Array, Object(Joomla\Database\Mysqli\MysqliDriver))
#7 [ROOT]/libraries/src/Table/Table.php(317): RsfirewallTableLogs->__construct(Object(Joomla\Database\Mysqli\MysqliDriver))
#8 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(24): Joomla\CMS\Table\Table::getInstance('Logs', 'RsfirewallTable')
#9 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(78): RSFirewallLogger->__construct()
#10 [ROOT]/plugins/system/rsfirewall/rsfirewall.php(56): RSFirewallLogger::getInstance()
#11 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(242): plgSystemRsfirewall->__construct(Object(Joomla\Event\Dispatcher), Array)
#12 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(160): Joomla\CMS\Application\CMSApplication->loadPluginFromFilesystem('rsfirewall', 'system')
#13 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(99): Joomla\CMS\Application\CMSApplication->loadExtension('Joomla\\CMS\\Exte...', 'rsfirewall:syst...', '/home/danisegi/...')
#14 [ROOT]/libraries/src/Plugin/PluginHelper.php(232): Joomla\CMS\Application\CMSApplication->bootPlugin('rsfirewall', 'system')
#15 [ROOT]/libraries/src/Plugin/PluginHelper.php(192): Joomla\CMS\Plugin\PluginHelper::import(Object(stdClass), true, Object(Joomla\Event\Dispatcher))
#16 [ROOT]/libraries/src/Application/CMSApplication.php(744): Joomla\CMS\Plugin\PluginHelper::importPlugin('system')
#17 [ROOT]/libraries/src/Application/SiteApplication.php(635): Joomla\CMS\Application\CMSApplication->initialiseApp(Array)
#18 [ROOT]/libraries/src/Application/SiteApplication.php(226): Joomla\CMS\Application\SiteApplication->initialiseApp()
#19 [ROOT]/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\SiteApplication->doExecute()
#20 [ROOT]/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#21 [ROOT]/index.php(32): require_once('/home/danisegi/...')
#22 {main}
2023-09-06T09:05:45+00:00 CRITICAL 40.77.167.63 error Uncaught Throwable of type mysqli_sql_exception thrown with message "Can't create/write to file '/var/cache/mysql/#sql-temptable-96d-29fe2-13ba2.MAI' (Errcode: 28 "No space left on device")". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(137): mysqli->prepare('SHOW FULL COLUM...')
#1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1089): Joomla\Database\Mysqli\MysqliStatement->__construct(Object(mysqli), 'SHOW FULL COLUM...')
#2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1900): Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SHOW FULL COLUM...')
#3 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(625): Joomla\Database\DatabaseDriver->setQuery(Object(Joomla\Database\Mysqli\MysqliQuery))
#4 [ROOT]/libraries/src/Table/Table.php(248): Joomla\Database\Mysqli\MysqliDriver->getTableColumns('#__rsfirewall_l...', false)
#5 [ROOT]/libraries/src/Table/Table.php(193): Joomla\CMS\Table\Table->getFields()
#6 [ROOT]/administrator/components/com_rsfirewall/tables/logs.php(36): Joomla\CMS\Table\Table->__construct('#__rsfirewall_l...', Array, Object(Joomla\Database\Mysqli\MysqliDriver))
#7 [ROOT]/libraries/src/Table/Table.php(317): RsfirewallTableLogs->__construct(Object(Joomla\Database\Mysqli\MysqliDriver))
#8 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(24): Joomla\CMS\Table\Table::getInstance('Logs', 'RsfirewallTable')
#9 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(78): RSFirewallLogger->__construct()
#10 [ROOT]/plugins/system/rsfirewall/rsfirewall.php(56): RSFirewallLogger::getInstance()
#11 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(242): plgSystemRsfirewall->__construct(Object(Joomla\Event\Dispatcher), Array)
#12 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(160): Joomla\CMS\Application\CMSApplication->loadPluginFromFilesystem('rsfirewall', 'system')
#13 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(99): Joomla\CMS\Application\CMSApplication->loadExtension('Joomla\\CMS\\Exte...', 'rsfirewall:syst...', '/home/danisegi/...')
#14 [ROOT]/libraries/src/Plugin/PluginHelper.php(232): Joomla\CMS\Application\CMSApplication->bootPlugin('rsfirewall', 'system')
#15 [ROOT]/libraries/src/Plugin/PluginHelper.php(192): Joomla\CMS\Plugin\PluginHelper::import(Object(stdClass), true, Object(Joomla\Event\Dispatcher))
#16 [ROOT]/libraries/src/Application/CMSApplication.php(744): Joomla\CMS\Plugin\PluginHelper::importPlugin('system')
#17 [ROOT]/libraries/src/Application/SiteApplication.php(635): Joomla\CMS\Application\CMSApplication->initialiseApp(Array)
#18 [ROOT]/libraries/src/Application/SiteApplication.php(226): Joomla\CMS\Application\SiteApplication->initialiseApp()
#19 [ROOT]/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\SiteApplication->doExecute()
#20 [ROOT]/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#21 [ROOT]/index.php(32): require_once('/home/danisegi/...')
#22 {main}
2023-09-06T09:05:46+00:00 CRITICAL 194.187.169.40 error Uncaught Throwable of type mysqli_sql_exception thrown with message "Can't create/write to file '/var/cache/mysql/#sql-temptable-96d-29fe3-13ba3.MAI' (Errcode: 28 "No space left on device")". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(137): mysqli->prepare('SHOW FULL COLUM...')
#1 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(1089): Joomla\Database\Mysqli\MysqliStatement->__construct(Object(mysqli), 'SHOW FULL COLUM...')
#2 [ROOT]/libraries/vendor/joomla/database/src/DatabaseDriver.php(1900): Joomla\Database\Mysqli\MysqliDriver->prepareStatement('SHOW FULL COLUM...')
#3 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(625): Joomla\Database\DatabaseDriver->setQuery(Object(Joomla\Database\Mysqli\MysqliQuery))
#4 [ROOT]/libraries/src/Table/Table.php(248): Joomla\Database\Mysqli\MysqliDriver->getTableColumns('#__rsfirewall_l...', false)
#5 [ROOT]/libraries/src/Table/Table.php(193): Joomla\CMS\Table\Table->getFields()
#6 [ROOT]/administrator/components/com_rsfirewall/tables/logs.php(36): Joomla\CMS\Table\Table->__construct('#__rsfirewall_l...', Array, Object(Joomla\Database\Mysqli\MysqliDriver))
#7 [ROOT]/libraries/src/Table/Table.php(317): RsfirewallTableLogs->__construct(Object(Joomla\Database\Mysqli\MysqliDriver))
#8 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(24): Joomla\CMS\Table\Table::getInstance('Logs', 'RsfirewallTable')
#9 [ROOT]/administrator/components/com_rsfirewall/helpers/log.php(78): RSFirewallLogger->__construct()
#10 [ROOT]/plugins/system/rsfirewall/rsfirewall.php(56): RSFirewallLogger::getInstance()
#11 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(242): plgSystemRsfirewall->__construct(Object(Joomla\Event\Dispatcher), Array)
#12 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(160): Joomla\CMS\Application\CMSApplication->loadPluginFromFilesystem('rsfirewall', 'system')
#13 [ROOT]/libraries/src/Extension/ExtensionManagerTrait.php(99): Joomla\CMS\Application\CMSApplication->loadExtension('Joomla\\CMS\\Exte...', 'rsfirewall:syst...', '/home/danisegi/...')
#14 [ROOT]/libraries/src/Plugin/PluginHelper.php(232): Joomla\CMS\Application\CMSApplication->bootPlugin('rsfirewall', 'system')
#15 [ROOT]/libraries/src/Plugin/PluginHelper.php(192): Joomla\CMS\Plugin\PluginHelper::import(Object(stdClass), true, Object(Joomla\Event\Dispatcher))
#16 [ROOT]/libraries/src/Application/CMSApplication.php(744): Joomla\CMS\Plugin\PluginHelper::importPlugin('system')
#17 [ROOT]/libraries/src/Application/SiteApplication.php(635): Joomla\CMS\Application\CMSApplication->initialiseApp(Array)
#18 [ROOT]/libraries/src/Application/SiteApplication.php(226): Joomla\CMS\Application\SiteApplication->initialiseApp()
#19 [ROOT]/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\SiteApplication->doExecute()
#20 [ROOT]/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#21 [ROOT]/index.php(32): require_once('/home/danisegi/...')
#22 {main}
any help is welcome because joomlart asked us to close RS firewall, so its done, we are waiting the result,
thanks,