|
From: Gerd W. <ger...@t-...> - 2022-08-23 18:43:29
|
Am 21.08.22 um 22:34 schrieb crystal: > Hi Gerd- > > This is the type of problem i am having. > 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 process list. > 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? > > 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)) > > Please see below... > > THANKS > > 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) > > Sorry I don't know MySQL's command line interface too well. But JDBC isn't designed for partial or nested transactions. With JDBC a connection is either in autocommit mode or the current transaction may be either committed or rolled back. As SQuirreL is built on top of JDBC it isn't designed to do more neither. Gerd |
