February 2016 - discuss - lists.mariadb.org

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] How to rollback XA Transactions
by Marc Schöchlin 04 Mar '16

04 Mar '16

Hi, i currently have the situation that i cannot modify tables/indices beaus of XA transactions which are in progress. mysql://root@localhost:/(none) - 11:37:55 > xa recover; +----------+--------------+--------------+------------------------------------------------------------------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+------------------------------------------------------------------+ | 4871251 | 35 | 29 | ^W<89>^B <E8>XF+foo-bar-de05,server,P4837foo-bar-de05,server,P4837,^A | | 4871251 | 35 | 29 | ^N<89>^B <E8>XF+foo-bar-de05,server,P4837foo-bar-de05,server,P4837,^A | +----------+--------------+--------------+------------------------------------------------------------------+ 2 rows in set (0.00 sec) The documentation (https://mariadb.com/kb/en/mariadb/xa-transactions/) suggests that xa transaction can be rolled back by using "xa rollback xid" but it seems that this is not possible because of the non-ascii characters. As you can see in the attached Innodb status, these transactions a active for a log time now and should not be relevant anymore. Naturally restarting the server should not help..... Do you have a suggestion how to prevent, solve or analyze this situation? Regards Marc ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ mysql://root@localhost:/(none) - 11:34:25 > SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2016-02-20 11:34:50 7fba401d3700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 31 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 57 srv_active, 0 srv_shutdown, 171810 srv_idle srv_master_thread log flush and writes: 171823 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2076 OS WAIT ARRAY INFO: signal count 2072 Mutex spin waits 339, rounds 174, OS waits 3 RW-shared spins 2133, rounds 63046, OS waits 2069 RW-excl spins 0, rounds 0, OS waits 0 Spin rounds per wait: 0.51 mutex, 29.56 RW-shared, 0.00 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1969875 Purge done for trx's n:o < 1965495 undo n:o < 0 state: running but idle History list length 316 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 4362, OS thread handle 0x7fba401d3700, query id 23179 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 1969667, not started MySQL thread id 1, OS thread handle 0x7fba41298700, query id 0 Waiting for background binlog tasks ---TRANSACTION 413370, ACTIVE (PREPARED) 172053 sec recovered trx , undo log entries 9 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 413360, ACTIVE (PREPARED) 172053 sec recovered trx , undo log entries 11 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) 1 row in set (0.00 sec) Regards Marc -- GPG encryption available: 0x670DCBEC/pool.sks-keyservers.net (https://www.256bit.org/keys/mschoechlin.pub.asc)

3 6

[Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'
by Lukas Lehner 02 Mar '16

02 Mar '16

Hi http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-… any idea? howto debug future crashes better? Lukas

4 4

[Maria-discuss] new jira: missing redirect
by Federico Razzoli 29 Feb '16

29 Feb '16

Hi! I see that MariaDB switched to the new JIRA. However this redirect has not been updated: http://mariadb.org/jira Regards Federico

1 0

[Maria-discuss] Fwd: New Question: Non-blocking calls from PHP
by Justin Swanhart 27 Feb '16

27 Feb '16

oops, didn't copy the list. ---------- Forwarded message ---------- From: Justin Swanhart <greenlion(a)gmail.com> Date: Wed, Feb 24, 2016 at 11:34 AM Subject: Re: [Maria-discuss] New Question: Non-blocking calls from PHP To: Federico Razzoli <federico_raz(a)yahoo.it> Hi, For now, if you want FIFO, just change the ORDER BY q_id DESC to ORDER BY q_id. The execution is parallel, it shouldn't starve queries. I will probably change this anyway by changing the structure of the `q` table to have a primary key that sorts by the completion status and a unique key for the auto_increment columns, then it can naturally be FIFO without causing lock contention due to locking scanned rows in InnoDB. The workaround for GET DIAGNOSTICS is to change it to not use that and just put a generic error in the table. You can't use conditional version syntax in stored procs, and I don't want to have two different versions of the script, since everyone really should be using 5.6+ or MariaDB 5.5+ IMHO. I will remove count_running_threads, it isn't really needed because the metadata locks held by the stored proc enforce that no more than 'thread_count' threads can run. I will remove that code shortly. I wasn't using metadata locks when I started writing the tool. This will remove the dependency on global variables and the processlist. It is version 1.0 and is still experimental :) Thank you for the feedback. --Justin On Wed, Feb 24, 2016 at 10:58 AM, Federico Razzoli <federico_raz(a)yahoo.it> wrote: > Yes, GET DIAGNOSTICS is in 5.5 (and anyway, a workaround for older > versions should be possible, correct?). > > Some comments: > > 1) The LIFO tables sounds to me a little dangerous. Of course > "asynchronous" means "asynchronous", but under certain circumstances some > queries could wait too much... don't you agree? Maybe the direction could > depend from an option... > > 2) SELECT queries are "materialized", which is cool. But I don't > understand how the user can associate an async query with the results table. > > 3) In MariaDB, the P_S is disabled by default, and a user can still > disable it in MySQL. Also, in MariaDB global_status is in I_S, while MySQL > has it in P_S (another funny incompatibility developed by Oracle). The > first problem can probably be addressed with CONNECT (SRCDEF='show > processlist') and the second with a view in async schema. Would you accept > a patch? > > Probably more comments/questions will come. In the meanwhile, thanks for > your work (again). > > bye > Federico > > > -------------------------------------------- > Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: > > Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP > A: "Federico Razzoli" <federico_raz(a)yahoo.it> > Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> > Data: Mercoledì 24 febbraio 2016, 16:04 > > Hi, > It is > completely native. It consists of a queue table, a thread > state table, a settings table, a stored procedure worker, an > event to execute the worker (more than one run in parallel) > and procs to drop off, check on, and get the results of a > SQL statement (which always waits if the SQL is not done > yet). > I don't know > if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work > with any version that has it. You can comment that out and > just put a generic error into the table if it isn't > supported, and it will work with any version that has > SIGNAL. > --Justin > On Wed, Feb 24, 2016 at > 10:01 AM, Federico Razzoli <federico_raz(a)yahoo.it> > wrote: > Hi > Justin! > > The name reminds me a a fatal trap for developers and sys > admins (async npm module), but the tools sounds useful. > > Is it publicly available? Is it entirely implemented via > stored procedures + event scheduler? > > > > bye > > Federico > > > > > > -------------------------------------------- > > Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> > ha scritto: > > > > Oggetto: Re: [Maria-discuss] New Question: Non-blocking > calls from PHP > > A: "AskMonty KB" <noreply(a)askmonty.org> > > Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> > > Data: Mercoledì 24 febbraio 2016, 15:32 > > > > Replying > > here in addition to the web page (ugh > Frankenstein's > > monster)... > > > > I just finished > > the first version of 'async' which runs queries > in > > the background (in parallel!) using a queue table, a > crafty > > stored procedure for a worker thread, and an event > which > > executes the workers. > > http://swanhart.livejournal.com/138754.html > > > > On Sun, Feb 21, 2016 at > > 8:55 AM, AskMonty KB <noreply(a)askmonty.org> > > wrote: > > Hello, > > > > > > > > A new question has been asked in " MariaDB > Connector/C > > API Functions" by shestero. Please answer it at > http://mariadb.com/kb/en/non-blocking-calls-from-php/ > > as the person asking the question may not be subscribed > to > > the mailing list. > > > > > > > > -------------------------------- > > > > I want to use non-blocking API ( > https://mariadb.com/kb/en/mariadb/non-blocking-api-reference > > ) from PHP. > > > > Is it possible now? > > > > If no, can anybody give me directions how to implement > my > > own PHP-extension in C (using Connector/C) or update > the > > existing module? I don't think it's very complex, > do > > I need to add just wraper-like implementations using > > blocking function as samples, don't I? > > > > -------------------------------- > > > > > > > > To view or answer this question please visit: > http://mariadb.com/kb/en/non-blocking-calls-from-php/ > > > > > > > > _______________________________________________ > > > > Mailing list: https://launchpad.net/~maria-discuss > > > > Post to : maria-discuss(a)lists.launchpad.net > > > > Unsubscribe : https://launchpad.net/~maria-discuss > > > > More help : https://help.launchpad.net/ListHelp > > > > > > > > -----Segue allegato----- > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > > Post to : maria-discuss(a)lists.launchpad.net > > Unsubscribe : https://launchpad.net/~maria-discuss > > More help : https://help.launchpad.net/ListHelp > > >

1 1

[Maria-discuss] MariaDB 10.1.12 and MariaDB Galera Cluster 10.0.24 & 5.5.48 now available
by Daniel Bartholomew 26 Feb '16

26 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.12, and MariaDB Galera Cluster 10.0.24 & 5.5.48. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.12 - Release Notes: https://mariadb.com/kb/en/mdb-10112-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10112-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.12 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 Galera Cluster 10.0.24 - Release Notes: https://mariadb.com/kb/en/mgc-10024-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10024-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.24 MariaDB Galera Cluster 5.5.48 - Release Notes: https://mariadb.com/kb/en/mgc-5548-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5548-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.48 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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

1 0

[Maria-discuss] Question on RocksDB AMA, when will MyRocks be in a proper distribution?
by MARK CALLAGHAN 25 Feb '16

25 Feb '16

https://www.reddit.com/r/IAmA/comments/47k1si/we_are_rocksdb_developers_ask… -- Mark Callaghan mdcallag(a)gmail.com

1 0

[Maria-discuss] New Question: Audit parameters getting reset after MySQL DB restart
by AskMonty KB 24 Feb '16

24 Feb '16

Hello, A new question has been asked in "MariaDB Community" by sanjaykumar.raghavendra. Please answer it at http://mariadb.com/kb/en/audit-parameters-getting-reset-after-mysql-db-rest… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I am working on automating the installation and configuration of MySQL for faster deployment. As part of this, I enable the Audit parameters dynamically which works fine. However after the instance restart, I noticed that the parameters are getting reset to their factory defaults which disables auditing. For instance, server_audit_logging gets reset to OFF. Has anyone come across this? How do I persist my settings across instance restarts? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/audit-parameters-getting-reset-after-mysql-db-rest…

1 0

Re: [Maria-discuss] New Question: Non-blocking calls from PHP
by Federico Razzoli 24 Feb '16

24 Feb '16

Yes, GET DIAGNOSTICS is in 5.5 (and anyway, a workaround for older versions should be possible, correct?). Some comments: 1) The LIFO tables sounds to me a little dangerous. Of course "asynchronous" means "asynchronous", but under certain circumstances some queries could wait too much... don't you agree? Maybe the direction could depend from an option... 2) SELECT queries are "materialized", which is cool. But I don't understand how the user can associate an async query with the results table. 3) In MariaDB, the P_S is disabled by default, and a user can still disable it in MySQL. Also, in MariaDB global_status is in I_S, while MySQL has it in P_S (another funny incompatibility developed by Oracle). The first problem can probably be addressed with CONNECT (SRCDEF='show processlist') and the second with a view in async schema. Would you accept a patch? Probably more comments/questions will come. In the meanwhile, thanks for your work (again). bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "Federico Razzoli" <federico_raz(a)yahoo.it> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 16:04 Hi, It is completely native. It consists of a queue table, a thread state table, a settings table, a stored procedure worker, an event to execute the worker (more than one run in parallel) and procs to drop off, check on, and get the results of a SQL statement (which always waits if the SQL is not done yet). I don't know if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work with any version that has it. You can comment that out and just put a generic error into the table if it isn't supported, and it will work with any version that has SIGNAL. --Justin On Wed, Feb 24, 2016 at 10:01 AM, Federico Razzoli <federico_raz(a)yahoo.it> wrote: Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler? bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply(a)askmonty.org> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32 Replying here in addition to the web page (ugh Frankenstein's monster)... I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply(a)askmonty.org> wrote: Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

Re: [Maria-discuss] New Question: Non-blocking calls from PHP
by Federico Razzoli 24 Feb '16

24 Feb '16

Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler? bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply(a)askmonty.org> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32 Replying here in addition to the web page (ugh Frankenstein's monster)... I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply(a)askmonty.org> wrote: Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

2 2