Django randomly giving Access Denied for MySQL
I have a Django app which is reading a MySQL database and serving that data in a template rendered by Django.
I am getting the following error sometimes randomly:
1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES)
My django url is /getdata. I hit it and it works fine, fetches the data and renders the template perfectly. Now, I hit refresh and I get the above mentioned access denied error.
Now again, if I refresh the page, the error disappears and the page is rendered just fine.
If I refresh the page 10 times, then I am getting this error 3 out of 10 times.
And after a while, the django server just crashes, leaving nothing in the logs.
I am running the MySQL server in a docker container with 3306 and 33060 exposed. My Django server is also running in a separate docker container.
When the django server crashes, it's container stops leaving the following in the docker deamon logs :
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11-08:00" level=info msg="shim reaped" id=6512d0b483768c839770c684bd477780d360bce5fd5894e6e49f77da9b6b70eb
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11.773109234-08:00" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
I need some recommendations for debugging.
python mysql docker django
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
add a comment |
I have a Django app which is reading a MySQL database and serving that data in a template rendered by Django.
I am getting the following error sometimes randomly:
1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES)
My django url is /getdata. I hit it and it works fine, fetches the data and renders the template perfectly. Now, I hit refresh and I get the above mentioned access denied error.
Now again, if I refresh the page, the error disappears and the page is rendered just fine.
If I refresh the page 10 times, then I am getting this error 3 out of 10 times.
And after a while, the django server just crashes, leaving nothing in the logs.
I am running the MySQL server in a docker container with 3306 and 33060 exposed. My Django server is also running in a separate docker container.
When the django server crashes, it's container stops leaving the following in the docker deamon logs :
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11-08:00" level=info msg="shim reaped" id=6512d0b483768c839770c684bd477780d360bce5fd5894e6e49f77da9b6b70eb
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11.773109234-08:00" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
I need some recommendations for debugging.
python mysql docker django
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
add a comment |
I have a Django app which is reading a MySQL database and serving that data in a template rendered by Django.
I am getting the following error sometimes randomly:
1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES)
My django url is /getdata. I hit it and it works fine, fetches the data and renders the template perfectly. Now, I hit refresh and I get the above mentioned access denied error.
Now again, if I refresh the page, the error disappears and the page is rendered just fine.
If I refresh the page 10 times, then I am getting this error 3 out of 10 times.
And after a while, the django server just crashes, leaving nothing in the logs.
I am running the MySQL server in a docker container with 3306 and 33060 exposed. My Django server is also running in a separate docker container.
When the django server crashes, it's container stops leaving the following in the docker deamon logs :
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11-08:00" level=info msg="shim reaped" id=6512d0b483768c839770c684bd477780d360bce5fd5894e6e49f77da9b6b70eb
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11.773109234-08:00" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
I need some recommendations for debugging.
python mysql docker django
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
I have a Django app which is reading a MySQL database and serving that data in a template rendered by Django.
I am getting the following error sometimes randomly:
1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES)
My django url is /getdata. I hit it and it works fine, fetches the data and renders the template perfectly. Now, I hit refresh and I get the above mentioned access denied error.
Now again, if I refresh the page, the error disappears and the page is rendered just fine.
If I refresh the page 10 times, then I am getting this error 3 out of 10 times.
And after a while, the django server just crashes, leaving nothing in the logs.
I am running the MySQL server in a docker container with 3306 and 33060 exposed. My Django server is also running in a separate docker container.
When the django server crashes, it's container stops leaving the following in the docker deamon logs :
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11-08:00" level=info msg="shim reaped" id=6512d0b483768c839770c684bd477780d360bce5fd5894e6e49f77da9b6b70eb
Jan 24 10:24:11 x.x.x.x dockerd[7408]: time="2019-01-24T10:24:11.773109234-08:00" level=info msg="ignoring event" module=libcontainerd namespace=moby topic=/tasks/delete type="*events.TaskDelete"
I need some recommendations for debugging.
python mysql docker django
python mysql docker django
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
asked Jan 24 at 20:41
Utsav JainUtsav Jain
61
61
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fsuperuser.com%2fquestions%2f1398077%2fdjango-randomly-giving-access-denied-for-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1398077%2fdjango-randomly-giving-access-denied-for-mysql%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
