java memory error

[Ahobert]

oa2020cadata/analysis/002_kb_rp_coverage.Rmd

Line 342 in 638834b

#### Backup in KB table space

When trying to backup the table rp_ind_df to Kb table space, it throws me a java.lang.OutOfMemoryError. However, the table takes up less than 1 gb according to R and my maximum heap size seems to be at 4 gb.

[njahn82]

Does it work on the script server?

…

On Wed, 23 Oct 2019 at 12:05, Ahobert ***@***.***> wrote: https://github.com/subugoe/oa2020cadata/blob/638834be4cf4686f6946543ee99aebbd482baacc/analysis/002_kb_rp_coverage.Rmd#L342 When trying to backup the table rp_ind_df to Kb table space, it throws me a java.lang.OutOfMemoryError. However, the table takes up less than 1 gb according to R and my maximum heap size seems to be at 4 gb. [image: Screenshot (39)] <https://user-images.githubusercontent.com/44192428/67382005-169b9680-f58d-11e9-968a-fcec2a919980.png> [image: Screenshot (40)] <https://user-images.githubusercontent.com/44192428/67382008-17ccc380-f58d-11e9-9441-111a355429ba.png> — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#3?email_source=notifications&email_token=AAM7YRQEBXZ7E4XOHA2LL3DQQAOXTA5CNFSM4JD67CHKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTYRYPQ>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAM7YRWVFZQ2K7RFR7VDMOLQQAOXTANCNFSM4JD67CHA> .

[njahn82]

Did you allocate memory before loading "rJava"? https://stackoverflow.com/questions/34624002/r-error-java-lang-outofmemoryerror-java-heap-space

…

On Wed, 23 Oct 2019 at 12:14, Najko Jahn ***@***.***> wrote: Does it work on the script server? On Wed, 23 Oct 2019 at 12:05, Ahobert ***@***.***> wrote: > > https://github.com/subugoe/oa2020cadata/blob/638834be4cf4686f6946543ee99aebbd482baacc/analysis/002_kb_rp_coverage.Rmd#L342 > > When trying to backup the table rp_ind_df to Kb table space, it throws me > a java.lang.OutOfMemoryError. However, the table takes up less than 1 gb > according to R and my maximum heap size seems to be at 4 gb. > > [image: Screenshot (39)] > <https://user-images.githubusercontent.com/44192428/67382005-169b9680-f58d-11e9-968a-fcec2a919980.png> > > [image: Screenshot (40)] > <https://user-images.githubusercontent.com/44192428/67382008-17ccc380-f58d-11e9-9441-111a355429ba.png> > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <#3?email_source=notifications&email_token=AAM7YRQEBXZ7E4XOHA2LL3DQQAOXTA5CNFSM4JD67CHKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTYRYPQ>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AAM7YRWVFZQ2K7RFR7VDMOLQQAOXTANCNFSM4JD67CHA> > . >

[Ahobert]

I did allocate memory, even increased the preimplemented value - still did not work. I did not try on the scriptserver yet.

I was, however, able to write tables as in here:

oa2020cadata/analysis/001_kb_rp_pretest.Rmd

Lines 196 to 200 in 638834b

	```{r}
	dbWriteTable(conn = jdbcConnection,
	name = "rp_countries_table",
	value = rp_countries)
	```