IDS Forum

Re: Panic analysis

Posted By: FRANK
Date: Wednesday, 24 June 2015, at 10:27 a.m.

In Response To: Re: Panic analysis (Art Kagel)

Thank Art, Jeff and Mark for the info!

We do not do partition/fragmentation.
We are heavily using the following sysmaster tables to monitor space usage
daily,
sysdbspaces
syschunks
sysextents

Seems difficult to avoid using them.

By the way, What does IFX_NOPENPS=4096 mean? Any possible side effect?

Thanks
Frank

On Fri, Jun 19, 2015 at 12:57 PM, Art Kagel <art.kagel@gmail.com> wrote:

> There are actually three bugs that cause memory allocation storms, the one
> Jeff mentioned and two others that mostly affect servers with many
> thousands of partitions (tables, indexes, partitions of tables or indexes)
> and occur when you try to access sysmaster tables that query the partition
> header pages (so systabnames, sysptnhdr, sysactptnhdr, sysextents, etc.).
> They are all fixed in v12.10.FC5 and the latest fixpacks for v11.70 and
> 11.50. Ran into all three at around the same time this past fall.
>
> Temporary work around: avoid querying sysmaster data about tables.
> Dbschema, myschema, dostats, some OAT sensors, and other utilities are some
> things that can trigger this depending on what options you pass in.
>
> Art
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> 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, Jun 19, 2015 at 10:47 AM, Jeff Filippi <iiug@itdataconsulting.com>
> wrote:
>
> > I had some customers have the same thing happen with 12.10FC4, there is a
> > bug.
> >
> > Either upgrade to 12.10FC5 or try setting the environment variable
> > "IFX_NOPENPS=4096;export IFX_NOPENPS"
> >
> > This helped the issue with my customers.
> >
> > Thanks, Jeff
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > FRANK
> > Sent: Friday, June 19, 2015 10:32 AM
> > To: ids@iiug.org
> > Subject: Panic analysis [35298]
> >
> > Folks,
> >
> > IDS 12.10 FC4, Linux 6.
> >
> > The following log is the only info we have about the crash ( no other
> info
> > dumped ) You can see it was struggling to add lot memories segments
> before
> > Panic ....
> > The Panic was a also VERY curious one with some unexpected process
> > terminated ...
> >
> > What are your comments ? What might be the culprit ? ....
> >
> > Thanks
> > Frank
> >
> > ...........................................
> > 21:10:26 Dynamically allocated new virtual shared memory segment (size
> > 2097152KB)
> > 21:10:26 Memory sizes:resident:114076 KB, virtual:84996324 KB, no
> SHMTOTAL
> > limit
> > 21:10:28 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:28 Memory sizes:resident:114076 KB, virtual:89190628 KB, no
> SHMTOTAL
> > limit
> > 21:10:30 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:30 Memory sizes:resident:114076 KB, virtual:93384932 KB, no
> SHMTOTAL
> > limit
> > 21:10:33 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:33 Memory sizes:resident:114076 KB, virtual:97579236 KB, no
> SHMTOTAL
> > limit
> > 21:10:36 Logical Log 279454 Complete, timestamp: 0x5e24c0a1.
> > 21:10:36 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:36 Memory sizes:resident:114076 KB, virtual:101773540 KB, no
> SHMTOTAL
> > limit
> > 21:10:38 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:38 Memory sizes:resident:114076 KB, virtual:105967844 KB, no
> SHMTOTAL
> > limit
> > 21:10:41 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:41 Memory sizes:resident:114076 KB, virtual:110162148 KB, no
> SHMTOTAL
> > limit
> > 21:10:44 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:44 Memory sizes:resident:114076 KB, virtual:114356452 KB, no
> SHMTOTAL
> > limit
> > 21:10:46 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:46 Memory sizes:resident:114076 KB, virtual:118550756 KB, no
> SHMTOTAL
> > limit
> > 21:10:49 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:49 Memory sizes:resident:114076 KB, virtual:122745060 KB, no
> SHMTOTAL
> > limit
> > 21:10:52 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:52 Memory sizes:resident:114076 KB, virtual:126939364 KB, no
> SHMTOTAL
> > limit
> > 21:10:55 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:10:55 Memory sizes:resident:114076 KB, virtual:131133668 KB, no
> SHMTOTAL
> > limit
> > 21:12:29 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:12:29 Memory sizes:resident:114076 KB, virtual:135327972 KB, no
> SHMTOTAL
> > limit
> > 21:12:51 Dynamically allocated new virtual shared memory segment (size
> > 4194304KB)
> > 21:12:51 Memory sizes:resident:114076 KB, virtual:139522276 KB, no
> SHMTOTAL
> > limit
> > 21:12:56 Fatal error in ADM VP at mt.c:14304
> > 21:12:56 Unexpected virtual processor termination: pid = 9812, signal 9
> > received.
> > 21:12:57 PANIC: Attempting to bring system down
> >
> > --001a11c119e20474cb0518e09ffe
> >
> >
> >
> ****************************************************************************
> > ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a1140727a36dabc0518e1d019
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a1135d7966824820519444fa6

Messages In This Thread

• Panic analysis
  FRANK -- Friday, 19 June 2015, at 11:31 a.m.
  • Re: Panic analysis
    Mark Jamison -- Friday, 19 June 2015, at 11:37 a.m.
  • RE: Panic analysis
    Jeff Filippi -- Friday, 19 June 2015, at 11:47 a.m.
    • Re: Panic analysis
      Art Kagel -- Friday, 19 June 2015, at 12:57 p.m.
      • Re: Panic analysis
        MARK SCRANTON -- Monday, 22 June 2015, at 8:35 a.m.
        • Re: Panic analysis
          Art Kagel -- Monday, 22 June 2015, at 9:03 a.m.
      • Re: Panic analysis
        FRANK -- Wednesday, 24 June 2015, at 10:27 a.m.
        • RE: Panic analysis
          Jeff Filippi -- Wednesday, 24 June 2015, at 10:46 a.m.
        • Re: Panic analysis
          Art Kagel -- Wednesday, 24 June 2015, at 11:23 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.