Hi, Something very strange was happened on my production server where i have mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT) Unfortunatelly i'm not able(ahhhh...i didn't start with --log) to reproduce the exact sequence of queries which was send to the server. MySQL was "down" on this query:
SELECT * FROM stoc LIMIT 1; ...where table stoc is MyISAM and has aprox.150.000 of rows(stoc.MYD ->14 MB,stoc.MY->23 MB). IMHO: I'm sure that is nothing wrong with this query because after mysql daemon was restarting, it was successfully executed. Anyhow,mysqld log "said": ============================================================================ ====== Alarm status: Active alarms: 1 Max used alarms: 3 Next alarm time: 28765 cNewCount: 45 Memory that was not free'ed (402786381 bytes): 1024 bytes at 0x008424df8, allocated at line 79 in 'hash_filo.h' 8152 bytes at 0x008882a88, allocated at line 2368 in 'sql_acl.cc' 8 bytes at 0x0088b1ac0, allocated at line 277 in 'array.c' 12 bytes at 0x008882a58, allocated at line 277 in 'array.c' 56 bytes at 0x0088b1b68, allocated at line 277 in 'array.c' 368 bytes at 0x0088b1930, allocated at line 277 in 'array.c' 968 bytes at 0x00889f1b0, allocated at line 94 in 'my_alloc.c' 24 bytes at 0x0088b1b30, allocated at line 277 in 'array.c' 2048 bytes at 0x0088b05d0, allocated at line 79 in 'hash_filo.h' 8 bytes at 0x0088af718, allocated at line 545 in 'sql_db.cc' 16384 bytes at 0x0088b67c8, allocated at line 154 in 'sql_string.h' 4112 bytes at 0x0088b5798, allocated at line 40 in 'my_alloc.c' 8208 bytes at 0x0088b3768, allocated at line 40 in 'my_alloc.c' 5 bytes at 0x0088b3740, allocated at line 201 in 'sql_parse.cc' 11 bytes at 0x00889c038, allocated at line 517 in 'sql_parse.cc' 16391 bytes at 0x0088ab5e8, allocated at line 90 in 'net_serv.cc' 84 bytes at 0x00889bbc8, allocated at line 129 in 'vio.c' 32768 bytes at 0x0088a35c8, allocated at line 178 in 'mf_iocache.c' 3 bytes at 0x00889bba0, allocated at line 66 in 'mf_cache.c' 6 bytes at 0x00889bb78, allocated at line 65 in 'mf_cache.c' 128 bytes at 0x00889bad8, allocated at line 147 in 'sql_class.cc' 3072 bytes at 0x0088a29a8, allocated at line 283 in 'sql_list.h' 256 bytes at 0x008887ce8, allocated at line 132 in 'sql_udf.cc' 496 bytes at 0x008878dd0, allocated at line 54 in 'queues.c' 800 bytes at 0x008878988, allocated at line 318 in 'sql_parse.cc' 8136 bytes at 0x0088769a0, allocated at line 94 in 'my_alloc.c' 8136 bytes at 0x0088749b8, allocated at line 94 in 'my_alloc.c' 248 bytes at 0x0088748a0, allocated at line 43 in 'ft_stopwords.c' 18599440 bytes at 0x059359020, allocated at line 119 in 'mf_keycache.c' 384053248 bytes at 0x042515020, allocated at line 117 in 'mf_keycache.c' 256 bytes at 0x008874780, allocated at line 814 in 'ha_innodb.cc' 24 bytes at 0x008422f20, allocated at line 700 in 'ha_innodb.cc' 1024 bytes at 0x008425218, allocated at line 209 in 'repl_failsafe.cc' 4224 bytes at 0x008423cb8, allocated at line 54 in 'sql_base.cc' 128 bytes at 0x008422710, allocated at line 49 in 'my_bitmap.c' 530 bytes at 0x008422c50, allocated at line 599 in 'charset.c' 672 bytes at 0x008422208, allocated at line 1402 in 'set_var.cc' 128 bytes at 0x00841e658, allocated at line 1621 in 'item_func.cc' 13411 bytes at 0x00841ed80, allocated at line 83 in 'derror.cc' 6 bytes at 0x00841e2d8, allocated at line 4947 in 'mysqld.cc' 6 bytes at 0x00841e2b0, allocated at line 51 in 'mf_tempdir.c' 4 bytes at 0x00841e288, allocated at line 32 in 'mf_tempdir.c' 456 bytes at 0x00841eb98, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e9b0, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e7c8, allocated at line 94 in 'my_alloc.c' Maximum memory usage: 409950738 bytes (400343k) 030126 23:47:13 /mysql-4.1/libexec/mysqld: Normal shutdown 030126 23:47:13 InnoDB: Starting shutdown... 030126 23:47:14 InnoDB: Shutdown completed 030126 23:48:59 mysqld started 030126 23:49:03 InnoDB: Started /mysql-4.1/libexec/mysqld: ready for connections ============================================================================ ===== Maybe this help. Best regards, Gelu _____________________________________________________ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php