My MythTV store lives on an LVM volume that is spread over 2 disks, one of them is an external USB disk. So the cleaninglady seems to have touched a cable and after coming back from holiday I had a read-only filesystem that afer a remount had about 350Gb in lost+found with irrelevant filenames.

1. total 337407844
2. drwx------ 2 tv tv 4096 Dec 17 22:47 .
3. drwxrwxrwx 15 tv tv 4096 Dec 17 22:44 ..
4. -rw-r--r-- 1 root root 423343556 Dec 14 07:10 I303109.RCN
5. -rw-r--r-- 1 root root 2990538924 Dec 13 19:05 I303107.RCN
6. -rw-r--r-- 1 root root 1023691768 Dec 13 08:10 I319494.RCN
7. -rw-r--r-- 1 root root 1023622348 Dec 13 07:45 I327684.RCN
8. -rw-r--r-- 1 root root 423735892 Dec 13 07:10 I327682.RCN
9. -rw-r--r-- 1 root root 466749476 Dec 12 15:43 I135169.RCN
10. -rw-r--r-- 1 root root 1023314212 Dec 12 07:45 I098309.RCN
11. -rw-r--r-- 1 root root …

Navicat For MySQL is a GUI for MySQL developers. I've tried a few tools before but somehow got attached to Navicat due to a few nice features that I'm not going to go into right now. Navicat suffers from a couple of annoying bugs and random crashes. I don't know if I can help fix the random ones but if I can at least file the ones I can reproduce, everyone wins. I have the latest as of today version 8.0.23.

Bug [NAL-15328]: Structure Sync Fails to notice encoding differences

ok folks. here's some results:

mysql> select last_errno,count(*) from 
queryqueue group by last_errno;
+------------+----------+
| last_errno | count(*) |
+------------+----------+
|          0 |  1600796 |
|       1048 |     1971 |
|       1053 |        1 |
|       1139 |       35 |
|       1267 |    19722 |
|       1270 |     4243 |
|       1271 |     8944 |
|       1416 |     2284 |
|       1580 |    23225 |
|       2003 |       28 |
|       2013 |     1606 |
+------------+----------+
11 rows in set (0.00 sec)

error 2013 means lost connection to server (read: server crashed).
so there are many bugs found already. 1606 crashes out of 1.6 million
executed queries, is great.

check my rss feed for the exact bugs ...