NutzCN Logo
问答 改造quartz为集群模式并使用nutDao遇到的问题
发布于 130天前 作者 Wizzercn 329 次浏览 复制 上一个帖子 下一个帖子
标签: nutzwk

写了ConnectionProvider 类,改了quartz配置文件,添加数据源配置,然并卵。。

@IocBean
public class NutConnectionProvider implements ConnectionProvider {
    @Inject
    private Dao dao;

    @Override
    public Connection getConnection() throws SQLException {
        return ((NutDao) dao).getDataSource().getConnection();
    }

    @Override
    public void initialize() throws SQLException {

    }

    @Override
    public void shutdown() throws SQLException {

    }

}

日志:::

2017-03-18 21:26:58,198 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'quartzManager'<interface org.nutz.integration.quartz.QuartzManager>
2017-03-18 21:26:58,198 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=quartzManager
2017-03-18 21:26:58,199 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=quartzManager
2017-03-18 21:26:58,200 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(quartzManager) in QuartzIocLoader@271407569
2017-03-18 21:26:58,200 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'quartzManager'<interface org.nutz.integration.quartz.QuartzManager>
2017-03-18 21:26:58,200 cn.wizzer.app.web.commons.plugin.PluginAopConfigure.getInterceptorPairList(PluginAopConfigure.java:33) DEBUG - skip -- org.nutz.integration.quartz.QuartzManagerImpl
2017-03-18 21:26:58,203 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.integration.quartz.QuartzManagerImpl without AOP
2017-03-18 21:26:58,204 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'quartzManager' to [app] 
2017-03-18 21:26:58,204 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'scheduler'<>
2017-03-18 21:26:58,204 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=scheduler
2017-03-18 21:26:58,204 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=scheduler
2017-03-18 21:26:58,205 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(scheduler) in QuartzIocLoader@271407569
2017-03-18 21:26:58,205 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'scheduler'<>
2017-03-18 21:26:58,205 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'scheduler' to [app] 
2017-03-18 21:26:58,245 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1172) INFO  - Using default implementation for ThreadExecutor
2017-03-18 21:26:58,248 org.quartz.simpl.SimpleThreadPool.initialize(SimpleThreadPool.java:268) INFO  - Job execution threads will use class loader of thread: Scanner-1
2017-03-18 21:26:58,261 org.quartz.core.SchedulerSignalerImpl.<init>(SchedulerSignalerImpl.java:61) INFO  - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
2017-03-18 21:26:58,261 org.quartz.core.QuartzScheduler.<init>(QuartzScheduler.java:240) INFO  - Quartz Scheduler v.2.2.3 created.
2017-03-18 21:26:58,262 org.quartz.simpl.RAMJobStore.initialize(RAMJobStore.java:155) INFO  - RAMJobStore initialized.
2017-03-18 21:26:58,263 org.quartz.core.QuartzScheduler.initialize(QuartzScheduler.java:305) INFO  - Scheduler meta-data: Quartz Scheduler (v2.2.3) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

2017-03-18 21:26:58,263 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1327) INFO  - Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
2017-03-18 21:26:58,263 org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1331) INFO  - Quartz scheduler version: 2.2.3
2017-03-18 21:26:58,263 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'jobFactory'<>
2017-03-18 21:26:58,263 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - 	 >> Load definition name=jobFactory
2017-03-18 21:26:58,263 org.nutz.ioc.loader.map.MapLoader.load(MapLoader.java:67) DEBUG - Loading define for name=jobFactory
2017-03-18 21:26:58,264 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:161) DEBUG - Found IocObject(jobFactory) in QuartzIocLoader@271407569
2017-03-18 21:26:58,264 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - 	 >> Make...'jobFactory'<>
2017-03-18 21:26:58,264 cn.wizzer.app.web.commons.plugin.PluginAopConfigure.getInterceptorPairList(PluginAopConfigure.java:33) DEBUG - skip -- org.nutz.integration.quartz.NutQuartzJobFactory
2017-03-18 21:26:58,264 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class org.nutz.integration.quartz.NutQuartzJobFactory without AOP
2017-03-18 21:26:58,264 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'jobFactory' to [app] 
2017-03-18 21:26:58,265 org.quartz.core.QuartzScheduler.setJobFactory(QuartzScheduler.java:2311) INFO  - JobFactory set to: org.nutz.integration.quartz.NutQuartzJobFactory@5506c724
2017-03-18 21:26:58,265 org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:575) INFO  - Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.

