RE: ERROR 1030: Got error 127 from table handler

2004-04-22 Thread Bhaskar Borthakur
Wednesday, April 21, 2004 4:45 PM > To: Dathan Vance Pattishall; [EMAIL PROTECTED] > Subject: RE: ERROR 1030: Got error 127 from table handler > > At 04:42 PM 4/21/2004 -0700, Dathan Vance Pattishall wrote: > >There is a delete bug where frequent deletes can cause table corruption

RE: ERROR 1030: Got error 127 from table handler

2004-04-21 Thread Dathan Vance Pattishall
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html > -Original Message- > From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 4:45 PM > To: Dathan Vance Pattishall; [EMAIL PROTECTED] > Subject: RE: ERROR 1030: Got error 127 from table handle

RE: ERROR 1030: Got error 127 from table handler

2004-04-21 Thread Bhaskar Borthakur
At 04:42 PM 4/21/2004 -0700, Dathan Vance Pattishall wrote: There is a delete bug where frequent deletes can cause table corruption. Upgrade to 4.0.18 -- I believe its been fixed by now. Is there a bug fix list that I can lookup on the net to make sure that this error has been fixed? thanks bha

RE: ERROR 1030: Got error 127 from table handler

2004-04-21 Thread Dathan Vance Pattishall
There is a delete bug where frequent deletes can cause table corruption. Upgrade to 4.0.18 -- I believe its been fixed by now. > -Original Message- > From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 1:30 PM > To: [EMAIL PROTECTED] > Subject: ERROR 1030: G

Re: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Jeremy Zawodny
On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote: > Well I don't feel that 4.0.x is mature enough for my environment quite > yet, although some replication features are actually needed (2 threads > are better then one). > > I might do a small deploy for some search system an

RE: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Dathan Vance Pattishall
y, September 10, 2003 10:48 AM -->To: Dathan Vance Pattishall -->Cc: [EMAIL PROTECTED] -->Subject: Re: "ERROR 1030: Got error 127 from table handler" --> -->On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: -->> -->> /usr/local/mysql/bi

Re: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Richard Gabriel
<[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 1:47 PM Subject: Re: "ERROR 1030: Got error 127 from table handler" > On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: > > > > /usr/local/mysql/bin/perror 127 >

Re: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Jeremy Zawodny
On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: > > /usr/local/mysql/bin/perror 127 > Error code 127: Unknown error 127 > 127 = Record-file is crashed > > I've been getting this allot lately from mysql-3.23.54-57. > > > Things that are not the cause: > - mySQL has

Re: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread colbey
Are you running linux and is it SMP? Kernel version plz.. On Wed, 10 Sep 2003, Dathan Vance Pattishall wrote: > > /usr/local/mysql/bin/perror 127 > Error code 127: Unknown error 127 > 127 = Record-file is crashed > > I've been getting this allot lately from mysql-3.23.54-57. > > > Things that

RE: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Dathan Vance Pattishall
-->- Original Message - -->From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> -->To: "'Tom Roos'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> -->Sent: Wednesday, September 10, 2003 1:28 PM -->Subject: RE: "ERROR 1030: Got er

Re: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Richard Gabriel
;" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 1:28 PM Subject: RE: "ERROR 1030: Got error 127 from table handler" > FilesystemSize Used Avail Use% Mounted on > /dev/sda5 97G 9.0G 82G 10% > > Plent

RE: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Dathan Vance Pattishall
IL PROTECTED] -->Subject: RE: "ERROR 1030: Got error 127 from table handler" --> -->hows u're disk space? --> -->-Original Message- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: 10 September 2003 19:11 -->To: [EMAIL PROTECTED] -->

RE: "ERROR 1030: Got error 127 from table handler"

2003-09-10 Thread Tom Roos
hows u're disk space? -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 19:11 To: [EMAIL PROTECTED] Subject: "ERROR 1030: Got error 127 from table handler" /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-f

Re: ERROR 1030: Got error 127 from table handler

2002-06-18 Thread Victoria Reznichenko
tl, Tuesday, June 18, 2002, 2:40:36 PM, you wrote: t> I do select: t> select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN ('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) ) AND (HOUR(data) <'19' AND HOUR(data) t> >='8') ) AND !(@data IN t> ('

Re: ERROR 1030: Got error 127 from table handler

2002-06-18 Thread Veysel Harun Sahin
It seems that your table has been crashed. Try to check and repair your table. tl wrote: >Hello MySQL, > > > >>>I do select: >>> >>> >select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN >('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')

Re: ERROR 1030: Got error 127 from table handler

2002-05-20 Thread Egor Egorov
Carter, Monday, May 20, 2002, 4:31:07 PM, you wrote: C> Can anyone shed some light on this? Have found that others have C> run into this (via Google) but no resolution and no hits at C> www.mysql.com. C> A count(*) query returns fine but trying to select the rows C> fails (see log snippet below)

RE: ERROR 1030: Got error 127 from table handler

2002-05-20 Thread Weaver, Walt
According to perror, error 127 = Record-file is crashed. This is a symptom of a corrupted table. Check out the MySQL manual, 4.4.6.9, How to Repair Tables. Specifically, try running myisamchk on the table. --Walt Weaver Bozeman, Montana -Original Message- From: Carter, Robert L (MN65)

RE: ERROR 1030: Got error 127 from table handler / Optimize Table

2002-05-16 Thread Dave Watkinson
restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running HTH Dave -Original Message- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: ERRO