from:"maxcamo at gmail dot com"

#47580 [NoF-Opn]: MSSQL: Changed database context to when connecting

2009-06-13 Thread maxcamo at gmail dot com

 ID:   47580
 User updated by:  maxcamo at gmail dot com
 Reported By:  maxcamo at gmail dot com
-Status:   No Feedback
+Status:   Open
 Bug Type: MSSQL related
 Operating System: Win2003
 PHP Version:  5.2CVS-2009-03-05 (snap)
 New Comment:

I've tried but i get the same problem

Can be related to mssql time_wait tcp/ip?

Thx

Massimo


Previous Comments:


[2009-06-02 01:00:01] 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.



[2009-05-25 19:46:59] ka...@php.net

Have you tried to change the severity with mssql_min_message_severity?
Error 5701 (Changed database context to) is at severity 10.



[2009-03-25 16:51:53] maxcamo at gmail dot com

ok but i can't connect to the db,

chaging the script like this
if ($connDb)
mssql_select_db($db, $connDb);
else
$lastmsg=mssql_get_last_message()

and...

fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.$lastmsg. :: . $pageName . \r\n);

i dont' get any mssql errors, but i get the same problem

I see this error randomly, or on heavy load, i think



[2009-03-09 07:32:52] maxcamo at gmail dot com

ok but i can't connect to the db,

chaging the script like this
if ($connDb)
mssql_select_db($db, $connDb);
else
$lastmsg=mssql_get_last_message()

and...

fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.$lastmsg. :: . $pageName . \r\n);

i dont' get any mssql errors, but i get the same problem

I see this error randomly, or on heavy load, i think



[2009-03-08 14:30:50] ka...@php.net

This is an informal notice from dblib, Microsoft's TechNet have
information about this here:
http://technet.microsoft.com/en-us/library/aa275768(SQL.80).aspx



The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/47580

-- 
Edit this bug report at http://bugs.php.net/?id=47580edit=1

#47580 [Csd-Opn]: MSSQL: Changed database context to when connecting

2009-03-25 Thread maxcamo at gmail dot com

 ID:   47580
 User updated by:  maxcamo at gmail dot com
 Reported By:  maxcamo at gmail dot com
-Status:   Closed
+Status:   Open
 Bug Type: MSSQL related
 Operating System: Win2003
 PHP Version:  5.2CVS-2009-03-05 (snap)
 New Comment:

ok but i can't connect to the db,

chaging the script like this
if ($connDb)
mssql_select_db($db, $connDb);
else
$lastmsg=mssql_get_last_message()

and...

fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.$lastmsg. :: . $pageName . \r\n);

i dont' get any mssql errors, but i get the same problem

I see this error randomly, or on heavy load, i think


Previous Comments:


[2009-03-09 07:32:52] maxcamo at gmail dot com

ok but i can't connect to the db,

chaging the script like this
if ($connDb)
mssql_select_db($db, $connDb);
else
$lastmsg=mssql_get_last_message()

and...

fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.$lastmsg. :: . $pageName . \r\n);

i dont' get any mssql errors, but i get the same problem

I see this error randomly, or on heavy load, i think



[2009-03-08 14:30:50] ka...@php.net

This is an informal notice from dblib, Microsoft's TechNet have
information about this here:
http://technet.microsoft.com/en-us/library/aa275768(SQL.80).aspx



[2009-03-05 21:27:58] maxcamo at gmail dot com

Description:

Hi,

with MSSQL 2005,Apache 2.2.11 and PHP 5.2.6 i get this error when i 
try to connect to the db

Changed database context to

The error raise up when I try to connect to the DB.

connections timeout are high

mssql.connect_timeout = 300
mssql.timeout = 300

It happen randomly, but more frequently when the site traffic si very 
high

Reproduce code:
---
$Maxtries=60;

$delayMin=5;
$delayMax=10;
$delay=rand($delayMin,$delayMax);
$log_filename=conn_failed.log;
$tries=1;

$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

while(!$connDb){

if ($tries=$Maxtries){
//echo Database failed to respond.;
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . : Errore Connessione \r\n);
fclose($fp);
exit;
}

usleep($delay*$tries);
$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

$tries++;
}

if ($tries1){
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries ::
.$ServerName.:: .mssql_get_last_message(). :: . $pageName .
\r\n);
fclose($fp);
}



Expected result:

Db Connection

Actual result:
--
Mar 05 2009 21:08:19:: Try:2 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /index.html
Mar 05 2009 21:08:20:: Try:8 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page2.html
Mar 05 2009 21:09:26:: Try:6 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page3.html











-- 
Edit this bug report at http://bugs.php.net/?id=47580edit=1

#47580 [Csd]: MSSQL: Changed database context to when connecting

2009-03-09 Thread maxcamo at gmail dot com

 ID:   47580
 User updated by:  maxcamo at gmail dot com
 Reported By:  maxcamo at gmail dot com
 Status:   Closed
 Bug Type: MSSQL related
 Operating System: Win2003
 PHP Version:  5.2CVS-2009-03-05 (snap)
 New Comment:

ok but i can't connect to the db,

chaging the script like this
if ($connDb)
mssql_select_db($db, $connDb);
else
$lastmsg=mssql_get_last_message()

and...

fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.$lastmsg. :: . $pageName . \r\n);

