[PSQL] Postgres server crashes when "CREATE INDEX" is run on existing table with data #930
Assignees
Labels
kind/bug
This issue is a bug
Comments
yugabyte-ci
pushed a commit
that referenced
this issue
Mar 12, 2019
…isting table with data
Summary:
Before:
While creating an index on existing table with data, postgres server would crash.
```
CREATE TABLE foo(a INT, b INT, c INT, d INT);
INSERT INTO foo VALUES(1,1,1,1);
CREATE INDEX foo_a ON foo(a);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
```
Now:
```
CREATE TABLE foo(a INT, b INT, c INT, d INT);
INSERT INTO foo VALUES(1,1,1,1);
postgres=# create index foo_d on foo(a);
CREATE INDEX
postgres=# select * from foo where a=1;
a | b | c | d
---+---+---+---
1 | 1 | 1 | 1
(1 row)
```
Test Plan: Jenkins
Reviewers: robert
Reviewed By: robert
Subscribers: yql
Differential Revision: https://phabricator.dev.yugabyte.com/D6281
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When index is created on an existing table containing data, Postgres server crashes.
The text was updated successfully, but these errors were encountered: