576470954 opened a new issue, #610:
URL: https://github.com/apache/incubator-seata-go/issues/610

   <!-- Please use this template while reporting a bug and provide as much info 
as possible. Not doing so may result in your bug not being addressed in a 
timely manner. Thanks!
   
   -->
   
   
   **What happened**:
   when I write sql "select sth for update" and use QueryContext func.Why I use 
QueryContext(not ExecContext) because I want to
   get the rows:
   <img width="602" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/1df2ef90-d14b-473e-aca2-fca6c6fcb9e9";>
   I got error:
   <img width="919" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/ea24ccdd-57ef-46dd-8b8d-4b33aab4879e";>
   
   
   
   **What you expected to happen**:
   execute normally
   
   **How to reproduce it (as minimally and precisely as possible)**:
   sql and func like my code
   
   **Anything else we need to know?**:
   the reason maybe in seata-go, it QueryContext and then ExecContext, so the 
mysql conn is something wrong
   this is the QueryContext code:
   <img width="1068" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/890ef0cc-e6db-486c-b633-49e4877595da";>
   and then :after exec the business func (showed upon) in line 178, it exec 
line:185 
   <img width="1215" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/9d9fecca-6f89-4242-8dbe-d5cf41ceb83c";>
   and this conn cant use twice(watching in mysql has been set to true, and 
haven't set to false after queryContext complete)
   <img width="902" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/b8a76d44-997e-4801-b6f6-24a8c7fcae63";>
   In mysql driver QueryContext func haven't finish the mc unless err != 
nil(it's diff with ExecContext func)
   <img width="945" alt="image" 
src="https://github.com/seata/seata-go/assets/28291353/ba6b3acb-9b33-44ec-b5fd-44265b7064b8";>
   
   


-- 
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-unsubscr...@seata.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org
For additional commands, e-mail: notifications-h...@seata.apache.org

Reply via email to