- 浏览: 127017 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
zzhanp:
完了?
工厂模式 -
greatwqs:
《How Tomcat WorK 》?
《How Tomcat Words 》读后理解 -
yusong0715:
...
工厂模式 -
Garfield.Geng:
// Spring有做过的。
/**
* Test ...
年末整理十四 MD5加密 -
phz50:
这帖子太逗了
女朋友想要什么
ORA-00600: 内部错误代码,参数: [], [], [], [], [], [], [], []
ORA-00604: 递归 SQL 层 出现错误
异常代码:
org.springframework.jdbc.UncategorizedSQLException:
Hibernate operation: could not execute query; uncategorized SQLException for SQL
[select count(*) as col_0_0_ from HC_COMMENT.LEAVEWORD leaveword0_, HC_COMMENT.TOPIC topic1_ where leaveword0_.TOPIC_ID=topic1_.ID and leaveword0_.INFO_ID=108268 and topic1_.AREACODE='001' and leaveword0_.LEAVEWORD_DINGNUM+leaveword0_.LEAVEWORD_BACKNUM>=5]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)
at com.hc360.comment.dao.core.HibernateGenericDao.pagedQuery(HibernateGenericDao.java:231)
at com.hc360.comment.dao.impl.FrontLeavewordDaoImpl.getHotNewLeaveword(FrontLeavewordDaoImpl.java:287)
at com.hc360.comment.manager.impl.FrontLeavewordManagerImpl.getHotNewLeaveword(FrontLeavewordManagerImpl.java:274)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy9.getHotNewLeaveword(Unknown Source)
at com.hc360.comment.manager.impl.LeaveWordServiceImpl.getHotNewLeaveword4DB(LeaveWordServiceImpl.java:715)
at com.hc360.comment.action.leaveword.LeavewordMoreListAction.moreLeavewords(LeavewordMoreListAction.java:213)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.hc360.comment.interceptor.FrontLoginInterceptor.intercept(FrontLoginInterceptor.java:32)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
解决办法: tomcat重启服务
解析:
ORA-00604 error occurred at recursive SQL level string
记得有个高手总结了关于ORA-00604/ORA-04031问题的解决:
修改INIT.ora 添加 _db_handles_cached = 0
该错误最常见的原因是数据库文件initSID.ora中的参数OPEN_CURSORS值太小。可以修改initSID.ora文件,OPEN_CURSORS的值一般为255.修改完后,宕下ORACLE,再重新启动。
还可以设置并启动数据库的事件跟踪功能。在initSID.ora中加上一行:event = "00604 trace name errorstack"
造成ORA-604错误的其它原因可能有:
- initSID.ora中,参数DC_FREE_EXTENTS或ROW_CACHE_ENQUEUES太低。可以根据操作系统和数据库的情况,适当增加这两个参数的值,宕下并重新启动ORACLE.
- 运行超出空间(伴随ORA-1547错误)。这时,要对表空间添加新文件,即增加表空间的大小。
- 达到了MAX_EXTENTS(伴随ORA-1556错误)。如果这样,就要修改表,允许更多的扩展。请从技术手册中查找MAX_EXTENTS的最大值。如果已经达到了最大值,必须用compress extents选项,把表卸出(export),再导入(import)数据库中。
_+++++++++++++++++++++++
请看http://www.dbanotes.net/Oracle/a_case_about_export.htm
发表评论
-
hashmap数据结构分析的还可以
2011-09-30 15:09 760http://www.iteye.com/topic/9072 ... -
webtrends 分析
2011-07-13 17:41 1692目标: 跨页面跨域轨迹分析 大网站监控服务的部署 日志 ... -
并发服务器模型
2011-07-12 23:41 1012并发服务模型: 预先分配多线程数,使用互斥锁 预先分配多进 ... -
怎样解决南北互通的难题?
2011-07-12 23:18 983http://www.west263.com/info/h ... -
HTTP REFERER 与防图片盗链
2011-06-23 14:44 1754什么是HTTP Referer 简言 ... -
HTTP协议的请求响应模式
2011-06-23 11:09 1892HTTP协议的request/response ... -
oracle错误码大全
2011-06-20 10:50 1305转载: http://laoshifu.iteye.com/b ... -
随笔记得总结
2011-06-08 22:42 736webservice bingo RPC -
nginx
2011-06-03 18:37 630nginx -
HTTP状态信息
2011-06-03 15:20 794在Wininet下使用http进行异步传输数据,通过一个回调函 ... -
HTTP协议header头域
2011-05-30 17:33 831HTTP协议header头域 摘自: h ... -
tomcat点滴之性能 部分参数说明
2011-05-23 15:11 857tomcat性能调整的几点: 1. enableLookup ... -
oracle 时间相减
2011-04-26 18:04 1404oracle 两个时间相减 默认的是天数 oracl ... -
年末整理十四 MD5加密
2011-01-28 18:47 1077import java.io.UnsupportedEncod ... -
年末整理十三
2011-01-28 18:46 986############################### ... -
年末整理十二
2011-01-28 18:43 869安装MySQL 时,系统提示:Cannot create wi ... -
年末整理十一
2011-01-28 18:38 602摘要: 今天同学们在群里讨论oracle的count( ... -
年末整理十 表分区
2011-01-28 18:36 1552获得分区信息MySQL可以通过如下方式来获取分区表的信息:Sh ... -
年末整理九 mysql存储过程例子
2011-01-28 18:29 1052create procedure uchome_blog_pr ... -
年末整理八 引擎MYSQL
2011-01-28 18:28 1159显示引擎的命令得到一 ...
相关推荐
win 8 升级 win 10 后,oracle 11g 无法启动及客户端连接,命令行sqlplus登录,startup 时报 ORA-00119 和 ORA-00132 的错误。 1. sqlplus /nolog 2. conn / as sysdba 3. startup 报错: ORA-00119 和 ORA-00132
您可能感兴趣的文章:常用的Oracle doc命令(收藏)Oracle 多行记录合并/连接/聚合字符串的几种方法Oracle中字符串连接的实现方法php连接oracle数据库及查询数据的方法plsql连接oracle数据库报ora 12154错
本人在工作中,从测试库往正式库中复制记录,用select for update 报错:ORA-01480:STR 绑定值的结尾 Null字符缺失 ,遂上网查找,都说是有非法字符(半个引号) 或者长度超长造成的。根据本人分析,应该不是上述原因...
oracle expdp导出blob字段遇到ora-01555报错的解决方案
记录一次通过隐含参数的恢复报错处理
oracle数据库中ora-类型报错及处理,工作过程中整理记录,
Oracle用户被锁,PL/SQL工具里使用用动态sql,导出对象 SQL脚本,ORA-00059解决办法,oracle ORA-01502 错误,ORA-24550,ORA-02054,查看oracle表每条记录的创建时间,
闪回区爆满问题也是经常会遇到的问题,最关键的是闪回设置大小以及归档被默认存放在了闪回目录,恰巧今天又遇到了这个问题,就记录下处理步骤,仅供遇到这类问题的人参考。 一、错误现象描述 1)应用端错误信息 ...
oracle介质恢复的内部过程--推断与参考 这个是两年前学习oracle总结的东西,不算什么新东西,仅作为个人的一个记录,也欢迎大家一起学习讨论。
设置errorstack,在发生特定的ORA错误时会记录发生问题的会话,语句以及各个进程的trace文件, 在alert日志中有记录错误记录的trace文件位置,也可以给单独会话开启errorstack,追踪会话报错信息,可以通过 下面两个...
mysql等其他数据库中有随着记录的插入而表ID自动增长的功能,而oracle却没有这样的功能,我们有以下两种方式可以解决字段自增长的功能。 因为两种方式都需要通过创建序列来实现,这里先给出序列的创建方式。 CREATE ...
作为一个Oracle数据库开发者或者DBA,在实际工作中经常会遇到这样的问题:试图对库表中的某一列或几列创建唯一索引时,系统提示ORA-01452:不能创建唯一索引,发现重复记录。 下面我们以表code_ref为例来讨论这个...
oracle调度程序Oracle定时任务讲解 oracle调度程序Oracle定时任务讲解
个人对于oracle ebs的学习笔记和心得
ORA脚本验证器用于验证Oracle SQL脚本是否存在常见错误的CLI。支持的检查链接文件(例如@@ myscript.sql) 表参考(外键,读取授权,更改,DML)用法要求: : npx orasv install.sql 您也可以直接从安装它并脱机...
12 ORA‐00604: error occurred at recursive SQL level 2 13 ORA‐01555: snapshot too old: rollback segment number 7 with name 14 "_SYSSMU7_4222772309$" too small 15 Process ID: 1730 16 Session ID: 1996 ...
Ora-Logger 应用程序是 Oracle 的高级日志记录系统。 它提供了将日志语句以不同的优先级编码到源代码中的能力。 一旦代码被编译,输出电平可以即时增加或减少。
1.下面语句错误的原因是: Update departments set department_id=300 where department_id=60; ERROR 位于第 1 行:
sga调整过大oracle无法启动解决方案文档记录了LINUX环境下将ORACLE的SGA设置过大导致数据库无法启动的解决方案
发现问题 某网友的数据库由于坏盘了,并且存储掉电,导致数据库无法open了。单看其数据库alert log的错误来看,是非常之简单的,如下: Fri Oct 26 10:33:53 2018 Recovery of Online Redo Log: Thread 1 Group 3 ...