Repository navigation
Writing data into files does not update SQL database records #3
Description
Changing the contents of a file (column) does not change the actual record in the database:
$ mysql -utest -ptest test -e 'SELECT * FROM data'
+-----+--------+
| uid | title |
+-----+--------+
| 1 | title1 |
+-----+--------+
$ ls mountpoint/data/ test/
$ cat mountpoint/data/uid/1/title; echo
title1
$ echo title2 > mountpoint/data/uid/1/title
$ cat mountpoint/data/uid/1/title
title2
$ mysql -utest -ptest test -e 'SELECT * FROM data'
+-----+--------+
| uid | title |
+-----+--------+
| 1 | title1 |
+-----+--------+
Activity
cweiske commentedon Jan 13, 2015
I guess this has to to with the fact that
mysqlfuseseems to use transactions. The network protocol dump shows that we're in a transaction, andautocommitis not enabled:cweiske commentedon Jan 13, 2015
The first SQL query after the login is
set autocommit=0, but that is not in the mysqlfuse codebase:cweiske commentedon Jan 13, 2015
This was a change in the MySQLdb package:
Fix bug clsn#3: enable autocommit so writes actually work
Fix bug clsn#3: enable autocommit so writes actually work