BADLY NEED HELP

2001-03-24 Thread Nuno Ferreira 


-rw-rw   1 mysqlmysql  100916 Mar 16 17:09 imp_addr.ISD
-rw-rw   1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw   1 mysqlmysql8648 Mar  9 11:06 imp_addr.frm



 I've been reading all the archieve files about a error i get when
 trying to do any sql thing with a table.

 check this out ...
 mysql select * from imp_addr;
 ERROR 1030: Got error 127 from table handler

   than  i did what everyone says to do with a problem like this
 ...

 isamchk -o imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223

 isamchk -r imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223

  and tried all the recovering methos available.

 When i use the "-e" option with the "-r" the output is this ...

 # isamchk -e imp_addr.ISM
 Checking ISAM file: imp_addr.ISM
 Data records:1223   Deleted blocks:   0
 - check file-size
 - check delete-chain
 - check index reference
 - check records and index references
 [root@thor horde]# isamchk -e -r -f imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223
 Found block with too small length at 297; Skipped
 Found block with too small length at 1558; Skipped
 Found block with too small length at 1955; Skipped
 Found link that points at 1342181235 (outside data file) at 2254
 Found block with too small length at 2504; Skipped
 Found link that points at 1157628996 (outside data file) at 3601
 Found link that points at 1258418244 (outside data file) at 3607
 Found block with too small length at 4543; Skipped
 Found block with too small length at 5053; Skipped
 Found link that points at 1744831599 (outside data file) at 5644
 Found link that points at 1107423343 (outside data file) at 5650
 Found block with too small length at 5713; Skipped
Found block with too small length at 5719; Skipped
 Found block with too small length at 6190; Skipped
 Found block with too small length at 7072; Skipped
 Found block with too small length at 7214; Skipped
 Found block with too small length at 7293; Skipped
 Found block with too small length at 7377; Skipped
 Found block with too small length at 7880; Skipped
 Found block with too small length at 8892; Skipped
 Found block with too small length at 9286; Skipped
 Found block with too small length at 9370; Skipped
 Found block with too small length at 9439; Skipped
 Found block with too small length at 9835; Skipped
 Found block with too small length at 10649; Skipped
 Found link that points at 1660946017 (outside data file) at 10788
 Found block with too small length at 11290; Skipped
 Found block with too small length at 12131; Skipped
 Found block with too small length at 12137; Skipped
 Found block with too small length at 12844; Skipped
 Found block with too small length at 13878; Skipped
 Found block with too small length at 14391; Skipped
 Found block with too small length at 14475; Skipped
 Found block with too small length at 15776; Skipped
 Found block with too small length at 15927; Skipped
 Found block with too small length at 16010; Skipped
 Found block with too small length at 16080; Skipped
 Found block with too small length at 16203; Skipped
 Found block with too small length at 16209; Skipped

  and it goes on and on for like more 20 lines or so ..

 Can anyone help me ??? i really need this table recovered ...

 Thanks

---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Table handler

2001-03-21 Thread Nuno Ferreira 



No .. not really that big (the table)

-rw-rw   1 mysqlmysql  100916 Mar 16 17:09 imp_addr.ISD
-rw-rw   1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw   1 mysqlmysql8648 Mar  9 11:06 imp_addr.frm

