Mysql tmp dir ibtmp1 full my hard disk
€8-30 EUR
Kulipwa wakati wa kujifungua
I've a problem with Mysql tmp dir,
after few hour the tmp dir table full my hard disk, i've limited the dir to 50gb (in mysql config) but when i try to save a product on my ecommerce ( magento 2 ) get this error in the log:
[login to view URL]: Impossibile salvare la riserva di magazzino. Si prega di riprovare. {"exception":"[object] (Magento\\Framework\\Exception\\CouldNotSaveException(code: 0): Impossibile salvare la riserva di magazzino. Si prega di riprovare. at at /home/raizer96/public_html/vendor/magento/module-catalog-inventory/Model/Stock/[login to view URL], Magento\\Framework\\Exception\\LocalizedException(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler), query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` at /home/raizer96/public_html/vendor/magento/module-catalog/Model/Indexer/Product/Price/Action/[login to view URL], Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler), query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/[login to view URL], PDOException(code: HY000): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler) at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/[login to view URL])"} []
if i restart mysql service all return ok for few hour
Kitambulisho cha Mradi: #19793144
Kuhusu mradi
3 wafanyakazi huru wanazabuni wastani wa €31 kwa kazi hii
Hello, I have read your job details carefully and I can do your work if you will provide me more details of the project. I will definitely give you a better solution to your problem. Thanks Ambient Infotech
Hello, I'll check and resolve your issue. Please initiate a chat session so we can discuss more about it. Thank you.