Oninit cdi / Archive
Talk to an expert →

fragment estimate_compression Partition is not in

Posted in 2014

Topics: Platform-Specific Issues

MATTI — — source: IIUG Forums & Mailing Lists

Hi, We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version 12.10.FC3E I get lots of this kind of error messages, where could i start finding reason for them? 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243371 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243371') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243372 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243372') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243401 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243401') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243414 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243414') failed T. Matti Jaatinen

↪ replying to MATTI
Art Kagel — — source: IIUG Forums & Mailing Lists

Matti: First thing to try is to run an oncheck -cDI on each of the complaining partnums. If you want to stop the messages, then disable the compression estimator task in sysadmin:ph_task, Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 8, 2014 at 6:36 AM, MATTI JAATINEN <matti.jaatinen@norelco.fi> wrote: > Hi, > > We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version > 12.10.FC3E > > I get lots of this kind of error messages, where could i start finding > reason > for them? > 15:36:05 fragment estimate_compression Partition is not in a consistent > state > for partnumber 5243371 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243371') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent > state > for partnumber 5243372 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243372') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent > state > for partnumber 5243401 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243401') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent > state > for partnumber 5243414 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243414') failed > > T. Matti Jaatinen > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3472a0f1dfc05001c2107

↪ replying to MATTI
JACQUES — — source: IIUG Forums & Mailing Lists

Original post: Hi, We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version 12.10.FC3E I get lots of this kind of error messages, where could i start finding reason for them? 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243371 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243371') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243372 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243372') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243401 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243401') failed 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243414 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression ','5243414') failed T. Matti Jaatinen Response: If you want to stop the messages, you can check Art's post. The message itself sounds worse then it actually is. In the code it looks like we are checking some flags on the partition, and if we see those flags, we report this message (the flags being roughly things like is the partition flagged as being dropped, is the partition a temp table usr or system, or is it being cleaned by btcleaner). Jacques Renaut IBM Informix Advanced Support APD Team

↪ replying to JACQUES
John Miller — — source: IIUG Forums & Mailing Lists

I would check to see if those partitions are related to timeseries tables or containers. I believe this could be the issue. The message is completely harmless. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 08/08/2014 05:28:14 AM: > From: Jacques Renaut/Lenexa/IBM@IBMUS > To: ids@iiug.org, > Date: 08/08/2014 05:28 AM > Subject: Re: fragment estimate_compression Partition is.... [33487] > Sent by: ids-bounces@iiug.org > > Original post: > > Hi, > > We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version > 12.10.FC3E > > I get lots of this kind of error messages, where could i start finding reason > for them? > 15:36:05 fragment estimate_compression Partition is not in a consistent state > for partnumber 5243371 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243371') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent state > for partnumber 5243372 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243372') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent state > for partnumber 5243401 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243401') failed > 15:36:05 fragment estimate_compression Partition is not in a consistent state > for partnumber 5243414 > 15:36:05 ERROR: admin_fragment_command('fragment estimate_compression > ','5243414') failed > > T. Matti Jaatinen > > Response: > > If you want to stop the messages, you can check Art's post. The > message itself > sounds worse then it actually is. In the code it looks like we are checking > some flags on the partition, and if we see those flags, we report > this message > (the flags being roughly things like is the partition flagged as being > dropped, is the partition a temp table usr or system, or is it being cleaned > by btcleaner). > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >