August 2011 - discuss - lists.mariadb.org

Re: [Maria-discuss] GUI/Workbench for MariaDB Aria?
by Peter Laursen 31 Aug '11

31 Aug '11

'transactional' in Aria will eanable crash recovery for the table. It will not make the table transactional (ie. START TRANSACTION, COMMIT, ROLLBACK etc.) are still ignored. Probably it was originaly intended to have it trasactional over time but I do not think focus is there at the moment. Byt yes .. it is just a checkbox and would be simple to add to any GUI (conditionally if engine = ARIA). But I think that if people want (user-)tables with the Aria engine you would use '1' in most if not all cases (temproary tables created by server internally is another thing). -- Peter On Wed, Aug 31, 2011 at 07:47, Ansgar Becker <ansgar.becker(a)googlemail.com>wrote: > Hi all, > I'm a bit unsure what this option really does, now that Peter said it > doesn't make a table transactional, but I'm sure there is a reason for why > it exists. So I'll see if I can add a checkbox right besides the engine drop > down, which is enabled only if Aria is selected. Also I need to read out > this attribute in existing tables, which needs some adjustment in my CREATE > TABLE parser. > > Ansgar > > Am 30.08.2011 19:31, schrieb Peter Laursen: > > We have the same request for SQLyog: > http://code.google.com/p/sqlyog/issues/detail?id=538 > > Of course a client is never engine-specific. But that is not the same > that a client has GUI fucntionalities to su > > @Vlad you probably know that your company (Monty Program) and mine > (Webyog) are partners (what means customers will gain a rebate to our > products when comming from Monty Program website. Check it out or ask Monty > himself). Not that I would mind that Ansgar adds this to Heidi. But > basically we never found it very important. Even if ARIA is set to > transactioanl = 1 , it is not transactional. it has crash recovery what is > not the same. > > > Peter > Webyog > > On Tue, Aug 30, 2011 at 19:11, Vladislav Vaintroub <wlad(a)montyprogram.com>wrote: > >> I'm forwarding this to Ansgar, as a feature request for HeidiSQL. May be >> tricky to add it as Aria-specific option, currently CREATE TABLE >> options/checkboxes in HeidiSQL seem to be not engine dependent to me. >> >> > -----Original Message----- >> > From: maria-discuss- >> > bounces+wlad=montyprogram.com(a)lists.launchpad.net [mailto:maria- >> > discuss-bounces+wlad=montyprogram.com(a)lists.launchpad.net] On Behalf >> > Of Daniel Bartholomew >> > Sent: Dienstag, 30. August 2011 18:50 >> > To: Maria Discuss >> > Subject: [Maria-discuss] GUI/Workbench for MariaDB Aria? >> > >> > New question on the Knowledgebase: >> > >> > http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria >> > >> > Does anybody know a good GUI/Work bench tool to handle ARIA >> > transactional=1/0 and row_format=PAGE situations? >> > >> > Thanks. >> > >> > -- >> > Daniel Bartholomew >> > MariaDB - http://mariadb.org >> > Monty Program - http://montyprogram.com >> > AskMonty Knowledgebase - http://kb.askmonty.org >> > >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~maria-discuss >> > Post to : maria-discuss(a)lists.launchpad.net >> > Unsubscribe : https://launchpad.net/~maria-discuss >> > More help : https://help.launchpad.net/ListHelp >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > > >

1 0

[Maria-discuss] Good GUI
by md＠rpzdesign.com 30 Aug '11

30 Aug '11

Hello: I have been using Navicat to administer my Oracle/Sun based MySQL servers for years. (www.navicat.com) Now I am switched over to MariaDB 2.8 using ARIA engine. What do MariaDB users recommend of good GUI front end that allows me to manage ARIA Create Table Transactional=0|1 Row_format=PAGE setting. Most Tools do not support all of the MariaDB settings in the table setup dialogs. Suggestions appreciated... md

3 2

[Maria-discuss] GUI/Workbench for MariaDB Aria?
by Daniel Bartholomew 30 Aug '11

30 Aug '11

New question on the Knowledgebase: http://kb.askmonty.org/en/guiworkbench-for-mariadb-aria Does anybody know a good GUI/Work bench tool to handle ARIA transactional=1/0 and row_format=PAGE situations? Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

3 2

[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