Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug] SQLSyntaxErrorException at HealthCheckResultMapper #67

Closed
Pil0tXia opened this issue Mar 18, 2024 · 1 comment
Closed

[Bug] SQLSyntaxErrorException at HealthCheckResultMapper #67

Pil0tXia opened this issue Mar 18, 2024 · 1 comment

Comments

@Pil0tXia
Copy link
Member

Steps to reproduce

Start application.

@Lambert-Rao

Logs

[2024-03-19 01:37:27.765] DEBUG main - Found key 'spring.liveBeansView.mbeanDomain' in PropertySource 'systemProperties' with value of type String
[2024-03-19 01:37:27.767] INFO main - Started EventMeshDashboardApplication in 2.425 seconds (JVM running for 3.288)
[2024-03-19 01:37:27.768] DEBUG main - Application availability state LivenessState changed to CORRECT
[2024-03-19 01:37:27.769] DEBUG main - Application availability state ReadinessState changed to ACCEPTING_TRAFFIC
[2024-03-19 01:37:27.769] INFO main - EventMeshDashboardApplication Boot Successful!
[2024-03-19 01:37:32.395] DEBUG pool-2-thread-1 - Creating a new SqlSession
[2024-03-19 01:37:32.397] DEBUG pool-2-thread-1 - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@456b75f1] was not registered for synchronization because synchronization is not active
[2024-03-19 01:37:32.418] DEBUG pool-2-thread-1 - Fetching JDBC Connection from DataSource
[2024-03-19 01:37:32.419] DEBUG pool-2-thread-1 - JDBC Connection [com.alibaba.druid.pool.DruidStatementConnection@218ee5eb] will not be managed by Spring
[2024-03-19 01:37:32.421] DEBUG pool-2-thread-1 - ==>  Preparing: INSERT INTO health_check_result(type, type_id, cluster_id, state, result_desc) VALUES
[2024-03-19 01:37:32.434] DEBUG pool-2-thread-1 - ==> Parameters: 
[2024-03-19 01:37:32.506] DEBUG pool-2-thread-1 - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@456b75f1]
[2024-03-19 01:37:32.531] DEBUG pool-2-thread-1 - Loaded 11 bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[2024-03-19 01:37:32.531] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'DB2'
[2024-03-19 01:37:32.533] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'Derby'
[2024-03-19 01:37:32.534] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'H2'
[2024-03-19 01:37:32.534] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'HDB'
[2024-03-19 01:37:32.534] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'HSQL'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'Informix'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'MS-SQL'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'MySQL'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'Oracle'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'PostgreSQL'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Creating shared instance of singleton bean 'Sybase'
[2024-03-19 01:37:32.535] DEBUG pool-2-thread-1 - Looking up default SQLErrorCodes for DataSource [com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceWrapper@17d32e9b]
[2024-03-19 01:37:32.537] DEBUG pool-2-thread-1 - Fetching JDBC Connection from DataSource
[2024-03-19 01:37:32.538] DEBUG pool-2-thread-1 - SQL error codes for 'MySQL' found
[2024-03-19 01:37:32.538] DEBUG pool-2-thread-1 - Caching SQL error codes for DataSource [com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceWrapper@17d32e9b]: database product name is 'MySQL'
[2024-03-19 01:37:32.539] DEBUG pool-2-thread-1 - Translating SQLException with SQL state '42000', error code '1064', message [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1] for task [
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
### The error may exist in org/apache/eventmesh/dashboard/console/mapper/health/HealthCheckResultMapper.java (best guess)
### The error may involve org.apache.eventmesh.dashboard.console.mapper.health.HealthCheckResultMapper.batchInsert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO health_check_result(type, type_id, cluster_id, state, result_desc) VALUES
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
]
Pil0tXia pushed a commit that referenced this issue Mar 19, 2024
@Lambert-Rao
[ISSUE #67] Fix HealthCheckResultMapper which leads to application error
e750702
@Pil0tXia
Copy link
Member Author

Completed in #68

SLSJL pushed a commit to SLSJL/eventmesh-dashboard that referenced this issue Mar 31, 2024
Merge branch 'dev' of https://github.com/SLSJL/eventmesh-dashboard in…
e75f4ae 
…to dev

* 'dev' of https://github.com/SLSJL/eventmesh-dashboard:
  [ISSUE apache#73] Add remoting service (apache#74)
  [ISSUE apache#45] Implement methods from storage-plugin.admin(rocketmq) (apache#66)
  [ISSUE apache#71] Reduce log file size and Streamline debug output (apache#72)
  [ISSUE apache#69] Integrate database credentials in auto-deploy (apache#70)
  [ISSUE apache#67] Fix HealthCheckResultMapper which leads to application error
  [ISSUE apache#64] Support automated deployment and Fix runtime packaging errors (apache#65)
  [ISSUE apache#60] add SDK manager (apache#62)
  [ISSUE apache#57] Modify the field, synchronize the modification, and add the mapper method (apache#58)
  [ISSUE apache#29] Set up EventMesh Dashboard Front-end (apache#56)
  [ISSUE apache#49] RocketMQ and Nacos health check (apache#53)
  [ISSUE apache#51] Config Mgmt basic function and config,runtime,store,cluster SQL (apache#52)

# Conflicts:
#	eventmesh-dashboard-view/public/index.html
#	eventmesh-dashboard-view/src/App.tsx
#	eventmesh-dashboard-view/src/index.tsx
#	eventmesh-dashboard-view/src/routes/RootLayout.tsx
#	eventmesh-dashboard-view/src/routes/navigation/Navigation.tsx
#	eventmesh-dashboard-view/src/routes/navigation/NavigationItem.tsx
#	eventmesh-dashboard-view/src/routes/topic/Topic.tsx
#	eventmesh-dashboard-view/src/routes/topic/stats/AbnormalTopicCount.tsx
#	eventmesh-dashboard-view/src/routes/topic/stats/Stats.tsx
#	eventmesh-dashboard-view/src/routes/topic/stats/StatsChart.tsx
#	eventmesh-dashboard-view/src/routes/topic/stats/TopicCount.tsx
#	eventmesh-dashboard-view/src/routes/topic/topic-list/TopicList.tsx
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Pil0tXia