找文章 / 找答案
kaccy玄铁二 关注Ta
  • 发帖数14
  • 粉丝0

此人很懒，什么也没有留下

    作者更多精彩帖子
    热门问答 更多热门问答
    精选问答 更多内容
    123下一页
    返回列表 发新帖

    技术支持 java.lang.NullPointerException报错

    kaccy玄铁二 显示全部楼层 发表于 2021-7-1 11:48:26 |阅读模式 打印 上一主题 下一主题
    select * from dw_user_info_all_d where dt = '20210622'; 我语句有什么错






    回复

    使用道具 举报

    精彩评论28

    永洪tech-wisiy青铜一 显示全部楼层 发表于 2021-7-1 11:50:04
    看不出问题呢，请详细说明一下什么情况下
    回复 支持 反对

    使用道具 举报

    kaccy玄铁二 显示全部楼层 发表于 2021-7-1 11:50:56
    永洪tech-wisiy 发表于 2021-7-1 11:50
    看不出问题呢，请详细说明一下什么情况下

    我连接的maxcompute数据源，查询一直这样报错
    回复 支持 反对

    使用道具 举报

    永洪tech-wisiy青铜一 显示全部楼层 发表于 2021-7-1 11:52:18
    kaccy 发表于 2021-7-1 11:50
    我连接的maxcompute数据源，查询一直这样报错

    这个需要详细看一下日志
    回复 支持 反对

    使用道具 举报

    kaccy玄铁二 显示全部楼层 发表于 2021-7-1 11:55:02
    永洪tech-wisiy 发表于 2021-7-1 11:52
    这个需要详细看一下日志

    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:48:24.707] |-[INFO] |-[16a51414c39d461c8059dd1b42dbf090] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 433M, free jvm mem: 590M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:48:44.707] |-[INFO] |-[2470d2bf26c842dc851895b9a3d2bb44] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 442M, free jvm mem: 581M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:49:04.707] |-[INFO] |-[2481d3a8872d45878aee8effd1521456] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 289M, free jvm mem: 734M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:49:24.708] |-[INFO] |-[a9e8b931b079486e9208f21b3916b381] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 298M, free jvm mem: 725M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:49:44.707] |-[INFO] |-[839f278d3e9246cbb647b4f479e032b0] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 307M, free jvm mem: 716M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:50:04.707] |-[INFO] |-[6f1ef2b5f7b94c479300faa38be6961e] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 316M, free jvm mem: 707M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:50:12.686] |-[INFO] |-[5df4833785a9408ca23150db696887fd] |-[admin] |-[g5.gqry.RunQryMgr.countGQueryCacheHits(RunQryMgr.java:354)] |-[QUERY: [___CONNECTION___/test/未命名-0/hellokaccy/hellokaccy/dw_user_info_all_d_0]  Total count of GQuery get AggGrid : 0,count of has refresh parameter : 0,count of hit postCache : 0,count of hit preCache : 0;Total count of GQuery get DetailGrid : 5,count of has refresh parameter : 0,count of hit tempCache : 0.]
    [2021-07-01 11:50:22.695] |-[INFO] |-[5df4833785a9408ca23150db696887fd] |-[admin] |-[g5.qry.sql.impl.SQLConnPool.checkConnValid(SQLConnPool.java:419)] |-[QUERY: [___CONNECTION___/test/未命名-0/hellokaccy/hellokaccy/dw_user_info_all_d_0]  connection g5.qry.sql.impl.GConn@1a04971c is checked valid, cost 12 ms]
    [2021-07-01 11:50:24.707] |-[INFO] |-[d7731204096642ef878388b5484b86d6] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 329M, free jvm mem: 694M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:50:44.706] |-[INFO] |-[42661a1d24a945ac8af63a452ea41205] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 338M, free jvm mem: 685M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:51:04.703] |-[INFO] |-[b123bf5022b342b68011e97c95c9bfe4] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 347M, free jvm mem: 676M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:51:24.705] |-[INFO] |-[96ab2aa5177544308600354bad815e22] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 356M, free jvm mem: 667M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:51:44.705] |-[INFO] |-[7efee95e82764b19a9b6228931c73ddd] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 365M, free jvm mem: 658M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:52:00.766] |-[INFO] |-[9fbbd547f05441feba3c01bf3808b083] |-[SYSTEM] |-[g5.qry.sql.impl.SQLConnPool.checkConnValid(SQLConnPool.java:419)] |-[OTHER:   connection g5.qry.sql.impl.GConn@73596d51 is checked valid, cost 12 ms]
    [2021-07-01 11:52:04.703] |-[INFO] |-[12cfa83a654b47fbb7a0ef26c5259e26] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 374M, free jvm mem: 649M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:52:04.831] |-[INFO] |-[e953360a36e24b75ac9d588900f0c5e5] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER:   Not need adjust mem, free: 73696160, total: 466616320]
    [2021-07-01 11:52:24.705] |-[INFO] |-[cfa8b9e51c6144ff8fded286390fd92d] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 383M, free jvm mem: 640M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:52:24.836] |-[INFO] |-[6f4a7c767924478e94e596808e28a40b] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER:   Not need adjust mem, free: 64293368, total: 466616320]
    [2021-07-01 11:52:29.727] |-[ERROR] |-[31500e3318e3468da0ff1b99f811b09e] |-[SYSTEM] |-[g5.sv.h5.PortalWebSocket.onError(PortalWebSocket.java:226)] |-[ERROR: [ErrCode: 0]  java.util.concurrent.TimeoutException: Idle timeout expired: 300003/300000 ms]
    org.eclipse.jetty.websocket.api.CloseException: java.util.concurrent.TimeoutException: Idle timeout expired: 300003/300000 ms
            at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onReadTimeout(AbstractWebSocketConnection.java:560) ~[websocket-common-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.AbstractConnection.onFillInterestedFailed(AbstractConnection.java:172) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillInterestedFailed(AbstractWebSocketConnection.java:533) ~[websocket-common-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.AbstractConnection$ReadCallback.failed(AbstractConnection.java:317) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.FillInterest.onFail(FillInterest.java:138) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.AbstractEndPoint.onIdleExpired(AbstractEndPoint.java:407) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.IdleTimeout.checkIdleTimeout(IdleTimeout.java:171) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at org.eclipse.jetty.io.IdleTimeout.idleCheck(IdleTimeout.java:113) ~[jetty-io-9.4.21.v20190926.jar:9.4.21.v20190926]
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
            at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
            at java.lang.Thread.run(Thread.java:834) [?:?]
    Caused by: java.util.concurrent.TimeoutException: Idle timeout expired: 300003/300000 ms
            ... 8 more
    [2021-07-01 11:52:29.736] |-[INFO] |-[21472e11b51b496cbd57bd705e8ce0c8] |-[SYSTEM] |-[g5.AbsSetting.getLong(AbsSetting.java:297)] |-[OTHER:   long value does not exist: websocket.session.interval]
    [2021-07-01 11:52:29.737] |-[WARN] |-[cb48b7c7693c405b99f3bd534f3ae9b7] |-[SYSTEM] |-[g5.sv.h5.PortalWebSocket.onOpen(PortalWebSocket.java:55)] |-[OTHER:   websocket session timeout interval: 300000]
    [2021-07-01 11:52:30.948] |-[INFO] |-[1b0e0ba4c7d945a6a2376cdea3e04eac] |-[SYSTEM] |-[g5.AbsSetting.getBoolean(AbsSetting.java:381)] |-[OTHER:   boolean value does not exist: websocket.notify.debug]
    [2021-07-01 11:52:32.951] |-[INFO] |-[2e9d76d1ede44fa09a629d6adc655a46] |-[SYSTEM] |-[g5.qry.database.AbsDBTableExecutor.executeCustomQry(AbsDBTableExecutor.java:338)] |-[OTHER:   querySql:[select count(*) as C  from  "YH_USER_MSG" a  where  ( a."NOTIFIED" = ? ) AND ( a."STATUS" = ? ) ], params:[admin, 1]]
    [2021-07-01 11:52:32.952] |-[WARN] |-[edc1b2007a254cd8beda6b6490cdf005] |-[SYSTEM] |-[g5.thread.ThreadUtil.regc(ThreadUtil.java:292)] |-[OTHER:   Thread did not initialize meta: Thread[Timer-19,5,main]]
    [2021-07-01 11:52:44.703] |-[INFO] |-[c61e7f99c367494a8d91ce11ea41630a] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 392M, free jvm mem: 631M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:52:44.838] |-[INFO] |-[d3a0d78cd3c54769945a1d3bdf1dcba2] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER:   Not need adjust mem, free: 54703776, total: 466616320]
    [2021-07-01 11:52:50.922] |-[WARN] |-[db6ef675536f4b0a97d7fcf0a4096d70] |-[SYSTEM] |-[g5.util.Util.getLocalMac(Util.java:4673)] |-[OTHER:   get local mac error:null]
    [2021-07-01 11:53:04.703] |-[INFO] |-[321134aa63594144aef98127da7086c5] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 402M, free jvm mem: 621M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:53:04.841] |-[INFO] |-[f2f7a766606f488b9cb7c6275c25f9e5] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER:   Not need adjust mem, free: 45030808, total: 466616320]
    [2021-07-01 11:53:23.822] |-[INFO] |-[5402167b252a477a895d5815733ca5b6] |-[admin] |-[g5.sv.console.req.HomeReq.processIns(HomeReq.java:167)] |-[OTHER:   Handle Homereq action getIndexPageProp, use 0.0 ms time.]
    [2021-07-01 11:53:23.854] |-[INFO] |-[dc7d6e3c2c344d9793bd835e282e38fa] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:381)] |-[OTHER:   boolean value does not exist: py.serve.local]
    [2021-07-01 11:53:23.854] |-[INFO] |-[dc7d6e3c2c344d9793bd835e282e38fa] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:381)] |-[OTHER:   boolean value does not exist: py.serve.fork]
    [2021-07-01 11:53:24.703] |-[INFO] |-[66428cc66be64e29822ef4a9c279c6f5] |-[SYSTEM] |-[g5.mem.AbsLink$Reporter.run0(AbsLink.java:332)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 413M, free jvm mem: 610M
    --GRLink Report, link count: 12, total link mem: 170M, used link mem: 0M
    --GSLink Report, link count: 7, total link mem: 341M, used link mem: 0M
    --Direct memory report, max: 1024M, used: 0M]
    [2021-07-01 11:53:24.841] |-[INFO] |-[d933a5427d9b43cf9f064048f2448fff] |-[SYSTEM] |-[g5.mem.LinkMgr.adjustMem(LinkMgr.java:185)] |-[OTHER:   Not need adjust mem, free: 32435624, total: 466616320]
    [2021-07-01 11:53:25.322] |-[INFO] |-[8465b9e1574c4c84a15de3d6704e5131] |-[admin] |-[g5.AbsSetting.getBoolean(AbsSetting.java:381)] |-[OTHER:   boolean value does not exist: alert.insert.debug]
    [2021-07-01 11:53:25.323] |-[INFO] |-[4f77c51547c746159892ae45c5ab6d98] |-[admin] |-[g5.qry.database.AbsDBTableExecutor.executeCustomQry(AbsDBTableExecutor.java:338)] |-[OTHER:   querySql:[select count(*) as C  from  "YH_USER_MSG" a  where  ( a."NOTIFIED" = ? ) AND ( a."STATUS" = ? ) ], params:[admin, 1]]
    [2021-07-01 11:53:25.373] |-[INFO] |-[8465b9e1574c4c84a15de3d6704e5131] |-[admin] |-[g5.qry.database.AbsDBTableExecutor.executeCustomQry(AbsDBTableExecutor.java:338)] |-[OTHER:   querySql:[select MSG.*, USRMSG."NOTIFIED", USRMSG."STATUS" as READ_STATUS  from  "YH_MSG" MSG
    join "YH_USER_MSG" USRMSG on USRMSG."MSGID" = MSG."MSGID"   where  USRMSG."NOTIFIED" = ?   order by USRMSG."TRIGGERTIME" DESC OFFSET 0 ROWS
    FETCH NEXT 15 ROWS ONLY], params:[admin]]
    [2021-07-01 11:53:25.389] |-[INFO] |-[8465b9e1574c4c84a15de3d6704e5131] |-[admin] |-[g5.qry.database.AbsDBTableExecutor.executeCustomQry(AbsDBTableExecutor.java:349)] |-[OTHER:   countSql:[select count(*) as C  from  "YH_MSG" MSG
    join "YH_USER_MSG" USRMSG on USRMSG."MSGID" = MSG."MSGID"   where  USRMSG."NOTIFIED" = ? ], params:[admin]]
    回复 支持 反对

    使用道具 举报

    永洪tech-wisiy青铜一 显示全部楼层 发表于 2021-7-1 11:58:06
    请发文件附件吧
    回复 支持 反对

    使用道具 举报

    kaccy玄铁二 显示全部楼层 发表于 2021-7-1 12:02:32
    log-30.225.0.104.zip (68.96 KB, 下载次数: 96)

    附件
    回复 支持 反对

    使用道具 举报

    永洪tech-wisiy青铜一 显示全部楼层 发表于 2021-7-1 13:25:55
    kaccy 发表于 2021-7-1 12:02
    附件

    Error:[400] com.aliyun.odps.OdpsException: ODPS-0130161:[3,27] Parse exception - invalid token '.'”]，SQL有问题，数据库抛出来的错误
    回复 支持 反对

    使用道具 举报

    kaccy玄铁二 显示全部楼层 发表于 2021-7-1 13:28:19
    永洪tech-wisiy 发表于 2021-7-1 13:25
    Error:[400] com.aliyun.odps.OdpsException: ODPS-0130161:[3,27] Parse exception - invalid token '.' ...

    那应该怎么改呢？
    回复 支持 反对

    使用道具 举报

    永洪tech-wisiy青铜一 显示全部楼层 发表于 2021-7-1 13:31:26
    kaccy 发表于 2021-7-1 13:28
    那应该怎么改呢？

    我这边没有使用过这个数据库，你可以查看一下有关该数据库的相关文档哦~
    回复 支持 反对

    使用道具 举报

    123下一页
    高级模式
    B Color Image Link Quote Code Smilies
    您需要登录后才可以回帖 登录 | 免费注册

    热门产品

    企业版购买试用 vividime Desktop vividime Z-Suite vividime X-Suite vividime Copilot 永洪云

    社区资源

    互助问答 海量模板 永洪学院 成功案例 帮助中心 积分商城

    关于永洪

    了解永洪 加入永洪 市场活动 媒体报道 联系我们
    • 官方微信

      欢迎关注永洪服务号！收费为0，价值无限

      扫码关注
    • 新浪微博

      让每位用户轻松挖掘数据价值！

      访问新浪微博
    • 智能客服
    50W

    会员等你来哦

    Copyright   ©2012-2024  北京永洪商智科技有限公司  (京ICP备12050607) 京公网安备110110802011451号 |《永洪社区协议》
    返回顶部