Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 18:44, Scott Marlowe wrote: > On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang wrote: > > Weird that I receive your each message twice. > > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura < > rsmog...@softperience.eu> > > wrote: > >> > >> Simple and obvious question right now do

Re: [GENERAL] Weird problem that enormous locks

t;>> >>>> >>>> >>>>> Regards, >>>>> Radoslaw Smogura >>>>> (mobile) >>>>> - >>>>> From: Tony Wang >>>>> Sent: 15 lipca 2011 03:51 >

Re: [GENERAL] Weird problem that enormous locks

On Friday, July 15, 2011 3:52:13 am Radosław Smogura wrote: > On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: > > Weird that I receive your each message twice. > > Once message You get from mailing list, one because You are (B)CC. If it is continues to be a problem go to : http://www.post

Re: [GENERAL] Weird problem that enormous locks

lipca 2011 03:51 To: Scott Marlowe Cc: PostgreSQL Subject: Re: [GENERAL] Weird problem that enormous locks On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: On Wed, Jul 13, 2011 at 9

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 5:08 AM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 18:52, Radosław Smogura > wrote: >> >> On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: >>> >>> Weird that I receive your each message twice. >> >> Once message You get from mailing list, one because You are (B)CC. >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 18:52, Radosław Smogura wrote: > On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: > >> Weird that I receive your each message twice. >> > Once message You get from mailing list, one because You are (B)CC. > gmail should be clever enough handling that, at lease I didn't

Re: [GENERAL] Weird problem that enormous locks

t; >> >> >>> Regards, >>> Radoslaw Smogura >>> (mobile) >>> ----- >>> From: Tony Wang >>> Sent: 15 lipca 2011 03:51 >>> To: Scott Marlowe >>> Cc: PostgreSQL >>> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: Weird that I receive your each message twice. Once message You get from mailing list, one because You are (B)CC. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql

Re: [GENERAL] Weird problem that enormous locks

locks that relname is null. will add that, though no idea why its null   Regards, Radoslaw Smogura (mobile) - From: Tony Wang Sent: 15 lipca 2011 03:51 To: Scott Marlowe Cc: PostgreSQL Subject: Re: [GENERAL] Weird problem that enormous locks On

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang wrote: > Weird that I receive your each message twice. > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura > wrote: >> >> Simple and obvious question right now do You call commit after >> transaction? If yes do you use any query or connection pooler? > > Y

Re: [GENERAL] Weird problem that enormous locks

d that, though no idea why it's null > > > Regards, > Radoslaw Smogura > (mobile) > -- > From: Tony Wang > Sent: 15 lipca 2011 03:51 > To: Scott Marlowe > Cc: PostgreSQL > > Subject: Re: [GENERAL] Weird pro

Re: [GENERAL] Weird problem that enormous locks

: Re: [GENERAL] Weird problem that enormous locks On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> &

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 12:38, John R Pierce wrote: > On 07/14/11 7:58 PM, Tony Wang wrote: > >> >> There were 2519 RowExclusiveLock and 85 ExclusiveLock >> > > how could 800 max_connections have 2519 row locks ? do you update multiple > different rows in the same transaction? > > the row locks

Re: [GENERAL] Weird problem that enormous locks

On 07/14/11 7:58 PM, Tony Wang wrote: There were 2519 RowExclusiveLock and 85 ExclusiveLock how could 800 max_connections have 2519 row locks ? do you update multiple different rows in the same transaction? -- john r pierceN 37, W 122 santa cruz ca

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 10:42, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 10:05, Scott Marlowe > > wrote: > >> > >> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > >> > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > > >> > wrote: >

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 10:05, Scott Marlowe > wrote: >> >> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: >> > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe >> > wrote: >> >> >> >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: >> >> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 10:05, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > > wrote: > >> > >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > >> > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > > >> > wrote: >

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > wrote: >> >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: >> > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe >> > wrote: >> >> >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> >> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > > wrote: > >> > >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > >> > On Thu, Jul 14, 2011 at 10:35, John R Pierce > >> > wrote: > >>

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> > On Thu, Jul 14, 2011 at 10:35, John R Pierce >> > wrote: >> > It's a game server, and the queries are updating users' money, as

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 01:13, Scott Marlowe wrote: > On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > > On Thu, Jul 14, 2011 at 10:35, John R Pierce > wrote: > > It's a game server, and the queries are updating users' money, as normal. > > The sql is like "UPDATE player SET money = money + 1

