User:Trogod/System0Maintai

From MythTV Official Wiki
< User:Trogod
Revision as of 06:55, 21 April 2012 by Trogod (talk | contribs) (14 Feb 2012)

Jump to: navigation, search

disk repair

some links

3 May 2011

booted from live DVD for mythbuntu

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos  

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA Hitachi HDT72101 (scsi)
Disk /dev/sdb: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      17.4kB  1000GB  1000GB  jfs 
 

Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label  
 

and then I ran fsck:

ubuntu@ubuntu:~$ sudo fsck.jfs -n /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/4/2011 3.21.10
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
Errors detected in the Fileset File/Directory Allocation Map control information. (F)
Errors detected in the Fileset File/Directory Allocation Map. (F)
**Phase 8 - Verify Disk Allocation Maps
Incorrect data detected in disk allocation control structures.
976761716 kilobytes total disk space.
   146077 kilobytes in 66698 directories.
964783365 kilobytes in 413547 user files.
       20 kilobytes in extended attributes
   513312 kilobytes reserved for system use.
 11611096 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is dirty.
Filesystem is dirty but is marked clean.  In its present state,
the results of accessing /dev/sdb1 (except by this utility) are undefined.
ubuntu@ubuntu:~$

and then I tried to fix it

ubuntu@ubuntu:~$ sudo fsck.jfs -f /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/4/2011 3.29.15
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
976761716 kilobytes total disk space.
   146077 kilobytes in 66698 directories.
964783365 kilobytes in 413547 user files.
       20 kilobytes in extended attributes
   506992 kilobytes reserved for system use.
 11617416 kilobytes are available for use.
Filesystem is clean.

and ran it again, just to check...

ubuntu@ubuntu:~$ sudo fsck.jfs -n /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/4/2011 3.32.51
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
976761716 kilobytes total disk space.
   146077 kilobytes in 66698 directories.
964783365 kilobytes in 413547 user files.
       20 kilobytes in extended attributes
   506992 kilobytes reserved for system use.
 11617416 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.
ubuntu@ubuntu:~$


13 May 2011

There was, apparently, a power failure, today. My wife booted up the System0, but it didn't boot properly. There was some text on the screen with some error messages about mounting filesystems. I should've paid closer attention to those messages. Instead, I went straight to trying to repair the filesystems. I booted from live DVD for mythbuntu

ubuntu@ubuntu:~$ sudo parted -l                                                        
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos 

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA Hitachi HDT72101 (scsi)
Disk /dev/sdb: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt 

Number  Start   End     Size    File system  Name  Flags
 1      17.4kB  1000GB  1000GB  jfs
 

Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
vhas been opened read-only.
vError: /dev/sr0: unrecognised disk label                                  

then I checked for errors

ubuntu@ubuntu:~$ sudo fsck.jfs -n /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/13/2011 2.43.16
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
Errors detected in the Fileset File/Directory Allocation Map control information. (F)
Errors detected in the Fileset File/Directory Allocation Map. (F)
**Phase 8 - Verify Disk Allocation Maps
Incorrect data detected in disk allocation control structures.
976761716 kilobytes total disk space.
   146089 kilobytes in 66698 directories.
953111998 kilobytes in 413620 user files.
       20 kilobytes in extended attributes
   507043 kilobytes reserved for system use.
 23288744 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is dirty.
Filesystem is dirty but is marked clean.  In its present state,
the results of accessing /dev/sdb1 (except by this utility) are undefined. 

then I attempted repair

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/13/2011 2.45.33
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
976761716 kilobytes total disk space.
   146089 kilobytes in 66698 directories.
953111998 kilobytes in 413620 user files.
       20 kilobytes in extended attributes
   506995 kilobytes reserved for system use.
 23288792 kilobytes are available for use.
Filesystem is clean.

real	1m51.009s
user	0m2.770s
sys	0m2.390s


ubuntu@ubuntu:~$ sudo fsck.jfs -n /dev/sdb1     
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/13/2011 2.48.53
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
976761716 kilobytes total disk space.
   146089 kilobytes in 66698 directories.
953111998 kilobytes in 413620 user files.
       20 kilobytes in extended attributes
   506995 kilobytes reserved for system use.
 23288792 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 216/628320 files (1.4% non-contiguous), 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda1
/dev/sda1: clean, 216/628320 files, 116856/1256416 blocks

ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda2
/dev/sda2 is mounted.  

WARNING!!!  The filesystem is mounted.   If you continue you ***WILL***
cause ***SEVERE*** filesystem damage.

Do you really want to continue (y/n)? no 

check aborted.

oh, yeah - that's the swap partititon. oops....

ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda3
/dev/sda3: clean, 131773/983488 files, 790678/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda4
/dev/sda4: clean, 1801/1313280 files, 218299/5242880 blocks

So both my /storage drive (/dev/sdb1) and my boot partition (/dev/sda1) needed repair...

when I rebooted, mythtv complained that it couldn't talk to the backend. I quit the frontend and check the log of the backend. I couldn't tell if any of the messages were particularly bad. there were some messages that seem to indicate that it couldn't talk to my HDHomeRun tuner. I restarted the frontend and found that I was able to play recorded shows. After I noticed that live TV didn't seem to be working, I tried to reboot.

On reboot, there was a message about a problem trying to mount /storage. ugh!!

So, I booted from the CD again and ran fsck

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/13/2011 3.54.20
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
976761716 kilobytes total disk space.
   146097 kilobytes in 66698 directories.
940169594 kilobytes in 413669 user files.
       20 kilobytes in extended attributes
   506987 kilobytes reserved for system use.
 36231212 kilobytes are available for use.
Filesystem is clean.
.|.......
real	1m47.821s
user	0m2.940s
sys	0m2.330s
ubuntu@ubuntu:~$ time sudo fsck.ext2 -p /dev/sda1
/dev/sda1: clean, 216/628320 files, 116856/1256416 blocks

real	0m5.592s
user	0m0.000s
sys	0m0.040s
ubuntu@ubuntu:~$ time sudo fsck.ext2 -p /dev/sda3
/dev/sda3: clean, 131774/983488 files, 790797/3933916 blocks

real	0m0.347s
user	0m0.000s
sys	0m0.010s
ubuntu@ubuntu:~$ time sudo fsck.ext2 -p /dev/sda4
/dev/sda4: clean, 1921/1313280 files, 234080/5242880 blocks

real	0m0.266s
user	0m0.000s
sys	0m0.010s

then I rebooted again. I bet I need a new hard drive for /storage...

17 May 2011

again, apparently a power outage. When I tried to boot System0, it complained of trouble mounting /storage, so back to fsck...

ubuntu@ubuntu:~$ sudo parted -l                                                
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos 

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA Hitachi HDT72101 (scsi)
Disk /dev/sdb: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt 

Number  Start   End     Size    File system  Name  Flags
 1      17.4kB  1000GB  1000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                   
ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/17/2011 2.39.13
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
File system object FF8765 is linked as: /mythtv/recordings/1071_20110516003400.mpg
cannot repair the data format error(s) in this file.
cannot repair FF8765.  Will release.
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
976761716 kilobytes total disk space.
   146105 kilobytes in 66698 directories.
952457952 kilobytes in 413640 user files.
       20 kilobytes in extended attributes
   507049 kilobytes reserved for system use.
 23942800 kilobytes are available for use.
Filesystem is clean.
.|.......
real	1m45.254s
user	0m2.900s
sys	0m2.360s
ubuntu@ubuntu:~$ sudo fsck.jfs -n /dev/sdb1     
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/17/2011 2.41.34
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
976761716 kilobytes total disk space.
   146105 kilobytes in 66698 directories.
