search

Andrew0Hill / NURS6293_environment

Docker-based environment to provide desktop interface and database access for NURS 6293.
0 stars 0 forks source link

BIRT Increase shared memory space or java memory? #29

Closed mgkahn closed 1 month ago

mgkahn commented 1 month ago

I think that is what's causing BIRT to complain. Complex query but it only returns 5 rows. Runs fine in DBeaver.

image
Andrew0Hill commented 1 month ago

I can try to fix this, can you give me the query you used so I can replicate?

mgkahn commented 1 month ago

This can wait. I need to read up on how to use BIRT. I know you have lots of Family LInkage work you are trying to complete before tomorrow. SQL file attached. birt_HTN_ACC_ESH.sql.txt

Andrew0Hill commented 1 month ago

Had some time while queries are running, so took a look.

It looks like this was caused by too little shared memory being allocated to the Postgres container. I replicated the error, then added shm_size: "1gb" to the docker-compose.yml under the Postgres container, and I was able to produce the report successfully.

I pushed the changed docker-compose.yml, let me know if it works for you.

mgkahn commented 1 month ago

Will test today. Interesting that it was the PG container. The query ran successfully using DBeaver but not BIRT so I thought it would turn out to be the Desktop container or java heap memory for BIRT.

Andrew0Hill commented 1 month ago

Tried some larger queries with the increased shared memory limit, and am not having any issues. We can re-open if this issue reappears.