Re: java.lang.OutOfMemoryError: GC overhead limit exceeded

Поиск
Список
Период
Сортировка
От Christophe combet
Тема Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Дата
Msg-id 1988332937.9191166.1595514781712@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: java.lang.OutOfMemoryError: GC overhead limit exceeded  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: java.lang.OutOfMemoryError: GC overhead limit exceeded  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения
Dear Rob,

Total RAM is 512GB.

Runtime.getRuntime().freeMemory() says: 7,630,918,904 at the time of issuing the query.

jConsole timed out and it is impossible to reconnect. I did a screen capture at the time of the freeze.

Le jeudi 23 juillet 2020 à 15:33:34 UTC+2, Rob Sargent <robjsargent@gmail.com> a écrit :




On 7/23/20 6:30 AM, Christophe combet wrote:
>
> Thank you for pointing the link between auto commit an buffering.
>
> autocommit=false: same exception.
>
> We try fetchSize.
>
> Thanks.
> Le jeudi 23 juillet 2020 à 13:47:14 UTC+2, Vladimir Sitnikov
> <sitnikov.vladimir@gmail.com> a écrit :
>
>
>  >can you try switching to autocommit=false?
>
> + you probably need to configure fetchSize as well.
>
> Vladimir

>
You set the 8G limit on the java process but did you tell up the
available RAM?  This query would require that about 3G be available to
hold all the data. Can you use jConsole to establish how much memory is
available at the time of issuing the query?



Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Jorge Solórzano
Дата:
Сообщение: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded