Professional Web Applications Themes

#39239 [NEW]: pconnect canīt reuse open connection - PHP Bugs

From: marcos dot neves at gmail dot com Operating system: FreeBSD 5.4-STABLE i386 PHP version: 5.1.6 PHP Bug Type: MySQL related Bug description: pconnect canīt reuse open connection Description: ------------ Probably itīs the same bug of 38283, but with a newer version and a different OS. I try the same version on windows, and mysql_pconnect reuse the connection as expected. But on two php instalations on two machines, pconnect works as a simple mysql_connect. The php.ini configuration are ok, and php is running as Apache Module, as required for pconnect works. FreeBSD 5.4-STABLE i386 apache-2.2.2_1 Version 2.2 of Apache web ...

  1. #1

    Default #39239 [NEW]: pconnect canīt reuse open connection

    From: marcos dot neves at gmail dot com
    Operating system: FreeBSD 5.4-STABLE i386
    PHP version: 5.1.6
    PHP Bug Type: MySQL related
    Bug description: pconnect canīt reuse open connection

    Description:
    ------------
    Probably itīs the same bug of 38283, but with a newer version and a
    different OS.

    I try the same version on windows, and mysql_pconnect reuse the connection
    as expected. But on two php instalations on two machines, pconnect works as
    a simple mysql_connect.
    The php.ini configuration are ok, and php is running as Apache Module, as
    required for pconnect works.

    FreeBSD 5.4-STABLE i386

    apache-2.2.2_1 Version 2.2 of Apache web server with prefork MPM.

    php5-5.1.6_2


    --
    Edit bug report at [url]http://bugs.php.net/?id=39239&edit=1[/url]
    --
    Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39239&r=trysnapshot44[/url]
    Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39239&r=trysnapshot52[/url]
    Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39239&r=trysnapshot60[/url]
    Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39239&r=fixedcvs[/url]
    Fixed in release: [url]http://bugs.php.net/fix.php?id=39239&r=alreadyfixed[/url]
    Need backtrace: [url]http://bugs.php.net/fix.php?id=39239&r=needtrace[/url]
    Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39239&r=needscript[/url]
    Try newer version: [url]http://bugs.php.net/fix.php?id=39239&r=oldversion[/url]
    Not developer issue: [url]http://bugs.php.net/fix.php?id=39239&r=support[/url]
    Expected behavior: [url]http://bugs.php.net/fix.php?id=39239&r=notwrong[/url]
    Not enough info: [url]http://bugs.php.net/fix.php?id=39239&r=notenoughinfo[/url]
    Submitted twice: [url]http://bugs.php.net/fix.php?id=39239&r=submittedtwice[/url]
    register_globals: [url]http://bugs.php.net/fix.php?id=39239&r=globals[/url]
    PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39239&r=php3[/url]
    Daylight Savings: [url]http://bugs.php.net/fix.php?id=39239&r=dst[/url]
    IIS Stability: [url]http://bugs.php.net/fix.php?id=39239&r=isapi[/url]
    Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39239&r=gnused[/url]
    Floating point limitations: [url]http://bugs.php.net/fix.php?id=39239&r=float[/url]
    No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39239&r=nozend[/url]
    MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39239&r=mysqlcfg[/url]
    marcos dot neves at gmail dot com Guest

  2. #2

    Default #39239 [Fbk->Opn]: pconnect canīt reuse open connection

    ID: 39239
    User updated by: marcos dot neves at gmail dot com
    Reported By: marcos dot neves at gmail dot com
    -Status: Feedback
    +Status: Open
    Bug Type: MySQL related
    Operating System: FreeBSD 5.4-STABLE i386
    PHP Version: 5.1.6
    New Comment:

    <?
    mysql_pconnect(...); // just open a connection
    ?>

    RUN the follow command on a mysql client:
    SHOW PROCESSLIST

    Since itīs persistent, that connection will be listed on PROCESSLIST.
    If you run the script again, the same opened connection should be used
    in place, and the timeout would be reset to zero. The problem is that a
    new connection has been opened.

    Please, tell me what more information can I give, cause the bug happens
    only under my server.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-10-23 15:38:43] [email]tony2001php.net[/email]

    Not enough information was provided for us to be able
    to handle this bug. Please re-read the instructions at
    [url]http://bugs.php.net/how-to-report.php[/url]

    If you can provide more information, feel free to add it
    to this bug and change the status back to "Open".

    Thank you for your interest in PHP.




    ------------------------------------------------------------------------

    [2006-10-23 15:30:28] marcos dot neves at gmail dot com

    Description:
    ------------
    Probably itīs the same bug of 38283, but with a newer version and a
    different OS.

    I try the same version on windows, and mysql_pconnect reuse the
    connection as expected. But on two php instalations on two machines,
    pconnect works as a simple mysql_connect.
    The php.ini configuration are ok, and php is running as Apache Module,
    as required for pconnect works.

    FreeBSD 5.4-STABLE i386

    apache-2.2.2_1 Version 2.2 of Apache web server with prefork MPM.

    php5-5.1.6_2



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39239&edit=1[/url]
    marcos dot neves at gmail dot com Guest

  3. #3

    Default #39239 [Opn->Bgs]: pconnect canīt reuse open connection

    ID: 39239
    Updated by: [email]tony2001php.net[/email]
    Reported By: marcos dot neves at gmail dot com
    -Status: Open
    +Status: Bogus
    Bug Type: MySQL related
    Operating System: FreeBSD 5.4-STABLE i386
    PHP Version: 5.1.6
    New Comment:
    >If you run the script again, the same opened connection
    >should be used in place, and the timeout would be reset
    >to zero.
    Only if your next request is server by THE VERY SAME Apache child as
    the previous one, 'cause persistent resources are
    per-process/per-thread.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-10-23 15:46:00] marcos dot neves at gmail dot com

    <?
    mysql_pconnect(...); // just open a connection
    ?>

    RUN the follow command on a mysql client:
    SHOW PROCESSLIST

    Since itīs persistent, that connection will be listed on PROCESSLIST.
    If you run the script again, the same opened connection should be used
    in place, and the timeout would be reset to zero. The problem is that a
    new connection has been opened.

    Please, tell me what more information can I give, cause the bug happens
    only under my server.

    ------------------------------------------------------------------------

    [2006-10-23 15:38:43] [email]tony2001php.net[/email]

    Not enough information was provided for us to be able
    to handle this bug. Please re-read the instructions at
    [url]http://bugs.php.net/how-to-report.php[/url]

    If you can provide more information, feel free to add it
    to this bug and change the status back to "Open".

    Thank you for your interest in PHP.




    ------------------------------------------------------------------------

    [2006-10-23 15:30:28] marcos dot neves at gmail dot com

    Description:
    ------------
    Probably itīs the same bug of 38283, but with a newer version and a
    different OS.

    I try the same version on windows, and mysql_pconnect reuse the
    connection as expected. But on two php instalations on two machines,
    pconnect works as a simple mysql_connect.
    The php.ini configuration are ok, and php is running as Apache Module,
    as required for pconnect works.

    FreeBSD 5.4-STABLE i386

    apache-2.2.2_1 Version 2.2 of Apache web server with prefork MPM.

    php5-5.1.6_2



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39239&edit=1[/url]
    tony2001@php.net Guest

  4. #4

    Default #39239 [Bgs]: pconnect canīt reuse open connection

    ID: 39239
    User updated by: marcos dot neves at gmail dot com
    Reported By: marcos dot neves at gmail dot com
    Status: Bogus
    Bug Type: MySQL related
    Operating System: FreeBSD 5.4-STABLE i386
    PHP Version: 5.1.6
    New Comment:

    How can I configure Apache to reuse the same thread more as it can.
    Cause each request, itīs creating a new connection with the database.
    Could it be because Iīm using Apache with prefork MPM?


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-10-23 15:57:55] [email]tony2001php.net[/email]
    >If you run the script again, the same opened connection
    >should be used in place, and the timeout would be reset
    >to zero.
    Only if your next request is server by THE VERY SAME Apache child as
    the previous one, 'cause persistent resources are
    per-process/per-thread.

    ------------------------------------------------------------------------

    [2006-10-23 15:46:00] marcos dot neves at gmail dot com

    <?
    mysql_pconnect(...); // just open a connection
    ?>

    RUN the follow command on a mysql client:
    SHOW PROCESSLIST

    Since itīs persistent, that connection will be listed on PROCESSLIST.
    If you run the script again, the same opened connection should be used
    in place, and the timeout would be reset to zero. The problem is that a
    new connection has been opened.

    Please, tell me what more information can I give, cause the bug happens
    only under my server.

    ------------------------------------------------------------------------

    [2006-10-23 15:38:43] [email]tony2001php.net[/email]

    Not enough information was provided for us to be able
    to handle this bug. Please re-read the instructions at
    [url]http://bugs.php.net/how-to-report.php[/url]

    If you can provide more information, feel free to add it
    to this bug and change the status back to "Open".

    Thank you for your interest in PHP.




    ------------------------------------------------------------------------

    [2006-10-23 15:30:28] marcos dot neves at gmail dot com

    Description:
    ------------
    Probably itīs the same bug of 38283, but with a newer version and a
    different OS.

    I try the same version on windows, and mysql_pconnect reuse the
    connection as expected. But on two php instalations on two machines,
    pconnect works as a simple mysql_connect.
    The php.ini configuration are ok, and php is running as Apache Module,
    as required for pconnect works.

    FreeBSD 5.4-STABLE i386

    apache-2.2.2_1 Version 2.2 of Apache web server with prefork MPM.

    php5-5.1.6_2



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39239&edit=1[/url]
    marcos dot neves at gmail dot com Guest

Similar Threads

  1. #39239 [Opn->Fbk]: pconnect canīt reuse open connection
    By tony2001@php.net in forum PHP Bugs
    Replies: 0
    Last Post: October 23rd, 03:38 PM
  2. Keeping Connection Open - Consequences?
    By Mike in forum ASP Database
    Replies: 2
    Last Post: December 12th, 06:39 PM
  3. Replies: 0
    Last Post: November 12th, 11:03 PM
  4. connection.open issue??
    By RP in forum ASP
    Replies: 3
    Last Post: June 30th, 09:03 PM
  5. Replies: 1
    Last Post: June 26th, 05:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139