Thread: Segmentation fault in PQexec

On 3 December 2016 at 11:26, VICTOR MIGUEL MORALES CAYUELA
<victormiguel.moralescayuela@telefonica.com> wrote:
>
> Hello,
>
> I receive a segmentation fault signal calling PQexec function with an already established connection and a valid SQL
query,as frame #4 shows. 
>
> I printed both the connection variable (conexion_bbdd) and the SQL query variable (sql_formateado) and both are
valid.
>

sorry, this is actually very little information to work with.
i made a simple program and wasn't able to reproduce your problem.

Do you reproduce this consistently? can you make a simpler program
that reproduces the problem you're seeing?
Are you sure the problem is not in your own code? specially, look at
the size of the "sql_formateado" variable.

sending code as images is not very nice btw.

PS: are you sure your problem is not fixed in 9.6.1?

--
Jaime Casanova                      www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

SGVsbG8sDQoNCg0KSSBmb3VuZCB0aGUgZXJyb3Igd2FzIGluIGFub3RoZXIgcGFydCBvZiB0aGUg
cHJvZ3JhbS4gVGhlcmUgd2FzIGEgcG9pbnRlciB3cml0aW5nIG1pc3Rha2VubHkgc29tZXdoZXJl
IGluIHRoZSBwcm9ncmFtIGNvZGUsIGFuZCBzb21laG93IGl0IGFmZmVjdGVkIFBRZXhlYygpLiAN
Cg0KDQpTb3JyeSBmb3IgdGhlIGluY29udmVuaWVuY2UsDQpWaWN0b3INCg0KDQotLS0tLU1lbnNh
amUgb3JpZ2luYWwtLS0tLQ0KRGU6IEphaW1lIENhc2Fub3ZhIFttYWlsdG86amFpbWUuY2FzYW5v
dmFAMm5kcXVhZHJhbnQuY29tXSANCkVudmlhZG8gZWw6IGRvbWluZ28sIDA0IGRlIGRpY2llbWJy
ZSBkZSAyMDE2IDI6MDENClBhcmE6IFZJQ1RPUiBNSUdVRUwgTU9SQUxFUyBDQVlVRUxBIDx2aWN0
b3JtaWd1ZWwubW9yYWxlc2NheXVlbGFAdGVsZWZvbmljYS5jb20+DQpDQzogcGdzcWwtYnVnc0Bw
b3N0Z3Jlc3FsLm9yZw0KQXN1bnRvOiBSZTogW0JVR1NdIFNlZ21lbnRhdGlvbiBmYXVsdCBpbiBQ
UWV4ZWMNCg0KT24gMyBEZWNlbWJlciAyMDE2IGF0IDExOjI2LCBWSUNUT1IgTUlHVUVMIE1PUkFM
RVMgQ0FZVUVMQSA8dmljdG9ybWlndWVsLm1vcmFsZXNjYXl1ZWxhQHRlbGVmb25pY2EuY29tPiB3
cm90ZToNCj4NCj4gSGVsbG8sDQo+DQo+IEkgcmVjZWl2ZSBhIHNlZ21lbnRhdGlvbiBmYXVsdCBz
aWduYWwgY2FsbGluZyBQUWV4ZWMgZnVuY3Rpb24gd2l0aCBhbiBhbHJlYWR5IGVzdGFibGlzaGVk
IGNvbm5lY3Rpb24gYW5kIGEgdmFsaWQgU1FMIHF1ZXJ5LCBhcyBmcmFtZSAjNCBzaG93cy4NCj4N
Cj4gSSBwcmludGVkIGJvdGggdGhlIGNvbm5lY3Rpb24gdmFyaWFibGUgKGNvbmV4aW9uX2JiZGQp
IGFuZCB0aGUgU1FMIHF1ZXJ5IHZhcmlhYmxlIChzcWxfZm9ybWF0ZWFkbykgYW5kIGJvdGggYXJl
IHZhbGlkLg0KPg0KDQpzb3JyeSwgdGhpcyBpcyBhY3R1YWxseSB2ZXJ5IGxpdHRsZSBpbmZvcm1h
dGlvbiB0byB3b3JrIHdpdGguDQppIG1hZGUgYSBzaW1wbGUgcHJvZ3JhbSBhbmQgd2Fzbid0IGFi
bGUgdG8gcmVwcm9kdWNlIHlvdXIgcHJvYmxlbS4NCg0KRG8geW91IHJlcHJvZHVjZSB0aGlzIGNv
bnNpc3RlbnRseT8gY2FuIHlvdSBtYWtlIGEgc2ltcGxlciBwcm9ncmFtIHRoYXQgcmVwcm9kdWNl
cyB0aGUgcHJvYmxlbSB5b3UncmUgc2VlaW5nPw0KQXJlIHlvdSBzdXJlIHRoZSBwcm9ibGVtIGlz
IG5vdCBpbiB5b3VyIG93biBjb2RlPyBzcGVjaWFsbHksIGxvb2sgYXQgdGhlIHNpemUgb2YgdGhl
ICJzcWxfZm9ybWF0ZWFkbyIgdmFyaWFibGUuDQoNCnNlbmRpbmcgY29kZSBhcyBpbWFnZXMgaXMg
bm90IHZlcnkgbmljZSBidHcuDQoNClBTOiBhcmUgeW91IHN1cmUgeW91ciBwcm9ibGVtIGlzIG5v
dCBmaXhlZCBpbiA5LjYuMT8NCg0KLS0gDQpKYWltZSBDYXNhbm92YSAgICAgICAgICAgICAgICAg
ICAgICB3d3cuMm5kUXVhZHJhbnQuY29tDQpQb3N0Z3JlU1FMIERldmVsb3BtZW50LCAyNHg3IFN1
cHBvcnQsIFJlbW90ZSBEQkEsIFRyYWluaW5nICYgU2VydmljZXMNCg==