I have tried the database application for mysql and postgres too. When I use pv type as OSS, and deploy the application, pods goes in CrashbackLoopOff. The error which I am constantly getting is
chown: changing ownership of '/var/lib/mysql/': Input/output error(For PostgreSQL I get the same error with var/lib/postgresql/data.)
The path which it is giving error is of container.The ways which I tried is, before uploading files to OSS I changed the ownership of files and folders from 999 to root and then uploaded to OSS. But then also I am getting this error for every database. Please give me solution for this as I am stuck from longer time. Thanks in Advance
If I understand you correctly there are few things you can do:
Launch the db container as root and than chown the directory. In case of mysql if you still can't change it than try running sudo chown -R mysql:mysql /var/lib/mysql as mysql:mysql is the default ownership there.
Use initContainer in order to change the target folder to /var/lib/mysql/
Use securityContext for containers. For example:
containers:
- name: mysql
image: <msql_image>
securityContext:
runAsUser: 0It should all also work for postgresql.
Please let me know if that helped.