100K the ISD part ... anyway i have tried to " imp_addr.ISD"
to put it 0 lenght ... but no luck :(((


ANYONE ???

 1'st post


 I've been reading all the archieve files about a error i get when
 trying to do any sql thing with a table.

 check this out ...
 mysql select * from imp_addr;
 ERROR 1030: Got error 127 from table handler

   than  i did what everyone says to do with a problem like this
 ...

 isamchk -o imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223

 isamchk -r imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223

  and tried all the recovering methos available.

 When i use the "-e" option with the "-r" the output is this ...

 # isamchk -e imp_addr.ISM
 Checking ISAM file: imp_addr.ISM
 Data records:1223   Deleted blocks:   0
 - check file-size
 - check delete-chain
 - check index reference
 - check records and index references
 [root@thor horde]# isamchk -e -r -f imp_addr.ISM
 - recovering ISAM-table 'imp_addr.ISM'
 Data records: 1223
 Found block with too small length at 297; Skipped
 Found block with too small length at 1558; Skipped
 Found block with too small length at 1955; Skipped
 Found link that points at 1342181235 (outside data file) at 2254
 Found block with too small length at 2504; Skipped
 Found link that points at 1157628996 (outside data file) at 3601
 Found link that points at 1258418244 (outside data file) at 3607
 Found block with too small length at 4543; Skipped
 Found block with too small length at 5053; Skipped
 Found link that points at 1744831599 (outside data file) at 5644
 Found link that points at 1107423343 (outside data file) at 5650
 Found block with too small length at 5713; Skipped
 Found block with too small length at 5719; Skipped
 Found block with too small length at 6190; Skipped
 Found block with too small length at 7072; Skipped
 Found block with too small length at 7214; Skipped
 Found block with too small length at 7293; Skipped
 Found block with too small length at 7377; Skipped
 Found block with too small length at 7880; Skipped
 Found block with too small length at 8892; Skipped
 Found block with too small length at 9286; Skipped
 Found block with too small length at 9370; Skipped
 Found block with too small length at 9439; Skipped
 Found block with too small length at 9835; Skipped
 Found block with too small length at 10649; Skipped
 Found link that points at 1660946017 (outside data file) at 10788
 Found block with too small length at 11290; Skipped
 Found block with too small length at 12131; Skipped
 Found block with too small length at 12137; Skipped
 Found block with too small length at 12844; Skipped
 Found block with too small length at 13878; Skipped
 Found block with too small length at 14391; Skipped
 Found block with too small length at 14475; Skipped
 Found block with too small length at 15776; Skipped
 Found block with too small length at 15927; Skipped
 Found block with too small length at 16010; Skipped
 Found block with too small length at 16080; Skipped
 Found block with too small length at 16203; Skipped
 Found block with too small length at 16209; Skipped

  and it goes on and on for like more 20 lines or so ..

 Can anyone help me ??? i really need this table recovered ...

 Thanks


---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: table handler prob

2001-03-20 Thread Nuno Ferreira 



Hi again 

No .. not really that big (the table)

-rw-rw   1 mysqlmysql  100916 Mar 16 17:09 imp_addr.ISD
-rw-rw   1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw   1 mysqlmysql8648 Mar  9 11:06 imp_addr.frm

100K the ISD part ... anyway i have tried to " imp_addr.ISD"
to put it 0 lenght ... but no luck :(((


ANYONE ???

On Fri, 16 Mar 2001, Gerald L. Clark wrote:

 Nuno Ferreira wrote:
 
  Hi again.
 
  I've been reading all the archieve files about a error i get when
  trying to do any sql thing with a table.
 
  check this out ...
  mysql select * from imp_addr;
  ERROR 1030: Got error 127 from table handler
 
    than  i did what everyone says to do with a problem like this
  ...
 
  isamchk -o imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
 
  isamchk -r imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
 
   and tried all the recovering methos available.
 
  When i use the "-e" option with the "-r" the output is this ...
 
  # isamchk -e imp_addr.ISM
  Checking ISAM file: imp_addr.ISM
  Data records:1223   Deleted blocks:   0
  - check file-size
  - check delete-chain
  - check index reference
  - check records and index references
  [root@thor horde]# isamchk -e -r -f imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
  Found block with too small length at 297; Skipped
  Found block with too small length at 1558; Skipped
  Found block with too small length at 1955; Skipped
  Found link that points at 1342181235 (outside data file) at 2254
  Found block with too small length at 2504; Skipped
  Found link that points at 1157628996 (outside data file) at 3601
  Found link that points at 1258418244 (outside data file) at 3607
  Found block with too small length at 4543; Skipped
  Found block with too small length at 5053; Skipped
  Found link that points at 1744831599 (outside data file) at 5644
  Found link that points at 1107423343 (outside data file) at 5650
  Found block with too small length at 5713; Skipped
  Found block with too small length at 5719; Skipped
  Found block with too small length at 6190; Skipped
  Found block with too small length at 7072; Skipped
  Found block with too small length at 7214; Skipped
  Found block with too small length at 7293; Skipped
  Found block with too small length at 7377; Skipped
  Found block with too small length at 7880; Skipped
  Found block with too small length at 8892; Skipped
  Found block with too small length at 9286; Skipped
  Found block with too small length at 9370; Skipped
  Found block with too small length at 9439; Skipped
  Found block with too small length at 9835; Skipped
  Found block with too small length at 10649; Skipped
  Found link that points at 1660946017 (outside data file) at 10788
  Found block with too small length at 11290; Skipped
  Found block with too small length at 12131; Skipped
  Found block with too small length at 12137; Skipped
  Found block with too small length at 12844; Skipped
  Found block with too small length at 13878; Skipped
  Found block with too small length at 14391; Skipped
  Found block with too small length at 14475; Skipped
  Found block with too small length at 15776; Skipped
  Found block with too small length at 15927; Skipped
  Found block with too small length at 16010; Skipped
  Found block with too small length at 16080; Skipped
  Found block with too small length at 16203; Skipped
  Found block with too small length at 16209; Skipped
 
   and it goes on and on for like more 20 lines or so ..
 
  Can anyone help me ??? i really need this table recovered ...
 
  Thanks
 
  --


 Looks to me like you have exceded the 2G File size limit.

 You need Myisam tables, and a filesystem that supports files larger than
 2G.

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-- 
---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: table handler prob

2001-03-18 Thread Nuno Ferreira 



Hi again 

No .. not really that big (the table)

-rw-rw   1 mysqlmysql  100916 Mar 16 17:09 imp_addr.ISD
-rw-rw   1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw   1 mysqlmysql8648 Mar  9 11:06 imp_addr.frm

100K the ISD part ... anyway i have tried to " imp_addr.ISD"
to put it 0 lenght ... but no luck :(((

On Fri, 16 Mar 2001, Gerald L. Clark wrote:

 Nuno Ferreira wrote:
 
  Hi again.
 
  I've been reading all the archieve files about a error i get when
  trying to do any sql thing with a table.
 
  check this out ...
  mysql select * from imp_addr;
  ERROR 1030: Got error 127 from table handler
 
    than  i did what everyone says to do with a problem like this
  ...
 
  isamchk -o imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
 
  isamchk -r imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
 
   and tried all the recovering methos available.
 
  When i use the "-e" option with the "-r" the output is this ...
 
  # isamchk -e imp_addr.ISM
  Checking ISAM file: imp_addr.ISM
  Data records:1223   Deleted blocks:   0
  - check file-size
  - check delete-chain
  - check index reference
  - check records and index references
  [root@thor horde]# isamchk -e -r -f imp_addr.ISM
  - recovering ISAM-table 'imp_addr.ISM'
  Data records: 1223
  Found block with too small length at 297; Skipped
  Found block with too small length at 1558; Skipped
  Found block with too small length at 1955; Skipped
  Found link that points at 1342181235 (outside data file) at 2254
  Found block with too small length at 2504; Skipped
  Found link that points at 1157628996 (outside data file) at 3601
  Found link that points at 1258418244 (outside data file) at 3607
  Found block with too small length at 4543; Skipped
  Found block with too small length at 5053; Skipped
  Found link that points at 1744831599 (outside data file) at 5644
  Found link that points at 1107423343 (outside data file) at 5650
  Found block with too small length at 5713; Skipped
  Found block with too small length at 5719; Skipped
  Found block with too small length at 6190; Skipped
  Found block with too small length at 7072; Skipped
  Found block with too small length at 7214; Skipped
  Found block with too small length at 7293; Skipped
  Found block with too small length at 7377; Skipped
  Found block with too small length at 7880; Skipped
  Found block with too small length at 8892; Skipped
  Found block with too small length at 9286; Skipped
  Found block with too small length at 9370; Skipped
  Found block with too small length at 9439; Skipped
  Found block with too small length at 9835; Skipped
  Found block with too small length at 10649; Skipped
  Found link that points at 1660946017 (outside data file) at 10788
  Found block with too small length at 11290; Skipped
  Found block with too small length at 12131; Skipped
  Found block with too small length at 12137; Skipped
  Found block with too small length at 12844; Skipped
  Found block with too small length at 13878; Skipped
  Found block with too small length at 14391; Skipped
  Found block with too small length at 14475; Skipped
  Found block with too small length at 15776; Skipped
  Found block with too small length at 15927; Skipped
  Found block with too small length at 16010; Skipped
  Found block with too small length at 16080; Skipped
  Found block with too small length at 16203; Skipped
  Found block with too small length at 16209; Skipped
 
   and it goes on and on for like more 20 lines or so ..
 
  Can anyone help me ??? i really need this table recovered ...
 
  Thanks
 
  --


 Looks to me like you have exceded the 2G File size limit.

 You need Myisam tables, and a filesystem that supports files larger than
 2G.

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-- 
---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problems with mysql table

2001-03-15 Thread Nuno Ferreira 


Hi there

I have a problem with one mysql table and i don't know how to
solve it .. the table has some important stuff.

when i make a select this is what happens

mysql select * from imp_addr;
ERROR 1030: Got error 127 from table handler
mysql 

and isamchk

isamchk imp_addr.ISM
Checking ISAM file: imp_addr.ISM
Data records:1223   Deleted blocks:   0
- check file-size
- check delete-chain
- check index reference
- check record links

Can anyone help me on this ???

Thanks :)

-- 
Nuno Ferreira AKA |rider
http://rider.lusoweb.pt
mailto:[EMAIL PROTECTED]
  
http://www.lusoweb.pt
mailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: problems with mysql table

2001-03-15 Thread Nuno Ferreira 


# isamchk  -a -d -e -f -i -l -o imp_addr.ISM

ISAM file: imp_addr.ISM
Data records:  1223  Deleted blocks:  0
Recordlength:25
Record format: Packed

table description:
Key Start Len Index   Type

User time 0.00, System time 0.00
Maximum resident set size 0, Integral resident set size 0
Non physical pagefaults 16, Physical pagefaults 51, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Vouluntary context switches 0, Invouluntary context switches 0


- Anymore available STRONG options i can use ??? cause i think
that ones are about all ... and still no good luck :(

regards



On Fri, 16 Mar 2001, Quentin Bennett wrote:

 Hi,

 Try some of the more aggressive fixing options on isamchk - see the manual
 for details.

 Quentin

 -Original Message-
 From: Nuno Ferreira [mailto:[EMAIL PROTECTED]]
 Sent: Friday, 16 March 2001 10:39 a.m.
 To: [EMAIL PROTECTED]
 Subject: problems with mysql table



   Hi there

   I have a problem with one mysql table and i don't know how to
 solve it .. the table has some important stuff.

   when i make a select this is what happens

 mysql select * from imp_addr;
 ERROR 1030: Got error 127 from table handler
 mysql

 and isamchk

 isamchk imp_addr.ISM
 Checking ISAM file: imp_addr.ISM
 Data records:1223   Deleted blocks:   0
 - check file-size
 - check delete-chain
 - check index reference
 - check record links

   Can anyone help me on this ???

   Thanks :)



-- 
---
Nuno Ferreira
mailto:[EMAIL PROTECTED]
http://www.lusoweb.pt
---


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php