Caused by: org.quartz.JobPersistenceException: Couldn‘t obtain triggers for job: 不良的类型值 long : \x
Caused by: org.quartz.JobPersistenceException: Couldn’t obtain triggers for job: 不良的类型值 long : \x。Caused by: org.postgresql.util.PSQLException: 不良的类型值 long : \x。
一、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)
更多推荐
所有评论(0)