952457952 kilobytes in 413640 user files.
       20 kilobytes in extended attributes
   507049 kilobytes reserved for system use.
 23942800 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

and my primary drive...

ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 216/628320 files (1.4% non-contiguous), 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda1
/dev/sda1: clean, 216/628320 files, 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda3
/dev/sda3: clean, 131781/983488 files, 792256/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda4
/dev/sda4: clean, 1931/1313280 files, 234856/5242880 blocks

again, both the boot partition and /storage needed repair. Ugh! why doesn't ubuntu fix this itself?

23 May 2011

I'm in the process of adding a 2 TB hard drive. I booted into a GParted live-CD to format the drive but when I booted back to mythtv, I received the message, again, about not being able to mount /storage. So, here I am again doing fsck

$ sudo parted -l    
Model: ATA Hitachi HDT72101 (scsi)
Disk /dev/sda: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt 

Number  Start   End     Size    File system  Name  Flags
 1      17.4kB  1000GB  1000GB  jfs


Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sdb: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos 

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: SAMSUNG S2H7J9AB303120 (scsi)
Disk /dev/sdc: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt 

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  


$ time sudo fsck.jfs -f /dev/sdb1                               
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/23/2011 3.32.12
The current device is:  /dev/sdb1

The superblock does not describe a correct jfs file system.

If device /dev/sdb1 is valid and contains a jfs file system,
then both the primary and secondary superblocks are corrupt
and cannot be repaired, and fsck cannot continue.

Otherwise, make sure the entered device /dev/sdb1 is correct.


real	0m1.488s
user	0m0.000s
sys	0m0.010s

OOPS, thank you fsck.jfs for catching my typo!! I didn't pay attention enough to the output of parted, I really meant

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sda1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/23/2011 3.33.41
The current device is:  /dev/sda1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
976761716 kilobytes total disk space.
   146109 kilobytes in 66698 directories.
961693217 kilobytes in 413659 user files.
       20 kilobytes in extended attributes
   507048 kilobytes reserved for system use.
 14707540 kilobytes are available for use.
Filesystem is clean.
.|.......
real	1m46.440s
user	0m2.610s
sys	0m2.540s
ubuntu@ubuntu:~$ time sudo fsck.jfs -n /dev/sda1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 5/23/2011 3.36.4
The current device is:  /dev/sda1
Block size in bytes:  4096
Filesystem size in blocks:  244190429
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
976761716 kilobytes total disk space.
   146109 kilobytes in 66698 directories.
961693217 kilobytes in 413659 user files.
       20 kilobytes in extended attributes
   507048 kilobytes reserved for system use.
 14707540 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	1m27.786s
user	0m3.100s
sys	0m1.510s
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sdb1
/dev/sdb1 was not cleanly unmounted, check forced.
/dev/sdb1: 216/628320 files (1.4% non-contiguous), 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sdb1
/dev/sdb1: clean, 216/628320 files, 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sdb3
/dev/sdb3: clean, 131936/983488 files, 796075/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sdb4
/dev/sdb4: clean, 2236/1313280 files, 242459/5242880 blocks (check in 5 mounts)

and then I rebooted, again!

10 June 2011

the power went out and then I got the message about not mounting /storage

$ sudo parted -l    
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1                               
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 6/11/2011 2.21.20
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   253309 kilobytes in 108698 directories.
1076441754 kilobytes in 715228 user files.
        0 kilobytes in extended attributes
   899063 kilobytes reserved for system use.
876425964 kilobytes are available for use.
Filesystem is clean.
|........
real	2m49.110s
user	0m4.470s
sys	0m2.500s
ubuntu@ubuntu:~$ time sudo fsck.jfs -n /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 6/11/2011 2.24.22
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   253309 kilobytes in 108698 directories.
1076441754 kilobytes in 715228 user files.
        0 kilobytes in extended attributes
   899063 kilobytes reserved for system use.
876425964 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m19.778s
user	0m4.520s
sys	0m1.770s

and then the other drive

ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sdb1
fsck.ext2: Bad magic number in super-block while trying to open /dev/sdb1
/dev/sdb1: 
The superblock could not be read or does not describe a correct ext2
filesystem.  If the device is valid and it really contains an ext2
filesystem (and not swap or ufs or something else), then the superblock
is corrupt, and you might try running e2fsck with an alternate superblock:
    e2fsck -b 8193 <device>

OOPS, thanks again, fsck.ext2! you caught my error

ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1 
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 216/628320 files (1.4% non-contiguous), 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda1
/dev/sda1: clean, 216/628320 files, 116856/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda3
/dev/sda3: clean, 131948/983488 files, 779468/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda4
/dev/sda4 has been mounted 21 times without being checked, check forced.

    2641 inodes used (0.20%)
     511 non-contiguous files (19.3%)
       3 non-contiguous directories (0.1%)
         # of inodes with ind/dind/tind blocks: 1683/4/0
  336364 blocks used (6.42%)
       0 bad blocks
       1 large file

    2508 regular files
     118 directories
       0 character device files
       0 block device files
       0 fifos
       0 links
       6 symbolic links (6 fast symbolic links)
       0 sockets
--------
    2632 files

15 July 2011

The power went out *again*!! and I had to reboot my mythtv. I saw the message again about /storage not being mounted, so I, again, performed the fsck runs:

ubuntu@ubuntu:~$ sudo parted -l    
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1                               
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 7/16/2011 1.2.18
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   267075 kilobytes in 116759 directories.
1421743391 kilobytes in 751591 user files.
        0 kilobytes in extended attributes
   928600 kilobytes reserved for system use.
531108556 kilobytes are available for use.
Filesystem is clean.
.|.......
real	3m18.417s
user	0m8.761s
sys	0m3.512s
ubuntu@ubuntu:~$ time sudo fsck.jfs -n /dev/sdb1
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 7/16/2011 1.7.19
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   267075 kilobytes in 116759 directories.
1421743391 kilobytes in 751591 user files.
        0 kilobytes in extended attributes
   928600 kilobytes reserved for system use.
531108556 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.
...|.....
real	2m38.882s
user	0m9.213s
sys	0m2.344s
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda1
/dev/sda1 was not cleanly unmounted, check forced.

     223 inodes used (0.04%)
       9 non-contiguous files (4.0%)
       1 non-contiguous directory (0.4%)
         # of inodes with ind/dind/tind blocks: 37/13/0
  137532 blocks used (10.95%)
       0 bad blocks
       0 large files

     210 regular files
       4 directories
       0 character device files
       0 block device files
       0 fifos
       0 links
       0 symbolic links (0 fast symbolic links)
       0 sockets
--------
     214 files
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda1
/dev/sda1: clean, 223/628320 files, 137532/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda3
/dev/sda3: clean, 155167/983488 files, 880281/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -pv /dev/sda4
/dev/sda4: clean, 2784/1313280 files, 351541/5242880 blocks

8 Aug 2011

had a problem before leaving on a trip

To run a command as administrator (user "root"), use "sudo <command>".
See "man sudo_root" for details.

ubuntu@ubuntu:~$ date
Wed Aug 10 03:24:49 UTC 2011
ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

ubuntu@ubuntu:~$ time sudo fsck.jfs -f /dev/sdb1                               
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 8/10/2011 3.25.35
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   274943 kilobytes in 120870 directories.
1535343612 kilobytes in 772232 user files.
        0 kilobytes in extended attributes
   945055 kilobytes reserved for system use.
