[Info-ingres] Ingres/Replicator Stress Test

Hi Dudes,

I've been playing with Ingres/Replicator again - I think its good for my
stress levels, they weren't high enough.

So on my source database I have a single row table called next_id. It
holds a sequence counter. I'm going to replicate this to a target
database.

The table suffers from high concurrency, so I've altered its shadow and
archive tables to be hash with minpages 10240. This removed the
deadlocking problems.

So I wrote a test program to do inserts into another table using the
traditional 'get next id' procedure which updates the next_id table,
extracts the next_id and returns this to the caling program. It survives
small scale of 5inserts.

A simple stress test...Same program 5000 inserts.

Okay....

How come my target databases version of this table started with a
synched up single row and ended up with two rows, only one of which
had the correct final value of the next_id?

There were no deadlocks detected on the next_id, its shadow or
archive. There was a deadlock on the dd_distrib_queue which caused it
to fail on a delete.

There was only:
Server 2: test_u4::rep_src_mb server 2: Error -- Wed Nov 23 14:35:38 2005 -- 1
392 -- UPDATE collision found for table 'martinb.next_id',
Source DB 110, Transaction ID 1120740203, Sequence 1.

My CDDS is running with a 'Last Write Wins' Collision handling.

Can anyone start guessing what may have occurred to cause the
second row to appear.

Martin Bowes.
--
Random Duckman Quote #88:
Cornfed: For those of you who went out for a beer-- We've created a
monster.

.

Relevant Pages

  • Re: Automating repetitive tasks-creating text strings from excel into
    ... You should be able to convert the list of numbers into a single row of numbers quite easily using find/replace. ... You would need to remove the final comma at the end of the last number, or just not select it when you copy to the clipboard for pasting into the database search box. ... keystrokes, or can someone help me "loop" the keystrokes in a macro so I can ...
    (microsoft.public.word.docmanagement)
  • Re: New record on a new day (re-post)
    ... In a well-normalized relational database design, ... CommentTypeID (a foreign key, pointing back to the Primary Key in a ... a single row in a table. ... be too difficult to maintain this data in an excel spreadsheet, ...
    (microsoft.public.access.formscoding)
  • Database vs Data Structure?
    ... I'm trying to decided whether to store the objects in the database ... data-structure in a single row in the database (then unpickle the data ... -able to query objects based on name and id. ...
    (comp.lang.python)
  • Database vs Data Structure?
    ... I'm trying to decided whether to store the objects in the database ... data-structure in a single row in the database (then unpickle the data ... -able to query objects based on name and id. ...
    (comp.lang.python)
  • Event log entry every time BizTalk is Busy
    ... We have a biztalk solution that is a file receive that applies a maps and then hits a database. ... The Messaging engine has throttled all inbound messages for the host "BizTalkServerApplication" due to high stress levels on the MessageBox database. ...
    (microsoft.public.biztalk.general)