maria-discuss team mailing list archive

[Erik de Waard <erikdewaard@xxxxxxxxx>]

Hello,

When upgrading from 10.1.16 to 10.1.17 on Debian Jessie i've received the
following error:

aptitude upgrade
<snip>
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
Processing triggers for libc-bin (2.19-18+deb8u4) ...
Errors were encountered while processing:
 mariadb-server-10.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mariadb-server-10.1

Current status: 0 updates [-14]
<snip>

/var/log/syslog
mysqld_safe[44689]: ERROR: 1136  Column count doesn't match value count at
row 1

Was able to fix by running.
/usr/sbin/mysqld --skip-grant --general-log &

And running the upgrade again.

See attached full logs.

The following packages will be upgraded: 
  galera-3 icinga2 icinga2-bin icinga2-common icinga2-doc libicinga2 libmariadbclient18 libmysqlclient18 
  mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 
  mysql-common 
14 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 23.5 MB of archives. After unpacking 1,190 kB will be used.
Do you want to continue? [Y/n/?] y
Get: 1 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main galera-3 amd64 25.3.17-jessie [7,403 kB]
Get: 2 http://debmon.org/debmon/ debmon-jessie/main icinga2 amd64 2.5.4-1~debmon8+2 [51.4 kB]
Get: 3 http://debmon.org/debmon/ debmon-jessie/main icinga2-bin amd64 2.5.4-1~debmon8+2 [91.1 kB]
Get: 4 http://debmon.org/debmon/ debmon-jessie/main libicinga2 amd64 2.5.4-1~debmon8+2 [2,694 kB]
Get: 5 http://debmon.org/debmon/ debmon-jessie/main icinga2-common all 2.5.4-1~debmon8+2 [89.2 kB]
Get: 6 http://debmon.org/debmon/ debmon-jessie/main icinga2-doc all 2.5.4-1~debmon8+2 [280 kB]
Get: 7 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main libmariadbclient18 amd64 10.1.17+maria-1~jessie [588 kB]
Get: 8 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main libmysqlclient18 amd64 10.1.17+maria-1~jessie [2,940 B]
Get: 9 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mysql-common all 10.1.17+maria-1~jessie [8,542 B]
Get: 10 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-common all 10.1.17+maria-1~jessie [3,278 B]
Get: 11 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-client-core-10.1 amd64 10.1.17+maria-1~jessie [693 kB]
Get: 12 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-client-10.1 amd64 10.1.17+maria-1~jessie [1,107 kB]
Get: 13 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-server-core-10.1 amd64 10.1.17+maria-1~jessie [4,389 kB]
Get: 14 http://mirror.i3d.net/pub/mariadb/repo/10.1/debian/ jessie/main mariadb-server-10.1 amd64 10.1.17+maria-1~jessie [6,129 kB]
Fetched 23.5 MB in 0s (30.8 MB/s)           
Preconfiguring packages ...
(Reading database ... 47559 files and directories currently installed.)
Preparing to unpack .../galera-3_25.3.17-jessie_amd64.deb ...
Unpacking galera-3 (25.3.17-jessie) over (25.3.15-jessie) ...
Preparing to unpack .../libmariadbclient18_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking libmariadbclient18 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../libmysqlclient18_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking libmysqlclient18 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../mysql-common_10.1.17+maria-1~jessie_all.deb ...
Unpacking mysql-common (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../mariadb-common_10.1.17+maria-1~jessie_all.deb ...
Unpacking mariadb-common (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../mariadb-client-core-10.1_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking mariadb-client-core-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../mariadb-client-10.1_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking mariadb-client-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../mariadb-server-core-10.1_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking mariadb-server-core-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up mysql-common (10.1.17+maria-1~jessie) ...
Setting up mariadb-common (10.1.17+maria-1~jessie) ...
(Reading database ... 47559 files and directories currently installed.)
Preparing to unpack .../mariadb-server-10.1_10.1.17+maria-1~jessie_amd64.deb ...
Unpacking mariadb-server-10.1 (10.1.17+maria-1~jessie) over (10.1.16+maria-1~jessie) ...
Preparing to unpack .../icinga2_2.5.4-1~debmon8+2_amd64.deb ...
Unpacking icinga2 (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ...
Preparing to unpack .../icinga2-bin_2.5.4-1~debmon8+2_amd64.deb ...
Unpacking icinga2-bin (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ...
Preparing to unpack .../libicinga2_2.5.4-1~debmon8+2_amd64.deb ...
Unpacking libicinga2 (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ...
Preparing to unpack .../icinga2-common_2.5.4-1~debmon8+2_all.deb ...
Unpacking icinga2-common (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ...
Preparing to unpack .../icinga2-doc_2.5.4-1~debmon8+2_all.deb ...
Unpacking icinga2-doc (2.5.4-1~debmon8+2) over (2.4.10-1~debmon8+1) ...
Processing triggers for systemd (215-17+deb8u4) ...
Processing triggers for man-db (2.7.0.2-5) ...
Setting up galera-3 (25.3.17-jessie) ...
Setting up icinga2-common (2.5.4-1~debmon8+2) ...
Installing new version of config file /etc/icinga2/features-available/gelf.conf ...
Installing new version of config file /etc/icinga2/icinga2.conf ...
Setting up libicinga2 (2.5.4-1~debmon8+2) ...
Setting up icinga2-bin (2.5.4-1~debmon8+2) ...
Setting up icinga2 (2.5.4-1~debmon8+2) ...
Setting up icinga2-doc (2.5.4-1~debmon8+2) ...
Setting up libmysqlclient18 (10.1.17+maria-1~jessie) ...
Setting up libmariadbclient18 (10.1.17+maria-1~jessie) ...
Setting up mariadb-client-core-10.1 (10.1.17+maria-1~jessie) ...
Setting up mariadb-client-10.1 (10.1.17+maria-1~jessie) ...
Setting up mariadb-server-core-10.1 (10.1.17+maria-1~jessie) ...
Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
Processing triggers for libc-bin (2.19-18+deb8u4) ...
Errors were encountered while processing:
 mariadb-server-10.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ...
dpkg: error processing package mariadb-server-10.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mariadb-server-10.1
                                         
Current status: 0 updates [-14].

Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] /usr/sbin/mysqld: Normal shutdown
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569831168 [Note] Slave SQL thread exiting, replication stopped in log 'node100-bin.005425' at position 316493939
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] Event Scheduler: Purging the queue. 0 events
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [Note] Slave I/O thread exiting, read up to log 'node100-bin.005436', position 601224429
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509970724608 [Note] InnoDB: FTS optimize thread exiting.
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] InnoDB: Starting shutdown...
Sep  1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509987510016 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool
Sep  1 12:36:42 node438 mysqld[2057]: 2016-09-01 12:36:42 139509987510016 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:36:42
Sep  1 12:37:43 node438 mysqld[2057]: 2016-09-01 12:37:43 139676569564928 [Note] InnoDB: Shutdown completed; log sequence number 392840234947
Sep  1 12:37:50 node438 mysqld[2057]: 2016-09-01 12:37:50 139676569564928 [Note] /usr/sbin/mysqld: Shutdown complete
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 44714 ...
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: The InnoDB memory heap is disabled
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Compressed tables use zlib 1.2.8
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using Linux native AIO
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using SSE crc32 instructions
Sep  1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Initializing buffer pool, size = 141.0G
Sep  1 12:41:06 node438 mysqld_safe[44689]: 2016-09-01 12:41:06 140538167474112 [Note] InnoDB: Completed initialization of buffer pool
Sep  1 12:41:07 node438 mysqld_safe[44689]: 2016-09-01 12:41:07 140538167474112 [Note] InnoDB: Highest supported file format is Barracuda.
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: 128 rollback segment(s) are active.
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: Waiting for purge to start
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840234947
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Note] InnoDB: Dumping buffer pool(s) not yet started
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
Sep  1 12:41:10 node438 mysqld_safe[44689]: ERROR: 1136  Column count doesn't match value count at row 1
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [ERROR] Aborting
Sep  1 12:41:10 node438 mysqld_safe[44689]: 
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:10 (/data/mysql/data/ib_buffer_pool was empty)
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool
Sep  1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:10
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: Installation of system tables failed!  Examine the logs in
Sep  1 12:41:17 node438 mysqld_safe[44689]: /data/mysql/data for more information.
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: The problem could be conflicting information in an external
Sep  1 12:41:17 node438 mysqld_safe[44689]: my.cnf files. You can ignore these by doing:
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]:     shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: You can also try to start the mysqld daemon with:
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]:     shell> /usr/sbin/mysqld --skip-grant --general-log &
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: and use the command line tool /usr/bin/mysql
Sep  1 12:41:17 node438 mysqld_safe[44689]: to connect to the mysql database and look at the grant tables:
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]:     shell> /usr/bin/mysql -u root mysql
Sep  1 12:41:17 node438 mysqld_safe[44689]:     mysql> show tables;
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: Try 'mysqld --help' if you have problems with paths.  Using
Sep  1 12:41:17 node438 mysqld_safe[44689]: --general-log gives you a log in /data/mysql/data that may be helpful.
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: The latest information about mysql_install_db is available at
Sep  1 12:41:17 node438 mysqld_safe[44689]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Sep  1 12:41:17 node438 mysqld_safe[44689]: MariaDB is hosted on launchpad; You can find the latest source and
Sep  1 12:41:17 node438 mysqld_safe[44689]: email lists at http://launchpad.net/maria
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:17 node438 mysqld_safe[44689]: Please check all of the above before submitting a bug report
Sep  1 12:41:17 node438 mysqld_safe[44689]: at http://mariadb.org/jira
Sep  1 12:41:17 node438 mysqld_safe[44689]: 
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 45049 ...
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: The InnoDB memory heap is disabled
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Compressed tables use zlib 1.2.8
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using Linux native AIO
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using SSE crc32 instructions
Sep  1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Initializing buffer pool, size = 141.0G
Sep  1 12:41:23 node438 mysqld_safe[45024]: 2016-09-01 12:41:23 139747651045312 [Note] InnoDB: Completed initialization of buffer pool
Sep  1 12:41:24 node438 mysqld_safe[45024]: 2016-09-01 12:41:24 139747651045312 [Note] InnoDB: Highest supported file format is Barracuda.
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: 128 rollback segment(s) are active.
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: Waiting for purge to start
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840236947
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Note] InnoDB: Dumping buffer pool(s) not yet started
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool
Sep  1 12:41:27 node438 mysqld_safe[45024]: ERROR: 1136  Column count doesn't match value count at row 1
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [ERROR] Aborting
Sep  1 12:41:27 node438 mysqld_safe[45024]: 
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:27
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool
Sep  1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:27
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: Installation of system tables failed!  Examine the logs in
Sep  1 12:41:35 node438 mysqld_safe[45024]: /data/mysql/data for more information.
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: The problem could be conflicting information in an external
Sep  1 12:41:35 node438 mysqld_safe[45024]: my.cnf files. You can ignore these by doing:
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]:     shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: You can also try to start the mysqld daemon with:
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]:     shell> /usr/sbin/mysqld --skip-grant --general-log &
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: and use the command line tool /usr/bin/mysql
Sep  1 12:41:35 node438 mysqld_safe[45024]: to connect to the mysql database and look at the grant tables:
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]:     shell> /usr/bin/mysql -u root mysql
Sep  1 12:41:35 node438 mysqld_safe[45024]:     mysql> show tables;
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: Try 'mysqld --help' if you have problems with paths.  Using
Sep  1 12:41:35 node438 mysqld_safe[45024]: --general-log gives you a log in /data/mysql/data that may be helpful.
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: The latest information about mysql_install_db is available at
Sep  1 12:41:35 node438 mysqld_safe[45024]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
Sep  1 12:41:35 node438 mysqld_safe[45024]: MariaDB is hosted on launchpad; You can find the latest source and
Sep  1 12:41:35 node438 mysqld_safe[45024]: email lists at http://launchpad.net/maria
Sep  1 12:41:35 node438 mysqld_safe[45024]: 
Sep  1 12:41:35 node438 mysqld_safe[45024]: Please check all of the above before submitting a bug report
Sep  1 12:41:35 node438 mysqld_safe[45024]: at http://mariadb.org/jira
Sep  1 12:41:35 node438 mysqld_safe[45024]: 

