系统版本由8.2.2升级到9.1.3，启动报错

cs888

我按照这个教程把系统版本由8.2.2升级到9.1.3

https://www.o2oa.net/cms/serverdeployment/110.html
启动后报这个错，请问是什么原因，如何解决？

2024-09-03 17:35:02.017 [ContextQuartzScheduler-x_query_service_processing_Worke
r-2] ERROR com.x.base.core.project.schedule.AbstractJob - id:b0a65b17-f956-41d5-
a75e-2a6b132c560f, name:com.x.base.core.project.schedule.AbstractJob, message:Ta
ble 'x.qry_idx_state' doesn't exist {prepstmnt 1684486868 SELECT t0.xid, t0.xcre
ateTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlates
tUpdateTime, t0.xmode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t
0 WHERE (t0.xtype = ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER
BY t0.xupdateTime ASC LIMIT ?, ?} [code=1146, state=42S02], exceptionrg.apache
.openjpa.persistence.PersistenceException.
org.apache.openjpa.persistence.PersistenceException: Table 'x.qry_idx_state' doe
sn't exist {prepstmnt 1684486868 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0
.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.xmode, t0
.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtype = ? AND
t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTime ASC LIM
IT ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:532
6) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:134) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:115) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:67) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheck
edException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handl
eCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:42) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[o
penjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[op
enjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.jav
a:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java
:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.query.service.processing.factory.StateFactory.getState(StateFac
tory.java:44) ~[classes/:?]
        at com.x.query.service.processing.schedule.HighFreqDocument.schedule(Hig
hFreqDocument.java:46) ~[classes/:?]
        at com.x.base.core.project.schedule.AbstractJob.execute(AbstractJob.java
:25) ~[x_base_core_project.jar:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.
jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:573) ~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'x.qry_idx_s
tate' doesn't exist {prepstmnt 1684486868 SELECT t0.xid, t0.xcreateTime, t0.xseq
uence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.
xmode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtyp
e = ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTim
e ASC LIMIT ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(Log
gingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStateme
nt.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:5
31) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(Select
ResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(
QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:36) ~[openjpa-3.2.2.jar:3.2.2]
        ... 12 more
2024-09-03 17:35:02.026 [ContextQuartzScheduler-x_query_service_processing_Worke
r-1] ERROR com.x.base.core.project.schedule.AbstractJob - id:d8fe59fc-233b-434b-
9211-d8713a227eb1, name:com.x.base.core.project.schedule.AbstractJob, message:Ta
ble 'x.qry_idx_state' doesn't exist {prepstmnt 170418243 SELECT t0.xid, t0.xcrea
teTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatest
UpdateTime, t0.xmode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0
WHERE (t0.xtype = ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER B
Y t0.xupdateTime ASC LIMIT ?, ?} [code=1146, state=42S02], exceptionrg.apache.
openjpa.persistence.PersistenceException.
org.apache.openjpa.persistence.PersistenceException: Table 'x.qry_idx_state' doe
sn't exist {prepstmnt 170418243 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.
xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.xmode, t0.
xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtype = ? AND
t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTime ASC LIMI
T ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:532
6) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:134) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:115) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:67) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheck
edException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handl
eCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:42) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[o
penjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[op
enjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.jav
a:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java
:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.query.service.processing.factory.StateFactory.getState(StateFac
tory.java:44) ~[classes/:?]
        at com.x.query.service.processing.schedule.HighFreqWorkCompleted.schedul
e(HighFreqWorkCompleted.java:51) ~[classes/:?]
        at com.x.base.core.project.schedule.AbstractJob.execute(AbstractJob.java
:25) ~[x_base_core_project.jar:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.
jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:573) ~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'x.qry_idx_s
tate' doesn't exist {prepstmnt 170418243 SELECT t0.xid, t0.xcreateTime, t0.xsequ
ence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.x
mode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtype
= ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTime
ASC LIMIT ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(Log
gingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStateme
nt.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:5
31) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(Select
ResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(
QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:36) ~[openjpa-3.2.2.jar:3.2.2]
        ... 12 more
2024-09-03 17:36:02.015 [ContextQuartzScheduler-x_query_service_processing_Worke
r-2] ERROR com.x.base.core.project.schedule.AbstractJob - id:34842bc3-4f1c-4ea7-
a843-2404ff613565, name:com.x.base.core.project.schedule.AbstractJob, message:Ta
ble 'x.qry_idx_state' doesn't exist {prepstmnt 994929995 SELECT t0.xid, t0.xcrea
teTime, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatest
UpdateTime, t0.xmode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0
WHERE (t0.xtype = ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER B
Y t0.xupdateTime ASC LIMIT ?, ?} [code=1146, state=42S02], exceptionrg.apache.
openjpa.persistence.PersistenceException.
org.apache.openjpa.persistence.PersistenceException: Table 'x.qry_idx_state' doe
sn't exist {prepstmnt 994929995 SELECT t0.xid, t0.xcreateTime, t0.xsequence, t0.
xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.xmode, t0.
xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtype = ? AND
t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTime ASC LIMI
T ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:532
6) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:134) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:115) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:67) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheck
edException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handl
eCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:42) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[o
penjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[op
enjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.jav
a:601) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java
:314) ~[openjpa-3.2.2.jar:3.2.2]
        at com.x.query.service.processing.factory.StateFactory.getState(StateFac
tory.java:44) ~[classes/:?]
        at com.x.query.service.processing.schedule.HighFreqWork.schedule(HighFre
qWork.java:50) ~[classes/:?]
        at com.x.base.core.project.schedule.AbstractJob.execute(AbstractJob.java
:25) ~[x_base_core_project.jar:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.
jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:573) ~[quartz-2.3.1.jar:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'x.qry_idx_s
tate' doesn't exist {prepstmnt 994929995 SELECT t0.xid, t0.xcreateTime, t0.xsequ
ence, t0.xupdateTime, t0.xdistributeFactor, t0.xfreq, t0.xlatestUpdateTime, t0.x
mode, t0.xnode, t0.xproperties, t0.xtype FROM X.QRY_IDX_STATE t0 WHERE (t0.xtype
= ? AND t0.xfreq = ? AND t0.xmode = ? AND t0.xnode = ?) ORDER BY t0.xupdateTime
ASC LIMIT ?, ?} [code=1146, state=42S02]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(Log
gingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStateme
nt.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:5
31) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:413) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(Select
ResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(
QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:36) ~[openjpa-3.2.2.jar:3.2.2]
        ... 12 more

论坛管理员

您是什么数据库，升级时的日志发出来看看

lansexuehu

您这个升级的问题解决了吗？