Lost connection to MySQL server during query

I have a standalone python script (i.e. not part of a web app) that makes use of the ORM. I call djago.setup(), make some queries, then call a function that can take 8 hours or more to run. When the function returns I want to make more queries, but they fail with 'Lost connection to MySQL server

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

Okay. Please check error logs of mysql. Its default path: /var/log/mysql/error.log Please look into any error signals for the same table into it. This could give clue for root cause of issue. Regards, Krishnasagar Subhedarpage On Thu, 15 Nov 2018 at 14:42, prateek gupta wrote: > Hi, > > My

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

Try reducing the connection max age to a lesser value like 3600 maybe? On Nov 15, 2018 2:41 PM, "prateek gupta" wrote: > Hi, > > My all db have 20 gb of size. > > On Thursday, November 15, 2018 at 12:27:27 PM UTC+5:30, Krishnasagar > Subhedarpage wrote: >> >> Hi Prateek, >> >> Did you check

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

Hi, My all db have 20 gb of size. On Thursday, November 15, 2018 at 12:27:27 PM UTC+5:30, Krishnasagar Subhedarpage wrote: > > Hi Prateek, > > Did you check disk info of server instance? What's disk consumption? > > Regards, > Krishnasagar Subhedarpage > > > > > On Thu, 15 Nov 2018 at 12:09,

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

Hi Prateek, Did you check disk info of server instance? What's disk consumption? Regards, Krishnasagar Subhedarpage On Thu, 15 Nov 2018 at 12:09, prateek gupta wrote: > It is strange again, now I am getting the same error. > Till morning it was working fine but now it is again showing same

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

It is strange again, now I am getting the same error. Till morning it was working fine but now it is again showing same error. On Wednesday, November 14, 2018 at 7:07:46 PM UTC+5:30, Jason wrote: > > also, you might want to update your mysqlclient package. 1.3.12 was > released over a year ago,

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

Thanks Jason! I have restarted teh server and updated the mysqlclient to 1.3.13 and the issue got resolved now. On Wednesday, November 14, 2018 at 7:07:46 PM UTC+5:30, Jason wrote: > > also, you might want to update your mysqlclient package. 1.3.12 was > released over a year ago, and 1.3.13

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

also, you might want to update your mysqlclient package. 1.3.12 was released over a year ago, and 1.3.13 was pushed out late June of this year. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving

Re: How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

just checking, but did you restart the mysql server after setting that max_allowed_packet setting? It won't stick without a restart. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails

How to solve django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')?

, 'Lost connection to MySQL server during query') The above error comes only for one table, rest all are working fine. I tried to set the max_allowed_packet=67108864 in mysql configuration file and in settings.py I have set the CONN_MAX_AGE=6000 but it is not working. Have anyone faced the same

'Lost connection to MySQL server during query'

Hi, We are using amazon AWS to run our commands that then talk to a db on amazon RDS. Our nightly commands sometimes fail with 'Lost connection to MySQL server during query' - this only happens on our big databases. If the commands are successful they usually report 28,29 mins. So we feel

Re: django, celery and mysql: Lost connection to MySQL server during query

I raised the log level to debug: ./manage.py celeryd -l debug That's the new piece of information: Out of memory (Needed 24492 bytes) Out of memory (Needed 24492 bytes) Out of memory (Needed 24492 bytes) Out of memory (Needed 24492 bytes) Out of memory (Needed 24492 bytes) Out of memory (Needed

Re: django, celery and mysql: Lost connection to MySQL server during query

Den 10/10/2010 kl. 17.55 skrev Massimiliano della Rovere: > > * Which process(es) on the server is using 100% CPU time? > directly from htop: > PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command > 544 mader 20 0 969M 953M 1444 R 96.0 47.4 50:09.85 python > ./manage.py

Re: django, celery and mysql: Lost connection to MySQL server during query

On Sun, Oct 10, 2010 at 17:12, Erik Cederstrand wrote: > > * Are you keeping a connection open to MySQL the whole time? I do not know what is the default behaviour of django, but I did not specify any custom option. > * What are the values of your timeout settings in the

Re: django, celery and mysql: Lost connection to MySQL server during query

Den 10/10/2010 kl. 16.34 skrev Massimiliano della Rovere: > Using django 1.2.3 with celery 2.0.3 and django-celery 2.0.3 and mysql > 5.1.41 on kubuntu 10.04, I receive the following error: > OperationalError(2013, 'Lost connection to MySQL server during query'). > > The error oc

django, celery and mysql: Lost connection to MySQL server during query

Using django 1.2.3 with celery 2.0.3 and django-celery 2.0.3 and mysql 5.1.41 on kubuntu 10.04, I receive the following error: OperationalError(2013, 'Lost connection to MySQL server during query'). The error occurs every time the task is executed and seems to be related to the execution time