February 2014 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 05 Dec '24

05 Dec '24

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

3 2

[Maria-discuss] InnoDB pain points
by Jan Lindström 14 Apr '14

14 Apr '14

Hi all, I would like to know the most affecting InnoDB pain points the customers/potential customers first refer. By pain point, I mean anything that causes concerns, restricts sales etc, pain point can be bug, missing feature, usage problem, performance etc. My goal on asking this question is to find out what are the real issues customers or potential customer are struggling or issues that block customers using MariaDB. After that I will see what I can do about the situation and plan forward to address the raised issues with proper priorities. Dean, if this list does to reach the support engineers and technical sales teams please forward to more suitable list. R: Jan -- Jan Lindström Principal Engineer MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

14 24

[Maria-discuss] Index bug in aria engine?
by pslawek83 07 Mar '14

07 Mar '14

Hi Guys, any comments on this issue? It seems that partial unique indexes can't be used in joins. https://mariadb.atlassian.net/browse/MDEV-5663 Regards,

4 5

[Maria-discuss] New Question: Downloaded; how do I install?
by AskMonty KB 28 Feb '14

28 Feb '14

Hello, A new question has been asked in "MariaDB Documentation" by jeffreythomas: -------------------------------- I've downloaded MariaDB; how do I install it? Thanks, Jeff -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/downloaded-how-do-i-install/

1 0

[Maria-discuss] New Question: Maria DB - changing hosting with a different DB
by AskMonty KB 26 Feb '14

26 Feb '14

Hello, A new question has been asked in "MariaDB community" by hannasles: -------------------------------- Hi Guys! I am moving my web-site from one hosting to another. The DB on the first hosting is MariaDB, DB on the hosting I am moving to is MyIsam. When importing the DB, I am getting this message: ERROR 1064 (42000) at line 19: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1' at line 6 Line 19 runs: CREATE TABLE `wp_blc_filters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1; As I am not good at all with DB and my hosting supports can not answer my enquiries, I have to open this question here. I will really appreciate that if you could help me with this! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-changing-hosting-with-a-different-db/

2 1

[Maria-discuss] New Question: How do I keep the graph table and data table in sync?
by AskMonty KB 26 Feb '14

26 Feb '14

Hello, A new question has been asked in "OQGRAPH" by prestonthayne: -------------------------------- So I added some rows to the data table before I created the graph table that then showed up just fine. I then added some more rows to the data table and did a select * on the graph table and the new rows weren't there. I did a shortest route query and they showed up. A subsequent select * query to the graph table and they were there. What triggered them to appear? I then added a few more and no matter what I do they won't show up. The last one that won't show up was a two way link ( insert into oq_backing (origid,destid) values (9,10),(10,9) ). That's not a problem is it? And lastly, is there any good documentation/literature around for how oqgraph works and how to use it? Thanks, Preston -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-keep-the-graph-table-and-data-table-in-sy…

1 0

[Maria-discuss] MariaDB 5.5.36 now available
by Daniel Bartholomew 26 Feb '14

26 Feb '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.36. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.36 - Release Notes: https://mariadb.com/kb/en/mariadb-5536-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5536-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.36 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - - - - Getting Started with MariaDB A how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. http://www.packtpub.com/getting-started-with-mariadb/book - - 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/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL 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: Unknown option 'table_data' OQGraph in MariaDB 10.0.7
by AskMonty KB 26 Feb '14

26 Feb '14

Hello, A new question has been asked in "OQGRAPH" by prestonthayne: -------------------------------- I am trying to evaluate MariaDB and OQGraph and am having difficulty creating the tables. I follow the examples exactly as on the site. I create the backing table, I insert some data into the backing table, I attempt to create the graph table and I get an error that the option 'table_data' is unknown. I am using MariaDB 10.0.7 on CentOS 6.5. Any advice would be greatly appreciated. Preston -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unknown-option-table_data-oqgraph-in-mariadb-1007/

1 0

[Maria-discuss] We are participating in Google Summer of Code 2014
by Colin Charles 25 Feb '14

25 Feb '14

Hi, It is with great pleasure that I can inform you that we have been accepted as an organisation to participate in Google Summer of Code 2014! It would be great to see more ideas pop up here: https://mariadb.com/kb/en/google-summer-of-code-2014/ More mentors are always wanted! I presume we will see a lot more student discussions here as well. If you have any questions that aren't answered on the lists, please send me a personal note Here's to more features & contributors in 2014. cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] InnoDB: Assertion failure in thread 139652707100416 in file buf0buf.c line 4172
by Reindl Harald 21 Feb '14

21 Feb '14

Hi after chnage to MariaDB i faced tonight that the third time on one of our dbmail-replication-slaves while that never happened with MySQL over years :-( 140221 3:19:50 InnoDB: Assertion failure in thread 139652707100416 in file buf0buf.c line 4172 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 140221 3:19:50 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 5.5.35-MariaDB key_buffer_size=10485760 read_buffer_size=131072 max_used_connections=1 max_threads=502 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 211932 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 /usr/libexec/mysqld(my_print_stacktrace+0x2e)[0x7f037fbde42e] /usr/libexec/mysqld(handle_fatal_signal+0x505)[0x7f037f847a25] /lib64/libpthread.so.0(+0xef90)[0x7f037d686f90] /lib64/libc.so.6(gsignal+0x39)[0x7f037d2ec9e9] /lib64/libc.so.6(abort+0x148)[0x7f037d2ee0f8] /usr/libexec/mysqld(+0x63f008)[0x7f037fa03008] /usr/libexec/mysqld(+0x676218)[0x7f037fa3a218] /usr/libexec/mysqld(+0x5f8048)[0x7f037f9bc048] /lib64/libpthread.so.0(+0x7c53)[0x7f037d67fc53] /lib64/libc.so.6(clone+0x6d)[0x7f037d3acdbd] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140221 3:19:52 InnoDB: The InnoDB memory heap is disabled 140221 3:19:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140221 3:19:52 InnoDB: Compressed tables use zlib 1.2.7 140221 3:19:52 InnoDB: Using Linux native AIO 140221 3:19:52 InnoDB: Initializing buffer pool, size = 64.0M 140221 3:19:52 InnoDB: Completed initialization of buffer pool 140221 3:19:52 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 153930874326 140221 3:19:52 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 153931613156 140221 3:19:53 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 75471956, file name bin.000375 InnoDB: and relay log file InnoDB: position 75472234, file name ./mysql-relay-bin.001426 InnoDB: Last MySQL binlog file position 0 1179902, file name /data/mysql/mysql_dbmail/bin.000224 140221 3:19:53 InnoDB: Waiting for the background threads to start 140221 3:19:54 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 153931613156 140221 3:19:54 [Note] Plugin 'FEDERATED' is disabled. 140221 3:19:54 [Note] Plugin 'FEEDBACK' is disabled. 140221 3:19:54 [Note] Server socket created on IP: '0.0.0.0'. 140221 3:19:55 [Note] Slave SQL thread initialized, starting replication in log 'bin.000375' at position 75471956, relay log './mysql-relay-bin.001426' position: 75472234 140221 3:19:55 [Note] Slave I/O thread: connected to master 'replication@******:3307',replication started in log 'bin.000376' at position 245 140221 3:19:55 [Note] Event Scheduler: Loaded 0 events 140221 3:19:55 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.35-MariaDB' socket: '/var/lib/mysql/mysqld_dbmail.sock' port: 3307

1 0