i dont' get any mssql errors, but i get the same problem

I see this error randomly, or on heavy load, i think


Previous Comments:


[2009-03-08 14:30:50] ka...@php.net

This is an informal notice from dblib, Microsoft's TechNet have
information about this here:
http://technet.microsoft.com/en-us/library/aa275768(SQL.80).aspx



[2009-03-05 21:27:58] maxcamo at gmail dot com

Description:

Hi,

with MSSQL 2005,Apache 2.2.11 and PHP 5.2.6 i get this error when i 
try to connect to the db

Changed database context to

The error raise up when I try to connect to the DB.

connections timeout are high

mssql.connect_timeout = 300
mssql.timeout = 300

It happen randomly, but more frequently when the site traffic si very 
high

Reproduce code:
---
$Maxtries=60;

$delayMin=5;
$delayMax=10;
$delay=rand($delayMin,$delayMax);
$log_filename=conn_failed.log;
$tries=1;

$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

while(!$connDb){

if ($tries=$Maxtries){
//echo Database failed to respond.;
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . : Errore Connessione \r\n);
fclose($fp);
exit;
}

usleep($delay*$tries);
$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

$tries++;
}

if ($tries1){
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries ::
.$ServerName.:: .mssql_get_last_message(). :: . $pageName .
\r\n);
fclose($fp);
}



Expected result:

Db Connection

Actual result:
--
Mar 05 2009 21:08:19:: Try:2 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /index.html
Mar 05 2009 21:08:20:: Try:8 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page2.html
Mar 05 2009 21:09:26:: Try:6 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page3.html











-- 
Edit this bug report at http://bugs.php.net/?id=47580edit=1

#47580 [NEW]: MSSQL: Changed database context to when connecting

2009-03-05 Thread maxcamo at gmail dot com

From: maxcamo at gmail dot com
Operating system: Win2003
PHP version:  5.2CVS-2009-03-05 (snap)
PHP Bug Type: MSSQL related
Bug description:  MSSQL: Changed database context to when connecting

Description:

Hi,

with MSSQL 2005,Apache 2.2.11 and PHP 5.2.6 i get this error when i 
try to connect to the db

Changed database context to

The error raise up when I try to connect to the DB.

connections timeout are high

mssql.connect_timeout = 300
mssql.timeout = 300

It happen randomly, but more frequently when the site traffic si very 
high

Reproduce code:
---
$Maxtries=60;

$delayMin=5;
$delayMax=10;
$delay=rand($delayMin,$delayMax);
$log_filename=conn_failed.log;
$tries=1;

$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

while(!$connDb){

if ($tries=$Maxtries){
//echo Database failed to respond.;
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . : Errore Connessione \r\n);
fclose($fp);
exit;
}

usleep($delay*$tries);
$connDb = @mssql_connect($host, $user, $pwd));
if ($connDb)
mssql_select_db($db, $connDb);

$tries++;
}

if ($tries1){
$fp = fopen($log_filename,a+);
fputs($fp, gmdate(M d Y H:i:s) . :: Try:$tries :: 
.$ServerName.::
.mssql_get_last_message(). :: . $pageName . \r\n);
fclose($fp);
}



Expected result:

Db Connection

Actual result:
--
Mar 05 2009 21:08:19:: Try:2 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /index.html
Mar 05 2009 21:08:20:: Try:8 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page2.html
Mar 05 2009 21:09:26:: Try:6 :: B-C2N1:: Il contesto di database è 
stato sostituito con 'dbName'. :: /page3.html







-- 
Edit bug report at http://bugs.php.net/?id=47580edit=1
-- 
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47580r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47580r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47580r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47580r=fixedcvs
Fixed in CVS and need be documented: 
http://bugs.php.net/fix.php?id=47580r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47580r=alreadyfixed
Need backtrace:  
http://bugs.php.net/fix.php?id=47580r=needtrace
Need Reproduce Script:   
http://bugs.php.net/fix.php?id=47580r=needscript
Try newer version:   
http://bugs.php.net/fix.php?id=47580r=oldversion
Not developer issue: 
http://bugs.php.net/fix.php?id=47580r=support
Expected behavior:   
http://bugs.php.net/fix.php?id=47580r=notwrong
Not enough info: 
http://bugs.php.net/fix.php?id=47580r=notenoughinfo
Submitted twice: 
http://bugs.php.net/fix.php?id=47580r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47580r=globals
PHP 4 support discontinued:  http://bugs.php.net/fix.php?id=47580r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=47580r=dst
IIS Stability:   
http://bugs.php.net/fix.php?id=47580r=isapi
Install GNU Sed: 
http://bugs.php.net/fix.php?id=47580r=gnused
Floating point limitations:  
http://bugs.php.net/fix.php?id=47580r=float
No Zend Extensions:  
http://bugs.php.net/fix.php?id=47580r=nozend
MySQL Configuration Error:   
http://bugs.php.net/fix.php?id=47580r=mysqlcfg

#47580 [NoF-Opn]: MSSQL: Changed database context to when connecting

#47580 [Csd-Opn]: MSSQL: Changed database context to when connecting

#47580 [Csd]: MSSQL: Changed database context to when connecting

#47580 [NEW]: MSSQL: Changed database context to when connecting

4 matches

Site Navigation

Mail list logo

Footer information