Hi all,
we've developed an application using libpq to access a table in the PgSQL database but we're sometimes experiencing segmentation fault on resetPQExpBuffer() function of libpq called from PQexecParams() with prepared query.
PostgreSQL version is 9.6.3 and the backtrace is:
Core was generated by `/usr/ti/bin/status-monitor2 -m /usr/lib64/status-monitor2/modules'.
Program terminated with signal 11, Segmentation fault.
#0 resetPQExpBuffer (str=str@entry=0x9f4a28) at pqexpbuffer.c:152
152 str->data[0] = '\0';
Thread 1 (Thread 0x7fdf68de3840 (LWP 3525)):
#0 resetPQExpBuffer (str=str@entry=0x9f4a28) at pqexpbuffer.c:152
No locals.
#1 0x00007fdf66e0333d in PQsendQueryStart (conn=conn@entry=0x9f46d0) at fe-exec.c:1371
No locals.
#2 0x00007fdf66e044b9 in PQsendQueryParams (conn=conn@entry=0x9f46d0, command=command@entry=0x409a98 "SELECT min, hour, day, month, dow, sensor, module, params, priority, rt_due FROM sm.cron WHERE sensor = $1 ORDER BY priority DESC", nParams=nParams@entry=1, paramTypes=paramTypes@entry=0x0, paramValues=paramValues@entry=0xa2b7b0, paramLengths=paramLengths@entry=0x0, paramFormats=paramFormats@entry=0x0, resultFormat=resultFormat@entry=0) at fe-exec.c:1192
No locals.
#3 0x00007fdf66e0552b in PQexecParams (conn=0x9f46d0, command=0x409a98 "SELECT min, hour, day, month, dow, sensor, module, params, priority, rt_due FROM sm.cron WHERE sensor = $1 ORDER BY priority DESC", nParams=1, paramTypes=0x0, paramValues=0xa2b7b0, paramLengths=0x0, paramFormats=0x0, resultFormat=0) at fe-exec.c:1871
No locals.
Unfortunately we didn't have more information from the crash, at least for now.
Is this a known issue and can you help me with this one?
Thanks,
Michal
--
Michal Novotny
System Development Lead
michal.novotny@greycortex.com
GREYCORTEX s.r.o.
Purkynova 127, 61200 Brno
Czech Republic
www.greycortex.com