Ttdfjt

What can Amex do if I cancel their card after using the sign up bonus miles?

If "more guns less crime", how do gun advocates explain that the EU has less crime than the US?

Why command hierarchy, if the chain of command is standing next to each other?

Are those flyers about apartment purchase a scam?

Word for an event that will likely never happen again

Are differences between uniformly distributed numbers uniformly distributed?

An equality about sin function?

Corroded Metal vs Magical Armor, should it melt it?

Is this n-speak?

How would timezones work on a planet 100 times the size of our Earth

How do some PhD students get 10+ papers? Is that what I need for landing good faculty position?

My cat is a houdini

Can lodestones be used to magnetize crude iron weapons?

How to find directories containing only specific files

In which case does the Security misconfiguration vulnerability apply to?

Why is the result of ('b'+'a'+ + 'a' + 'a').toLowerCase() 'banana'?

Regex crossword (sudoku?)

Escape Velocity - Won't the orbital path just become larger with higher initial velocity?

Why are Tucker and Malcolm not dead?

Are there really no countries that protect Freedom of Speech as the United States does?

Programmatically add log information in all renderings(controller, view) html

Why did IBM make public the PC BIOS source code?

Understanding the point of a kölsche Witz

Update Office without opening an Office application

Some Magento2 Customer's login takes too much time

Magento2 DI compilation takes too much timemagento 1.14 customer login hangs on some accountsMagento 2 Backend are very slowRedirect to customer's store view on loginMagento 2 Website taking too much time to load?Magento 2 product listing page extremely slowMagento 2.1.8 is taking too much time to loadMagento 2 - Duplicate Order IssueMagento2 : Too much apache processes running and consume memorydeploy:mode:set production taking too much time

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

We have magento2 community edition 2.2.6

We are having issues with customer login for some users,

Their login takes too much time, and in database it goes in sleep queries which remains their for like 5-10 15 minutes
Even if there are no past orders or anything, it takes forever to load and times out

this happens to some of the users, and we don't know what is cause of this issue,
we tried to find from logs and slow query logs, but didn't find the issue,

can any body help in look in this to resolve?

magento2 customer-account

share|improve this question

edited Aug 2 at 10:26

Govind Prajapati

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please add some slow & sleep query so that we can understand more
  
  – Amit Bera♦
  Aug 2 at 5:19
  
  

  
  
  
  

add a comment | 

0

We have magento2 community edition 2.2.6

We are having issues with customer login for some users,

Their login takes too much time, and in database it goes in sleep queries which remains their for like 5-10 15 minutes
Even if there are no past orders or anything, it takes forever to load and times out

this happens to some of the users, and we don't know what is cause of this issue,
we tried to find from logs and slow query logs, but didn't find the issue,

can any body help in look in this to resolve?

magento2 customer-account

share|improve this question

edited Aug 2 at 10:26

Govind Prajapati

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please add some slow & sleep query so that we can understand more
  
  – Amit Bera♦
  Aug 2 at 5:19
  
  

  
  
  
  

add a comment | 

We have magento2 community edition 2.2.6

We are having issues with customer login for some users,

Their login takes too much time, and in database it goes in sleep queries which remains their for like 5-10 15 minutes
Even if there are no past orders or anything, it takes forever to load and times out

this happens to some of the users, and we don't know what is cause of this issue,
we tried to find from logs and slow query logs, but didn't find the issue,

can any body help in look in this to resolve?

magento2 customer-account

share|improve this question

edited Aug 2 at 10:26

Govind Prajapati

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

share|improve this question

edited Aug 2 at 10:26

Govind Prajapati

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

share|improve this question

edited Aug 2 at 10:26

Govind Prajapati

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

asked Aug 2 at 5:16

Govind PrajapatiGovind Prajapati

122 bronze badges

2 Answers
2

active

oldest

votes

1

If you use another API call that take some time means all pages are taking time. For example your using P21 Integration on ur website, that api getting the response of timeout then all pages are slow.

share|improve this answer

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Not sure what do you mean by P21 integration, but this was happening to some particular users only, and not all, so if there was something like this it would have been for everybody.
  
  – Govind Prajapati
  Aug 2 at 10:25
  

  
  
  
  

add a comment | 

0

Ok, We solved this issue

(First we thought it was due to some extension but we disabled all extensions we installed and it was behaving same)

This comes due to old entries in quote table

We are not sure but some old inactive marked quote item for specific users were causing this delay, perhaps some bug in magento or dont know,

but we removed those entries from quote table which have the customer's email (customer who were facing the timeout issue) and it got fixed,

So basically Old entries some how magento is not be able process or get hold on properly via some queries running on post login pages, causing this issue,
we accidentally found the cause while running

Mysql Show Full process list again and again while it was timing out
So we checked the entry in database and found it was having customer email as logged in user, so to check I deleted that, and Bingo it was solved,

If you guys have came across similar issue and if its not solved by this method but some other method, do share your solution here

share|improve this answer

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you ever find a solution which stopped this happening? We're experiencing the same thing which happens over multiple customers (but not all). Clearing the quotes table isn't a good solution so I'm hoping to find out the root cause?
  
  – Jamie
  Aug 9 at 10:28
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f284158%2fsome-magento2-customers-login-takes-too-much-time%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

If you use another API call that take some time means all pages are taking time. For example your using P21 Integration on ur website, that api getting the response of timeout then all pages are slow.

share|improve this answer

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Not sure what do you mean by P21 integration, but this was happening to some particular users only, and not all, so if there was something like this it would have been for everybody.
  
  – Govind Prajapati
  Aug 2 at 10:25
  

  
  
  
  

add a comment | 

1

If you use another API call that take some time means all pages are taking time. For example your using P21 Integration on ur website, that api getting the response of timeout then all pages are slow.

share|improve this answer

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Not sure what do you mean by P21 integration, but this was happening to some particular users only, and not all, so if there was something like this it would have been for everybody.
  
  – Govind Prajapati
  Aug 2 at 10:25
  

  
  
  
  

add a comment | 

If you use another API call that take some time means all pages are taking time. For example your using P21 Integration on ur website, that api getting the response of timeout then all pages are slow.

share|improve this answer

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

share|improve this answer

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

answered Aug 2 at 5:20

Soundararajan mSoundararajan m

5699 bronze badges

0

Ok, We solved this issue

(First we thought it was due to some extension but we disabled all extensions we installed and it was behaving same)

This comes due to old entries in quote table

We are not sure but some old inactive marked quote item for specific users were causing this delay, perhaps some bug in magento or dont know,

but we removed those entries from quote table which have the customer's email (customer who were facing the timeout issue) and it got fixed,

So basically Old entries some how magento is not be able process or get hold on properly via some queries running on post login pages, causing this issue,
we accidentally found the cause while running

Mysql Show Full process list again and again while it was timing out
So we checked the entry in database and found it was having customer email as logged in user, so to check I deleted that, and Bingo it was solved,

If you guys have came across similar issue and if its not solved by this method but some other method, do share your solution here

share|improve this answer

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you ever find a solution which stopped this happening? We're experiencing the same thing which happens over multiple customers (but not all). Clearing the quotes table isn't a good solution so I'm hoping to find out the root cause?
  
  – Jamie
  Aug 9 at 10:28
  

  
  
  
  

add a comment | 

0

Ok, We solved this issue

(First we thought it was due to some extension but we disabled all extensions we installed and it was behaving same)

This comes due to old entries in quote table

We are not sure but some old inactive marked quote item for specific users were causing this delay, perhaps some bug in magento or dont know,

but we removed those entries from quote table which have the customer's email (customer who were facing the timeout issue) and it got fixed,

So basically Old entries some how magento is not be able process or get hold on properly via some queries running on post login pages, causing this issue,
we accidentally found the cause while running

Mysql Show Full process list again and again while it was timing out
So we checked the entry in database and found it was having customer email as logged in user, so to check I deleted that, and Bingo it was solved,

If you guys have came across similar issue and if its not solved by this method but some other method, do share your solution here

share|improve this answer

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Did you ever find a solution which stopped this happening? We're experiencing the same thing which happens over multiple customers (but not all). Clearing the quotes table isn't a good solution so I'm hoping to find out the root cause?
  
  – Jamie
  Aug 9 at 10:28
  

  
  
  
  

add a comment | 

Ok, We solved this issue

(First we thought it was due to some extension but we disabled all extensions we installed and it was behaving same)

This comes due to old entries in quote table

We are not sure but some old inactive marked quote item for specific users were causing this delay, perhaps some bug in magento or dont know,

but we removed those entries from quote table which have the customer's email (customer who were facing the timeout issue) and it got fixed,

So basically Old entries some how magento is not be able process or get hold on properly via some queries running on post login pages, causing this issue,
we accidentally found the cause while running

Mysql Show Full process list again and again while it was timing out
So we checked the entry in database and found it was having customer email as logged in user, so to check I deleted that, and Bingo it was solved,

If you guys have came across similar issue and if its not solved by this method but some other method, do share your solution here

share|improve this answer

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

share|improve this answer

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges

answered Aug 2 at 10:23

Govind PrajapatiGovind Prajapati

122 bronze badges