417499748 kilobytes are available for use.
Filesystem is clean.
.....|...
real	3m10.225s
user	0m4.880s
sys	0m2.970s
ubuntu@ubuntu:~$ time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1>
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 8/10/2011 3.36.44
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   274943 kilobytes in 120870 directories.
1535343612 kilobytes in 772232 user files.
        0 kilobytes in extended attributes
   945055 kilobytes reserved for system use.
417499748 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m34.966s
user	0m4.910s
sys	0m2.100s
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 223/628320 files (4.5% non-contiguous), 137568/1256416 blocks
/dev/sda3: clean, 155703/983488 files, 895915/3933916 blocks
/dev/sda4: clean, 3449/1313280 files, 373878/5242880 blocks
ubuntu@ubuntu:~$ 
ubuntu@ubuntu:~$ 
ubuntu@ubuntu:~$ history
    1  date
    2  sudo parted -l
    3  time sudo fsck.jfs -f /dev/sdb1
    4  time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext2 -pv /dev/sda3 ; sudo fsck.ext2 -pv /dev/sda4
    5  history
<sck.ext2 -pv /dev/sda3 ; sudo fsck.ext2 -pv /dev/sda4                       
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
/dev/sda3: clean, 155703/983488 files, 895915/3933916 blocks
/dev/sda4: clean, 3449/1313280 files, 373878/5242880 blocks
ubuntu@ubuntu:~$ 

30 Sep 2011

not sure what happened. Kathy said the machine was off and she rebooted it. She answered a question, it finished booting, but then it wouldn't play any recordings. When I logged into the machine, /storage was not mounted. I booted from the CD and repaired the disk

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<fsck.jfs -f /dev/sdb1 ; time  sudo fsck.jfs -n /dev/sdb1                      
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 10/1/2011 3.35.56
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   279134 kilobytes in 121820 directories.
1453643882 kilobytes in 786700 user files.
        0 kilobytes in extended attributes
   954712 kilobytes reserved for system use.
499194012 kilobytes are available for use.
Filesystem is clean.
...|.....
real	3m19.823s
user	0m4.930s
sys	0m2.910s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 10/1/2011 3.39.15
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   279134 kilobytes in 121820 directories.
1453643882 kilobytes in 786700 user files.
        0 kilobytes in extended attributes
   954712 kilobytes reserved for system use.
499194012 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m41.068s
user	0m5.190s
sys	0m1.920s
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1                                   
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda3
/dev/sda3: clean, 158421/983488 files, 967246/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda4
/dev/sda4: clean, 5296/1313280 files, 444812/5242880 blocks

3 Nov 20111

just had a power outage. when I rebooted my mythtv, I had the same message about /storage, so I had to repair, again:

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<fsck.jfs -f /dev/sdb1 ; time sudo fsck.jfs -n /dev/sdb1                       
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 11/4/2011 3.37.12
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   279753 kilobytes in 121819 directories.
1545814193 kilobytes in 788138 user files.
        0 kilobytes in extended attributes
   956072 kilobytes reserved for system use.
407022960 kilobytes are available for use.
Filesystem is clean.
..|......
real	3m20.305s
user	0m4.990s
sys	0m2.880s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 11/4/2011 3.40.31
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   279753 kilobytes in 121819 directories.
1545814193 kilobytes in 788138 user files.
        0 kilobytes in extended attributes
   956072 kilobytes reserved for system use.
407022960 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m44.818s
user	0m5.370s
sys	0m2.020s
<ext2 -p /dev/sda1                                                           
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 223/628320 files (4.5% non-contiguous), 137568/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1                                   
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda3
/dev/sda3: clean, 158391/983488 files, 941738/3933916 blocks
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda4
/dev/sda4: clean, 5753/1313280 files, 466452/5242880 blocks
ubuntu@ubuntu:~$                                                                                         

the power went out a second time before I could reboot!!! So, I ran the commands again...

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<; sudo fsck.ext2 -p /dev/sda3 ; sudo fsck.ext2 -p /dev/sda4                   
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 11/4/2011 3.59.41
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   279753 kilobytes in 121819 directories.
1545814193 kilobytes in 788138 user files.
        0 kilobytes in extended attributes
   956072 kilobytes reserved for system use.
407022960 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real    2m45.050s
user    0m5.060s
sys    0m2.120s
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
/dev/sda3: clean, 158391/983488 files, 941738/3933916 blocks
/dev/sda4: clean, 5753/1313280 files, 466452/5242880 blocks
ubuntu@ubuntu:~$ history
    1  sudo parted -l
    2  time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext2 -p /dev/sda3 ; sudo fsck.ext2 -p /dev/sda4
    3  history

27 Nov 20111

