- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Magento 2.3.2 database does not save any data changes in Admin Panel
There is something in our mage 2.3 database that is preventing us from saving any changes on in the admin panel (backend) and front end (customers making orders). While we suspect that the database is corrupted, we cannot absolutely pinpoint where the corruption is, i.e. which table is corrupted. Database check does not give any clue of any corruption and we can actually query the database using PHP Admin.
I hope that somebody has experienced the same issue and share their resolution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Hi @xumsoft,
There may be some issue with cache and indexing.
Try the following command once and check.
Flush the cache from admin or command.
php bin/magento cache:flush Or sudo rm -rf var/cache/*
For indexing
php bin/magento indexer:reindex
I hope it will help you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Hi Vimal,
Thanks for your response.
We actually did executed the cache:flush and indexer:reindex several times already and also did manually remove the var/cache. But the issue was not resolved. There is an error log whenever we make changes to the data. I will send you the details on the next post.
Are there other tricks/tips we can try?
Regards,
Elpie
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Hi Vimal,
Here is an excerpt of the exception error we are getting whenever we save in the admin panel:
1 exception(s):
Exception #0 (Exception): Warning: session_start(): Failed to decode session object. Session has been destroyed in /home/rjonline/public_html/dev23/vendor/magento/framework/Session/SessionManager.php on line 206
Exception #0 (Exception): Warning: session_start(): Failed to decode session object. Session has been destroyed in /home/rjonline/public_html/dev23/vendor/magento/framework/Session/SessionManager.php on line 206
<pre>#1 session_start() called at [vendor/magento/framework/Session/SessionManager.php:206]
#2 Magento\Framework\Session\SessionManager->start() called at [generated/code/Magento/Backend/Model/Auth/Session/Interceptor.php:167]
#3 Magento\Backend\Model\Auth\Session\Interceptor->start() called at [vendor/magento/framework/Session/SessionManager.php:140]
#4 Magento\Framework\Session\SessionManager->__construct(&Magento\Framework\App\Request\Http#000000006f24ea25000000001bd86528#, &Magento\Framework\Session\SidResolver\Proxy#000000006f24ea62000000001bd86528#, &Magento\Backend\Model\Session\AdminConfig#000000006f24ebf6000000001bd86528#, &Magento\Framework\Session\SaveHandler#000000006f24ebee000000001bd86528#, &Magento\Framework\Session\Validator#000000006f24eb11000000001bd86528#, &Magento\Framework\Session\Storage#000000006f24eb13000000001bd86528#, &Magento\Framework\Stdlib\Cookie\PhpCookieManager#000000006f24ea52000000001bd86528#, &Magento\Framework\Stdlib\Cookie\CookieMetadataFactory#000000006f24ea56000000001bd86528#, &Magento\Framework\App\State\Interceptor#000000006f24ea88000000001bd86528#) called at [vendor/magento/module-backend/Model/Auth/Session.php:101]
#5 Magento\Backend\Model\Auth\Session->__construct(&Magento\Framework\App\Request\Http#000000006f24ea25000000001bd86528#, &Magento\Framework\Session\SidResolver\Proxy#000000006f24ea62000000001bd86528#, &Magento\Backend\Model\Session\AdminConfig#000000006f24ebf6000000001bd86528#, &Magento\Framework\Session\SaveHandler#000000006f24ebee000000001bd86528#, &Magento\Framework\Session\Validator#000000006f24eb11000000001bd86528#, &Magento\Framework\Session\Storage#000000006f24eb13000000001bd86528#, &Magento\Framework\Stdlib\Cookie\PhpCookieManager#000000006f24ea52000000001bd86528#, &Magento\Framework\Stdlib\Cookie\CookieMetadataFactory#000000006f24ea56000000001bd86528#, &Magento\Framework\App\State\Interceptor#000000006f24ea88000000001bd86528#, &Magento\Framework\Acl\Builder\Proxy#000000006f24eb16000000001bd86528#, &Magento\Backend\Model\UrlInterface\Proxy#000000006f24eb99000000001bd86528#, &Magento\Backend\App\Config#000000006f24eb93000000001bd86528#) called at [generated/code/Magento/Backend/Model/Auth/Session/Interceptor.php:14]
#6 Magento\Backend\Model\Auth\Session\Interceptor->__construct(&Magento\Framework\App\Request\Http#000000006f24ea25000000001bd86528#, &Magento\Framework\Session\SidResolver\Proxy#000000006f24ea62000000001bd86528#, &Magento\Backend\Model\Session\AdminConfig#000000006f24ebf6000000001bd86528#, &Magento\Framework\Session\SaveHandler#000000006f24ebee000000001bd86528#, &Magento\Framework\Session\Validator#000000006f24eb11000000001bd86528#, &Magento\Framework\Session\Storage#000000006f24eb13000000001bd86528#, &Magento\Framework\Stdlib\Cookie\PhpCookieManager#000000006f24ea52000000001bd86528#, &Magento\Framework\Stdlib\Cookie\CookieMetadataFactory#000000006f24ea56000000001bd86528#, &Magento\Framework\App\State\Interceptor#000000006f24ea88000000001bd86528#, &Magento\Framework\Acl\Builder\Proxy#000000006f24eb16000000001bd86528#, &Magento\Backend\Model\UrlInterface\Proxy#000000006f24eb99000000001bd86528#, &Magento\Backend\App\Config#000000006f24eb93000000001bd86528#) called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:116]
#7 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Backend\...', array(&Magento\Framework\App\Request\Http#000000006f24ea25000000001bd86528#, &Magento\Framework\Session\SidResolver\Proxy#000000006f24ea62000000001bd86528#, &Magento\Backend\Model\Session\AdminConfig#000000006f24ebf6000000001bd86528#, &Magento\Framework\Session\SaveHandler#000000006f24ebee000000001bd86528#, &Magento\Framework\Session\Validator#000000006f24eb11000000001bd86528#, &Magento\Framework\Session\Storage#000000006f24eb13000000001bd86528#, &Magento\Framework\Stdlib\Cookie\PhpCookieManager#000000006f24ea52000000001bd86528#, &Magento\Framework\Stdlib\Cookie\CookieMetadataFactory#000000006f24ea56000000001bd86528#, &Magento\Framework\App\State\Interceptor#000000006f24ea88000000001bd86528#, &Magento\Framework\Acl\Builder\Proxy#000000006f24eb16000000001bd86528#, &Magento\Backend\Model\UrlInterface\Proxy#000000006f24eb99000000001bd86528#, &Magento\Backend\App\Config#000000006f24eb93000000001bd86528#)) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:66]
#8 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#9 Magento\Framework\ObjectManager\ObjectManager->get('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:160]
#10 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgument(array('instance' => 'Magento\Backend\...'), 'Magento\Backend\...', NULL, 'authStorage', 'Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:246]
#11 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgumentsInRuntime('Magento\Backend\...', array(array('eventManager', 'Magento\Framewor...', true, NULL), array('backendData', 'Magento\Backend\...', true, NULL), array('authStorage', 'Magento\Backend\...', true, NULL), array('credentialStorag...', 'Magento\Backend\...', true, NULL), array('coreConfig', 'Magento\Framewor...', true, NULL), array('modelFactory', 'Magento\Framewor...', true, NULL)), array()) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:34]
#12 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->_resolveArguments('Magento\Backend\...', array(array('eventManager', 'Magento\Framewor...', true, NULL), array('backendData', 'Magento\Backend\...', true, NULL), array('authStorage', 'Magento\Backend\...', true, NULL), array('credentialStorag...', 'Magento\Backend\...', true, NULL), array('coreConfig', 'Magento\Framewor...', true, NULL), array('modelFactory', 'Magento\Framewor...', true, NULL)), array()) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:59]
#13 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#14 Magento\Framework\ObjectManager\ObjectManager->get('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:160]
#15 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgument(array('instance' => 'Magento\Backend\...'), 'Magento\Backend\...', NULL, 'auth', 'Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:246]
#16 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgumentsInRuntime('Magento\Backend\...', array(array('auth', 'Magento\Backend\...', true, NULL), array('formKeyValidator', 'Magento\Framewor...', true, NULL), array('backendUrl', 'Magento\Backend\...', true, NULL), array('redirectFactory', 'Magento\Framewor...', true, NULL), array('rawResultFactory', 'Magento\Framewor...', true, NULL)), array()) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:34]
#17 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->_resolveArguments('Magento\Backend\...', array(array('auth', 'Magento\Backend\...', true, NULL), array('formKeyValidator', 'Magento\Framewor...', true, NULL), array('backendUrl', 'Magento\Backend\...', true, NULL), array('redirectFactory', 'Magento\Framewor...', true, NULL), array('rawResultFactory', 'Magento\Framewor...', true, NULL)), array()) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:59]
#18 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#19 Magento\Framework\ObjectManager\ObjectManager->get('Magento\Backend\...') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:196]
#20 Magento\Framework\ObjectManager\Factory\AbstractFactory->parseArray(array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\Framewor...'))) called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:172]
#21 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgument(array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\Framewor...')), NULL, NULL, 'validators', 'RequestValidator') called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:246]
#22 Magento\Framework\ObjectManager\Factory\AbstractFactory->resolveArgumentsInRuntime('RequestValidator', array(array('validators', NULL, true, NULL)), array('validators' => array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\Framewor...')))) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:34]
#23 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->_resolveArguments('RequestValidator', array(array('validators', NULL, true, NULL)), array('validators' => array('csrf_validator' => array('instance' => 'CsrfRequestValid...'), 'http_method_vali...' => array('instance' => 'Magento\Framewor...')))) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:59]
#24 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('RequestValidator') called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#25 Magento\Framework\ObjectManager\ObjectManager->get('RequestValidator') called at [vendor/magento/framework/App/FrontController.php:71]
#26 Magento\Framework\App\FrontController->__construct(&Magento\Framework\App\RouterList#000000006f24ebc8000000001bd86528#, &Magento\Framework\App\Response\Http\Interceptor#000000006f24ea50000000001bd86528#, NULL, NULL, NULL) called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:14]
#27 Magento\Framework\App\FrontController\Interceptor->__construct(&Magento\Framework\App\RouterList#000000006f24ebc8000000001bd86528#, &Magento\Framework\App\Response\Http\Interceptor#000000006f24ea50000000001bd86528#, NULL, NULL, NULL) called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:116]
#28 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Framewor...', array(&Magento\Framework\App\RouterList#000000006f24ebc8000000001bd86528#, &Magento\Framework\App\Response\Http\Interceptor#000000006f24ea50000000001bd86528#, NULL, NULL, NULL)) called at [vendor/magento/framework/ObjectManager/Factory/Dynamic/Developer.php:66]
#29 Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Framewor...') called at [vendor/magento/framework/ObjectManager/ObjectManager.php:70]
#30 Magento\Framework\ObjectManager\ObjectManager->get('Magento\Framewor...') called at [vendor/magento/framework/App/Http.php:136]
#31 Magento\Framework\App\Http->launch() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:24]
#32 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:261]
#33 Magento\Framework\App\Bootstrap->run(&Magento\Framework\App\Http\Interceptor#000000006f24ea5b000000001bd86528#) called at [index.php:39]
</pre>
Regards,
xumsoft
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Hello @xumsoft
Please try to increase memory_limit and session_lifetime.
Hope this will resolve your session_start() issue.
If it helps you, accept it as solution and give kudos.
Regards
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
HI @xumsoft,
I got your issue.
You need to give directory path for the sessions.
So change in the app/etc/env.php file and
find
array (
'save' => 'files',
),
and replace with
array (
'save' => 'files',
'save_path' => 'var/session',
),
OR IFYOU WANT TO SAVE SESSION IN THE DB THEN:
array ( 'save' => 'db', ),
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Hi Sarvagya,
Thanks for the suggestion.
We already have the settings in php.ini as follows:
memory_limit = 4G
session.gc_maxlifetime = 1440
session.save_handler = files
session.save_path = "/var/tmp"
But the issue remains unresolved.
Regards,
xumsoft
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
@xumsoft
Have you tried env.php file changes as mentioned in my recent post?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
Our env.php file has already the following setting:
'session' => [
array (
'save' => 'files',
'save_path' => 'var/session' //session folder
)
... but admin panel is still crashing on a simple function on putting a sales order on Hold.
Regards,
Xumsoft
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Magento 2.3.2 database does not save any data changes in Admin Panel
We already have that setting in our env.php but it is still crashing.
Regards,
Xumsoft