Backend error when trying to add plant

[Sennevds]

Avoid duplicated bug reports

• [X] I've found a bug and checked that there are no open or closed bug report related to this.

Description

When trying to add a new plant via the search option I get following error as response: { "statusCode": 500, "errorCode": "INTERNAL_SERVER_ERROR", "message": "Could not commit JPA transaction" } In the backend logs nothing is shown

Expected behaviour

No response

Steps to reproduce

No response

Local environment

No response

Additional info

No response

[MDeLuise]

Hi @Sennevds, thanks for opening the issue! I just pushed an hotfix version of the backend service, the 0.4.1, could you please try if the problem is fixed in that version?

[Sennevds]

Works thanks for the fast response!

[MDeLuise]

Thank you for reporting this issue and using the project!

[nykroy]

I have the jpa transaction error. And the app said i have 0.3 version after Re-pull image and redeploy :s

My stack file:

version: "3" name: plant-it services: backend: image: msdeluise/plant-it-backend:latest environment:

• MYSQL_HOST=db
• MYSQL_PORT=3306
• MYSQL_USERNAME=root
• MYSQL_PSW=root
• MYSQL_ROOT_PASSWORD=root
• MYSQL_DATABASE=bootdb
• JWT_SECRET=putTheSecretHere
• JWT_EXP=1
• USERS_LIMIT=-1
• UPLOAD_DIR=/upload-dir
• API_PORT=8080
• CACHE_TTL=86400
• CACHE_HOST=cache
• CACHE_PORT=6379
• TREFLE_KEY=XXXXX
• ALLOWED_ORIGINS=*
• LOG_LEVEL=DEBUG
• UPDATE_EXISTING=false
• SMTP_HOST=smtp.gmail.com
• SMTP_PORT=587
• SMTP_EMAIL=xxxx
• SMTP_PASSWORD=xxxx
• SMTP_AUTH=true
• SMTP_START_TTL=true
• CONTACT_MAIL=xxxx
• SSL_ENABLED=false

• CERTIFICATE_PATH=/certificates/

  depends_on:
    - db
    - cache
  restart: unless-stopped
  volumes:
    - "/volume2/docker/plant-it/upload-dir:/upload-dir"
    - "/volume2/docker/plant-it/certs:/certificates"
  ports:
    - "8080:8080"

  db: image: mysql:8.0 restart: always environment:

• MYSQL_HOST=db
• MYSQL_PORT=3306
• MYSQL_USERNAME=root
• MYSQL_PSW=root
• MYSQL_ROOT_PASSWORD=root
• MYSQL_DATABASE=bootdb
• JWT_SECRET=putTheSecretHere
• JWT_EXP=1
• USERS_LIMIT=-1
• UPLOAD_DIR=/upload-dir
• API_PORT=8080
• CACHE_TTL=86400
• CACHE_HOST=cache
• CACHE_PORT=6379
• TREFLE_KEY=
• ALLOWED_ORIGINS=*
• LOG_LEVEL=DEBUG
• UPDATE_EXISTING=false
• SMTP_HOST=smtp.gmail.com
• SMTP_PORT=587
• SMTP_EMAIL=xxxx
• SMTP_PASSWORD=xxxxx
• SMTP_AUTH=true
• SMTP_START_TTL=true
• CONTACT_MAIL=xxxx
• SSL_ENABLED=false

• CERTIFICATE_PATH=/certificates/

  volumes:
    - "/volume2/docker/plant-it/db:/var/lib/mysql"

  cache: image: redis:7.2.1 restart: always

  frontend: image: msdeluise/plant-it-frontend:latest environment:

• PORT=3000
• API_URL=http://192.168.218.10:8080/api
• WAIT_TIMEOUT=10000
• CACHE_TTL_DAYS=7
• BROWSER=none
• SSL_ENABLED=false
• CERTIFICATE_PATH=/certificates/ links:
  • backend ports:
  • "3000:3000" volumes:
    • "/volume2/docker/plant-it/certs:/certificates" volumes: certs: driver: local driver_opts: type: none o: bind device: ./certificates

[nykroy]

With image: msdeluise/plant-it-backend:0.4.1 i have the same problem

[MDeLuise]

Hi @nykroy, thanks for bringing this issue to my attention. Could you please let me know when you encountered the issue?

I apologize for the inconvenience caused. It appears that the version number in the releases of the app was not updated correctly, leading to the display of 0.3.0 instead of 0.4.1. I will push a small fix for this tomorrow morning.

Thank you for your patience and understanding.

[nykroy]

thank you for your super usefull app 😃!

I encountered when i do a re-pull image and redeploy on my stack on portainer

[MDeLuise]

Thank you for using the project! 😁 Unfortunately as you noticed, some little bugs were introduced in the last release but I'm working on fixing them.

I just pushed a 0.4.2 version of the backend, now the app should show the right version. Could you please download this new version and let me know if your problem still persist?

[nykroy]

Now i have the correct version. I can add reminder but i can activate reminders The error on backend is: WARN 12 --- [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning

[nykroy]

Ok the notification problem IS solved configuring email address for the user. 🤣. All problems are solved with 0.4.2 and email config

[MDeLuise]

Great that was that! 😁 If you incurred in any other issue you're welcome to open a bug

Happy planting 🪴