I accidentally pressed the small button to the right of the big button with the blue light - that rebooted my machine :(

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

time sudo fsck.jfs -f /dev/sdb1 ; time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext2 -p /dev/sda3 ; sudo fsck.ext2 -p /dev/sda4

fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 11/28/2011 6.36.12
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   280358 kilobytes in 121821 directories.
1481145669 kilobytes in 789402 user files.
        0 kilobytes in extended attributes
   957429 kilobytes reserved for system use.
471690732 kilobytes are available for use.
Filesystem is clean.
.....|...
real	3m24.804s
user	0m4.920s
sys	0m3.190s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 11/28/2011 6.39.36
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   280358 kilobytes in 121821 directories.
1481145669 kilobytes in 789402 user files.
        0 kilobytes in extended attributes
   957429 kilobytes reserved for system use.
471690732 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m45.797s
user	0m4.860s
sys	0m2.170s
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 223/628320 files (4.5% non-contiguous), 137568/1256416 blocks
/dev/sda3: clean, 158402/983488 files, 941096/3933916 blocks
/dev/sda4: clean, 6163/1313280 files, 486655/5242880 blocks (check in 4 mounts)
ubuntu@ubuntu:~$ sudo fsck.ext2 -p /dev/sda1
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks


3 Dec 20111

I don't remember the story, but this transcript was stored in a file named =fsck1539.txt= dated 3 December 2011 7:40 AM

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<sda1 ; time sudo fsck.ext3 -p /dev/sda3 ; time sudo fsck.ext3 -p /dev/sda4          
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 12/3/2011 15.29.47
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
File system object FF600928 is linked as: /mythtv/recordings/1071_20111202100000.mpg
cannot repair the data format error(s) in this file.
cannot repair FF600928.  Will release.
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   280498 kilobytes in 121821 directories.
1450924680 kilobytes in 789777 user files.
        0 kilobytes in extended attributes
   957602 kilobytes reserved for system use.
501911688 kilobytes are available for use.
Filesystem is clean.
......|..
real	3m28.918s
user	0m4.890s
sys	0m3.120s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 12/3/2011 15.33.17
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   280498 kilobytes in 121821 directories.
1450924680 kilobytes in 789777 user files.
        0 kilobytes in extended attributes
   957602 kilobytes reserved for system use.
501911688 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m46.588s
user	0m5.020s
sys	0m1.980s
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks

real	0m2.656s
user	0m0.000s
sys	0m0.040s
/dev/sda3: clean, 158414/983488 files, 935458/3933916 blocks

real	0m0.716s
user	0m0.020s
sys	0m0.000s
/dev/sda4 has been mounted 21 times without being checked, check forced.
/dev/sda4: 6318/1313280 files (17.9% non-contiguous), 497458/5242880 blocks

real	0m27.069s
user	0m1.440s
sys	0m1.350s

4 Dec 20111

ubuntu@ubuntu:~$ sudo parted -l                                                
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<ev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4         
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 12/4/2011 14.25.9
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   280530 kilobytes in 121821 directories.
1450622150 kilobytes in 789821 user files.
        0 kilobytes in extended attributes
   957660 kilobytes reserved for system use.
502214192 kilobytes are available for use.
Filesystem is clean.
....|....
real	3m24.965s
user	0m4.860s
sys	0m2.910s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 12/4/2011 14.28.36
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   280530 kilobytes in 121821 directories.
1450622150 kilobytes in 789821 user files.
        0 kilobytes in extended attributes
   957660 kilobytes reserved for system use.
502214192 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m48.667s
user	0m4.940s
sys	0m2.100s
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 223/628320 files (4.5% non-contiguous), 137568/1256416 blocks
/dev/sda3: clean, 158668/983488 files, 943194/3933916 blocks
/dev/sda4: clean, 6329/1313280 files, 497861/5242880 blocks
ubuntu@ubuntu:~$ history
    1  sudo parted -l
    2  time sudo fsck.jfs -f /dev/sdb1 ; time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4
    3  history

6 Jan 2012

I ran some system updates but neede to repair jfs after reboot

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<ev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4           
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 1/6/2012 14.26.45
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   281124 kilobytes in 121824 directories.
1459764866 kilobytes in 791188 user files.
        0 kilobytes in extended attributes
   958962 kilobytes reserved for system use.
493070768 kilobytes are available for use.
Filesystem is clean.
.......|.
real	3m31.329s
user	0m4.670s
sys	0m3.070s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 1/6/2012 14.30.17
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   281124 kilobytes in 121824 directories.
1459764866 kilobytes in 791188 user files.
        0 kilobytes in extended attributes
   958962 kilobytes reserved for system use.
493070768 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m48.799s
user	0m5.180s
sys	0m1.940s
/dev/sda1 was not cleanly unmounted, check forced.
/dev/sda1: 223/628320 files (4.5% non-contiguous), 137568/1256416 blocks
/dev/sda3: clean, 158542/983488 files, 997355/3933916 blocks
/dev/sda4: clean, 6656/1313280 files, 516586/5242880 blocks
ubuntu@ubuntu:~$ history
    1  sudo parted -l
    2  time sudo fsck.jfs -f /dev/sdb1 ; time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4
    3  history

8 Feb 2012

I came home from work and my niece told me that the system had locked up. A frame from Saturday Night live was on the screen and the system was unresponsive. i rebooted and was greeted with a message about serious issues found on /dev/storage

ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<ev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4           
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 2/9/2012 2.42.34
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   283611 kilobytes in 121983 directories.
1444626518 kilobytes in 793628 user files.
        0 kilobytes in extended attributes
   964717 kilobytes reserved for system use.
508205848 kilobytes are available for use.
Filesystem is clean.
...|.....
real	3m35.063s
user	0m4.630s
sys	0m3.160s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 2/9/2012 2.46.10
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   283611 kilobytes in 121983 directories.
1444626518 kilobytes in 793628 user files.
        0 kilobytes in extended attributes
   964717 kilobytes reserved for system use.
508205848 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m53.672s
user	0m4.930s
sys	0m2.170s
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
/dev/sda3: clean, 158507/983488 files, 955923/3933916 blocks
/dev/sda4: clean, 7425/1313280 files, 576179/5242880 blocks
ubuntu@ubuntu:~$ sudo parted -l
Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sda: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3


Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sdb: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Warning: Unable to open /dev/sr0 read-write (Read-only file system).  /dev/sr0
has been opened read-only.
Error: /dev/sr0: unrecognised disk label                                  

<ev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4           
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 2/9/2012 2.42.34
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   283611 kilobytes in 121983 directories.
1444626518 kilobytes in 793628 user files.
        0 kilobytes in extended attributes
   964717 kilobytes reserved for system use.
508205848 kilobytes are available for use.
Filesystem is clean.
...|.....
real	3m35.063s
user	0m4.630s
sys	0m3.160s
fsck.jfs version 1.1.12, 24-Aug-2007
processing started: 2/9/2012 2.46.10
The current device is:  /dev/sdb1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
**Phase 7 - Verify File/Directory Allocation Maps
**Phase 8 - Verify Disk Allocation Maps
1953513472 kilobytes total disk space.
   283611 kilobytes in 121983 directories.
1444626518 kilobytes in 793628 user files.
        0 kilobytes in extended attributes
   964717 kilobytes reserved for system use.
508205848 kilobytes are available for use.
File system checked READ ONLY.
Filesystem is clean.

real	2m53.672s
user	0m4.930s
sys	0m2.170s
/dev/sda1: clean, 223/628320 files, 137568/1256416 blocks
/dev/sda3: clean, 158507/983488 files, 955923/3933916 blocks
/dev/sda4: clean, 7425/1313280 files, 576179/5242880 blocks

    1  sudo parted -l
    2  time sudo fsck.jfs -f /dev/sdb1 ; time sudo fsck.jfs -n /dev/sdb1 ; sudo fsck.ext2 -p /dev/sda1 ; sudo fsck.ext3 -p /dev/sda3 ; sudo fsck.ext3 -p /dev/sda4

database repair

29 Sep 2011

I came home in the evening and discovered that my recordings had disappeared!! I figured that the problem was my database, so I got to work restoring it. I went and read up at Database_Backup_and_Restore#Replacing_an_existing_database

I stopped the backend with sudo service mythtv-backend stop

I went and looked in my backuprc directory: DBBackupDirectory=/storage/backups/myth/ and found these

$ ls -Ftl /storage/backups/myth/ | head
total 841808
-rw-r--r-- 1 root root 25035043 2011-09-29 08:01 mythconverg-1254-20110929080125.sql.gz
-rw-r--r-- 1 root root 25143802 2011-09-28 07:51 mythconverg-1254-20110928075102.sql.gz
-rw-r--r-- 1 root root 25108974 2011-09-27 08:09 mythconverg-270-11.sql.gz
-rw-r--r-- 1 root root 25107088 2011-09-27 08:06 mythconverg-1254-20110927080629.sql.gz
-rw-r--r-- 1 root root 25361448 2011-09-26 08:02 mythconverg-1254-20110926080153.sql.gz

I made a backup of my current database, just in case:

$ mythconverg_backup.pl --verbose
[SNIP]
Deleting 16 and keeping (up to) 5 backup files.
[SNIP]

oops!! I didn't want it to delta my old backup files :( oh well. I tried the restore

$ ./mythconverg_restore.pl --directory /storage/backups/myth/ --filename mythconverg-1254-20110929080125.sql.gz

ERROR: Unable to do a full restore. The database contains data.

after looking around a bit, in particular: http://ubuntuforums.org/showthread.php?t=1580142 I found I needed this command:

ttttt@hoosst:~$ ./mythconverg_restore.pl  --drop_database   --create_database  --verbose --directory /storage/backups/myth/ --filename mythconverg-1254-20110929080125.sql.gz

Configuring environment:
  -    username: ttttt
  -        HOME: /home/ttttt
  - MYTHCONFDIR: /home/ttttt/.mythtv

Parsing configuration files:
  - checking: /home/ttttt/.mythtv/config.xml
     parsing: /home/ttttt/.mythtv/config.xml
  - checking: /home/ttttt/.mythtv/backuprc
     parsing: /home/ttttt/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

Database Information:
         DBHostName: localhost
             DBPort: 0
         DBUserName: mythtv
         DBPassword: XXX
             DBName: mythconverg
        DBSchemaVer: 
  DBBackupDirectory: /storage/backups/myth/
   DBBackupFilename: mythconverg-1254-20110929080125.sql.gz
      drop_database: yes
    create_database: yes

Executables:
       mysql_client: mysql
         uncompress: gzip -d

Miscellaneous:
    partial_restore: no
   restore_xmltvids: no
    change_hostname: no

Checking database.

Preparing initial database.
Dropping database.
Creating database.
Setting database character set.

Found 0 tables in the database.

Backup file is compressed.
 - Uncompressing backup file with IO::Uncompress::Gunzip.

Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.

Executing command:
'mysql' --defaults-extra-file='/tmp/jP_6V60oxA' --host='localhost' --user='mythtv' 'mythconverg'

mysql exited with status: 0

Restored 3172 of 3172 lines.

Successfully restored backup.

Found DBSchemaVer: 1254.
Setting database character set.
ttttt@hoosst:~$ 

I restarted the backend with sudo service mythtv-backend start. Since 'someone' was watching a DVD, I checked the mythweb website and saw the listings I expected :) hopefully the fronted shows this list, too!