配置文件::::

#==============================================================    
#Configure Main Scheduler Properties    
#==============================================================     
org.quartz.scheduler.instanceName = defaultScheduler  
org.quartz.scheduler.instanceId = AUTO  

#==============================================================    
#Configure JobStore     isClustered=启用集群模式
#==============================================================   
org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX  
orgorg.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate \
org.quartz.jobStore.dataSource=myDS 
org.quartz.jobStore.tablePrefix = SYS_QRTZ_  
org.quartz.jobStore.isClustered = true  
org.quartz.jobStore.clusterCheckinInterval = 20000    
org.quartz.jobStore.maxMisfiresToHandleAtATime = 120  
org.quartz.jobStore.misfireThreshold = 120000  
org.quartz.jobStore.txIsolationLevelSerializable = true  

#==============================================================    
#Configure ThreadPool    
#==============================================================   
org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool  
org.quartz.threadPool.threadCount = 2  
org.quartz.threadPool.threadPriority = 5  
org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true  

#==============================================================  
#Skip Check Update  
#update:true  
#not update:false  
#==============================================================  
org.quartz.scheduler.skipUpdateCheck = true   

#============================================================================     
# Configure Plugins      
#============================================================================        
org.quartz.plugin.triggHistory.class = org.quartz.plugins.history.LoggingJobHistoryPlugin     
org.quartz.plugin.shutdownhook.class = org.quartz.plugins.management.ShutdownHookPlugin  
org.quartz.plugin.shutdownhook.cleanShutdown = true  

org.quartz.dataSource.myDS.connectionProvider.class = cn.wizzer.app.web.commons.quartz.NutConnectionProvider
22 回复

结贴 放错地方了。。。

突然报错了!!

ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3261)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3874)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3911)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
        at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
        ... 4 more

怎么会关闭呢?

 dataSource already closed at 

得看这个时间点的日志

dataSource already closed at Thu Apr 27 18:13:39 CST 2017

是mysql的日志 还是项目的日志呢?

job类里面能这样用吗?
插入成功 600条

/**
 */
@IocBean
public class ListQiniuFilesInfoJob implements Job {

    private static final Log log = Logs.get();
    @Inject
    protected  Dao dao;
    
    @Inject
    private  QiniuFileUploadService qiniuFileUploadService;
    
    @Inject
    protected RedisService redisService;
    
    public void execute(JobExecutionContext context) throws JobExecutionException {
        String taskId = context.getJobDetail().getKey().getName();
    	String marker = "";
        List<Record> query = dao.query("sys_files", Cnd.where("marker","<>","").andNot("marker", "is", null).limit(1, 1).desc("opAt"));
		if(query!=null && query.size()>=1){
			 marker = query.get(0).getString("marker");
		}
		List<Sys_files> listfilesToDB = qiniuFileUploadService.listfilesByMarker(marker);
		log.info("marker==="+marker+"-----listfilesToDB-----"+listfilesToDB.size());
		for (int i = 0; i < listfilesToDB.size(); i++) {
			Sys_files file = dao.fetch(Sys_files.class, listfilesToDB.get(i).getId());
			if(file == null){
				dao.insert(listfilesToDB.get(i),FieldFilter.create(Sys_files.class, FieldMatcher.create(true)));
			}
		}
	    dao.update(Sys_task.class, Chain.make("exeAt", (int) (System.currentTimeMillis() / 1000)).add("exeResult", "执行成功"), Cnd.where("id", "=", taskId));
	 
    }
     
}

说好的日志呢?

Job 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda execution complete at  11:13:30 04/28/2017 and reports: null
2017-04-28 11:13:30,350 org.quartz.core.ErrorLogger.schedulerError(QuartzScheduler.java:2425) ERROR - An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@2d86e904
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
        at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
        ... 7 more
An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@2d86e904
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
        at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
        ... 7 more
