Back To Programming / Scripting / Coding Forum

Error Renaming MySQL Table During ALTER TABLE

  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post June 22nd, 2011, 6:41 pm

I'm at a bit of a loss what this error means. My best guess is that it's a permission issue somewhere, perhaps a garbage collection issue, maybe MySQL is leaving behind a bunch of temp files. This is the result of a cron job that runs every day.

Code: [ Select ]
Error on rename of './dbname/table_name@002dwp.MYI' to './dbname/#sql2-1a97-12c684.MYI' (Errcode: 2)


Here's the query that produces the error.

Code: [ Select ]
$sql = 'ALTER TABLE table_name ORDER BY insert_order';
Strong with this one, the sudo is.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post June 22nd, 2011, 6:41 pm

  • demonmaestro
  • Gold Member
  • Gold Member
  • User avatar
  • Joined: Jun 21, 2006
  • Posts: 476
  • Loc: Conroe, Texas
  • Status: Offline

Post June 22nd, 2011, 7:03 pm

looks like a permission....
Thanks, Josh --DemonMaestro
www.LilNetwork.com
Fun Website www.ShoutsCloud.com
  • Bogey
  • Bogey
  • Genius
  • User avatar
  • Joined: Jul 14, 2005
  • Posts: 8211
  • Loc: USA
  • Status: Offline

Post June 23rd, 2011, 12:06 am

This error seems to be very similar to the problem you are having...

A google search for MySQL Errorcode: 2 talks about creating/writing to file.

perror - The "Explain Error Codes" Utility

Hope this at least leads you in the right direction.
"Bring forth therefore fruits meet for repentance:" Matthew 3:8

Page 1 of 1

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: Kurthead+1 and 116 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.