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/29 07:55:38 UTC

[GitHub] [shardingsphere] TeslaCN opened a new issue, #22501: panic: pq: No value specified for parameter 1. when using Golang XORM

TeslaCN opened a new issue, #22501:
URL: https://github.com/apache/shardingsphere/issues/22501

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   master - e71e94d7e1b71694402829ea0074cb085129069e
   
   This issue may be caused by https://github.com/apache/shardingsphere/pull/13692
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-Proxy PostgreSQL
   
   ### Expected behavior
   
   Query returned correct result.
   
   ### Actual behavior
   
   ```
   panic: pq: No value specified for parameter 1.
   ```
   
   ### Reason analyze (If you can)
   
   ![image](https://user-images.githubusercontent.com/20503072/204470841-e9ae17c9-bb8c-4d90-8489-8d0cbead962b.png)
   
   ![image](https://user-images.githubusercontent.com/20503072/204470888-7b2d807b-7657-4cd2-a44e-41082e5a36dd.png)
   
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ```yaml
   schemaName: postgres
   dataSources:
     ds_0:
       url: jdbc:postgresql://127.0.0.1:5432/postgres?prepareThreshold=1
       username: postgres
       password: postgres
       connectionTimeoutMilliseconds: 3000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 32
       minPoolSize: 0
   
   rules: []
   ```
   
   


-- 
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] TeslaCN commented on issue #22501: panic: pq: No value specified for parameter 1. when using Golang XORM

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22501:
URL: https://github.com/apache/shardingsphere/issues/22501#issuecomment-1333207853

   > please try this: `docker run --network host -e driverName=postgres -e dataSourceName='user=postgres password=123456 host=127.0.0.1 port=5432 sslmode=disable dbname=casdoor' -e dbName='' casbin/casdoor:latest`
   
   This is ShardingSphere-Proxy's issue. Casdoor is just a way to reproduce this.


-- 
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] jakiuncle commented on issue #22501: panic: pq: No value specified for parameter 1. when using Golang XORM

Posted by GitBox <gi...@apache.org>.
jakiuncle commented on issue #22501:
URL: https://github.com/apache/shardingsphere/issues/22501#issuecomment-1331824562

   please try this     docker run   --network host   -e driverName=postgres   -e dataSourceName='user=postgres password=123456 host=127.0.0.1 port=5432 sslmode=disable dbname=casdoor' -e dbName=''   casbin/casdoor:latest
   


-- 
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