- discuss - lists.mariadb.org

[Maria-discuss] Frequently running Event overlapping itself
by Brian Evans 17 Aug '11

17 Aug '11

I have an issue where a fast triggering event, running every 30 seconds, is occasionally running multiple times without each finishing. This is causing duplicate data as things are marked done one at a time. I am trying to figure a solution such that this event can only run singly, but what is the best way? DISABLE at start and ENABLE at end? Do SESSION variables work between event invocations?

2 2

[Maria-discuss] Installation issues with PHP5
by Daniel Bartholomew 15 Aug '11

15 Aug '11

A few comments were posted yesterday to the following Knowledgebase article: https://kb.askmonty.org/en/installation-issues-with-php5 The poster is getting mysql_connect errors. He's using CentOS 5 64bit, PHP 5.2, and recently upgraded from MySQL 5.0.77 to MariaDB 5.3. If you have any experience in this area, please consider jumping in and replying to the comments. Thanks! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Bug reporting
by planas 06 Aug '11

06 Aug '11

How does one post a bug? install issue with MariaDB-server-5.2 and 5.3 - fatal, crash on install Ubuntu 11.04 see below for terminal reports for both sudo apt-get install mariadb-server-5.2 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-core-5.2 mysql-common Suggested packages: mailx mariadb-test The following NEW packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.2 mariadb-client-core-5.2 mariadb-server-5.2 mariadb-server-core-5.2 mysql-common 0 upgraded, 8 newly installed, 0 to remove and 2 not upgraded. Need to get 21.4 MB/21.5 MB of archives. After this operation, 51.2 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mysql-common all 5.2.7-mariadb101~natty [10.6 kB] Get:2 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main libmariadbclient16 amd64 5.2.7-mariadb101~natty [1,454 kB] Get:3 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main libmysqlclient16 amd64 5.2.7-mariadb101~natty [4,300 B] Get:4 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-client-core-5.2 amd64 5.2.7-mariadb101~natty [93.7 kB] Get:5 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-client-5.2 amd64 5.2.7-mariadb101~natty [1,759 kB] Get:6 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-core-5.2 amd64 5.2.7-mariadb101~natty [4,474 kB] Get:7 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-5.2 amd64 5.2.7-mariadb101~natty [13.6 MB] Fetched 21.4 MB in 6s (3,166 kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 458443 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.2.7-mariadb101~natty_all.deb) ... Selecting previously deselected package libmariadbclient16. Unpacking libmariadbclient16 (from .../libmariadbclient16_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from .../libmysqlclient16_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.2. Unpacking mariadb-client-core-5.2 (from .../mariadb-client-core-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-client-5.2. Unpacking mariadb-client-5.2 (from .../mariadb-client-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-server-core-5.2. Unpacking mariadb-server-core-5.2 (from .../mariadb-server-core-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for menu ... Setting up mysql-common (5.2.7-mariadb101~natty) ... Selecting previously deselected package mariadb-server-5.2. (Reading database ... 458622 files and directories currently installed.) Unpacking mariadb-server-5.2 (from .../mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up libmysqlclient16 (5.2.7-mariadb101~natty) ... Setting up libmariadbclient16 (5.2.7-mariadb101~natty) ... Setting up libdbd-mysql-perl (4.016-1) ... Setting up mariadb-client-core-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-client-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-server-core-5.2 (5.2.7-mariadb101~natty) ... Setting up mariadb-server-5.2 (5.2.7-mariadb101~natty) ... ' * Stopping MariaDB database server mysqld [ OK ] 110805 19:21:20 [Note] Plugin 'PBXT' is disabled. 110805 19:21:20 [Note] Plugin 'InnoDB' is disabled. * Starting MariaDB database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mariadb-server-5.2 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for menu ... Errors were encountered while processing: mariadb-server-5.2 E: Sub-process /usr/bin/dpkg returned an error code (1) sudo apt-get install mariadb-server-5.3 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.3 mariadb-client-core-5.3 mariadb-server-core-5.3 mysql-common Suggested packages: mailx mariadb-test The following NEW packages will be installed: libdbd-mysql-perl libmariadbclient16 libmysqlclient16 mariadb-client-5.3 mariadb-client-core-5.3 mariadb-server-5.3 mariadb-server-core-5.3 mysql-common 0 upgraded, 8 newly installed, 0 to remove and 2 not upgraded. Need to get 22.8 MB of archives. After this operation, 56.5 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mysql-common all 5.3.0-mariadb101~natty [10.7 kB] Get:2 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main libmariadbclient16 amd64 5.3.0-mariadb101~natty [1,517 kB] Get:3 http://us.archive.ubuntu.com/ubuntu/ natty/main libdbd-mysql-perl amd64 4.016-1 [140 kB] Get:4 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main libmysqlclient16 amd64 5.3.0-mariadb101~natty [4,356 B] Get:5 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-client-core-5.3 amd64 5.3.0-mariadb101~natty [94.1 kB] Get:6 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-client-5.3 amd64 5.3.0-mariadb101~natty [1,760 kB] Get:7 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-server-core-5.3 amd64 5.3.0-mariadb101~natty [4,719 kB] Get:8 http://ftp.osuosl.org/pub/mariadb/repo/5.3/ubuntu/ natty/main mariadb-server-5.3 amd64 5.3.0-mariadb101~natty [14.5 MB] Fetched 22.8 MB in 6s (3,556 kB/s) Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 458566 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.3.0-mariadb101~natty_all.deb) ... Selecting previously deselected package libmariadbclient16. Unpacking libmariadbclient16 (from .../libmariadbclient16_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from .../libmysqlclient16_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_amd64.deb) ... Selecting previously deselected package mariadb-client-core-5.3. Unpacking mariadb-client-core-5.3 (from .../mariadb-client-core-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-client-5.3. Unpacking mariadb-client-5.3 (from .../mariadb-client-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Selecting previously deselected package mariadb-server-core-5.3. Unpacking mariadb-server-core-5.3 (from .../mariadb-server-core-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for menu ... Setting up mysql-common (5.3.0-mariadb101~natty) ... Selecting previously deselected package mariadb-server-5.3. (Reading database ... 458747 files and directories currently installed.) Unpacking mariadb-server-5.3 (from .../mariadb-server-5.3_5.3.0-mariadb101~natty_amd64.deb) ... Processing triggers for man-db ... Processing triggers for ureadahead ... Setting up libmysqlclient16 (5.3.0-mariadb101~natty) ... Setting up libmariadbclient16 (5.3.0-mariadb101~natty) ... Setting up libdbd-mysql-perl (4.016-1) ... Setting up mariadb-client-core-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-client-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-server-core-5.3 (5.3.0-mariadb101~natty) ... Setting up mariadb-server-5.3 (5.3.0-mariadb101~natty) ... * Stopping MariaDB database server mysqld [ OK ] 110805 19:01:37 [Note] Plugin 'PBXT' is disabled. 110805 19:01:37 [Note] Plugin 'InnoDB' is disabled. * Starting MariaDB database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mariadb-server-5.3 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for menu ... Errors were encountered while processing: mariadb-server-5.3 E: Sub-process /usr/bin/dpkg returned an error code (1) I have spent days trying to fully resolve this. One should be able uninstall and reinstall a package as needed without tracking down bugs in the installer or uninstaller scripts. Logs have been blank or just repeat the above information. -- Jay Lozier jslozier(a)gmail.com

2 1

[Maria-discuss] Cannot install Mariadb-server-5.2
by planas 04 Aug '11

04 Aug '11

Hi I have been struggling to get mariadb to work. My problems have been either the server is very erratic, usually will not start it. After trying a complete reinstall I can not install the mariadb-server-5.2 package either from the repository or from a deb. I am using Ubuntu/Pinguy 11.04. The installation results from apt-get or aptitude are sudo aptitude install mariadb-server-5.2 The following NEW packages will be installed: mariadb-server-5.2 0 packages upgraded, 1 newly installed, 0 to remove and 21 not upgraded. Need to get 13.6 MB of archives. After unpacking 30.8 MB will be used. Get:1 http://ftp.osuosl.org/pub/mariadb/repo/5.2/ubuntu/ natty/main mariadb-server-5.2 amd64 5.2.7-mariadb101~natty [13.6 MB] Fetched 13.6 MB in 4s (2,733 kB/s) Preconfiguring packages ... (Reading database ... 427308 files and directories currently installed.) Unpacking mariadb-server-5.2 (from .../mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb) ... Aborting downgrade from (at least) 5.3 to 5.2. If are sure you want to downgrade to 5.2, remove the file /var/lib/mysql/debian-*.flag and try installing again. dpkg: error processing /var/cache/apt/archives/mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb (--unpack): subprocess new pre-installation script returned error exit status 1 Errors were encountered while processing: /var/cache/apt/archives/mariadb-server-5.2_5.2.7-mariadb101~natty_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: I tried MySQL 5.1.7 from the Ubuntu repository and got the same results. Searching various forums/online information has not turned up an answer including MySQL and Ubuntu. -- Jay Lozier jslozier(a)gmail.com

2 1

[Maria-discuss] A couple of new questions in the Knowledgebase
by Daniel Bartholomew 02 Aug '11

02 Aug '11

All, While I was out on vacation it appears a couple of new questions were posted to the Knowledgebase. If you have some time, please take a look. Thanks! Missing mysqld.sock file http://kb.askmonty.org/en/missing-mysqldsock-file and myisam_use_mmap does not use mmap after a massive insert http://kb.askmonty.org/en/myisam_use_mmap-does-not-use-mmap-after-a-massive… -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

2 1

[Maria-discuss] MariaDB 5.3 on lenny crashing about every 8 minutes
by Carsten Bernhard 02 Aug '11

02 Aug '11

Hi, I have installed MariaDB 5.3 from the apt packages on a lenny amd64 machine. Initial setup went fine and the database is working correctly. When I give some load to the machine I get crashes about every 8 minutes. This is what the log shows: Jul 29 00:36:17 svn mysqld: 110729 0:36:17 [ERROR] mysqld got signal 11 ; Jul 29 00:36:17 svn mysqld: This could be because you hit a bug. It is also poss ible that this binary Jul 29 00:36:17 svn mysqld: or one of the libraries it was linked against is cor rupt, improperly built,Jul 29 00:36:17 svn mysqld: or misconfigured. This error can also be caused by m alfunctioning hardware. Jul 29 00:36:17 svn mysqld: We will try our best to scrape up some info that will hopefully help diagnose Jul 29 00:36:17 svn mysqld: the problem, but since we have already crashed, some thing is definitely wrongJul 29 00:36:17 svn mysqld: and this may fail. Jul 29 00:36:17 svn mysqld: Jul 29 00:36:17 svn mysqld: key_buffer_size=0 Jul 29 00:36:17 svn mysqld: read_buffer_size=2097152 Jul 29 00:36:17 svn mysqld: max_used_connections=13 Jul 29 00:36:17 svn mysqld: max_threads=102 Jul 29 00:36:17 svn mysqld: threads_connected=1 Jul 29 00:36:17 svn mysqld: It is possible that mysqld could use up toJul 29 00:36:17 svn mysqld: key_buffer_size + (read_buffer_size + sort_buffer_si ze)*max_threads = 627994 K Jul 29 00:36:17 svn mysqld: bytes of memoryJul 29 00:36:17 svn mysqld: Hope that's ok; if not, decrease some variables in t he equation. Jul 29 00:36:17 svn mysqld: Jul 29 00:36:17 svn mysqld: Thread pointer: 0x7f1740013780Jul 29 00:36:17 svn mysqld: Attempting backtrace. You can use the following info rmation to find outJul 29 00:36:17 svn mysqld: where mysqld died. If you see no messages after this , something went Jul 29 00:36:17 svn mysqld: terribly wrong... Jul 29 00:36:17 svn mysqld: stack_bottom = 0x41614110 thread_stack 0x48000Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e) [0x7f176c 0dc1de]Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_segfault+0x448) [0x7f176bce3 de8] Jul 29 00:36:17 svn mysqld: /lib/libpthread.so.0 [0x7f176a281a80]Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0x22) [0x7f176bd68 c52] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_derived_optimize(THD*, st_lex*, TABLE_LIST*)+0x12e) [0x7f176be52fbe] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_handle_single_derived(st_lex*, TABLE_LIST*, unsigned int)+0x10e) [0x7f176be53c3e] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(st_select_lex::handle_derived(st_lex*, unsigned int)+0x48) [0x7f176bc07528] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0xb2) [0x7f176bd68ce2] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_derived_optimize(THD*, st_lex*, TABLE_LIST*)+0x12e) [0x7f176be52fbe] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_handle_single_derived(st_lex*, TABLE_LIST*, unsigned int)+0x10e) [0x7f176be53c3e] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(st_select_lex::handle_derived(st_lex*, unsigned int)+0x48) [0x7f176bc07528] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(JOIN::optimize()+0xb2) [0x7f176bd68ce2] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x104) [0x7f176bd70a84] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x171) [0x7f176bd714c1] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld [0x7f176bcef8fb] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_execute_command(THD*)+0x1ef9) [0x7f176bcf2239] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c1) [0x7f176bcf6181] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xde1) [0x7f176bcf8941] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(do_command(THD*)+0x100) [0x7f176bcf9230] Jul 29 00:36:17 svn mysqld: /usr/sbin/mysqld(handle_one_connection+0xe4) [0x7f176bceacf4] Jul 29 00:36:17 svn mysqld: /lib/libpthread.so.0 [0x7f176a279fc7] Jul 29 00:36:17 svn mysqld: /lib/libc.so.6(clone+0x6d) [0x7f176985764d] Jul 29 00:36:17 svn mysqld: Jul 29 00:36:17 svn mysqld: Trying to get some variables. Jul 29 00:36:17 svn mysqld: Some pointers may be invalid and cause the dump to abort. Jul 29 00:36:17 svn mysqld: Query (0x7f176ec35988): SELECT * FROM ( Jul 29 00:36:17 svn mysqld: SELECT @rn := if( @lc = l.l_contentid, @rn +1, 0 ) AS rnum, @lc := l_contentid, l.* Jul 29 00:36:17 svn mysqld: FROM vb3_vbseo_likes l, (SELECT @rn :=0, @lc :=0) r Jul 29 00:36:17 svn mysqld: WHERE l_ctype = 1 AND l_cgroup =39820 AND l_contentid IN (289195,289196 ) Jul 29 00:36:17 svn mysqld: ORDER BY l_contentid Jul 29 00:36:17 svn mysqld: ) as nest Jul 29 00:36:17 svn mysqld: where rnum<3 Jul 29 00:36:17 svn mysqld: Connection ID (thread ID): 511 Jul 29 00:36:17 svn mysqld: Status: NOT_KILLED Jul 29 00:36:17 svn mysqld: Jul 29 00:36:17 svn mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Jul 29 00:36:17 svn mysqld: information that should help you find out what is causing the crash. Jul 29 00:36:17 svn mysqld_safe: Number of processes running now: 0 Jul 29 00:36:17 svn mysqld_safe: mysqld restarted Just to confirm the installed packages: dpkg --get-selections | grep maria libmariadbclient16 install mariadb-client-5.3 install mariadb-client-core-5.3 install mariadb-server-5.3 install mariadb-server-core-5.3 install Any pointers? Cheers, Carsten

3 2

[Maria-discuss] MariaDB on Windows and Aria Temp Tables
by Brian Evans 01 Aug '11

01 Aug '11

I recently installed MariaDB 5.2.7 Win-x64 to a machine from http://downloads.askmonty.org/mariadb/. When I did 'SELECT @@aria_used_for_temp_tables;', it returned 0. I know this a compile time option and was wondering if this was intended. Several references I've found point that it is meant to be enabled by default. Thanks

2 1

[Maria-discuss] Help with RPM src build
by bwellsnc 22 Jul '11

22 Jul '11

I have gone over every document concerning building mariadb using src rpm. I am trying to build mariadb against RHEL 6. I have run rpmbuild against the src rpm and I get this error everytime: error: configure: error: C compiler cannot create executables The instructions, I have to admit, are not very good about building using the source rpm. If there is anyone who has a better howto, I would really appreciate it. Thanks! Brent

3 11

[Maria-discuss] mariadb runs at lowest priority (nice -n 19)
by Panayot Belchev 13 Jun '11

13 Jun '11

Hi, I just noticed that all our MariaDB 5.2 servers show the same: $ ps -eo ni,comm |grep mysql 9 mysqld_safe 19 mysql_isam_spac <defunct> 19 mysqld While servers with Oracle MySQL are at nice -n 0 I tried setting niceness=-10 in /usr/bin/mysqld_safe but with no effect. Is there a reason to run MariaDB at the lowest possible priority and is there a way to change that?

4 7

[Maria-discuss] XtraDB using the Windows Installer
by Jake Drew 09 Jun '11

09 Jun '11

I have a couple of questions regarding XtraDB. 1. I am curious, if XtraDB is turned on / installed by default when MariaDB is installed using the windows installer on a Windows 2008 R2 server? 2. Is this default behavior the same in 5.1.53 and 5.2.6? 3. How can I tell if XtraDB is currently installed on any given MariaDB install? i.e. Is there a SHOW or other similar command I can run to confirm that XtraDB is installed?

5 4