ISAM error: no free disk space
I have been having problems with adding pictures to one of the tables in
my database.
I am running this on an NT and using regular NTFS disk space for the
dataspaces.
I am using the commands like the following to add the pictures:
INSERT INTO mbl_image VALUES (0, 133, 651, 2, DATETIME(2000-08-30
14:21:20)YEAR TO SECOND, 13.9530666666667, 21.5392,'T', 'jpg',
FILETOBLOB('I:\\51034_133.jpg', 'client' ),FILETOBLOB('I:\\51034_133_t.jpg', 'client' ));
These commands work well for the first 132 pictures (in this particular
group but the database already had 422 pictures in it), but the 133
picture fails to be inserted and the following error message appears:
[Informix][Universal Server][mbl] SQL Error (-9810) : Smartblobs error.
[ ISAM error -131 : ISAM error: no free disk space ]
Now my dataspace for these pictures was created with the following
command:
onspaces -c -S myndspace -g 5 -p f:\\ifmxdata\\myndspace_dat.000 -o 0 -s2000000 -Ms 5000 -Df "LOGGING=ON"
Since each of these jpg pictures is less than 0,5 mb in size all 132 of
them can at most be 66 mb
Which is far less than the 2 GB that the myndspace dataspace contains.
Since there were about 422 pictures in the database already this makes a
total of 554 which should take approximately less than 272 mb. In fact I
would expect to Get at least 3000 pictures into the dataspace before
experiencing any lack of space.
So why am I getting these no free disk space errors. There seems to be
plenty of space on the
NTFS disk that contains the dataspace when examined in windows.
Is this something to do with the metadata size allocation -Ms 5000?
Is the only solution to recreate the dataspace with different metadata
allocation or can I change the metadata allocation without rebuilding
everything from scratch (Although I have all the database creation files
I would prefer to forego completely recreating the database.)?.
My root dataspace is small, but It would hardly be a solution to
increase its size and allowing metadata to spill over into it since
there will be 200.000 pictures in the dataspace by the time it is
finished. This means that the metadata will need to be included in
myndspace and its additional chunks.
Has anyone run into a similar problem?
Thanks for any answers in advance and have a merry Christmas.
--
Arni Thoroddsen
Arnith@loki.bok.hi.is