- discuss - lists.mariadb.org

[Maria-discuss] New error code
by Олег Царев 03 Aug '10

03 Aug '10

Hi people, I solve trouble from previous letter by insert fictive errors. Now i have one more trouble - should add new error message to 5.1, bug i should respect forward compatible with mysql 5.5 What the error number get? Does mysql have reserved intervals for third-party patches? Thank you, Oleg.

2 1

[Maria-discuss] Error messages and Error codes (backport 5.5 => 5.1)
by Олег Царев 01 Aug '10

01 Aug '10

Hello all, I have troubles with backport some errors from 5.5 to 5.1 http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_… http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html#error_er_… Last error in mysql 5.1.49 - 1640. If i just add ER_QUERY_CACHE_DISABLED --- a/sql/share/errmsg.txt 2010-07-09 16:35:08.000000000 +0400 +++ b/sql/share/errmsg.txt 2010-07-31 20:41:47.244015659 +0400 @@ -6213,3 +6213,7 @@ ER_DEBUG_SYNC_HIT_LIMIT eng "debug sync point hit limit reached" ger "Debug Sync Point Hit Limit erreicht" + +ER_QUERY_CACHE_DISABLED + eng "Query cache is disabled; restart the server with query_cache_type=1 to enable it" + then error code of ER_DEBUG_SYNC_HIT_LIMIT is 1641 (instead of 1651 what i need). If i try: --- a/sql/share/errmsg.txt 2010-07-09 16:35:08.000000000 +0400 +++ b/sql/share/errmsg.txt 2010-07-31 20:41:47.244015659 +0400 @@ -6213,3 +6213,8 @@ ER_DEBUG_SYNC_HIT_LIMIT eng "debug sync point hit limit reached" ger "Debug Sync Point Hit Limit erreicht" + +start-error-number 1010 +ER_QUERY_CACHE_DISABLED + eng "Query cache is disabled; restart the server with query_cache_type=1 to enable it" + then mysql doesn't start with error in bootstrap.log like: "mysqld can't srart because errmsg.sys has only 642 errors, when last error number is ...." How can i backport error from mysql 5.5 to mysql 5.1 right? Now i solve trouble like: --- a/sql/share/errmsg.txt 2010-07-09 16:35:08.000000000 +0400 +++ b/sql/share/errmsg.txt 2010-07-31 20:41:47.244015659 +0400 @@ -6213,3 +6213,27 @@ ER_DEBUG_SYNC_HIT_LIMIT eng "debug sync point hit limit reached" ger "Debug Sync Point Hit Limit erreicht" + +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_01 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_02 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_03 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_04 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_05 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_06 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_07 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_08 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_09 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED_WRITE_SPACE_10 + eng "Fix error number for ER_QUERY_CACHE_DISABLED" +ER_QUERY_CACHE_DISABLED + eng "Query cache is disabled; restart the server with query_cache_type=1 to enable it" + But this is ugly hack. What do you think about my trouble and ways for solve? Best regards, Oleg.

2 1

[Maria-discuss] Possible CVE from upstream
by Brian Evans 29 Jul '10

29 Jul '10

