MySQL Forums
Forum List  »  InnoDB

Re: MySQL 8.0 Command Line Client Error 1205
Posted by: J C
Date: July 17, 2022 03:20PM

Side Note: Lol, I am not a newb to MySQL (rather, an amateur at the Command Line as I even had trouble finding it when it was pre-installed with a Community Package), but I do not know where else to post this as this is somewhat of a miscellaneous issue.

MySQL 8.0 Command Line Client is giving me a timeout error and I have restarting the transaction by typing "start transaction" another time. Keep in mind that I have another command line open with the table CIA_DATA.new_table and it is also being updated with the same changes. (I am doing this to follow a tutorial.) Here is the script:

mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)

mysql> update CIA_DATA.new_table set c1 = 2 where c1 = 1;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction


P.S.: Feel free to send this to another forum section if this is not the right one, moderators. I just want to fix this issue.

Options: ReplyQuote

Written By
Re: MySQL 8.0 Command Line Client Error 1205
July 17, 2022 03:20PM

Sorry, you can't reply to this topic. It has been closed.

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.