Re: Mysql - czy już działa?

[Michał Łukaszek]

2009/7/7 Arkadiusz Miskiewicz <arekm w maven.pl>:

> Można spróbować 5.1.36-3. Ma wyłączone wsparcie dla profilowania (show profile
> itd) ale przynajmniej działa.

Nie bardzo.

[root w wolf mysql]# rpm -q mysql
mysql-5.1.36-3.i686
[root w wolf mysql]# date
czw, 9 lip 2009, 13:10:50 CEST
[root w wolf mysql]# service mysql start
Uruchamianie usługi MySQL /var/lib/mysql.......................... [  ZAJĘTY  ]
Waiting for MySQL to start.........................................[ ZROBIONE ]
[root w wolf mysql]# date
czw, 9 lip 2009, 13:11:19 CEST
[root w wolf mysql]# service mysql status
MySQL cluster /var/lib/mysql.......................................[ died ]
[root w wolf mysql]# tail -30 /var/log/mysql/error.err

thd: 0x8b1c368
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 = 0xb47a636c thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29) [0x84764cf]
/usr/sbin/mysqld(handle_segfault+0x4b3) [0x81cff03]
[0xb80b4400]
/usr/sbin/mysqld(set_thd_proc_info+0xe) [0x81ba61f]
/usr/sbin/mysqld(check_access(THD*, unsigned long, char const*,
unsigned long*, bool, bool, bool)+0x92) [0x81d8e37]
/usr/sbin/mysqld(check_table_access(THD*, unsigned long, TABLE_LIST*,
unsigned int, bool)+0x1ff) [0x81d97c5]
/usr/sbin/mysqld(Prepared_statement::prepare(char const*, unsigned
int)+0xb4a) [0x8252f18]
/usr/sbin/mysqld(mysql_sql_stmt_prepare(THD*)+0x2e8) [0x8255339]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x3ab8) [0x81e068a]
/usr/sbin/mysqld(mysql_parse(THD*, char const*, unsigned int, char
const**)+0x2f1) [0x81e4857]
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*,
unsigned int)+0xda8) [0x81e5aaa]
/usr/sbin/mysqld(do_command(THD*)+0xc9) [0x81e634e]
/usr/sbin/mysqld(handle_one_connection+0x348) [0x81d6ac4]
/lib/libpthread.so.0 [0xb80914fa]
/lib/libpthread.so.0 [0xb8091415]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8b7b860 = SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed
     FROM session
     WHERE  sess_id=?
thd->thread_id=1
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.

[root w wolf mysql]# uname -a
Linux wolf 2.6.28.9-3 #1 SMP Tue Apr 21 13:21:56 CEST 2009 i686
Intel(R)_Pentium(R)_III_CPU_family______1133MHz PLD Linux

-- 
pozdrawiam,
Michał Łukaszek
prism w pld-linux.org