# Maintained through Puppet

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
syslog

[mysql]

# CLIENT #
port                           = 3306
socket		= /var/run/mysqld/mysqld.sock

[mysqld]
server-id = 100000123
skip-name-resolve
binlog_format = MIXED


innodb_buffer_pool_load_at_startup = ON
innodb_buffer_pool_dump_at_shutdown = ON

# GENERAL #
user                           = mysql

# TokuDB #
tokudb_row_format = tokudb_lzma
plugin-load-add=ha_tokudb.so
tokudb_cache_size =141G

default_storage_engine         = InnoDB

socket		= /var/run/mysqld/mysqld.sock
pid-file	= /tmp/mysql.pid

# MyISAM #
key_buffer_size                = 80M
myisam_recover_options         = BACKUP,FORCE
myisam_sort_buffer_size = 64M

# SAFETY #
max_allowed_packet             = 32M
max_connect_errors             = 500
sysdate_is_now                 = 1
innodb                         = FORCE

# DATA STORAGE #
datadir                        = /data/mysql/data
tmpdir                         = /data/mysql/tmp

# BINARY LOGGING #
log-bin = /data/mysql/binlogs/node438-bin
log-bin-index = /data/mysql/binlogs/node438-bin.index
expire_logs_days               = 3
sync_binlog                    = 1

