IC50516: ASSERT FAIL: DECRREFCOUNT() RETURNS 768 EROR

APAR status

• Closed as program error.

Error description

• ==== State: Opened by: ssajip on 24 August 2006 18:47:42 ====
  15:59:51  IBM Informix Extended Parallel Server Version 8.51.F
     Software Serial Number RDS#N000000
  15:59:51  Assert Failed: Unexpected condition(-768) in file
  ddutil.c, line 2915
  15:59:51   Who:Session(20, ssajip@ramsay, 2232, 818589136)
  ?? Thread(110, sqlexec_1.20, 0x30c7ade8, 1)
  ??File: sqerr.c Line: 355
  15:59:51   Results: Contact Product Support
  15:59:51   Action:
  15:59:51  Thread globals for thread: 110 sqlexec_1.20
   scb?: 0x0000000031cb5b88  (scb_t)
   rstcb?: 0x0000000030c7ade8  (rstcb_t)
   TRANSP : 0x0000000030caadd0  (rtx_t)
  15:59:51  Stack for thread: 110 sqlexec_1.20
   base: 0x0000000032124028
    len:? 66048
     pc: 0x0000000100430928
    tos: 0x00000000321315f1
  state: running
     vp: 1
  0x100430928 oninit :: afstack
  0x10042ed24 oninit :: afhandler
  0x10042da28 oninit :: affail_interface
  0x10042c800 oninit :: ev_alarms_interface
  0x100535de0 oninit :: fsqerr
  0x1004c10ac oninit :: decrrefcount
  0x10054df60 oninit :: rmdiclink
  0x10054c478 oninit :: cleanup_cb_tables
  0x10054d21c oninit :: closecb
  0x10054ad9c oninit :: close_cb_subtree
  0x10054a880 oninit :: closesdb
  0x10054a0cc oninit :: releasesdb
  0x1009f10c0 oninit :: sq_release
  0x100a15284 oninit :: sqmain
  0x1003ea468 oninit :: startup
  [002] 15:42:28?On-Line Mode
  [001] 15:59:51?Unexpected condition(-768) in file ddutil.c,
  line 2915
  [001] 15:59:51?Assert Failed: Unexpected condition(-768) in
  file ddutil.c, line 2915
  [001] 15:59:51?IBM Informix Extended Parallel Server Version
  8.51.F
  [001] 15:59:51? Who:Session(20, ssajip@ramsay, 2232,
  818589136)
  ?? Thread(110, sqlexec_1.20, 0x30c7ade8, 1)
  ??File: sqerr.c Line: 355
  [001] 15:59:51? Results: Contact Product Support
  [001] 15:59:51? Action:
  [001] 15:59:51?stack trace for pid 2101 written to
  /tmp/af.4562f67
  [001] 15:59:51? See Also: /tmp/af.4562f67
  Reproduction:
  Load file can be generated using this program:
  ===============================================
  #include <stdio.h>
  main()
  {
    FILE *fp;
    int i,j,k;
    char Line[100];
    fp = (FILE *) fopen("load.in", "w+");
    if (fp == NULL)
    {
      printf("Cannot open file\n");
      exit(-1);
    }
    for (i=1; i <= 100; i++)
    {
      sprintf(Line, "%d | %s|\n", i, "ABC");
      j = strlen(Line);
      fwrite(Line,j, 1, fp);
    }
    fclose(fp);
  }
  ===============================================
  Dbaccess script:
  drop database test;
  create database test;
  create raw table response_node_dim_eval
    (
      response_node_key serial not null,
      response_node_type char(3) not null,
      response_node char(80) not null
    );
  create raw table response_node_dim
    (
      response_node_key integer not null,
      response_node_type char(3) not null,
      response_node char(80) not null
    );
  load from load.in insert into response_node_dim_eval;
  load from load.in insert into response_node_dim;
  -- This query causes the 768 error
  unload to /dev/null
  select *
  from
  (
      select (select count(response_node_key) sequence from
  ?    response_node_dim_eval x
  ?    where x.response_node_key <= y.response_node_key)
  sequence
      from response_node_dim_eval as y
  );
  ===============================================
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users
  ****************************************************************
  PROBLEM DESCRIPTION:
  15:59:51  IBM Informix Extended Parallel Server Version 8.51.FC1
   Software Serial Number RDS#N000000
  15:59:51  Assert Failed: Unexpected condition(-768) in file
  ddutil.c, line 2915
  15:59:51   Who:Session(20, ssajip@ramsay, 2232, 818589136)
  ?? Thread(110, sqlexec_1.20, 0x30c7ade8, 1)
  ??File: sqerr.c Line: 355
  15:59:51   Results: Contact Product Support
  15:59:51   Action:
  15:59:51  Thread globals for thread: 110 sqlexec_1.20
   scb?: 0x0000000031cb5b88  (scb_t)
   rstcb?: 0x0000000030c7ade8  (rstcb_t)
   TRANSP : 0x0000000030caadd0  (rtx_t)
  15:59:51  Stack for thread: 110 sqlexec_1.20
   base: 0x0000000032124028
    len:? 66048
     pc: 0x0000000100430928
    tos: 0x00000000321315f1
  state: running
     vp: 1
  0x100430928 oninit :: afstack
  0x10042ed24 oninit :: afhandler
  0x10042da28 oninit :: affail_interface
  0x10042c800 oninit :: ev_alarms_interface
  0x100535de0 oninit :: fsqerr
  0x1004c10ac oninit :: decrrefcount
  0x10054df60 oninit :: rmdiclink
  0x10054c478 oninit :: cleanup_cb_tables
  0x10054d21c oninit :: closecb
  0x10054ad9c oninit :: close_cb_subtree
  0x10054a880 oninit :: closesdb
  0x10054a0cc oninit :: releasesdb
  0x1009f10c0 oninit :: sq_release
  0x100a15284 oninit :: sqmain
  0x1003ea468 oninit :: startup
  [002] 15:42:28?On-Line Mode
  [001] 15:59:51?Unexpected condition(-768) in file ddutil.c,
  line 2915
  [001] 15:59:51?Assert Failed: Unexpected condition(-768) in
  file ddutil.c, line 2915
  [001] 15:59:51?IBM Informix Extended Parallel Server Version
  8.51.F
  [001] 15:59:51? Who:Session(20, ssajip@ramsay, 2232,
  818589136)
  ?? Thread(110, sqlexec_1.20, 0x30c7ade8, 1)
  ??File: sqerr.c Line: 355
  [001] 15:59:51? Results: Contact Product Support
  [001] 15:59:51? Action:
  [001] 15:59:51?stack trace for pid 2101 written to
  /tmp/af.4562f67
  [001] 15:59:51? See Also: /tmp/af.4562f67
  ****************************************************************
  RECOMMENDATION:
  Upgrade to XPS 8.51.xC2 or above.
  ****************************************************************
  

Problem conclusion

• Problem first fixed in XPS 8.51.xC2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX EXT XP

• Fixed component ID

  5724C1900

Applicable component levels

• R851 PSY

     UP

• R850 PSY

     UP

• R840 PSY

     UP