Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Heikki Linnakangas
Tom Lane wrote: I'm still not very sure why you're hitting the problem more often than other people. There might be some tweak you could make in your application code to dodge the issue. The initial size of the local lock hash table is 128. That's a lot of locks, most applications probably do

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Tom Lane
"Dorochevsky,Michel" <[EMAIL PROTECTED]> writes: > Are you planning to provide a binary fix for 8.2.x? I personally am not --- IIRC you are running on Windows, which I don't even have a build environment for. But you could pull REL8_2_STABLE branch tip from the CVS server and build it for yoursel

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-27 Thread Dorochevsky,Michel
> Tom Lane wrote > I've committed a fix for this; it'll be in the next set of releases. > > regards, tom lane Tom, Thanks a lot for all your work and help, I am very impressed by the PostgreSQL Team. Just a last question. Are you planning to provide a binary fix for 8.2.x?

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-26 Thread Tom Lane
I wrote: > Also, we have a generic issue that making fresh entries in a hashtable > might result in a concurrent hash_seq_search scan visiting existing > entries more than once; that's definitely not something any of the > existing callers are thinking about. > I'm too tired to think about fixes r

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-20 Thread Tom Lane
"Dorochevsky,Michel" <[EMAIL PROTECTED]> writes: > Two runs of the same test program fail at different places, so it seems to > be dependent of the timing. Two log files are available at >www.dorochevsky.de/infos/postgresql-2007-04-20_145638.zip >www.dorochevsky.de/infos/postgresql-2007-04-

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-19 Thread Tom Lane
"Michel Dorochevsky" <[EMAIL PROTECTED]> writes: > We are encountering the following problem: > 2007-04-19 16:22:19 PANIC: failed to re-find shared lock object > 2007-04-19 16:22:19 STATEMENT: COMMIT PREPARED Wow, that's interesting. > My question is: how could we proceed to get help? > Does an

[BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-19 Thread Michel Dorochevsky
The following bug has been logged online: Bug reference: 3245 Logged by: Michel Dorochevsky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows 2000 / XP / 2003 Description:PANIC: failed to re-find shared lock object Details: We are