ID: 33737 User updated by: leon at lost dot co dot nz Reported By: leon at lost dot co dot nz Status: Open Bug Type: PDO related Operating System: Linux 2.6 / Apache2 PHP Version: PHP 5 CVS Assigned To: wez New Comment:
Tried again this morning with CVS snapshot php5-200507192230. Same install routine which, this time, created and install the .so file properly. My test script now works fine, and I can run the unit tests successfully. Big improvement! However... I'm still getting intermittent (like about half of the time I run the PDO::SQLite tests) segfaults reported in Apache's error log. Prehaps more worryingly, after trying to run the SQLite unit tests for a while, I have seen what looks like some of the apache2 stuck in infinite loops (three processs each using ~33% CPU -- I'm using the Apache2 prefork MPM with APXS2 to build PHP). Previous Comments: ------------------------------------------------------------------------ [2005-07-18 23:45:06] leon at lost dot co dot nz Hmmm... I think something screwy happened with the install of the latest snapshot, making my last (good news/bad news) report suspect. I did my usual install routine (on Debian 3.1): make apache2ctl stop make install apache2ctl start Then tested the snippet using the CLI: $ php -v PHP 5.1.0-dev (cli) (built: Jul 19 2005 08:45:23 NZ) $ php test.php $ (no segfault!) The 'bad news' came when I browsed to the unit test page normally -- but on further investigation it seems that the normal install process failed on the snapshot. For some reason 'make install' put the files libphp5.[a|la] in my /usr/lib/apache2/modules, rather than the usual libphp5.so... Has the build process changed, or have I done something stupid? ;-) ./configure --with-apxs2=/usr/bin/apxs2 \ --with-config-file-dir=/etc/php --with-mcrypt --with-gd \ --with-zlib --enable-exif --with-freetype-dir \ --with-jpeg-dir --enable-debug ------------------------------------------------------------------------ [2005-07-18 23:15:18] [EMAIL PROTECTED] Let's see the backtrace(s) for the problems here, before deciding what else to do. ------------------------------------------------------------------------ [2005-07-18 22:59:55] leon at lost dot co dot nz Just rebuilt and retested with php5-200507182030, thanks for the quick response! I've got good news and bad news: The good news is that the latest snapshot doesn't segfault on the test snippet above. The bad news is that my full unit tests still cause PHP to segfault on the SQLite tests... What would you like me to do? I could: 1) Put together another snippet and post it here 2) As above, but create a new bug report 3) Post my classes somewhere for you to look at directly Cheers, Leon ------------------------------------------------------------------------ [2005-07-18 16:49:44] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Works for me with CVS HEAD. Please try the snap dated after this message to confirm. ------------------------------------------------------------------------ [2005-07-18 01:31:49] leon at lost dot co dot nz Whew... All done... I've pared my script from > 1800 lines of PHP scattered accross 7 files to three lines in one file! Turns out to be a SQLite PDO problem... <?php $conn = new PDO('sqlite::memory:'); $sql = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;"; $conn->query($sql); ?> This snippet causes PHP5.1b3 to segfault everytime (I'm using the bundled SQLite library). One of my other unit tests still throws up that corruption I talked about before, but I'll try to isolate that and submit a brand new bug report for that. ------------------------------------------------------------------------ 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/33737 -- Edit this bug report at http://bugs.php.net/?id=33737&edit=1