7 Dec 2011

This evening my wife reported that the list of recorded programs was messed up. I needed to fix the database. The problem was likely caused by recent power outages.

I checked my list of database backups

$ ls -Ftl /storage/backups/myth/ | head
total 1193936
-rw-r--r-- 1 root root 27140333 2011-12-07 07:48 mythconverg-1254-20111207074815.sql.gz
-rw-r--r-- 1 root root 26816433 2011-12-06 07:52 mythconverg-340-11.sql.gz
-rw-r--r-- 1 root root 26816446 2011-12-06 07:49 mythconverg-1254-20111206074906.sql.gz
-rw-r--r-- 1 root root 27678464 2011-12-05 08:06 mythconverg-1254-20111205080615.sql.gz
-rw-r--r-- 1 root root 27823570 2011-12-04 06:54 mythconverg-1254-20111204065432.sql.gz
-rw-r--r-- 1 root root 27008777 2011-12-03 08:37 mythconverg-1254-20111203083704.sql.gz
-rw-r--r-- 1 root root 27301674 2011-12-01 07:28 mythconverg-1254-20111201072750.sql.gz
-rw-r--r-- 1 root root 27571056 2011-11-30 08:01 mythconverg-1254-20111130080104.sql.gz
-rw-r--r-- 1 root root 28130065 2011-11-29 07:51 mythconverg-333-11.sql.gz

then I did an extra database backup

$ /home/tttt/mythconverg_backup.pl --directory /storage/backups/myth/ --rotate 25
$ sudo service mythtv-backend stop
mythtv-backend stop/waiting
$ /home/tttt/mythconverg_backup.pl --directory /storage/backups/myth/ --rotate 25

and then I ran the restore script


$ ./mythconverg_restore.pl  --drop_database   --create_database  --verbose --directory /storage/backups/myth/ --filename mythconverg-1254-20111206074906.sql.gz

Configuring environment:
  -    username: tttt
  -        HOME: /home/tttt
  - MYTHCONFDIR: /home/tttt/.mythtv

Parsing configuration files:
  - checking: /home/tttt/.mythtv/config.xml
     parsing: /home/tttt/.mythtv/config.xml
  - checking: /home/tttt/.mythtv/backuprc
     parsing: /home/tttt/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

Database Information:
         DBHostName: localhost
             DBPort: 0
         DBUserName: xxxx
         DBPassword: XXX
             DBName: xxxxx
        DBSchemaVer: 
  DBBackupDirectory: /storage/backups/myth/
   DBBackupFilename: mythconverg-1254-20111206074906.sql.gz
      drop_database: yes
    create_database: yes

Executables:
       mysql_client: mysql
         uncompress: gzip -d

Miscellaneous:
    partial_restore: no
   restore_xmltvids: no
    change_hostname: no

Checking database.

Preparing initial database.
Dropping database.
Creating database.
Setting database character set.

Found 0 tables in the database.

Backup file is compressed.
 - Uncompressing backup file with IO::Uncompress::Gunzip.

Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.

Executing command:
'mysql' --defaults-extra-file='/tmp/VP1JIvIENX' --host='localhost' --user='mythtv' 'mythconverg'

mysql exited with status: 0

Restored 3176 of 3176 lines.

Successfully restored backup.

Found DBSchemaVer: 1254.
Setting database character set.

I figured it might be a good idea to optimize the database

$ sudo service mythtv-backend stopstop: Unknown instance: 

