跪求解惑!!!

提问 3 519
sgsgsg
sgsgsg 2023-01-10
版本:renren-fast 开发环境:
renren-fast 后端启动一分钟抱错一次connot covert the column of type bytea to requested type lond
回帖
  • 看不出问题了,百度一下吧
    0 回复
  • sgsgsg
    sgsgsg (楼主)
    2023-01-10
    plcation Daree APelicationl CAProgram Fiesavare18. 0. 171binv.e(2023年1月10日 下午7:31:18)Caused by:org.postgresql.util. PSOLExcoption: Cannot convert the column of type BYTEA to requested type long.at org.postgresql.jdbc. PgResultset.readLongValue (PgResultSet.java: 3012)备torg.postgresql.jdbc. PgResultSet.getLong (PgResultset.java: 2032)住0org.postgresql.jdbc. PgResultSet.getBlob (PgResultSet.java: 416)atorg-postgrosq1.jdbc. PgResultSet.getB1cb (PgResultSet.java: 403)老com.alibaba.druid.filter. FilterChainImpl,rosultset_gotBlob (FilterChainImpl.java: 2205)中com.alibaba.druid.filtor. PilterAdapter.rosultset_gotBlob (PiltorAdaptor.java: 1513)com.alibaba.druid.filter. FilterChainImpl.rosultSet_getBlob (FilterChainImpl.java: 2203)at2ecom.alibaba.druid.filter.stat.statFilter.resultBet_getBlob (8tatFiltor.java: 750)atcom.alibaba,druid.filter. FilterChaintmpl,resultBet_getBlob (FilterChainimpl.java: 2203)at com.alibaba.druid.proxy.jdbc. Result8etProxyImpl.getBlob (ResultSetProxyImpl.java: 293)at com.alibaba.druid.pool. DruidpooledRosultset.getBlob (DruidpooledResultset.java: 1170)atorg.quartz.impl.jdbcjobntore.stdJDBCDelegate.getobjectFromBlob (StdJDBCDelegate.java: 3190)at org.quartz.impl.jdbcjobstore. StdJDBCDelegate.selectTrigger (StdJDBCDelegate.java: 1780)at org.quartz.impl.jdbcjobutore. JobstoreSupport.rotrioveTrigger (Jobstoresupport.java: 1536)4 common frames omitted 2023-01-10 21: 35: 06. 7882023-01-10 21: 35: 21. 8902023-01-10 21: 35: 36. 9902023-01-10 21: 35: 52. 0932023-01-10 21: 35: 52. 134ERRORoxq-quartz. JobPersistenceException: couldn't rotriove triggor: Cannot convert the column of typo BYiSR to requested type long.at org.quartz.impl.jdbcjobstore. JobstoreSupport.retriovoTrigger (JobStoreSupport.java: 1538)at org.quartz.impl.jdbejobstore. JobStoreSupport.recoverMisfiredJobs (Jobstoresupport.java: 984)at org.quartz.impl.jdbcjobstore. JobstoreSupport.doRecoverMisfires (Jobstoresupport.java: 3249)at org.quartz.impl.jdbcjobstore. JobstoreSupportSMistiroHandlor,manage (JobStoreSupport.java: 3997)at org.quartz.impl.jdbcjobstore. JobstoreSupportSMisfireHandler.run (Jobstoresupport.java: 4018)Caused by:org.postgresql.util. PSOLException: Cannot convert the column of typo BYTEA to requested type long.at org-postgresql.jdbc. PgResultSet.readLongValue (PgResultset.java: 3012)atorg-postgresql.jdbc. PgRosultet.getLong (gRosultset.java: 2032)atorg.postgresql.jdbc. PgResultset.gotBlob (PgResultset.java: 416)org-postgresql.jdbc. PgRosultSet.getBlob (PgResultBot.java: 403)at com.alibaba.druid.filter.pilterchainImpl.resultset_getBlob (PilterChainImpl.java: 2205)com.alibaba.druid.filter. FilterAdaptor.resultSet_gotBlob (FiltorAdapter.java: 1513)INPOINPO 8084---INFO 8084---INFO 8084- [MinfiroHandler] o. .w.quartz. LocalDatalourceJobatore8084---[_MisfireHandler) o.s.s.quartz. LocalDatasourceJobstore[_MisfiroHandler] o.s.s.quartz.LocalDatasourceJobstoreLHisfireHandler] o.s.s.quartz. LocalDataBourcoJobStore[_MisfireHandler] o.s.s.quaxtz. LocalDataSourceJobStore8084---:Bandling 1 trigger (s) that mi:Handling 1 triggor (n) that mi:Handling 1 trigger (a) that mi:Handling 1 trigger (s) that mi:\isfireHandler: Error handlin
    0 回复
  • sgsgsg
    sgsgsg (楼主)
    2023-01-10
    @Mark 是不是需要把表字段bytea都改掉啊?
    0 回复