Re: [Maria-discuss] FYI:10.5.15-MariaDB crash und recover

Hi, Radisson97, Thanks. Do you have debuginfo packages installed? It looks like the stack trace was not correctly resolved. Where did you get mariadb from? From Debian or MariaDB? Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Jun 01, radisso...@gmx.de wrote: >

Re: [Maria-discuss] Privilege Question

Hi, Scott, In MariaDB it's SUPER privilege. Starting from 10.5 there are fine-grained privilege for various activities, see https://mariadb.com/kb/en/grant/#global-privileges But there is no one "system_variables_admin" privilege. Different system variables are protected by different

Re: [Maria-discuss] Disable validation for `DATETIME` columns

Hi, William, On Apr 02, William Edwards wrote: > Hi Sergei, > > Sergei Golubchik schreef op 2023-03-30 14:54: > > Hi, William, > > > > Could you provide a sequence of SQL commands demonstrating what > > exactly is not working? > > > > I've just tri

Re: [Maria-discuss] Column named 'row_number' gives error in 10.11

Hi, Keith, On Apr 02, Keith Edmunds wrote: > > I can't say I'm impressed with a "patch" which eliminates something > > like this from the list of reserved words. They are, after all, > > reserved for a reason. > > I'm not impressed that a point release introduces a reserved word that > will

Re: [Maria-discuss] Disable validation for `DATETIME` columns

Hi, William, Could you provide a sequence of SQL commands demonstrating what exactly is not working? I've just tried and I was able to insert '2023-03-26 02:30:00' into a DATETIME column just fine. Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Mar 30, William

Re: [Maria-discuss] DELETE query hanging on Statistics (10.6.12)

Hi, Dan, On Mar 03, mari...@biblestuph.com wrote: > With this table: > > CREATE TABLE t1 ( > label varchar(100) NOT NULL, > dt datetime NOT NULL, > success tinyint(1) NOT NULL, > PRIMARY KEY (label,dt), > KEY dt (dt), > KEY success (success,dt) > ) ENGINE=InnoDB DEFAULT

Re: [Maria-discuss] Branch 10.4 conflict

Hi, Otto, Yes, two weeks ago 10.5 merge commit was mistakenly pushed into 10.4. Branch protection didn't prevent it because the commit passed all tests (as 10.5 commit). Jan noticed that and reverted this change by pushing 9335e2a2b1d555d2ad83ae6f44acb8467c495b72. But still 10.4 branch had all

Re: [Maria-discuss] Query got stuck while we fetch for specific timestamp

