Mysql Error 1030 Got Error 127 From Table Handler
: Got error 127 from table handler 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 Sponsor User Tag List Results 1 to 2 of 2 Thread: MySQL error : Got error 127 from table handler Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Aug 23, 2001,11:57 #1 itsource View Profile View Forum Posts SitePoint Addict Join Date Jun 2001 Location Thailand Posts 369 Mentioned 0 Post(s) Tagged 0 Thread(s) MySQL error : Got error 127 from table handler I just insert new record in mysql, Before add I query view old recode, it work but when insert new record and select * from tablename I have error message, I try to read manual but not found SELECT * FROM staff_profile MySQL said: Got error 127 from table handler Can any body help please? Aug 23, 2001,14:14 #2 itsource View Profile View Forum Posts SitePoint Addict Join Date Jun 2001 Location Thailand Posts 369 Mentioned 0 Post(s) Tagged 0 Thread(s) hey all, I have good news. I can solve my problem. My sql has command check table and repair table If your table has problem and error when you query in database, chcek table will check table and report error and repair table can fix it. for my problem i insert some rows that cause table error and repair command can remove those row already see more information about check and repair table at this http://www.mysql.com/documentation/m...le_maintenance Quick Navigation PHP Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Community Center News & Announcements General Discussions Introductions Talk With The Experts Website Design & Content - Reviews & Critiques Code Reviews Forum Support & Feedback Content Web Content Photography & Audio-visual Media Social Media Design Your Site Getting Started With Web Design Website Design Graphics (X)HTML CSS & Page Layout Accessibility & Usability Program Your Site PHP Developing For Mobile Devices CMS & Wordpress C
plain text I'm running RedHat 7.3 distro with 2.4.18-4smp #1 SMP The table in questions is -rw-r----- 1 mysql mysql 8.9k Jul 26 00:23 hasit.frm -rw-r----- 1 mysql mysql 994M Sep 10 09:59 hasit.MYD -rw-r----- 1 mysql mysql 681M Sep 10 09:59 hasit.MYI my my.cnf option [mysqld] skip-innodb skip-bdb skip-name-resolve skip-locking port=3306 socket=/var/lib/mysql/mysql.sock datadir=/var/lib/mysql # Helps inserts happen much faster set-variable = key_buffer=512M # keep allot more tables in memory set-variable = table_cache=1024 #Increase this value for faster ORDER BY or GROUP BY operations set-variable = sort_buffer=64M #If you do many sequential scans, you may want http://www.sitepoint.com/forums/showthread.php?32061-MySQL-error-Got-error-127-from-table-handler to increase this value set-variable = record_buffer=16M #use for when mysql is doing a check or repair set-variable = myisam_sort_buffer_size=64M set-variable = max_allowed_packet=16M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency (Might only be used for Solaris) set-variable = thread_concurrency=8 set-variable = tmp_table_size=512 set-variable = max_connections=450 set-variable = back_log=20 set-variable = max_connect_errors=400 set-variable = wait_timeout=10 This is a RAID-5 http://lists.mysql.com/mysql/149427 with 128MB ICP Raid Card with 4GB of memory -->-----Original Message----- -->From: Richard Gabriel [mailto:rgabriel@stripped] -->Sent: Wednesday, September 10, 2003 10:32 AM -->To: Dathan Vance Pattishall; mysql@stripped -->Subject: Re: "ERROR 1030: Got error 127 from table handler" --> -->What kernel are you running? --> -->Also, try increasing the max open tables. That might help. --> -->Richard Gabriel -->Director of Technology, -->CoreSense Inc. -->(518) 306-3043 x3951 --> -->----- Original Message ----- -->From: "Dathan Vance Pattishall"
query a certain table, mysql returns error message: "MySQL said: Got error 127 from table handler". Only one table got such an problem. We never touched it before. Anyone have an idear? Thanks! Alex http://forums.westhost.com/archive/index.php/t-6732.html FZ12-13-2003, 06:11 PMThis might help: http://forums.devshed.com/t101141/s3f423285f17bf5511ffdd4f05753da55.html stonix12-13-2003, 06:47 PMI tried repair but got following error message: "error The handler for the table doesn't support check/repair" Alex FZ12-13-2003, 07:27 PMHmm, have you tried using PhpMyAdmin to see if you can browse the records in the thing? Maybe PhpMyAdmin will be able to guide you to a solution... wildjokerdesign12-13-2003, 08:42 PMPhpMyAdmin is reliant on Mod_php being installed and it well check and repair a table mysql error so maybe there is somethng that is installed when Mod_php is installed that handles the check and repair. stonix12-14-2003, 10:24 AMI tried PhpMyAdmin but no use. I placed an emergency ticket but nobody even reviewed it. I am thinking that the only way to resume it is to have westhost restore the table file from their backup tape - they do regular tape backup, do they? labi05-18-2004, 07:24 AMSame problem in my case.:( mysql error 1030 It happened few days ago, and westhost I think restarted mysqld but now again. I also have a table what is unaccessable (status="in use" ). I don't know but this Sql server is a disaster, almost every day is a problem... I already lose data. Or is my script?! I used the same scripts on old westhost server, where never happend anything like this... Hopefully westhost will do something or I have to looking for an other host... labi05-18-2004, 07:38 AMIn my case the "repaire table" command (from phpMyAdmin) did the job, but unfortunately one of the table loose data... Barb5405-19-2004, 09:31 PMHi, Once you get your database fixed up why not "dump" your database every so often just in case? I do this because of past issues with other services. I'm new to WestHost but do they let you set up CronJobs? There could be an answer there as well. I back up my entire website at least weekly and more if there is a lot of activity. HTH, Barb jalal05-20-2004, 01:10 AMYou can also turn on the mysql logging and have a look in the logs to see if there are any strange error messages. And, as Barb suggests, its easy to setup a cron job to backup the database on a regular basis. HTH