$ /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
Repaired/Optimized: `mythconverg`.`archiveitems`
Analyzed: `mythconverg`.`archiveitems`
Repaired/Optimized: `mythconverg`.`callsignnetworkmap`
Analyzed: `mythconverg`.`callsignnetworkmap`
Repaired/Optimized: `mythconverg`.`capturecard`
Analyzed: `mythconverg`.`capturecard`
Repaired/Optimized: `mythconverg`.`cardinput`
Analyzed: `mythconverg`.`cardinput`
Repaired/Optimized: `mythconverg`.`channel`
Analyzed: `mythconverg`.`channel`
Repaired/Optimized: `mythconverg`.`channelgroup`
Analyzed: `mythconverg`.`channelgroup`
Repaired/Optimized: `mythconverg`.`channelgroupnames`
Analyzed: `mythconverg`.`channelgroupnames`
Repaired/Optimized: `mythconverg`.`channelscan`
Analyzed: `mythconverg`.`channelscan`
Repaired/Optimized: `mythconverg`.`channelscan_channel`
Analyzed: `mythconverg`.`channelscan_channel`
Repaired/Optimized: `mythconverg`.`channelscan_dtv_multiplex`
Analyzed: `mythconverg`.`channelscan_dtv_multiplex`
Repaired/Optimized: `mythconverg`.`codecparams`
Analyzed: `mythconverg`.`codecparams`
Repaired/Optimized: `mythconverg`.`credits`
Analyzed: `mythconverg`.`credits`
Repaired/Optimized: `mythconverg`.`customexample`
Analyzed: `mythconverg`.`customexample`
Repaired/Optimized: `mythconverg`.`diseqc_config`
Analyzed: `mythconverg`.`diseqc_config`
Repaired/Optimized: `mythconverg`.`diseqc_tree`
Analyzed: `mythconverg`.`diseqc_tree`
Repaired/Optimized: `mythconverg`.`displayprofilegroups`
Analyzed: `mythconverg`.`displayprofilegroups`
Repaired/Optimized: `mythconverg`.`displayprofiles`
Analyzed: `mythconverg`.`displayprofiles`
Repaired/Optimized: `mythconverg`.`dtv_multiplex`
Analyzed: `mythconverg`.`dtv_multiplex`
Repaired/Optimized: `mythconverg`.`dtv_privatetypes`
Analyzed: `mythconverg`.`dtv_privatetypes`
Repaired/Optimized: `mythconverg`.`dvdbookmark`
Analyzed: `mythconverg`.`dvdbookmark`
Repaired/Optimized: `mythconverg`.`dvdinput`
Analyzed: `mythconverg`.`dvdinput`
Repaired/Optimized: `mythconverg`.`dvdtranscode`
Analyzed: `mythconverg`.`dvdtranscode`
Repaired/Optimized: `mythconverg`.`eit_cache`
Analyzed: `mythconverg`.`eit_cache`
Repaired/Optimized: `mythconverg`.`filemarkup`
Analyzed: `mythconverg`.`filemarkup`
Repaired/Optimized: `mythconverg`.`gallerymetadata`
Analyzed: `mythconverg`.`gallerymetadata`
Repaired/Optimized: `mythconverg`.`gamemetadata`
Analyzed: `mythconverg`.`gamemetadata`
Repaired/Optimized: `mythconverg`.`gameplayers`
Analyzed: `mythconverg`.`gameplayers`
Repaired/Optimized: `mythconverg`.`housekeeping`
Analyzed: `mythconverg`.`housekeeping`
Repaired/Optimized: `mythconverg`.`inputgroup`
Analyzed: `mythconverg`.`inputgroup`
Repaired/Optimized: `mythconverg`.`inuseprograms`
Analyzed: `mythconverg`.`inuseprograms`
Repaired/Optimized: `mythconverg`.`jobqueue`
Analyzed: `mythconverg`.`jobqueue`
Repaired/Optimized: `mythconverg`.`jumppoints`
Analyzed: `mythconverg`.`jumppoints`
Repaired/Optimized: `mythconverg`.`keybindings`
Analyzed: `mythconverg`.`keybindings`
Repaired/Optimized: `mythconverg`.`keyword`
Analyzed: `mythconverg`.`keyword`
Repaired/Optimized: `mythconverg`.`movies_movies`
Analyzed: `mythconverg`.`movies_movies`
Repaired/Optimized: `mythconverg`.`movies_showtimes`
Analyzed: `mythconverg`.`movies_showtimes`
Repaired/Optimized: `mythconverg`.`movies_theaters`
Analyzed: `mythconverg`.`movies_theaters`
Repaired/Optimized: `mythconverg`.`music_albumart`
Analyzed: `mythconverg`.`music_albumart`
Repaired/Optimized: `mythconverg`.`music_albums`
Analyzed: `mythconverg`.`music_albums`
Repaired/Optimized: `mythconverg`.`music_artists`
Analyzed: `mythconverg`.`music_artists`
Repaired/Optimized: `mythconverg`.`music_directories`
Analyzed: `mythconverg`.`music_directories`
Repaired/Optimized: `mythconverg`.`music_genres`
Analyzed: `mythconverg`.`music_genres`
Repaired/Optimized: `mythconverg`.`music_playlists`
Analyzed: `mythconverg`.`music_playlists`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_categories`
Analyzed: `mythconverg`.`music_smartplaylist_categories`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_items`
Analyzed: `mythconverg`.`music_smartplaylist_items`
Repaired/Optimized: `mythconverg`.`music_smartplaylists`
Analyzed: `mythconverg`.`music_smartplaylists`
Repaired/Optimized: `mythconverg`.`music_songs`
Analyzed: `mythconverg`.`music_songs`
Repaired/Optimized: `mythconverg`.`music_stats`
Analyzed: `mythconverg`.`music_stats`
Repaired/Optimized: `mythconverg`.`mythlog`
Analyzed: `mythconverg`.`mythlog`
Repaired/Optimized: `mythconverg`.`mythweb_sessions`
Analyzed: `mythconverg`.`mythweb_sessions`
Repaired/Optimized: `mythconverg`.`networkiconmap`
Analyzed: `mythconverg`.`networkiconmap`
Repaired/Optimized: `mythconverg`.`oldfind`
Analyzed: `mythconverg`.`oldfind`
Repaired/Optimized: `mythconverg`.`oldprogram`
Analyzed: `mythconverg`.`oldprogram`
Repaired/Optimized: `mythconverg`.`oldrecorded`
Analyzed: `mythconverg`.`oldrecorded`
Repaired/Optimized: `mythconverg`.`people`
Analyzed: `mythconverg`.`people`
Repaired/Optimized: `mythconverg`.`phonecallhistory`
Analyzed: `mythconverg`.`phonecallhistory`
Repaired/Optimized: `mythconverg`.`phonedirectory`
Analyzed: `mythconverg`.`phonedirectory`
Repaired/Optimized: `mythconverg`.`pidcache`
Analyzed: `mythconverg`.`pidcache`
Repaired/Optimized: `mythconverg`.`playgroup`
Analyzed: `mythconverg`.`playgroup`
Repaired/Optimized: `mythconverg`.`powerpriority`
Analyzed: `mythconverg`.`powerpriority`
Repaired/Optimized: `mythconverg`.`profilegroups`
Analyzed: `mythconverg`.`profilegroups`
Repaired/Optimized: `mythconverg`.`program`
Analyzed: `mythconverg`.`program`
Repaired/Optimized: `mythconverg`.`programgenres`
Analyzed: `mythconverg`.`programgenres`
Repaired/Optimized: `mythconverg`.`programrating`
Analyzed: `mythconverg`.`programrating`
Repaired/Optimized: `mythconverg`.`recgrouppassword`
Analyzed: `mythconverg`.`recgrouppassword`
Repaired/Optimized: `mythconverg`.`record`
Analyzed: `mythconverg`.`record`
Repaired/Optimized: `mythconverg`.`record_tmp`
Analyzed: `mythconverg`.`record_tmp`
Repaired/Optimized: `mythconverg`.`recorded`
Analyzed: `mythconverg`.`recorded`
Repaired/Optimized: `mythconverg`.`recordedcredits`
Analyzed: `mythconverg`.`recordedcredits`
Repaired/Optimized: `mythconverg`.`recordedfile`
Analyzed: `mythconverg`.`recordedfile`
Repaired/Optimized: `mythconverg`.`recordedmarkup`
Analyzed: `mythconverg`.`recordedmarkup`
Repaired/Optimized: `mythconverg`.`recordedprogram`
Analyzed: `mythconverg`.`recordedprogram`
Repaired/Optimized: `mythconverg`.`recordedrating`
Analyzed: `mythconverg`.`recordedrating`
Repaired/Optimized: `mythconverg`.`recordedseek`
Analyzed: `mythconverg`.`recordedseek`
Repaired/Optimized: `mythconverg`.`recordingprofiles`
Analyzed: `mythconverg`.`recordingprofiles`
Repaired/Optimized: `mythconverg`.`recordmatch`
Analyzed: `mythconverg`.`recordmatch`
Repaired/Optimized: `mythconverg`.`romdb`
Analyzed: `mythconverg`.`romdb`
Repaired/Optimized: `mythconverg`.`schemalock`
Analyzed: `mythconverg`.`schemalock`
Repaired/Optimized: `mythconverg`.`settings`
Analyzed: `mythconverg`.`settings`
Repaired/Optimized: `mythconverg`.`storagegroup`
Analyzed: `mythconverg`.`storagegroup`
Repaired/Optimized: `mythconverg`.`tvchain`
Analyzed: `mythconverg`.`tvchain`
Repaired/Optimized: `mythconverg`.`tvosdmenu`
Analyzed: `mythconverg`.`tvosdmenu`
Repaired/Optimized: `mythconverg`.`upnpmedia`
Analyzed: `mythconverg`.`upnpmedia`
Repaired/Optimized: `mythconverg`.`videocast`
Analyzed: `mythconverg`.`videocast`
Repaired/Optimized: `mythconverg`.`videocategory`
Analyzed: `mythconverg`.`videocategory`
Repaired/Optimized: `mythconverg`.`videocountry`
Analyzed: `mythconverg`.`videocountry`
Repaired/Optimized: `mythconverg`.`videogenre`
Analyzed: `mythconverg`.`videogenre`
Repaired/Optimized: `mythconverg`.`videometadata`
Analyzed: `mythconverg`.`videometadata`
Repaired/Optimized: `mythconverg`.`videometadatacast`
Analyzed: `mythconverg`.`videometadatacast`
Repaired/Optimized: `mythconverg`.`videometadatacountry`
Analyzed: `mythconverg`.`videometadatacountry`
Repaired/Optimized: `mythconverg`.`videometadatagenre`
Analyzed: `mythconverg`.`videometadatagenre`
Repaired/Optimized: `mythconverg`.`videosource`
Analyzed: `mythconverg`.`videosource`
Repaired/Optimized: `mythconverg`.`videotypes`
Analyzed: `mythconverg`.`videotypes`
Repaired/Optimized: `mythconverg`.`weatherdatalayout`
Analyzed: `mythconverg`.`weatherdatalayout`
Repaired/Optimized: `mythconverg`.`weatherscreens`
Analyzed: `mythconverg`.`weatherscreens`
Repaired/Optimized: `mythconverg`.`weathersourcesettings`
Analyzed: `mythconverg`.`weathersourcesettings`
and then I started the backend
sudo service mythtv-backend start

