Technology Insights

Skype Instant Message History Using 100% CPU On OSX

I really miss the old versions of Skype on my Macbook running OSX Mountain Lion. While I could just download and install one of the Skype version for .DMG’s some people I talk with require the newer version of Skype to use some of the features not available in the older versions, etc. I wish Skype would stop with the Facebook integration and all the other fancy stuff and just allow me to send instant messages and make phone calls as I am not sure I have ever seen a piece of software that I once liked so much take so many steps backwards. Anyhow the issue at hand is Skype on OSX Mountain Lion using all of your computers CPU and unfortunately my resolution to the issue is to use a third party application to view Skype history.

Technology Insights

PostgreSQL: Run A SELECT Statement From A Linux Shell Using PSQL

Earlier today I was troubleshooting some resource issues on a PostgreSQL server and needed to test some various SELECT statements to see if any of them were causing problems. I also wanted to verify the amount of resources a SELECT statement made using PGAdmin versus the amount of resources the same SELECT statement used running it directly on the Postgres server itself. Below is information on how to run a SELECT statement from a Linux shell. In this example the server is running CentOS Linux and PostgreSQL 8.4.4.

Technology Insights

No operator matches the given name and argument type(s). You might need to add explicit type casts.

When working on writing some directions for someone at work I ran into a PostgreSQL command line query error. I have much more experience using MySQL so my initial Postgres commands always mimic what I would do in MySQL. Anyhow when attempting to run a SELECT statement matching contents of a specific column I received the error below. After a little research I came up with the answer fairly easily but wanted to note here to help others out and serve as a reference point if I forgot the proper PSQL query in the future. Below I describe the query that caused the error, the error returned by Postgres, and the proper query to use when attempting to match a variable in a Postgres SELECT statement.

Technology Insights

Gentoo Server Error: Superblock mount time is in the future

I was working on a Gentoo server today and had another time stamp issue. This may have been related to the one I wrote about yesterday because in addition to that error now I was getting a “Superblock mount time is in the future” error which was saying that the mount time of my drives was in the future. The server would not boot and I had to run a manual fsck every time to get it to boot. Clearly this was not normal behavior so I decided to dig into the problem. I rarely reboot the servers so I never noticed this behavior.