dbTalk Databases Forums  

-310 error occurred before checkflushed called

comp.databases.xbase.codebase comp.databases.xbase.codebase


Discuss -310 error occurred before checkflushed called in the comp.databases.xbase.codebase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vladimir Silantyev
 
Posts: n/a

Default -310 error occurred before checkflushed called - 09-12-2003 , 05:32 AM






I have a program that maintain large database of e-mail addresses.
Everything works fine, until size of .cdx file grows to 4gb. Size of
..dbf file is 5012 mb.

When i try to add more records, codebase reports error: "(-310)
occured, before CheckFlushed was called".

Large file support is on.
Delphi 7
Windows XP
NTFS
c4dll, ver 6.50

Table structure (em.dbf):
ID integer,
EMAIL character 40,
HOST character 40,
DOMAIN character 4,
UNSUB logical,
CLICKED logical

Index structure(em.cdx):
EM_EMAIL, unique: (UPPER( TRIM( EMAIL ) + '@' + TRIM( HOST ) + '.' +
TRIM( DOMAIN ) ))
EM_ID, unique: ID

Documentation says, that index file size limitation is 4096 GB.

What's wrong?

Reply With Quote
  #2  
Old   
Terry
 
Posts: n/a

Default Re: -310 error occurred before checkflushed called - 09-12-2003 , 10:56 AM






I ran into a similar problem with a large database file (128GB). When
building the database the index file would not grow beyond 4GB, even
with large file support on.

To fix this we set the index block size(code4indexblocksizeset
function) to 512 and rebuilt the index. This changes the underlying
structure of the index file and allows for indexes up to 4096GB(?).

Hope this helps!
Terry

stealth (AT) kama (DOT) ru (Vladimir Silantyev) wrote in message news:<37d9fa0a.0309120232.2b1195ae (AT) posting (DOT) google.com>...
Quote:
I have a program that maintain large database of e-mail addresses.
Everything works fine, until size of .cdx file grows to 4gb. Size of
.dbf file is 5012 mb.

When i try to add more records, codebase reports error: "(-310)
occured, before CheckFlushed was called".

Large file support is on.
Delphi 7
Windows XP
NTFS
c4dll, ver 6.50

Table structure (em.dbf):
ID integer,
EMAIL character 40,
HOST character 40,
DOMAIN character 4,
UNSUB logical,
CLICKED logical

Index structure(em.cdx):
EM_EMAIL, unique: (UPPER( TRIM( EMAIL ) + '@' + TRIM( HOST ) + '.' +
TRIM( DOMAIN ) ))
EM_ID, unique: ID

Documentation says, that index file size limitation is 4096 GB.

What's wrong?

Reply With Quote
  #3  
Old   
Vladimir Silantyev
 
Posts: n/a

Default Re: -310 error occurred before checkflushed called - 09-18-2003 , 11:46 PM



Thank you very much, Terry.

This really helps.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.