# REPLICATION #
read_only                      = 1
skip_slave_start               = 1
log_slave_updates              = 1
relay-log = /data/mysql/binlogs/node438-relay-bin
relay-log-index = /data/mysql/binlogs/node438-relay-bin.index

# CACHES AND LIMITS #
tmp_table_size                 = 32M
max_heap_table_size            = 32M
query_cache_type               = 0
query_cache_size               = 0
max_connections                = 2000
query_cache_min_res_unit = 2K
connect_timeout		= 10
thread_cache_size              = 100
open_files_limit               = 65535
table_definition_cache         = 4096
table_open_cache               = 3072
sort_buffer_size	= 2M
read_buffer_size	= 1M
max_allowed_packet	= 32M
thread_stack		= 256K



# INNODB #
innodb_data_home_dir		= /data/mysql/data
innodb_data_file_path		= ibdata1:10M:autoextend
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size           = 512M
innodb_log_group_home_dir 	= /data/mysql/data
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 141G
innodb_log_buffer_size		= 25M
innodb_read_io_threads = 8
innodb_write_io_threads = 8


innodb_file_format = Barracuda

innodb_stats_on_metadata = 0

# LOGGING #
log_queries_not_using_indexes  = 1
slow_query_log                 = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1


[mysqldump]
quick
quote-names
max_allowed_packet	= 32M

[isamchk]
key_buffer_size		= 16M