Couldn't retrieve trigger: invalid stream header

最新推荐文章于 2023-10-24 22:16:39 发布

yunxuantu

最新推荐文章于 2023-10-24 22:16:39 发布

阅读量7.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： java杂谈

本文链接：https://blog.youkuaiyun.com/yunxuantu/article/details/85248871

java杂谈专栏收录该内容

38 篇文章

订阅专栏

本文详细解析了定时任务中出现的“流标头无效”错误，指出问题源于数据库表名与代码中表名的大小写不一致，并提供了解决方案，即将数据库表名统一为大写，以确保与代码中表名的一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

定时任务报错：无法检索触发器:流标头无效。

2018-12-25 15:28:50.603 [QuartzScheduler_scheduler-NON_CLUSTERED_MisfireHandler] INFO  org.springframework.scheduling.quartz.LocalDataSourceJobStore - Handling the first 1 triggers that missed their scheduled fire-time.  More misfired triggers remain to be processed.
2018-12-25 15:28:50.603 [QuartzScheduler_scheduler-NON_CLUSTERED_MisfireHandler] ERROR org.springframework.scheduling.quartz.LocalDataSourceJobStore - MisfireHandler: Error handling misfires: Couldn't retrieve trigger: invalid stream header: 5B424032
org.quartz.JobPersistenceException: Couldn't retrieve trigger: invalid stream header: 5B424032
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1533) ~[quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:979) ~[quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3187) ~[quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3935) [quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3956) [quartz-2.2.1.jar:?]
Caused by: java.io.StreamCorruptedException: invalid stream header: 5B424032
	at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:866) ~[?:1.8.0_191]
	at java.io.ObjectInputStream.<init>(ObjectInputStream.java:358) ~[?:1.8.0_191]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3199) ~[quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1780) ~[quartz-2.2.1.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1531) ~[quartz-2.2.1.jar:?]
	... 4 more

原因：定时任务的表名小写，代码与数据库的表名匹配不一致。

方案：将数据库的表与代码的表名一致即可，此处场景，数据库表名大写即可。