- discuss - lists.mariadb.org

[Maria-discuss] Mariadb 10.0.11 "ERROR 2013 (HY000): Lost connection to MySQL server during query". Help fixing?
by grantksupport＠operamail.com 14 Jun '14

14 Jun '14

I'm running Mariadb 10.0.11 on linux/64. Connected to my DB, executing similar queries, one succeeds, the next fails @ error "ERROR 2013 (HY000): Lost connection to MySQL server during query" There's a backtrace included below. I'm not sure what it tells me about the problem, or what to do about. Any help or suggestions would be appreciated. Here are the queries MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='tagclouds'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='tagclouds'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='system_charts'; ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='system_charts'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 3 Current database: dTEST ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='system_charts'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 3 Current database: dTEST ERROR 2013 (HY000): Lost connection to MySQL server during query MariaDB [dTEST]> UPDATE system SET status='0' WHERE name='tagclouds'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 3 Current database: dTEST Query OK, 0 rows affected (0.09 sec) Rows matched: 1 Changed: 0 Warnings: 0 MariaDB [dTEST]> Here's the -err log on failed exec of UPDATE system SET status='0' WHERE name='system_charts'; tail -f /var/log/mariadb/mariadb-err.log 140612 22:34:39 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.0.11-MariaDB-log key_buffer_size=268435456 read_buffer_size=1048576 max_used_connections=1 max_threads=66 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 601410 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7f2de93f1008 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f2e11fe5e78 thread_stack 0x100000 /usr/local/mariadb/bin/mysqld(my_print_stacktrace+0x2e)[0xacb60e] /usr/local/mariadb/bin/mysqld(handle_fatal_signal+0x390)[0x6f5a10] /lib64/libpthread.so.0(+0xf9f0)[0x7f2e177f79f0] /usr/local/mariadb/bin/mysqld[0x915cba] /usr/local/mariadb/bin/mysqld[0x909e27] /usr/local/mariadb/bin/mysqld[0x90a35b] /usr/local/mariadb/bin/mysqld[0x916853] /usr/local/mariadb/bin/mysqld[0x8a9aa6] /usr/local/mariadb/bin/mysqld[0x8ab639] /usr/local/mariadb/bin/mysqld[0x8cd5a7] /usr/local/mariadb/bin/mysqld[0x8d0cfc] /usr/local/mariadb/bin/mysqld[0x8b5777] /usr/local/mariadb/bin/mysqld[0x82ef43] /usr/local/mariadb/bin/mysqld(_ZN7handler13ha_update_rowEPKhPh+0xe5)[0x6fedc5] /usr/local/mariadb/bin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_+0x10e2)[0x641922] /usr/local/mariadb/bin/mysqld(_Z21mysql_execute_commandP3THD+0x191b)[0x5b923b] /usr/local/mariadb/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1d7)[0x5bf4f7] /usr/local/mariadb/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x15d7)[0x5c1057] /usr/local/mariadb/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x20c)[0x66f0ec] /usr/local/mariadb/bin/mysqld(handle_one_connection+0x38)[0x66f138] /usr/local/mariadb/bin/mysqld[0x9d5184] /lib64/libpthread.so.0(+0x80db)[0x7f2e177f00db] /lib64/libc.so.6(clone+0x6d)[0x7f2e164a090d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f2dd8c3e020): UPDATE system SET status='0' WHERE name='system_charts' Connection ID (thread ID): 3 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140612 22:34:39 mysqld_safe Number of processes running now: 0 140612 22:34:39 mysqld_safe mysqld restarted 2014-06-12 22:34:39 7f025c6d9780 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 140612 22:34:39 [Note] InnoDB: Using mutexes to ref count buffer pool pages 140612 22:34:39 [Note] InnoDB: The InnoDB memory heap is disabled 140612 22:34:39 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 140612 22:34:39 [Note] InnoDB: Compressed tables use zlib 1.2.8 140612 22:34:39 [Note] InnoDB: Using Linux native AIO 140612 22:34:39 [Note] InnoDB: Not using CPU crc32 instructions 140612 22:34:39 [Note] InnoDB: Initializing buffer pool, size = 256.0M 140612 22:34:39 [Note] InnoDB: Completed initialization of buffer pool 140612 22:34:39 [Note] InnoDB: Highest supported file format is Barracuda. 140612 22:34:39 [Note] InnoDB: The log sequence numbers 736578572 and 736578572 in ibdata files do not match the log sequence number 736659958 in the ib_logfiles! 140612 22:34:39 [Note] InnoDB: Database was not shutdown normally! 140612 22:34:39 [Note] InnoDB: Starting crash recovery. 140612 22:34:39 [Note] InnoDB: Reading tablespace information from the .ibd files... 140612 22:34:39 [Note] InnoDB: Restoring possible half-written data pages 140612 22:34:39 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 6422, file name /var/log/mariadb/mariadb-bin.000270 140612 22:34:39 [Note] InnoDB: 128 rollback segment(s) are active. 140612 22:34:39 [Note] InnoDB: Waiting for purge to start 140612 22:34:39 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 736659958 140612 22:34:39 [Note] Recovering after a crash using /var/log/mariadb/mariadb-bin 140612 22:34:39 [Note] Starting crash recovery... 140612 22:34:39 [Note] Crash recovery finished. 140612 22:34:39 [Note] Server socket created on IP: '127.0.0.1'. 140612 22:34:39 [Note] Event Scheduler: Loaded 0 events 140612 22:34:39 [Note] /usr/local/mariadb/bin/mysqld: ready for connections. Version: '10.0.11-MariaDB-log' socket: '/var/cache/mariadb/mariadb.sock' port: 3306 Source distribution

