.
>
> Regards
>
>
> *Envoyé:* mardi 19 mars 2024 à 14:53
> *De:* "Joe Witt"
> *À:* users@nifi.apache.org
> *Objet:* Re: java.lang.OutOfMemoryError: Java heap space : NIFI 1.23.2
> Hello
>
> The key output is
>
> java.lang.OutOfMemoryError: Jav
; to 1 and it is worked.
Regards
Envoyé: mardi 19 mars 2024 à 14:53
De: "Joe Witt"
À: users@nifi.apache.org
Objet: Re: java.lang.OutOfMemoryError: Java heap space : NIFI 1.23.2
Hello
The key output is
java.lang.OutOfMemoryError: Java heap space
Review batch prope
Specifically set Fetch Size to something like 1000, by default setting
Fetch Size to zero will cause Postgres to fetch the entire ResultSet into
memory [1]. We should probably change that default to avoid problems like
this and with other drivers (for example, Oracle's default is 10 rows which
is
Hello
The key output is
java.lang.OutOfMemoryError: Java heap space
Review batch property options to limit response sizes in the database calls.
Thanks
On Tue, Mar 19, 2024 at 6:15 AM wrote:
> Hello
>
> I got the executeSQL processor does the sql command "select * from
> public.table1"
>
Hello
I got the executeSQL processor does the sql command "select * from public.table1"
It is a postgresql database.
Here the end of properties of processor.
Max Wait Time 0 seconds
Normalize Table/Column Names false
Use Avro Logical Types false
Compression Format NONE