Re: sequence skips 30 values, how?

Tom Lane wrote:
> Geoffrey <esoteric@3times25.net> writes:
>> We are trying to track down an issue with our PostgreSQL application.
>> We are running PostgreSQL 7.4.13 on Red Hat Enterprise ES 3.
>
>> We have a situation where the postgres backend process drops core and
>> dies.
>
> Please provide a stack trace from that coredump ...
>
>             regards, tom lane

It follows.  Note, the references to /usr/local/pcm170/... are from a
3rd party application we have built into our backend.  I'm sure I know
what I'll hear regarding that issue. :)  We are in the process up
upgrading to a newer version of this product.  stack trace follows:

#0  0x001968a4 in vfprintf () from /lib/tls/libc.so.6
#1  0x001b7d24 in vsnprintf () from /lib/tls/libc.so.6
#2  0x0019d0a4 in snprintf () from /lib/tls/libc.so.6
#3  0x002d29c2 in pcm_getmiles_s () from /esc/pgrnd/prog/libpcmiler.so
#4  0x081082c4 in ExecMakeFunctionResult ()
#5  0x08109e1a in ExecEvalExpr ()
#6  0x08107f5d in init_fcache ()
#7  0x08108062 in ExecMakeFunctionResult ()
#8  0x08109e1a in ExecEvalExpr ()
#9  0x0810a089 in ExecEvalExprSwitchContext ()
#10 0x002c7d30 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#11 0x002c6b00 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#12 0x002c42a8 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#13 0x002c40c9 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#14 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#15 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#16 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#17 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#18 0x002c3e25 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#19 0x002c3071 in plpgsql_exec_function () from /usr/lib/pgsql/plpgsql.so
#20 0x002c0004 in plpgsql_call_handler () from /usr/lib/pgsql/plpgsql.so
#21 0x081082c4 in ExecMakeFunctionResult ()
#22 0x08109e1a in ExecEvalExpr ()
---Type <return> to continue, or q <return> to quit---
#23 0x0810ab54 in ExecCleanTargetListLength ()
#24 0x0810adba in ExecProject ()
#25 0x0810ae88 in ExecScan ()
#26 0x081105d9 in ExecIndexScan ()
#27 0x08106d70 in ExecProcNode ()
#28 0x081055fd in ExecEndPlan ()
#29 0x081049d8 in ExecutorRun ()
#30 0x08118794 in spi_printtup ()
#31 0x08118686 in spi_printtup ()
#32 0x08116b62 in SPI_execp ()
#33 0x002c598f in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#34 0x002c4193 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#35 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#36 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#37 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#38 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#39 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#40 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#41 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#42 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#43 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#44 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#45 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
---Type <return> to continue, or q <return> to quit---
#46 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#47 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#48 0x002c4502 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#49 0x002c40da in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#50 0x002c4015 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#51 0x002c3e25 in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#52 0x002c378a in plpgsql_exec_trigger () from /usr/lib/pgsql/plpgsql.so
#53 0x002c0063 in plpgsql_call_handler () from /usr/lib/pgsql/plpgsql.so
#54 0x080f283e in FreeTriggerDesc ()
#55 0x080f37b7 in ExecARUpdateTriggers ()
#56 0x080f3bbe in ExecARUpdateTriggers ()
#57 0x080f3d1f in DeferredTriggerEndQuery ()
#58 0x08179d08 in pg_plan_queries ()
#59 0x08178904 in pg_plan_queries ()
#60 0x0817b1c1 in PostgresMain ()
#61 0x08154c40 in ClosePostmasterPorts ()
#62 0x08154633 in ClosePostmasterPorts ()
#63 0x08152b98 in PostmasterMain ()
#64 0x0815225e in PostmasterMain ()
#65 0x08121f63 in main ()

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin