On 09/13/2011 11:04 PM, Grzegorz Jaśkiewicz wrote:
2011/9/13 Merlin Moncure:
2011/9/13 Grzegorz Jaśkiewicz:
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
yup -- you destroyed all the evidence. if it happens again, try
posti
2011/9/13 Grzegorz Jaśkiewicz :
> 2011/9/13 Merlin Moncure :
>> 2011/9/13 Grzegorz Jaśkiewicz :
>>> I'm guessing I won't get much more from devs , without providing more
>>> info here which unfortunately has been lost.
>>
>> yup -- you destroyed all the evidence. if it happens again, try
>> postin
2011/9/13 Merlin Moncure :
> 2011/9/13 Grzegorz Jaśkiewicz :
>> I'm guessing I won't get much more from devs , without providing more
>> info here which unfortunately has been lost.
>
> yup -- you destroyed all the evidence. if it happens again, try
> posting some more info, particularly what's go
2011/9/13 Grzegorz Jaśkiewicz :
> I'm guessing I won't get much more from devs , without providing more
> info here which unfortunately has been lost.
yup -- you destroyed all the evidence. if it happens again, try
posting some more info, particularly what's going on with locks,
pg_stat_activity,
I'm guessing I won't get much more from devs , without providing more
info here which unfortunately has been lost.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2011/9/12 Merlin Moncure :
>
> It seems odd that you could not create a temp sequence but you were
> able to reindex the entire database. did you confirm you were
> blocking on a non-granted lock?
I could revacuum/reindex all stuff, only if I had to do the system
catalogues first. That seemed a
2011/9/12 Grzegorz Jaśkiewicz :
> So here's the thing. I got a message from one of the developers, that
> running 'create temporary sequence xyz;' hangs on the database.
> That seemed suspicious. I tried running any ddl command, and that hang.
> No other connections to the database.
>
> It turned o
So here's the thing. I got a message from one of the developers, that
running 'create temporary sequence xyz;' hangs on the database.
That seemed suspicious. I tried running any ddl command, and that hang.
No other connections to the database.
It turned out that it had a power failure earlier in t
