Description:
Server version 5.1.30
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 18 min 18 sec
SunOS 5.11 snv_118 i86pc
MySQL: 5.1.30
PHP: 5.2.9
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8k DAV/2 PHP/5.2.9 mod_jk/1.2.27
Interface web server -> PHP: apache2handler
Joomla: Joomla! 1.5.18 Stable [ wojmamni ama wojnaiki ] 27-May-2010 18:00 GMT
User Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.9.1) Gecko/20090623 Firefox/3.5
Log file:
100622 15:44:27 [Note] /usr/mysql/5.1/bin/mysqld: ready for connections.
Version: '5.1.30' socket: '/tmp/mysql.sock' port: 3306 Source distribution
/usr/mysql/5.1/bin/mysqld'my_print_stacktrace+0x1c [0x874a148]
/usr/mysql/5.1/bin/mysqld'handle_segfault+0x1f3 [0x82be2d7]
/lib/libc.so.1'__sighndlr+0xf [0xfeaed1cf]
/lib/libc.so.1'call_user_handler+0x2af [0xfeae024f]
/usr/mysql/5.1/bin/mysqld'__1cQbest_access_path6FpnEJOIN_pnNst_join_table_pnDTHD_XIdd_v_+0x5a1 [0x8343421]
/usr/mysql/5.1/bin/mysqld'__1cbGbest_extension_by_limited_search6FpnEJOIN_XIddII_b_+0x251 [0x8345375]
/usr/mysql/5.1/bin/mysqld'__1cbGbest_extension_by_limited_search6FpnEJOIN_XIddII_b_+0x58d [0x83456b1]
/usr/mysql/5.1/bin/mysqld'__1cbGbest_extension_by_limited_search6FpnEJOIN_XIddII_b_+0x58d [0x83456b1]
/usr/mysql/5.1/bin/mysqld'__1cbGbest_extension_by_limited_search6FpnEJOIN_XIddII_b_+0x58d [0x83456b1]
/usr/mysql/5.1/bin/mysqld'__1cLchoose_plan6FpnEJOIN_X_b_+0x2b3 [0x8344db7]
/usr/mysql/5.1/bin/mysqld'__1cUmake_join_statistics6FpnEJOIN_pnKTABLE_LIST_pnEItem_pnQst_dynamic_array__b_+0x16d9 [0x833f709]
/usr/mysql/5.1/bin/mysqld'__1cEJOINIoptimize6M_i_+0x5a0 [0x8339c60]
/usr/mysql/5.1/bin/mysqld'__1cMmysql_select6FpnDTHD_pppnEItem_pnKTABLE_LIST_IrnEList4n0B___p2IpnIst_order_9D39DXpnNselect_result_pnSst_select_lex_unit_pnNst_select_lex__b_+0x363 [0x833debb]
/usr/mysql/5.1/bin/mysqld'__1cNhandle_select6FpnDTHD_pnGst_lex_pnNselect_result_L_b_+0x11f [0x8338613]
/usr/mysql/5.1/bin/mysqld'__1cVexecute_sqlcom_select6FpnDTHD_pnKTABLE_LIST__b_+0x20f [0x82d8fb3]
/usr/mysql/5.1/bin/mysqld'__1cVmysql_execute_command6FpnDTHD__i_+0x497 [0x82d1a3f]
/usr/mysql/5.1/bin/mysqld'__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x2418 [0x82cfc94]
/usr/mysql/5.1/bin/mysqld'__1cKdo_command6FpnDTHD__b_+0x105 [0x82cd6d5]
/usr/mysql/5.1/bin/mysqld'handle_one_connection+0x3b6 [0x82cba52]
/lib/libc.so.1'_thrp_setup+0x7e [0xfeaece66]
/lib/libc.so.1'_lwp_start+0x0 [0xfeaed0f0]
100622 15:45:24 - 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=16384
read_buffer_size=262144
max_used_connections=1
max_threads=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 32639 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0xb1c2608
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 = fe241fb0 thread_stack 0x20000
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at b5d6618 = SELECT a.*, g.name AS groupname FROM jos_users AS a INNER JOIN jos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.id INNER JOIN jos_core_acl_aro_groups AS g ON g.id = gm.group_id GROUP BY a.id ORDER BY a.name LIMIT 0, 20
thd->thread_id=5
thd->killed=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.
100622 15:45:24 mysqld_safe mysqld restarted
100622 15:45:24 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
100622 15:45:24 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100622 15:45:24 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100622 15:45:24 InnoDB: Started; log sequence number 0 46409
100622 15:45:24 [Note] Event Scheduler: Loaded 0 events
100622 15:45:24 [Note] /usr/mysql/5.1/bin/mysqld: ready for connections.
Version: '5.1.30' socket: '/tmp/mysql.sock' port: 3306 Source distribution
How to repeat:
run a query
SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = c.catid LEFT JOIN jos_sections AS s ON s.id = c.sectionid LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state != -2 ORDER BY section_name , section_name, cc.title, c.ordering LIMIT 0, 20
server crashes regardless how to run it, including command line interface
some other queries have the same effect, for example:
SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering
Approximately 50% of queries from Joomla admin panel are executed normally, others (including shown above) are not.
