- discuss - lists.mariadb.org

[Maria-discuss] New Question: Where is the "Restrictions and Limitations" documentation of MariaDB?
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by openiduser59. Please answer it at http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! MySQL has the "Restrictions and Limitations" documentation section: http://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/subquery-restrictio… Where is the same section of MariaDB docs? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document…

1 0

[Maria-discuss] New Question: Unable to create after insert trigger on mariadb
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "SQL Structure and Commands" by girish2477. Please answer it at http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I followed trigger instructions from documentation. When i run the script from command line, cursor does not come back. i have to kill the execution Server version: 5.5.46-MariaDB MariaDB Server Tried various formats CREATE TRIGGER company_insert AFTER INSERT ON companyMain FOR EACH ROW INSERT INTO companytest (ID, Value) VALUES (20, CONCAT(NEW.`Code`,' - ',NEW.`Name`)); ------------ DELIMITER // DROP TRIGGER IF EXISTS company_insert ; CREATE TRIGGER company_insert AFTER INSERT ON companyMainFOR EACH ROW BEGIN DECLARE vFormatID int; SET vFormatID=20; INSERT INTO companytest (ID,Value) VALUES ( vFormatID,NEW.`Name`); END; // DELIMITER; Tried running from command directly or pass as .sql file. both ways its stuck no response back on command. Have to kill. ^CCtrl-C -- query killed. Continuing normally. ERROR 1317 (70100) at line 3: Query execution was interrupted Your help will be appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/

1 0

[Maria-discuss] CONJ SSL connection with client cert and key
by Beeton, Carolyn (Carolyn) 20 Oct '15

20 Oct '15

From: Beeton, Carolyn (Carolyn) Sent: Monday, October 19, 2015 3:39 PM To: 'maria-discuss(a)lists.launchpad.net' Subject: CONJ SSL connection with client cert and key I am using the MariaDb Connector/J to connect to a remote database which requires a client cert and key in addition to the server cert. Is there any way to configure this (similar to MySql clientCertificateKeyStoreUrl)? Thanks, Carolyn

1 0

[Maria-discuss] New Question: Please update procedures to upgrade Galera cluster from MariaDB 10.0.21/22 to MariaDB 10.1.8
by AskMonty KB 19 Oct '15

19 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by robin_anil_g. Please answer it at http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It seems like wserp replication is now part of MariaDB. I would appreciate insights into correct rolling upgrade procedure for the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster…

1 0

[Maria-discuss] Moving from Launchpad lists to something else... ?
by Colin Charles 19 Oct '15

19 Oct '15

Hi, I was speaking to Otto (CEO, MariaDB Foundation) and discussing that we should move the lists from Launchpad to something else. We obviously want to preserve the archives, and this isn’t going to happen overnight (something like an aim by the end of the year). Would you be ok with running on Google Groups? Would you prefer being on Mailman? Do you have another self-hosted or (preferably free) hosted solution as your preference? Today, we have several lists (maria-discuss, maria-developers, maria-docs) that are hosted on Launchpad. We also have a few lists (ambassadors, announce, commits, mirroring, maria-buildbot-reports) hosted on Mailman at lists.askmonty.org. Let us know what you think about this Kind Regards, Colin Charles -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

6 6

[Maria-discuss] New Question: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
by AskMonty KB 17 Oct '15

17 Oct '15

Hello, A new question has been asked in "MariaDB Community" by wraith. Please answer it at http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! Being new to MariaDB, I'm unsure if this is the correct forum to pose my question. Please forgive and forward me in the right direction if it is not :) I've recently upgraded from MySQL to MariaDB on my QNAP TS-410 server and commenced using. I've recently attempted to backup my tables and have been faced with a "Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)". I've browsed the web and the "mysql_upgrade" command is regularly touted; however, this doesn't appear to be on my TS-410. I've also attempted restarting the server via the TS-410 web interface. I approached QNAP who responded they were unable to assist. Which leads me here. Has anyone encountered a similar or same scenario? And able to provide assistance in resolving? Thanks in advance -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because…

