add fragment

Posted in 2008

Topics: Storage & Space Management, Error Codes & Troubleshooting, Security, Permissions & Auditing, Data Types & Schema Design, Triggers, Constraints & Referential Integrity, Logging & Checkpoints, Versions, Editions & End-of-Life

FRANK — Tue, 08 Jan 2008 18:29:41 — source: IIUG Forums & Mailing Lists

HI, Folks, IDS11.10 UC1, AIX5.3 We tried adding a fragment to a table and got the following( attached info ), any comments are appreciated. I got a similar result form IDS10 UC5 also long time ago. Thanks, Frank =====SQL====== alter fragment on table ds_head add partition pt5 (datatype_name [1,2] ='MS') in dbdata05 ; 776: Alter fragment error: unable to move row(s) to new fragmentation scheme. 111: ISAM error: no record found. =====ONLINE LOG====== IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line -- Up 5 days 22:00:25 -- 2022240 Kbytes Message Log File: /dbbackup/online_log/online_pop.log18:14:40 Logical Log 28064 - Backup Completed 18:15:13 Checkpoint Completed: duration was 4 seconds. 18:15:13 Tue Jan 8 - loguniq 28065, logpos 0x8ddd9ac, timestamp: 0xe0184ce6 Interval: 4599 18:15:13 Maximum server connections 17 18:15:13 Checkpoint Statistics - Avg. Txn Block Time 0.002, # Txns blocked 1, Plog used 46240, Llog used 56918 18:15:13 Logical Log 28065 Complete, timestamp: 0xe018a14e. 18:15:13 Logical Log 28065 - Backup Started 18:15:17 Logical Log 28065 - Backup Completed 18:16:56 Assert Failed: Condition Failed (Memory pointer (0xbb6bfe38) freed twice), In (mt_shm_free) 18:16:56 IBM Informix Dynamic Server Version 11.10.UC1 18:16:56 Who: Session(1439, informix@elena, 475342, b04a7c38) Thread(1545, sqlexec, b0482948, 5) File: mtshpool.c Line: 3213 18:16:56 Action: Please notify IBM Informix Technical Support. 18:16:56 stack trace for pid 631098 written to /tmp/af.9f1be17 18:16:56 See Also: /tmp/af.9f1be17, shmem.9f1be17.0 18:17:14 Error writing '/tmp/shmem.9f1be17.0' errno = 28 18:17:15 Condition Failed (Memory pointer (0xbb6bfe38) freed twice), In (mt_shm_free) =====TABLE SCHEMA ====== { TABLE "informix".ds_head row size = 586 number of columns = 12 index size = 339 } create table "informix".ds_head ( inventory_id serial not null , dataset_name varchar(255,44) not null , dataset_size_bytes int8, datatype_name char(10) not null , datatype_version char(10), ingest_status char(10), ingest_dt datetime year to second not null , orig_data_filenm varchar(255,44) not null , distribution_site char(1) not null , data_source char(10), has_visual_file char(1), restriction_level smallint, primary key (inventory_id) constraint "informix".ds_head_pk ) with crcols fragment by expression partition pt1 (datatype_name [1,2] = 'GV' ) in dbdata01 , partition pt2 (datatype_name [1,2] = 'GO' ) in dbdata02 , partition pt3 (datatype_name [1,2] = 'CW' ) in dbdata03 , partition pt4 (datatype_name [1,2] = 'NP' ) in dbdata04 , partition pt6 (datatype_name [1,2] = 'AS' ) in dbdata05 , partition pt7 (datatype_name [1,2] = 'IA' ) in dbdata05 , partition pt8 (datatype_name [1,2] = 'ED' ) in dbdata05 , partition pt9 (datatype_name [1,2] = 'AV' ) in dbdata05 , partition pt10 (datatype_name [1,2] = 'ED' ) in dbdata05 , partition pt11 (datatype_name [1,2] = 'IA' ) in dbdata05 , partition pt12 (datatype_name [1,2] = 'AB' ) in dbdata05 , partition rmd remainder in dbdata05 extent size 8192 next size 8192 lock mode row; revoke all on "informix".ds_head from "public"; create unique index "informix".ds_head_idx0 on "informix".ds_head (dataset_name) using btree in dbdata05 ; create index "informix".w_ds_head_idx4 on "informix".ds_head (ingest_dt) using btree ; alter table "informix".ds_head add constraint (foreign key (datatype_name) references "informix".datatypes constraint "informix".ds_head_dtn); alter table "informix".ds_head add constraint (foreign key (datatype_version) references "informix".datatyp_vers constraint "informix".ds_head_dtv); alter table "informix".ds_head add constraint (foreign key (distribution_site) references "informix".distribution_sites constraint "informix" .ds_head_fk1);

