You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "MyHeart0 (via GitHub)" <gi...@apache.org> on 2025/05/21 03:53:06 UTC
[I] Project stop reporting error [shardingsphere]
MyHeart0 opened a new issue, #35478:
URL: https://github.com/apache/shardingsphere/issues/35478
javaproject
The introduced dependencies are：
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc</artifactId>
<version>5.5.1</version>
</dependency>
The default metadata storage has been configured as mysql :
Properties props2 = new Properties();
props2.setProperty("jdbcUrl", "jdbc:mysql://xx.xx.xx.xx:xx/user");
props2.setProperty("username", "root");
props2.setProperty("password", "root.");
ModeConfiguration modeConfiguration =
new ModeConfiguration("Standalone", new StandalonePersistRepositoryConfiguration("JDBC", props2));
Error reported when the project is stopped：
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement:
DELETE FROM `repository` WHERE `key` LIKE ? [42102-200]
May I ask why there is an error message regarding the H2 database
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-2937657383
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-3153820141
> This issue still occurs in version 5.5.2.
You obviously need to open a new issue and provide your unit tests. In the master branch `5.5.3-SNAPSHOT`, JDBC mode has become an optional module.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "lly-ke (via GitHub)" <gi...@apache.org>.
lly-ke commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-3153837688
<img width="1585" height="964" alt="Image" src="https://github.com/user-attachments/assets/ee02fd1f-f044-4260-b969-6d1665502154" />
[2025-08-05 15:27:16.166] [ERROR] [TID: N/A] [SpringApplicationShutdownHook] [org.apache.shardingsphere.mode.repository.standalone.jdbc.JDBCRepository] - Delete JDBC data by key: /nodes/compute_nodes/online/jdbc/8a27dc9e-6d56-4f3f-9416-c7be522109ed failed
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement:
DELETE FROM `repository` WHERE `key` LIKE ? [42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableOrView(Parser.java:7599)
at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1350)
at org.h2.command.Parser.parseDelete(Parser.java:1377)
at org.h2.command.Parser.parsePrepared(Parser.java:914)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.apache.shardingsphere.mode.repository.standalone.jdbc.JDBCRepository.delete(JDBCRepository.java:218)
at org.apache.shardingsphere.mode.persist.service.unified.ComputeNodePersistService.offline(ComputeNodePersistService.java:76)
at org.apache.shardingsphere.mode.persist.PersistServiceFacade.close(PersistServiceFacade.java:75)
at org.apache.shardingsphere.mode.manager.ContextManager.close(ContextManager.java:193)
at org.apache.shardingsphere.driver.jdbc.core.datasource.ShardingSphereDataSource.close(ShardingSphereDataSource.java:107)
at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:239)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:587)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:559)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingleton(DefaultListableBeanFactory.java:1163)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:520)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingletons(DefaultListableBeanFactory.java:1156)
at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1106)
at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1075)
at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1021)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-2912294508
- I guess there are some edge cases involved here, because the unit tests of the relevant classes cannot use testcontainers-java and just mock some results normally.
- Could you provide a git containing the unit tests for testcontainers-java ? I'd like to know the specific mysql version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "lly-ke (via GitHub)" <gi...@apache.org>.
lly-ke commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-3170413476
> > This issue still occurs in version 5.5.2.
>
> You obviously need to open a new issue and provide your unit tests. In the master branch `5.5.3-SNAPSHOT`, JDBC mode has become an optional module.
https://github.com/apache/shardingsphere/issues/36223
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian closed issue #35478: Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement:
URL: https://github.com/apache/shardingsphere/issues/35478
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-2912313594
- Are you talking about one of the effects of https://github.com/apache/shardingsphere/issues/33281? That issue is in the 5.5.2 milestone.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Project stop reporting error ：org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "repository" not found; SQL statement: [shardingsphere]
Posted by "lly-ke (via GitHub)" <gi...@apache.org>.
lly-ke commented on issue #35478:
URL: https://github.com/apache/shardingsphere/issues/35478#issuecomment-3153810754
This issue still occurs in version 5.5.2.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org