tiehan 2013-09-17 13:06 采纳率: 0%
浏览 1970

批量定时(使用quartz.jar) hibernate3.1.3+Spring1.2.8 程序运行一段时间停止

程序使用Hibernate 3.1.3+Spring 1.2.8,使用dbcp数据库连接,在程序中使用Quartz.jar定时四个任务,每天定时执行,运行几天后所有任务都不执行了,好像死锁了一样,无异常、无错误抛出,重新启动后又可正常执行。求高手指点,日志如下:

2013-09-17 21:00:41,859 org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
2013-09-17 21:00:41,890 org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.Oracle9Dialect
2013-09-17 21:00:41,890 org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
2013-09-17 21:00:41,890 org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Connection release mode: on_close
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 1
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.classic.ClassicQueryTranslatorFactory
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
2013-09-17 21:00:41,890 org.hibernate.cfg.SettingsFactory - Query cache: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Statistics: enabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
2013-09-17 21:00:41,906 org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2013-09-17 21:00:41,921 org.hibernate.impl.SessionFactoryImpl - building session factory
2013-09-17 21:00:41,937 net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/workspace/ZCCL_BatchServer/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2013-09-17 21:00:42,500 org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2013-09-17 21:00:42,578 org.springframework.aop.framework.DefaultAopProxyFactory - CGLIB2 available: proxyTargetClass feature enabled
2013-09-17 21:00:42,640 com.dcits.server.StartServer - Roman-----------systemEnv serverPort-----18171
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - =======管理线程就绪=======
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 线程[1]启动完成
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 服务器忙,增加新线程
2013-09-17 21:00:42,640 com.dcits.server.ListenServer - 线程[2]启动完成
2013-09-17 21:00:42,640 com.dcits.server.AcceptServer - G0_L1_CR:=======正在监听端口[18171]=======
2013-09-17 21:00:42,640 com.dcits.server.AcceptServer - G0_L2_CR:=======正在监听端口[18171]=======
2013-09-17 21:00:42,671 org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2013-09-17 21:00:42,687 org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
Hibernate: select * from ( select this_.JOB_ID as JOB1_15_0_, this_.JOB_NAME as JOB2_15_0_, this_.JOB_CLASS as JOB3_15_0_, this_.JOB_TYPE as JOB4_15_0_, this_.JOB_TRIGGER_STATE as JOB5_15_0_, this_.JOB_CRON_EXPRESSION as JOB6_15_0_, this_.JOB_METHOD as JOB7_15_0_, this_.JOB_GROUP as JOB8_15_0_, this_.JOB_SPRING_BEAN as JOB9_15_0_, this_.JOB_EXE_LAST_TIME as JOB10_15_0_, this_.JOB_EXE_NEXT_TIME as JOB11_15_0_, this_.JOB_START_TIME as JOB12_15_0_, this_.JOB_END_TIME as JOB13_15_0_, this_.JOB_TRIGGER_TYPE as JOB14_15_0_, this_.JOB_PRI as JOB15_15_0_, this_.JOB_TRIGGER_NAME as JOB16_15_0_, this_.JOB_TRIGGER_GROUP as JOB17_15_0_, this_.JOB_EXE_STATE as JOB18_15_0_ from CHQB_JOB this_ ) where rownum <= ?
2013-09-17 21:00:42,859 com.dcits.job.util.JobUtil - Roman--------------jobList's size------5
2013-09-17 21:00:42,859 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 0/3 * * * ?
2013-09-17 21:00:42,921 org.quartz.simpl.SimpleThreadPool - Job execution threads will use class loader of thread: main
2013-09-17 21:00:42,953 org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
2013-09-17 21:00:42,953 org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2013-09-17 21:00:42,953 org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 1.4.2
2013-09-17 21:00:42,968 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 01 11 * * ?
2013-09-17 21:00:42,984 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 00 16 * * ?
2013-09-17 21:00:43,000 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 0/1 * * * ?
2013-09-17 21:00:43,046 com.dcits.job.util.JobUtil - (JobInfo)job's class -----0 50 16 * * ?
2013-09-17 21:00:43,062 org.quartz.core.QuartzScheduler - Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
2013-09-17 21:01:00,015 com.dcits.job.base.BaseJob - ----START------TrpLoadBatchJob----------
2013-09-17 21:01:00,015 com.dcits.job.TrpLoadBatchJob - Tue Sep 17 21:01:00 CST 2013################START RUN TrpLoadBatchJob ##########0

  • 写回答

1条回答 默认 最新

  • ChatGPTᴼᴾᴱᴺᴬᴵ 2023-02-14 13:42
    关注

    该回答引用ChatGPT

    您好,从日志信息来看,似乎没有特别明显的异常和错误信息,但有一些线索可能对您有所帮助。


    根据您提供的日志信息,可以看到 Hibernate 和 Ehcache 在运行时正常启动。另外,您提到的“死锁”的情况可能是由于数据库连接池或者 Quartz 任务调度器的使用不当所导致的。


    首先,您可以检查一下数据库连接池的配置是否正确。dbcp 连接池在高并发情况下会出现连接泄漏的情况,这可能会导致连接数被占满,从而影响数据库的正常运行。您可以检查一下连接池的最大连接数、空闲连接数等配置,以及是否正确关闭了数据库连接。


    其次,您可以检查一下 Quartz 任务调度器的配置是否正确。任务调度器中的任务执行可能会被阻塞,从而导致任务调度器不能正常执行任务。您可以检查一下任务的执行时间和间隔时间是否正确,以及是否存在死循环等情况。


    最后,您可以尝试使用日志级别更高的设置,以便更好地追踪应用程序的运行情况。特别是在 Quartz 任务调度器中,您可以检查一下任务执行的日志信息,看看是否存在阻塞等情况。

    评论

报告相同问题?

悬赏问题

  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B