↪ replying to FRANK

FRANK — Tue, 08 Jan 2008 19:07:23 — source: IIUG Forums & Mailing Lists

Reproduced it in a more simple ( same thing but try to eliminate possible confusion) Thanks, Frank =============== IDS11.10 UC1, AIX5.3.0.0 SQL, alter fragment on table ds_head add partition pt5 (datatype_name [1,2] ='MS') in dbdata05 ; 776: Alter fragment error: unable to move row(s) to new fragmentation scheme. 111: ISAM error: no record found. LOG, informix@elena $ onstat -m IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line -- Up 5 days 22:34:35 -- 2022240 Kbytes Message Log File: /dbbackup/online_log/online_pop.log18:50:14 Tue Jan 8 - loguniq 28066, logpos 0x6969018, timestamp: 0xe0299327 Interval: 4606 18:50:14 Maximum server connections 17 18:50:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 7883, Llog used 6182 18:51:00 Logical Log 28066 Complete, timestamp: 0xe03389c5. 18:51:00 Logical Log 28066 - Backup Started 18:51:09 Logical Log 28066 - Backup Completed 18:51:41 Logical Log 28067 Complete, timestamp: 0xe05057c6. 18:51:41 Logical Log 28067 - Backup Started 18:51:45 Logical Log 28067 - Backup Completed 18:52:28 Assert Failed: Condition Failed (Memory pointer (0xbad3d838) freed twice), In (mt_shm_free) 18:52:28 IBM Informix Dynamic Server Version 11.10.UC1 18:52:28 Who: Session(1439, informix@elena, 475342, b04a7c38) Thread(1545, sqlexec, b0482948, 1) File: mtshpool.c Line: 3213 18:52:28 Action: Please notify IBM Informix Technical Support. 18:52:28 stack trace for pid 295204 written to /tmp/af.9f1be17 18:52:28 See Also: /tmp/af.9f1be17 18:52:30 Condition Failed (Memory pointer (0xbad3d838) freed twice), In (mt_shm_free) TABLE SCHEMA, { TABLE "informix".ds_head row size = 586 number of columns = 12 index size = 339 } create table "informix".ds_head ( inventory_id serial not null , dataset_name varchar(255,44) not null , dataset_size_bytes int8, datatype_name char(10) not null , datatype_version char(10), ingest_status char(10), ingest_dt datetime year to second not null , orig_data_filenm varchar(255,44) not null , distribution_site char(1) not null , data_source char(10), has_visual_file char(1), restriction_level smallint, primary key (inventory_id) constraint "informix".ds_head_pk ) with crcols fragment by expression partition pt1 (datatype_name [1,2] = 'GV' ) in dbdata01 , partition pt2 (datatype_name [1,2] = 'GO' ) in dbdata02 , partition pt3 (datatype_name [1,2] = 'CW' ) in dbdata03 , partition pt4 (datatype_name [1,2] = 'NP' ) in dbdata04 , partition rmd remainder in dbdata05 extent size 8192 next size 8192 lock mode row; revoke all on "informix".ds_head from "public"; create unique index "informix".ds_head_idx0 on "informix".ds_head (dataset_name) using btree in dbdata05 ; create index "informix".w_ds_head_idx4 on "informix".ds_head (ingest_dt) using btree ; alter table "informix".ds_head add constraint (foreign key (datatype_name) references "informix".datatypes constraint "informix".ds_head_dtn); alter table "informix".ds_head add constraint (foreign key (datatype_version) references "informix".datatyp_vers constraint "informix".ds_head_dtv); alter table "informix".ds_head add constraint (foreign key (distribution_site) references "informix".distribution_sites constraint "informix" .ds_head_fk1); On Jan 8, 2008 1:29 PM, FRANK <yunyaoqu@gmail.com> wrote: > HI, Folks, > > IDS11.10 UC1, AIX5.3 > > We tried adding a fragment to a table and got the following( attached info > ), any comments are appreciated. > I got a similar result form IDS10 UC5 also long time ago. > > Thanks, > Frank > > =====SQL====== > > alter fragment on table ds_head add partition pt5 (datatype_name [1,2] => 'MS') in dbdata05 ; > > 776: Alter fragment error: unable to move row(s) to new fragmentation > scheme.> > 111: ISAM error: no record found.> > =====ONLINE LOG====== > > IBM Informix Dynamic Server Version 11.10.UC1 -- On-Line -- Up 5 days > 22:00:25 -- 2022240 Kbytes > > Message Log File: /dbbackup/online_log/online_pop.log> 18:14:40 Logical Log 28064 - Backup Completed > 18:15:13 Checkpoint Completed: duration was 4 seconds. > 18:15:13 Tue Jan 8 - loguniq 28065, logpos 0x8ddd9ac, timestamp: > 0xe0184ce6 Interval: 4599 > > 18:15:13 Maximum server connections 17 > 18:15:13 Checkpoint Statistics - Avg. Txn Block Time 0.002, # Txns blocked > 1, Plog used 46240, Llog used 56918 > > 18:15:13 Logical Log 28065 Complete, timestamp: 0xe018a14e. > 18:15:13 Logical Log 28065 - Backup Started > 18:15:17 Logical Log 28065 - Backup Completed > 18:16:56 Assert Failed: Condition Failed (Memory pointer (0xbb6bfe38) > freed > twice), In (mt_shm_free) > 18:16:56 IBM Informix Dynamic Server Version 11.10.UC1 > 18:16:56 Who: Session(1439, informix@elena, 475342, b04a7c38) > > Thread(1545, sqlexec, b0482948, 5) > > File: mtshpool.c Line: 3213 > 18:16:56 Action: Please notify IBM Informix Technical Support. > 18:16:56 stack trace for pid 631098 written to /tmp/af.9f1be17 > 18:16:56 See Also: /tmp/af.9f1be17, shmem.9f1be17.0 > 18:17:14 Error writing '/tmp/shmem.9f1be17.0' errno = 28 > 18:17:15 Condition Failed (Memory pointer (0xbb6bfe38) freed twice), In > (mt_shm_free) > > =====TABLE SCHEMA ====== > > { TABLE "informix".ds_head row size = 586 number of columns = 12 index > size > = 339 > > } > create table "informix".ds_head > ( > > inventory_id serial not null , > > dataset_name varchar(255,44) not null , > > dataset_size_bytes int8, > > datatype_name char(10) not null , > > datatype_version char(10), > > ingest_status char(10), > > ingest_dt datetime year to second not null , > > orig_data_filenm varchar(255,44) not null , > > distribution_site char(1) not null , > > data_source char(10), > > has_visual_file char(1), > > restriction_level smallint, > > primary key (inventory_id) constraint "informix".ds_head_pk > ) with crcols > fragment by expression > > partition pt1 (datatype_name [1,2] = 'GV' ) in dbdata01 , > > partition pt2 (datatype_name [1,2] = 'GO' ) in dbdata02 , > > partition pt3 (datatype_name [1,2] = 'CW' ) in dbdata03 , > > partition pt4 (datatype_name [1,2] = 'NP' ) in dbdata04 , > > partition pt6 (datatype_name [1,2] = 'AS' ) in dbdata05 , > > partition pt7 (datatype_name [1,2] = 'IA' ) in dbdata05 , > > partition pt8 (datatype_name [1,2] = 'ED' ) in dbdata05 , > > partition pt9 (datatype_name [1,2] = 'AV' ) in dbdata05 , > > partition pt10 (datatype_name [1,2] = 'ED' ) in dbdata05 , > > partition pt11 (datatype_name [1,2] = 'IA' ) in dbdata05 , > > partition pt12 (datatype_name [

add fragment

Related threads

Glossary

Your privacy choices