Skip to content

Instantly share code, notes, and snippets.

View benesch's full-sized avatar

Nikhil Benesch benesch

198 followers · 0 following
View GitHub Profile
@benesch
benesch / us-states.csv
Created April 10, 2017 19:11
US states and their postal codes
State Abbreviation
Alabama AL
Alaska AK
Arizona AZ
Arkansas AR
California CA
Colorado CO
Connecticut CT
Delaware DE
District of Columbia DC
@benesch
benesch / broken output
Last active April 28, 2017 19:45
root@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a
@benesch
benesch / broken output
Created April 28, 2017 19:45
root@:26257/> create table (a string, b string);CREATE TABLE t (a STRING, b STRING);use d;CREATE DATABASE d;CREATE TABLE d.t (a STRING, b STRING);SELECT * FROM d.t;ALTER TABLE d.t ADD COLUMN c STRING;describe table d.t;describe d.t;\?\d\tSHOW t;show d.t;show table t;SHOW TABLES;use d;SHOW TABLES;SET database = 'd';SHOW TABLES;show table t;SHOW t;SELECT * FROM t;SELECT * FROM t limit 1;SELECT * FROM t limit 1;SELECT * FROM t limit 1;ALTER TABLE t ADD COLUMN d STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;SELECT * FROM t LIMIT 1;ALTER TABLE t ADD COLUMN e STRING;ALTER TABLE t ADD COLUMN f STRING;SELECT * FROM t LIMIT 1;BACKUP;BACKUP d TO 'bar';SHOW DATABASES;show tables datablocks;use datablocks;SET database = 'datablocks';SHOW TABLES;SELECT * FROM blocks LIMIT 1;SELECT * FROM datablocks.blocks;SELECT * FROM blocks LIMIT 0;SELECT * FROM datablocks.blocks LIMIT 0;SELECT count(*) FROM datablocks.blocks;SHOW TABLES;SELECT count(*) FROM datablocks.blocks;ALTER TABLE datablocks.blocks ADD COLUMN a
@benesch
benesch / crdb-1.0-rc.1-build-from-source.patch
Created May 2, 2017 15:31
--- a/src/github.com/cockroachdb/cockroach/Makefile
+++ b/src/github.com/cockroachdb/cockroach/Makefile
@@ -110,7 +110,7 @@ short: build testshort checkshort
buildoss: BUILDTARGET = ./pkg/cmd/cockroach-oss
-build buildoss: BUILDMODE = build -i -o cockroach$(SUFFIX)$(shell $(XGO) env GOEXE)
+build buildoss: BUILDMODE = build -i -o cockroach$(SUFFIX)$$($(XGO) env GOEXE)
# The build.utcTime format must remain in sync with TimeFormat in pkg/build/info.go.
@benesch
benesch / blergh
Created May 18, 2017 15:53
W170518 11:25:57.176329 61232 server/status/runtime.go:111 Could not parse build timestamp: parsing time "" as "2006/01/02 15:04:05": cannot parse "" as "2006"
I170518 11:25:57.177280 61232 server/config.go:436 1 storage engine initialized
I170518 11:25:57.177483 61232 server/node.go:454 [n?] store [n0,s0] not bootstrapped
I170518 11:25:57.179298 61232 server/node.go:389 [n?] **** cluster 0e6c56b2-a561-40b0-97ba-6eedceee3e37 has been created
I170518 11:25:57.179309 61232 server/node.go:390 [n?] **** add additional nodes by specifying --join=127.0.0.1:59883
I170518 11:25:57.179678 61232 storage/store.go:1252 [n1] [n1,s1]: failed initial metrics computation: [n1,s1]: system config not yet available
I170518 11:25:57.179697 61232 server/node.go:467 [n1] initialized store [n1,s1]: {Capacity:536870912 Available:536870912 RangeCount:1 LeaseCount:0}
I170518 11:25:57.179717 61232 server/node.go:351 [n1] node ID 1 initialized
I170518 11:25:57.179752 61232 gossip/gossip.go:297 [n1] NodeDescriptor set to node_id
@benesch
benesch / gist:35e66b4275d02c131d394da830e03e5e
Created June 7, 2017 15:02
arjun@espeon  ~/goworkspace/src/github.com/cockroachdb/cockroach   timely_distsql  make build
GOPATH set to /home/arjun/goworkspace
make[1]: Nothing to be done for 'build_lib_static'.
[100%] Built target libprotobuf
make all-am
[ 0%] Built target build_version
[100%] Built target rocksdb
GEN pkg/cli/zcgo_flags.go
GEN pkg/server/status/zcgo_flags.go
GEN pkg/storage/engine/zcgo_flags.go
@benesch
benesch / gist:fe006f1e93ec04387e4900a2530670d4
Created June 7, 2017 20:07
runtime: goroutine stack exceeds 1000000000-byte limit
fatal error: stack overflow
runtime stack:
runtime.throw(0x5561d77, 0xe)
/usr/local/Cellar/go/1.8.3/libexec/src/runtime/panic.go:596 +0x95
runtime.newstack(0x0)
/usr/local/Cellar/go/1.8.3/libexec/src/runtime/stack.go:1089 +0x3f2
runtime.morestack()
/usr/local/Cellar/go/1.8.3/libexec/src/runtime/asm_amd64.s:398 +0x86
@benesch
benesch / eek.log
Created July 19, 2017 02:21
$ gmake -j8
GOPATH set to /Users/benesch/go
GEN pkg/cli/zcgo_flags.go
GEN pkg/server/status/zcgo_flags.go
GEN pkg/storage/engine/zcgo_flags.go
GEN pkg/ccl/storageccl/engineccl/zcgo_flags.go
GEN pkg/cli/zcgo_flags_x86_64_apple_darwin16.6.0.go
GEN pkg/server/status/zcgo_flags_x86_64_apple_darwin16.6.0.go
GEN pkg/storage/engine/zcgo_flags_x86_64_apple_darwin16.6.0.go
GEN pkg/ccl/storageccl/engineccl/zcgo_flags_x86_64_apple_darwin16.6.0.go
@benesch
benesch / logged-results
Created August 11, 2017 22:17
I170811 22:12:28.364995 173 storage/engine/rocksdb.go:67 [/go/src/github.com/cockroachdb/cockroach/c-deps/rocksdb/db/external_sst_file_ingestion_job.cc:229] [AddFile] External SST file /mnt/data1/auxiliary/114.0/i28.t6.ingested was ingested in L6 with path /mnt/data1/001229.sst (global_seqno=0) in 1.21s
I170811 22:12:28.365020 173 storage/engine/rocksdb.go:67 [/go/src/github.com/cockroachdb/cockroach/c-deps/rocksdb/db/db_impl.cc:2679] [AddFile] prepare 0.00, before run 0.00, run 0.00, resume 1.21
I170811 22:12:28.983109 168 storage/engine/rocksdb.go:67 [/go/src/github.com/cockroachdb/cockroach/c-deps/rocksdb/db/external_sst_file_ingestion_job.cc:229] [AddFile] External SST file /mnt/data1/auxiliary/117.3/i20.t6.ingested was ingested in L6 with path /mnt/data1/001230.sst (global_seqno=0) in 1.83s
I170811 22:12:28.983137 168 storage/engine/rocksdb.go:67 [/go/src/github.com/cockroachdb/cockroach/c-deps/rocksdb/db/db_impl.cc:2679] [AddFile] prepare 0.00, before run 1.21, run 0.00, resume 0.62
@benesch
benesch / gist:c747301192eb984686fb60fccf24c506
Created August 22, 2017 20:23
goroutine 47626 [running]:
runtime/pprof.writeGoroutineStacks(0x7fca3d973178, 0xc445862140, 0x30, 0xc46749cf30)
/usr/local/go/src/runtime/pprof/pprof.go:603 +0x79
runtime/pprof.writeGoroutine(0x7fca3d973178, 0xc445862140, 0x2, 0xc421175978, 0x5bef38)
/usr/local/go/src/runtime/pprof/pprof.go:592 +0x44
runtime/pprof.(*Profile).WriteTo(0x2a2de40, 0x7fca3d973178, 0xc445862140, 0x2, 0xc445862140, 0xc421175ba8)
/usr/local/go/src/runtime/pprof/pprof.go:302 +0x3b5
net/http/pprof.handler.ServeHTTP(0xc46749ce51, 0x9, 0x2a633c0, 0xc445862140, 0xc42062ef00)
/usr/local/go/src/net/http/pprof/pprof.go:209 +0x1d1
net/http/pprof.Index(0x2a633c0, 0xc445862140, 0xc42062ef00)