- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.1.13 sysbench and Fusion-IO PCIE card lock question ?
by Ljr Yang 02 May '16

02 May '16

Hi, All Recently, We use Sysbench Test MariaDB 10.1.13. In Test ,We found server lock and can't write . Testing environment: server1: 10.2.1.242 (HP OEM Fusion IO PCIE Card 3.2TB ) server2: 10.2.1.239 (ScanDisk Fusion IO PCIE Card 3.2TB) sysbench test script: sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --num-threads=16 --mysql-host=localhost --mysql-port=3306 --mysql-socket=/data/mysql2/data/mysql.sock --mysql-user=root --mysql-password=123456 --mysql-db=test --max-time=0 --max-requests=0 --report-interval=1 --oltp-tables-count=16 run when *wsrep_on = on *, after run a few minutes or a few hours, both server1 and server2 were stucked, all write stoped ,only select statement run normal : ................ [ 815s] threads: 16, tps: 6176.00, reads: 86431.00, writes: 24699.00, response time: 3.37ms (95%), errors: 0.00, reconnects: 0.00 [ 816s] threads: 16, tps: 6064.99, reads: 84907.86, writes: 24256.96, response time: 3.66ms (95%), errors: 0.00, reconnects: 0.00 [ 817s] threads: 16, tps: 6097.00, reads: 85394.05, writes: 24394.02, response time: 3.54ms (95%), errors: 0.00, reconnects: 0.00 [ 818s] threads: 16, tps: 6131.97, reads: 85819.52, writes: 24529.86, response time: 3.65ms (95%), errors: 0.00, reconnects: 0.00 [ 819s] threads: 16, tps: 6143.04, reads: 86036.63, writes: 24575.18, response time: 3.44ms (95%), errors: 0.00, reconnects: 0.00 [ 820s] threads: 16, tps: 5819.80, reads: 81532.22, writes: 23332.20, response time: 3.60ms (95%), errors: 0.00, reconnects: 0.00 [ 821s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 822s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 823s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 824s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 825s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 826s] threads: 16, tps: 0.00, reads: 0.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 ................ In error log file not error info , after execute* pstack `pidof mysqld` > pstack.log*, sysbench run normal again , and start write data. Every time have this problem, in pstack.log file contains a few lock: #0 0x00007f2b04fe0334 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f2b04fdb5d8 in _L_lock_854 () from /lib64/libpthread.so.0 #2 0x00007f2b04fdb4a7 in pthread_mutex_lock () from /lib64/libpthread.so.0 .................... When *set wsrep_on = off*, Sysbench test MariaDB 10.1.13 normal. As contrast ,We download Percona-XtraDB-Cluster-5.6.28-rel76.1-25.14.1.Linux.x86_64.ssl101.tar.gz and run sysbench test, found same problem too. We can't confirm , is it hardware or galera question ? please help analyze ,thank you. Reference link: https://en.wikibooks.org/wiki/Linux_Applications_Debugging_Techniques/Deadl… http://www.linuxprogrammingblog.com/threads-and-fork-think-twice-before-usi… -- 杨建军

2 1

[Maria-discuss] MariaDB 10.0.25 now available
by Daniel Bartholomew 30 Apr '16

30 Apr '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.25. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.25 - Release Notes: https://mariadb.com/kb/en/mdb-10025-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10025-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.25 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ 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

1 0

[Maria-discuss] ERROR 1242 (21000): Subquery returns more than 1 row
by Tristan AURIOL 29 Apr '16

29 Apr '16

Hi everyone, I have a big problem with my application. My application execute this request : INSERT INTO `mydb`.`service_request` ( `id_z`, `id_app`, `request_time`, `priority` ) ( SELECT sc.`id_z`, sc.`id_app`, NOW(), 0 FROM `mydb`.`service_connection` sc JOIN `mydb`.`service` s ON ( s.`id_service` = sc.`id_service` ) WHERE 1=1 AND sc.`id_app` = _utf8'afr' AND s.`status` = 'available' AND ( sc.`last_synchronized_time` < SUBDATE( NOW(), INTERVAL 600 SECOND ) OR sc.`last_synchronized_time` IS NULL ) AND sc.`nb_errors` < 2 AND sc.`id_z` NOT IN ( SELECT sr.`id_z` FROM `mydb`.`service_request` sr WHERE sr.`id_app` = _utf8'afr' AND sr.`status` IN ( 'waiting thu', 'waiting sez', 'in progress' ) ) ) ; This request works well into MySQL 5.6.25-1~dotdeb+7.1 but when I run into 10.1.11-MariaDB-1~jessie-log I have this error: ERROR 1242 (21000): Subquery returns more than 1 row Do you have an idea? Thanks -- *Tristan AURIOL*

3 2

[Maria-discuss] New Question: Coding in MariaDB
by AskMonty KB 27 Apr '16

27 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by dbamaria. Please answer it at http://mariadb.com/kb/en/coding-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hi, I have the following questions: -What is the language used for coding in MariaDB? -As the Oracle package doesn't exist, how MariaDB structure its code ? -Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/coding-in-mariadb/

1 0

[Maria-discuss] New Question: server do not permit root to log in
by AskMonty KB 27 Apr '16

27 Apr '16

Hello, A new question has been asked in "MariaDB Community" by xav795. Please answer it at http://mariadb.com/kb/en/server-do-not-permit-root-to-log-in/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I am trying to start the db with mysqld command the server is getting ready for connections but i cant log in with root because access is denied. I tried to start the server with the skip-grant-access options, and i saw that root does not exist in mysql.USER table. I have many error message when the server starts : 2016-04-27 01:24:11 b7074740 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 160427 1:24:11 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/gtid_slave_pos'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 160427 1:24:11 [ERROR] InnoDB: Tablespace open failed for '"mysql"."gtid_slave_pos"', ignored. 2016-04-27 01:24:11 b7074740 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 160427 1:24:11 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 160427 1:24:11 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored. 160427 1:24:11 [Note] InnoDB: 128 rollback segment(s) are active. 160427 1:24:11 [Note] InnoDB: Waiting for purge to start 160427 1:24:12 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1729734 handlersocket: initialized 160427 1:24:12 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 160427 1:24:12 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 160427 1:24:12 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist Does anybody no what to do with this informations? Regards Xavier -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/server-do-not-permit-root-to-log-in/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.49 and Connector updates now available
by Daniel Bartholomew 26 Apr '16

26 Apr '16

The MariaDB project is pleased to announce the immediate availability of: - MariaDB Galera Cluster 5.5.49 - MariaDB Connector/J 1.4.3 - MariaDB Connector/C 2.2.3 These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.49 - Release Notes: https://mariadb.com/kb/en/mgc-5549-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5549-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.49 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.4.3 - Release Notes: https://mariadb.com/kb/en/mcj-143-rn/ - Changelog: https://mariadb.com/kb/en/mcj-143-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.4.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.2.3 - Release Notes: https://mariadb.com/kb/en/mcc-223-rn/ - Changelog: https://mariadb.com/kb/en/mcc-223-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.2.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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] New Question: Error Starting service
by AskMonty KB 26 Apr '16

26 Apr '16

Hello, A new question has been asked in "MaxScale Getting Started" by cisaksen. Please answer it at http://mariadb.com/kb/en/error-starting-service/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Background: 3 Mariadb Galera servers - 'maxscaleuser'@'hostname%' configured as directed Maxscale 1.4 for SUSE 12 In the maxscale log I see the following errors: Failed to obtain address for host hostname%, Name or service not known. Failed to add user maxscaleuser@hostname% for service [galera service]. This user will be unavailable via maxscale. So I have my maxscaleuser account setup in mysql correctly but it appears that maxscale doesn't like the wildcard % ? is there a way to fix this ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-starting-service/

1 0

[Maria-discuss] MariaDB coding questions
by Ghazi Btissam 26 Apr '16

26 Apr '16

Hi, - As the Oracle package does'nt exist, how MariaDB structure its code ? - Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? Thanks

1 0

[Maria-discuss] InnoDB fake changes
by Federico Razzoli 25 Apr '16

25 Apr '16

Hi all I see that 10.2 still has the innodb_fake_changes variable (OFF by default). That feature was stable in Percona Server 5.5, is beta in 5.6, and was removed in 5.7. Is it still there just for compatibility with old configuration files, or is there still a reason to use it? And in that case, is it stable or not? Regards, Federico

4 3

[Maria-discuss] New Question: Mariadb Columnstore on Windows
by AskMonty KB 25 Apr '16

25 Apr '16

Hello, A new question has been asked in "MariaDB Community" by brian_demilia_g. Please answer it at http://mariadb.com/kb/en/mariadb-columnstore-on-windows/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does anyone know if the upcoming Columnstore storage engine will be usable on Windows? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-columnstore-on-windows/

1 0