Webspeed strange behavior

yoachan

Member
Hi. I want to askif anyone of you have the same experience with me.
I'm using opera as my default browser and set it to load every requested page directly from the server. (So there won't be any problem with browser's history).
But SOMETIMES I met strange behavior.

For each edit transaction, I put the user's name to field on every records with the same transaction number the user currently holding (let's say it's "Mr. X"). So when other user diplay all transaction, they can see wich transaction is currently being edit by "Mr. X" and not allowed to use them (by program).

When "Mr. X" finished his edit transaction, I erase his username from every single records so that the records become available for other user to use.

But the problem is sometimes even the user name field is already empty, my program still displayed "Mr. X"'s name. But when i do reload the page, sometimes the username become blank, and sometimes it showing "Mr. X"'s name again. All I do just reload the display page. Goes blank, and goes filled at random. But mostly blank.

When I checked directly to the database using "mpro" form shell, i found out that it really is blank. But why my web program become lunatic?

So I stop my web broker, shutdown my database(s), and restart them all.

And voilla. The program runs just in the proper way. "Mr. X" is completely gone.

Anyone have any solution? Because it's driving me nuts.
I'm using OE 10.1A on Acer Server with platform RedHat Enterprise Linux Advanced Server 4.

Regards

YoChan
 
Hi Yoachan,

Sounds like some overhead to me putting the name inside the record. I'm more of an optimistic locking person myself (especially with webseed since agents don't come that cheap and use plenty of memory).

But anyhow, looks like you have some 'dirty' reads on your hand. Start the webspeed agents up with the -rereadnolock parameter and the problem is probably gone.

HTH,

Casper.
 
Back
Top