工作认证定时任务--------------------------
2017-04-28 11:13:30,090 cn.wizzer.common.quartz.job.AuthWorkQueryCompByEmailJob.execute(AuthWorkQueryCompByEmailJob.java:45) INFO  - 工作认证定时任务:[]
工作认证定时任务:[]
2017-04-28 11:13:30,094 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa execution complete at  11:13:30 04/28/2017 and reports: null
Job 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa execution complete at  11:13:30 04/28/2017 and reports: null
2017-04-28 11:13:30,126 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815 fired (by trigger abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815) at:  11:13:30 04/28/2017
Job abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815 fired (by trigger abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815) at:  11:13:30 04/28/2017
2017-04-28 11:13:30,128 cn.wizzer.common.quartz.job.SendSMSJob.execute(SendSMSJob.java:48) INFO  - 短信定时发送启动[]
短信定时发送启动[]
2017-04-28 11:13:30,132 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815 execution complete at  11:13:30 04/28/2017 and reports: null
Job abc49c0c897d4d678eb8d5ca32cfa815.abc49c0c897d4d678eb8d5ca32cfa815 execution complete at  11:13:30 04/28/2017 and reports: null
2017-04-28 11:13:30,165 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652 fired (by trigger baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652) at:  11:13:30 04/28/2017
Job baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652 fired (by trigger baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652) at:  11:13:30 04/28/2017
2017-04-28 11:13:30,176 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652 execution complete at  11:13:30 04/28/2017 and reports: null
Job baaf3528b91442d8b3a52c763af67652.baaf3528b91442d8b3a52c763af67652 execution complete at  11:13:30 04/28/2017 and reports: null
2017-04-28 11:13:30,270 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda execution complete at  11:13:30 04/28/2017 and reports: null
Job 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda execution complete at  11:13:30 04/28/2017 and reports: null
2017-04-28 11:13:30,350 org.quartz.core.ErrorLogger.schedulerError(QuartzScheduler.java:2425) ERROR - An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@2d86e904
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
	at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
	at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
	at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
	... 7 more
An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@2d86e904
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
	at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
	at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
	at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
	... 7 more
2017-04-28 11:13:33,007 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1 fired (by trigger 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1) at:  11:13:33 04/28/2017
Job 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1 fired (by trigger 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1) at:  11:13:33 04/28/2017
2017-04-28 11:13:33,009 cn.wizzer.common.quartz.job.SendEmailJob.execute(SendEmailJob.java:56) INFO  - 邮件定时发送启动[]
邮件定时发送启动[]
2017-04-28 11:13:33,011 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1 execution complete at  11:13:33 04/28/2017 and reports: null
Job 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1 execution complete at  11:13:33 04/28/2017 and reports: null
2017-04-28 11:13:33,120 org.quartz.core.ErrorLogger.schedulerError(QuartzScheduler.java:2425) ERROR - An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@357e6940
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
	at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
	at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
	at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
	... 7 more
An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@357e6940
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
	at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
	at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
	at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
	at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
	at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
	at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
	at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
	... 7 more
2017-04-28 11:13:35,011 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7 fired (by trigger 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7) at:  11:13:35 04/28/2017
Job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7 fired (by trigger 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7) at:  11:13:35 04/28/2017
2017-04-28 11:13:35,016 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) INFO  - Job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7 execution complete at  11:13:35 04/28/2017 and reports: null
Job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7 execution complete at  11:13:35 04/28/2017 and reports: null
2017-04-28 11:13:35,027 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda fired (by trigger 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda) at:  11:13:35 04/28/2017
Job 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda fired (by trigger 3fcb43f8ec524b37a5eb1a149fd03cda.3fcb43f8ec524b37a5eb1a149fd03cda) at:  11:13:35 04/28/2017
2017-04-28 11:13:35,041 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) INFO  - Job 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa fired (by trigger 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa) at:  11:13:35 04/28/2017
Job 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa fired (by trigger 58830ca871774543aaf2fc17318af2aa.58830ca871774543aaf2fc17318af2aa) at:  11:13:35 04/28/2017
2017-04-28 11:13:35,042 cn.wizzer.common.quartz.job.AuthWorkQueryCompByEmailJob.execute(AuthWorkQueryCompByEmailJob.java:40) INFO  - 工作认证定时任务--------------------------
工作认证定时任务--------------------------
2017-04-28 11:13:35,045 cn.wizzer.common.quartz.job.AuthWorkQueryCompByEmailJob.execute(AuthWorkQueryCompByEmailJob.java:45) INFO  - 工作认证定时任务:[]
工作认证定时任务:[]

.. 你把debug日志禁掉了?所以那几秒发生的事情没记录。。。

