Re: postgresql and load balancing

On Fri, Feb 15, 2013 at 5:49 PM, Oliver Urbann
<[email protected]> wrote:
> the process is migrated but the benchmark crashes with different
> messages, e.g.:
>
> Client 3 aborted in state 11: FATAL:  semop(id=491526) failed:
> Bezeichner wurde entfernt
>
> or
>
> Client 2 aborted in state 8: FEHLER:  lock RowExclusiveLock on object
> 16384/16391/0 is already held
>
> Did anybody have success load balancing postgresql?
> https://lists.sourceforge.net/lists/listinfo/ssic-linux-users

IIRC, locks in OpenSSI is not system wide. Further more, when a
process (the whole thread group in this case) migrated, then it is
migrated entirely in the sense that it physically move.

This is different than say MOSIX which use "stub" approach, so lock
might still work because there is still communication between origin
node and the new node (from the migration point of view)

So that might explain the lock error message. To prove it, try to
install MOSIX and see if the crash/error disappear during your test.

-- 
regards,

Mulyadi Santosa
Freelance Linux trainer and consultant

blog: the-hydra.blogspot.com
training: mulyaditraining.blogspot.com

------------------------------------------------------------------------------
The Go Parallel Website, sponsored by Intel - in partnership with Geeknet, 
is your hub for all things parallel software development, from weekly thought 
leadership blogs to news, videos, case studies, tutorials, tech docs, 
whitepapers, evaluation guides, and opinion stories. Check out the most 
recent posts - join the conversation now. http://goparallel.sourceforge.net/