- discuss - lists.mariadb.org

[Maria-discuss] New Question: MariaDB keeps crashing on some wordpress posts
by AskMonty KB 08 Jun '15

08 Jun '15

Hello, A new question has been asked in "MariaDB Community" by nunocarapito. Please answer it at http://mariadb.com/kb/en/mariadb-keeps-crashing-on-some-wordpress-posts/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there. I have a mariadb server with 2 wordpress blogs. Sometimes, when an admin posts something in it, it crashes. I've updated it, and it still happens. Not sure what else Should I do. Here's the log. http://pastebin.com/Sp6fsN4P Thanks for the help. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-keeps-crashing-on-some-wordpress-posts/

1 0

[Maria-discuss] 2015 leap second issues?
by Marco Nicosia 06 Jun '15

06 Jun '15

Hi all, I'm writing to inquire if I should prepare any of our MariaDB/Galera users for the upcoming leap second. According to http://www.timeanddate.com/time/leapseconds.html the next leap second will be added on June 30, 2015 at 23:59:60 UTC. I searched a bit for "leap second mariadb" but didn't find anything recent. Most of our users are on MariaDB 10.0.13 and Galera 25.2.9 or subsequent. Have anyone tested both MariaDB and Galera to ensure that there are versions which are resilient to the introduction of a leap second? If so, is there documentation of versions which are known vulnerable to or proof against it? Thanks! -- Marco Nicosia Product Manager Pivotal Software, Inc.

4 6

[Maria-discuss] New Question: Converting from MySQL to MariadB
by AskMonty KB 05 Jun '15

05 Jun '15

Hello, A new question has been asked in "MariaDB Community" by cavj1. Please answer it at http://mariadb.com/kb/en/converting-from-mysql-to-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi All... I'm in the process of moving from MySQL to MariadB for our web app. Within the web app we use various Crystal Reports that run on the server and present the report to the user. The report currently uses a MySQL ODBC connector. IF I modify the ODBC connector to point to the new server will the MySQL ODBC connector still work? Does anyone know if the MySQL ODBC connector is compatible with MariadB? Otherwise I'd have to modify every report in the system to use the new connector which will be very time consuming. Thank you for any input you provide. Joe -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/converting-from-mysql-to-mariadb/

1 0

[Maria-discuss] Question about Galera "pc.recovery" feature
by Marco Nicosia 05 Jun '15

05 Jun '15

Hi all! We recently discovered the configuration wsrep_provider_options="pc.recovery=TRUE" and set about to set this configuration, as we'd like to avoid unnecessary boostrapping whenever possible. We were further surprised to discover that this feature had been enabled by default. But we were frustrated in our attempts to trigger this feature to actually observe it in action. I understand that the feature is intended to recover from full cluster crashes _such as_ a power outage, but we were unable to come up with a scenario in which we could interrupt the cluster and watch it recover automatically. This included deploying to AWS and setting all three nodes to 'stop' then 'start.' In each instance, we had to manually bootstrap. Am I misunderstanding the feature, or the conditions under which we can trigger it? -- Marco Nicosia Product Manager Pivotal Software, Inc. mnicosia(a)pivotal.io c: 650-796-2948

2 1

[Maria-discuss] MariaDB 10.1.5 now available
by Daniel Bartholomew 04 Jun '15

04 Jun '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.5. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.5 - Release Notes: https://mariadb.com/kb/en/mariadb-1015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.5 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/en/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: Switch over at a database level
by AskMonty KB 04 Jun '15

04 Jun '15

Hello, A new question has been asked in "Standard Replication" by mahoarita. Please answer it at http://mariadb.com/kb/en/switch-over-at-a-database-level/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to switch over an individual database? For example, with the below scenario: - I have 3-server replication - Server contains multiple databases owned by different users I'd like to manually switch over only one database, "MyDb1" as a failover test. The rest of the databases residing on the same MariaDB server should not be impacted. This is to minimize the impact to other databases for failover test exercise. Is this possible by Standard Replication? I'd be grateful for this information. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/switch-over-at-a-database-level/

1 0

[Maria-discuss] New Question: Autoinstall ODBC
by AskMonty KB 03 Jun '15

03 Jun '15

Hello, A new question has been asked in "MariaDB Connector/ODBC" by leopoldotaylhardat. Please answer it at http://mariadb.com/kb/en/autoinstall-odbc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How can I install ODBC in silent mode with command line (windows) options? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/autoinstall-odbc/

1 0

[Maria-discuss] Unknown crash
by Irwanto 03 Jun '15

03 Jun '15

