Hi, I only just installed ROCKSTOR a couple of days ago, configured a couple of drives as RAID1 and copied some data over, oh and installed Plex. This has happened a couple of times, but basically it is not working at all, cannot logon to the web, plex is offline, the drives were unmounted. Rebooting brought the drives back online, but still cannot logon to web. SSH is fine.
Thanks for the logs. The error is clear and coincidentally, I saw the same problem on a machine here this morning. The problem is that postgres connections are accumulating over time causing this error. However, I am not sure of the root cause yet. Looking into it.
When you see this problem, you don’t need to reboot. Just restart postgres: systemctl restart postgresql.
While I am thinking of it, what is the extensibility model for using postgres - I assume I can count on it running, and if I want to create tables and store data there, that’s fine, I should just make sure I back up my tables and schema before a system update or something. I searched in your docs and only found this reference, http://rockstor.com/docs/contribute.html?highlight=postgresql, which seems to suggest I could create my own database and use it.
Hi @Nick, yes it is the same issue. I haven’t gotten to the root cause yet, seems like there’s a slow connection leak perhaps triggered by data-collector service. Are you able to consistently reproduce it? If so, are you able to reproduce it even if you leave the UI in static page such as Storage -> Disks?
Rockstor creates two databases during first install and these databases are never deleted. Any database other than Rockstor’s own are not messed with either. You sure can create your own.