Форум пользователей MySQL

======= Memory map: ========
ae676000-ae677000 ---p 00000000 00:00 0
ae677000-aee76000 rw-p 00000000 00:00 0
aee76000-aee77000 ---p 00000000 00:00 0
aee77000-af676000 rw-p 00000000 00:00 0
af676000-af677000 ---p 00000000 00:00 0
af677000-afe76000 rw-p 00000000 00:00 0
afe76000-afe77000 ---p 00000000 00:00 0
afe77000-b0676000 rw-p 00000000 00:00 0
b0676000-b0677000 ---p 00000000 00:00 0
b0677000-b107c000 rw-p 00000000 00:00 0
b121d000-b121e000 ---p 00000000 00:00 0
b121e000-b124d000 rw-p 00000000 00:00 0
b124d000-b124e000 ---p 00000000 00:00 0
b124e000-b127d000 rw-p 00000000 00:00 0
b127d000-b127e000 ---p 00000000 00:00 0
b127e000-b1a7d000 rw-p 00000000 00:00 0
b1a7d000-b1a7e000 ---p 00000000 00:00 0
b1a7e000-b227d000 rw-p 00000000 00:00 0
b227d000-b227e000 ---p 00000000 00:00 0
b227e000-b6592000 rw-p 00000000 00:00 0
b6592000-b659c000 r-xp 00000000 ca:01 499857     /lib/libnss_files-2.11.3.so
b659c000-b659d000 r--p 00009000 ca:01 499857     /lib/libnss_files-2.11.3.so
b659d000-b659e000 rw-p 0000a000 ca:01 499857     /lib/libnss_files-2.11.3.so
b659e000-b65a6000 r-xp 00000000 ca:01 499847     /lib/libnss_nis-2.11.3.so
b65a6000-b65a7000 r--p 00008000 ca:01 499847     /lib/libnss_nis-2.11.3.so
b65a7000-b65a8000 rw-p 00009000 ca:01 499847     /lib/libnss_nis-2.11.3.so
b65a8000-b65ae000 r-xp 00000000 ca:01 499878     /lib/libnss_compat-2.11.3.so
b65ae000-b65af000 r--p 00006000 ca:01 499878     /lib/libnss_compat-2.11.3.so
b65af000-b65b0000 rw-p 00007000 ca:01 499878     /lib/libnss_compat-2.11.3.so
b65b0000-b65b1000 ---p 00000000 00:00 0
b65b1000-b6db1000 rw-p 00000000 00:00 0
b6db1000-b6eef000 r-xp 00000000 ca:01 499876     /lib/libc-2.11.3.so
b6eef000-b6ef0000 ---p 0013e000 ca:01 499876     /lib/libc-2.11.3.so
b6ef0000-b6ef2000 r--p 0013e000 ca:01 499876     /lib/libc-2.11.3.so
b6ef2000-b6ef3000 rw-p 00140000 ca:01 499876     /lib/libc-2.11.3.so
b6ef3000-b6ef7000 rw-p 00000000 00:00 0
b6ef7000-b6f14000 r-xp 00000000 ca:01 501669     /lib/libgcc_s.so.1
b6f14000-b6f15000 rw-p 0001c000 ca:01 501669     /lib/libgcc_s.so.1
b6f15000-b6f39000 r-xp 00000000 ca:01 499851     /lib/libm-2.11.3.so
b6f39000-b6f3a000 r--p 00023000 ca:01 499851     /lib/libm-2.11.3.so
b6f3a000-b6f3b000 rw-p 00024000 ca:01 499851     /lib/libm-2.11.3.so
b6f3b000-b7024000 r-xp 00000000 ca:01 107707     /usr/lib/libstdc++.so.6.0.13
b7024000-b7028000 r--p 000e9000 ca:01 107707     /usr/lib/libstdc++.so.6.0.13
b7028000-b7029000 rw-p 000ed000 ca:01 107707     /usr/lib/libstdc++.so.6.0.13
b7029000-b7030000 rw-p 00000000 00:00 0
b7030000-b7043000 r-xp 00000000 ca:01 499854     /lib/libnsl-2.11.3.so
b7043000-b7044000 r--p 00012000 ca:01 499854     /lib/libnsl-2.11.3.so
b7044000-b7045000 rw-p 00013000 ca:01 499854     /lib/libnsl-2.11.3.so
b7045000-b7047000 rw-p 00000000 00:00 0
b7047000-b7050000 r-xp 00000000 ca:01 499855     /lib/libcrypt-2.11.3.so
b7050000-b7051000 r--p 00008000 ca:01 499855     /lib/libcrypt-2.11.3.so
b7051000-b7052000 rw-p 00009000 ca:01 499855     /lib/libcrypt-2.11.3.so
b7052000-b7079000 rw-p 00000000 00:00 0
b7079000-b707b000 r-xp 00000000 ca:01 499848     /lib/libdl-2.11.3.so
b707b000-b707c000 r--p 00001000 ca:01 499848     /lib/libdl-2.11.3.so
b707c000-b707d000 rw-p 00002000 ca:01 499848     /lib/libdl-2.11.3.so
b707d000-b707e000 rw-p 00000000 00:00 0
b707e000-b7085000 r-xp 00000000 ca:01 500083     /lib/libwrap.so.0.7.6
b7085000-b7086000 rw-p 00007000 ca:01 500083     /lib/libwrap.so.0.7.6
b7086000-b7099000 r-xp 00000000 ca:01 107684     /usr/lib/libz.so.1.2.3.4
b7099000-b709a000 rw-p 00013000 ca:01 107684     /usr/lib/libz.so.1.2.3.4
b709a000-b70ae000 r-xp 00000000 ca:01 499862     /lib/libpthread-2.11.3.so
b70ae000-b70af000 ---p 00014000 ca:01 499862     /lib/libpthread-2.11.3.so
b70af000-b70b0000 r--p 00014000 ca:01 499862     /lib/libpthread-2.11.3.so
b70b0000-b70b1000 rw-p 00015000 ca:01 499862     /lib/libpthread-2.11.3.so
b70b1000-b70b3000 rw-p 00000000 00:00 0
b70b6000-b70bb000 rw-p 00000000 00:00 0
b70bb000-b70bc000 r-xp 00000000 00:00 0          [vdso]
b70bc000-b70d7000 r-xp 00000000 ca:01 499867     /lib/ld-2.11.3.so
b70d7000-b70d8000 r--p 0001b000 ca:01 499867     /lib/ld-2.11.3.so
b70d8000-b70d9000 rw-p 0001c000 ca:01 499867     /lib/ld-2.11.3.so
b70d9000-b7868000 r-xp 00000000 ca:01 107918     /usr/sbin/mysqld
b7868000-b789f000 r--p 0078e000 ca:01 107918     /usr/sbin/mysqld
b789f000-b78fe000 rw-p 007c5000 ca:01 107918     /usr/sbin/mysqld
b78fe000-b7910000 rw-p 00000000 00:00 0
b8256000-b8802000 rw-p 00000000 00:00 0          [heap]
bf99a000-bf9af000 rw-p 00000000 00:00 0          [stack]
10:53:36 UTC - mysqld got signal 6 ;
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=33554432
read_buffer_size=131072
max_used_connections=1
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 362317 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0xffffffffb867e340
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 = ffffffffb124c36c thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2d) [0xb768b20d]
/usr/sbin/mysqld(handle_fatal_signal+0x4a4) [0xb7470104]
[0xb70bb400]
/lib/libc.so.6(abort+0x182) [0xb6dde962]
/lib/libc.so.6(+0x6108d) [0xb6e1208d]
/lib/libc.so.6(__fortify_fail+0x40) [0xb6e91a20]
/lib/libc.so.6(+0xe09da) [0xb6e919da]
/usr/sbin/mysqld(+0x62fa84) [0xb7708a84]
/usr/sbin/mysqld(+0x26c587) [0xb7345587]
/usr/sbin/mysqld(Item_field::send(Protocol*, String*)+0x1b) [0xb727dd2b]
/usr/sbin/mysqld(select_send::send_data(List<Item>&)+0x14a) [0xb733b73a]
/usr/sbin/mysqld(+0x2dd7f0) [0xb73b67f0]
/usr/sbin/mysqld(+0x2df0e0) [0xb73b80e0]
/usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x95) [0xb73c1975]
/usr/sbin/mysqld(+0x2e9927) [0xb73c2927]
/usr/sbin/mysqld(JOIN::exec()+0xa6a) [0xb73d91da]
/usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0xf8) [0xb73d4b38]
/usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x164) [0xb73dad14]
/usr/sbin/mysqld(+0x284a1f) [0xb735da1f]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x25a6) [0xb7363a26]
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x42a) [0xb7369b5a]
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xe9d) [0xb736aa0d]
/usr/sbin/mysqld(do_command(THD*)+0xf3) [0xb736bd43]
/usr/sbin/mysqld(handle_one_connection+0x268) [0xb735a298]
/lib/libpthread.so.0(+0x57b0) [0xb709f7b0]
/lib/libc.so.6(clone+0x5e) [0xb6e7d0be]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (ffffffffb86aa5d0): SELECT
            t.rating,
            ROUND( p.suma / t.massa, 2 ) AS suma_tovar,
            p.suma AS suma,
            t.massa,
            t.id AS id,
            p.is_confrim,
            t.name AS tovar_name,
            t.categories_id,
            um.name as unit_measure_name,
            t.name as name_tovar,
            t.suma as suma,
            p.user_id as price_user_id,
            p.date_cr as price_date_cr,
            p.id as price_id,
            pr_prod.id as tosh_prodavez_id,
            pr_prod.name as tosh_prodavez_name,
            tosh.id as tosh_id,
            reg.name as region_name,
            gor.name as gorod_name,
            tosh.uliza as tosh_uliza,
            tosh.dom as tosh_dom,
            tosh.korpus as tosh_korpus,
            tosh.stronie as tosh_stronie,
            tosh.floor as tosh_floor,
            tosh.office as tosh_office,
            tosh.position as tosh_position,
            p.user_id as price_user_id,
            profil_prodavez_price_avtor.name
Connection ID (thread ID): 8
Status: NOT_KILLED

The manual page at <a href="http://dev.mysql.com/doc/mysql/en/crashing.html">http://dev.mysql.com/doc/mysql/en/crashing.html</a> contains
information that should help you find out what is causing the crash.
120819 10:53:36 [Note] Plugin 'FEDERATED' is disabled.
120819 10:53:36  InnoDB: Initializing buffer pool, size = 8.0M
120819 10:53:36  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120819 10:53:36  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...
InnoDB: Last MySQL binlog file position 0 106, file name /var/log/mysql/mysql-bin.000180
120819 10:53:36  InnoDB: Started; log sequence number 0 2263735865
120819 10:53:36 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
120819 10:53:36 [Note] Starting crash recovery...
120819 10:53:36 [Note] Crash recovery finished.
120819 10:53:36 [Note] Event Scheduler: Loaded 0 events
120819 10:53:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.61-0+squeeze1-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)