2 4

[Maria-discuss] newbie question
by Roberto Spadim 12 Jun '14

12 Jun '14

Guys, i'm with a "newbie" question I need to swap a primary key value, for example: create table test ( id int not null default 0, other varchar(255) not null default '', primary key(id) ); insert into test (1,'a'); insert into test (2,'b'); now i want that (2,'b') becomes (1,'b') and (1,'a') becomes (2,'a') the point is, how to do this, with only one UPDATE without duplicate column id value? and without delete values? -- Roberto Spadim

4 13

[Maria-discuss] MariaDB Galera Cluster 10.0.11 now available
by Daniel Bartholomew 12 Jun '14

12 Jun '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.11 This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.11 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10011-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10011-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.11 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - 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/ - http://www.cafepress.com/mariadb 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] ncurses and mysql
by Roberto Spadim 11 Jun '14

11 Jun '14

Hi guys, i'm running slackware 14.1, i upgrade to slackware-current, and downloaded the mariadb-10.0.11 x64 with glibc 2.19 the point is... whern i run mysql, it requires a 'deprecated' library, libtinfo.so.5, this one was replaced by libncurses.so.5 there's something we could help here? today i execute a symlink to solve this problem, but since libtinfo is deprecated, should we update our compile line? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

3 4

[Maria-discuss] MariaDB 5.5.38 now available
by Daniel Bartholomew 09 Jun '14

09 Jun '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.38 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.38 - Release Notes: https://mariadb.com/kb/en/mariadb-5538-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5538-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.38 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 10.0. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - 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/ - http://www.cafepress.com/mariadb 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] MariaDB encryption
by Jonas Oreland 06 Jun '14

06 Jun '14

Hi there, I read this blog post http://monty-says.blogspot.com/2014/05/for-your-eyes-only-or-adding-better.… and wanted to inform you that we at Google has developed on-disk/block-level encryption for Innodb, aria (as used by temporary tables), binlogs and temp-files. The code is not yet published, but we expect it to be within a few weeks or so. We (of course?) think that it would be better if you instead of developing new code spent the time testing/reviewing ours. I'm happy to answer questions on the topic, and will let you know once we've published it. /Jonas ps. Ian talked about this at percona, https://www.percona.com/live/mysql-conference-2014/sessions/privacy-and-sec…

4 6

[Maria-discuss] EXPLAIN and CONNECT
by Federico Razzoli 04 Jun '14

04 Jun '14

6 17

[Maria-discuss] New Question: Spider storage engine condition pushdown
by AskMonty KB 04 Jun '14

04 Jun '14

Hello, A new question has been asked in "Spider" by lokeshkumar-p-417: -------------------------------- Hi, We are using Spider storage engine for sharding with MariaDB. MariaDB version - 10.0.10 Spider version - 3.2 Platform - CentOs 6.5 Problem: ---------------- We have a simple scenario, where we have a table with Spider storage engine, which is list partitioned based on a column. Each partition is pointing to a shard. Whenever a query is fired from the Master database with a WHERE clause, the WHERE condition is not being pushed to the shard, instead all the data from shard is being transferred to the DB where Spider storage engine is present. I came to know that this issue has been fixed in the Spider storage engine, and also I verified the MariaDB 10.0.9-spider-3.2 source code and it has cond_push and cond_pop functions. Please let me know how else can I enable this condition pushdown. Regards, -Lokesh Kumar -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/spider-storage-engine-condition-pushdown/

1 0

[Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)
by Colin Charles 03 Jun '14

03 Jun '14

Hi all, Recently there was chat about how PERFORMANCE_SCHEMA was enabled by mistake and it should be disabled in the 10.0 series. I'm curious - how many of you are using PERFORMANCE_SCHEMA? Is it a problem to turn it on, if you use it? I'm referring to: https://mariadb.atlassian.net/browse/MDEV-6249 Looking from the webscalesql list, there are examples of performance degradation: https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/eUNsl0lSfbMJ https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/-YZMMCuPw3QJ quote: "Our perf testing agrees with your assessment (we see about a 5%-6% perf hit when it's included and on, and a 2%-3% hit when it's included but off)" Please discuss this, either here or on MDEV-6249 Thanks cheers, -colin -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

8 12

[Maria-discuss] New Question: How much storage is available in the FREE versions of MariaDB 5.x and 10.x?
by AskMonty KB 03 Jun '14

03 Jun '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- How much storage is available in the FREE versions of MariaDB 5.x and 10.x? I just want to know how much upto storage available in the MariaDB 5.0 and 10.0 free version? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-how-much-storage-is-available-in…

2 1