Hi, Ragul, Can you share the table definition? The result of SHOW CREATE TABLE TableA. /Sergei On Jan 27, ragul rangarajan wrote: > Hi all, > > I have a TableA with data around 1.4Billion which was partitioned by > timestamp. > > > TableA (

Re: [Maria-discuss] Inspect SQL sentencies in aria_log files

Hi, woodyst, Aria log files are not an alternative to binary log, they do not contain sql statements. On Jan 20, woodyst wrote: > Hello! > > Please, forgive me if I am asking in the wrong list so I do not know if it > is the correct place for asking this question. > > I was using MyISAM engine

Re: [Maria-discuss] MariaDB 10.5.18: Performance-Problems with CONCAT

Hi, Johannes, Try the next release (expected in about a month) where https://jira.mariadb.org/browse/MDEV-29988 is fixed. Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Jan 04, Johannes Ody wrote: > I'm german. Please excuse my bad english. > MariaDB version

Re: [Maria-discuss] Followup on MDEV-25625, still present in 10.5.16

Hi, Chris, I saw that Daniel Black has picked it up, so I expect it'll be closed in the next release too. Regards, Sergei On Nov 16, Chris Ross (cross2) wrote: > Thank you. While I’m here, any chance you can get the changes from > MDEV-23230 applied too? > >- Chris >

Re: [Maria-discuss] Followup on MDEV-25625, still present in 10.5.16

Hi, Chris, Reopened, thanks On Nov 16, Chris Ross (cross2) wrote: > Hello all. I came across MDEV-25625 while looking for that same > problem. It was closed, I think because the reporter didn’t get back > to it, but I’m now seeing the same. I’ve added a comment, but I don’t > know if

Re: [Maria-discuss] Retrieve authentication plugins for user

Hi, William, Don't use mysql.user. It's only preserved for compatibility with old application and intentionally does not support any new authentication features. You can see all plugins in `show create user`. The actual table where this information is stored is mysql.global_priv

Re: [Maria-discuss] Maria-db refuses to start

Hi, Jogchum, On Oct 12, Jogchum Reitsma wrote: > Hi, > > I am on OpenSuse Tumbleweed, rolling distro. > > Since some snapshots of Tumbleweed my mariadb does not start at system > start. I don't use the mariadb databases a lot, so I didn't notice it > immediately. Hence I'm  unsure when the

Re: [Maria-discuss] Change case with unique constraint

Hi, Keith, Thanks, it's a bug. Reported as https://jira.mariadb.org/browse/MDEV-29345 Until it's fixed, you can as a workaround update your column to something else and then to "Test". Or you can reduce the column length. On Aug 21, Keith Edmunds wrote: > I can't change the case of a column

Re: [Maria-discuss] "Rewind" type of mechanisms?

Hi, Sam, It's not automatic, but you can replay binlog backwards and undo already committed changes: https://mariadb.com/kb/en/flashback/ On Aug 19, Sam R. wrote: > >Gordan Bobic wrote: > > There is no built in rewind option to roll back a committed > > transaction that I am aware of -

Re: [Maria-discuss] Incorrect Documentation: Replicating JSON from MySQL to MariaDB

Hi, Gordan, Would it work if you install "mysql_json" plugin in the MariaDB and then replicate MySQL->MariaDB? I didn't try myself, but I've checked the sources and it appears that it was supposed to work. If it won't - please, report it as a bug. On May 29, Gordan Bobic wrote: > On this page:

Re: [Maria-discuss] MariaDB latest source tarballs missing

Hi, Shreenidhi, On May 19, Shreenidhi Shedi wrote: > > I am from VMware Photon OS engineering team. > > We are trying to fix few CVEs that are being reported in 10.2.x & > 10.3.x versions of MariaDB. > > There is release note for v10.2.44 but I cannot find the source > tarball in downloads

Re: [Maria-discuss] A federation bug was identified.

Hi, 최혁규, It might be a bug, but it's impossible to tell for sure with the information you've provided. Please, report a bug at jira.mariadb.org and answer questions there as needed. You can also specify there whether you use Federated or FederatedX, what is the version of the second server and

Re: [Maria-discuss] sys schema backup

Hi, William! On Dec 03, William Edwards wrote: > Hi, > > The 'sys' schema is documented to be "A collection of views, functions > and procedures to help MySQL administrators get insight in to MySQL > Database usage." Is there anything in this schema that should be backed > up, or can I skip

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! On Nov 19, Lukas Javorsky wrote: > Thank you for your responses. > > > By the way, we're working on OpenSSL 3.0 support right now, > > MDEV-25785. There should be a patch ready very soon. > Will you update the existing versions as well? For example > MariaDB-Server-10.5? This is the

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! This looks very strange. Perhaps, indeed, the previous server process didn't die and is still bound to the port 16020? This is not very likely, mtr kills all processes with -9, there shouldn't be anything hanging around. But how otherwise 13, "Permission denied" can happen? By the

Re: [Maria-discuss] Incorrectly formatted XML files in mariadb-server sources

Hi, Zuzana! I'd suggest to suppress all rpminspect warnings in the test files. Sometimes files may be ill-formed on purpose, sometimes not. But they're just for testing, so it just not worth the time and efforts to fix them. Index.xml is rather unfortunate, thought, ideally it should be a valid

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! On Oct 13, Lukas Javorsky wrote: > Hi Sergei, > > > How do these tests fail? > For example: > Test = encryption.corrupted_during_recovery > Error: > "mysqltest: At line 25: query 'INSERT INTO t1 VALUES(2)' failed: 1932: > Table 'test.t1' doesn't exist in engine" > > For the full log

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! On Oct 05, Lukas Javorsky wrote: > Hi guys, > > I've found few particular tests from the test suite that is failing due to > the OpenSSL-3 version and I want to separate them and give them to the > OpenSSL team in Red Hat. > > The idea behind this is to give them a set of

Re: [Maria-discuss] MyISAM: single table GROUP BY plan changes based on LIMIT. BUG?

Hi, Vassilis! On Oct 12, Vassilis Virvilis wrote: > > I managed to create a trivial reproducer with a 10 rows table. > > If I don't specify LIMIT the plan goes to filesort. > If I specify LIMIT <= 9 the plan goes to utilize the index > If I specify LIMIT >= 10 (table rows) the plan foes to

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! Sorry, for not replying earlier. There is no WIP or estimate yes. Only an understanding that we have to do it, it's unavoidable, and highly likely we'll need to do it in existing versions, not only in a new development branch. And Connector/C already supports OpenSSL 3.0 (CONC-503),

Re: [Maria-discuss] How can I separate one test from mysql_test

Hi, Lukas! Do you use some patches to make mariadb compile with OpenSSL-3? I thought it won't work out of the box. /Sergei On Oct 05, Lukas Javorsky wrote: > Hi guys, > > I've found few particular tests from the test suite that is failing due to > the OpenSSL-3 version and I want to separate

Re: [Maria-discuss] AWS Key management plugin key rotation in replication

Hi, Reinis! On Aug 30, Reinis Rozitis wrote: > > Slaves use their own encryption, they can use completely different set of > > keys with different rotation period. They don't have to be synchronized with > >the master. > > That is clear, > but I wanted to know in case they use the same key does

Re: [Maria-discuss] AWS Key management plugin key rotation in replication

Hi, Reinis! Slaves use their own encryption, they can use completely different set of keys with different rotation period. They don't have to be synchronized with the master. On Aug 29, Reinis Rozitis wrote: > Hello, > I wanted to clarify - does the key rotation (with AWS KMS backend) work in >

Re: [Maria-discuss] ALTER vs MODIFY to set default on a column

Hi, Shane! On Aug 12, Shane Bishop wrote: > > I originally used a query like this: ALTER TABLE wp_ewwwio_images ALTER > updated SET DEFAULT CURRENT_TIMESTAMP; > > This was speedy, and worked a treat, but now I'm finding it doesn't work on > all MySQL servers. Notably, we've run into trouble

Re: [Maria-discuss] Differences between MariaDB packages

Hi, William! You, likely, mean mariadb-server-10.2 or mariadb-server-10.3. This was a transitional period, in a sense. Debian packages have switched to the unix_socket authentication and MariaDB packages haven't. Since 10.4 both Debian and MariaDB packages use unix_socket authentication and a

Re: [Maria-discuss] OpenSSL 3.0 support

Hi, Lukas! On Jun 17, Lukas Javorsky wrote: > Hi, > > We've created two Jira tickets for the OpenSSL 3.0 support, however, we > didn't really get a response or any detailed information from you about it. > > Connector-c: https://jira.mariadb.org/browse/CONC-503 This was done today > Server:

Re: [Maria-discuss] Can't build mariadb 10.5 without gssapi?

Hi, Chris! On Apr 21, Chris Ross (cross2) wrote: > G’day there. So, I was trying to turn off the auth_gssapi plugin > which we aren’t using in our build of mariadb 10.5.8. However, adding > -DPLUGIN_AUTH_GSSAPI=NO, which is how I've turned off multiple other > plugins, seems to have no effect.

Re: [Maria-discuss] Performance of MariaDB ODBC connector

Hi, Dušan! It's now reported as a bug, see https://jira.mariadb.org/browse/ODBC-313 Note, that you can add yourself to the watch list to get notified about this issue changes. Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Apr 30, Dušan Pavlica wrote: > Hi, > >

Re: [Maria-discuss] Building mariadb without PCRE?

Hi, Chris! On Apr 19, Chris Ross (cross2) wrote: > Good day. We have been using MariaDB in our product for a while, and > are upgrading to 10.5.8 at the moment. I’ve just noticed that it’s no > longer using the PCRE on our system, it’s grabbing its own from > outside since the upgrade to PCRE2.

Re: [Maria-discuss] MEMORY tables and binlog

Hi, Dajka! This looks like a bug. Could you report it at jira.mariadb.org? Do you know when it happen, can you reproduce it at will? On Apr 07, Dajka Tamás wrote: > Hi All, > > When checking the binlog on the new-node01 with mysqlbinlog, I get the > following: > > # at 2361 > #210407 11:13:34

Re: [Maria-discuss] Is it possible to upgrade SHA-1 and MD5 algorithms in Mariadb-10.5?

Hi, Lukas! On Mar 19, Lukas Javorsky wrote: > > The main functions that are important for us is the password hashing, > certificate fingerprinting in mariadb-connector-c which uses SHA-1 or > MD5 Neither password hashing nor certificate fingerprinting, as far as I can see, use MD5. Password

Re: [Maria-discuss] Is it possible to upgrade SHA-1 and MD5 algorithms in Mariadb-10.5?

Hi, Lukas! What do you mean by "upgrade SHA-1 and MD5 algorithms in MariaDB" ? Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org On Mar 17, Lukas Javorsky wrote: > Hi, > > In RHEL-9 we are deprecating, old SHA-1 and MD5 and that's why I want to > ask you if there is any

Re: [Maria-discuss] Introduction and Task Suggestion

Hi, Hemant! On Mar 14, Hemant Kumar Singh wrote: > Hi everyone, > I am Hemant from Nepal, currently a Computer Science Junior at NIT > Warangal, India willing to take part in GSoC 2021. > > I saw a major priority task "MDEV-13648- Add FULL OUTER JOIN to > MariaDB" unresolved since gsoc 2019; but

Re: [Maria-discuss] Why does MariaDB needs SELinux capability for setuid/setgid?

Hi, Lukas! > I found that setuid/setgid is used inside mysqld_safe_helper > (mariadbd-safe-helper). > Are there any other cases when MariaDB uses these functions? Yes, in the server. If the server is started with --memlock it does mlockall(MCL_CURRENT) to prevent itself from being swapped.

Re: [Maria-discuss] Odd errors with TIMESTAMP columns

Hi, David! This is, apparently, the time when DST was enabled in the time zone in which you're doing the import. On Feb 26, David Buckley wrote: > Hello, > > I hope this is the correct list for this sort of question, apologies if not. > > I am working on importing data from a MySQL 5.1

Re: [Maria-discuss] mariadb-config sym-link in MariaDB 10.5.5

12/20, 04:39, "Sergei Golubchik" wrote: > > Hi, Chris! > > Thanks. > I've pushed a fix into a testing branch. > The commit hash is 61be53a9c40 if you want to apply it as a workaround. > > Another workaround would be to do 'mkdir -p destdir/usr/bin' > before 'ma

Re: [Maria-discuss] mariadb-config sym-link in MariaDB 10.5.5

Hi, Chris! Thanks. I've pushed a fix into a testing branch. The commit hash is 61be53a9c40 if you want to apply it as a workaround. Another workaround would be to do 'mkdir -p destdir/usr/bin' before 'make DESTDIR=destdir install' Regards, Sergei VP of MariaDB Server Engineering and

Re: [Maria-discuss] Set password for all users, regardless of host value

Hi, Chris! On Sep 07, Chris Ross (cross2) wrote: > > > On 9/5/20, 04:37, "Sergei Golubchik" wrote: > >> Hi, Chris! >> >> Yes, you can do an ALTER USER statement, something like >> >> for x in (select host from mysql.global_priv where

Re: [Maria-discuss] Set password for all users, regardless of host value

Hi, Reindl! On Sep 05, Reindl Harald wrote: > > > you can do an UPDATE too, like > > > > update mysql.global_priv set priv=json_set(priv, 'authentication_string', > > password(‘rawpassword’)) > > > > this is rather fragile and of course not recommended. > > well, why in the world was a

Re: [Maria-discuss] Set password for all users, regardless of host value

Hi, Chris! On Sep 04, Chris Ross (cross2) wrote: > Hello there. We have scripts to restore credentials to MySQL > databases from external store. The mechanism that was in use, > however, stores usernames and passwords, without consideration of the > scope (host) of that auth record. In older

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

Hi, Reindl! On Aug 24, Reindl Harald wrote: > > Am 24.08.20 um 14:23 schrieb Sergei Golubchik: > > Sorry, I couldn't understand, was 10.3 returning 3..2..1 and 10.4 > > started to return 1..2..3? Or was it the other way around? > > that at a bottom is a unified iff

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

Hi, Reindl! Sorry, I couldn't understand, was 10.3 returning 3..2..1 and 10.4 started to return 1..2..3? Or was it the other way around? I tried your table structure and your test data on both 10.3 and 10.5 and in both cases I've got 3..2..1 On Aug 21, Reindl Harald wrote: > > in all previous

Re: [Maria-discuss] MariaDB 10.4: subtle change of result ordering

Hi, Reindl! 1. Is it 10.3 to 10.4 difference? There were some optimizations that could have such an effect. https://mariadb.com/kb/en/changes-improvements-in-mariadb-104/#optimizer Can you share the table structure? 2. Technically, MyISAM only returns rows in the order of insertion if you insert

Re: [Maria-discuss] [Maria Discuss] Building from source failing on Mac OS X complaining of librarymariadb

Hi, Rodrigo! Yes. An easy workaround for you would be to run cmake -DMYSQL_MAINTAINER_MODE=OFF this will disable -Werror. I would agree that you don't have to be forced to do it and that cmake should figure it out on its own. So it's a bug. If you report it at jira.mariadb.org, we'll have it

Re: [Maria-discuss] Test failures in my build of MariaDB 10.5.4

Hi, Chris! On Aug 06, Chris Ross (cross2) wrote: > Thanks Sergei. Attached is a trimmed version of the var/stdout.log from > the recent mtr run. Let me know if there is other ancillary data for > any of these tests that I can also provide. > > - Chris > Checking supported features... >

Re: [Maria-discuss] Test failures in my build of MariaDB 10.5.4

Hi, Chris! Yes, it's the correct forum. maria-develop...@lists.launchpad.net would be an even better match, but this is good enough, no need to repost. And, yes, please post relevant parts of the log, including diffs. On Aug 06, Chris Ross (cross2) wrote: > I am building MariaDB 10.5.4 from

Re: [Maria-discuss] Specifying install libdir when building from source

Hi, Chris! On Jul 06, Chris Ross (cross2) wrote: > Hi! > > On 7/6/20, 10:36, "Sergei Golubchik" wrote: > > Hi, Chris! > > On Jul 06, Chris Ross (cross2) wrote: > > ... I want to install into /usr/lib64. Assuming there > > i

Re: [Maria-discuss] Specifying install libdir when building from source

Hi, Chris! On Jul 06, Chris Ross (cross2) wrote: > Good morning.  I have a simple question, but haven’t been able to find > the answer searching or in cmake -LH output.  How do I configure the > install paths for libraries?  By default, as expected, it installs > into /usr/lib, but I want to

Re: [Maria-discuss] Group by pushdown for JDBC or FederatedX

Hi, Dan! On Jul 03, Dan Hill wrote: > Hi! > > I'm evaluating if I can use Maria's JDBC connector to join tables from > Apache Pinot (they have a prototype jdbc connector). > > When external tables are used (like JDBC or FederatedX), are group bys > pushed down or do these connectors return the

Re: [Maria-discuss] Which binaries include support for compression zstd and lz4?

riaDB/server/commit/b4a532b27bf1ab1fd1ff2a5db9638630010b57cc > > la 27. kesäk. 2020 klo 19.58 Sergei Golubchik kirjoitti: > > > > It seems that zstd support has disappeared recently because of a bug > > introduced as a merge mistake. > > > > I've fixe

Re: [Maria-discuss] Which binaries include support for compression zstd and lz4?

Hi, Jonas! On Jun 27, Jonas Krauss wrote: > Hello all, > > I would like to have the most recent MariaDB 10.5.4 with the MyRocks plugin > and support for LZ4 *and* ZSTD compression on a Debian-based Linux distro. > > So far I have found: > >- Ubuntu 18.04, MariaDB 10.2.26 binaries support

Re: [Maria-discuss] Doubts about temporal table

Hi, Roberto! On Jun 08, Roberto Spadim wrote: > Hi folks > > Could be possible query temporal tables but instead of use a timestamp, use > a “commit” id? > > For example query first commit, second, third, ... and the last commit = > current table? Yes. See

Re: [Maria-discuss] backup from any cluster member can't be restarted and restored

Hi, Jeff! The only issue that comes to my mind is https://jira.mariadb.org/browse/MDEV-21211 It's work-in-progress and hopefully will be fixed in the next release. On May 26, Jeff Dyke wrote: > Sorry to anyone that is just catching up, the TLDR is migrated a set of > servers to 10.4 from 10.3

Re: [Maria-discuss] Data At Rest Encryption Overhead

Hi, Michael! On May 08, Michael Caplan wrote: > Hello, > > I'm working on a plan to roll out MariaDB per table data at rest > encryption.  Reading through the docs > (https://mariadb.com/kb/en/data-at-rest-encryption-overview/), I > understand that "Using encryption has an overhead of roughly

Re: [Maria-discuss] Redisql

Hi, Roberto! Yes, sure it's possible to write such an engine. Even without redisql. On Apr 18, Roberto Spadim wrote: > Hi folks > There’s a module, redisql > That allow redis server execute sqlite like queries > Could be possible a engine with this tool? It’s looks very interesting to > pub sub

Re: [Maria-discuss] transactional sql update patch system ?

Hi, launchpad! On Feb 28, launch...@rupat.de wrote: > Hello, > > we want, that a sql patch file can ONLY be applied if all commands in > it can applied successful ! If you want that you can only use statements that can be rolled back. Or set up a replication, make sure that the slave is up to

Re: [Maria-discuss] Query failure after minor upgrade 10.1.38 to 10.1.41

Hi, Benoit! This looks like https://jira.mariadb.org/browse/MDEV-20265 Fixed in 10.1.42 On Sep 20, Benoit Plessis wrote: > Hi Guys, > > We are experiencing a break in backward compatibility with the lastest > 10.1 release which got publied on the debian/stretch release. > > Queries that worked

Re: [Maria-discuss] Cannot open datafile for read-only: './dbmail/#sql2-704-271.ibd' OS error: 71

Hi, Reindl! On Sep 14, Reindl Harald wrote: > Am 14.09.19 um 14:05 schrieb Sergei Golubchik: > > Hi, Reindl! > > > > 1. Do you actually have /dbmail/*271* files ? > > no as you can see "Cannot open datafile for read-only: > './dbmail/#sql2-704-271.ibd'"

Re: [Maria-discuss] Json validation of unicode escaped strings

Hi, Manoj! This looks like https://jira.mariadb.org/browse/MDEV-19760 which was just fixed recently and should be out in the next release. On Sep 11, manoj wrote: > I am trying to insert json data in to a table with json check > constraint. The non-ascii characters are unicode escaped. > This

Re: [Maria-discuss] stability of 10.4.7

Hi, Tom! On Sep 07, Tom Ryan wrote: > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(handler_index_cond_check+0x8d)[0x5644f6c7b1fd] > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(+0x566623)[0x5644f6973623] > Sep 6 14:37:59 node-2 mysqld[1846]: >

Re: [Maria-discuss] Thread State: Unlocking tables

Hi! On Sep 04, mari...@biblestuph.com wrote: > On 9/3/2019 4:27 PM, Sergei Golubchik wrote: > > On Sep 03, mari...@biblestuph.com wrote: > >> Can someone fill me in as to what's happening behind the scenes > >> when a thread has the state "Unlocking tables?&

Re: [Maria-discuss] Thread State: Unlocking tables

Hi, mariadb! On Sep 03, mari...@biblestuph.com wrote: > Can someone fill me in as to what's happening behind the scenes when a > thread has the state "Unlocking tables?" It literally does just that, unlock tables. There's nothing that could cause a long wait, as far as I can see. > I looked

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

Hi, Benoit! On Sep 03, Benoit Plessis wrote: > > As for your 'kind suggestion' of handling deprecated/unknown option i > personnally strongly disagree, some of mysql/mariadb options have real > impact and "physical" consequences on the database, preventing it to > start because of setting not

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

Hi, Marko! On Sep 02, Marko Mäkelä wrote: > On Mon, Sep 2, 2019 at 8:48 PM Reindl Harald wrote: > > and yes, i assumed that a core developer other than you would look > > at that startup log, came to the conslusion "indeed, no warning > > there" and while read the few lines "indeed, the latest

Re: [Maria-discuss] mariadb + FIPS

Hi, Captain! On Aug 29, Captain Wiggum wrote: > Hi All, > > I have searched the archives and forums and cannot find an answer to > this question. > Does mariadb support FIPS, and if so, how or where is a document about > this. Yes, it does. The link was earlier in the thread. > I use mariadb

Re: [Maria-discuss] 10.3.x: unknown variable 'innodb_support_xa=1'

Hi, Reindl! On Sep 02, Reindl Harald wrote: > Am 02.09.19 um 17:09 schrieb Marko Mäkelä: > > On Mon, Sep 2, 2019 at 5:43 PM Reindl Harald wrote: > >> unknown variable 'innodb_support_xa=1' > >> > >> would you funny guys consider things like deperectaion warnings in > >> previous releases > > >

Re: [Maria-discuss] Subquery conversion off-switch

Hi, Slawomir! On Aug 13, pslawek83 wrote: > Hi Guys, is in_predicate_conversion_th going to be re-enabled for > release builds in some next mariadb release? If I make pull request, > will you take it?   Basically for everyone not aware about the > issue, this forced IN-predicate to subquery

Re: [Maria-discuss] Disk increase with MAD and MAI extension files in tmp dir

Hi, Kevin! When did it start? Did you, for example, upgrade from 10.3.13 to 10.3.14 and then noticed it? (I'm not saying this is a known bug in 10.3.14, it was just an example) What filesystem is it? And, don't forget, if it looks like a bug to you, report it at jira.mariadb.org to get it

Re: [Maria-discuss] Can you fix it so that you can email reply to Jira tickets?

Hi, Justin! Fixed. Regards, Sergei ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

Re: [Maria-discuss] MDB 10.4+Galera build's wsrep-lib/.../*.so libs are built, but not installed? what step's missing?

Hi, PGNet! On Aug 02, PGNet Dev wrote: > On 8/2/19 9:33 AM, Sergei Golubchik wrote: > > Yes, I've just done that, in cmake/wsrep.cmake. > > > > We never in our automated or manual builds set BUILD_SHARED_LIBS, > > so this went unnoticed until now. Thanks! >

Re: [Maria-discuss] MDB 10.4+Galera build's wsrep-lib/.../*.so libs are built, but not installed? what step's missing?

Hi, PGNet! On Aug 02, PGNet Dev wrote: > hi serg > > On 8/1/19 12:40 AM, Sergei Golubchik wrote: > > How did you build, I mean, exact commands? > > I used `cmake . && make` as the page above says, and I didn't get > > this error. > > Of course yo

Re: [Maria-discuss] MDB 10.4+Galera build's wsrep-lib/.../*.so libs are built, but not installed? what step's missing?

Hi, PGNet! On Aug 02, PGNet Dev wrote: > On 8/2/19 8:21 AM, Sergei Golubchik wrote: > > Did you set, perhaps, -DBUILD_SHARED_LIBS=ON ? > > yep. that's been 'on' for ages here. > > that'd be one of the LAST options I would've thought to look at :-/ > > iiuc, it

Re: [Maria-discuss] MDB 10.4+Galera build's wsrep-lib/.../*.so libs are built, but not installed? what step's missing?

Hi, PGNet! On Jul 26, PGNet Dev wrote: > I'm building MDB 10.4/head on linux64 > > Galera's set up for build, following > > https://mariadb.com/kb/en/library/installing-galera-from-source/ How did you build, I mean, exact commands? I used `cmake . && make` as the page above says, and I

Re: [Maria-discuss] Question on ALTER USER

Hi, Sean! Use GRANT instead of ALTER USER before 10.2 GRANT USAGE ON *.* TO 'user1'@'localhost' WITH MAX_USER_CONNECTIONS 0; On Jul 30, Sean T Shen wrote: > Thanks. In this case, the way to control connections is through global > variables? > Such as this: SET GLOBAL max_connections = 500; >

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

Hi, Reindl! On Jul 16, Reindl Harald wrote: > > > Am 16.07.19 um 21:13 schrieb Sergei Golubchik: > > you can run mysql_fix_privilege_tables.sql manually. Like with > > mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql > > how would that solve the issue of a

Re: [Maria-discuss] ERROR 1071 with mysql_upgrade

Hi, Erik! you can run mysql_fix_privilege_tables.sql manually. Like with mysql -uroot -p -vvv < mysql_fix_privilege_tables.sql Presuming FreeBSD installs this file somewhere. If it doesn't, you can extract it from mysql_upgrade with strings, I suppose. On Jul 16, Erik Cederstrand wrote: > Hi, >

Re: [Maria-discuss] Since MariaDB 10.1 aggregate functions return different field type for columns with date values

Hi, Stefan! On Jul 02, Stefan Langenmaier wrote: > Hi all, > > If I execute the following query on MariaDB 10.1 or later, the result > contains a column with a datetime field type (MYSQL_TYPE_DATETIME): > > SELECT MIN(NOW()) AS t > > On older versions or any version of MySQL this column is a

Re: [Maria-discuss] pam authentication not working after few hours

onfirm the authentication process succeeded. > In MariaDB logs I find a line like this: "[Warning] Access denied for > user 'user@'server_hostname' (using password: NO)" > > Any ideas? > > On 17/06/19 14:13, Sergei Golubchik wrote: > > Hi, Fabrizio! > >

Re: [Maria-discuss] pam authentication not working after few hours

Hi, Fabrizio! On Jun 17, Fabrizio Gerardi wrote: > Hi everyone, > > I have problems with mariadb 10.3.15 in a centos 7 environment. > > I configured mariadb to authenticate users via pam module while the > system is a member of an active directory domain. > > Everything works fine except that

Re: [Maria-discuss] mariadb 10.3.15 doesn't work

Hi, Jeff! On Jun 12, Jeff Dyke wrote: > Out of curiosity, why doesn't this release get pulled from > repositories. I understand all of the rationale behind no tests until > the bug hits(and agree with it), i've been using mysql since 4.06, or > 3.x i believe. I've never seen a "use [database]"

Re: [Maria-discuss] mariadb 10.3.15 doesn't work

Hi! It's https://jira.mariadb.org/browse/MDEV-19490 The fix is already pushed, it should be in 10.3.16 On Jun 03, mingming1 yu wrote: > Hi Expert, > > I encounter below issue with mariadb 10.3.15, any suggestions? > > BTW, it works well with 10.3.13. > # mysql -h 127.0.0.1 -u root -p > Enter

Re: [Maria-discuss] mariadb CVE

Hi, mingming1! On May 05, mingming1 yu wrote: > Hi Expert, > > I have a question how to identify a mariadb CVE issue. > > For example, per description of > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-2481, it only refers > the mysql version which are affected, but not mention any

Re: [Maria-discuss] Strange timestamp index behaviour / bug

Hi, Reinis! On Apr 01, Reinis Rozitis wrote: > Hello, > before reporting it as bug I wanted to understand what's really going > on or how to investigate it further: > > Because of the DST changes we experienced a strange issue where > afterwards a query suddenly wouldn't use an index on a

Re: [Maria-discuss] Row vs Statement Replication in 10.3

Hi, Dan! Is t1 by any chance an InnoDB table that has a foreign key relationship to another table that has an auto-increment column? If yes - it might be a bug I've fixed just this week :) On Mar 29, mari...@biblestuph.com wrote: > > "Statements writing to a table with an auto-increment column

Re: [Maria-discuss] install plugin “if not installed”?

Hi, Felipe! On Mar 29, Felipe Gasper wrote: > Hello, > > Is there any way to install a plugin via SQL but to trap the error > that comes up if the plugin is already installed? > > I’d like to do it without creating a “throwaway” procedure, if that’s > possible. Yes. There's more than one way

Re: [Maria-discuss] Row vs Statement Replication in 10.3

Hi! Try to set the binlog format to STATEMENT. Then you should get a warning that "statement is unsafe... because ..." That is, there will be some kind of an explanation. On Mar 28, mari...@biblestuph.com wrote: > Using binlog-format=MIXED I'm trying to get my head around why certain >

Re: [Maria-discuss] auth_socket.so on upgrade 5.7 -> 10.2

Hi, Felipe! On Mar 28, Felipe Gasper wrote: > Hello, > > Is mysql_upgrade meant to facilitate a migration from auth_socket.so > to MariaDB’s unix_socket.so? > > I just tried to upgrade 5.7 to 10.2 and found root@localhost (which > was set up to use MySQL auth_socket.so) was no longer able to

Re: [Maria-discuss] MariaDB 10.2.23 and MariaDB Connector/J 2.4.1 now available

Hi, Reindl! Sorry. You have a highly customized configuration that doesn't match anything we test, so these issues happen sometimes :( I've now added -DENABLED_PROFILING=OFF to one of our builders, so this particular failure won't happen again. We also test -DPLUGIN_PERFSCHEMA=NO and

Re: [Maria-discuss] Why does local root need a password?

Hi, Felipe! On Mar 25, Felipe Gasper wrote: > Hello, > > I’ve submitted a proposal to the MySQL team to allow the system > administrator, when logging in via a local socket that indicates > reliably that the DB client is the superuser (e.g., SO_PEERCRED in > Linux), to not need a password. As

Re: [Maria-discuss] mysqld --initialize

Hi, Sergey! On Mar 22, Sergey Vojtovich wrote: > Hi! > > Please accept my vote against this feature. I don't think mysqld > should carry code that is otherwise only needed for initialisation. > > At the same time I'm not big fan of mysql_install_db. My preference is to > have some C++ mariatool

Re: [Maria-discuss] mysqld --initialize

Hi, Felipe! On Mar 21, Felipe Gasper wrote: > Hi all, > > Does MariaDB intend to support “mysqld --initialize”? > > Thank you! We've just discussed that a couple of days ago :) I don't think there was anyone against supporting it, so I'd answer your question with "yes". But when it'll be

Re: [Maria-discuss] MariaDB version of Function Name Parsing and Resolution

Hi! On Mar 18, mari...@biblestuph.com wrote: > Is there anywhere a MariaDB specific version of the document here: > > https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html > > Or can someone just tell me which functions are affected by IGNORE_SPACE > for MariaDB 10.3? I'm guessing

Re: [Maria-discuss] Server system variables which description I haven't found

Hi, Michal! On Feb 27, Michal Schorm wrote: > > Stack trace: > Does that mean without "--stack-trace" I won't get the trace? stack-trace is enabled by default. You will not get the stack trace if you'll use --disable-stack-trace > gdb: > I understand it as "--gdb" is meant for runtime

  1   2   3   4   >