#20203 [Opn->Fbk]: odbc_do() or odbc_exec() Always produces a segmentation fault core dump

ID: 20203 Updated by: kalowsky@php.net Reported By: xmixail@ipnet.gr -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: sparc solaris 2.8 and 2.6 PHP Version: 4.2.3 New Comment: I'd still appriciate the SQL Log :) Previous Comments: ------------------------------------------------------------------------ [2002-11-02 07:26:43] xmixail@ipnet.gr at /usr/pkg/php/php4-200210311500/ext/odbc/php_odbc.c:1274 1274 convert_to_string_ex(pv_query); (gdb) n 1277 result = (odbc_result *)emalloc(sizeof(odbc_result)); (gdb) display result 1: result = (odbc_result *) 0x1b4a88 (gdb) display result.stmt 2: result.stmt = 0x1b9da8 (gdb) display /s result.stmt 3: x/s result.stmt 0x1b9da8: "select * from kan_keim" At this point the query statment is correct But just before producing the fault is the following : 1305 if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TY PE, SQL_CURSOR_DYNAMIC) 5: /u rc = 16 4: rc = 16 3: x/s result.stmt 0x1c5148: "" 2: result.stmt = 0x1c5148 1: result = (odbc_result *) 0x1b9dd8 (gdb) s Program received signal SIGSEGV, Segmentation fault. 0xfeff55dc in SQLExtendedFetch () from /usr/local/odbc/lib/sql_st_lt.so I hope this helps you Best regards Christos ------------------------------------------------------------------------ [2002-11-01 09:32:49] iliaa@php.net display query display result->stmt ------------------------------------------------------------------------ [2002-11-01 06:16:39] xmixail@ipnet.gr Please i am not too familiar with gdb can you tell me how I can print query and result->stmt variables in step #10 ? Bets regards Christos ------------------------------------------------------------------------ [2002-10-31 19:45:27] kalowsky@php.net Also can you please turn on SQL Logging so we can see which steps are being processed. From the looks of it the SQLExtendedFetch is catching an error condition or possibly a need to re-allocate data and refetch furth of data. I find it hard to believe that the odbc_exect (a very basic part of any DB layer) isn't working with MSSQL. What are the types of data you're trying to extract? ------------------------------------------------------------------------ [2002-10-31 19:31:52] iliaa@php.net On step #10 could you print the values of: query and result->stmt ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/20203 -- Edit this bug report at http://bugs.php.net/?id=20203&edit=1