No such entity with addressId, occurs randomly on visitors browser. System Log Generated

[InternetMedicineMan]

We've been having an issue on our 2.2.3 installation in Production. On occasion a visitor will report they have this System Log Generated error show up instead of the web page. I've managed to get it myself just a couple times. Every single time when you go to the filesystem and check the report it reports the following:

{"0":"No such entity with addressId = 45879","1":"#0 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-customer/Model/AddressRegistry.php(49): Magento\Framework\Exception\NoSuchEntityException::singleField('addressId', '45879')
#1 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-customer/Model/ResourceModel/AddressRepository.php(166): Magento\Customer\Model\AddressRegistry->retrieve('45879')
#2 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-persistent/Observer/EmulateCustomerObserver.php(105): Magento\Customer\Model\ResourceModel\AddressRepository->getById('45879')
</end Fragment>

The addressID is different every time. And the only way to fix it for that person, is to just clear the cookies. Once you clear your cookies for the domain everything works perfectly fine again. It almost seems like something on the cookies is getting corrupt. It's pretty rare that it happens but we have a busy store, so rare is still 2-5 times a day.

Preconditions

1. Magento 2.2.3
2. PHP v 7.0.23
3. Percona
4. Managed Magento server at Nexcess

Steps to reproduce

I have not managed to figure out reliable steps to reproduce. Appears to be random

Expected result

1. It shouldn't produce an error?

Actual result

{"0":"No such entity with addressId = 45879","1":"#0 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-customer/Model/AddressRegistry.php(49): Magento\Framework\Exception\NoSuchEntityException::singleField('addressId', '45879')\n#1 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-customer/Model/ResourceModel/AddressRepository.php(166): Magento\Customer\Model\AddressRegistry->retrieve('45879')\n#2 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-persistent/Observer/EmulateCustomerObserver.php(105): Magento\Customer\Model\ResourceModel\AddressRepository->getById('45879')\n#3 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(72): Magento\Persistent\Observer\EmulateCustomerObserver->execute(Object(Magento\Framework\Event\Observer))\n#4 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(60): Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod(Object(Magento\Persistent\Observer\EmulateCustomerObserver), Object(Magento\Framework\Event\Observer))\n#5 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->dispatch(Array, Object(Magento\Framework\Event\Observer))\n#6 /chroot/home/wonderci/retailer.wondercide.com/html/generated/code/Magento/Framework/Event/Manager/Proxy.php(95): Magento\Framework\Event\Manager->dispatch('controller_acti...', Array)\n#7 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/App/Action/Action.php(96): Magento\Framework\Event\Manager\Proxy->dispatch('controller_acti...', Array)\n#8 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http))\n#9 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Cms\Controller\Index\Index\Interceptor->___callParent('dispatch', Array)\n#10 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Cms\Controller\Index\Index\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))\n#11 /chroot/home/wonderci/retailer.wondercide.com/html/generated/code/Magento/Cms/Controller/Index/Index/Interceptor.php(39): Magento\Cms\Controller\Index\Index\Interceptor->___callPlugins('dispatch', Array, Array)\n#12 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/App/FrontController.php(55): Magento\Cms\Controller\Index\Index\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))\n#13 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(58): Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))\n#14 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', Array)\n#15 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php(94): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))\n#16 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(135): Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))\n#17 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php(69): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))\n#18 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(135): Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))\n#19 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/Interception/Interceptor.php(153): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http))\n#20 /chroot/home/wonderci/retailer.wondercide.com/html/generated/code/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, NULL)\n#21 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))\n#22 /chroot/home/wonderci/retailer.wondercide.com/html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch()\n#23 /chroot/home/wonderci/retailer.wondercide.com/html/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http\Interceptor->launch()\n#24 /chroot/home/wonderci/wondercide.com/html/index.php(43): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor))\n#25 {main}","url":"/","script_name":"/index.php"}

Additional Information

The issue is not trivial and reproducible only in specific condition(s) or situation.
Here is the summary based investigation and comments

• approach to fix No such entity with addressId, occurs randomly on visitors browser. System Log Generated #15115 (comment)
• The latest steps to reproduce and cause: No such entity with addressId, occurs randomly on visitors browser. System Log Generated #15115 (comment)
• one more RCA: No such entity with addressId, occurs randomly on visitors browser. System Log Generated #15115 (comment)

[hunterallen]

Did you find a solution? I am facing the same issue, but cannot find a way to reproduce it.

[InternetMedicineMan]

@hunterallen No I haven't found a solution. Appears to happen randomly. If a customer calls us about the issue, having them clear their cookies solves the issue. I have no idea why it happens or how to prevent it. But the problem is being caused in the cookies.

[hunterallen]

What happened to me was that a customer was checking out with a new shipping address and a new (but different from shipping) billing address. Once I manually added the address to that customers account the error went away.

[chattertech]

I am also having the same error. Only happens for customers who are logged in.

[kanduvisla]

I have this when I try to create an order in the admin for customers that have an account.

I'm using Magento 2.2.5. The error is:

No such entity with addressId =

Note that the customer has an account and an address, and use for shipping address the "use same as billing address" is checked.

[Kingball]

I found the problem.
This happen if new customer have fail transaction payment on first time.
so the customer id and address id not connect.

how to reproduce :

• Change payment key (public key or private key) so, transaction always fail
• create new customer
• make transaction
• make payment -> result is fail
• Change back payment key
• make payment -> result success
• sign out (Error No such entity with addressId = xxx)
• Clear cookie
• Sign In back
• SIgn Out (Error No such entity with addressId = xxx)

I don't how to fix it. hope someone can help to fix it

Thank you

Hi @InternetMedicineMan thank you for you report, the fix for this issue has already on 2.2-develop and 2.3-develop branch