Error 1053 08s01 At Line 1 Server Shutdown In Progress
Reporter: Todd Farmer (OCA) Email Updates: Status: Closed Impact on me: None Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical) Version:5.0.37 OS:Microsoft Windows Assigned to: Tatiana Azundris Nuernberg Triage: Triaged: D4 (Minor) View Add Comment Files Developer Edit Submission View Progress Log Contributions [27 Apr 2007 17:56] Todd Farmer Description: When a query is waiting on a lock, pressing Control-C eventually generates "ERROR 1053 (08S01): Server shutdown in progress" message. This is not accurate - the server is never shut down. In fact, the connection is never terminated - the same CONNECTION_ID() is observed before and after the message. How to repeat: Using two clients, execute the following: [client #1] CREATE TABLE l (i INT PRIMARY KEY) ENGINE = InnoDB; INSERT INTO l VALUES (1); BEGIN; SELECT * FROM l WHERE i = 1 FOR UPDATE; [client #2] SELECT CONNECTION_ID(); BEGIN; SELECT * FROM l WHERE i = 1 FOR UPDATE; [control - c and wait for error and new prompt] SELECT CONNECTION_ID(); Suggested fix: Return control to client immediately after Control-C and do not generate error. [7 Jan 2008 8:39] Tatiana Azundris Nuernberg On control-C, the client sends "KILL /*!50000 QUERY */ threadID" to the server. Meaning that on < 5.0, we'd kill the connection, and on 5.0+, just the offending query (which is why CONNECTION_ID() remains the same on 5.0+ -- the connection is never dropped, just the current query is cancelled in medias res). That is correct and intended behaviour. In this ticket's example, this is what presumably happens next: On the server, a flag is set on the thread executing the query in question, asking the thread to abort processing the query ASAP: thd->killed= KILL_QUERY (ER_QUERY_INTERRUPTED) In records.cc:rr_quick(), the reading is interrupted, and (info->)thd->killed is seen. This results in ER_SERVER_SHUTDOWN being raised / sent to the client, regardless of whether the server is really going down, and regardless of whether even the connexion (and not just the query) is terminated. If this theory proves to be correct, then the server behaves correct and as intended, except that it sends a rather misleading error-message. That it sends one at all on cancel is correct behaviour, the exact phrasing however is unfortu
MySQL #1053 - Server shutdown in progress??? The SitePoint Forums have moved. You can now find them here. This forum is now closed to new posts, but you can browse existing content. You can find out more information about the move and how to open a new account (if necessary) here. If you get stuck you can get support by emailing forums@sitepoint.com If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. SitePoint http://bugs.mysql.com/28141 Sponsor User Tag List Results 1 to 6 of 6 Thread: #1053 - Server shutdown in progress??? Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 15, 2007,05:45 #1 Raskolnikov View Profile View Forum Posts SitePoint Guru Join Date Jul 2003 Location USA Posts 606 Mentioned 0 Post(s) Tagged 0 Thread(s) #1053 - Server shutdown in progress??? Using this query: SELECT p.first, p.last, http://www.sitepoint.com/forums/showthread.php?478751-1053-Server-shutdown-in-progress p.city, p.state, p.member_id, m.corr_type, m.member_corr_id FROM members p LEFT OUTER JOIN member_corrections m ON p.member_id = m.member_id AND m.processed='0' WHERE p.club_id = '245' AND p.memLevel='1' ORDER BY p.last i get this error: #1053 - Server shutdown in progress Any ideas why this might happen. It should produce roughly 250 results. Running MySql 5.0.27 Ras May 15, 2007,06:11 #2 longneck View Profile View Forum Posts reads the ********* Crier Join Date Feb 2004 Location Tampa, FL (US) Posts 9,854 Mentioned 1 Post(s) Tagged 0 Thread(s) is it only that query that produces that error? May 15, 2007,06:21 #3 Raskolnikov View Profile View Forum Posts SitePoint Guru Join Date Jul 2003 Location USA Posts 606 Mentioned 0 Post(s) Tagged 0 Thread(s) yup..... Even if i change the value of club_id......quering a different club. I get the same error. May 15, 2007,06:44 #4 Raskolnikov View Profile View Forum Posts SitePoint Guru Join Date Jul 2003 Location USA Posts 606 Mentioned 0 Post(s) Tagged 0 Thread(s) now i got #2006 - MySQL server has gone away ???? where the Hell did it go? vacation? to lunch? did it just get fed up and decide to walk out? what kind of an error message is that.....holy crap i could come up with better terminology. Ras May 15, 2007,11:29 #5 longneck View Profile View Forum Posts reads the *
links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish. Starts at just $1 https://forums.digitalpoint.com/threads/mysql-error-server-shutdown-in-progress.9727/ per CPM or $0.10 per CPC. mysql error: Server shutdown in progress Discussion https://bugs.launchpad.net/bugs/599790 in 'Site & Server Administration' started by Fishing Forum, Feb 16, 2005. 0 Fishing Forum Active Member Messages: 537 Likes Received: 21 Best Answers: 0 Trophy Points: 60 #1 mysql error: Server shutdown in progress mysql error number: 1053 Got a problem with my VB board giving this error a few times to error 1053 day Any advice and what would cause this ?? Thank you for your time Fishing Forum, Feb 16, 2005 IP digitalpoint Overlord of no one Staff Messages: 37,666 Likes Received: 2,527 Best Answers: 447 Trophy Points: 710 Digital Goods: 29 #2 I've only seen that when a shutdown was in progress. Either a reboot of the server, or restart of the mysqld process. If you error 1053 08s01 can see the MySQL Runtime Variables (easiest way is with phpmyadmin), you can see how long the database server has been running. If you contact me privately for support, I'll direct you to the correct support forum. Save time and go there first. Ingress Intel digitalpoint, Feb 16, 2005 IP Fishing Forum Active Member Messages: 537 Likes Received: 21 Best Answers: 0 Trophy Points: 60 #3 Cheers Will have a look Fishing Forum, Feb 16, 2005 IP (You must log in or sign up to reply here.) Show Ignored Content Log in with Facebook Your name or email address: Do you already have an account? No, create an account now. Yes, my password is: Forgot your password? Stay logged in Digital Point Home Forums > Development > Site & Server Administration > Log in to view your Analytics, AdSense & PayPal stats Home Forums Search Forums Recent Posts Spy Search EnginesGoogleAdSenseGuidelines / CompliancePlacement / Reviews / ExamplesReporting & StatsPaymentsAdWordsAnalyticsGoogle+SitemapsGoogle APIShoppingYahooPublisher NetworkSearch MarketingYahoo APIBingBing AdsAll Other Search EnginesDirectoriesSolicitations & AnnouncementsODP / DMOZBusiness & MarketingGeneral BusinessGeneral MarketingSearch Engine OptimizationKeywordsMicrodataPayment ProcessingPayPalSocial NetworksFacebookFacebook APITwitterGoogle+Link DevelopmentLegal IssuesDomain NamesAppraisalsCopywritingArticle MarketplaceeCommercePay Per Click AdvertisingDigital Point AdsGoogle AdWordsYahoo Search MarketingBing AdsAffiliate ProgramsAffiliat
Status Importance Assigned to Milestone mysql-dfsg-5.1 (Ubuntu) Edit Fix Released Low Unassigned Edit You need to log in to change this bug's status. Affecting: mysql-dfsg-5.1 (Ubuntu) Filed here by: Sander Johansen When: 2010-06-29 Confirmed: 2010-08-20 Started work: 2010-08-20 Completed: 2010-08-20 Target Distribution Baltix BOSS Juju Charms Collection Elbuntu Guadalinex Guadalinex Edu Kiwi Linux nUbuntu PLD Linux Tilix tuXlab Ubuntu Ubuntu Linaro Evaluation Build Ubuntu RTM Package (Find…) Project (Find…) Status Importance Fix Released Low Assigned to Nobody Me Comment on this change (optional) Email me about changes to this bug report Also affects project (?) Also affects distribution/package Nominate for series Bug Description When enabling events with "SET GLOBAL event_scheduler = ON; " I get a flood of error messages when I stop mysql. Here is what's happening: /etc/init.d/mysql restart * Stopping MySQL database server mysqld ERROR 1053 (08S01) at line 1: Server shutdown in progress ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ......... ..... ... To stop it, I have to do "killall -9 xargs" from another shell. This is happening on Ubuntu 9.10 with mysql 5.1.37-1ubuntu5.4 I managed to enable event scheduler in my.cnf with setting event_scheduler = 1 . Then the bug permanently will occour every time I stop mysql. I've heard that the mysql init script is diffrent from the ubuntu/debian version. That might be the reason of this bug. ProblemType: Bug Architecture: amd64 Date: Tue Jun 29 13:02:34 2010 DistroRelease: Ubuntu 9.10 Logs.var.log.kern.log: MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['Provisioning', 'debian-5.1.flag', 'mysql_upgrade_info', 'DB30000693', 'ib_logfile0', 'DB13453812', 'lost@002bfound', 'mysql', 'DB13453817', 'ibdata1', 'ib_logfile1', 'test'] Package: mysql-server-5.1 5.1.37-1ubuntu5.4 ProcEnviron: PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-19.56-server SourcePackage: mysql-dfsg-5.1 Uname: Linux 2.6.31-19-server x86_64 mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2010-06-28T16:36:44.028478 Tags: amd64 apport-bug Edit Tag help Sander Johan