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.

 
Go Back  dBforums > Database Server Software > Informix > chunk errors

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-15-07, 14:01
artemka artemka is offline
Registered User
 
Join Date: May 2004
Location: New York
Posts: 248
chunk errors

Hi guys, looks like Im facing an issue with disks

online.log is bellow.

everything i read about CLNT_PAM_CAPABLE error points to a bug and i need to upgrade the engine, but what to do with
13:48:06 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
im not sure yet, HP is not reporting any errors according to /var/adm/syslog
or gvdisplay and lvdisplay commands.


the system is not mirrored, if these are disk errors what should i do?
I was thinking about creating an additional dbspace, recreate the tables that live in chunk 18 there and rename the tables in chunk 18 to table_name_old or something so nothing new would get written there.
Is there any way to find out which table lives on pagenum 519153?
Any suggestions?


13:46:17 Environment variable CLNT_PAM_CAPABLE is too long (maximum is -1 char
acters).
13:46:17 File: osenv.c, line: 1839, status: -5.
13:46:17 Environment variable CLNT_PAM_CAPABLE is too long (maximum is -1 chara
cters).
13:46:17 File: osenv.c, line: 1839, status: -5.
13:47:38 Environment variable CLNT_PAM_CAPABLE is too long (maximum is -1 chara
cters).
13:47:38 File: osenv.c, line: 1839, status: -5.
13:47:38 Environment variable CLNT_PAM_CAPABLE is too long (maximum is -1 chara
cters).
13:47:38 File: osenv.c, line: 1839, status: -5.
13:48:06 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
13:48:06 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
13:48:06 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
13:50:29 Checkpoint Completed: duration was 7 seconds.
13:50:29 Checkpoint loguniq 6201, logpos 0x5384080

13:51:53 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
13:51:53 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5
13:51:53 I/O read chunk 18, pagenum 519153, pagecnt 1 --> errno = 5

Last edited by artemka; 05-15-07 at 14:06.
Reply With Quote
  #2 (permalink)  
Old 05-15-07, 17:06
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
get what tables on chunk 18 and what table is page 519153 ...
oncheck -pe

print the page with error...
oncheck -pP 18 519153

about coping the table to another dbspace, is not a bad idea... but you need discover if the problem is your disk devices or not...

sorry my bad english...
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
  #3 (permalink)  
Old 05-15-07, 17:21
artemka artemka is offline
Registered User
 
Join Date: May 2004
Location: New York
Posts: 248
Thank you for your help on identifying the tables.

I created the new dbspace and now copying tables out there.
Looks like it's helping, time will tell.

Cheers

Artem
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On