This seems to affect the released versions of MariaDB as well since they are based on 5.1.47 upstream as far as I can tell. CVE-2010-2008 (http://nvd.nist.gov/nvd.cfm?cvename=CVE-2010-2008) MySQL before 5.1.48 allows remote authenticated users with alter database privileges to cause a denial of service (server crash and database loss) via an ALTER DATABASE command with a #mysql50# string followed by a . (dot), .. (dot dot), ../ (dot dot slash) or similar sequence, and an UPGRADE DATA DIRECTORY NAME command, which causes MySQL to move certain directories to the server data directory.

1 0

[Maria-discuss] where are the buildbot results for valgrind and the InnoDB plugin?
by MARK CALLAGHAN 25 Jul '10

25 Jul '10

As described in http://mysqlha.blogspot.com/2010/07/building-mariadb-with-innodb-plugin.html I did some of the QA checks that I do for any new code that I might use. I have yet to find buildbot results for valgrind and the InnoDB plugin or XtraDB. Are they not run for buildbot? -- Mark Callaghan mdcallag(a)gmail.com

2 5

[Maria-discuss] (no subject)
by Justin Swanhart 16 Jun '10

16 Jun '10

http://wafejqh.wifethen.ru -- -- Justin Swanhart, Consultant, Percona Inc. Bay Area, USA (PDT, GMT -7) +1 888 401 3401 | Justin x503 | 24x7 Help x911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/

3 2

[Maria-discuss] OpenSQLCamp EU Call for Papers
by Henrik Ingo 31 May '10

31 May '10

Giuseppe Maxia wanted me to bring to your attention, that the Call for Papers for OpenSQLCamp EU is now open: http://opensqlcamp.org/Events/2010/Call_for_Participation "The European OpenSQLCamp 2010 will take place in parallel to the Free and Open Source Conference 2010 (FrOSCon) on Saturday 21st and Sunday 22nd August at the Fachhochschule Bonn-Rhein-Sieg in St. Augustin, Germany. St. Augustin is located close to Bonn and Cologne. " henrik -- Henrik Ingo Project Manager and COO, Monty Program Ab hingo(a)askmonty.org, skype:henrik.ingo, +358405697354 http://askmonty.org/wiki/index.php/About_Us What's up with MariaDB? http://askmonty.org/wiki/index.php/MariaDB

1 0

[Maria-discuss] Please help me clear this simple but critical issue [SELECT INTO OUTFILE LOCAL]
by Cool Guy 20 May '10

20 May '10

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... Now, we moved the database to a different server and SELECT * INTO OUTFILE .... no longer works, understandable - security reasons I believe. But, interestingly LOAD DATA INFILE .... can be changed to LOAD DATA LOCAL INFILE .... and bam, it works. I am not complaining nor am I expressing disgust towards MySQL. The alternative to that added 2 lines of extra code and a system call form a .sql script. All I wanted to know is why LOAD DATA LOCAL INFILE works and why is there no such thing as SELECT INTO OUTFILE LOCAL? I did my homework, couldn't find a direct answer to my questions above. I couldn't find a feature request @ MySQL either. If someone can clear that up, that had be awesome! I am planning on suggesting MariaDB to our company cos' it is not under Oracle's admin. Does MariaDB already have this "SELECT INTO OUTFILE LOCAL .." feature implemented or is it in the wishlist/to-do list? Thank you, Kiran

3 14

[Maria-discuss] Someone from MariaDB to talk at ODTUG conference?
by Henrik Ingo 11 May '10

11 May '10

Hi all I just had a talk with Sheeri about an upcoming Oracle Developer Tools User Group conference in June in Washington. There will be a 1 day MySQL track on Sunday, plus possibly some other MySQL talks: http://www.odtugkaleidoscope.com/agenda.html Sheeri was asking if someone from Monty Program (or, imho any MariaDB activist) wanted to present. Things to note: - The conference is application developer oriented, so things like optimizer internals or tuning InnoDB buffer size is not interesting. - We don't want to talk about MariaDB per se. We don't want to introduce this crowd to the reality of there being so many MySQL forks. The previous points pretty much rule out everything we presented at the MySQL conference :-) Good topics could be: - Efficient and inefficient SQL queries in MySQL - UDF tutorial and examples The first suggestion is imho good. These Oracle experts need to learn to avoid certain things like most subqueries, and how to work around that. But on the other hand this is a natural topic for someone from us to present, since we could then also mention that correlated subqueries will work creat in MariaDB 5.3, which may even be beta by this point? The second suggestion is an example of something that would be considered very technical topic in this conference. Now the question is who to send there? This is not significant enough that someone from Europe would fly in - heh, most of us would probably not volunteer themselves at this point :-) In US I see Bryan or Daniel as candidates for this, Igor possibly for the UDF kind of talk more than the app developer talk. And, it needn't be a Monty Program employee, let me know if you're interested. Colin, will you pick this up from here? henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

1 1

[Maria-discuss] PBXT issues
by Alexandre Almeida 06 May '10

06 May '10

Hi Guys, I am setting an enviroment with MariaDB + PBXT, but, I am pretty much disappointed. Do you know if this time (see below) makes sense? Five hours to create a PBXT table with 10mio records... It's too much!!! See my steps: create table telpbxt like telinno; Query OK, 0 rows affected (0,50 sec) fis-> alter table telpbxt engine = pbxts; Query OK, 0 rows affected, 1 warning (0,07 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> alter table telpbxt engine = pbxt; Query OK, 0 rows affected (0,26 sec) Records: 0 Duplicates: 0 Warnings: 0 fis-> show create table telpbxt; +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | telpbxt | CREATE TABLE `telpbxt` ( `cpf` bigint(20) DEFAULT NULL, `nome` varchar(100) DEFAULT NULL, `log` varchar(100) DEFAULT NULL, `endereco` varchar(100) DEFAULT NULL, `comp1` varchar(100) DEFAULT NULL, `comp2` varchar(100) DEFAULT NULL, `bairro` varchar(100) DEFAULT NULL, `cidade` varchar(100) DEFAULT NULL, `cep` varchar(100) DEFAULT NULL, `ddd` varchar(100) DEFAULT NULL, `telefone` varchar(100) DEFAULT NULL, KEY `idx2` (`nome`(10)) ) ENGINE=PBXT DEFAULT CHARSET=latin1 | +--------- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0,00 sec) fis-> insert into telpbxt select * from tel; Query OK, 10262048 rows affected (5 hours 2 min 22,14 sec) Records: 10262048 Duplicates: 0 Warnings: 0

4 11

[Maria-discuss] bug or not bug? ;-)
by Alexandre Almeida 05 May '10

05 May '10

Guys, everytime I run the following command: show global status like 'created%tmp%tables' the created_tmp_tables is incremented by 1. Is that right? I mean, which relationship between a show global (that will perform a minimum select at information_schema) and a new temporary table? I would appreciate your comments. Alex

2 2