1 0

[Maria-discuss] MariaDB version string in initial handshake
by Felipe Gasper 17 Oct '15

17 Oct '15

Hi all, I’m seeing a version string like this from the server in the initial handshake: 5.5.5-10.1.16-MariaDB Why does MariaDB negotiate with a different-format version string than MySQL? Is this documented somewhere? -FG

3 2

[Maria-discuss] New Question: INSERT IGNORE refuses to ignore foreign key constraints. Bug maybe?
by AskMonty KB 15 Oct '15

15 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by stillsmil. Please answer it at http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is this a bug? INSERT IGNORE refuses to ignore ERROR 1452, as is described in http://stackoverflow.com/questions/6849393/mysqls-insert-ignore-into-foreig…. To regenerate the error: CREATE TABLE parent (id INT AUTO_INCREMENT NOT NULL , PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE child ( id INT AUTO_INCREMENT , parent_id INT , INDEX par_ind (parent_id) , PRIMARY KEY (id) , FOREIGN KEY (parent_id) REFERENCES parent(id) ) ENGINE=INNODB; INSERT INTO parent VALUES (1) (2); INSERT IGNORE INTO child VALUES (NULL, 3); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`financedb`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)) Server version: 10.0.21-MariaDB-log MariaDB Server -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr…

1 0

[Maria-discuss] New Question: Unable to build mariadb connector 2.2.0
by AskMonty KB 12 Oct '15

12 Oct '15

Hello, A new question has been asked in "MariaDB Community" by johnnyoj. Please answer it at http://mariadb.com/kb/en/unable-to-build-mariadb-connector-220/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do I debug why cmake is failing? -- Performing Test ICONV_SECOND_ARGUMENT_IS_CONST -- Performing Test ICONV_SECOND_ARGUMENT_IS_CONST - Success -- Found Iconv: /usr/lib/libc.so CMake Error: File /root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/mariadb_config/mariadb_config.c.in does not exist. CMake Error at mariadb_config/CMakeLists.txt:27 (CONFIGURE_FILE): configure_file Problem configuring file -- MariaDB Connector/c configuration: -- CPack generation: TGZ -- SSL support: ON -- Experimental Sqlite support: -- Zlib support: yes (using bundled zlib) -- Installation layout: DEFAULT -- Include files will be installed in /usr/local/include/mariadb -- Libraries will be installed in /usr/local/lib/mariadb -- Binaries will be installed in /usr/local/bin -- Required: -- Configuring incomplete, errors occurred! See also "/root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/CMakeFiles/CMakeOutput.log". See also "/root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/CMakeFiles/CMakeError.log". make: *** No targets specified and no makefile found. Stop. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-build-mariadb-connector-220/

1 0

[Maria-discuss] New Question: Cannot change socket location in 10.0.21
by AskMonty KB 12 Oct '15

12 Oct '15

Hello, A new question has been asked in "MariaDB Community" by bits45. Please answer it at http://mariadb.com/kb/en/cannot-change-socket-location-in-10021/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to change the socket file location to anything other than /var/lib/mysql on Red Hat 6.6 x64. Using the socket variable in server.cnf or even in my.cnf does not appear to honor the varable. I've tried placing the variable setting in various locations in the server.cnf file, but nothing seems to work. The socket file is always created in /var/lib/mysql, or the database has problems starting up. Where else do I search for this? Could it have been compiled in by accident? If I try this with MySQL 5.6 Community version it works without issue - I placed the variable in /etc/my.cnf file under [mysqld] Again, I'm using the non enterprise version of MariaDB 10.0.21 with RHEL 6.6. I downloaded MariaDB from the yum repositories via MariaDB.com Thanks, -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cannot-change-socket-location-in-10021/

1 0