起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › Java heap space
返回列表 发新帖
查看: 3704|回复: 2

[结贴] Java heap space

[复制链接]

156

主题

748

帖子

2430

积分

金牌会员

Rank: 6Rank: 6

积分
2430
QQ
发表于 2020-9-28 11:53:20 | 显示全部楼层 |阅读模式
单表中大概有50万条数据，打开功能界面后台报如下错误。尝试办法：1、<db-paging>true</db-paging>修改成true
                 2、jvm参数设置为-Xms1024M -Ddebug=true -XX:MaxPermSize=1024m。两种办法都不行。请问怎么解决？
  1. java.lang.RuntimeException: queryLimit: 10000, ksql: SELECT ZJJG_YHZHJYXX.*  FROM ZJJG_YHZHJYXX ZJJG_YHZHJYXX ORDER BY ZJJG_YHZHJYXX.TRANSDATE desc LIMIT 0, -1
  2.         at com.justep.system.data.impl.TableUtilsImplement.queryWarn(Unknown Source)
  3.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  4.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  5.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  6.         at com.justep.system.data.BizData.query(Unknown Source)
  7.         at BizProcedure.query(BizProcedure.java:12)
  8.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  9.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  10.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  11.         at java.lang.reflect.Method.invoke(Method.java:497)
  12.         at com.justep.system.action.Engine.invokeActions(Native Method)
  13.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  14.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  15.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  16.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  17.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  18.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  19.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  20.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  21.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  22.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  23.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  24.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  25.         at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
  26.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  27.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  28.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  29.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  30.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  31.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  32.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  33.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
  34.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
  35.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
  36.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  37.         at java.lang.Thread.run(Thread.java:745)
  38. 2020-09-28 11:18:57 excute stream action, params:{"accept":"application/json","action":"queryZJJG_YHZHJYXXAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"CDFLAG,CRTACC,CRTBANKNAME,CRTNAME,CRTUNITNAME,CURRENCYNAME,DATASOURCE,DBTACC,DBTBANKNAME,DBTNAME,DBTUNITNAME,DR,GROUP_NAME,IFINSIDE,IFREAD,INSIDEIDENT,ISVERIF,NUSAGE,PK_GROUP,PUBANDPRIVATEIDENT,READDATE,TRANSABSTR,TRANSDATE,TRANSTIME,TRSAMT,TRSAMTLOCAL,TYPE,UNITCODE,UNITNAME,YEAR,ZJJG_YHZHJYXX,version","limit":-1,"offset":0,"variables":{}},"process":"/zjjg/dtzjqs/process/dj_yhzhjyxx/dj_yhzhjyxxProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"ZJJG_YHZHJYXX","sequence":"CDFLAG,CRTACC,CRTBANKNAME,CRTNAME,CRTUNITNAME,CURRENCYNAME,DATASOURCE,DBTACC,DBTBANKNAME,DBTNAME,DBTUNITNAME,DR,GROUP_NAME,IFINSIDE,IFREAD,INSIDEIDENT,ISVERIF,NUSAGE,PK_GROUP,PUBANDPRIVATEIDENT,READDATE,TRANSABSTR,TRANSDATE,TRANSTIME,TRSAMT,TRSAMTLOCAL,TYPE,UNITCODE,UNITNAME,YEAR,ZJJG_YHZHJYXX,version"},"transformIdcolumn":true,"useNamespace":true}}
  39. java.lang.reflect.InvocationTargetException
  40.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  41.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  42.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  43.         at java.lang.reflect.Method.invoke(Method.java:497)
  44.         at com.justep.system.action.Engine.invokeActions(Native Method)
  45.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  46.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  47.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  48.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  49.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  50.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  51.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  52.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  53.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  54.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  55.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  56.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  57.         at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
  58.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  59.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  60.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  61.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  62.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  63.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  64.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  65.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
  66.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
  67.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
  68.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  69.         at java.lang.Thread.run(Thread.java:745)
  70. Caused by: java.lang.OutOfMemoryError: Java heap space
  71.         at java.util.HashMap.newNode(HashMap.java:1734)
  72.         at java.util.HashMap.putVal(HashMap.java:641)
  73.         at java.util.HashMap.put(HashMap.java:611)
  74.         at com.justep.system.data.impl.TableImpl$CoreRowImpl.<init>(Unknown Source)
  75.         at com.justep.system.data.impl.TableImpl.appendRow(Unknown Source)
  76.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  77.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  78.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  79.         at com.justep.system.data.BizData.query(Unknown Source)
  80.         at BizProcedure.query(BizProcedure.java:12)
  81.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  82.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  83.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  84.         at java.lang.reflect.Method.invoke(Method.java:497)
  85.         at com.justep.system.action.Engine.invokeActions(Native Method)
  86.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  87.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  88.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  89.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  90.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  91.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  92.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  93.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  94.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  95.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  96.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  97.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  98.         at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
  99.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  100.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  101.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  102.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
复制代码



回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2020-9-28 15:42:18 | 显示全部楼层
SELECT ZJJG_YHZHJYXX.*  FROM ZJJG_YHZHJYXX ZJJG_YHZHJYXX ORDER BY ZJJG_YHZHJYXX.TRANSDATE desc LIMIT 0, -1

页面中分页查询啊，limit为-1说明没有分页查询
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

156

主题

748

帖子

2430

积分

金牌会员

Rank: 6Rank: 6

积分
2430
QQ
 楼主| 发表于 2020-9-29 20:39:55 | 显示全部楼层
jishuang 发表于 2020-9-28 15:42
SELECT ZJJG_YHZHJYXX.*  FROM ZJJG_YHZHJYXX ZJJG_YHZHJYXX ORDER BY ZJJG_YHZHJYXX.TRANSDATE desc LIMIT ...

结帖
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-11-25 09:32 , Processed in 0.054682 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表