Some Magento2 Customer's login takes too much timeMagento2 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
Running code generated in realtime in JavaScript with eval()
What can Amex do if I cancel their card after using the sign up bonus miles?
Markov-chain sentence generator in Python
Must a locally compact, second countable, Hausdorff space support a Radon measure?
Is it okay for a ticket seller to grab a tip in the USA?
Super Duper Vdd stiffening required on 555 timer, what is the best way?
Are there any other rule mechanics that could grant Thieves' Cant?
Split phone numbers into groups based on first digit
Help, I cannot decide when to start the story
How to find directories containing only specific files
80's/90's superhero cartoon with a man on fire and a man who made ice runways like Frozone
Are differences between uniformly distributed numbers uniformly distributed?
Generate Brainfuck for the numbers 1–255
What are these funnel-looking green things in my yard?
The cat exchanges places with a drawing of the cat
Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?
What is a good class if we remove subclasses?
(A room / an office) where an artist works
Programmatically add log information in all renderings(controller, view) html
In which case does the Security misconfiguration vulnerability apply to?
Can the IPA represent all languages' tones?
Why does the standard fingering / strumming for a D maj chord leave out the 5th string?
Is there any way to stop a user from creating executables and running them?
If "more guns less crime", how do gun advocates explain that the EU has less crime than the US?
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;
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
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
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
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
magento2 customer-account
edited Aug 2 at 10:26
Govind Prajapati
asked Aug 2 at 5:16
Govind PrajapatiGovind Prajapati
12 bronze badges
12 bronze badges
Please add some slow & sleep query so that we can understand more
– Amit Bera♦
Aug 2 at 5:19
add a comment |
Please add some slow & sleep query so that we can understand more
– Amit Bera♦
Aug 2 at 5:19
Please add some slow & sleep query so that we can understand more
– Amit Bera♦
Aug 2 at 5:19
Please add some slow & sleep query so that we can understand more
– Amit Bera♦
Aug 2 at 5:19
add a comment |
2 Answers
2
active
oldest
votes
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.
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 |
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
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
);
);
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
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
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
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.
answered Aug 2 at 5:20
Soundararajan mSoundararajan m
569 bronze badges
569 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 |
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
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
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 |
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
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
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
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
answered Aug 2 at 10:23
Govind PrajapatiGovind Prajapati
12 bronze badges
12 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 |
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
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
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 |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Please add some slow & sleep query so that we can understand more
– Amit Bera♦
Aug 2 at 5:19