Re: segmentation fault postgres 9.3.5 core dump perlu related ? - Mailing list pgsql-general

It has been some time since we have seen this problem.
See earlier  message on this subject/thread  for the suspect  plperl function executing
at the time of the core.

Someone on our development team  suggested it might relate to some build options of perl.
In particular MULTIPLICITY or THREADS . We can have this perl fx executing on
two different connections/sessions at the same time. I intend to write some test scripts
that will increase the possibility of this occurrence to see if it makes the problem
more reproducible.

I'll update again after completing some testing. Meanwhile other thoughts and/or
confirmation that these build options should be enabled are welcome.

Thanks

Dave Day

I believe below is an valid stack dump:

Core was generated by `postgres'.
Program terminated with signal 11, Segmentation fault.
(gdb) bt
#0  0x000000080bfa50a3 in Perl_fbm_instr () from /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18
#1  0x000000080c00ff93 in Perl_re_intuit_start () from /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18
#2  0x000000080bfc27a2 in Perl_pp_match () from /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18
#3  0x000000080bfbe6a3 in Perl_runops_standard () from /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18
#4  0x000000080bf57bd8 in Perl_call_sv () from /usr/local/lib/perl5/5.18/mach/CORE/libperl.so.5.18
#5  0x000000080bcfb7c7 in plperl_call_perl_func () from /usr/local/lib/postgresql/plperl.so
#6  0x000000080bcf83c2 in plperl_call_handler () from /usr/local/lib/postgresql/plperl.so
#7  0x000000000057611f in ExecMakeTableFunctionResult ()
#8  0x000000000058b6c7 in ExecFunctionScan ()
#9  0x000000000057bab2 in ExecScan ()
#10 0x00000000005756b8 in ExecProcNode ()
#11 0x00000000005876a8 in ExecLimit ()
#12 0x0000000000575771 in ExecProcNode ()
#13 0x0000000000573630 in standard_ExecutorRun ()
#14 0x0000000000593294 in SPI_execute ()
#15 0x000000000059379c in SPI_execute_plan_with_paramlist ()
#16 0x00000008024f19bc in plpgsql_subxact_cb () from /usr/local/lib/postgresql/plpgsql.so
#17 0x00000008024ee909 in plpgsql_subxact_cb () from /usr/local/lib/postgresql/plpgsql.so
#18 0x00000008024eaf3b in plpgsql_exec_function () from /usr/local/lib/postgresql/plpgsql.so
#19 0x00000008024ea243 in plpgsql_exec_function () from /usr/local/lib/postgresql/plpgsql.so
#20 0x00000008024e6551 in plpgsql_call_handler () from /usr/local/lib/postgresql/plpgsql.so
#21 0x000000000057611f in ExecMakeTableFunctionResult ()
#22 0x000000000058b6c7 in ExecFunctionScan ()
#23 0x000000000057bab2 in ExecScan ()
#24 0x00000000005756b8 in ExecProcNode ()
#25 0x0000000000573630 in standard_ExecutorRun ()
#26 0x0000000000645b0a in PortalRun ()
#27 0x0000000000645719 in PortalRun ()
#28 0x00000000006438ea in PostgresMain ()
#29 0x00000000005ff267 in PostmasterMain ()
#30 0x00000000005a31ba in main ()

pkg info perl5
perl5-5.18.4_11
Name           : perl5
Version        : 5.18.4_11
Installed on   : Mon Jan  5 09:28:05 EST 2015
Origin         : lang/perl5.18
Architecture   : freebsd:10:x86:64
Prefix         : /usr/local
Categories     : perl5 lang devel
Licenses       : GPLv1 or ART10
Maintainer     : perl@FreeBSD.org
WWW            : http://www.perl.org/
Comment        : Practical Extraction and Report Language
Options        :
    DEBUG          : off
    GDBM           : off
    MULTIPLICITY   : off
    PERL_64BITINT  : on
    PERL_MALLOC    : off
    PTHREAD        : on
    SITECUSTOMIZE  : off
    THREADS        : off
    USE_PERL       : on
Shared Libs provided:
    libperl.so.5.18
Annotations    :
    cpe            : cpe:2.3:a:perl:perl:5.18.4:::::freebsd10:x64:11
    repo_type      : binary
    repository     : redcom
Flat size      : 49.2MiB
Description    :
Perl is a language that combines some of the features of C, sed, awk and
shell.  See the manual page for more hype.  There are also many books
published by O'Reilly & Assoc.  See pod/perlbook.pod for more
information.