- discuss - lists.mariadb.org

[Maria-discuss] New Question: Upgrade (10.1.16+maria-1~jessie) broke system
by AskMonty KB 22 Jul '16

22 Jul '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by olliblum_59359. Please answer it at http://mariadb.com/kb/en/upgrade-10116maria-1jessie-broke-system/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- sudo apt-get -f install ....... Setting up mariadb-server-10.1 (10.1.16+maria-1~jessie) ... Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.1 (= 10.1.16+maria-1~jessie); however: Package mariadb-server-10.1 is not configured yet. dpkg: error processing package mariadb-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mariadb-server-10.1 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) ------------- ystemctl status mariadb.service mariadb.service - MariaDB database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Thu 2016-07-21 22:46:21 UTC; 2min 1s ago Process: 9595 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=227/NO_NEW_PRIVILEGES) Process: 9592 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 9433 ExecStartPre=/bin/sh -c VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 9429 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 9595 (code=exited, status=227/NO_NEW_PRIVILEGES) Jul 21 22:46:21 systemd[1]: mariadb.service: main process exited, code=exited, status=227/NO_NEW_PRIVILEGES Jul 21 22:46:21 systemd[1]: Failed to start MariaDB database server. Jul 21 22:46:21 systemd[1]: Unit mariadb.service entered failed state. ------- syslog Jul 21 22:49:15 systemd[1]: mariadb.service: main process exited, code=exited, status=227/NO_NEW_PRIVILEGES Jul 21 22:49:15 systemd[1]: Failed to start MariaDB database server. Jul 21 22:49:15 systemd[1]: Unit mariadb.service entered failed state. ------- I have tried so far apt-get clean system restart dpkg --configure -a dpkg --configure -f apt-get is blocked now as it always tries to configure mariadb and then fail Any ideas? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrade-10116maria-1jessie-broke-system/

1 0

[Maria-discuss] New Question: data base issue
by AskMonty KB 21 Jul '16

21 Jul '16

Hello, A new question has been asked in "MariaDB Community" by annamae_moreno_g. Please answer it at http://mariadb.com/kb/en/data-base-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hello im using xampp because im doing some web programming with php and i also using mariadb with data base . my question how can i use mariadb without using the port of mysql in xampp.. what program do i have to download so i can use this 2 products. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/data-base-issue/

1 0

[Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade
by Mark Wadham 21 Jul '16

21 Jul '16

Hi, We have a repeatable failure to initiate IST with MariaDB 10.1.14 after performing a schema upgrade on a single node in RSU mode. The error condition is when there is a delete query in the format: delete from <table> where id >= <n> on the non-RSU cluster nodes while the node is disconnected from the cluster. On rejoining the node determines that it is in sync with the other cluster nodes and no IST is performed, despite the rows that were deleted in the cluster. If we then delete the rows manually from the joining node, mysqld immediately crashes on the other nodes because they can't execute the new write transaction. The process we followed is: 1. Set up a 3-node cluster, nodes 0,1,2 2. Enable RSU on node 0: SET GLOBAL wsrep_OSU_method='RSU'; 3. Isolate node 0 from the cluster: SET GLOBAL wsrep_cluster_address="gcomm://"; 4. Perform a backward-compatible schema change, since this is the point of this process. In our test we added a single column to a table with a default value of null. Additionally we deleted some rows from a table on nodes 1 and 2, with: delete from <table> where id >= 100; which affected around 20 rows. 5. Rejoin the node to the cluster: SET GLOBAL wsrep_cluster_address="<gcomm string from config file>"; At this point the node immediately rejoins without doing IST and believes it is in sync, yet the rows are deleted on nodes 1 and 2 but not node 0. Interestingly if the delete query is: delete from <table> where id = <n>; there is no problem. Also we have not had any issue with syncing INSERT and UPDATE statements. A combination of INSERT, UPDATE and DELETE where id >= resulted in the insert/update statements being synced but the deletes not synced. It is as if the quorum somehow doesn't recognise delete where id >= as an event. Our next test cases are: 1. Switching node 0 back to TOI mode before rejoining the cluster, although I can't really see how this would make a difference. 2. Upgrading to MariaDB 10.1.16 which was released a couple of days ago. 3. Testing whether regular IST is affected, ie IST that should occur normally without switching to RSU mode or dropping a node out of the cluster. This seems like a pretty basic failure and I'm concerned that it may also affect regular IST, i.e. a node falling behind the cluster for normal reasons without any involvement of RSU mode, which would effectively make the whole system useless if it could randomly drop delete statements. If anyone can shed any light on why this may be happening we would be very grateful! Thanks, Mark

2 6

[Maria-discuss] Creating Custom Storage Engine
by Jonathan Ellithorpe 21 Jul '16

21 Jul '16

Hi All, I searched around but couldn't find documentation / tutorials on creating a custom storage backend for MariaDB. Could anyone point me in the right direction? Thanks, Jonathan

5 11

[Maria-discuss] New Question: MariaDB Installation error
by AskMonty KB 20 Jul '16

20 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-installation-error/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am getting error with ibdata1 auto extending of the files when running mysql_install_db and it fills the file with zeroes. But when i delete the ibdata and run the mysql_install_db again everything goes fine. Also the size in my.cnf file is innodb_data_file_path = ibdata1:100M:autoextend InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and 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 attempt. 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 data! How exactly to resolve the error? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-installation-error/

1 0

[Maria-discuss] Key lengths for file_key_management plugin
by Honza Horak 19 Jul '16

19 Jul '16

I've asked directly in the documentation page, but maybe someone will know answer here: https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/#comment_2346 In that article it is said that 128, 192 or 256-bit keys are supported, but later AES_CTR and AES_CBC modes talk only about 128bit keys. What piece of information am I missing? Honza

2 3

[Maria-discuss] maillist break dkim signed mails
by Benny Pedersen 18 Jul '16

18 Jul '16

but when will it stop that practice ?

2 1

[Maria-discuss] MariaDB 10.1.16 now available
by Daniel Bartholomew 18 Jul '16

18 Jul '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.16. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.16 - Release Notes: https://mariadb.com/kb/en/mdb-10116-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10116-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.16 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

2 1

[Maria-discuss] after set replicate_wild_do_table, binlog file could not update ?
by Ljr Yang 15 Jul '16

15 Jul '16

Hi, all Today, we setup new master/slave (both MariaDB 10.1.14), add log_slave_updates=1, log_bin , relay_log parameters in slave's my.cnf file. in mariadb client , execute below command, when master update, slave replication normal , and log_bin and relay_log file could update normal too. stop slave; set global replicate_wild_do_table='test01.%,mysql.%' ; start slave; IF add replicate_wild_do_table='test01.%,mysql.%' in slave's my.cnf file and restart salve, replication normal, relay_log file could update, but log_bin file could not update. we test four machines, all have the problem . Please help confirm ,thanks . Ljr

2 1

[Maria-discuss] mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable
by Umarzuki Mochlis 15 Jul '16

15 Jul '16

2 of 3 mariadb servers 10.1, ubuntu 16.04 unable to install mariadb-connect-engine-10.1 with error The following packages have unmet dependencies: mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable E: Unable to correct problems, you have held broken packages. I fould bugreport at https://jira.mariadb.org/browse/MDEV-10032 but it seems stalled? One other thing to note, apt-get upgrade does not upgrade mariadb to 10.1.15, only on the one that successfully installed mariadb-connect-engine-10.1 How do I solve this? I already tried apt-get purge mariadb* then reinstall but still same.

3 8