• Registered: 07/12/2011
  • Posts: 18

Topic: Asset Entry Module

Dear all,

When i want to key in the asset entry, mysql giving an error code like below,What that's mean ?

DATABASE ERROR : could not get all assets
error code : 1436
error message : Thread stack overrun: 12912 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive

Thanks for your supports

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Asset Entry Module

Increase the thread_stack parameter value from the current 128K to 192 K for 32 bit systems or 256 K for 64 bit systems.

http://stackoverflow.com/questions/2919558/mysql-servers-thread-stack-parameter-what-is-it-how-big-should-it-be
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

You will need to set it in the my.cnf or my.ini or .my.cnf file under the [mysqld] stanza and restart the mysqld process/server.

thread_stack=196608

apmuthu's Website