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 2021/03/15 10:21:24 UTC

[GitHub] [shardingsphere] wavelet123 edited a comment on issue #9634: sharding tables error when insert

wavelet123 edited a comment on issue #9634:
URL: https://github.com/apache/shardingsphere/issues/9634#issuecomment-799187291


   > Hi @wavelet123
   > 
   > 1. Which version is running in your case?
   > 2. It looks like SS did not locate the database for this table. Which SQL triggered this exception?
   > 3. Could you set `SQL-show` = true in the configuration file? Therefore we can get more details about your issue.
   > 
   > Thanks
   
   Hi tristaZero ,
   1.We are using 4.1.1.
   2.The following sql triggered this exception
   insert into t_accountfriend(FFirstAccountID,FSecondAccountID,FGroupType,FIsDeleted,FCreateTime,FModifyTime)values(1013421,1013422,2,0,now(),now());
   3.  sql.show: true has been set in server.yaml,do we need to set SQL-show = true in config-sharding.yaml?
   4. the "select count(*) from t_accountfriend" works correct and does not trigger any errors. 
   
   Thanks
   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org