Solved Failed to update phpMyAdmin-4.3.7 using pkg-1.4.9

Hi,

I noticed a very strange error when updating phpMyAdmin-4.3.7:
- using pkg-1.4.6:
Code:
# portupgrade phpMyAdmin-4.3.7

[Reading data from pkg(8) ... - 216 packages found - done]

[Updating the portsdb <format:bdb_btree> in /var/db/pkg ... - 24505 port entries found .........1000.........2000.........3000.........4000.........5000.........6000.........7000.........8000.........9000.........10000.........11000.........12000.........13000.........14000.........15000.........16000.........17000.........18000.........19000.........20000.........21000.........22000.........23000.........24000..... ..... done]

--->  Upgrading 'phpMyAdmin-4.3.7' to 'phpMyAdmin-4.3.8' (databases/phpmyadmin)

...

===>   Registering installation for phpMyAdmin-4.3.8

[mx.domain.net] Installing phpMyAdmin-4.3.8...

===> Creating users and/or groups.

Using existing group 'www'.



phpMyAdmin-4.3.8 has been installed into:



    /usr/local/www/phpMyAdmin

....

===>  Cleaning for phpMyAdmin-4.3.8

--->  Cleaning out obsolete shared libraries
- using pkg-1.4.9:
Code:
# portupgrade phpMyAdmin-4.3.7

[Reading data from pkg(8) ... - 198 packages found - done]

[Updating the portsdb <format:bdb_btree> in /var/db/pkg ... - 24503 port entries found .........1000.........2000.........3000.........4000.........5000.........6000.........7000.........8000.........9000.........10000.........11000.........12000.........13000.........14000.........15000.........16000.........17000.........18000.........19000.........20000.........21000.........22000.........23000.........24000..... ..... done]

--->  Upgrading 'phpMyAdmin-4.3.7' to 'phpMyAdmin-4.3.8' (databases/phpmyadmin)

--->  Building '/usr/ports/databases/phpmyadmin'

===>  Cleaning for phpMyAdmin-4.3.8

===>  License GPLv2 accepted by the user

===>  Found saved configuration for phpMyAdmin-4.0.3

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/sbin/pkg - found

=> phpMyAdmin-4.3.8-all-languages.tar.xz doesn't seem to exist in /var/ports/distfiles/.

=> Attempting to fetch http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.3.8/phpMyAdmin-4.3.8-all-languages.tar.xz

phpMyAdmin-4.3.8-all-languages.tar.xz         100% of 5238 kB 5871 kBps 00m01s

===> Fetching all distfiles required by phpMyAdmin-4.3.8 for building

===>  Extracting for phpMyAdmin-4.3.8

=> SHA256 Checksum OK for phpMyAdmin-4.3.8-all-languages.tar.xz.

===>  Patching for phpMyAdmin-4.3.8

===>  Configuring for phpMyAdmin-4.3.8

===>  Staging for phpMyAdmin-4.3.8

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/include/php/main/php.h - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/ctype.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/session.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/filter.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mbstring.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/json.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mysqli.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/apc.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/bz2.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/gd.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mcrypt.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/openssl.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/pdf.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/xml.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/zip.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/zlib.so - found

===>   Generating temporary packing list

===> Creating users and/or groups.

====> Compressing man pages (compress-man)

--->  Backing up the old version

--->  Uninstalling the old version

[Reading data from pkg(8) ... - 198 packages found - done]

--->  Deinstalling 'phpMyAdmin-4.3.7'

Updating database digests format: 100%

Checking integrity... done (0 conflicting)

Deinstallation has been requested for the following 1 packages (of 0 packages in the universe):



Installed packages to be REMOVED:

phpMyAdmin-4.3.7



The operation will free 29 MiB.

[mx.domain.net] [1/1] Deinstalling phpMyAdmin-4.3.7...

[mx.domain.net] [1/1] Deleting files for phpMyAdmin-4.3.7: 100%

[Reading data from pkg(8) ... - 197 packages found - done]

--->  Installing the new version via the port

===>  Installing for phpMyAdmin-4.3.8

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/include/php/main/php.h - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/ctype.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/session.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/filter.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mbstring.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/json.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mysqli.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/apc.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/bz2.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/gd.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/mcrypt.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/openssl.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/pdf.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/xml.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/zip.so - found

===>   phpMyAdmin-4.3.8 depends on file: /usr/local/lib/php/20100525-zts/zlib.so - found

===>   Registering installation for phpMyAdmin-4.3.8

pkg-static: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:1494: out of memory

*** [fake-pkg] Error code 74



Stop in /basejail/usr/ports/databases/phpmyadmin.

*** [install] Error code 1



Stop in /basejail/usr/ports/databases/phpmyadmin.

*** [reinstall] Error code 1



Stop in /basejail/usr/ports/databases/phpmyadmin.

** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade20150206-37458-lzirmp env UPGRADE_TOOL=portupgrade UPGRADE_PORT=phpMyAdmin-4.3.7 UPGRADE_PORT_VER=4.3.7 make reinstall

--->  Restoring the old version

[mx.domain.net] Installing phpMyAdmin-4.3.7...

===> Creating users and/or groups.

Using existing group 'www'.

[mx.domain.net] Extracting phpMyAdmin-4.3.7: 100%

Message for phpMyAdmin-4.3.7:

phpMyAdmin-4.3.7 has been installed into:



    /usr/local/www/phpMyAdmin



Please edit config.inc.php to suit your needs.



To make phpMyAdmin available through your web site, I suggest

that you add something like the following to httpd.conf:



For Apache versions earlier than 2.4:



    Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"



    <Directory "/usr/local/www/phpMyAdmin/">

Options none

AllowOverride Limit



Order Deny,Allow

Deny from all

Allow from 127.0.0.1 .example.com

    </Directory>



For Apache version 2.4.x or above:



    Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"



    <Directory "/usr/local/www/phpMyAdmin/">

Options None

AllowOverride Limit



Require local

    Require host .example.com

    </Directory>



SECURITY NOTE: phpMyAdmin is an administrative tool that has had several

remote vulnerabilities discovered in the past, some allowing remote

attackers to execute arbitrary code with the web server's user credential.

All known problems have been fixed, but the FreeBSD Security Team strongly

advises that any instance be protected with an additional protection layer,

e.g. a different access control mechanism implemented by the web server

as shown in the example.  Do consider enabling phpMyAdmin only when it

is in use.

** Fix the installation problem and try again.

** Listing the failed packages (-:ignored / *:skipped / !:failed)

! databases/phpmyadmin (phpMyAdmin-4.3.7)(install error)
How can I fix it?
 
Code:
pkg-static: sqlite error while executing INSERT OR IGNORE INTO mtree(content) VALUES(?1) in file pkgdb.c:1494: out of memory

First things first. Have you checked this specific error out? Do you actually have enough memory on the system?
 
Searching less specifically for "out of memory" errors with sqlite suggests that this error may misleadingly appear when columns used in the query don't exist, or if the connection being used has been accidentally set to NULL. It's possible that it's a bug in pkg. Interestingly, they released 1.4.10 one day (in fact the next morning, around 12 hours) after 1.4.9.

Update to 1.4.10 and 1.4.99.10
- Fix a regression causing bus error
Of course by the time I'd finished writing this you'd already posted that the upgrade has fixed it, but I'll post this anyway.
 
Back
Top