Search Postgresql Archives

Re: [HACKERS] pgjdbc logical replication client throwing exception

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Andres,

I also checked server log. Nothing unusual is recorded there.
Do  you have any other suggestion. Thank you.

Best regards,
Dipesh Dangol

On Fri, Sep 15, 2017 at 11:32 PM, Dipesh Dangol <ddipeshdan@xxxxxxxxx> wrote:
Hi Vladimir,
Ya, initially I was trying with withStatusInterval(20, TimeUnit.SECONDS),
that didn't work so, then only I switched to 
.withStatusInterval(20, TimeUnit.MILLISECONDS)
but it is not working as well. I am not aware of type of test cases that you are pointing.
Could you please send me any link for that one.

For generating the load, I am using benchmarkSQL, which will generate around 9000
transactions per second. I am trying to run streamAPI at the same time
BenchmarskSQL is generating load. If i don't run benchmarkSQL it works fine I mean
when there are only few transactions to replicate at a time, it works fine. But when
I run it with that benchmarskSql and try to add some logic like some conditions, then
it breaks down in between, most of the time within few seconds.

Hi Andres,
I haven't check the server log yet. Now, I don't access to my working
environment, I will be able to check that only on Monday. If I find any suspicious
thing in log, I will let you know.

Thank you guys.







On Fri, Sep 15, 2017 at 10:05 PM, Andres Freund <andres@xxxxxxxxxxx> wrote:
On 2017-09-15 20:00:34 +0000, Vladimir Sitnikov wrote:
> ++pgjdbc dev list.
>
> >I am facing unusual connection breakdown problem. Here is the simple code
> that I am using to read WAL file:
>
> Does it always fails?
> Can you create a test case? For instance, if you file a pull request with
> the test, it will get automatically tested across various PG versions, so
> it would be easier to reson about
>
> Have you tried "withStatusInterval(20, TimeUnit.SECONDS)" instead of 20
> millis? I don't think it matter much, however 20ms seems to be an overkill.

Also, have you checked the server log?

- Andres



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux