Re: #1036 - Table 'gain' is read only

[Ronald Wiplinger]

MariaDB [(none)]> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | ON |
+-----------------------+-------+

ls -la db_gain
total 212
drwx------ 2 mysql mysql 4096 10月 22 16:41 .
drwx------ 15 mysql mysql 4096 11月 1 14:10 ..
-rw-rw---- 1 mysql mysql 61 10月 22 16:18 db.opt
-rw-rw---- 1 mysql mysql 4142 10月 22 16:41 gain.frm
-rw-rw---- 1 mysql mysql 196608 10月 31 23:25 gain.ibd

No error log:
ls -l /var/log/mysql/
total 4
-rw-r----- 1 mysql adm 0 11月 4 07:41 error.log
-rw-r----- 1 mysql adm 0 11月 3 07:39 error.log.1
-rw-r----- 1 mysql adm 20 10月 19 07:37 error.log.8.gz

select * from gain; shows all data in the table,

Your last hint seems to show something. I read the dump file and see:
LOCK TABLES `gain` WRITE;

Is that the reason why I cannot write to that table? How to unlock?