无法串行访问事务错误:ORA-08177: can't serialize access for this transaction
来源:互联网 发布:苹果手机数据流量开关 编辑:程序博客网 时间:2024/06/07 04:06
当事务隔离级别为serializable,两个事务并发修改同一个对象,当前一个事务提交或回滚时,第二个事务会收到该错误。
测试使用表,此表用于生成唯一主键:
test@ORCL> create table id_table
2 (id_name varchar2(30) primary key,
3 id_value number);
Table created.
test@ORCL>insert into id_table values('MY_KEY',0);
1 row created.
test@ORCL>commit;
Commit complete.
会话一事务隔离级别serializable,修改id_table表中MY_KEY值加1,但不提交
test@ORCL>set transaction isolation level serializable;
Transaction set.
会话二事务隔离级别serializable,修改id_table表中MY_KEY值加1,但不提交
test@ORCL>set transaction isolation level serializable;
Transaction set.
test@ORCL>update id_table set id_value = id_value + 1 where id_name ='MY_KEY';
此时修改会被阻塞
会话一提交修改的数据,会话二会收到如下信息
test@ORCL>update id_table set id_value = id_value + 1 where id_name = 'MY_KEY';
update id_table set id_value = id_value + 1 where id_name = 'MY_KEY'
*
ERROR at line 1:
ORA-08177: can't serialize access for this transaction
- 无法串行访问事务错误:ORA-08177: can't serialize access for this transaction
- ORA-08177: can't serialize access for this transaction(一)
- CentOS gdb core 调试错误: error reading variable: can't compute CFA for this frame
- 局域网访问Apache PHP错误:Forbidden You don't have permission to access / on this server.
- yii中访问出现的错误: You don't have permission to access / on this server
- can't create transaction lock on ... 错误原因
- can't create transaction lock on ... 错误原因
- .mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this op
- mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this op
- mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this op
- Mysql 访问,提示无法连接Can't get hostname for your address Error 1042
- mysql远程访问出现MySQL错误1042-Can't get hostname for your address解决方法
- 解决本地访问MySql数据库出现“Can't get hostname for your address”错误
- Error: Can't access JTAG chain 错误情况讨论
- Selenium Firefox Python错误can't access dead object?
- Windows 下MySql无法实现远程访问。问题提示1024-can't get hostname for your address
- Mysql 5.5 无法远程登陆:Can't get hostname for your
- Can't start a cloned connection while in manual transaction mode.错误的解决方案
- 继续研究gloox2
- android学习笔记01
- android学习笔记01
- C++ 递归求斐波拉契数列
- 如何使用Java Singleton模式
- 无法串行访问事务错误:ORA-08177: can't serialize access for this transaction
- lost有感
- java设计模式学习系列之一:单例模式(Singleton)
- FBreader
- 初识网络游戏防作弊
- Refactoring improving the design of existing code (1)
- swf 头标签tag
- Qt中使用QProcess备份和恢复Mysql数据库
- C++读书笔记——typeid操作符(2009-8-1 9:22:00)