MySQL Forums
Forum List  »  Optimizer & Parser

java.sql.SQLException: maxBlockcount [5] reached!
Posted by: Holger Thiel
Date: September 15, 2008 02:52AM

Hi,

we get a very seldom message:

"java.sql.SQLException: maxBlockcount [5] reached!"

It seems an Optimizer/Memory-Problem.

On one system we do not get this error, but on the other one.

Regards,
Holger



The configuration ist nearly the same, besides these parameters:

connect_timeout
good : 5
bad : 10

innodb_flush_method
good : O_DSYNC
bad : O_DIRECT

range_alloc_block_size
good : 2048
bad : 4096

Options: ReplyQuote


Subject
Views
Written By
Posted
java.sql.SQLException: maxBlockcount [5] reached!
3112
September 15, 2008 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.