- 185
- 0
问题描述
跑项目就无限循环下面的语句,无法执行下一步,项目都没有报错,也不知道错在哪,就是不停的循环查表,表是空表,没有数据 。
问题出现的环境背景及自己尝试过哪些方法
相关代码
create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.del_flag=0 Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.del_flag=0 Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select applicatio0_.pid as pid1_24_, applicatio0_.pcode as pcode2_24_, applicatio0_.create_by as create_b3_24_, applicatio0_.create_time as create_t4_24_, applicatio0_.del_flag as del_flag5_24_, applicatio0_.pdescription as pdescrip6_24_, applicatio0_.domain_id as domain_i7_24_, applicatio0_.env_id as env_id8_24_, applicatio0_.item_state_id as item_sta9_24_, applicatio0_.pname as pname10_24_, applicatio0_.scope_id as scope_i11_24_, applicatio0_.status as status12_24_, applicatio0_.update_by as update_13_24_, applicatio0_.update_time as update_14_24_, applicatio0_.version as version15_24_, applicatio0_.app_sys_id as app_sys16_24_, applicatio0_.display_seq as display17_24_, applicatio0_.running_status as running18_24_, applicatio0_.type as type19_24_ from gov_application applicatio0_ where applicatio0_.pcode=? and applicatio0_.del_flag=? Hibernate: select appnodepo0_.pid as pid1_22_, appnodepo0_.pcode as pcode2_22_, appnodepo0_.create_by as create_b3_22_, appnodepo0_.create_time as create_t4_22_, appnodepo0_.del_flag as del_flag5_22_, appnodepo0_.pdescription as pdescrip6_22_, appnodepo0_.domain_id as domain_i7_22_, appnodepo0_.env_id as env_id8_22_, appnodepo0_.item_state_id as item_sta9_22_, appnodepo0_.pname as pname10_22_, appnodepo0_.scope_id as scope_i11_22_, appnodepo0_.status as status12_22_, appnodepo0_.update_by as update_13_22_, appnodepo0_.update_time as update_14_22_, appnodepo0_.version as version15_22_, appnodepo0_.app_code as app_cod16_22_, appnodepo0_.app_id as app_id17_22_, appnodepo0_.app_sys_id as app_sys18_22_, appnodepo0_.cluster_code as cluster19_22_, appnodepo0_.cluster_id as cluster20_22_, appnodepo0_.config_cent_id as config_21_22_, appnodepo0_.context_path as context22_22_, appnodepo0_.ip as ip23_22_, appnodepo0_.is_secure as is_secu24_22_, appnodepo0_.node_host as node_ho25_22_, appnodepo0_.port as port26_22_, appnodepo0_.reg_cent_id as reg_cen27_22_, appnodepo0_.type as type28_22_, appnodepo0_.url as url29_22_ from gov_app_node appnodepo0_ where appnodepo0_.del_flag=?
你期待的结果是什么?实际看到的错误信息又是什么?
1
打赏
收藏
点击回答
您的回答被采纳后将获得:提问者悬赏的 10 元积分
- 共 0 条
- 全部回答
-
繁华初下,心已空づ 普通会员 1楼
死循环查询是指一个查询运行得非常久,没有结果返回。这种情况通常是由于查询的执行顺序错误,或者查询没有正确关闭,导致查询一直在运行,而没有返回任何结果。
以下是一些可能导致死循环查询的原因:
-
查询的执行顺序错误:如果你的查询没有按照预期的顺序执行,那么它可能会一直运行下去,直到达到某个边界条件。例如,如果你的查询是使用ORDER BY子句按照某个字段的值对数据进行排序,如果你没有使用LIMIT子句限制排序的条数,那么查询可能会一直运行下去,直到达到所有记录。
-
查询没有正确关闭:如果你的查询没有正确关闭,那么它可能会一直运行下去,直到关闭。例如,如果你使用的是Python的pymysql库,你可以在查询执行完毕后使用
close()方法关闭连接。如果你没有使用这个方法,那么查询可能会一直运行下去。 -
查询中的循环引用:如果你的查询中存在循环引用,那么在某个时刻,这个查询可能会因为没有结束而运行下去。例如,如果你有一个嵌套的查询,其中子查询在结果中找到了一个重复的行,那么在子查询返回结果后,这个查询可能会一直运行下去,直到子查询结束。
解决死循环查询的方法取决于具体的情况。以下是一些可能的解决方案:
-
检查查询的执行顺序:确保你的查询按照预期的顺序执行,并使用LIMIT子句限制排序的条数。
-
确保查询没有错误关闭:确保你的查询在执行完毕后正确关闭。
-
确保查询中的循环引用:在编写查询时,确保你正确处理了循环引用。例如,你可以使用SQL的JOIN语句来处理嵌套查询中的循环引用。
如果你无法确定问题的原因,或者无法解决问题,可能需要寻求专业的数据库管理员的帮助。
-
更多回答
网站公告
- 扫一扫访问手机版
回答动态

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器更新之后。服务器里面有部分玩家要重新创建角色是怎么回事啊?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题函数计算不同地域的是不能用内网吧?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题ARMS可以创建多个应用嘛?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题在ARMS如何申请加入公测呀?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题前端小程序接入这个arms具体是如何接入监控的,这个init方法在哪里进行添加?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器刚到期,是不是就不能再导出存档了呢?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器的游戏版本不兼容 尝试更新怎么解决?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器服务器升级以后 就链接不上了,怎么办?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器转移以后服务器进不去了,怎么解决?预计能赚取 0积分收益

- 神奇的四哥:发布了悬赏问题阿里云幻兽帕鲁服务器修改参数后游戏进入不了,是什么情况?预计能赚取 0积分收益
- 回到顶部
- 回到顶部

