mysql 执行查询导致服务器崩溃求解:Some pointers may be invalid and cause the dump to abort

  • 时间:
  • 浏览:1
  • 来源:uu快3官网app_uu快3豹子赚钱

InnoDB: We intentionally generate a memory trap.

and this may fail.

where mysqld died. If you see no messages after this, something went

120720  9:25:33 [Note] Crash recovery finished.

thd: 0xf500ed500

InnoDB: about forcing recovery.

/lib64/libpthread.so.0 [0x3c8cc0eb10]

/data/mysql/bin/mysqld [0x72a4ab]

/data/mysql/bin/mysqld(JOIN::optimize()+0x44e) [0x66e734]

InnoDB: for how to resolve the issue.

/data/mysql/bin/mysqld [0x68d500f]

/data/mysql/bin/mysqld(JOIN::exec()+0x1990) [0x6881e0]

Version: '5.1.35-log'  socket: '/tmp/mysql.sock'  port: 35006  MySQL Community Server (GPL)

120720  9:25:25  InnoDB: Assertion failure in thread 11750046464 in file row/row0mysql.c line 1534

/data/mysql/bin/mysqld(Item::save_in_field_no_warnings(Field*, bool)+0x500) [0x52cc8c]

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61828500 K

key_buffer_size=33554432

120720  9:25:27  InnoDB: Database was not shut down normally!

the problem, but since we have already crashed, something is definitely wrong

bytes of memory

InnoDB: Restoring possible half-written data pages from the doublewrite

Trying to get some variables.

/data/mysql/bin/mysqld(handle_one_connection+0xd20) [0x500564c]

/data/mysql/bin/mysqld(subselect_single_select_engine::exec()+0x26d) [0x59e4c1]

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html

/data/mysql/bin/mysqld(Item_singlerow_subselect::val_int()+0xb5) [0x59ed8f]

120720  9:25:27  InnoDB: Starting an apply batch of log records to the database...

InnoDB: buffer...

InnoDB: whose .ibd and .frm files MySQL automatically removed, but the

read_buffer_size=2097152

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

/data/mysql/bin/mysqld(Item::save_in_field(Field*, bool)+0x275) [0x5007fb7]

or one of the libraries it was linked against is corrupt, improperly built,

120720  9:25:33  InnoDB: Started; log sequence number 124 4151885387

max_threads=5000

120720  9:25:27  InnoDB: Error: table 'tmp/#sql3712_1558c_2'

This could be because you hit a bug. It is also possible that this binary

thd->killed=NOT_KILLED

max_used_connections=1500

120720  9:25:33 [Note] Recovering after a crash using mysql-bin

/data/mysql/bin/mysqld(Item_subselect::exec()+0x42) [0x59dc12]

InnoDB: Thread 11670185004 stopped in file os/os0sync.c line 588

120720  9:25:33 [Note] Starting crash recovery...

/data/mysql/bin/mysqld [0x68e01c]

InnoDB: immediately after the mysqld startup, there may be

/data/mysql/bin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xae) [0x68dcaa]

/data/mysql/bin/mysqld [0x616ad8]

InnoDB: Please refer to

/lib64/libc.so.6(clone+0x6d) [0x3c8c0d3d1d]

InnoDB: in InnoDB data dictionary has tablespace id 4219,

InnoDB: Last MySQL binlog file position 0 18981718, file name ./mysql-bin.006479

InnoDB: table still exists in the InnoDB internal data dictionary.

Some pointers may be invalid and cause the dump to abort...

InnoDB: Starting crash recovery.

120720 09:25:26 mysqld_safe Number of processes running now: 0

/data/mysql/bin/mysqld(my_print_stacktrace+0x20) [0xa05744]

InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 500 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 500 51 52 53 54 55 56 57 58 59 500 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 500 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

/data/mysql/bin/mysqld(handle_segfault+0x368) [0x500074c]

/data/mysql/bin/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x20a) [0x61706e]

InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

InnoDB: Thread 11706500976 stopped in file ../../storage/innobase/include/sync0sync.ic line 115

120720  9:25:33 [Note] Event Scheduler: Loaded 0 events

InnoDB: but tablespace with that id or name does not exist. Have

InnoDB: Thread 1103137088 stopped in file handler/ha_innodb.cc line 4583

terribly wrong...

/data/mysql/bin/mysqld(mysql_execute_command(THD*)+0x4b00) [0x610c500]

/data/mysql/bin/mysqld [0x675934]

thd->thread_id=209

InnoDB: Doing recovery: scanned up to log sequence number 124 4151885387

InnoDB: you deleted or moved .ibd files?

InnoDB: If you get repeated assertion failures or crashes, even

information that should help you find out what is causing the crash.

/data/mysql/bin/mysqld [0x725901]

/data/mysql/bin/mysqld(row_unlock_for_mysql+0x11e) [0x915112]

InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html

120720 09:25:26 mysqld_safe mysqld restarted

/lib64/libpthread.so.0 [0x3c8cc0673d]

thd->query at 0xff365000 = SELECT DISTINCT g.USER_ID FROM SYS_USER_GROUP g  LEFT JOIN SYS_USER u on g.USER_ID=u.USER_ID  WHERE GROUP_ID = (SELECT GROUP_ID  FROM SYS_GROUP WHERE GROUP_CODE='ZB_JIHUAHUAN_GROUP') AND u.org_id = 2

/data/mysql/bin/mysqld [0x72617c]

/data/mysql/bin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x16c) [0x695220]

It is possible that mysqld could use up to

/data/mysql/bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x133f) [0x500b5d9]

threads_connected=177

120720  9:25:25 - mysqld got signal 11 ;

InnoDB: Log scan progressed past the checkpoint lsn 124 45000467491

120720  9:25:33 [Note] /data/mysql/bin/mysqld: ready for connections.

/data/mysql/bin/mysqld(do_command(THD*)+0x114) [0x500a296]

InnoDB: corruption in the InnoDB tablespace. Please refer to

Attempting backtrace. You can use the following information to find out

stack_bottom = 0x45009c118 thread_stack 0x50000

Hope that's ok; if not, decrease some variables in the equation.

We will try our best to scrape up some info that will hopefully help diagnose

or misconfigured. This error can also be caused by malfunctioning hardware.

InnoDB: Apply batch completed

/data/mysql/bin/mysqld(ha_innobase::unlock_row()+0x57) [0x835500f]

/data/mysql/bin/mysqld(SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool)+0x6aa) [0x724144]

InnoDB: This may also be a table created with CREATE TEMPORARY TABLE