Bug #80258 [NEW]: Windows Deduplication Enabled, seeing randon permission errors
| From: | josh dot manchester at dirxion dot com | Date: | Mon, 19 Oct 2020 13:14:10 +0000 |
| Subject: | Bug #80258 [NEW]: Windows Deduplication Enabled, seeing randon permission errors | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-229749@lists.php.net to get a copy of this message | ||
From: josh dot manchester at dirxion dot com
Operating system: Windows 2016 Standard
PHP version: 7.4.11
Package: SQLite related
Bug Type: Bug
Bug description:Windows Deduplication Enabled, seeing randon permission errors
Description:
------------
We have Windows deduplication enabled on our 2016 servers for several
years but I think we found something out of whack with the latest PHP
version. I originally upgraded from 7.4.7 to 7.4.11, when I had problems
I then attempted to downgrade to 7.4.10 and the problem remained, but
with 7.4.9 I have no issues. While our primary web product had some
'Unable to find resource' type errors loading, the simplest example I
can provide is our health check script that we have setup for testing
Database connectivity. On versions 7.4.11 and 7.4.10 the SQLite check
fails with the error I provided under Actual Result.
I am using the Windows PHP NTS build as provided on your site. I tested
this on 2 servers, and each server would start to work if I either
downgraded to php 7.4.9, or disabled Deduplication and ran the
powershell script to unoptimize all the files.
Test script:
---------------
<?php
include 'includes/autoload.php';
//SQLite
$db_path = 'abb20htm.db3';
$db = new PDO('sqlite:'.$db_path);//connection
$bookdb3_class = new BookDb3($db);
$sgt = '3';//res
$row = $bookdb3_class->getFirstPageLabel($sgt)->getResults();
//$bookdb3_class->printOut();
//print_r($row);
$pageLabel = $row['PageLabel'];
if ($pageLabel == '1')
echo 'SQLite test succeeded';
else
echo 'SQLite test failed';
echo '<br>';
?>
Expected result:
----------------
Via a browser, we expect to see...
SQLite test succeeded
Actual result:
--------------
Note: My original health check script had some MySQL and MSSQL health
checks that I removed in my example, so line 39 is no longer accurate.
Fatal error: Uncaught PDOException: open_basedir prohibits opening
abb20htm.db3 in F:\Sites\ITMonitors\dbtests\default.php:39 Stack trace:
#0 F:\Sites\ITMonitors\dbtests\default.php(39):
PDO->__construct('sqlite:abb20htm...') #1 {main} thrown in
F:\Sites\ITMonitors\dbtests\default.php on line 39
--
Edit bug report at https://bugs.php.net/bug.php?id=80258&edit=1
--
Fix committed: https://bugs.php.net/fix.php?id=80258&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=80258&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=80258&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=80258&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=80258&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=80258&r=support
Expected behavior: https://bugs.php.net/fix.php?id=80258&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=80258&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=80258&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=80258&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=80258&r=phptooold
Daylight Savings: https://bugs.php.net/fix.php?id=80258&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=80258&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=80258&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=80258&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=80258&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=80258&r=mysqlcfg