ID: 15325
Comment by: sargon at tut dot by
Reported By: mike at dct-mail dot com
Status: Closed
Bug Type: MSSQL related
Operating System: Windows 2000 Server
PHP Version: 4.1.1
New Comment:
Me too! The same error.
Php ver. 4.3.1; WinXP Pro; MSSQL 2000 SP3.
Previous Comments:
------------------------------------------------------------------------
[2002-10-28 10:53:55] [EMAIL PROTECTED]
not a php extension issue...
------------------------------------------------------------------------
[2002-02-08 02:54:07] mike at dct-mail dot com
The return from mssql_query() appears to be immediate. When the call to
sleep() is present, the backup continues and completes during the
sleep() and the execution timer isn't exceeded. (I verified by using a
sleep(300) and did get the timer exceeded error.)
------------------------------------------------------------------------
[2002-02-07 23:47:50] ollie at cronky dot net
Is the backup taking longer than your max script execution time (in
php.ini) by any chance?
------------------------------------------------------------------------
[2002-02-01 11:05:06] mike at dct-mail dot com
Running the 4.1.1 binaries from php.net:
Using mssql_query() to issue a backup statement doesn't work
$conn = msssql_connect("localhost", "sa", "") or die("bad");
$sql = "BACKUP DATABASE Northwind TO DC_Northwind";
$result = mssql_query($sql, $conn);
mssql_close($conn);
sets $result to 1 and the script prints:
MS SQL message: Cannot create worker thread. (severity 16) in Unknown
on Line 0
MS SQL message: BACKUP DATABASE is terminating abnormally. (severity
16) in Unknown on Line 0
Then a dialog box reports:
The instruction at "0x100a0f9d" referenced memory at "0x00000000". The
memory cannot be "written".
SQL Profiler confirms that the backup failed.
If a sleep(25) is placed after the call to mssql_query():
1) The warning messages aren't displayed
2) The backup actually succeeds
but
3) The dialog box still appears (and the script terminates).
Using the 4.0.6 binaries from the web site the backup behaves
identically, BUT the dialog box does not appear and the script
terminates cleanly.
The SQL Server has all service packs installed and the backup commands
work without problem from the query analyzer or isql.exe
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=15325&edit=1
