hello~
When I try to "Using a stack trace" there's no "mysqld.sym.gz" on our
server . Can we always find "mysqld.sym.gz" on any operating system? Our
operating system is Linux 7.0 . I would like to mail you our error log to
see if you can tell us what's wrong with our MySQL which always crash
unexpectedly . Thanks !
Sincerely yours .
Tracy Lu
Following is error log:
020213 21:50:23?mysqld started
/home/ap1/libexec/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
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 range sanity check OK, backtrace follows:
0x4007d00e
0x815f4f8
0x815f1c1
0x8143b08
0x81503ff
0x81506b9
0x81505ae
0x810e625
0x81050f7
0x8104de8
0x8105f73
0x8102107
0x80e3cc1
0x80e20ac
0x80c7605
0x80cb4ec
0x80c6a4d
0x80c5f66
Stack trace successful, trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x823a7c0 = select count(invno) as tlrecs from srvmst where
invno='k0036381' and strno ='2053'
thd->thread_id = 9861
Successfully dumped variables, if you ran with --log,
take a look at the details of what thread 9861 did to cause the crash.
In some cases of really bad corruption, this value may be invalid
Please use the information above to create a repeatable
test case for the crash, and send it to [EMAIL PROTECTED]
Number of processes running now: 0
020218 15:01:50?mysqld restarted
/home/ap1/libexec/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
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 range sanity check OK, backtrace follows:
0x4007d00e
0x4011bf48
0x80d82fa
0x80cb4d7
0x80c6a4d
0x80c5f66
Stack trace successful, trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8223268 = insert into tmptree1
(unid,parent,child,title,att,filename,sysfilename,owner,beginday,begintime
,endday,endtime,sequence,groupname) values
('3d850d56f8784f4f64427363cfe07f6e','309082909d9419a6201c622129c8357e','1e
fe2c23f8f57e71df959033b1344a83','針對Acer產品之新品故障與維修品處理方式','
D','4.txt','2587a47633a7f3c62bb96f1587bd2ccf.txt','90113','2000.12.13','12
:00','2002.12.10','24:00',8,'營業群組')
thd->thread_id = 79
Successfully dumped variables, if you ran with --log,
take a look at the details of what thread 79 did to cause the crash.
In some cases of really bad corruption, this value may be invalid
Please use the information above to create a repeatable
test case for the crash, and send it to [EMAIL PROTECTED]
Number of processes running now: 1
mysqld process hanging, pid 29649 - killed
020218 15:19:42?mysqld restarted
/home/ap1/libexec/mysqld: ready for connections
020218 15:37:01?mysqld started
/home/ap1/libexec/mysqld: ready for connections
020218 16:02:10?/home/ap1/libexec/mysqld: Normal shutdown
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php