468,306 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,306 developers. It's quick & easy.

Anyone Can help me about MySQL - hang ?

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
2 3356
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
Thank you very much sir..

Aug 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Richard Gabriel | last post: by
2 posts views Thread by Jeremy K | last post: by
reply views Thread by Arthur Perry | last post: by
4 posts views Thread by Madhu Gopinathan | last post: by
10 posts views Thread by Lloyd Harold | last post: by
118 posts views Thread by Chuck Cheeze | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.