Oninit cdi / Archive
Talk to an expert →

Problem with Datablade Modules

Posted in 2000

Topics: Installation, Setup & Upgrades, Storage & Space Management, Data Types & Schema Design

Kirill Pirgalin — — source: Informix-list mailing list archive (1991-1998)

Hello! Please look on my problem and give advise what to do. 1. I have a database with several tables use Image and Video Datablade modules. It was created a year ago imideatly after installation of Informix distributive packet. After that we were able to insert only 16 records (images and some numeric values)into DB. After that we were able to read and run simple queries as: -------------------------------------------------------------------------- select chunkid, rank from vidimgdesc where Resembles (image, row('IpdColorImageFE(RETINA_WIDTH=32, RETINA_HEIGHT=32)', row(row(row('IFX_FILE', NULL::LLD_Lob, '/home/isl161/images/personnel/ido.gif'), NULL::lvarchar), '','',0, 0, '')), rank #REAL); -------------------------------------------------------------------------- it returns frame number and resemblence degree. Tables were created by following queries: -------------------------------------------------------------------------- create table personnel ( personid int, first varchar(255), last varchar(255), image ifdimgdesc, primary key (personid) ); CREATE INDEX per_color_index on personnel (image IfdImgDesc_ops) USING frnet(extractor='IpdColorImageFE(RETINA_WIDTH=32,RETINA_HEIGHT=32)') in sbdbs; CREATE INDEX per_texture_index on personnel (image IfdImgDesc_ops) USING frnet(extractor='IpdTextureImageFE(RETINA_WIDTH=32,RETINA_HEIGHT=32)') in sbdbs; CREATE INDEX per_gestalt_index on personnel (image IfdImgDesc_ops) USING frnet(extractor='IpdGestaltImageFE(RETINA_WIDTH=32,RETINA_HEIGHT=32)') in sbdbs; insert into personnel values (0, 'nobody', 'nobody',row(row(row('ifx_file',NULL::LLD_Lob,'/net/emc2-32/isl/home/isl161/images/personnel/ido.gif'),NULL::lvarchar),'NULL','NULL' ,NULL::lvarchar,NULL::lvarchar,NULL::lvarchar)::ifdimgdesc ); insert into personnel values (1, 'Ido', 'Carmel',row(row(row('ifx_file',NULL::LLD_Lob,'/net/emc2-32/isl/home/isl161/images/personnel/ido.gif'),NULL::lvarchar),'NULL','NULL' ,NULL::lvarchar,NULL::lvarchar,NULL::lvarchar)::ifdimgdesc ); -------------------------------------------------------------------------- But at some day Informix stoped to work properly. - Unable to register Datablade modules for new-created databases (by blademgr) - Unable to insert any record contains image/video linked field - Unable to compare images and etc. I receive next messages while registering DataBledes for new Database: -------------------------------------------------------------------------- 10 2000-07-25 11:54:56 Register video.1.20.UC1 Fail - Log in /tmp/blademgr/50040/log010.log Pick the number of a log or N to cancel :- 10 blade: video.1.20.UC1 err expct: unexpected SQL stmt: create index Idx1ChunkMD on VidChunkMD (Chunk MedChunk_ops) using rtree; SQL state: XRLT70:-937 : RLT70: cannot create rtree index in non-logging(??? - K.) database blade: video.1.20.UC1 err expct: unexpected SQL stmt: drop type MedPtr restrict; SQL state: XIX000:-9630 : Cannot drop type (medptr): still in use. blade: video.1.20.UC1 err expct: unexpected SQL stmt: EXCEPTION SQL state: Registration failed for DataBlade module "video.1.20.UC1", recovery was unsuccessful. -------------------------------------------------------------------------- Our sysadmin claims that everything as usual, excepts that mainframe with Informix sometimes fails... He can RE-install informix (or only these DataBlades) but after - He won't know any other way to fix this problem - And what to do with existed database? I ask you to give advise what can we do and may be with your recomendations sysadmin will permit to us reinstall Informix. Best regards, Kirill Pirgalin. Technion, Israel.

Related threads