Skip to content

Instantly share code, notes, and snippets.

@mike1703
mike1703 / optimize-sqlite.sh
Created October 31, 2017 07:04
finds all sqlite databases in the current folder (and subfolders) and executes sqlite3 $FILE "VACUUM;" on all databases
#!/bin/bash
find -type f \( -name "*.db" -or -name "*.sqlite" \) -print0 | while read -d $'\0' FILE
do
TYPE=`file "$FILE" | grep -i sqlite`
[ -z "$TYPE" ] && continue # this is not an sqlite db
PRESIZE=`ls -sh "$FILE" | cut -f 1 -d " "`
PRESIZEFULL=`ls -s "$FILE" | cut -f 1 -d " "`
sqlite3 "$FILE" "VACUUM;"
POSTSIZE=`ls -sh "$FILE" | cut -f 1 -d " "`
@mike1703
mike1703 / exception.log
Created March 31, 2012 12:22
openra exception created by engineer invading just sold ore refinery
System.InvalidOperationException: Attempted to get trait from destroyed object (proc 98 (not in world))
at OpenRA.TraitDictionary.CheckDestroyed (OpenRA.Actor actor) [0x00000] in <filename unknown>:0
at OpenRA.TraitDictionary.Contains[Building] (OpenRA.Actor actor) [0x00000] in <filename unknown>:0
at OpenRA.Actor.HasTrait[Building] () [0x00000] in <filename unknown>:0
at OpenRA.Mods.RA.Buildings.BuildingInfluence.<BuildingInfluence>m__304 (OpenRA.Actor a) [0x00000] in <filename unknown>:0
at (wrapper delegate-invoke) <Module>:invoke_void__this___Actor (OpenRA.Actor)
at (wrapper delegate-invoke) <Module>:invoke_void__this___Actor (OpenRA.Actor)
at (wrapper delegate-invoke) <Module>:invoke_void__this___Actor (OpenRA.Actor)
at (wrapper delegate-invoke) <Module>:invoke_void__this___Actor (OpenRA.Actor)
at (wrapper delegate-invoke) <Module>:invoke_void__this___Actor (OpenRA.Actor)