php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #13681 Stale data across clustered webservers
Submitted: 2001-10-15 19:09 UTC Modified: 2001-12-13 06:28 UTC
From: jweiss at greyzone dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.5 OS: Linux
Private report: No CVE-ID: None
 [2001-10-15 19:09 UTC] jweiss at greyzone dot com
I have 2 mirrored, PHP-enabled webservers connecting to the same MySQL database. These servers are load-balanced through a Cisco Local Director which maintains no data persistency. The problem is basically that, though UPDATES and INSERTS on one of the webservers are immediately registered (through a SELECT statement) on the other box, only UPDATES on the second box are immediately registered on the first; INSERTS on this second box take some time (several minutes) to show up on the first box. The assymmetry here makes this an extremely beguiling problem.

To correct it, I have tried to get rid of persistent connections (both through php.ini and through our code). I have also tried upgrading MySQL (to 3.23.43); have upgraded (and backgraded to PHP 4.0.5); and have recompiled PHP (4.0.5) with the newest MySQL development libraries (again, 3.23.43). All of this has been to no avail.

The fact that direct client connections to the MySQL server from both of the webservers immediately shows any data updates seems to suggest that this is not a problem in the MySQL server itself. It would seem, then, that the PHP client is not directly contacting the MySQL server when it echoes out the stale data. Anyway, I'm pretty well stumped on this. Please let me know if this is in fact a bug (as it seems) or if there are any other things to look into.

Thanks,
jonathan

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-11-20 18:43 UTC] mfischer@php.net
Very hard to reproduce if you understand what I mean ..

Can you give it a try with latest RC?

http://www.php.net/~zeev/php-4.1.0RC3.tar.gz

Feedback.
 [2001-12-13 06:28 UTC] sander@php.net
No feedback. Closing.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Jun 15 16:01:30 2024 UTC