• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Random server crash

Random server crash 7 months 3 weeks ago #42957

  • folamour
  • folamour's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
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,
The topic has been locked.

Random server crash 7 months 3 weeks ago #42958

  • octavian
  • octavian's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 783
  • Thank you received: 110
The error is rather self explanatory:

"Can't create/write to file '/var/cache/mysql/#sql-temptable-96d-29fe1-13ba1.MAI' (Errcode: 28 "No space left on device")

There is no space left on your MySQL server.

The fact that you are seeing RSFirewall! in there is because the RSFirewall! System Plugin is set to run as the first plugin but that doesn't have anything to do with the error you're receiving. Feel free to uninstall RSFirewall! completely - you'll end up with the same error from your MySQL server.

Regards
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The topic has been locked.
The following user(s) said Thank You: folamour
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!