14 Feb 2012

I accessed my mythtv box and found only a few items in the menu of recorded programs :( It must be time for a restoration of the database!

$ sudo service mythtv-backend stop
[sudo] password for ttttt: 
mythtv-backend stop/waiting

$ ls -Ftl /storage/backups/myth/ | head
total 1432112
-rw-r--r-- 1 root root 27524213 2012-02-13 07:43 mythconverg-1254-20120213074249.sql.gz
-rw-r--r-- 1 root root 27589479 2012-02-12 07:44 mythconverg-1254-20120212074340.sql.gz
-rw-r--r-- 1 root root 27827504 2012-02-11 07:41 mythconverg-1254-20120211074051.sql.gz
-rw-r--r-- 1 root root 27650747 2012-02-10 07:45 mythconverg-1254-20120210074459.sql.gz
-rw-r--r-- 1 root root 27737840 2012-02-09 07:39 mythconverg-1254-20120209073933.sql.gz
-rw-r--r-- 1 root root 27522239 2012-02-08 07:45 mythconverg-1254-20120208074502.sql.gz
-rw-r--r-- 1 root root 27384911 2012-02-07 08:05 mythconverg-038-12.sql.gz
-rw-r--r-- 1 root root 27381294 2012-02-07 08:03 mythconverg-1254-20120207080241.sql.gz
-rw-r--r-- 1 root root 27429067 2012-02-06 07:47 mythconverg-1254-20120206074717.sql.gz

$ /home/tttt/mythconverg_backup.pl --directory /storage/backups/myth/ --rotate 25

and now the actual work

$ ./mythconverg_restore.pl  --drop_database   --create_database  --verbose --directory /storage/backups/myth/ --filename mythconverg-1254-20120213074249.sql.gz

Configuring environment:
  -    username: tttt
  -        HOME: /home/tttt
  - MYTHCONFDIR: /home/tttt/.mythtv

Parsing configuration files:
  - checking: /home/tttt/.mythtv/config.xml
     parsing: /home/tttt/.mythtv/config.xml
  - checking: /home/tttt/.mythtv/backuprc
     parsing: /home/tttt/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

Database Information:
         DBHostName: localhost
             DBPort: 0
         DBUserName: mythtv
         DBPassword: XXX
             DBName: mythconverg
        DBSchemaVer: 
  DBBackupDirectory: /storage/backups/myth/
   DBBackupFilename: mythconverg-1254-20120213074249.sql.gz
      drop_database: yes
    create_database: yes

Executables:
       mysql_client: mysql
         uncompress: gzip -d

Miscellaneous:
    partial_restore: no
   restore_xmltvids: no
    change_hostname: no

Checking database.

Preparing initial database.
Dropping database.
Creating database.
Setting database character set.

Found 0 tables in the database.

Backup file is compressed.
 - Uncompressing backup file with IO::Uncompress::Gunzip.

Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.

Executing command:
'mysql' --defaults-extra-file='/tmp/ZXdP2ZSy8C' --host='localhost' --user='mythtv' 'mythconverg'

mysql exited with status: 0

Restored 3179 of 3179 lines.

Successfully restored backup.

Found DBSchemaVer: 1254.
Setting database character set.

and an optimization

$ time /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
Repaired/Optimized: `mythconverg`.`archiveitems`
Analyzed: `mythconverg`.`archiveitems`
Repaired/Optimized: `mythconverg`.`callsignnetworkmap`
Analyzed: `mythconverg`.`callsignnetworkmap`
Repaired/Optimized: `mythconverg`.`capturecard`
Analyzed: `mythconverg`.`capturecard`
Repaired/Optimized: `mythconverg`.`cardinput`
Analyzed: `mythconverg`.`cardinput`
Repaired/Optimized: `mythconverg`.`channel`
Analyzed: `mythconverg`.`channel`
Repaired/Optimized: `mythconverg`.`channelgroup`
Analyzed: `mythconverg`.`channelgroup`
Repaired/Optimized: `mythconverg`.`channelgroupnames`
Analyzed: `mythconverg`.`channelgroupnames`
Repaired/Optimized: `mythconverg`.`channelscan`
Analyzed: `mythconverg`.`channelscan`
Repaired/Optimized: `mythconverg`.`channelscan_channel`
Analyzed: `mythconverg`.`channelscan_channel`
Repaired/Optimized: `mythconverg`.`channelscan_dtv_multiplex`
Analyzed: `mythconverg`.`channelscan_dtv_multiplex`
Repaired/Optimized: `mythconverg`.`codecparams`
Analyzed: `mythconverg`.`codecparams`
Repaired/Optimized: `mythconverg`.`credits`
Analyzed: `mythconverg`.`credits`
Repaired/Optimized: `mythconverg`.`customexample`
Analyzed: `mythconverg`.`customexample`
Repaired/Optimized: `mythconverg`.`diseqc_config`
Analyzed: `mythconverg`.`diseqc_config`
Repaired/Optimized: `mythconverg`.`diseqc_tree`
Analyzed: `mythconverg`.`diseqc_tree`
Repaired/Optimized: `mythconverg`.`displayprofilegroups`
Analyzed: `mythconverg`.`displayprofilegroups`
Repaired/Optimized: `mythconverg`.`displayprofiles`
Analyzed: `mythconverg`.`displayprofiles`
Repaired/Optimized: `mythconverg`.`dtv_multiplex`
Analyzed: `mythconverg`.`dtv_multiplex`
Repaired/Optimized: `mythconverg`.`dtv_privatetypes`
Analyzed: `mythconverg`.`dtv_privatetypes`
Repaired/Optimized: `mythconverg`.`dvdbookmark`
Analyzed: `mythconverg`.`dvdbookmark`
Repaired/Optimized: `mythconverg`.`dvdinput`
Analyzed: `mythconverg`.`dvdinput`
Repaired/Optimized: `mythconverg`.`dvdtranscode`
Analyzed: `mythconverg`.`dvdtranscode`
Repaired/Optimized: `mythconverg`.`eit_cache`
Analyzed: `mythconverg`.`eit_cache`
Repaired/Optimized: `mythconverg`.`filemarkup`
Analyzed: `mythconverg`.`filemarkup`
Repaired/Optimized: `mythconverg`.`gallerymetadata`
Analyzed: `mythconverg`.`gallerymetadata`
Repaired/Optimized: `mythconverg`.`gamemetadata`
Analyzed: `mythconverg`.`gamemetadata`
Repaired/Optimized: `mythconverg`.`gameplayers`
Analyzed: `mythconverg`.`gameplayers`
Repaired/Optimized: `mythconverg`.`housekeeping`
Analyzed: `mythconverg`.`housekeeping`
Repaired/Optimized: `mythconverg`.`inputgroup`
Analyzed: `mythconverg`.`inputgroup`
Repaired/Optimized: `mythconverg`.`inuseprograms`
Analyzed: `mythconverg`.`inuseprograms`
Repaired/Optimized: `mythconverg`.`jobqueue`
Analyzed: `mythconverg`.`jobqueue`
Repaired/Optimized: `mythconverg`.`jumppoints`
Analyzed: `mythconverg`.`jumppoints`
Repaired/Optimized: `mythconverg`.`keybindings`
Analyzed: `mythconverg`.`keybindings`
Repaired/Optimized: `mythconverg`.`keyword`
Analyzed: `mythconverg`.`keyword`
Repaired/Optimized: `mythconverg`.`movies_movies`
Analyzed: `mythconverg`.`movies_movies`
Repaired/Optimized: `mythconverg`.`movies_showtimes`
Analyzed: `mythconverg`.`movies_showtimes`
Repaired/Optimized: `mythconverg`.`movies_theaters`
Analyzed: `mythconverg`.`movies_theaters`
Repaired/Optimized: `mythconverg`.`music_albumart`
Analyzed: `mythconverg`.`music_albumart`
Repaired/Optimized: `mythconverg`.`music_albums`
Analyzed: `mythconverg`.`music_albums`
Repaired/Optimized: `mythconverg`.`music_artists`
Analyzed: `mythconverg`.`music_artists`
Repaired/Optimized: `mythconverg`.`music_directories`
Analyzed: `mythconverg`.`music_directories`
Repaired/Optimized: `mythconverg`.`music_genres`
Analyzed: `mythconverg`.`music_genres`
Repaired/Optimized: `mythconverg`.`music_playlists`
Analyzed: `mythconverg`.`music_playlists`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_categories`
Analyzed: `mythconverg`.`music_smartplaylist_categories`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_items`
Analyzed: `mythconverg`.`music_smartplaylist_items`
Repaired/Optimized: `mythconverg`.`music_smartplaylists`
Analyzed: `mythconverg`.`music_smartplaylists`
Repaired/Optimized: `mythconverg`.`music_songs`
Analyzed: `mythconverg`.`music_songs`
Repaired/Optimized: `mythconverg`.`music_stats`
Analyzed: `mythconverg`.`music_stats`
Repaired/Optimized: `mythconverg`.`mythlog`
Analyzed: `mythconverg`.`mythlog`
Repaired/Optimized: `mythconverg`.`mythweb_sessions`
Analyzed: `mythconverg`.`mythweb_sessions`
Repaired/Optimized: `mythconverg`.`networkiconmap`
Analyzed: `mythconverg`.`networkiconmap`
Repaired/Optimized: `mythconverg`.`oldfind`
Analyzed: `mythconverg`.`oldfind`
Repaired/Optimized: `mythconverg`.`oldprogram`
Analyzed: `mythconverg`.`oldprogram`
Repaired/Optimized: `mythconverg`.`oldrecorded`
Analyzed: `mythconverg`.`oldrecorded`
Repaired/Optimized: `mythconverg`.`people`
Analyzed: `mythconverg`.`people`
Repaired/Optimized: `mythconverg`.`phonecallhistory`
Analyzed: `mythconverg`.`phonecallhistory`
Repaired/Optimized: `mythconverg`.`phonedirectory`
Analyzed: `mythconverg`.`phonedirectory`
Repaired/Optimized: `mythconverg`.`pidcache`
Analyzed: `mythconverg`.`pidcache`
Repaired/Optimized: `mythconverg`.`playgroup`
Analyzed: `mythconverg`.`playgroup`
Repaired/Optimized: `mythconverg`.`powerpriority`
Analyzed: `mythconverg`.`powerpriority`
Repaired/Optimized: `mythconverg`.`profilegroups`
Analyzed: `mythconverg`.`profilegroups`
Repaired/Optimized: `mythconverg`.`program`
Analyzed: `mythconverg`.`program`
Repaired/Optimized: `mythconverg`.`programgenres`
Analyzed: `mythconverg`.`programgenres`
Repaired/Optimized: `mythconverg`.`programrating`
Analyzed: `mythconverg`.`programrating`
Repaired/Optimized: `mythconverg`.`recgrouppassword`
Analyzed: `mythconverg`.`recgrouppassword`
Repaired/Optimized: `mythconverg`.`record`
Analyzed: `mythconverg`.`record`
Repaired/Optimized: `mythconverg`.`record_tmp`
Analyzed: `mythconverg`.`record_tmp`
Repaired/Optimized: `mythconverg`.`recorded`
Analyzed: `mythconverg`.`recorded`
Repaired/Optimized: `mythconverg`.`recordedcredits`
Analyzed: `mythconverg`.`recordedcredits`
Repaired/Optimized: `mythconverg`.`recordedfile`
Analyzed: `mythconverg`.`recordedfile`
Repaired/Optimized: `mythconverg`.`recordedmarkup`
Analyzed: `mythconverg`.`recordedmarkup`
Repaired/Optimized: `mythconverg`.`recordedprogram`
Analyzed: `mythconverg`.`recordedprogram`
Repaired/Optimized: `mythconverg`.`recordedrating`
Analyzed: `mythconverg`.`recordedrating`
Repaired/Optimized: `mythconverg`.`recordedseek`
Analyzed: `mythconverg`.`recordedseek`
Repaired/Optimized: `mythconverg`.`recordingprofiles`
Analyzed: `mythconverg`.`recordingprofiles`
Repaired/Optimized: `mythconverg`.`recordmatch`
Analyzed: `mythconverg`.`recordmatch`
Repaired/Optimized: `mythconverg`.`romdb`
Analyzed: `mythconverg`.`romdb`
Repaired/Optimized: `mythconverg`.`schemalock`
Analyzed: `mythconverg`.`schemalock`
Repaired/Optimized: `mythconverg`.`settings`
Analyzed: `mythconverg`.`settings`
Repaired/Optimized: `mythconverg`.`storagegroup`
Analyzed: `mythconverg`.`storagegroup`
Repaired/Optimized: `mythconverg`.`tvchain`
Analyzed: `mythconverg`.`tvchain`
Repaired/Optimized: `mythconverg`.`tvosdmenu`
Analyzed: `mythconverg`.`tvosdmenu`
Repaired/Optimized: `mythconverg`.`upnpmedia`
Analyzed: `mythconverg`.`upnpmedia`
Repaired/Optimized: `mythconverg`.`videocast`
Analyzed: `mythconverg`.`videocast`
Repaired/Optimized: `mythconverg`.`videocategory`
Analyzed: `mythconverg`.`videocategory`
Repaired/Optimized: `mythconverg`.`videocountry`
Analyzed: `mythconverg`.`videocountry`
Repaired/Optimized: `mythconverg`.`videogenre`
Analyzed: `mythconverg`.`videogenre`
Repaired/Optimized: `mythconverg`.`videometadata`
Analyzed: `mythconverg`.`videometadata`
Repaired/Optimized: `mythconverg`.`videometadatacast`
Analyzed: `mythconverg`.`videometadatacast`
Repaired/Optimized: `mythconverg`.`videometadatacountry`
Analyzed: `mythconverg`.`videometadatacountry`
Repaired/Optimized: `mythconverg`.`videometadatagenre`
Analyzed: `mythconverg`.`videometadatagenre`
Repaired/Optimized: `mythconverg`.`videosource`
Analyzed: `mythconverg`.`videosource`
Repaired/Optimized: `mythconverg`.`videotypes`
Analyzed: `mythconverg`.`videotypes`
Repaired/Optimized: `mythconverg`.`weatherdatalayout`
Analyzed: `mythconverg`.`weatherdatalayout`
Repaired/Optimized: `mythconverg`.`weatherscreens`
Analyzed: `mythconverg`.`weatherscreens`
Repaired/Optimized: `mythconverg`.`weathersourcesettings`
Analyzed: `mythconverg`.`weathersourcesettings`

real	0m22.365s
user	0m0.160s
sys	0m0.000s

and then I started the backend

sudo service mythtv-backend start