Mysql Error Writing File 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 t
that make connections all over the world. Join today Community Community Home Getting Involved Chat Forum SupportPost installation SOLVED: Keep getting Errcode: 122 - help needed! Posted by modstore on March 31, 2011 at 8:53pm Keep getting this error after a certain amount of time: user warning: Can't create/write to file '/home/tmp/#sql_6e72_0.MYI' (Errcode: 122) ...please see the screen capture for the https://www.virtualmin.com/node/11524 full message. http://imm.io/4HmX - screen capture. I have changed the mysql temp dir to /home/tmp from /tmp, as I thought that may be the problem, but to get things working again, I need to clear out the /tmp dir, and there seems to be nothing in the /home/tmp https://www.drupal.org/node/1112468 dir. Also, when I do df command, only 21% of harddrive is used, so don't know what is causing this. Cheers, Mark. Log in or register to post comments ⋅ Categories: Drupal 6.x Comments SOLVED modstore commented March 31, 2011 at 11:05pm After much searching, it turns out that the limitation was the inode limit on the server: df -i Modified Street Cars -D7 Site Log in or register to post comments News itemsDrupal news Planet Drupal Association news Social media directory Security announcements Jobs Our communityCommunity Getting involved Services, Training & Hosting Groups & Meetups DrupalCon Code of conduct DocumentationDocumentation Drupal 8 docs Drupal 7 docs Developer docs api.drupal.org Drupal code baseDownload & Extend Drupal core Modules Themes Distributions Governance of communityAbout Web accessibility The Drupal Association About Drupal.org Terms of service Privacy policy Drupal is a registered trademark of Dries Buytaert.
as plain text hmmm. I doubt it's disk quota, unless I'm missing something in reading this? [dae51d=ttyp2]4:56pm@thematrix:{/etc/cron.daily}> perror 122 Disk quota exceeded [dae51d=ttyp2]5:49pm@thematrix:{/etc/cron.daily}> quota Disk quotas for user dae51d (uid 518): Filesystem https://lists.mysql.com/mysql/33457 blocks quota limit grace files quota limit grace /dev/hda1 368 100000 900000 27 2000 2500 /dev/hdb1 131337 500000 900000 1348 5000 5100 The image_db is not that big by the way: [dae51d=ttyp2]5:50pm@thematrix:{/var/lib/mysql/image_db}> ll total 140 -rw-rw---- 1 mysql mysql 2565 Mar 28 00:48 AppliesTo_Table.ISD -rw-rw---- 1 mysql mysql 15360 Apr 6 16:54 AppliesTo_Table.ISM -rw-rw---- 1 mysql mysql error mysql 8616 Dec 29 07:07 AppliesTo_Table.frm -rw-rw---- 1 mysql mysql 126 Dec 29 07:15 City_Table.ISD -rw-rw---- 1 mysql mysql 2048 Apr 6 16:54 City_Table.ISM -rw-rw---- 1 mysql mysql 8594 Dec 29 07:15 City_Table.frm -rw-rw---- 1 mysql mysql 33049 Mar 28 00:48 Image_Table.ISD -rw-rw---- 1 mysql mysql 17408 Apr 6 16:54 Image_Table.ISM -rw-rw---- 1 mysql mysql 8808 Jan mysql error writing 8 21:43 Image_Table.frm -rw-rw---- 1 mysql mysql 1044 Jan 11 00:34 Name_Table.ISD -rw-rw---- 1 mysql mysql 2048 Apr 6 16:54 Name_Table.ISM -rw-rw---- 1 mysql mysql 8594 Dec 29 06:54 Name_Table.frm > -----Original Message----- > From: sasha@stripped [mailto:sasha@stripped]On > Behalf Of sasha@stripped > Sent: Thursday, April 06, 2000 2:23 PM > To: Daevid Vincent > Cc: mySQL Database > Subject: Re: ERROR 3: Error writing file './image_db/A-9d9.frm' > (Errcode: 122) > > > Daevid Vincent wrote: > > > > Can someone explain why this ALTER isn't working? > > > > [dae51d=ttyp2]4:22pm@thematrix:{/var/lib/mysql}> mysql -v image_db > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 2521 to server version: 3.22.25-log > > > > Reading history-file /home/dae51d/.mysql_history > > Type 'help' for help. > > > > mysql> ALTER TABLE Image_Table CHANGE column image_name image_name > > VARCHAR(100); > > -------------- > > ALTER TABLE Image_Table CHANGE column image_name image_name VARCHAR(100) > > -------------- > > > > ERR