Bug #80258 [NEW]: Windows Deduplication Enabled, seeing randon permission errors

From: 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

« previous php.bugs (#229749) next »