By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,494 Members | 881 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,494 IT Pros & Developers. It's quick & easy.

Anyone Can help me about MySQL - hang ?

P: n/a
This is my sample error in my MySQL Log

New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please
do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x894dfb8 = select
distinct(F_PK_GROUP_ID),F_GROUP_NAME_TH from
tbl_private_pur_itemgroup_twy_set_db
G,tbl_private_pur_itemtype_twy_set_db IT where
G.F_PK_GROUP_ID=IT.F_FK_GROUP_ID AND G.F_STATUS ='1' and
IT.F_EMP_ID='10235' order by F_PK_GROUP_ID ASC
thd->thread_id=165
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please
do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8846f50 = select distinct(F_TYPE_ID)
,F_ITEM_TYPE_NAME_TH from twy_pos_db.tbl_pur_item_twy_pos_db
T,twy_set_db.tbl_private_pur_itemtype_twy_set_db IT where
T.F_TYPE_ID=IT.F_PK_ITEM_TYPE_ID and T.F_GROUP_ID = '05' and
T.F_STATUS<>'0' and IT.F_EMP_ID='10235' order by F_ITEM_TYPE_NAME_TH
ASC
thd->thread_id=2
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please
do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8a40a58 = show create table `TBU_CLASS_DETAIL`
thd->thread_id=838
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

###################
Anyone can tell me step-by-step to solve these problems sir?

Thank you for advance
Pratchaya

Aug 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
pr*******@banana.co.th wrote:
This is my sample error in my MySQL Log

New value of fp=(nil) failed sanity check, terminating stack trace!


Googling for this error message, I gather that it's frequently due to
exhausting physical memory on your server running MySQL. Some people
have resolved the error by adjusting settings in their my.cnf file to
prevent the mysqld server from requesting too much memory. Also some
people limit the number of connections for users.

It may also be an error that is generated too enthusiastically by a
certain version of MySQL 4.0.x.
See http://archives.neohapsis.com/archiv...4-q3/0144.html

It could also be database corruption.
See http://www.jsw4.net/info/list-archiv.../msg00066.html

I would recommend following the database maintenance and repair
procedures described at: http://dev.mysql.com/doc/mysql/en/mysqlcheck.html

Also upgrade to the most recent release of MySQL 4.1.

Regards,
Bill K.
Aug 18 '05 #2

P: n/a
Thank you very much sir..

Aug 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.