How to avoid “ERROR (6101): allocated too many command handles”(DBMR: 2017)?

~ 0 min
2016-03-09 10:44

Applications can allocate 257 statement handles in one connection by default. The error will be return when statements reached database limited value.bescause Create Statement but not corresponding Close Statement in application will cause statement increasing and achieve the limiting value. So if errors occur you should check the application whether corresponding Close Statement exist. In addition, if because of business or other reasons to be statement over than 257, you can set keyword DB_MXCMD= xxx in dbmconfig.ini file to solve this problem. Attention please, you need restart DB server after set DB_MXCMD keyword.

Version: DBMaker 5.x

Product: Normal, Bundle

Platform: Windows, Linux

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags