How does one do table locking?

[charl]

This example illustrates what looks like the driver stalling when one uses locking on tables.

If one manually executes the SQL in the mysql client there are no issues.

Is there some special way table locking is handled in the driver that I am not using int he example?

[charl]

When you run the example the code seems to lock when trying to execute:

INSERT INTO bar SELECT * FROM foo

Which was right after tables foor/bar were locked with:

LOCK TABLE foo WRITE, bar WRITE

[xaprb]

The issue here is that you are running those queries on different
connections. One connection locks, another one tries to insert. Use a
transaction to bind everything to a single connection. Better yet, don't
use LOCK TABLES :-P

[arnehormann]

@charls it's exactly as @xaprb says 😀 ... I think everyone hits this once.
Thanks for opening an issue in go-database-sql-tutorial!

[hokadiri]

Using a transaction poses its own challenges see:
#1280

TLDR: Using a transaction, one should end it with a commit or rollback.
Doing locking, one has to Lock table then Unlock table. Unlock table implicitly does a commit which conflicts with Tx.commit

[ghost]

@hokadiri have you found any solution to the challenge you mentioned?