dynamobi/dynamobi — Issue #131: [LDB-191] row counts get reset to 0 if reentrant SQL for ALTER TABLE REBUILD fails
Author: dynamobi-build
Created: 2011-12-30 02:15:43+00:00
State: open
Labels: LCS, LDB

[reporter="jvs", created="Mon, 8 Dec 2008 19:40:09 -0500 (GMT-05:00)"]
create schema x;

create table x.t(i int);

insert into x.t values (1), (2), (3);

0: jdbc:luciddb:> alter system set "cacheReservePercentage" = 98;

No rows affected (0.054 seconds)

0: jdbc:luciddb:> alter system set "cachePagesInit" = 5;

No rows affected (0.057 seconds)

0: jdbc:luciddb:> alter table x.t rebuild;

Error: Cache scratch memory exhausted (state=,code=0)

0: jdbc:luciddb:> alter system set "cachePagesInit" = 5000;

No rows affected (0.24 seconds)

0: jdbc:luciddb:> alter system set "cacheReservePercentage" = 5;

No rows affected (0.013 seconds)

0: jdbc:luciddb:> select current_row_count from sys_root.dba_stored_tables where table_name='T';

+--------------------+

| CURRENT_ROW_COUNT |

+--------------------+

| 0 |

+--------------------+

1 row selected (1.446 seconds)