This morning, after shutting down and restarting the MariaDB and Owncloud rock-ons, they are now working again. I have no idea why. (This was, of course, the very first thing I tried when the problem started; I don’t know why it worked today even though it didn’t work then.)
But the issue with missing snapshots persists. Here’s how my mariadb-data snapshots look now:
drwxr-xr-x 1 mariadb mariadb 228 Nov 29 03:42 mariadata_201611290342
drwxr-xr-x 1 mariadb mariadb 228 Nov 29 03:42 mariadata_201612040300
drwxr-xr-x 1 mariadb mariadb 228 Dec 6 03:42 mariadata_201612060342
drwxr-xr-x 1 mariadb mariadb 780 Feb 18 22:50 mariadata_201702182350
drwxr-xr-x 1 mariadb mariadb 780 Feb 18 23:50 mariadata_201702190050
drwxr-xr-x 1 mariadb mariadb 550 Feb 19 01:30 mariadata_201702190130
drwxr-xr-x 1 mariadb mariadb 550 Feb 19 01:30 mariadata_201702190150
drwxr-xr-x 1 mariadb mariadb 596 Feb 19 01:50 mariadata_201702190250
drwxr-xr-x 1 mariadb mariadb 642 Feb 19 02:50 mariadata_201702190350
drwxr-xr-x 1 mariadb mariadb 688 Feb 19 03:50 mariadata_201702190450
drwxr-xr-x 1 mariadb mariadb 734 Feb 19 04:50 mariadata_201702190550
drwxr-xr-x 1 mariadb mariadb 780 Feb 19 05:50 mariadata_201702190650
drwxr-xr-x 1 mariadb mariadb 780 Feb 19 06:50 mariadata_201702190750
drwxr-xr-x 1 mariadb mariadb 780 Feb 19 07:50 mariadata_201702190850
drwxr-xr-x 1 mariadb mariadb 780 Feb 19 08:50 mariadata_201702190950
drwxr-xr-x 1 mariadb mariadb 228 Oct 25 03:42 reverted-working-again
But here’s what shows up in the Rockstor web GUI:
mariadata_201702190950 February 19th 2017, 9:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190850 February 19th 2017, 8:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190750 February 19th 2017, 7:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190650 February 19th 2017, 6:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190550 February 19th 2017, 5:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190450 February 19th 2017, 4:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190350 February 19th 2017, 3:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190250 February 19th 2017, 2:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190150 February 19th 2017, 1:50:04 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190130 February 19th 2017, 1:30:06 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702190050 February 19th 2017, 12:50:05 am Visible Yes 620.09 MB 320.00 KB
mariadata_201702182350 February 18th 2017, 11:50:05 pm Visible Yes 620.09 MB 320.00 KB
reverted-working-again December 10th 2016, 1:46:50 pm Hidden No 537.01 MB 243.98 MB
See the difference? The snapshots from 20161129, 20161204, and 20161206 aren’t listed.
I’ve followed the directions from the Internal Implementation thread to make the snapshots visible (mount -o subvol=.snapshots/mariadb-data/mariadata_201612060342 /dev/sdb /mnt2/mariadb-data/.mariadata_201612060342
etc.), rebooted Rockstor, and they’re still not there in the GUI.
So, while Owncloud and MariaDB are working for now, my snapshot issues persist:
-
Not all snapshots are being listed in the GUI, even after I mount them on the command line to make them visible;
-
Daily snapshots are not being preserved. They’re being taken, but they’re being removed after a day. For example, I have the mariadata_201702190130 snapshot that was taken at 01:30 this morning, but the one that was taken at 01:30 yesterday morning is gone.
-
Weekly and monthly snapshots are gone too. It’s not clear whether they’re not being taken at all, or whether they’re being taken and then removed in the same way that Daily ones are.
I’ve just thought of something: maybe it’s the filenames. I’ve used the same prefix (“mariadata”) for my hourly, daily, weekly, and monthly snapshots, and I currently have the most recent 12 snapshots listed. Not the most recent 12 hourly snapshots; there are 11 hourly snapshots and 1 daily snapshot.
This suggests it could be the filenames, and that the hourly scheduled task is removing all but the 12 most recent snapshots beginning with “mariadata_”.
I’m going to try changing them to use different prefixes (mariadata-hourly, mariadata-daily, etc.) and see if that makes a difference. It’ll take a couple of days to know for sure, but I’ll report back.