Skywalking 10.0.0 cant revice the metirc data, it produced events releated tables cant be found.

[liuvlun]

Please dont delete this issue, i am very urgent to know why and how to resolve it. thank you.
Deployment OS: Centos7
Deployment user: root
Error detail:
2024-06-26 22:33:41,406 - org.apache.skywalking.oap.server.storage.plugin.jdbc.common.dao.JDBCBatchDAO - 81 [pool-5-thread-1] ERROR [] - Table "events_20240621" not found; SQL statement: INSERT INTO events_20240621(id,table_name,uuid,service,service_instance,endpoint,name,type,message,parameters,start_time,end_time,layer,time_bucket) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) [42102-212] org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "events_20240621" not found; SQL statement: INSERT INTO events_20240621(id,table_name,uuid,service,service_instance,endpoint,name,type,message,parameters,start_time,end_time,layer,time_bucket) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) [42102-212] at org.h2.message.DbException.getJdbcSQLException(DbException.java:502) ~[h2-2.1.212.jar:2.1.212] at org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[h2-2.1.212.jar:2.1.212] at org.h2.message.DbException.get(DbException.java:223) ~[h2-2.1.212.jar:2.1.212] at org.h2.message.DbException.get(DbException.java:199) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8376) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8347) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.readTableOrView(Parser.java:8336) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.readTableOrView(Parser.java:8306) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.parseInsert(Parser.java:1641) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.parsePrepared(Parser.java:814) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.parse(Parser.java:691) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.parse(Parser.java:661) ~[h2-2.1.212.jar:2.1.212] at org.h2.command.Parser.prepareCommand(Parser.java:568) ~[h2-2.1.212.jar:2.1.212] at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631) ~[h2-2.1.212.jar:2.1.212] at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554) ~[h2-2.1.212.jar:2.1.212] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) ~[h2-2.1.212.jar:2.1.212] at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) ~[h2-2.1.212.jar:2.1.212] at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288) ~[h2-2.1.212.jar:2.1.212] at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:318) ~[HikariCP-3.1.0.jar:?] at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) ~[HikariCP-3.1.0.jar:?] at org.apache.skywalking.oap.server.storage.plugin.jdbc.BatchSQLExecutor.invoke(BatchSQLExecutor.java:54) ~[storage-jdbc-hikaricp-plugin-10.0.0.jar:10.0.0] at org.apache.skywalking.oap.server.storage.plugin.jdbc.common.dao.JDBCBatchDAO.lambda$flush$1(JDBCBatchDAO.java:78) ~[storage-jdbc-hikaricp-plugin-10.0.0.jar:10.0.0] at java.util.HashMap.forEach(HashMap.java:1337) ~[?:?] at org.apache.skywalking.oap.server.storage.plugin.jdbc.common.dao.JDBCBatchDAO.flush(JDBCBatchDAO.java:75) ~[storage-jdbc-hikaricp-plugin-10.0.0.jar:10.0.0] at org.apache.skywalking.oap.server.core.storage.PersistenceTimer.lambda$extractDataAndSave$3(PersistenceTimer.java:135) ~[server-core-10.0.0.jar:10.0.0] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1736) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?]

[wu-sheng]

Mentioned here, #12382 (reply in thread)