Bug #69632 [Fbk->Csd]: undefined symbol: lo_truncate64

Edit report at https://bugs.php.net/bug.php?id=69632&edit=1 ID: 69632 User updated by: kaveh at plutoz dot com Reported by: kaveh at plutoz dot com Summary: undefined symbol: lo_truncate64 -Status: Feedback +Status: Closed Type: Bug Package: PostgreSQL related Operating System: fedora 21 PHP Version: 5.6.8 Assigned To: yohgaki Block user comment: N Private report: N New Comment: Yup, I have the packages from http://www.postgresql.org/ . I had version 9.1 (postgresql91-libs-9.1.3-1PGDG.f16 ). After reading your comment and upgrading it to version 9.4, not to mention one that is packaged for my current OS (postgresql94-libs.x86_64 0:9.4.1-1PGDG.f21) the warning disappeared. thanks for the hint, and sorry for taking your time. Previous Comments: ------------------------------------------------------------------------ [2015-05-13 23:40:27] yohgaki@php.net [yohgaki@dev phpsec]$ php -m | grep pgsql pdo_pgsql pgsql [yohgaki@dev phpsec]$ php -v PHP 5.6.8 (cli) (built: Apr 16 2015 13:32:01) Copyright (c) 1997-2015 The PHP Group Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2015, by Zend Technologies [yohgaki@dev phpsec]$ phpenv versions * system (set by /home/yohgaki/.phpenv/version) 5.4.37 5.5.21 5.6.0 5.6.5 [yohgaki@dev phpsec]$ rpm -q postgresql-libs postgresql-libs-9.3.6-1.fc21.x86_64 I guess you have custom postgresql installation. ------------------------------------------------------------------------ [2015-05-13 22:18:39] yohgaki@php.net Strange. I think it's packaging problem, but I'll check it. ------------------------------------------------------------------------ [2015-05-13 22:12:23] kaveh at plutoz dot com Description: ------------ I am not sure exactly when this has happened but recently I am getting this warning for which I can't find any existing report or relevant post on line: [root@km php.d]# php -v PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pgsql.so' - /usr/lib64/php/modules/pgsql.so: undefined symbol: lo_truncate64 in Unknown on line 0 Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pgsql.so' - /usr/lib64/php/modules/pgsql.so: undefined symbol: lo_truncate64 in Unknown on line 0 PHP 5.6.8 (cli) (built: Apr 16 2015 13:32:01) Copyright (c) 1997-2015 The PHP Group Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2015, by Zend Technologies with Xdebug v2.3.2, Copyright (c) 2002-2015, by Derick Rethans [root@km php.d]# yum info php-pgsql Loaded plugins: langpacks Installed Packages Name : php-pgsql Arch : x86_64 Version : 5.6.8 Release : 1.fc21 Size : 370 k Repo : installed From repo : updates Summary : A PostgreSQL database module for PHP URL : http://www.php.net/ License : PHP Description : The php-pgsql package add PostgreSQL database support to PHP. : PostgreSQL is an object-relational database management : system that supports almost all SQL constructs. PHP is an : HTML-embedded scripting language. If you need back-end support for : PostgreSQL, you should install this package in addition to the main : php package. [root@km php.d]# uname -a Linux km.office 3.19.7-200.fc21.x86_64 #1 SMP Thu May 7 22:00:21 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux If it helps, I get the same thing without xdebug as well. I also have the pdo installed, and mysql connection through pdo works without any issue. Expected result: ---------------- no warning in the output. Actual result: -------------- get a warning saying : /usr/lib64/php/modules/pgsql.so: undefined symbol: lo_truncate64 in Unknown on line 0 ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=69632&edit=1