Informix:Could not do a physical-order read to fetch netxt row异常
来源:互联网 发布:mac make alias 编辑:程序博客网 时间:2024/06/03 18:15
问题描述:
昨天某同事反应号码预占与释放抛 Could not do a physical-order read to fetch netxt row异常。
如果对那段逻辑,设置断点的话,倒能正常预占释放。和他一起看了半天代码,没发现异样。
处理过程:
1.代码检查无果后,转下informix设置
2.执行informix 表、锁设置
a.ALTER TABLE <table name> LOCK MODE (ROW)
b.update statistics high
c.SET LOCK MODE TO WAIT 10 (10ms)
依然时好时坏,问题没能完全解决。
转机:
今天他神奇发现下面代码:
..
saveInst(p1,p2) ;
...
preUse(x1,x2,x3);
异常是在js代码preUse中抛出来的。saveInst与preUse均采用异步ajax调用后台逻辑处理。
原因在于:在saveInst尚未完全执行完毕时,preUse已经开始执行,此时表被锁。
最终解决:
在上【处理过程】基础上,修改上面逻辑,在saveInst中,通过回调函数方式,执行preUse方法。
备注:
此版本代码,在Oracle上面,能正常使用,与Oracle锁的机制相关。
- Informix:Could not do a physical-order read to fetch netxt row异常
- informix错误Could not do a physical-order read to fetch next row解决
- error "could not read a hi value - you need to populate the table".
- svn: Could not use external editor to fetch log message
- Android中出现:Failed to read row 0, column -1 from a CursorWindow which has 1 rows, 5 columns异常
- git push origin master fatal: 'origin' does not appear to be a git repository fatal: Could not read
- Android Studio 2.1 Beta Fetch failed fatal: Could not read from remote repository
- Error with hilo in NHibernate - “could not read a hi value - you need to populate the table”
- libtest.a: could not read symbols: Archive has no index; run ranlib to add one的原因和解决方案
- How to read data from a file in reverse order?
- A complete message could not be read on socket
- make error: libneon.a: could not read symbols: Bad value
- 解决 liblog4cpp.a: could not read symbols: Bad value
- 异常信息: ResultSet can not re-read row data for column 2
- svn commit 时 Could not use external editor to fetch log message
- svn: Could not use external editor to fetch log message; 问题解决
- svn: Could not use external editor to fetch log message; 问题解决
- svn: Could not use external editor to fetch log message; 问题解决
- java内存模型总结
- 季宏敏对话冯庆
- javascript[js]获取url参数的代码
- Oracle授权访问
- JAVA反射使用手记
- Informix:Could not do a physical-order read to fetch netxt row异常
- 成员初始化表的作用 实例解析
- 季宏敏对话冯庆
- 随机提取N条记录的SQL语句(转)
- JAVA线程池ThreadPoolExecutor与阻塞队列BlockingQueue
- 如何用 JavaScript 获取当前 URL 的文件名
- SCM软件配置管理
- C#对Outlook2010 编程
- Android 中的WiFi学习笔记——经典