启动服务Server的时候报错,提示表找不到

shiwf 2023-5-18 632

java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:571) at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204) at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:373) at io.moquette.persistence.DatabaseStore.getSensitiveWord(DatabaseStore.java:3444) at io.moquette.persistence.MemoryMessagesStore.updateSensitiveWord(MemoryMessagesStore.java:560) at io.moquette.persistence.MemoryMessagesStore.initStore(MemoryMessagesStore.java:542) at io.moquette.persistence.MemoryStorageService.initStore(MemoryStorageService.java:51) at io.moquette.server.Server.startServer(Server.java:261) at io.moquette.server.Server.startServer(Server.java:226) at io.moquette.server.Server.startServer(Server.java:210) at io.moquette.server.Server.start(Server.java:120) at cn.wildfirechat.server.Server.main(Server.java:15) Caused by: org.h2.jdbc.JdbcSQLException: Table "T_SENSITIVEWORD" not found; SQL statement: select _word from t_sensitiveword order by id desc [42102-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.command.Parser.readTableOrView(Parser.java:5920) at org.h2.command.Parser.readTableFilter(Parser.java:1430) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2138) at org.h2.command.Parser.parseSelectSimple(Parser.java:2287) at org.h2.command.Parser.parseSelectSub(Parser.java:2133) at org.h2.command.Parser.parseSelectUnion(Parser.java:1946) at org.h2.command.Parser.parseSelect(Parser.java:1919) at org.h2.command.Parser.parsePrepared(Parser.java:463) at org.h2.command.Parser.parse(Parser.java:335) at org.h2.command.Parser.parse(Parser.java:307) at org.h2.command.Parser.prepareCommand(Parser.java:278) at org.h2.engine.Session.prepareLocal(Session.java:611) at org.h2.engine.Session.prepareCommand(Session.java:549) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247) at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:76) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:304) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:547) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

最新回复 (4)
  • HeavyRain 2023-5-18
    引用 2
    IM服务有没有修改过,试试用我们没有修改的版本运行看看有没有这个错误
  • shiwf 2023-5-23
    引用 3
    问题找到了,我在idea上启动的,是这个存放sql脚本路劲migrate/h2识别不到原因
  • Jerry_xuan 1月前
    引用 4
    shiwf 问题找到了,我在idea上启动的,是这个存放sql脚本路劲migrate/h2识别不到原因
    我用的是mysql数据库,他也找不到项目broker/migrate/mysql路径下的sql文件,怎么处理,哪位大神指点下
  • HeavyRain 1月前
    引用 5
    打包后运行
返回