Skip to content

Syntax error when executing transaction with go pq sql driver library. #16309

@andrewchambers

Description

@andrewchambers

BUG REPORT

  1. Please supply the header (i.e. the first few lines) of your most recent
    log file for each node in your cluster.

I170603 06:28:35.309149 61 util/log/clog.go:908 [config] file created at: 2017/06/03 06:28:35
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] running on machine: cockroach-1
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] binary: CockroachDB CCL v1.0 (linux amd64, built 2017/05/10 13:19:57, go1.8.1)
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] arguments: [cockroach start --insecure --store /cockroachdata]

  1. Please describe the issue you observed:
  • What did you do?

Ran a transaction with github.com/lib/pq and github.com/lib/pq

  • What did you expect to see?

The transaction to execute correctly.

  • What did you see instead?
2017/06/04 10:28:54 an error occured during billing: error billing due account 247821695300435969: pq: syntax error at or near "read"
BEGIN READ WRITE

The issue seems to be cockroachdb does not support the READ WRITE syntax used by the pq driver at the following line:

https://github.com/lib/pq/blob/8837942c3e09574accbc5f150e2c5e057189cace/conn_go18.go#L68

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions