- Queries
- All Stories
- Search
- Advanced Search
- Transactions
- Transaction Logs
All Stories
Nov 5 2017
Create empty directories after the parent volume exists
Use K for recordsize unit (see upstream task), simplify node.get per D1176
s/Examples/Example
Allow InnoDB engine to write in their directories
$ /usr/local/etc/rc.d/mysql-server start Installing MariaDB/MySQL system tables in '/var/db/mysql' ... 2017-11-05 13:57:44 34429034496 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repli ction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=ysul.nasqueron.org' or '--log-bin=mysqld-bin' to avoi d this problem. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Operating system error number 13 in a file operation. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory. 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Cannot open datafile '/var/db/mysql/mysql-innodb-data/ibdata1' 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, an d it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attemp t. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious d ata! 2017-11-05 13:57:45 34429034496 [ERROR] InnoDB: Database creation was aborted with error Cannot open a file. You may need to delete the ibdata1 file before try ing to start up again. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' init function returned error. 2017-11-05 13:57:45 34429034496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-11-05 13:57:45 34429034496 [ERROR] /usr/local/libexec/mysqld: unknown variable 'bin_log_format=MIXED' 2017-11-05 13:57:45 34429034496 [ERROR] Aborting
Proofread and improve configuration file: stop words, performance schema
$ salt-call --local state.apply roles/dbserver-mysql local: ---------- ID: mysql_server_software Function: pkg.installed Result: True Comment: All specified packages are already installed Started: 01:45:51.880169 Duration: 246.099 ms Changes: ---------- ID: arcology/mysql-innodb-data Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-data was updated Started: 01:45:52.131408 Duration: 563.66 ms Changes: ---------- arcology/mysql-innodb-data: ---------- mountpoint: /var/db/mysql/mysql-innodb-data recordsize: 16k ---------- ID: arcology/mysql-innodb-logs Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-innodb-logs was updated Started: 01:45:52.695790 Duration: 557.842 ms Changes: ---------- arcology/mysql-innodb-logs: ---------- mountpoint: /var/db/mysql/mysql-innodb-logs recordsize: 128k ---------- ID: arcology/mysql-root Function: zfs.filesystem_present Result: True Comment: filesystem arcology/mysql-root was updated Started: 01:45:53.254366 Duration: 574.172 ms Changes: ---------- arcology/mysql-root: ---------- mountpoint: /var/db/mysql/mysql-root recordsize: 8k ---------- ID: /usr/local/etc/my.cnf Function: file.managed Result: True Comment: File /usr/local/etc/my.cnf updated Started: 01:45:53.838402 Duration: 95.623 ms Duration: 95.623 ms Changes: ---------- diff: New file mode: 0644 ---------- ID: /var/run/mysqld Function: file.directory Result: True Comment: Directory /var/run/mysqld updated Started: 01:45:53.934487 Duration: 7.571 ms Changes: ---------- /var/run/mysqld: New Dir ---------- ID: /var/db/mysql Function: file.directory Result: True Comment: Directory /var/db/mysql updated Started: 01:45:53.942532 Duration: 5.229 ms Changes: ---------- group: mysql user: mysql
Nov 4 2017
I reported upstream an issue for recordsize, falsely reporting to be updated in test mode: https://github.com/saltstack/salt/issues/44404
Currently, we have all the 14 plugins packages, as we well use weechat-plugins (installed by weechat):
Fix commit range to select only MySQL
Don't use tabs for alignment. Create /var/run/mysqld.
It's currently running, I'll check dependencies and release later.
RUN apt-get install freebsd-buildutils libfl-dev fortunes && \ ln -s /usr/bin/freebsd-lex /usr/bin/lex && \ cd /opt && wget http://dereckson.devio.us/software/valspeak/valspeak-1.0.tar.gz && \ tar xzvf valspeak-1.0.tar.gz && cd valspeak-1.0 && make && ln -s /opt/valspeak-1.0/valspeak /usr/bin/valspeak && \ cd /opt && git clone https://devcentral.nasqueron.org/source/jive.git && cd jive && \ make && ln -s /opt/jive/jive /usr/bin/jive
Released at rJIVE.
Previous order
Remove \n
I can't repro anymore this issue, when I investigated to a header/body write order issue, fixed in D1169.