My Server :Windows 2003 R2RAM 4GMariaDB 10.0.19 01 June i'm sure i shutdown normally02 June is holiday03 June i see "crash recovery" in log file i'm sure disk is ok with chkdsk e: sometime i get this word in log file, so what caused this here my log 150601 20:17:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages150601 20:17:10 [Note] InnoDB: The InnoDB memory heap is disabled150601 20:17:10 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150601 20:17:10 [Note] InnoDB: Memory barrier is not used150601 20:17:10 [Note] InnoDB: Compressed tables use zlib 1.2.3150601 20:17:10 [Note] InnoDB: Not using CPU crc32 instructions150601 20:17:10 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150601 20:17:10 [Note] InnoDB: Completed initialization of buffer pool150601 20:17:10 [Note] InnoDB: Highest supported file format is Barracuda.150601 20:17:10 [Note] InnoDB: 128 rollback segment(s) are active.150601 20:17:10 [Note] InnoDB: Waiting for purge to start150601 20:17:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10406975924150601 20:17:11 [Note] Server socket created on IP: '0.0.0.0'.150601 20:17:11 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150601 20:17:11 [Note] Event Scheduler: Loaded 0 events150601 20:17:11 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150601 20:22:11 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150601 20:22:14 [Note] feedback plugin: server replied 'ok'150601 20:33:39 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: Normal shutdown 150601 20:33:39 [Note] Event Scheduler: Purging the queue. 0 events150601 20:34:02 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' CryptGenRandom error150601 20:34:02 [Note] InnoDB: FTS optimize thread exiting.150601 20:34:02 [Note] InnoDB: Starting shutdown...150603 7:12:49 [Note] InnoDB: Using mutexes to ref count buffer pool pages150603 7:12:49 [Note] InnoDB: The InnoDB memory heap is disabled150603 7:12:49 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions150603 7:12:49 [Note] InnoDB: Memory barrier is not used150603 7:12:49 [Note] InnoDB: Compressed tables use zlib 1.2.3150603 7:12:50 [Note] InnoDB: Not using CPU crc32 instructions150603 7:12:50 [Note] InnoDB: Initializing buffer pool, size = 1008.0M150603 7:12:50 [Note] InnoDB: Completed initialization of buffer pool150603 7:12:50 [Note] InnoDB: Highest supported file format is Barracuda.150603 7:12:50 [Note] InnoDB: The log sequence numbers 10406975924 and 10406975924 in ibdata files do not match the log sequence number 10407001762 in the ib_logfiles!150603 7:12:50 [Note] InnoDB: Database was not shutdown normally!150603 7:12:50 [Note] InnoDB: Starting crash recovery.150603 7:12:50 [Note] InnoDB: Reading tablespace information from the .ibd files...150603 7:13:01 [Note] InnoDB: Restoring possible half-written data pages 150603 7:13:01 [Note] InnoDB: from the doublewrite buffer...InnoDB: Last MySQL binlog file position 0 11515, file name E:\smart\smart_database_mariadb.10\repl\KMS-PLB-bin.000001150603 7:13:02 [Note] InnoDB: 128 rollback segment(s) are active.150603 7:13:02 [Note] InnoDB: Waiting for purge to start150603 7:13:02 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.23-72.1 started; log sequence number 10407001762150603 7:13:03 [Note] Server socket created on IP: '0.0.0.0'.150603 7:13:03 [Warning] 'proxies_priv' entry '@% root@kutu' ignored in --skip-name-resolve mode.150603 7:13:03 [Note] Event Scheduler: Loaded 0 events150603 7:13:03 [Note] E:\smart\smart_database_mariadb.10\bin\mysqld.exe: ready for connections.Version: '10.0.19-MariaDB-log' socket: '' port: 3309 mariadb.org binary distribution150603 7:18:03 [Note] feedback plugin: report to 'https://mariadb.org/feedback_plugin/post' was sent150603 7:18:04 [Note] feedback plugin: server replied 'ok'

1 0

[Maria-discuss] security scans: 5.5.5-10.0.19 should be 5.5.43-10.0.19
by Reindl Harald 01 Jun '15

01 Jun '15

[harry@rh:~]$ telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. ] 5.5.5-10.0.19-MariaDB the 5.5.5 srting leads in false positives for security scans and while i reported that to OpenVAS the correct soultion would be updating the 5.5.5 string to the latest 5.5x release instead "Fix" each scanner out there Medium (CVSS: 4.0) NVT: MariaDB 'COM_CHANGE_USER' Command Insecure Salt Generation Security Bypass Vuln... (OID: 1.3.6.1.4.1.25623.1.0.804037) Solution Upgrade to MariaDB version 5.2.14, 5.3.12, 5.5.29 or later, For updates refer to https://mariadb.org Medium (CVSS: 5.0) NVT: MariaDB Denial Of Service Vulnerability (Windows) (OID: 1.3.6.1.4.1.25623.1.0.804035) Solution Upgrade to MariaDB 5.1.68, 5.2.15, 5.3.13, 5.5.30 or later, For updates refer to https://mariadb.org Product detection result: cpe:/a:mariadb:mariadb:5.5.5- by MySQL/MariaDB Detection (OID: 1.3.6.1.4.1.25623.1.0.100152)

2 1

Re: [Maria-discuss] Dynamic Columns ORM
by Tom Worster 23 May '15

23 May '15

Hi Daniel, Yes, I shall add remarks about indexes to the docs. I didn't have any purpose for "token" other than I needed a name for the strings that go in the SQL that refer to dynamic columns. Is there a problem with that particular word or do you think it would be better to do without any such name? You're spot on about computed columns. From my point of view, doing that amounts to adding the column to the schema. The column name appears in DDL and the corresponding attribute is therefore no longer ad hoc in the the application. The same point applies (in some imaginary future) to adding an index to a dynamic column without needing a computed column. If attributes represented in the application are to be truly fluid then their corresponding dynamic column cannot be indexed, at least not as I understand indexes in MySQL. Thanks for taking a look. Tom From: Daniel Black <daniel.black(a)openquery.com.au> Date: Saturday, May 23, 2015 at 1:27 AM To: Tom Worster <fsb(a)thefsb.org>, maria-discuss email list <maria-discuss(a)lists.launchpad.net> Subject: Re: [Maria-discuss] Dynamic Columns ORM They are generally good for blob like information that is generally retrieved in a query with some structure around name->value pairs. You mentioned (forum) that there isn't an index on these items so you'll get more row scanning on these if people search on a Dynamic attribute tokens (not sure why you are adding "token" to the language here). This limitation to be mentioned more in the documentation you've written. You could use computed columns to extract a variable to index if really needed but you'll need to ask why isn't it a column in its own right. https://mariadb.com/kb/en/mariadb/virtual-computed-columns/ Enhancing frameworks to expose database features is a good thing as they often get omitted in the reduction to the lowest common factor (mysql-5.0?) and sometimes the lowest common factor across db implementations (ansi SQL(?)). -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 1