Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Request Postgres compatibility to support Flowable Engine: Set commands #35109

Closed
drewdeally opened this issue Feb 21, 2019 · 1 comment
Closed

Request Postgres compatibility to support Flowable Engine: Set commands #35109

drewdeally opened this issue Feb 21, 2019 · 1 comment
Assignees
@knz

Comments

@drewdeally
Copy link

support for following Commands

SET synchronize_seqscans TO off; 
SET lock_timeout = 0; 
SET idle_in_transaction_session_timeout = 0; 
SET row_security = off;

root@:26257/defaultdb> SET synchronize_seqscans TO off;                                                                                                                              SET statement_timeout = 0;                                                                                                                                                           SET lock_timeout = 0;                                                                                                                                                                SET idle_in_transaction_session_timeout = 0;                                                                                                                                         SET row_security = off;
pq: the configuration setting "synchronize_seqscans" is not supported
HINT: This feature is not yet implemented in CockroachDB.

Please check https://github.com/cockroachdb/cockroach/issues to check
whether this feature is already tracked. If you cannot find it there,
please report this error with reproduction steps at:

    https://github.com/cockroachdb/cockroach/issues/new/choose

If you would rather not post publicly, please contact us directly at:

    [email protected]

The Cockroach Labs team appreciates your feedback.


pq: the configuration setting "lock_timeout" is not supported
HINT: This feature is not yet implemented in CockroachDB.

Please check https://github.com/cockroachdb/cockroach/issues to check
whether this feature is already tracked. If you cannot find it there,
please report this error with reproduction steps at:

    https://github.com/cockroachdb/cockroach/issues/new/choose

If you would rather not post publicly, please contact us directly at:

    [email protected]

The Cockroach Labs team appreciates your feedback.

pq: the configuration setting "idle_in_transaction_session_timeout" is not supported
HINT: This feature is not yet implemented in CockroachDB.

Please check https://github.com/cockroachdb/cockroach/issues to check
whether this feature is already tracked. If you cannot find it there,
please report this error with reproduction steps at:

    https://github.com/cockroachdb/cockroach/issues/new/choose

If you would rather not post publicly, please contact us directly at:

    [email protected]

The Cockroach Labs team appreciates your feedback.

pq: the configuration setting "row_security" is not supported
HINT: This feature is not yet implemented in CockroachDB.

Please check https://github.com/cockroachdb/cockroach/issues to check
whether this feature is already tracked. If you cannot find it there,
please report this error with reproduction steps at:

    https://github.com/cockroachdb/cockroach/issues/new/choose

If you would rather not post publicly, please contact us directly at:

    [email protected]

The Cockroach Labs team appreciates your feedback.


cockroach version
Build Tag:    v2.2.0-alpha.20190211
Build Time:   2019/02/07 23:44:57
Distribution: CCL
Platform:     linux amd64 (x86_64-unknown-linux-gnu)
Go Version:   go1.11.4
C Compiler:   gcc 6.3.0
Build SHA-1:  4bdf0ad7b3190e1836e311d2b05478e8cda0bfe6
Build Type:   release

Also track under

#20296
#5924

https://github.com/flowable/flowable-engine
@drewdeally drewdeally changed the title Postgres compatibility to support Flowable Engine: Set commands Request Postgres compatibility to support Flowable Engine: Set commands Feb 21, 2019
@awoods187 awoods187 mentioned this issue Feb 21, 2019
Closed
@knz knz mentioned this issue Feb 21, 2019
Merged
@rolandcrosby
Copy link

@drewdeally looking at these in the context of the overall Flowable log we have, I'm pretty sure that this is another set of statements that were issued by pg_dump. Good to see that @knz was able to turn around a fix quickly but this one may not be on the critical path.

@rolandcrosby rolandcrosby mentioned this issue Feb 21, 2019
Closed
craig bot pushed a commit that referenced this issue Feb 25, 2019
@nvanbenschoten @knz @dt
Merge #35077 #35116 #35134 #35151 #35162
f9fde46 
35077: workload: add indexes workload r=nvanbenschoten a=nvanbenschoten

Closes #34912.

This adds a new workload called `indexes`. Unlike `kv`, the workload is
specifically designed to stress secondary indexes. Its schema looks
like:

```
CREATE TABLE indexes (
    key     UUID  NOT NULL PRIMARY KEY,
    col0    INT   NOT NULL,
    col1    INT   NOT NULL,
    col2    INT   NOT NULL,
    col3    INT   NOT NULL,
    col4    INT   NOT NULL,
    col5    INT   NOT NULL,
    col6    INT   NOT NULL,
    col7    INT   NOT NULL,
    col8    INT   NOT NULL,
    col9    INT   NOT NULL,
    payload BYTES NOT NULL
)
```

and it includes knobs to specify how many of the "col" columns should be
indexed and whether they should be indexed using a UNIQUE specifier. The
workload also includes a knob to specify the size of the `payload`
column.

Release note: None

35116: sql: add support for extra session vars for pg compatibility r=knz a=knz

Fixes #35109.

This adds compatibility support for the following variables, with only
the default values that make sense in CockroachDB:

- `row_security`
- `synchronize_seqscans`,
- `lock_timeout`,
- `idle_in_transaction_session_timeout`

Release note: None

35134: storageccl: leave params in workload URIs r=dt a=dt

workload URIs do not contain anything sensitive and including them in the job make it easier see what it was actually doing.

Release note: none.

35151: sql: tolerate non-existent databases for plan cache invalidation r=knz a=knz

Fixes  #35145.

Release note (bug fix): CockroachDB again properly reports when a
database used during PREPARE does not exist any more when EXECUTE is
used.

35162: storage: remove TODOs in cmd_push_txn r=nvanbenschoten a=nvanbenschoten

This was discussed in #33523 (review) but I missed digging into it at the time. I still don't think I have my head fully wrapped around it, but I do enough to know that it's not something I want to start pulling on right now.

Release note: None

Co-authored-by: Nathan VanBenschoten <[email protected]>
Co-authored-by: Raphael 'kena' Poss <[email protected]>
Co-authored-by: David Taylor <[email protected]>
@craig craig bot closed this as completed in #35116 Feb 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@knz knz

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@rolandcrosby @knz @drewdeally