Re: [GENERAL] Weird problem that enormous locks

On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > On Thu, Jul 14, 2011 at 10:35, John R Pierce wrote: > It's a game server, and the queries are updating users' money, as normal. > The sql is like "UPDATE player SET money = money + 100 where id = 12345". > The locks were RowExclusiveLock for the

Re: [GENERAL] Weird problem that enormous locks

t's > the way why we think about having 9.x server. > > > Regards, > Radoslaw Smogura > (mobile) > -- > From: Tony Wang > Sent: 14 lipca 2011 07:00 > To: John R Pierce > Cc: pgsql-general@postgresql.org > Su

Re: [GENERAL] Weird problem that enormous locks

From: Tony Wang Sent: 14 lipca 2011 07:00 To: John R Pierce Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Weird problem that enormous locks On Thu, Jul 14, 2011 at 12:35, John R Pierce wrote: On 07/13/11 8:47 PM, Tony Wang wrote: It's a game server, and the queries are updating u

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 12:35, John R Pierce wrote: > On 07/13/11 8:47 PM, Tony Wang wrote: > >> It's a game server, and the queries are updating users' money, as normal. >> The sql is like "UPDATE player SET money = money + 100 where id = 12345". >> The locks were RowExclusiveLock for the table

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 8:47 PM, Tony Wang wrote: It's a game server, and the queries are updating users' money, as normal. The sql is like "UPDATE player SET money = money + 100 where id = 12345". The locks were RowExclusiveLock for the table "player" and the indexes. The weird thing is there was another

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 10:35, John R Pierce wrote: > On 07/13/11 7:16 PM, Tony Wang wrote: > > On Thu, Jul 14, 2011 at 10:01, John R Pierce > pie...@hogranch.com>> wrote: >> >>On 07/13/11 6:55 PM, Tony Wang wrote: >> >>Could I consider it a hardware problem, or postgresql running >>

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 7:16 PM, Tony Wang wrote: On Thu, Jul 14, 2011 at 10:01, John R Pierce > wrote: On 07/13/11 6:55 PM, Tony Wang wrote: Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a mo

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 10:01, John R Pierce wrote: > On 07/13/11 6:55 PM, Tony Wang wrote: > >> Could I consider it a hardware problem, or postgresql running too long >> which causes problems? (It ran about half a month, however, it ran much >> longer than that without problems) >> > > i have po

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 6:55 PM, Tony Wang wrote: Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a month, however, it ran much longer than that without problems) i have postgres servers that run for months and even years without problems.

Re: [GENERAL] Weird problem that enormous locks

Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a month, however, it ran much longer than that without problems) On Wed, Jul 13, 2011 at 00:52, Tony Wang wrote: > Hi, > > The configuration information is listed at the end. > I met

Re: [GENERAL] Weird problem that enormous locks

On Wed, Jul 13, 2011 at 08:40, Craig Ringer wrote: > On 13/07/2011 12:52 AM, Tony Wang wrote: > >> Have any one experienced that, or any suggestion on researching/debugging? >> >> Capture the contents of pg_catalog.pg_stat_activity whenever your cron > job notices high lock counts. That'll give y

Re: [GENERAL] Weird problem that enormous locks

On 13/07/2011 12:52 AM, Tony Wang wrote: Have any one experienced that, or any suggestion on researching/debugging? Capture the contents of pg_catalog.pg_stat_activity whenever your cron job notices high lock counts. That'll give you some more information to work with. POST Newspapers 276 On

[GENERAL] Weird problem that enormous locks

Hi, The configuration information is listed at the end. I met this problem last weekend. The presentation was that, the db locks became enormous, up to 8.3k, and the db hanged there. About half an hour to one hour later, it recovered: the locks became 1 or 2 hundreds, which was its average level.