Ping mySQL every minute in an attempt to keep the connection alive.

Ping MySQL every minute in an attempt to keep the connection alive.

I've tried various MySQL server settings, and some TCP settings on the webtry server, none seem to keep the connection from hanging, so this is a brute-force solution.

BUG=skia:

Committed: http://code.google.com/p/skia/source/detail?r=14720

[mtklein, 2014-05-13 20:32:58]

lgtm

[jcgregorio, 2014-05-13 20:34:31]

The CQ bit was checked by jcgregorio@google.com

[commit-bot: I haz the power, 2014-05-13 20:34:56]

CQ is trying da patch. Follow status at
 https://skia-tree-status.appspot.com/cq/jcgregorio@google.com/286543003/20001

[commit-bot: I haz the power, 2014-05-13 20:49:22]

The CQ bit was unchecked by commit-bot@chromium.org

[commit-bot: I haz the power, 2014-05-13 20:49:23]

Failed to apply patch for experimental/webtry/webtry.go:
While running patch -p1 --forward --force --no-backup-if-mismatch;
  can't find file to patch at input line 6
  Perhaps you used the wrong -p or --strip option?
  The text leading up to this was:
  --------------------------
  |Index: experimental/webtry/webtry.go
  |diff --git a/experimental/webtry/webtry.go b/experimental/webtry/webtry.go
  |index
f909b0637d3a30d64f2dbd12fa154a339d9ae591..bf352fb13178b0573a4128365f8695a1ac255c19
100644
  |--- a/experimental/webtry/webtry.go
  |+++ b/experimental/webtry/webtry.go
  --------------------------
  No file to patch.  Skipping patch.
  1 out of 1 hunk ignored

Patch:       experimental/webtry/webtry.go
Index: experimental/webtry/webtry.go
diff --git a/experimental/webtry/webtry.go b/experimental/webtry/webtry.go
index
f909b0637d3a30d64f2dbd12fa154a339d9ae591..bf352fb13178b0573a4128365f8695a1ac255c19
100644
--- a/experimental/webtry/webtry.go
+++ b/experimental/webtry/webtry.go
@@ -235,6 +235,17 @@ func init() {
 		_, err = db.Exec(sql)
 		log.Printf("Info: status creating sqlite table for workspace try: %q\n", err)
 	}
+
+	// Ping the database to keep the connection fresh.
+	go func() {
+		c := time.Tick(1 * time.Minute)
+		for _ = range c {
+			if err := db.Ping(); err != nil {
+				log.Printf("ERROR: Database failed to respond: %q\n", err)
+			}
+		}
+	}()
+
 }
 
 // Titlebar is used in titlebar template expansion.

[jcgregorio, 2014-05-14 12:49:16]

The CQ bit was checked by jcgregorio@google.com

[commit-bot: I haz the power, 2014-05-14 12:49:22]

CQ is trying da patch. Follow status at
 https://skia-tree-status.appspot.com/cq/jcgregorio@google.com/286543003/40001

[commit-bot: I haz the power, 2014-05-14 12:55:37]

Change committed as 14720