SQLBase: isolation error 11.0.2

forum.gupta.bugreport (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

SQLBase: isolation error 11.0.2

Post by NewsgroupServer » 21 Feb 2008, 09:44

 Posted by:  Hrastnik Dejan 

I want to post following problems:

We installed the SQLBase 11.02 at our customer with nearly 50 users.
We used the isolation level RC. The result was, that if more then 20 or 30
users are working
with the database, the SQLBase server shut down with writing fail.sql (error
703 and 803).

We are absolutely sure: no memory problems, no harddisk problem. The old
SQLBase version
8.5 PTF3 works fine for many years (we changed the hardware server)

After one day of working and many times of restarting the SQLBase server,
the database crashed totally.
The commands INSTALL DATABASE.. or CONNECT.. causes a shutdown of the
SQLBase server.

So we decided to change to the old isolation level RL. The result was, that
the ammount of locks was 5 to 10 times
higher than in the SQLBase version 8.5.

It is impossible for our cutomers to use the new version SQLBase 11.0.2

Best regards

Dejan Hrastnik

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

SQLBase: isolation error 11.0.2

Post by NewsgroupServer » 21 Feb 2008, 14:04

 Posted by:  F R Bhote 

Use RL with readonly=0

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

SQLBase: isolation error 11.0.2

Post by NewsgroupServer » 21 Feb 2008, 15:03

 Posted by:  Rainer Ebert 

This only works, if you have less than 2 users. :-(((

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests