On 10/28/2013 05:52 PM, Stéphan BEUZE wrote:
> Is it OK if I send a test case written in Java ? Or is there a well
> defined way to post test case ?
A standalone test case written in Java is pretty easy to run. Just
provide build and run instructions - for example, if it's a stand-alone
file, inst
On Mon, Oct 28, 2013 at 3:22 PM, Stéphan BEUZE
wrote:
> Le 19/10/2013 05:21, Amit Kapila a écrit :
>> On Fri, Oct 18, 2013 at 3:43 PM, Stéphan BEUZE
>> wrote:
>>> * CONTEXT
>>> Two Java threads are created. One is connected with 'rec' user, while the
>>> other one
>>> is connected with 'rec_lct'
Le 19/10/2013 05:21, Amit Kapila a écrit :
On Fri, Oct 18, 2013 at 3:43 PM, Stéphan BEUZE
wrote:
Here I provide more details about the environment where the error occurs:
* ENVIRONMENT
Client:
Java Web Application running on JBoss 5.0.0.GA - JDK 1.6.0_24 64bit
Server:
Postgresql 9
On Fri, Oct 18, 2013 at 3:43 PM, Stéphan BEUZE
wrote:
> Here I provide more details about the environment where the error occurs:
>
> * ENVIRONMENT
> Client:
> Java Web Application running on JBoss 5.0.0.GA - JDK 1.6.0_24 64bit
>
> Server:
> Postgresql 9.2.4, compiled by Visual C++ build
=?ISO-8859-1?Q?St=E9phan_BEUZE?= writes:
>> So the question is about used extensions or contrib. (it can be loaded
>> by server, or in a session with LOAD, it can be auto-explain,
>> pg_stat_statement, ).
> I don't use any used extensions or contrib.
Well, you're doing *something* that you h
Those extensions are installed in the system, so you can install them in
PostgreSQL.
You may also have contrib run by servers without being pure extension.
So the question is about used extensions or contrib. (it can be loaded
by server, or in a session with LOAD, it can be auto-explain,
pg_sta
> > What PostgreSQL version is this?
>
> I'm using "Postgresql 9.2.4, compiled by Visual C++ build 1600,
> 64-bit"
> > Are there any triggers on any of these tables?
>
> There are no triggers.
>
> > Any noteworthy extensions installed?
>
> Here is the results returned by "select * from
> pg_
You may find additional answers in my last email.
However, I'll try to adress some of your questions.
a. Are there any new connections happening, how this table is getting
populated?
Check my last email.
b. How did you concluded that above sql statement leads to error,
because this e
Here I provide more details about the environment where the error occurs:
* ENVIRONMENT
Client:
Java Web Application running on JBoss 5.0.0.GA - JDK 1.6.0_24 64bit
Server:
Postgresql 9.2.4, compiled by Visual C++ build 1600, 64bit
Client and Server run on the same platform:
Windows
On 18/10/13 18:01, Amit Kapila wrote:
On Wed, Oct 16, 2013 at 5:55 PM, Stéphan BEUZE
wrote:
The following query is performed concurrently by two threads logged in with
two different users:
WITH raw_stat AS (
SELECT
host(client_addr) as client_addr,
pid ,
On Wed, Oct 16, 2013 at 5:55 PM, Stéphan BEUZE
wrote:
> The following query is performed concurrently by two threads logged in with
> two different users:
>
> WITH raw_stat AS (
> SELECT
>host(client_addr) as client_addr,
>pid ,
>usename
> FR
> What PostgreSQL version is this?
I'm using "Postgresql 9.2.4, compiled by Visual C++ build 1600, 64-bit"
> Are there any triggers on any of these tables?
There are no triggers.
> Any noteworthy extensions installed?
Here is the results returned by "select * from pg_available_extensions"
name
On Wed, Oct 16, 2013 at 8:25 AM, Stéphan BEUZE
wrote:
> The following query is performed concurrently by two threads logged in with
> two different users:
>
> WITH raw_stat AS (
> SELECT
>host(client_addr) as client_addr,
>pid ,
>usename
> FR
The following query is performed concurrently by two threads logged in
with two different users:
WITH raw_stat AS (
SELECT
host(client_addr) as client_addr,
pid ,
usename
FROM
pg_stat_activity
WHERE
usename = curr
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > I havn't built a reliable test case yet but I *think* the tuple
> > concurrently updated problem is with an analyze being run inside of a
> > function and also being run by autovacuum.
>
> If so it should be fixe
Stephen Frost <[EMAIL PROTECTED]> writes:
> I havn't built a reliable test case yet but I *think* the tuple
> concurrently updated problem is with an analyze being run inside of a
> function and also being run by autovacuum.
If so it should be fixed as of 8.2 --- I believe we changed the locking
r
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > Subject pretty much says it all. I've put up with this error in the
> > past when it has caused me trouble but it's now starting to hit our
> > clients on occation which is just unacceptable.
>
> Have you
Stephen Frost <[EMAIL PROTECTED]> writes:
> Subject pretty much says it all. I've put up with this error in the
> past when it has caused me trouble but it's now starting to hit our
> clients on occation which is just unacceptable.
Have you tracked down the exact scenario making it happen?
Greetings,
Subject pretty much says it all. I've put up with this error in the
past when it has caused me trouble but it's now starting to hit our
clients on occation which is just unacceptable.
The way I've seen it happen, and this is just empirically so I'm not
sure that it's exactly
19 matches
Mail list logo
