python - _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10055)") -


i'm getting following error when running python script on 2008 vm running mysql server 5.6 using ajax

traceback (most recent call last):   file "mypythonjob.py", line 22, in <module>     db = mdb.connect('localhost', 'website','servername', 'website')   file "c:\python27\lib\site-packages\mysqldb\__init__.py", line 81, in connect     return connection(*args, **kwargs)   file "c:\python27\lib\site-packages\mysqldb\connections.py", line 187, in __init__     super(connection, self).__init__(*args, **kwargs2) _mysql_exceptions.operationalerror: (2003, "can't connect mysql server on 'localhost' (10055)")

i can watch in resource monitor cpu climbs 100% after 75 seconds @ point mysql.exe has 30 threads , python.exe has 6 threads error kicks out , python.exe terminated , mysql server un reachable 2mins comes on line. 

import os, datetime, pymssql , time, subprocess import mysqldb mdb today = datetime.datetime.now().replace(hour=0, minute=0, second=0, microsecond=0) sixmonth = today - datetime.timedelta(days=180) db = mdb.connect('localhost', 'website','server', 'website')  #values changed post cursor = db.cursor() sql2 = "select 1column mytable 4column '"+str(today)+"'"   #values changed post (query produces 1100 rows) cursor.execute(sql2) data2 = cursor.fetchall() cursor.close() db.close()   row2 in data2:     db = pymssql.connect(host="sqldb",user="username", password="pwd", database="somedatabase")  #values changed post     cursor = db.cursor()     sql3 = "set transaction isolation level read uncommitted; select col1,col2,col3 tbl col1 '%somedata%' , col3 < '"+str(sixmonth)+"' , col2 ='data'"     #values changed post     cursor.execute(sql3)     data3 = cursor.fetchall()     db.commit()     cursor.close()     db.close()     row3 in data3:         db = mdb.connect('localhost', 'website','server', 'website')         cursor = db.cursor()         sql4 = "update mytable set 2column ='"+str(row3[2])+"', 3column ='"+str(row3[1])+"' 4column '"+str(today)+"' , 1column '"+str(row3[0])+"'"      #values changed post (seems finish update @ 575 rows)         cursor.execute(sql4)         data4 = cursor.fetchall()         db.commit()         cursor.close()         db.close()

resolution attempts ran code small 10 row of starting data vs 1100 checked make sure i'm closing connections , db's when i'm done them check mysql log file there nothing changed setting max_allowed_packet in my.ini 32mg 500mg , commented out

thanks looking

added note: if remove set transaction isolation level read uncommitted; second query seems continue run. let go 5 mins , count stopped @ 575 updated , held there.

solved issue, not passing variable first query second killing server results passing bloating line count update.


Comments

Post a Comment

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

from android trying send image class of data, iis webservice. (c#) the problem 400 bad request . the image being encoded base64 . , placed json rest of class elements. my guess base64 not valid inside json. server not understand it. if set string "" , post accepted fine. so question is, how make base64 valid within json array? ( tried url.encode no success). or how should send image android webservice? gson gson = new gson(); string json = gson.tojson(record); // record has param { string base64photo } how big image? i'm pretty sure surpassing iis json size limit (default 4 mb). check http://geekswithblogs.net/frankw/archive/2008/08/05/how-to-configure-maxjsonlength-in-asp.net-ajax-applications.aspx or http://www.webtrenches.com/post.cfm/iis7-file-upload-size-limits good luck!
Read more

javascript - addthis share facebook and google+ url -

i attempting use addthis create simple url shares whichever current page user on when click share button. of right now, have twitter working. when user clicks, able see url populated in tweet box. when user clicks facebook or google+, url doesn't seem show in share box. <ul class="addthis_toolbox addthis_default_style "> <li><a class="addthis_button_facebook"><img src="/img/facebook-social.png" width="20" height="20" border="0" alt="share" /></a></li> <li><a class="addthis_button_twitter"><img src="/img/twitter-social.png" width="20" height="20" border="0" alt="share" /></a></li> <li><a class="addthis_button_google_plusone_share"><img src="/img/google-social.png" width="20" height="20" border="0" alt="s...
Read more

ios - Show keyboard with UITextField in the input accessory view -

i have buttona , when buttona clicked, want keyboard show uitextfield in inputaccessoryview. there way have keyboard show manually , set inputaccessoryview without having uitextfield initially? thanks. you cannot summon keyboard without object can become first responder. there 2 ways work around: subclass uiview , implement uikeyinput protocol in it. example: in .h file: @interface inputobject : uiview<uikeyinput> @property (nonatomic, copy) nsstring *text; @property (nonatomic, strong) uiview *inputaccessoryview; // must override inputaccessoryview , since it's readonly default @end in .m file, implement protocol: - (bool)canbecomefirstresponder { return yes; } - (bool)hastext { return [self.text length]; } - (void)inserttext:(nsstring *)text { nsstring *selftext = self.text ? self.text : @""; self.text = [selftext stringbyappendingstring:text]; [[nsnotificationcenter defaultcenter] postnotificationname:kinputobjec...
Read more