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