Technology Insights

Adding Redmine Project Error: ActiveRecord::StatementInvalid (Mysql::Error: Unknown column projects_count in field list

I was working on a project today for a client and after the initial research I realized that the project actually warranted an entire sub project account in Redmine. The reasoning behind this was even though the project would be using the same Ruby project code as the primary project this specific side project would need to allow access to the tickets for one of our partners. The easiest way to allow the partners accounts access to only a specific set of tickets, their own wiki, etc. would be to generate a sub Redmine project underneath of the primary Redmine project. So obviously the first thing to do was to add the project so I could start configuring it and this is where I ran into the initial issue. I received an internal server error when attempting to add the sub project within Redmine. Below I describe the issue, what I think caused the issue, and the end resolution that allowed me to start adding sub projects within Redmine again.

Technology Errors

CriticalMailer ::Exception:: FATAL C53300 Msorry, too many clients already Fproc.c L276 RInitProcess

I was tasked with troubleshooting a Ruby Rufus Task Scheduler issue today so I started with reviewing the log files. Upon digging into the logs I noticed numerous errors which are expanded below. The primary error appeared to be a connection issue from Ruby to PostgreSQL as it was complaining about too many connections. While the server I was looking into is actively used in a development environment the connections limit of 100 should have been more than enough to handle the load. After looking into the issue more I found out that some large Postgres queries from within the Ruby code were causing the issue and once those were optimized things started working properly. Below I describe the errors noticed via the Ruby logs, steps taken to troubleshoot the errors, and final resolution.

Technology Errors

FireFox: Error code: sec_error_untrusted_issuer

You may receive the below error in FireFox when attempting to add a SSL certificate security exception. If you do follow the below steps to be able to actually add the security exception.

Error: uses an invalid security certificate.
The certificate is not trusted because it is self signed.
(Error code: sec_error_untrusted_issuer)