[
https://issues.apache.org/jira/browse/MADLIB-1007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhang Guang Zhou updated MADLIB-1007:
-------------------------------------
Description:
Greenplum crashed when running:
postgres=# SELECT
postgres-# madlib.relative_error(
postgres(# madlib.array_scalar_add(ARRAY[0.8, 9.5, 2.6]::float8[],
2.2::float8),
postgres(# ARRAY[3.0, 11.7, 4.8]::float8[]) ;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Greenplum version:
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.3devel (Greenplum Database 4.3.99.00 build dev) compiled on Jun
17 2016 17:07:42 (with assert checking)
(1 row)
Madlib version is 1.9.0 installed with madpack.
The core stack is:
Core was generated by `postgres: port 15432, guangzhou.zgz postgres [local]
con6 [local] cmd3 SELECT '.
Program terminated with signal 11, Segmentation fault.
#0 0x000000372e80f3cb in raise () from /lib64/libpthread.so.0
Missing separate debuginfos, use: debuginfo-install
audit-libs-2.1.3-3.1.alios6.x86_64 bzip2-libs-1.0.5-7.1.alios6.x86_64
cyrus-sasl-lib-2.1.23-13.1.alios6.x86_64 glibc-2.12-1.80.2.alios6.x86_64
keyutils-libs-1.4-4.el6.x86_64 krb5-libs-1.9-22.1.alios6.x86_64
libcom_err-1.42-367.el6.x86_64 libcurl-7.19.7-26.1.alios6.2.x86_64
libgcc-4.4.6-3.2.alios6.x86_64 libidn-1.18-2.1.alios6.x86_64
libselinux-2.0.94-5.2.1.alios6.x86_64 libstdc++-4.4.6-3.2.alios6.x86_64
libxml2-2.7.6-4.1.alios6.x86_64 nspr-4.8.8-3.1.alios6.x86_64
nss-3.12.10-16.1.alios6.x86_64 nss-softokn-freebl-3.12.9-11.1.alios6.x86_64
nss-util-3.12.10-2.1.alios6.x86_64 openldap-2.4.23-20.3.alios6.x86_64
openssl-1.0.1e-42.alios6.4.x86_64 pam-1.1.1-10.1.alios6.x86_64
tops-inner-aegis-sqa-1.0.75-269763.alios6.x86_64 zlib-1.2.3-29.el6.x86_64
(gdb) bt
#0 0x000000372e80f3cb in raise () from /lib64/libpthread.so.0
#1 0x00000000009c9b23 in StandardHandlerForSigillSigsegvSigbus_OnMainThread
(processName=0xd38b3b "Master process", postgres_signal_arg=11) at elog.c:4567
#2 0x00000000008c5e69 in CdbProgramErrorHandler (postgres_signal_arg=11) at
postgres.c:3413
#3 <signal handler called>
#4 0x000000372e531a7f in __strlen_sse42 () from /lib64/libc.so.6
#5 0x00000000004b10c3 in hashname (fcinfo=0x7fffcf78ccd0) at hashfunc.c:138
#6 0x00000000009cc1ec in DirectFunctionCall1 (func=0x4b1097 <hashname>,
arg1=0) at fmgr.c:1005
#7 0x0000000000996c33 in CatalogCacheComputeHashValue (cache=0x2ca94b8,
nkeys=2, cur_skey=0x7fffcf78d110) at catcache.c:195
#8 0x0000000000997fd4 in SearchCatCache (cache=0x2ca94b8, v1=261507, v2=0,
v3=0, v4=0) at catcache.c:1055
#9 0x00000000009a2e44 in SearchSysCache (cacheId=32, key1=261507, key2=0,
key3=0, key4=0) at syscache.c:604
#10 0x00007f0c8ab12992 in madlib::dbconnector::postgres::(anonymous
namespace)::madlib_SearchSysCache1(int, long) () from
/usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
#11 0x00007f0c8ab19e49 in
madlib::dbconnector::postgres::SystemInformation::functionInformation(unsigned
int) () from
/usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
#12 0x00007f0c8ae52797 in long
madlib::dbconnector::postgres::UDF::call<madlib::modules::linalg::dist_norm2>(FunctionCallInfoData*)
() from /usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
#13 0x00000000006e120b in ExecMakeFunctionResult (fcache=0x2dbdc60,
econtext=0x2dbeb20, isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:1755
#14 0x00000000006e1efb in ExecEvalFunc (fcache=0x2dbdc60, econtext=0x2dbeb20,
isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:2206
#15 0x00000000006e757c in ExecEvalExprSwitchContext (expression=0x2dbdc60,
econtext=0x2dbeb20, isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:4655
#16 0x000000000083035a in evaluate_expr (expr=0x2d70730, result_type=701) at
clauses.c:3341
#17 0x000000000082f878 in evaluate_function (funcid=261507, result_type=701,
args=0x2d705c0, func_tuple=0x7f0c8b1ceba8, context=0x7fffcf790350) at
clauses.c:2947
#18 0x000000000082f5e1 in simplify_function (funcid=261507, result_type=701,
args=0x2d705c0, allow_inline=1 '\001', context=0x7fffcf790350) at clauses.c:2803
#19 0x000000000082d53a in eval_const_expressions_mutator (node=0x2d6fed8,
context=0x7fffcf790350) at clauses.c:1744
#20 0x00000000008326b6 in expression_tree_mutator (node=0x2d6fe38,
mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
clauses.c:3956
#21 0x000000000082d650 in eval_const_expressions_mutator (node=0x2d6fdc0,
context=0x7fffcf790350) at clauses.c:1774
#22 0x000000000082ffee in inline_function (funcid=262664, result_type=701,
args=0x2d6f700, pcqCtx=0x2d45af0, func_tuple=0x7f0c8b1ce3e0,
context=0x7fffcf790350) at clauses.c:3213
#23 0x000000000082f63a in simplify_function (funcid=262664, result_type=701,
args=0x2d6f700, allow_inline=1 '\001', context=0x7fffcf790350) at clauses.c:2813
#24 0x000000000082d53a in eval_const_expressions_mutator (node=0x2d6db78,
context=0x7fffcf790350) at clauses.c:1744
#25 0x0000000000832599 in expression_tree_mutator (node=0x2d6db00,
mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
clauses.c:3920
#26 0x000000000082f0a4 in eval_const_expressions_mutator (node=0x2d6db00,
context=0x7fffcf790350) at clauses.c:2506
#27 0x00000000008326b6 in expression_tree_mutator (node=0x2d6da60,
mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
clauses.c:3956
#28 0x000000000082f0a4 in eval_const_expressions_mutator (node=0x2d6da60,
context=0x7fffcf790350) at clauses.c:2506
#29 0x000000000082d1dc in eval_const_expressions (root=0x2d6e9a8,
node=0x2d6da60) at clauses.c:1630
#30 0x000000000080556b in preprocess_expression (root=0x2d6e9a8,
expr=0x2d6da60, kind=1) at planner.c:928
#31 0x0000000000804e8c in subquery_planner (glob=0x2d40f20, parse=0x2d6d8d0,
parent_root=0x2d6d490, tuple_fraction=0, subroot=0x7fffcf7904b0,
config=0x2d6e930) at planner.c:668
#32 0x000000000080f8cb in make_subplan (root=0x2d6d490,
orig_subquery=0x2d6cdd8, subLinkType=EXPR_SUBLINK, testexpr=0x0, isTopQual=0
'\000') at subselect.c:428
#33 0x0000000000810812 in process_sublinks_mutator (node=0x2d6d740,
context=0x7fffcf790a20) at subselect.c:946
#34 0x0000000000832599 in expression_tree_mutator (node=0x2d6d6c8,
mutator=0x81077b <process_sublinks_mutator>, context=0x7fffcf790a20) at
clauses.c:3920
#35 0x0000000000810a0c in process_sublinks_mutator (node=0x2d6d6c8,
context=0x7fffcf790f30) at subselect.c:1013
#36 0x00000000008326b6 in expression_tree_mutator (node=0x2d6d800,
mutator=0x81077b <process_sublinks_mutator>, context=0x7fffcf790f30) at
clauses.c:3956
#37 0x0000000000810a0c in process_sublinks_mutator (node=0x2d6d800,
context=0x7fffcf790fc0) at subselect.c:1013
#38 0x0000000000810779 in SS_process_sublinks (root=0x2d6d490, expr=0x2d6d800,
isQual=0 '\000') at subselect.c:919
#39 0x00000000008055b2 in preprocess_expression (root=0x2d6d490,
expr=0x2d6d800, kind=1) at planner.c:946
#40 0x0000000000804e8c in subquery_planner (glob=0x2d40f20, parse=0x2d6d170,
parent_root=0x0, tuple_fraction=0, subroot=0x7fffcf791110, config=0x2d6d418) at
planner.c:668
#41 0x000000000080454d in standard_planner (parse=0x2d6d170, cursorOptions=0,
boundParams=0x0) at planner.c:396
#42 0x0000000000804269 in planner (parse=0x2d45298, cursorOptions=0,
boundParams=0x0) at planner.c:296
#43 0x00000000008c16d1 in pg_plan_query (querytree=0x2d45298, boundParams=0x0)
at postgres.c:811
#44 0x00000000008c17d3 in pg_plan_queries (querytrees=0x2d8ab30,
boundParams=0x0, needSnapshot=0 '\000') at postgres.c:884
#45 0x00000000008c2f18 in exec_simple_query (query_string=0x2d40638 "SELECT\n
madlib.relative_error(\n madlib.array_scalar_add(ARRAY[0.8, 9.5,
2.6]::float8[], 2.2::float8),\n ARRAY[3.0, 11.7, 4.8]::float8[]) ;",
seqServerHost=0x0, seqServerPort=-1) at postgres.c:1659
#46 0x00000000008c7929 in PostgresMain (argc=1, argv=0x2c4e5c0,
dbname=0x2c4e2e0 "postgres", username=0x2c41238 "guangzhou.zgz") at
postgres.c:4654
#47 0x000000000085f51a in BackendRun (port=0x2c4c090) at postmaster.c:7026
#48 0x000000000085ebf8 in BackendStartup (port=0x2c4c090) at postmaster.c:6713
#49 0x0000000000857199 in ServerLoop () at postmaster.c:2464
#50 0x0000000000855aa1 in PostmasterMain (argc=18, argv=0x2c18030) at
postmaster.c:1540
#51 0x000000000077a937 in main (argc=18, argv=0x2c18030) at main.c:206
(gdb)
was:
Greenplum crashed when running:
postgres=# SELECT
postgres-# madlib.relative_error(
postgres(# madlib.array_scalar_add(ARRAY[0.8, 9.5, 2.6]::float8[],
2.2::float8),
postgres(# ARRAY[3.0, 11.7, 4.8]::float8[]) ;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Greenplum version:
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.3devel (Greenplum Database 4.3.99.00 build dev) compiled on Jun
17 2016 17:07:42 (with assert checking)
(1 row)
Madlib version is 1.9.0 installed with madpack.
> crash is hit when calling the madlib.relative_error function in Greenplum
> -------------------------------------------------------------------------
>
> Key: MADLIB-1007
> URL: https://issues.apache.org/jira/browse/MADLIB-1007
> Project: Apache MADlib
> Issue Type: Bug
> Components: Module: Utilities
> Reporter: Zhang Guang Zhou
>
> Greenplum crashed when running:
> postgres=# SELECT
> postgres-# madlib.relative_error(
> postgres(# madlib.array_scalar_add(ARRAY[0.8, 9.5, 2.6]::float8[],
> 2.2::float8),
> postgres(# ARRAY[3.0, 11.7, 4.8]::float8[]) ;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> Greenplum version:
> postgres=# select version();
> version
> ----------------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.3devel (Greenplum Database 4.3.99.00 build dev) compiled on Jun
> 17 2016 17:07:42 (with assert checking)
> (1 row)
> Madlib version is 1.9.0 installed with madpack.
> The core stack is:
> Core was generated by `postgres: port 15432, guangzhou.zgz postgres [local]
> con6 [local] cmd3 SELECT '.
> Program terminated with signal 11, Segmentation fault.
> #0 0x000000372e80f3cb in raise () from /lib64/libpthread.so.0
> Missing separate debuginfos, use: debuginfo-install
> audit-libs-2.1.3-3.1.alios6.x86_64 bzip2-libs-1.0.5-7.1.alios6.x86_64
> cyrus-sasl-lib-2.1.23-13.1.alios6.x86_64 glibc-2.12-1.80.2.alios6.x86_64
> keyutils-libs-1.4-4.el6.x86_64 krb5-libs-1.9-22.1.alios6.x86_64
> libcom_err-1.42-367.el6.x86_64 libcurl-7.19.7-26.1.alios6.2.x86_64
> libgcc-4.4.6-3.2.alios6.x86_64 libidn-1.18-2.1.alios6.x86_64
> libselinux-2.0.94-5.2.1.alios6.x86_64 libstdc++-4.4.6-3.2.alios6.x86_64
> libxml2-2.7.6-4.1.alios6.x86_64 nspr-4.8.8-3.1.alios6.x86_64
> nss-3.12.10-16.1.alios6.x86_64 nss-softokn-freebl-3.12.9-11.1.alios6.x86_64
> nss-util-3.12.10-2.1.alios6.x86_64 openldap-2.4.23-20.3.alios6.x86_64
> openssl-1.0.1e-42.alios6.4.x86_64 pam-1.1.1-10.1.alios6.x86_64
> tops-inner-aegis-sqa-1.0.75-269763.alios6.x86_64 zlib-1.2.3-29.el6.x86_64
> (gdb) bt
> #0 0x000000372e80f3cb in raise () from /lib64/libpthread.so.0
> #1 0x00000000009c9b23 in StandardHandlerForSigillSigsegvSigbus_OnMainThread
> (processName=0xd38b3b "Master process", postgres_signal_arg=11) at elog.c:4567
> #2 0x00000000008c5e69 in CdbProgramErrorHandler (postgres_signal_arg=11) at
> postgres.c:3413
> #3 <signal handler called>
> #4 0x000000372e531a7f in __strlen_sse42 () from /lib64/libc.so.6
> #5 0x00000000004b10c3 in hashname (fcinfo=0x7fffcf78ccd0) at hashfunc.c:138
> #6 0x00000000009cc1ec in DirectFunctionCall1 (func=0x4b1097 <hashname>,
> arg1=0) at fmgr.c:1005
> #7 0x0000000000996c33 in CatalogCacheComputeHashValue (cache=0x2ca94b8,
> nkeys=2, cur_skey=0x7fffcf78d110) at catcache.c:195
> #8 0x0000000000997fd4 in SearchCatCache (cache=0x2ca94b8, v1=261507, v2=0,
> v3=0, v4=0) at catcache.c:1055
> #9 0x00000000009a2e44 in SearchSysCache (cacheId=32, key1=261507, key2=0,
> key3=0, key4=0) at syscache.c:604
> #10 0x00007f0c8ab12992 in madlib::dbconnector::postgres::(anonymous
> namespace)::madlib_SearchSysCache1(int, long) () from
> /usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
> #11 0x00007f0c8ab19e49 in
> madlib::dbconnector::postgres::SystemInformation::functionInformation(unsigned
> int) () from
> /usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
> #12 0x00007f0c8ae52797 in long
> madlib::dbconnector::postgres::UDF::call<madlib::modules::linalg::dist_norm2>(FunctionCallInfoData*)
> () from
> /usr/local/madlib/Versions/1.9/ports/greenplum/4.3ORCA/lib/libmadlib.so
> #13 0x00000000006e120b in ExecMakeFunctionResult (fcache=0x2dbdc60,
> econtext=0x2dbeb20, isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:1755
> #14 0x00000000006e1efb in ExecEvalFunc (fcache=0x2dbdc60, econtext=0x2dbeb20,
> isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:2206
> #15 0x00000000006e757c in ExecEvalExprSwitchContext (expression=0x2dbdc60,
> econtext=0x2dbeb20, isNull=0x7fffcf78e43f "", isDone=0x0) at execQual.c:4655
> #16 0x000000000083035a in evaluate_expr (expr=0x2d70730, result_type=701) at
> clauses.c:3341
> #17 0x000000000082f878 in evaluate_function (funcid=261507, result_type=701,
> args=0x2d705c0, func_tuple=0x7f0c8b1ceba8, context=0x7fffcf790350) at
> clauses.c:2947
> #18 0x000000000082f5e1 in simplify_function (funcid=261507, result_type=701,
> args=0x2d705c0, allow_inline=1 '\001', context=0x7fffcf790350) at
> clauses.c:2803
> #19 0x000000000082d53a in eval_const_expressions_mutator (node=0x2d6fed8,
> context=0x7fffcf790350) at clauses.c:1744
> #20 0x00000000008326b6 in expression_tree_mutator (node=0x2d6fe38,
> mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
> clauses.c:3956
> #21 0x000000000082d650 in eval_const_expressions_mutator (node=0x2d6fdc0,
> context=0x7fffcf790350) at clauses.c:1774
> #22 0x000000000082ffee in inline_function (funcid=262664, result_type=701,
> args=0x2d6f700, pcqCtx=0x2d45af0, func_tuple=0x7f0c8b1ce3e0,
> context=0x7fffcf790350) at clauses.c:3213
> #23 0x000000000082f63a in simplify_function (funcid=262664, result_type=701,
> args=0x2d6f700, allow_inline=1 '\001', context=0x7fffcf790350) at
> clauses.c:2813
> #24 0x000000000082d53a in eval_const_expressions_mutator (node=0x2d6db78,
> context=0x7fffcf790350) at clauses.c:1744
> #25 0x0000000000832599 in expression_tree_mutator (node=0x2d6db00,
> mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
> clauses.c:3920
> #26 0x000000000082f0a4 in eval_const_expressions_mutator (node=0x2d6db00,
> context=0x7fffcf790350) at clauses.c:2506
> #27 0x00000000008326b6 in expression_tree_mutator (node=0x2d6da60,
> mutator=0x82d23f <eval_const_expressions_mutator>, context=0x7fffcf790350) at
> clauses.c:3956
> #28 0x000000000082f0a4 in eval_const_expressions_mutator (node=0x2d6da60,
> context=0x7fffcf790350) at clauses.c:2506
> #29 0x000000000082d1dc in eval_const_expressions (root=0x2d6e9a8,
> node=0x2d6da60) at clauses.c:1630
> #30 0x000000000080556b in preprocess_expression (root=0x2d6e9a8,
> expr=0x2d6da60, kind=1) at planner.c:928
> #31 0x0000000000804e8c in subquery_planner (glob=0x2d40f20, parse=0x2d6d8d0,
> parent_root=0x2d6d490, tuple_fraction=0, subroot=0x7fffcf7904b0,
> config=0x2d6e930) at planner.c:668
> #32 0x000000000080f8cb in make_subplan (root=0x2d6d490,
> orig_subquery=0x2d6cdd8, subLinkType=EXPR_SUBLINK, testexpr=0x0, isTopQual=0
> '\000') at subselect.c:428
> #33 0x0000000000810812 in process_sublinks_mutator (node=0x2d6d740,
> context=0x7fffcf790a20) at subselect.c:946
> #34 0x0000000000832599 in expression_tree_mutator (node=0x2d6d6c8,
> mutator=0x81077b <process_sublinks_mutator>, context=0x7fffcf790a20) at
> clauses.c:3920
> #35 0x0000000000810a0c in process_sublinks_mutator (node=0x2d6d6c8,
> context=0x7fffcf790f30) at subselect.c:1013
> #36 0x00000000008326b6 in expression_tree_mutator (node=0x2d6d800,
> mutator=0x81077b <process_sublinks_mutator>, context=0x7fffcf790f30) at
> clauses.c:3956
> #37 0x0000000000810a0c in process_sublinks_mutator (node=0x2d6d800,
> context=0x7fffcf790fc0) at subselect.c:1013
> #38 0x0000000000810779 in SS_process_sublinks (root=0x2d6d490,
> expr=0x2d6d800, isQual=0 '\000') at subselect.c:919
> #39 0x00000000008055b2 in preprocess_expression (root=0x2d6d490,
> expr=0x2d6d800, kind=1) at planner.c:946
> #40 0x0000000000804e8c in subquery_planner (glob=0x2d40f20, parse=0x2d6d170,
> parent_root=0x0, tuple_fraction=0, subroot=0x7fffcf791110, config=0x2d6d418)
> at planner.c:668
> #41 0x000000000080454d in standard_planner (parse=0x2d6d170, cursorOptions=0,
> boundParams=0x0) at planner.c:396
> #42 0x0000000000804269 in planner (parse=0x2d45298, cursorOptions=0,
> boundParams=0x0) at planner.c:296
> #43 0x00000000008c16d1 in pg_plan_query (querytree=0x2d45298,
> boundParams=0x0) at postgres.c:811
> #44 0x00000000008c17d3 in pg_plan_queries (querytrees=0x2d8ab30,
> boundParams=0x0, needSnapshot=0 '\000') at postgres.c:884
> #45 0x00000000008c2f18 in exec_simple_query (query_string=0x2d40638 "SELECT\n
> madlib.relative_error(\n madlib.array_scalar_add(ARRAY[0.8, 9.5,
> 2.6]::float8[], 2.2::float8),\n ARRAY[3.0, 11.7, 4.8]::float8[]) ;",
> seqServerHost=0x0, seqServerPort=-1) at postgres.c:1659
> #46 0x00000000008c7929 in PostgresMain (argc=1, argv=0x2c4e5c0,
> dbname=0x2c4e2e0 "postgres", username=0x2c41238 "guangzhou.zgz") at
> postgres.c:4654
> #47 0x000000000085f51a in BackendRun (port=0x2c4c090) at postmaster.c:7026
> #48 0x000000000085ebf8 in BackendStartup (port=0x2c4c090) at postmaster.c:6713
> #49 0x0000000000857199 in ServerLoop () at postmaster.c:2464
> #50 0x0000000000855aa1 in PostmasterMain (argc=18, argv=0x2c18030) at
> postmaster.c:1540
> #51 0x000000000077a937 in main (argc=18, argv=0x2c18030) at main.c:206
> (gdb)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
