Caused by: org.quartz.JobPersistenceException: Couldn‘t obtain triggers for job: 不良的类型值 long : \x

港控/mmm° 2023-09-25 14:03 3阅读 0赞

#### 一、quartz切换成postgres启动报错信息 ####

Caused by: org.quartz.JobPersistenceException: Couldn’t obtain triggers for job: 不良的类型值 long : \\x  
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:2190)  
at org.quartz.impl.jdbcjobstore.JobStoreSupport 31. e x e c u t e V o i d ( J o b S t o r e S u p p o r t . j a v a : 2257 ) a t o r g . q u a r t z . i m p l . j d b c j o b s t o r e . J o b S t o r e S u p p o r t 31.executeVoid(JobStoreSupport.java:2257) at org.quartz.impl.jdbcjobstore.JobStoreSupport 31.executeVoid(JobStoreSupport.java:2257)atorg.quartz.impl.jdbcjobstore.JobStoreSupportVoidTransactionCallback.execute(JobStoreSupport.java:3780)  
at org.quartz.impl.jdbcjobstore.JobStoreSupport V o i d T r a n s a c t i o n C a l l b a c k . e x e c u t e ( J o b S t o r e S u p p o r t . j a v a : 3778 ) a t o r g . q u a r t z . i m p l . j d b c j o b s t o r e . J o b S t o r e C M T . e x e c u t e I n L o c k ( J o b S t o r e C M T . j a v a : 245 ) a t o r g . q u a r t z . i m p l . j d b c j o b s t o r e . J o b S t o r e S u p p o r t . p a u s e J o b ( J o b S t o r e S u p p o r t . j a v a : 2253 ) a t o r g . q u a r t z . c o r e . Q u a r t z S c h e d u l e r . p a u s e J o b ( Q u a r t z S c h e d u l e r . j a v a : 1242 ) a t o r g . q u a r t z . i m p l . S t d S c h e d u l e r . p a u s e J o b ( S t d S c h e d u l e r . j a v a : 370 ) a t c o m . h u i m a y u n . j o b . u t i l . S c h e d u l e U t i l s . c r e a t e S c h e d u l e J o b ( S c h e d u l e U t i l s . j a v a : 96 ) a t c o m . h u i m a y u n . j o b . s e r v i c e . S y s J o b S e r v i c e I m p l . i n i t ( S y s J o b S e r v i c e I m p l . j a v a : 46 ) a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 ( N a t i v e M e t h o d ) a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e ( U n k n o w n S o u r c e ) a t s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e ( U n k n o w n S o u r c e ) a t j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e ( U n k n o w n S o u r c e ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . a n n o t a t i o n . I n i t D e s t r o y A n n o t a t i o n B e a n P o s t P r o c e s s o r VoidTransactionCallback.execute(JobStoreSupport.java:3778) at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245) at org.quartz.impl.jdbcjobstore.JobStoreSupport.pauseJob(JobStoreSupport.java:2253) at org.quartz.core.QuartzScheduler.pauseJob(QuartzScheduler.java:1242) at org.quartz.impl.StdScheduler.pauseJob(StdScheduler.java:370) at com.huimayun.job.util.ScheduleUtils.createScheduleJob(ScheduleUtils.java:96) at com.huimayun.job.service.SysJobServiceImpl.init(SysJobServiceImpl.java:46) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor VoidTransactionCallback.execute(JobStoreSupport.java:3778)atorg.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)atorg.quartz.impl.jdbcjobstore.JobStoreSupport.pauseJob(JobStoreSupport.java:2253)atorg.quartz.core.QuartzScheduler.pauseJob(QuartzScheduler.java:1242)atorg.quartz.impl.StdScheduler.pauseJob(StdScheduler.java:370)atcom.huimayun.job.util.ScheduleUtils.createScheduleJob(ScheduleUtils.java:96)atcom.huimayun.job.service.SysJobServiceImpl.init(SysJobServiceImpl.java:46)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)atjava.lang.reflect.Method.invoke(UnknownSource)atorg.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessorLifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)  
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)  
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)  
… 37 common frames omitted  
Caused by: org.postgresql.util.PSQLException: 不良的类型值 long : \\x  
at org.postgresql.jdbc.PgResultSet.toLong(PgResultSet.java:3241)  
at org.postgresql.jdbc.PgResultSet.getLong(PgResultSet.java:2424)  
at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:466)  
at org.postgresql.jdbc.PgResultSet.getBlob(PgResultSet.java:452)  
at com.alibaba.druid.pool.DruidPooledResultSet.getBlob(DruidPooledResultSet.java:1157)  
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3190)  
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1780)  
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggersForJob(StdJDBCDelegate.java:1704)  
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:2187)  
… 53 common frames omitted

#### 二、解决方法 ####

##### 1、找到你项目中的配置文件新增加以下配置项目 #####

prop.put("org.quartz.jobStore.driverDelegateClass", "org.quartz.impl.jdbcjobstore.PostgreSQLDelegate");
    ```![在这里插入图片描述](https://img-blog.csdnimg.cn/47f33feb4c374f00b655c01702a303f3.png)
    
    
    #### 2、问题完美解决
    ![在这里插入图片描述](https://img-blog.csdnimg.cn/a237326fa33144fc88c9edef4ece4b9b.png)