Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

[Matin Hobbs]

 Posted by:  Matin Hobbs 

Hi,

While re-indexing one of the tables in a 17GB database we are getting a 2103
cannot perform LSEEK error. We have no problems constructing the database by
basically merging 5 other smaller databases and everything works until we
try and reindex a paticular table after the merge; other tables have been
succuessfully reindexed.

There is plenty of disk space and the file system is NTFS. Are there any
limitations on the size of tables within a database? Has anyone else had
this problem.

Best Regards

[Mike Vandine]

 Posted by:  Mike Vandine 

Hi Martin,

Try applying the latest PTF and trying again. The problem is in a temp file
being built that is getting larger than 2GB when the index is being created.

Also, send your sql.ini file and let us look at the settings for cache= and
sortcache=

Best regards,

Mike

[Matin Hobbs]

 Posted by:  Matin Hobbs 

Hi Mike,

We are trying with 8.5.0 PTF4. If this doesn't work I will send you the
SQL.INI. I believe the cache is set to 128000 and there is no sortcache
defined.

Best Regards

Martin

[Matin Hobbs]

 Posted by:  Matin Hobbs 

Hi Mike,

I am afraid the bug still exists in 8.5.0. PTF4.

Best Regards

[FRBhote]

 Posted by:  F R Bhote 

I would reduce the cache to 40000 and give it a try. Is the index very
large- how many fields are there in the index?

[Mike Vandine]

 Posted by:  Mike Vandine 

With the sortlevel=0 command, you are saying that you want the default
sortcache of 2048 pages to be the maximum sortcache for the whole server,
not for each sort process. You either need to:

1. Take out the sortlevel=0 command (recommended for normal processing)
2. Leave the sortlevel=0 command in and put in a line: 'sortcache=65535'.
This is the current maximum and with the sortlevel=0 in this will be the
default for the whole server. You might try this just for the build.

I would also recommend dropping the cache= to around 50,000 or so.

Best Regards,

Mike

[Matin Hobbs]

 Posted by:  Matin Hobbs 

Hi Mike,

Just to let you know your suggested settings worked and we were able to
build what is now a 19GB database. Do you think there is any chance this bug
will get fixed in a future PTF for 8.5.0?

Best Regards

[Jim McNamara]

 Posted by:  Jim McNamara 

See http://www.guptaworldwide.com/Products/Product_life_cycle.aspx

8.5 is out of engineering support. That means no more PTFs.