Hello Community,
Alright so every other day I'm getting this error when i try to login to either webmail or owncloud.
Im not sure exactly what started triggering it but i usually have to restart everything to get it to clear up.
Any idea why the system database is getting too many connections after a few days?
Right now I'm the only user.
So far i have killed many of the network reporting apps as i saw somewhere else that those can cause this.
Alright so every other day I'm getting this error when i try to login to either webmail or owncloud.
Im not sure exactly what started triggering it but i usually have to restart everything to get it to clear up.
Any idea why the system database is getting too many connections after a few days?
Right now I'm the only user.
So far i have killed many of the network reporting apps as i saw somewhere else that those can cause this.
In Database
Share this post:
Responses (12)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Hello
I just experienced a zarafa crash as well.
I checked the number of connections to system-mysql and got over 300
I restarted system-mysql with
service system-mysqld restart
and checked again and got 23
the system-mysql log is rather empty.
Just a few lines about the restart I had to do to get going again.. -
Accepted Answer
OK - looks fine
Do you have any third party clients connecting to the service? perhaps one is not terminating it's connections properly and leaving open database connections. The database has a default number of connections to maintain and can be modified to improve this number (150+) but that would seem only to be a work around and not to understand why its happening
If you're happy to drop to the command line it might be useful to see how many connections are open? 'netstat -ntp | grep 3308'
You can also count the number of connections by piping the output through wc, 'netstat -ntp | grep 3308 | wc -l' -
Accepted Answer
8GB
3 users total / 1 actually being used.
system-mysql
i don't use the mysql server app, everything is using the system database.
Yes i have both webmail and owncloud using only 443, port 80 redirects to the 443 side of the site.
Ill enable reports again but last time i checked there hasn't been any out of the norm traffic spikes or anything of the sort.
Seems to take about 2-3 days to come back with this error and then i cannot log into webmail or owncloud as i get this message when trying. -
Accepted Answer
Hi Nathan, did you see my response here? do you have enough RAM?
How many users? which log file is the error shown in? mysql or system-mysql?
http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,33/func,view/id,64010/limit,10/limitstart,10/#64215
Is your webserver open to the world and could be the result of a brute force type login attack? you might find clues for failed authentication in the OwnCloud logs or monitor incoming port 80/443 traffic -
Accepted Answer
-
Accepted Answer
pmacct is one of three programs installed be the app-network-detail-report and is only used by it. To remove it do:
Instead of the service command you could do a "killall pmacctd". Normally be very careful about using "yum remove" as it can remove the heck of a lot of dependencies - "rpm -e" is safer. In this case yum is fine.service pmacctd stop
yum remove pmacct -
Accepted Answer
-
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »