php-general Digest 2 Apr 2013 10:46:23 -0000 Issue 8181
Topics (messages 320724 through 320737):
mysqli & nested queries - maybe I'm rusty...
320724 by: Jay Blanchard
320737 by: Jay Blanchard
A relative date puzzle
320725 by: Jim Giner
320726 by: Mattias Thorslund
320727 by: Mattias Thorslund
320728 by: Jim Giner
320729 by: Steven Staples
Is there a PHP based authentication library?
320730 by: Mark
320731 by: David OBrien
320732 by: Sorin Badea
320733 by: Mark
320734 by: Mark
320735 by: Andy McKenzie
php-fpm (5.4.13) takes up all cpu resources
320736 by: Free Proxy
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
I am putting together an application where we are almost exclusively
using stored procedures in MySQL because most of the heavy lifting (as
it should be) is done in the database.
I have exactly one situation where I need to execute a stored procedure
and while returning the results if I run a across a particular value in
those results I need to execute another SP to handle. Because I have
forgotten which combination or store_result, use_result, fetch_row (not
to mention that fetch row doesn't have the column names in the array,
just the index) to use I am banging my head against the wall while
getting the dastardly "2014 Commands out of sync;" error. Can someone
provide some insight please?
Assume that $mysqli is the connection -
$sql = "CALL sp_ONE(" . $product . "," . $level . ")";
if(!$result = $mysqli->multi_query($sql)) {
echo "Error: (" . $mysqli->errno . ") " . $mysqli->error . " on
Query " . $sql;
} else {
do {
if($side = $mysqli->store_result()) {
/* output the list */
echo '<ul>';
while($row = $side->fetch_row()) {
/* careful, column names aren't carried over */
echo '<li data-page="' . $row[2] . '">' . $row[1] .
'</li>';
/* do we need to do a another stored procedure? */
if(isset($row[3])) {
/* get the info */
$sql = "CALL sp_TWO(" . $product . "," . $row[0] . ")";
if(!$subResult = $mysqli->multi_query($sql)) {
echo "Error: (" . $mysqli->errno . ") " .
$mysqli->error . " on Query " . $sql;
}
/* output the extra info */
echo '<ul>';
while($sub = mysqli_fetch_array($subResult)) {
echo '<li data-page="' . $sub[1] . '">' .
$sub[0] . '</li>';
}
echo '</ul>';
}
}
echo '</ul>';
$side->close();
}
} while($mysqli->next_result());
}
--- End Message ---
--- Begin Message ---
Anyone? I have not been able to find a solution online.
On 4/1/2013 11:33 AM, Jay Blanchard wrote:
I am putting together an application where we are almost exclusively
using stored procedures in MySQL because most of the heavy lifting (as
it should be) is done in the database.
I have exactly one situation where I need to execute a stored
procedure and while returning the results if I run a across a
particular value in those results I need to execute another SP to
handle. Because I have forgotten which combination or store_result,
use_result, fetch_row (not to mention that fetch row doesn't have the
column names in the array, just the index) to use I am banging my head
against the wall while getting the dastardly "2014 Commands out of
sync;" error. Can someone provide some insight please?
Assume that $mysqli is the connection -
$sql = "CALL sp_ONE(" . $product . "," . $level . ")";
if(!$result = $mysqli->multi_query($sql)) {
echo "Error: (" . $mysqli->errno . ") " . $mysqli->error . " on
Query " . $sql;
} else {
do {
if($side = $mysqli->store_result()) {
/* output the list */
echo '<ul>';
while($row = $side->fetch_row()) {
/* careful, column names aren't carried over */
echo '<li data-page="' . $row[2] . '">' . $row[1] .
'</li>';
/* do we need to do a another stored procedure? */
if(isset($row[3])) {
/* get the info */
$sql = "CALL sp_TWO(" . $product . "," . $row[0] .
")";
if(!$subResult = $mysqli->multi_query($sql)) {
echo "Error: (" . $mysqli->errno . ") " .
$mysqli->error . " on Query " . $sql;
}
/* output the extra info */
echo '<ul>';
while($sub = mysqli_fetch_array($subResult)) {
echo '<li data-page="' . $sub[1] . '">' .
$sub[0] . '</li>';
}
echo '</ul>';
}
}
echo '</ul>';
$side->close();
}
} while($mysqli->next_result());
}
--- End Message ---
--- Begin Message ---
I'm looking for some ideas on how to handle the following get a datetime
value that is relative to a specific future date when presented with a
partial day &time value.
Specifically, I have an appl that requires some lengthy input involving
days and times. I have streamlined the d/e effort so that it can be
done entirely using the number keypad (if available), or else just with
numeric entries. Works great, very quick (JS) and accurate. Basically
the users type some numbers and end up with something like:
Sat 08:00am or Fri 07:00pm etc.
Does anyone have an idea on how I can convert this value to a true
datetime value for my database updates, where the above value is
relative to a specific date in the future? IE, the d/e takes place a
few days before a certain upcoming date and I want my entry of "Sat" to
translate to the Saturday following that certain date. This could take
place one to two weeks prior to the start date, so just adding "next" to
the value above won't work. I really need to incorporate a specific
date in the solution.
Thoughts anyone?
--- End Message ---
--- Begin Message ---
On 4/1/13 11:05 AM, Jim Giner wrote:
I'm looking for some ideas on how to handle the following get a
datetime value that is relative to a specific future date when
presented with a partial day &time value.
Specifically, I have an appl that requires some lengthy input
involving days and times. I have streamlined the d/e effort so that
it can be done entirely using the number keypad (if available), or
else just with numeric entries. Works great, very quick (JS) and
accurate. Basically the users type some numbers and end up with
something like:
Sat 08:00am or Fri 07:00pm etc.
Does anyone have an idea on how I can convert this value to a true
datetime value for my database updates, where the above value is
relative to a specific date in the future? IE, the d/e takes place a
few days before a certain upcoming date and I want my entry of "Sat"
to translate to the Saturday following that certain date. This could
take place one to two weeks prior to the start date, so just adding
"next" to the value above won't work. I really need to incorporate a
specific date in the solution.
Thoughts anyone?
Use strtotime() to get a UNIX time stamp, then use date() to format it
as you like.
$myDate = strtotime("wed 11:00 am"); //1365012000
echo date("Y-m-d H:i:s", $myDate); //2013-04-03 11:00:00
On two lines for clarity.
Cheers,
Mattias
--- End Message ---
--- Begin Message ---
On 4/1/13 11:15 AM, Mattias Thorslund wrote:
On 4/1/13 11:05 AM, Jim Giner wrote:
I'm looking for some ideas on how to handle the following get a
datetime value that is relative to a specific future date when
presented with a partial day &time value.
Specifically, I have an appl that requires some lengthy input
involving days and times. I have streamlined the d/e effort so that
it can be done entirely using the number keypad (if available), or
else just with numeric entries. Works great, very quick (JS) and
accurate. Basically the users type some numbers and end up with
something like:
Sat 08:00am or Fri 07:00pm etc.
Does anyone have an idea on how I can convert this value to a true
datetime value for my database updates, where the above value is
relative to a specific date in the future? IE, the d/e takes place a
few days before a certain upcoming date and I want my entry of "Sat"
to translate to the Saturday following that certain date. This could
take place one to two weeks prior to the start date, so just adding
"next" to the value above won't work. I really need to incorporate a
specific date in the solution.
Thoughts anyone?
Use strtotime() to get a UNIX time stamp, then use date() to format it
as you like.
$myDate = strtotime("wed 11:00 am"); //1365012000
echo date("Y-m-d H:i:s", $myDate); //2013-04-03 11:00:00
On two lines for clarity.
Cheers,
Mattias
I'm sorry, I didn't read the last part of your question too closely.
strtotime() should help you there as well. Just put the timestamp of the
date to compare the string expression to as the second parameter.
$relativeToDate = strtotime("2013-04-04"); //1365058800
$myDate = strtotime("wed 11:00 am", $relativeToDate); //1365616800
echo date("Y-m-d H:i:s", $myDate); //2013-04-10 11:00:00
For more advanced date manipulation, there are the Date/Time functions
but this is simple stuff. You can even do it OO-style with the DateTime
class & Co.
Cheers,
Mattias
--- End Message ---
--- Begin Message ---
On 4/1/2013 2:32 PM, Mattias Thorslund wrote:
On 4/1/13 11:15 AM, Mattias Thorslund wrote:
On 4/1/13 11:05 AM, Jim Giner wrote:
I'm looking for some ideas on how to handle the following get a
datetime value that is relative to a specific future date when
presented with a partial day &time value.
Specifically, I have an appl that requires some lengthy input
involving days and times. I have streamlined the d/e effort so that
it can be done entirely using the number keypad (if available), or
else just with numeric entries. Works great, very quick (JS) and
accurate. Basically the users type some numbers and end up with
something like:
Sat 08:00am or Fri 07:00pm etc.
Does anyone have an idea on how I can convert this value to a true
datetime value for my database updates, where the above value is
relative to a specific date in the future? IE, the d/e takes place a
few days before a certain upcoming date and I want my entry of "Sat"
to translate to the Saturday following that certain date. This could
take place one to two weeks prior to the start date, so just adding
"next" to the value above won't work. I really need to incorporate a
specific date in the solution.
Thoughts anyone?
Use strtotime() to get a UNIX time stamp, then use date() to format it
as you like.
$myDate = strtotime("wed 11:00 am"); //1365012000
echo date("Y-m-d H:i:s", $myDate); //2013-04-03 11:00:00
On two lines for clarity.
Cheers,
Mattias
I'm sorry, I didn't read the last part of your question too closely.
strtotime() should help you there as well. Just put the timestamp of the
date to compare the string expression to as the second parameter.
$relativeToDate = strtotime("2013-04-04"); //1365058800
$myDate = strtotime("wed 11:00 am", $relativeToDate); //1365616800
echo date("Y-m-d H:i:s", $myDate); //2013-04-10 11:00:00
For more advanced date manipulation, there are the Date/Time functions
but this is simple stuff. You can even do it OO-style with the DateTime
class & Co.
Cheers,
Mattias
Thanks for this - I'll experiment and see if I have it. Basically I
never read the strtotime doc close enough to get past the word "now" in
the syntax. Obviously it is EXACTLY what I needed.
--- End Message ---
--- Begin Message ---
> Thanks for this - I'll experiment and see if I have it. Basically I never
> read the strtotime doc close enough to get past the word "now" in the
> syntax. Obviously it is EXACTLY what I needed.
$var = strtotime('now');
Is the same as
$var = time();
Unless of course, I didn't understand what you're referring too :P
But strtotime() is a very useful function, unless of course you want the OO
stuff ;)
--- End Message ---
--- Begin Message ---
Hi,
I stumbled upon this payment library: http://ci-merchant.org/ which
abstracts the different payment backends away and exposes a new easy
to use interface for the app developer to use. Thus making it very
easy to use different payment providers.
I was wondering if something like that is also existing for
authentication? For example, in authentication you have quite a few
different ones:
- Mozilla Persona
- openid
- facebook connect
- google (openid?)
- use/pass based authentication (a.k.a. the self made version that
every dev begins with)
- oauth
- twitter connect
- etc...
Is there such a library in existence? I'm especially looking for one
with mozilla persona implemented.
Kind regards,
Mark
--- End Message ---
--- Begin Message ---
On Mon, Apr 1, 2013 at 5:26 PM, Mark <mark...@gmail.com> wrote:
> Hi,
>
> I stumbled upon this payment library: http://ci-merchant.org/ which
> abstracts the different payment backends away and exposes a new easy
> to use interface for the app developer to use. Thus making it very
> easy to use different payment providers.
>
> I was wondering if something like that is also existing for
> authentication? For example, in authentication you have quite a few
> different ones:
> - Mozilla Persona
> - openid
> - facebook connect
> - google (openid?)
> - use/pass based authentication (a.k.a. the self made version that
> every dev begins with)
> - oauth
> - twitter connect
> - etc...
>
> Is there such a library in existence? I'm especially looking for one
> with mozilla persona implemented.
>
> Kind regards,
> Mark
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> https://github.com/openid/php-openid
--- End Message ---
--- Begin Message ---
Hi Mark,
I think a simple Google search would be faster. Anyway, an unified way for
3rd party authentication doesn't exist from my knowledge, but for Persona
you could use the sample from mozilla github account
https://github.com/mozilla/browserid-cookbook .
Good luck,
Sorin!
On Tue, Apr 2, 2013 at 12:26 AM, Mark <mark...@gmail.com> wrote:
> Hi,
>
> I stumbled upon this payment library: http://ci-merchant.org/ which
> abstracts the different payment backends away and exposes a new easy
> to use interface for the app developer to use. Thus making it very
> easy to use different payment providers.
>
> I was wondering if something like that is also existing for
> authentication? For example, in authentication you have quite a few
> different ones:
> - Mozilla Persona
> - openid
> - facebook connect
> - google (openid?)
> - use/pass based authentication (a.k.a. the self made version that
> every dev begins with)
> - oauth
> - twitter connect
> - etc...
>
> Is there such a library in existence? I'm especially looking for one
> with mozilla persona implemented.
>
> Kind regards,
> Mark
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Badea Sorin (unu.sorin)
sorin.bade...@gmail.com
unu_so...@yahoo.com
Pagina personala:
http://badeasorin.com
--- End Message ---
--- Begin Message ---
On Tue, Apr 2, 2013 at 12:25 AM, David OBrien <dgobr...@gmail.com> wrote:
>
>
>
> On Mon, Apr 1, 2013 at 5:26 PM, Mark <mark...@gmail.com> wrote:
>>
>> Hi,
>>
>> I stumbled upon this payment library: http://ci-merchant.org/ which
>> abstracts the different payment backends away and exposes a new easy
>> to use interface for the app developer to use. Thus making it very
>> easy to use different payment providers.
>>
>> I was wondering if something like that is also existing for
>> authentication? For example, in authentication you have quite a few
>> different ones:
>> - Mozilla Persona
>> - openid
>> - facebook connect
>> - google (openid?)
>> - use/pass based authentication (a.k.a. the self made version that
>> every dev begins with)
>> - oauth
>> - twitter connect
>> - etc...
>>
>> Is there such a library in existence? I'm especially looking for one
>> with mozilla persona implemented.
>>
>> Kind regards,
>> Mark
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
> https://github.com/openid/php-openid
That's OpenID only. What i meant is one library with some plugin
structure where you can add in a plugin for each authentication
method.
--- End Message ---
--- Begin Message ---
On Tue, Apr 2, 2013 at 12:27 AM, Sorin Badea <sorin.bade...@gmail.com> wrote:
> Hi Mark,
> I think a simple Google search would be faster. Anyway, an unified way for
> 3rd party authentication doesn't exist from my knowledge, but for Persona
> you could use the sample from mozilla github account
> https://github.com/mozilla/browserid-cookbook .
>
> Good luck,
> Sorin!
>
>
> On Tue, Apr 2, 2013 at 12:26 AM, Mark <mark...@gmail.com> wrote:
>>
>> Hi,
>>
>> I stumbled upon this payment library: http://ci-merchant.org/ which
>> abstracts the different payment backends away and exposes a new easy
>> to use interface for the app developer to use. Thus making it very
>> easy to use different payment providers.
>>
>> I was wondering if something like that is also existing for
>> authentication? For example, in authentication you have quite a few
>> different ones:
>> - Mozilla Persona
>> - openid
>> - facebook connect
>> - google (openid?)
>> - use/pass based authentication (a.k.a. the self made version that
>> every dev begins with)
>> - oauth
>> - twitter connect
>> - etc...
>>
>> Is there such a library in existence? I'm especially looking for one
>> with mozilla persona implemented.
>>
>> Kind regards,
>> Mark
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>
>
> --
> Badea Sorin (unu.sorin)
> sorin.bade...@gmail.com
> unu_so...@yahoo.com
> Pagina personala:
> http://badeasorin.com
I couldn't find it on google thus i asked in the one place where - if
it exists - people would probably know. I find it quite surprising
that a library like this isn't in existence yet. I can imagine tons of
sites would certainly benefit from having one generic interface to
use.
Anyway, thank you for your pointer and reply. If you (or anyone else)
finds a lib for this, please don't hesitate to post it in here. :)
--- End Message ---
--- Begin Message ---
I started building one at my last job, though it was part of a framework I
was developing. I knew I was going to need to authenticate against both
LDAP and old-fashioned database username/md5-password columns. (Ah, legacy
user databases.)
If it would be useful, I could dig out what I had and try to make it into a
stand-alone set of functions, but I never got further than those two
options. Basically there was a script that took in a username and password
from a web form, then looked at a config file to decide which set of the
sub-functions to use. For a DB, it checked to see if the username and
hashed password matched a row in the database; for LDAP, it did some
re-encoding to handle the weird encrypt that our OpenLDAP server used, then
ran through the process of checking to see if the user actually had that as
their password.
Like I said, let me know if anyone wants to see it... I'm unemployed right
now, and a project to work on this week (or next... this week is kind of
busy) might be a good thing.
-Andy McKenzie
On Mon, Apr 1, 2013 at 6:49 PM, Mark <mark...@gmail.com> wrote:
> On Tue, Apr 2, 2013 at 12:27 AM, Sorin Badea <sorin.bade...@gmail.com>
> wrote:
> > Hi Mark,
> > I think a simple Google search would be faster. Anyway, an unified way
> for
> > 3rd party authentication doesn't exist from my knowledge, but for Persona
> > you could use the sample from mozilla github account
> > https://github.com/mozilla/browserid-cookbook .
> >
> > Good luck,
> > Sorin!
> >
> >
> > On Tue, Apr 2, 2013 at 12:26 AM, Mark <mark...@gmail.com> wrote:
> >>
> >> Hi,
> >>
> >> I stumbled upon this payment library: http://ci-merchant.org/ which
> >> abstracts the different payment backends away and exposes a new easy
> >> to use interface for the app developer to use. Thus making it very
> >> easy to use different payment providers.
> >>
> >> I was wondering if something like that is also existing for
> >> authentication? For example, in authentication you have quite a few
> >> different ones:
> >> - Mozilla Persona
> >> - openid
> >> - facebook connect
> >> - google (openid?)
> >> - use/pass based authentication (a.k.a. the self made version that
> >> every dev begins with)
> >> - oauth
> >> - twitter connect
> >> - etc...
> >>
> >> Is there such a library in existence? I'm especially looking for one
> >> with mozilla persona implemented.
> >>
> >> Kind regards,
> >> Mark
> >>
> >> --
> >> PHP General Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >
> >
> >
> > --
> > Badea Sorin (unu.sorin)
> > sorin.bade...@gmail.com
> > unu_so...@yahoo.com
> > Pagina personala:
> > http://badeasorin.com
>
> I couldn't find it on google thus i asked in the one place where - if
> it exists - people would probably know. I find it quite surprising
> that a library like this isn't in existence yet. I can imagine tons of
> sites would certainly benefit from having one generic interface to
> use.
>
> Anyway, thank you for your pointer and reply. If you (or anyone else)
> finds a lib for this, please don't hesitate to post it in here. :)
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Hi All,
I have a strange problem with php-fpm, I checkd lots of document, but I
can't fix it.
I'm using a Freebsd 91 server to host my website. Nginx and php-fpm 5.4.13
and mysql are using.
The hardware of my server is
12Core CPUs,
32G memory
6 HDD used as a Raidz2 array to host website
2 SSD used as a mirror array to host Database
After I upgrade from 5.4.11 o 5.4.13, I got below problem.
Usually, my system is in below status:(top)
last pid: 52977; load averages: 4.70, 4.66,
5.55
301 processes: 2 running, 299 sleeping
CPU: 6.5% user, 0.0% nice, 6.3% system, 0.9% interrupt, 86.3% idle
Mem: 7029M Active, 11G Inact, 12G Wired, 1076M Cache, 399M Free
ARC: 8412M Total, 3190M MFU, 1763M MRU, 624K Anon, 209M Header, 3249M Other
Swap: 36G Total, 145M Used, 36G Free
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
52728 www 1 25 0 150M 35564K accept 13 0:01 5.86% php-fpm
52735 www 1 25 0 150M 35416K accept 16 0:01 5.76% php-fpm
52740 www 1 25 0 150M 37668K accept 14 0:01 5.66% php-fpm
52739 www 1 24 0 150M 36424K accept 12 0:01 5.66% php-fpm
52708 www 1 24 0 150M 36324K accept 10 0:01 5.66% php-fpm
52724 www 1 24 0 150M 37740K select 16 0:01 5.57% php-fpm
52714 www 1 25 0 150M 36952K accept 21 0:01 5.57% php-fpm
52719 www 1 25 0 150M 37252K accept 23 0:01 5.57% php-fpm
52717 www 1 25 0 150M 39004K accept 12 0:01 5.57% php-fpm
52734 www 1 25 0 150M 37720K accept 18 0:01 5.57% php-fpm
52726 www 1 24 0 150M 37308K accept 23 0:01 5.47% php-fpm
52737 www 1 25 0 150M 37832K accept 14 0:01 5.37% php-fpm
52721 www 1 25 0 150M 36548K accept 22 0:01 5.37% php-fpm
52710 www 1 25 0 154M 38792K accept 16 0:01 5.37% php-fpm
52723 www 1 25 0 150M 35768K accept 10 0:01 5.37% php-fpm
But sometimes, I found a php-fpm will take up about 25%+ cpu resource, then
the cpu usage of php-fpm will get increased one by one. Then php-fpm will
take up all CPU resources.
Like below:
last pid: 54212; load averages: 75.83, 75.55,
75.73
up 3+10:47:39 10:27:53
301 processes: 6 running, 295 sleeping
CPU: 6.8% user, 0.0% nice, 95.2% system, 0.7% interrupt, 0.0% idle
Mem: 7021M Active, 11G Inact, 12G Wired, 1358M Cache, 561M Free
ARC: 8525M Total, 3438M MFU, 1619M MRU, 1866K Anon, 213M Header, 3253M Other
Swap: 36G Total, 145M Used, 36G Free
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
53939 www 1 31 0 150M 33096K accept 22 0:01 28.59%
php-fpm
53941 www 1 31 0 154M 38144K accept 20 0:01 28.40%
php-fpm
53938 www 1 30 0 150M 32816K accept 3 0:01 27.57%
php-fpm
53677 www 1 52 0 150M 28440K accept 2 0:04 26.49%
php-fpm
53948 www 1 27 0 150M 28964K accept 19 0:01 24.69%
php-fpm
53947 www 1 26 0 150M 29272K accept 8 0:01 24.05%
php-fpm
53951 www 1 25 0 150M 31208K accept 17 0:01 23.86%
php-fpm
53953 www 1 24 0 150M 35300K accept 15 0:00 23.86%
php-fpm
53950 www 1 25 0 150M 28268K accept 2 0:00 23.76%
php-fpm
53954 www 1 24 0 150M 35476K accept 19 0:00 23.76%
php-fpm
53955 www 1 24 0 150M 31292K accept 21 0:00 23.76%
php-fpm
53956 www 1 24 0 150M 34064K accept 19 0:00 23.66%
php-fpm
53962 www 1 24 0 150M 33224K CPU9 9 0:00 23.66%
php-fpm
53960 www 1 24 0 150M 33548K CPU17 17 0:00 23.66%
php-fpm
Below is the php-fpm.slow.
[01-Apr-2013 16:46:52] WARNING: [pool www] child 96623, script
'/web/www/forum.php' (request: "GET /forum.php") executing too slow
(30.661218 sec), logging
[01-Apr-2013 16:46:52] WARNING: [pool www] child 96620, script
'/web/www/forum.php' (request: "GET /forum.php") executing too slow
(31.778921 sec), logging
[01-Apr-2013 16:46:52] NOTICE: child 96764 stopped for tracing
[01-Apr-2013 16:46:52] NOTICE: about to trace 96764
[01-Apr-2013 16:46:52] NOTICE: finished trace of 96764
[01-Apr-2013 16:46:52] NOTICE: child 96763 stopped for tracing
[01-Apr-2013 16:46:52] NOTICE: about to trace 96763
[01-Apr-2013 16:46:52] ERROR: failed to ptrace(PT_IO) pid 96763: Bad
address (14)
[01-Apr-2013 16:46:52] NOTICE: finished trace of 96763
[01-Apr-2013 16:46:52] NOTICE: child 96762 stopped for tracing
[01-Apr-2013 16:46:52] NOTICE: about to trace 96762
[01-Apr-2013 16:46:52] NOTICE: finished trace of 96762
[01-Apr-2013 16:46:52] NOTICE: child 96761 stopped for tracing
[01-Apr-2013 16:46:52] NOTICE: about to trace 96761
The only way to fix this issue is to restart php-fpm.
At first, I though it's a mysql error, but I monitorred mysql process, and
I found that there is no slowlog. I tried to reinstall php, but this issue
still exist.
Can anyone help on this issue?
--- End Message ---
