To be brutally honest, if you want stability you should not be using MyISAM, much less a not particularly commonly used feature.
On Thu, Nov 24, 2011 at 12:58 AM, Reindl Harald <h.rei...@thelounge.net> wrote: > and the next one without "memlock" > > 111124 09:50:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid > ended > 111124 09:50:35 mysqld_safe Starting mysqld daemon with databases from > /Volumes/dune/mysql_data > 111124 9:50:35 [Note] Plugin 'InnoDB' is disabled. > 111124 9:50:35 [Note] Plugin 'FEDERATED' is disabled. > 111124 9:50:35 [Note] Plugin 'BLACKHOLE' is disabled. > 111124 9:50:35 [Note] Plugin 'ARCHIVE' is disabled. > 111124 9:50:35 [Note] Plugin 'partition' is disabled. > 111124 9:50:35 [Note] Event Scheduler: Loaded 0 events > 111124 9:50:35 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.5.18-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 > thelounge.net build > 111124 9:53:12 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:12 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:17 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:17 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:22 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:22 [ERROR] Got error 127 when reading table > './aume/skefonds2009_ext_content' > 111124 9:53:32 [ERROR] Got error 127 when reading table './afi/cms1_sub2' > 111124 9:53:32 [ERROR] Got error 127 when reading table './afi/cms1_sub2' > 111124 9:55:02 [ERROR] Got error 127 when reading table > './hurnaus/cms1_galerie_sub' > 111124 9:55:02 [ERROR] Got error 127 when reading table > './hurnaus/cms1_galerie_sub' > 111124 9:55:14 - 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. > 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. > > key_buffer_size=268435456 > read_buffer_size=262144 > max_used_connections=12 > max_threads=200 > thread_count=3 > connection_count=3 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 418015 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > Thread pointer: 0x2ea7080 > 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 = 0x7ffd2ea39d40 thread_stack 0x40000 > /usr/libexec/mysqld(my_print_stacktrace+0x33)[0x7ab8f3] > /usr/libexec/mysqld(handle_segfault+0x470)[0x50f190] > /lib64/libpthread.so.0(+0xeeb0)[0x7ffdaae93eb0] > /lib64/libc.so.6(+0x12ffa5)[0x7ffda920cfa5] > /usr/libexec/mysqld(mi_mmap_pread+0x15a)[0x90880a] > /usr/libexec/mysqld(_mi_read_dynamic_record+0x1fe)[0x90ac5e] > /usr/libexec/mysqld(mi_rkey+0x378)[0x930f48] > /usr/libexec/mysqld(_ZN9ha_myisam14index_read_mapEPhPKhm16ha_rkey_function+0x59)[0x8f1fe9] > /usr/libexec/mysqld[0x5b3f35] > /usr/libexec/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x61)[0x5a4721] > /usr/libexec/mysqld[0x5b2c65] > /usr/libexec/mysqld(_ZN4JOIN4execEv+0xbe1)[0x5c39b1] > /usr/libexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x152)[0x5bf182] > /usr/libexec/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x184)[0x5c5074] > /usr/libexec/mysqld[0x57df97] > /usr/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x2438)[0x585808] > /usr/libexec/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x186)[0x589ef6] > /usr/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x15e5)[0x58b505] > /usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x117)[0x61fff7] > /usr/libexec/mysqld(handle_one_connection+0x50)[0x6200a0] > /lib64/libpthread.so.0(+0x6ccb)[0x7ffdaae8bccb] > /lib64/libc.so.6(clone+0x6d)[0x7ffda91bdc2d] > > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort. > Query (0x7ffd20021720): is an invalid pointer > Connection ID (thread ID): 647 > Status: NOT_KILLED > > > -------- Original-Nachricht -------- > Betreff: 'myisam_use_mmap' unstable like hell > Datum: Thu, 24 Nov 2011 09:20:28 +0100 > Von: Reindl Harald <h.rei...@thelounge.net> > Organisation: the lounge interactive design > An: Mailing-List mysql <mysql@lists.mysql.com> > > introduced with 5.1 myisam_use_mmap leads in 5.5.18 > after some days to table crashes - will this be ever > useful on servers with thousands of tables? > ________________________ > > 111124 8:20:17 - 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. > 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. > > key_buffer_size=268435456 > read_buffer_size=262144 > max_used_connections=33 > max_threads=200 > thread_count=6 > connection_count=6 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 418015 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > Thread pointer: 0x2a4bd50 > 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 = 0x7f507cf70d40 thread_stack 0x40000 > /usr/libexec/mysqld(my_print_stacktrace+0x33)[0x7ab8f3] > /usr/libexec/mysqld(handle_segfault+0x470)[0x50f190] > /lib64/libpthread.so.0(+0xeeb0)[0x7f51054caeb0] > /lib64/libc.so.6(+0x12ffa5)[0x7f5103843fa5] > /usr/libexec/mysqld(mi_mmap_pread+0x15a)[0x90880a] > /usr/libexec/mysqld(_mi_read_dynamic_record+0x1fe)[0x90ac5e] > /usr/libexec/mysqld(mi_rkey+0x378)[0x930f48] > /usr/libexec/mysqld(_ZN9ha_myisam14index_read_mapEPhPKhm16ha_rkey_function+0x59)[0x8f1fe9] > /usr/libexec/mysqld[0x5b3f35] > /usr/libexec/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x61)[0x5a4721] > /usr/libexec/mysqld[0x5b2c65] > /usr/libexec/mysqld(_ZN4JOIN4execEv+0xbe1)[0x5c39b1] > /usr/libexec/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x152)[0x5bf182] > /usr/libexec/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x184)[0x5c5074] > /usr/libexec/mysqld[0x57df97] > /usr/libexec/mysqld(_Z21mysql_execute_commandP3THD+0x2438)[0x585808] > /usr/libexec/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x186)[0x589ef6] > /usr/libexec/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x15e5)[0x58b505] > /usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0x117)[0x61fff7] > /usr/libexec/mysqld(handle_one_connection+0x50)[0x6200a0] > /lib64/libpthread.so.0(+0x6ccb)[0x7f51054c2ccb] > /lib64/libc.so.6(clone+0x6d)[0x7f51037f4c2d] > > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort. > Query (0x7f4ffc0058a0): is an invalid pointer > Connection ID (thread ID): 460043 > Status: NOT_KILLED > > 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. > > The "--memlock" argument, which was enabled, uses system calls that are > unreliable and unstable on some operating systems and operating-system > versions (notably, some versions of Linux). This crash could be due to use > of those buggy OS calls. You should consider whether you really need the > "--memlock" parameter and/or consult the OS distributer about "mlockall" > bugs. > 111124 08:20:18 mysqld_safe Number of processes running now: 0 > 111124 08:20:18 mysqld_safe mysqld restarted > 111124 8:20:18 [Note] Plugin 'InnoDB' is disabled. > 111124 8:20:18 [Note] Plugin 'FEDERATED' is disabled. > 111124 8:20:18 [Note] Plugin 'BLACKHOLE' is disabled. > 111124 8:20:18 [Note] Plugin 'ARCHIVE' is disabled. > 111124 8:20:18 [Note] Plugin 'partition' is disabled. > 111124 8:20:19 [Note] Event Scheduler: Loaded 0 events > 111124 8:20:19 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.5.18-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 > thelounge.net build > 111124 8:20:19 [ERROR] /usr/libexec/mysqld: Table './afi/cms1_global_cache' > is marked as crashed and should be > repaired > 111124 8:20:19 [Warning] Checking table: './afi/cms1_global_cache' > 111124 8:20:19 [ERROR] Got an error from unknown thread, > /home/builduser/rpmbuild/BUILD/mysql-5.5.18/storage/myisam/ha_myisam.cc:870 > > > > -- > > Mit besten Grüßen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofmühlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 > icq: 154546673, http://www.thelounge.net/ > > http://www.thelounge.net/signature.asc.what.htm > -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql