Cockroach: Postico crashes when opening a table via the GUI running against 2.1.0-beta.20181015

[rmloveland]

The Postico database GUI crashes reliably when connected to a local CockroachDB cluster and I click the GUI icon to open a table.

To reproduce:

1. Start a local 3-node cluster (version is "CockroachDB CCL v2.1.0-beta.20181015 (x86_64-apple-darwin13, built 2018/10/15 18:29:15, go1.10.3)")
2. Start Postico (version 1.4.2) on a Mac
3. In Postico, attempt to view a table by clicking on the GUI icon (e.g., system.jobs. I also loaded the 'movr' dataset and attempted to open movr.rides.)
4. BOOM - Postico crashes, with something about a bounds exception (among other things):

Application Specific Information:
*** Terminating app due to uncaught exception 'NSRangeException', reason: '*** -[__NSArrayI objectAtIndex:]: index 9223372036854775807 beyond bounds [0 .. 7]'
abort() called
terminating with uncaught exception of type NSException

Full log from the MacOS Crash Reporter is attached below.

postico-crash.txt

Environment:

• CockroachDB version is "CockroachDB CCL v2.1.0-beta.20181015 (x86_64-apple-darwin13, built 2018/10/15 18:29:15, go1.10.3)"
• Server OS: MacOS 10.12.6
• Client app: Postico 1.4.2

[rmloveland]

cc @awoods187

[vilterp]

I have also seen this.

[jordanlewis]

Anyone triaging this please run cockroach with --vmodule=conn_executor=2 before doing the operation, then paste the queries that are sent to Cockroach right before the crash.

[awoods187]

here is what caused it to fail:

I181025 14:49:40.446083 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [NoTxn pos:10] executing ExecStmt: SHOW COLUMNS FROM defaultdb.untitled_table
I181025 14:49:40.446187 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [Open pos:10] executing ExecStmt: SHOW COLUMNS FROM defaultdb.untitled_table
I181025 14:49:40.458990 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [NoTxn pos:11] executing ExecStmt: SHOW INDEXES FROM defaultdb.untitled_table
I181025 14:49:40.459056 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [Open pos:11] executing ExecStmt: SHOW INDEXES FROM defaultdb.untitled_table
I181025 14:49:40.460464 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [NoTxn pos:12] executing Sync
I181025 14:49:40.462353 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [NoTxn pos:13] executing ExecStmt: SHOW TABLES FROM defaultdb
I181025 14:49:40.462436 374 sql/conn_executor.go:1116  [n1,client=127.0.0.1:55064,user=root] [Open pos:13] executing ExecStmt: SHOW TABLES FROM defaultdb

[awoods187]

https://gist.github.com/awoods187/67e5eba4b7d75eb978e4d8d5da5ed92f

[Tungtono]

For those who are looking for a native GUI that supports CockroachDB, try TablePlus. Tested with CockroachDB beta 2.1 and it works just fine.

[jakob]

Our latest build of Postico works with 2.1.0-rc.1 (see https://github.com/jakob/Postico/issues/600)

Download Link: postico-3700.zip

[awoods187]

@rmloveland let me know if this works for you as well as it did for @vilterp

[rmloveland]

@awoods187 works great for me - many thanks @jakob !

Closing this issue.