One of my MySQL 5.7.12 instances refused to start after upgrading to FreeBSD’s MySQL port version 5.7.12_1, claiming:
2016-05-18T11:03:26.688719Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 8192 pages, max 0 (relevant if non-zero) pages!
“Googling” the error message led me to http://sharadchhetri.com/2014/11/29/upgrading-mysql-5-1-5-6-service-failed-start/. I added the following line to the
[mysqld] section in
innodb_data_file_path = ibdata1:10M:autoextend
At least MySQL is happy.
From the error message I deduced that the current
ibdata1 file has a length equal to 4864 pages × 16 KiB/page = 77824 KiB = 76 MiB, while MySQL 5.7.12 expects this to be at least 8192 pages × 16 KiB/page = 131072 KiB = 128 MiB. The current length was confirmed by running
ls -l /var/db/mysql/ibdata1:
-rw-r----- 1 mysql mysql 79691776 18 mai 13:03 /var/db/mysql/ibdata1
In the long run it’s better to retire the old
/var/db/mysql/my.cnf in favour of the “new”
I too was bitten by the
portupgrade uninstall error, due to broken pipes, on my laptop running FreeBSD/amd64 stable/10. Others have identified the
file 5.26 utility as the culprit, introduced in
stable/10 as r298920.
Watch PR 209211 for any progress.
base/head was corrected at r299234, and
stable/10 will follow soon. Continue reading portupgrade uninstall error, broken pipe
All FreeBSD systems under my care got upgraded last Friday to fix some NTP bugs. That upgrade introduced a new bug in the kernel. The bug first appeared at r298004 in
base/head, and later at r298134 in
base/stable/10. The i386-based systems were more notably affected than the amd64-based systems, as the former typically has less memory than the latter. Continue reading Memory leaks in recent stable/10 kernel
Brandon J. Wandersee’s recent post on the FreeBSD Questions mailling list pointed me to Matthew Fuller‘s BSD vs Linux. Enjoy!
You should replace every mention of “CVS”, “CVSup”, and “pkg_*” with “Subversion” (SVN), “SVNup”, and “pkg *”, respectively. I.e., the command
pkg_add becomes the command
pkg add (with no underscore), etc.
KBDMUX_DFLT_KEYMAP is available for those of us using keyboard layouts different from the US/UK keyboard layout. This is very handy when running in single-user mode. Continue reading
KBDMUX_DFLT_KEYMAP is available for
I learned ZFS hides certain filesystem and pool properties from normal view. You need to know their names and specify them explicitly to get their values. Use the option
-p to get the raw value of the filesystem properties. E.g.
zfs get -p createtxg. Continue reading Hidden properties in ZFS
I spent some days last week converting our 32-bit AMANDA server to a 64-bit counterpart using spare but aged hardware. The former AMANDA server ran on very aged hardware in comparison. Going 64-bit also ment turning to ZFS-based storage.
Today, I replaced the two 320 GB first generation SATA drives with two 1 TB third generation SATA drives. The new drives, like their predecessors, are connected to the second generation SATA controller on the motherboard. Replacing the drives is nevertheless an improvement. Continue reading Replacing drives on AMANDA server
GnuPG 2.1.11 was recently added to the FreeBSD ports collection, in r409152. Deselecting the NLS option breaks the building of GnuPG. Continue reading security/gnupg breaks when deselecting NLS option
All commands were done as the
root user unless indicated.
su -l pgsql
pg_dumpall | bzip2 -9c > all-db-9.4.6-2016-02-17.sql.bz2
chmod 0600 all-db-9.4.6-2016-02-17.sql.bz2
make -C /usr/ports/databases/postgresql95-server config-recursive
pkg delete databases/postgresql94-contrib
portupgrade -fpvo databases/postgresql95-client databases/postgresql94-client
portupgrade -Nfpv databases/postgresql95-contrib
portupgrade -fpvo databases/postgresql95-server databases/postgresql94-server
portupgrade -fprv -x databases/postgresql95-client -x databases/postgresql95-server -x databases/postgresql95-contrib databases/postgresql95-client
mv /usr/local/pgsql/data /usr/local/pgsql/data0
su -l pgsql -c 'mkdir /usr/local/pgsql/data'
su -l pgsql
bzcat all-db-9.4.6-2016-02-17.sql.bz2 | psql -f - template1
# Transfer all relevant settings from /usr/local/pgsql/data0 to /usr/local/pgsql/data for pg_hba.conf and postgresql.conf
su -l pgsql
pg_dumpall | bzip2 -9c > all-db-9.5.1-2016-02-17.sql.bz2
chmod 0600 all-db-9.5.1-2016-02-17.sql.bz2
rm -R /usr/local/pgsql/data0
graphics/py-graphviz was renamed to
graphics/py-pygraphviz in r408353. Run these two commands to get back on track:
portupgrade -fpvo graphics/py-pygraphviz graphics/py-graphviz
portupgrade -fprvx graphics/py-pygraphviz graphics/py-pygraphviz