Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

forum.gupta.bugreport (2005-2010)
Matin Hobbs

Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Matin Hobbs » 17 May 2006, 17:44

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Mike Vandine » 18 May 2006, 00:21

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Matin Hobbs » 18 May 2006, 17:04

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Matin Hobbs » 19 May 2006, 14:22

 Posted by:  Matin Hobbs 

Hi Mike,

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

Best Regards

You do not have the required permissions to view the files attached to this post.

FRBhote
India
Posts: 2208
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by FRBhote » 19 May 2006, 15:22

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Mike Vandine » 21 May 2006, 05:39

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Matin Hobbs » 22 May 2006, 16:51

 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

Re: Error 2103 Lseek error in SQLBASE 8.5 (no PTF)

Post by Jim McNamara » 22 May 2006, 17:22

 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.

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests