Magento 2.3.2 database does not save any data changes in Admin Panel

[xumsoft]

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.  

[Vimal Kumar]

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!

[xumsoft]

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

[xumsoft]

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

[Sarvagya Pandey]

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

[Vimal Kumar]

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',
),

For reference:
Link1
Link2

I hope it will resolve your issue.

[xumsoft]

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

[Vimal Kumar]

@xumsoft 

Have you tried env.php file changes as mentioned in my recent post?

[xumsoft]

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

[xumsoft]

We already have that setting in our env.php but it is still crashing.

Regards,

Xumsoft