Important ZFS Migration Gotcha

I'm making a note of this.  I am still working on ZFS migration strategies in my spare time.  The snapshots are really important!  I ran a zfs send @snapshot and piped it to a zfs recieve and then had planned on running another zfs send with an incremental.  However, I tried to do this from memory ("You just add an '-i' - right?"  No!)  I got confused and deleted the target snapshot.  This is bad if you want to send an incremental.  Plus- more importantly - I wouldn't have gotten the confusing error if I had send the incremental like this:

    # zfs send -i store/messaging@today store/messaging@L8R ...

I was simply running the first command - "send the snapshot".  You have to say "-i" but you are saying I want an incremental of the earlier snapshot (@today), use the later snapshot (cleverly named @L8R) to create the delta.  Whew!  Glad I caught that in time.  Test systems are good!

This is why I wear my veil

I hate it when this happens!  Ha! Saw this on Linda's Bee Journal and couldn't resist re-posting it.

Socialization

I saw this rerun of a Peanuts cartoon and it reminded me of this blog: No Thank You, We Don't Believe in Socialization!  The author points out a perspective not many have considered on the way "socialization" is "implemented" in the current public schools.  The old "one room schools" seem to us outmoded but maybe they had more to offer than meets the eye.

Milano gets yet another super

I ran home and added a honey super to Milano at lunch.  Wow!  This was a newly installed package - mid April - and they are doing terrific!  They were packed in there.  Harvested a bit of honey comb too and we all sampled it.  I can't understand why it is so much better than the stuff from the grocery - but it is!  I love these bees!  They are so nice!  I popped the top and pulled a frame and scraped out some comb and no one got angry.  None of them tried to sting me or follow me.  Wow!  It'll be a long time before I ever buy any non-Italian packages again!

Perl and SQLite

Finally got around to finishing my little SQLite and Perl program.  To speed things up, I used a shell script with remote SSH commands to grab the data, then used Perl to stuff it into SQLite.  Very cool!   Need to use Perl's Net-SNMP on next version but this was mainly an excuse to use SQLite.  Glad I did.  There's a lot of strangeness - can't get used to putting a dot in front of commands and many of my favorite SQL commands are missing or renamed.  Still - SO COOL to be able to create a database on the fly like that.

Want to delete all tables in SQLite?

You can do it with the following DANGEROUS commands:

PRAGMA writable_schema = 1;
delete from sqlite_master where type = 'table';
PRAGMA writable_schema = 0;

you then want to recover the deleted space with

VACUUM

and a good test to make sure everything is ok

PRAGMA INTEGRITY_CHECK;

Found this on the Internet but haven't ran across it elsewhere.