[DEBUG] 12:03:33.028 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - UPDATE sys_task SET exeAt=?,exeResult=?  WHERE id=?
    |          1 |    2 |                                3 |
    |------------|------|----------------------------------|
    | 1493352213 | 执行成功 | 1c589f88ddc64cb4b9d66c9acb611bb1 |
  For example:> "UPDATE sys_task SET exeAt=1493352213,exeResult='执行成功'  WHERE id='1c589f88ddc64cb4b9d66c9acb611bb1'"
[INFO ] 12:03:33.032 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobWasExecuted(LoggingJobHistoryPlugin.java:513) - Job 1c589f88ddc64cb4b9d66c9acb611bb1.1c589f88ddc64cb4b9d66c9acb611bb1 execution complete at  12:03:33 04/28/2017 and reports: null
[DEBUG] 12:03:33.034 org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:107) - Lock 'TRIGGER_ACCESS' is desired by: defaultScheduler_Worker-1
[DEBUG] 12:03:33.034 org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:92) - Lock 'TRIGGER_ACCESS' is being obtained: defaultScheduler_Worker-1
[DEBUG] 12:03:33.035 org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:116) - Lock 'TRIGGER_ACCESS' given to: defaultScheduler_Worker-1
[DEBUG] 12:03:33.037 org.quartz.impl.jdbcjobstore.DBSemaphore.releaseLock(DBSemaphore.java:141) - Lock 'TRIGGER_ACCESS' returned by: defaultScheduler_Worker-1
2017-04-28 12:03:34,244 org.quartz.core.ErrorLogger.schedulerError(QuartzScheduler.java:2425) ERROR - An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@357e6940
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
        at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
        ... 7 more
An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@357e6940
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3793)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.retryExecuteInNonManagedTXLock(JobStoreSupport.java:3758)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:3055)
        at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1804)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:269)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
        at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1110)
        at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1014)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4544)
        at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:662)
        at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4540)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:992)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:984)
        at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:103)
        at org.nutz.integration.quartz.NutConnectionProvider.getConnection(NutConnectionProvider.java:18)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
        ... 7 more
[DEBUG] 12:03:35.001 org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:107) - Lock 'TRIGGER_ACCESS' is desired by: defaultScheduler_QuartzSchedulerThread
[DEBUG] 12:03:35.002 org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:92) - Lock 'TRIGGER_ACCESS' is being obtained: defaultScheduler_QuartzSchedulerThread
[DEBUG] 12:03:35.004 org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:116) - Lock 'TRIGGER_ACCESS' given to: defaultScheduler_QuartzSchedulerThread
[DEBUG] 12:03:35.030 org.quartz.impl.jdbcjobstore.DBSemaphore.releaseLock(DBSemaphore.java:141) - Lock 'TRIGGER_ACCESS' returned by: defaultScheduler_QuartzSchedulerThread
[DEBUG] 12:03:35.031 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) - Get 'qiniuVideoFileUpdateJob'<class cn.wizzer.common.quartz.job.QiniuVideoFileUpdateJob>
[INFO ] 12:03:35.032 org.quartz.plugins.history.LoggingJobHistoryPlugin.jobToBeExecuted(LoggingJobHistoryPlugin.java:469) - Job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7 fired (by trigger 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7) at:  12:03:35 04/28/2017
[DEBUG] 12:03:35.032 org.quartz.core.JobRunShell.run(JobRunShell.java:201) - Calling execute on job 2339f92ec6364fd1b0bc8b08a248fec7.2339f92ec6364fd1b0bc8b08a248fec7
[DEBUG] 12:03:35.032 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - SELECT * FROM sys_files  WHERE mimeType LIKE ? AND duration IS NULL

数据源昨晚6点就关了

我重新启动项目还是报错这个错 是不是要把什么数据清空下?

ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]

@wendal 进程杀掉 mvn jetty run

数据库连接sql客户端是没有问题的。数据库是阿里云rds

来自炫酷的 NutzCN

把日志清空

清空了 quart集群相关表的数据 然后启动还是有

org.quartz.core.ErrorLogger.schedulerError(QuartzScheduler.java:2425) ERROR - An error occurred while org.quartz.impl.jdbcjobstore.JobStoreSupport$45@2d86e904
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017 [See nested exception: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Apr 27 18:13:39 CST 2017]

测试了下localhost 一点毛病都没有

进程就没关吧

这就坑了 我用lsof -i:8080 和 lsof -i:8087 然后kill -9 pid

但是我用ps ef | grep java 居然还有一个java 进程 杀掉重启。正常了!!!

添加回复
请先登陆
回到顶部