MySQL 4.0.20 crash on SET GLOBAL query_cache_size
Dave Juntgen
MySQL 4.0.20 crashed when setting running the command: SET GLOBAL =
query_cache_size=3D33554432.
OS: Linux webchartdb2 2.4.26 #2 SMP Sat Jul 17 02:29:04 EST 2004 i686 =
i686 i386 GNU/Linux
mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
Connection id: 55161
Current database: webchart_neuro
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.20-pro-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 2 hours 25 min 39 sec
Threads: 29 Questions: 5879187 Slow queries: 232 Opens: 36145 Flush =
tables: 1 Open tables: 2098 Queries per second avg: 672.753
resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
0x8070740 handle_segfault + 420
0x8247998 pthread_sighandler + 184
0x80e43b2 find_bin__11Query_cacheUl + 54
0x80e4043 get_free_block__11Query_cacheUlcUl + 31
0x80e3fc5 allocate_block__11Query_cacheUlcUlc + 81
0x80e3859 =
write_block_data__11Query_cacheUlPcUlQ217Query_cache_block10block_typeUic=
+ 69
0x80e286e store_query__11Query_cacheP3THDP13st_table_list + 302
0x807b2b9 mysql_execute_command__Fv + 997
0x807ebda mysql_parse__FP3THDPcUi + 146
0x807a3d3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435
0x8079e2d do_command__FP3THD + 157
0x8079669 handle_one_connection + 641
0x824514c pthread_start_thread + 220
0x827b17a thread_start + 4
Any help would be greatly appreciated.
Regards,
--Dave J.
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax=A0 : 260.459.6271
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?unsub=3Dmysql-...@freebsd.csie.nctu.edu.tw
Sanja Byelkin
On Fri, Dec 03, 2004 at 01:25:11PM -0500, Dave Juntgen wrote:
> Hello everyone,
>
> MySQL 4.0.20 crashed when setting running the command: SET GLOBAL query_cache_size=33554432.
>
> OS: Linux webchartdb2 2.4.26 #2 SMP Sat Jul 17 02:29:04 EST 2004 i686 i686 i386 GNU/Linux
>
> mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
>
> Connection id: 55161
> Current database: webchart_neuro
> Current user: root@localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Server version: 4.0.20-pro-log
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Client characterset: latin1
> Server characterset: latin1
> UNIX socket: /tmp/mysql.sock
> Uptime: 2 hours 25 min 39 sec
>
> Threads: 29 Questions: 5879187 Slow queries: 232 Opens: 36145 Flush tables: 1 Open tables: 2098 Queries per second avg: 672.753
>
> resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
>
> 0x8070740 handle_segfault + 420
> 0x8247998 pthread_sighandler + 184
> 0x80e43b2 find_bin__11Query_cacheUl + 54
> 0x80e4043 get_free_block__11Query_cacheUlcUl + 31
> 0x80e3fc5 allocate_block__11Query_cacheUlcUlc + 81
> 0x80e3859 write_block_data__11Query_cacheUlPcUlQ217Query_cache_block10block_typeUic + 69
> 0x80e286e store_query__11Query_cacheP3THDP13st_table_list + 302
> 0x807b2b9 mysql_execute_command__Fv + 997
> 0x807ebda mysql_parse__FP3THDPcUi + 146
> 0x807a3d3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435
> 0x8079e2d do_command__FP3THD + 157
> 0x8079669 handle_one_connection + 641
> 0x824514c pthread_start_thread + 220
> 0x827b17a thread_start + 4
>
> Any help would be greatly appreciated.
I am sorry, but above do not give enough to find what happened.
Is above repeatable?
Can you, please, make repeatable test suite and put it on
http://bugs.mysql.com/ or to bu...@lists.mysql.com
(this list is for discussion of mysql internals, but above looke like
a bug)?
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin <sa...@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/internals?unsub=mysql-i...@freebsd.csie.nctu.edu.tw