Mysql Error Writing File Errcode 122
MySQL Errcode: 122 when creating databases after update 14 posts / 0 new Log in or register to post comments Last post #1 Sun, 09/20/2009 - 09:15 Deviation MySQL Errcode: 122 when creating databases after update I've run into a bit of a snag after updating MySQL via Virtualmin. Any time I go to create a table, I get the following error: #3 - Error writing file './DB_NAME/TABLE_NAME.frm' (Errcode: 122) From what I've looked at thus far, I know its a quota issue. The first thing I did was create a new plan with unlimited quotas. I applied that to my virtual server without any luck. So I checked my limits with ulimit. It shows unlimited for mysql, the user account, and root. I'm stuck. Any help would be appreciated. This wasn't an issue before the Virtualmin updates. CentOS 5.2 x64 Virtualmin GPL 3.73 MySQL 5.0.77 Log in or register to post comments #2 Sun, 09/20/2009 - 11:00 andreychek Hrm, well, as you've seen, that error definitely appears to be a quota or space error. Are you sure you have enough space in /var (or specifically, /var/lib/mysql)? Although this doesn't typically happen, you might want to verify that the mysql user doesn't have a quota set on it -- you can verify that by typing "quota -v mysql". Next -- for the group of the Virtual Server you're creating -- what does "quota -g GROUPNAME" show? -Eric Log in or register to post comments #3 Sun, 09/20/2009 - 12:10 Deviation quote -v mysql shows: Disk quotas for user mysql (uid 27): Filesystem blocks quota limit grace files quota limit grace /dev/xvda 101172 0 0 978 0 0 quota -g GROUPNAME shows: Filesystem blocks quota limit grace files quota limit grace /dev/xvda 1752600* 1048576 1048576 131 0 0 If i'm reading that correctly, its showing a 1GB quota? There's 8GB free on the system. Log in or register to post comments #4 Sun, 09/20/2009 - 12:22 andreychek Mmm, yeah, looks like the group for your Virtual Server is using 1.7GB, but the quota is set to 1GB. -Eric Log in or register to post comments #5 Sun, 09/20/2009 - 16:42 (Reply to #4) Deviation So how do I get rid of the quota? I thought creating a new plan with no quota and assigning it to the user would work. Log in or register to post comments #6 Sun, 09/20/2009 - 16:46 andreychek Well, go into Edit Virtual Server -> Qu
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL/Writing file error (Errcode 28) up vote 45 down vote favorite 5 I have the https://www.virtualmin.com/node/11524 following error with one of our web applications - Query3 failed: Error writing file '/tmp/MY1fnqpm' (Errcode: 28) ... INSERT MailList... (removed the rest of the query for security reasons) Any ideas - is this some hard disk space issue on my server? mysql logging share|improve this question edited Jun 3 '15 at 13:37 user1981275 5,94032957 asked Sep 14 '11 at 11:39 Zabs 3,6872581164 2 Is there sufficient disk space available? http://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28 –NDM Sep 14 '11 at 11:43 3 Free up some space on your device. –Ashwin A Sep 14 '11 at 11:45 I had this error pop up today on a device with only 11% used. I rebooted the machine, and it was fine after that, but it would seem that this error can happen even when there is space available. –Elkvis Sep 8 '14 at 13:43 add a comment| 7 Answers 7 active oldest votes up vote 78 down vote accepted Use the perror command: $ perror 28 OS error code 28: No space left on device Unless error codes are different on your system, your file system is full. share|improve this answer answered Sep 14 '11 at 11:42 arnaud576875 52.7k11139153 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 10 down vote We have experienced similar issue, and the problem was MySQL used /tmp directory for its needs (it's default configuration). And /tmp was located on its own partition, that had too few space for big MySQL requests. For more
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MyISAM :: [Errcode: 122] … Can't create/write http://forums.mysql.com/read.php?21,388906,388906 to file '/tmp/#sql_6700_0.MYI' New Topic Advanced Search [Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI' Posted by: Jacques Guiffo () Date: October 06, 2010 01:29AM Hi members For some time now as the users of my multiples sites are growing, I am having this type of error almost everything day mysql error [ ….Can't create/write to file '/tmp/#sql_6700_0.MYI' (Errcode: 122) ] which block all the pages query to continue. NB: I have double check with my server and my VPS plan doesn’t seem to have a storage issue. Type of error message I get: ( ... NOW()) AND a.cid = 1 GROUP mysql error writing BY a.aid ORDER BY a.cton DESC LIMIT 0, 20Can't create/write to file '/tmp/#sql_6700_0.MYI' (Errcode: 122) ) Please can somebody help or advice on this? More information: Operating system: Linux Architecture x86_64: MySQL version 5.0.91-community Apache version: 2.2.16 PHP version: 5.2.9 Thanks and regards Jacques Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views Written By Posted [Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI' 6705 Jacques Guiffo 10/06/2010 01:29AM Re: [Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI' 3062 Rick James 10/10/2010 04:12PM Re: [Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI' 2226 Jacques Guiffo 10/15/2010 06:02AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany