php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31678 ODBC Connection fails on Multiprocessor System
Submitted: 2005-01-24 10:31 UTC Modified: 2005-05-25 01:00 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: zipf dot mailcom at boewe-systec dot nospam dot de Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 5CVS, 4CVS (2005-02-05) OS: Windows 2000
Private report: No CVE-ID: None
 [2005-01-24 10:31 UTC] zipf dot mailcom at boewe-systec dot nospam dot de
Description:
------------
Platform: 4-CPU machine, Apache 1.3.33, PHP 4.3.x, Win 2000 Adv.
server engl., IBM DB2 8.2 (Fixpack 7a)

When issuing multiple Odbc-requests at once, the Apache client thread dies and Apache restarts but after that the ODBC connection will not work again. But php still works just the ODBC Connection fails

Same code runs okay on one-CPU machine with same platform. 
Tried php 4.3.8 4.3.9 4.3.10
Apache 1.3.31 - Apache 1.3.33 and Apache 2.0.52

Behavior is similar to bug 26558.




Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-01-24 10:54 UTC] derick@php.net
Why do you think this is a PHP problem and not some ODBC drivers problem?
 [2005-01-24 11:54 UTC] zipf dot mailcom at boewe-systec dot nospam dot de
A normal ODBC Connection still works. Just Apache/PHP cannot connect to the database anymore.
 [2005-02-03 05:17 UTC] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

And I ask again:
Does this work on command line? (using PHP CLI binary..)

Using PHP CLI binary means the executably file (is it php.exe or php-cli.exe in windows?) found in PHP distros..

Get the snapshot first.

 [2005-02-04 10:26 UTC] zipf dot mailcom at boewe-systec dot nospam dot de
Ok we tested today with this development snapshot. it took a very long time to get that error but it still occured. 
But this time apache didn?t respond at all after the crash. usually apache was still serving requests, but this time there was no answer anymore. We tested with IIS as well and it is the same behavior, so this isn?t just apache related.

testing a dbcheck php page with commandline still works after the crash.
 [2005-02-14 20:27 UTC] wez@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.0-win32-latest.zip

You could try the new database stuff in PHP 5.

http://snaps.php.net/win32/PECL_5_0/php_pdo.dll
http://snaps.php.net/win32/PECL_5_0/php_pdo_odbc.dll

Documentation at: http://www.php.net/pdo

PDO is to be bundled with the PHP 5.1 release; it's currently in beta, and has proven to be quite stable so far.
I'd really appreciate your feedback to see if PDO has the same issues that you've found with the older ODBC extension.

If you decide to try PDO and run into problems, ask for help on pecl-dev@lists.php.net; we're currently in aggressive beta/QA mode and aim to turnaround bug fixes next-day if possible.

 [2005-03-03 08:51 UTC] zipf dot mailcom at boewe-systec dot nospam dot de
I tried to isolate the problem with a single page to narrow down that error. but unfortunately the bug only happens in real life. I tried to creat different crash pages wich request the same sql queries that our real application does but so far i have not been able to reproduce that error by a single page.
I cannot change all the database code to the pdo classes as this would take to long, thats why I wanted to create a single page version so i could test it.
 [2005-05-17 17:20 UTC] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip


 [2005-05-25 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Dec 03 12:01:30 2024 UTC