WEB 在启动时 会limit 分页查数据库 数据 往redis缓存 一开始都没有问题 现在数据量大了 就会在启动中途中 报错 如下
Cause: java.sql.SQLException: java.lang.IllegalStateException: Have already allocated a maximum of 8192 pages
; uncategorized SQLException; SQL state [HY000]; error code [1105]; java.lang.IllegalStateException: Have already allocated a maximum of 8192 pages; nested exception is java.sql.SQLException: java.lang.IllegalStateException: Have already allocated a maximum of 8192 pages
mycat 报错
2021-12-08 04:05:43.551 WARN [BusinessExecutor11] (io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler.handleDataProcessException(MultiNodeQueryHandler.java:828)) - io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler@4f9bfc9a caught exception
java.lang.IllegalStateException: Have already allocated a maximum of 8192 pages
at io.mycat.memory.unsafe.memory.mm.DataNodeMemoryManager.allocatePage(DataNodeMemoryManager.java:254) ~[Mycat-server-1.6.7.1-release.jar:?]
at io.mycat.memory.unsafe.memory.mm.MemoryConsumer.allocatePage(MemoryConsumer.java:136) ~[Mycat-server-1.6.7.1-release.jar:?]
at io.mycat.memory.unsafe.utils.sort.UnsafeExternalSorter.acquireNewPageIfNecessary(UnsafeExternalSorter.java:385) ~[Mycat-server-1.6.7.1-release.jar:?]
at io.mycat.memory.unsafe.utils.sort.UnsafeExternalSorter.insertRecord(UnsafeExternalSorter.java:400) ~[Mycat-server-1.6.7.1-release.jar:?]
at io.mycat.memory.unsafe.utils.sort.UnsafeExternalRowSorter.insertRow(UnsafeExternalRowSorter.java:80) ~[Mycat-server-1.6.7.1-release.jar:?]
at io.mycat.sqlengine.mpp.DataNodeMergeManager.run(DataNodeMergeManager.java:465) ~[Mycat-server-1.6.7.1-release.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
求给出出主意谢谢了
