#36764 [Fbk->Opn]: pdo_oci hangs apache

ID: 36764 User updated by: mauroi at digbang dot com Reported By: mauroi at digbang dot com -Status: Feedback +Status: Open Bug Type: PDO related Operating System: Win XP SP2 PHP Version: 5CVS-2006-03-16 (snap) New Comment: Well, I tried to generate a backtrace but there's no real crash here. On windows it hangs, on linux the script doesn't finish (it stops after the fetch, but with no segfault). gdb only shows "Detaching after fork from child process xxxx". Is there anything else I can do? (I can use another datatype. Maybe you could wait for someone that can't live without binary_float). Thanks.... Previous Comments: ------------------------------------------------------------------------ [2006-03-18 21:13:03] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. All I get is: array(2) { ["FIELD"]=> string(4) "1.0E" [0]=> string(4) "1.0E" } (I did "insert into foo values (1)") ------------------------------------------------------------------------ [2006-03-18 20:54:55] mauroi at digbang dot com I'm using oracle instant client (on windows), and oracle 10R2 on linux also. I tried this script on linux (centos4, same machine): $conn = new PDO('oci:dbname= :o)', 'user', 'pass'); $a = $conn->prepare('SELECT * FROM foo'); var_dump($a->execute()); echo 'aa'; var_dump($a->fetch()); echo 'bb'; and got this: "bool(true) aa" (row information and bb missing) I don't get anything wrong in the error_log. Just the usual line in the access_log. Did you insert data on the table? With an empty table it doesn't happen. Thank you. ------------------------------------------------------------------------ [2006-03-18 20:31:23] tony2001@php.net I'm afraid "The page keeps loading forever" and "hangs" is not enough to understand the problem and I can't reproduce it on Linux with Oracle Instant Client and Oracle 10. What version of Oracle client and server are you using? What's in the error_log? Any other info? ------------------------------------------------------------------------ [2006-03-17 13:55:43] mauroi at digbang dot com Yes. The same happens. The page keeps loading forever. ------------------------------------------------------------------------ [2006-03-17 09:22:15] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Sure I did a mistake. ------------------------------------------------------------------------ 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/36764 -- Edit this bug report at http://bugs.php.net/?id=36764&edit=1