Markus Fischer writes: > Hmm well ... thinking about this again, the behaviour is > expected isn't it? > > You're locking the table, you're not unlocking it. The > persistent connection itself is not influenced by this in > anyway and is still valid.
Yup, that's *why* it happens. What the bug report is intended to do is spur someone to figure out whether it can be prevented in PHP--if not, I'll document it as another pitfall of persistent connections. > So, the state is, your tables are locked. On your next run > using the very same persistent link, you'll have to unlock > them. Unfortunately, unlocking the tables earlier in the script doesn't appear to solve the problem. > It is the same problem with persistent links when you change > the database in one script and reuse the link in another > script. Of course the database has changed for the second > script too. Yup. > IMHO it is the responsibility of the developer to take care > of this. And, reviewing this, then its just a bad idea to use > locking with persistent connections. I agree--*if* it cannot be addressed in PHP. > IMHO, no bug but bogus; the developer has to take care of it. Not bogus either, then: either 'Documentation problem' (since it's known, undesired behaviour which is not warned against) or 'Feature request' (since it's undesired behaviour which may--again, I'm not sure--be addressable). > Feel free to correct me if I'm wrong :-) > > > - Markus Nope, I don't think you're wrong--I just don't think the problem should be ignored, since people have been bitten by it, and likely will be again. At least if it's documented (which I'll do after dinner unless someone yells) we'll be able to tell people that yeah, it sucks, but they were warned not to use pconnect with locks. :) -- Torben Wilson <[EMAIL PROTECTED]> http://www.thebuttlesschaps.com +1.604.709.0506 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
