[Sqlrelay-discussion] Segmentation fault in libsqlrclient (php)

[armand\.bastien <arm...@la...>]

Hi,

I am trying SQLRelay 0.37 for a php site (with oracle base on
a Solaris). It works greats (page displays quite faster, db
load is decreased).

For a test page, Php stops with a seg fault (in libsqlrclient).

In this page, I have two queries that use more than 15 Column
(select * with 17 columns in the table and Select C1,...,C19).
If only one query is executed, there is no problem.

If I compile again the php api with OPTIMISTIC_COLUMN_COUNT
set to 20. The seg fault does not occur. (both queries are
executed)

Here is the backtrace extracted from the core file :
libsqlrclient-0.37.so.1`_ZN3row8addFieldEjPKcj+0x28(1eadf8,
7800, 7800, 31, 0, fea3ee28)
libsqlrclient-0.37.so.1`_ZN10sqlrcursor16processResultSetEby+0xf8(1,
0, 0, 31, 1f2628, 32)
libsqlrclient-0.37.so.1`_ZN10sqlrcursor8runQueryEPKc+0x88(1,
1575c0, 1575c0, 4, 21, 0)
libsqlrclient-0.37.so.1`_ZN10sqlrcursor12executeQueryEv+0x50(1eadf8,
1eadf8, c5, 1, 19, 0)
libsqlrclient-0.37.so.1`_ZN10sqlrcursor9sendQueryEPKc+0x10(1eadf8,
c22f8, 4632c8, 0, 1, 19)
sql_relay.so`zif_sqlrcur_sendquery+0xb8(4632c8, 4670f0, 0, 1,
feb364f4, 0)
libphp4.so`execute+0x20fc(3b8a78, ffbe2d74, 10e6bc, 10e6c8,
fee3d2f8, ffbe3b58)
libphp4.so`execute+0x1e80(a18a8, ffbe3bf4, 10e6ac, ffbe3b54,
fee3d2f8, ffbe4458)
libphp4.so`execute+0x1e80(34c940, ffbe44f4, 1e00, 10e69c,
fee3d2f8, ffbec1b8)
libphp4.so`execute+0x1e80(216020, ffbec254, fee3d2f8,
ffbec3a0, 28a8, 28ac)
libphp4.so`execute+0x3424(2c2f68, ffbec494, fee3d2f8,
ffbecb00, 0, 0)
libphp4.so`execute+0x3424(334728, ffbed654, fee3d2f8,
ffbee520, 0, 0)
libphp4.so`execute+0x3424(3138b0, ffbee794, fee3d2f8,
ffbeeae0, 0, 0)
libphp4.so`execute+0x3424(3c45d8, ffbeebd4, ffbeec7c, 220c, 0, 0)
libphp4.so`zend_execute_scripts+0xa8(8, 0, 3, ffbef230,
fee3d0c8, ffbeece8)
libphp4.so`php_execute_script+0x1f0(0, fee3a078, 99040,
fffffd1c, 0, ff1bf781)
libphp4.so`apache_php_module_main+0x1cc(ffffffff, 0, 0,
ffffff64, ffffff6c, 22d58)
libphp4.so`send_php+0x1e8(fee3d408, 0, 0, 0, 70, 70)
libhttpd.so`ap_invoke_handler+0x1b0(98390, 12, 1, ff38ee3c,
231f8, fffff2b4)
libhttpd.so`process_request_internal+0x150(0, 1, 98390,
fee50000, 0, fffffb50)
libhttpd.so`ap_process_request+0x30(98390, 2, 98390, fffff810,
ff38eff0, 2)
libhttpd.so`child_main+0x950(fffff204, b400, ff38b7e4,
ff38b7e0, fffff09c, fffff8e8)
libhttpd.so`make_child+0x11c(22d58, 2, 450e9d4e, ff385764, 0,
fee50030)
libhttpd.so`perform_idle_server_maintenance+0x1f4(5, 4,
450e9d4e, ff38b7a8, 5, 5)
libhttpd.so`standalone_main+0x848(fffff210, fffff67c,
fffff9e8, fffff700, ff38f00c, ff38ee70)
libhttpd.so`ap_main+0x440(5, ffbef8a4, ffbef8bc, 20a38, 0, 0)
_start+0x5c(0, 0, 0, 0, 0, 0)

Take Care.=0A=0AAcc=E9dez au courrier =E9lectronique de La Poste 
sur www.laposte.net ou sur 3615 LAPOSTENET (0,34=80 TTC /mn) 
1 Giga de stockage gratuit =96 Antispam et antivirus int=E9gr=E9s 
=0A