Re: mysql_fdw crash

Hi,

>When gdb will be active, then use command c, and then run query in session. gdb should to catch segfault.

Thank you very much. It's been helpfull.

BTW behaviour is strange. When I'm executing following, I do have always a SEGV :

psql (11.1)
Type "help" for help.

herve=# CREATE OR REPLACE FUNCTION public.test_bug2(text,integer,timestamp with time zone)
herve-# RETURNS integer
herve-#
herve-# AS '
herve'#
herve'# select coalesce(max(id),1) from sact_v1.autocalls where label=$1 and machine_id=$2 and created_date=$3;
herve'# '
herve-# LANGUAGE sql;
CREATE FUNCTION
herve=# select test_bug2('BSM_CRITICAL_SYSLOG',18843,now());

The GDB session :

Continuing.

Program received signal SIGSEGV, Segmentation fault.
prepare_query_params (param_types=0x1c86ac8, param_values=0x1c86ac0, param_exprs=0x1c86ab8, param_flinfo=0x1c86ab0, numParams=3, fdw_exprs=0x1c6b5b8, node=0x1c792d8) at mysql_fdw.c:2139
2139 *param_types[i] = exprType(param_expr);
(gdb) bt
#0 prepare_query_params (param_types=0x1c86ac8, param_values=0x1c86ac0, param_exprs=0x1c86ab8, param_flinfo=0x1c86ab0, numParams=3, fdw_exprs=0x1c6b5b8, node=0x1c792d8)
at mysql_fdw.c:2139
#1 mysqlBeginForeignScan (node=0x1c792d8, eflags=<optimized out>) at mysql_fdw.c:503
#2 0x000000000062ae94 in ExecInitForeignScan ()
#3 0x00000000006077bf in ExecInitNode ()
#4 0x000000000061117d in ExecInitAgg ()
#5 0x0000000000607717 in ExecInitNode ()
#6 0x0000000000601cf4 in standard_ExecutorStart ()
#7 0x000000000060d6ec in fmgr_sql ()
#8 0x00000000005fd504 in ExecInterpExpr ()
#9 0x00000000006258fb in ExecResult ()
#10 0x00000000006009aa in standard_ExecutorRun ()
#11 0x000000000073eaec in PortalRunSelect ()
#12 0x000000000073fede in PortalRun ()
#13 0x000000000073bd82 in exec_simple_query ()
#14 0x000000000073d249 in PostgresMain ()
#15 0x000000000047cff6 in ServerLoop ()
#16 0x00000000006cf7b3 in PostmasterMain ()
#17 0x000000000047ded1 in main ()

What is confusing, is that if I do the same with a pl/pgsql function (see below) I can run it 5 times, and the 6th exec hit the same SEGV...

CREATE OR REPLACE FUNCTION public.test_bug(text,text)
RETURNS integer
LANGUAGE plpgsql
AS $function$
DECLARE
plabel ALIAS FOR $1;
spmachine_id ALIAS FOR $2;
rid integer;
lnow timestamp with time zone;
pmachine_id INTEGER;

BEGIN
pmachine_id := cast(spmachine_id as INTEGER);
lnow:=now();

select max(id) into rid from sact_v1.autocalls where label=plabel and machine_id=pmachine_id and created_date=lnow;
rid := coalesce(rid,-1);

return rid;
END;
$function$;

CREATE FUNCTION
herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');
test_bug
----------
-1
(1 row)

herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');
test_bug
----------
-1
(1 row)

herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');
test_bug
----------
-1
(1 row)

herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');
test_bug
----------
-1
(1 row)

herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');
test_bug
----------
-1
(1 row)

herve=# select test_bug('BSM_CRITICAL_SYSLOG','18843');

Program received signal SIGSEGV, Segmentation fault.
prepare_query_params (param_types=0x1ca3558, param_values=0x1ca3550, param_exprs=0x1ca3548, param_flinfo=0x1ca3540, numParams=3, fdw_exprs=0x1ca8638, node=0x1cade28) at mysql_fdw.c:2139
2139 *param_types[i] = exprType(param_expr);
(gdb) bt
#0 prepare_query_params (param_types=0x1ca3558, param_values=0x1ca3550, param_exprs=0x1ca3548, param_flinfo=0x1ca3540, numParams=3, fdw_exprs=0x1ca8638, node=0x1cade28)
at mysql_fdw.c:2139
#1 mysqlBeginForeignScan (node=0x1cade28, eflags=<optimized out>) at mysql_fdw.c:503
#2 0x000000000062ae94 in ExecInitForeignScan ()
#3 0x00000000006077bf in ExecInitNode ()
#4 0x000000000061117d in ExecInitAgg ()
#5 0x0000000000607717 in ExecInitNode ()
#6 0x0000000000601cf4 in standard_ExecutorStart ()
#7 0x0000000000632946 in _SPI_execute_plan ()
#8 0x0000000000632d0b in SPI_execute_plan_with_paramlist ()
#9 0x00007ffb349aba22 in exec_stmt_execsql () from /usr/local/pgsql/lib/plpgsql.so
#10 0x00007ffb349ace43 in exec_stmts () from /usr/local/pgsql/lib/plpgsql.so
#11 0x00007ffb349af6d3 in exec_stmt_block () from /usr/local/pgsql/lib/plpgsql.so
#12 0x00007ffb349af88f in plpgsql_exec_function () from /usr/local/pgsql/lib/plpgsql.so
#13 0x00007ffb349a3375 in plpgsql_call_handler () from /usr/local/pgsql/lib/plpgsql.so
#14 0x00000000005fd504 in ExecInterpExpr ()
#15 0x00000000006258fb in ExecResult ()
#16 0x00000000006009aa in standard_ExecutorRun ()
#17 0x000000000073eaec in PortalRunSelect ()
#18 0x000000000073fede in PortalRun ()
#19 0x000000000073bd82 in exec_simple_query ()
#20 0x000000000073d249 in PostgresMain ()
#21 0x000000000047cff6 in ServerLoop ()
#22 0x00000000006cf7b3 in PostmasterMain ()
#23 0x000000000047ded1 in main ()