You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Radar Lei (JIRA)" <ji...@apache.org> on 2018/07/13 06:23:00 UTC
[jira] [Updated] (HAWQ-1639) Unexpected internal error when
truncate and alter in a transaction
[ https://issues.apache.org/jira/browse/HAWQ-1639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Radar Lei updated HAWQ-1639:
----------------------------
Affects Version/s: 2.3.0.0-incubating
Fix Version/s: (was: 2.3.0.0-incubating)
backlog
Description:
hdb=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.3.0.0-incubating build dev) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (R
ed Hat 4.8.5-16) compiled on May 4 2018 06:27:27
(1 row)
hdb=# begin;
BEGIN
hdb=# select * from test limit 2;
a
--------------------
asdfsdgrtecvxbfgdh
asdfsdgrtecvxbfgdh
(2 rows)
hdb=# truncate table test;
TRUNCATE TABLE
hdb=# select * from test limit 2;
a
---
(0 rows)
hdb=# alter table test add column b varchar(20) default '';
ALTER TABLE
hdb=# commit;
ERROR: Unexpected internal error (appendonlywriter.c:525)
hdb=# rollback;
WARNING: there is no transaction in progress
ROLLBACK
hdb=#
was:
hdb=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------
PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.3.0.0-incubating build dev) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (R
ed Hat 4.8.5-16) compiled on May 4 2018 06:27:27
(1 row)
hdb=# begin;
BEGIN
hdb=# select * from test limit 2;
a
--------------------
asdfsdgrtecvxbfgdh
asdfsdgrtecvxbfgdh
(2 rows)
hdb=# truncate table test;
TRUNCATE TABLE
hdb=# select * from test limit 2;
a
---
(0 rows)
hdb=# alter table test add column b varchar(20) default '';
ALTER TABLE
hdb=# commit;
ERROR: Unexpected internal error (appendonlywriter.c:525)
hdb=# rollback;
WARNING: there is no transaction in progress
ROLLBACK
hdb=#
> Unexpected internal error when truncate and alter in a transaction
> ------------------------------------------------------------------
>
> Key: HAWQ-1639
> URL: https://issues.apache.org/jira/browse/HAWQ-1639
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Affects Versions: 2.3.0.0-incubating
> Reporter: TaoJIn
> Assignee: Radar Lei
> Priority: Major
> Fix For: backlog
>
>
> hdb=# select version();
> version
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
> --------------------------------------------------
> PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.3.0.0-incubating build dev) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (R
> ed Hat 4.8.5-16) compiled on May 4 2018 06:27:27
> (1 row)
>
> hdb=# begin;
> BEGIN
> hdb=# select * from test limit 2;
> a
> --------------------
> asdfsdgrtecvxbfgdh
> asdfsdgrtecvxbfgdh
> (2 rows)
>
> hdb=# truncate table test;
> TRUNCATE TABLE
> hdb=# select * from test limit 2;
> a
> ---
> (0 rows)
>
> hdb=# alter table test add column b varchar(20) default '';
> ALTER TABLE
> hdb=# commit;
> ERROR: Unexpected internal error (appendonlywriter.c:525)
> hdb=# rollback;
> WARNING: there is no transaction in progress
> ROLLBACK
> hdb=#
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)