potential bug and/or not understanding behavior
Hi all-
I originally directed this to Squirrel SQL but it may not
be their issue. I can't get multiple queries to show up in processlist
or in connections option in the workbench.
I set autocommit off, and then I do a partial transaction.
It doesn't show up in the processlist at all.
I think if it is a partial query, it show up in processlist.
If not, how can you tell what is going on with a partial transaction?
Do you have any ideas why it doesn't list the partial queries?
Please see below...
I feel about as crazy as a gang of loons right now .
mysql Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
THANKS for any assistance!
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> update a1 set bar = 'qy' where foo = 2;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> show processlist;
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 126 | Waiting on empty queue | NULL |
| 8 | root | localhost | mydb | Query | 0 | init | show processlist |
+----+-----------------+-----------+------+---------+------+------------------------+------------------+
2 rows in set (0.00 sec)
Subject
Views
Written By
Posted
potential bug and/or not understanding behavior
829
August 21, 2022 07:26PM
355
August 21, 2022 09:01PM
485
August 21, 2022 10:07PM
327
August 21, 2022 10:21PM
587
August 21, 2022 10:34PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.