You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/16 09:27:21 UTC
[GitHub] [shardingsphere] MrCong233 opened a new issue, #22207: When grafana connects shardingsphere, a error that the time format is incorrect reports regularly.
MrCong233 opened a new issue, #22207:
URL: https://github.com/apache/shardingsphere/issues/22207
## Bug Report
When grafana connects shardingsphere, a error that the time format is incorrect reports regularly.
### Which version of ShardingSphere did you use?
shardingsphere-5.2.1， commit id：85541320133e8049027e922557636fe32c58625c
grafana-7.1.3 with opengauss-gdbc
openGauss-3.1.0，create a MySQL compatible database（create database DBCOMPATIBILITY='B';）
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
proxy
### Expected behavior
execute successfully.
### Actual behavior
```
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:251)
at org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.extended.bind.protocol.PostgreSQLTextTimestampUtils.parse(PostgreSQLTextTimestampUtils.java:52)
at org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.extended.bind.PostgreSQLComBindPacket.getTextParameters(PostgreSQLComBindPacket.java:133)
at org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.extended.bind.PostgreSQLComBindPacket.getTextParameters(PostgreSQLComBindPacket.java:99)
at org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.extended.bind.PostgreSQLComBindPacket.readParameters(PostgreSQLComBindPacket.java:80)
at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.extended.bind.PostgreSQLComBindExecutor.execute(PostgreSQLComBindExecutor.java:51)
at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.extended.PostgreSQLAggregatedCommandExecutor.execute(PostgreSQLAggregatedCommandExecutor.java:41)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:111)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
```
the error statement retrieved from the stack
```sql
SELECT (SELECT COUNT(*) FROM "user") AS users,(SELECT COUNT(*) FROM "org") AS orgs,(SELECT COUNT(*) FROM "dashboard") AS dashboards,(SELECT COUNT(*) FROM "data_source") AS datasources,(SELECT COUNT(*) FROM "star") AS stars,(SELECT COUNT(*) FROM "playlist") AS playlists,(SELECT COUNT(*) FROM "alert") AS alerts,(SELECT COUNT(*) FROM "user" WHERE last_seen_at > ?) AS active_users,(SELECT COUNT(id) FROM "dashboard" WHERE is_folder = ?) AS folders,(
SELECT COUNT(acl.id)
FROM "dashboard_acl" AS acl
INNER JOIN "dashboard" AS d
ON d.id = acl.dashboard_id
WHERE d.is_folder = ?
) AS dashboard_permissions,(
SELECT COUNT(acl.id)
FROM "dashboard_acl" AS acl
INNER JOIN "dashboard" AS d
ON d.id = acl.dashboard_id
WHERE d.is_folder = ?
) AS folder_permissions,(SELECT COUNT(id) FROM "dashboard_provisioning") AS provisioned_dashboards,(SELECT COUNT(id) FROM "dashboard_snapshot") AS snapshots,(SELECT COUNT(id) FROM "dashboard_version") AS dashboard_versions,(SELECT COUNT(id) FROM "annotation") AS annotations,(SELECT COUNT(id) FROM "team") AS teams,(SELECT COUNT(id) FROM "user_auth_token") AS auth_tokens,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE u.last_seen_at > ? AND ( org_user.user_id=u.id AND org_user.role='Viewer' )
) AS active_viewers,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE ( org_user.user_id=u.id AND org_user.role='Viewer' )
) AS viewers,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE u.last_seen_at > ? AND ( org_user.user_id=u.id AND org_user.role='Editor' )
) AS active_editors,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE ( org_user.user_id=u.id AND org_user.role='Editor' )
) AS editors,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE u.last_seen_at > ? AND ( org_user.user_id=u.id AND org_user.role='Admin' )
) AS active_admins,
(
SELECT COUNT(DISTINCT u.id)
FROM "user" AS u, org_user
WHERE ( org_user.user_id=u.id AND org_user.role='Admin' )
) AS admins
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
##
```
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
- !TRANSACTION
defaultType: local
providerType: Atomikos
#providerType: Narayana
props:
max-connections-size-per-query: 1
executor-size: 16 # Infinite by default.
sql-show: true
proxy-frontend-flush-threshold: 128 # The default value is 128.
proxy.transaction.type: XA
sql-federation-type: ADVANCED
```
```yaml
databaseName: grafana
dataSources:
ds_0:
url: jdbc:opengauss://192.168.0.129:56666/grafana?serverTimezone=UTC&useSSL=false&connectTimeout=10&batchMode=on&loggerLevel=OFF
username: grafana
password: Huawei@123
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
defaultDatabaseStrategy:
standard:
shardingAlgorithmName: database_default_inline
shardingColumn: id
# none: null
defaultTableStrategy:
none: null
shardingAlgorithms:
database_default_inline:
props:
algorithm-expression: ds_0
type: INLINE
ds_t1_alg:
props:
algorithm-expression: ds_${ds_id % 1}
type: INLINE
ts_t1_alg:
props:
algorithm-expression: ts_${ts_id % 1}
type: INLINE
tables:
t1:
actualDataNodes: ds_${0..0}.ts_${0..0}
databaseStrategy:
standard:
shardingAlgorithmName: ds_t1_alg
shardingColumn: ds_id
tableStrategy:
standard:
shardingAlgorithmName: ts_t1_alg
shardingColumn: ts_id
```
--
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
[GitHub] [shardingsphere] tristaZero closed issue #22207: When grafana connects shardingsphere, a error that the time format is incorrect reports regularly.
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #22207: When grafana connects shardingsphere, a error that the time format is incorrect reports regularly.
URL: https://github.com/apache/shardingsphere/issues/22207
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #22207: When grafana connects shardingsphere, a error that the time format is incorrect reports regularly.
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22207:
URL: https://github.com/apache/shardingsphere/issues/22207#issuecomment-1317977508
Hi @MrCong233
Please provide the time value format that cause this issue. Thank you!
--
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