One of my larger fears when I bought my Subaru Impreza with a CVT transmission was that the transmission would fail early, but not early enough to be covered by warranty. I saw talk online about reliability problems with the tech, which was fairly new to cars, with the Impreza only being in its second year with them I believe. On last Wednesday, my transmission did fail, but luckily it is going to work out alright, as Subaru of America (SOA) is going to help me out.
Continue reading post "Impreza transmission death"problem posts page 5
I was all ready to head off to work this morning when my Subaru Impreza’s transmission started acting up.
Continue reading post "#3623"My boot has died, or at least was maimed. Trudging through the snow for one of my morning walks, the sole came off at the front and started hanging down, catching on the snow as I went.
Continue reading post "#3618"My furnace stopped working again yesterday. Luckily I was able to get it running again myself this time.
Continue reading post "#3566"My old eBay username / email seems to no longer exist in eBay’s system. I used it as recently as fourteen years ago. Disappointing: I have to start over there.
Rsync and dealing with “some files vanished” warning
I use rsync for backups, site deployments, and other purposes where I need to sync two folders. It took a little while to figure out, but has been great for those purposes since. Every once in a while, though, I run into issues with it. Recently, I set up an rsync script to back up most of the files on my entire computer. Since this takes a while and the computer is actively running during the backup, things can change while it is still running. This can lead to some errors like “rsync warning: some files vanished before they could be transferred”. Even though this is a warning, and the sync works perfectly fine, it returns a non-zero exit code. This caused my script to stop and thus the rest of the backup activity didn’t finish.
I looked for an option or simple solution to allow it to go on without complaining.
Continue reading post "Rsync and dealing with “some files vanished” warning"My furnace was fixed on Monday, just a few days after stopping working. I called Echols because of a sticker on the furnace and the fact that they work on Carrier furnaces. They came about an hour later.
Continue reading post "#3547"My furnace stopped working. Luckily this house has a lot of thermal mass (brick) and is well insulated, plus has newer windows.
Continue reading post "#3541"MySQL: DELETE with sub-query on same table
I had an issue with a MySQL query containing a sub-query recently where it worked fine when done as a SELECT query, but gave an error when switching it to a DELETE query. The error given was something like ‘You can’t specify target table “items” for update in FROM clause’. The sub-query was referencing the same table as the main query, which apparently can’t be done directly in MySQL because the table will be modified during deletion. But there is a sort of a hack I found in this StackOverflow answer, among others, to force it to create a temp table and allow it to work.
Swap file for composer out of memory problems
PHP’s defacto package manager, composer, has long required large amounts of memory to do updates for larger projects, often more than servers or virtual machines have. The script will die with an out of memory error, or more recently, the simple message “Killed”, and do no work in these situations. The normal procedure is to develop locally, deploy local lock file (composer.lock) to the server, and run composer install instead of update. But I’ve recently moved to doing most of my development in VMs, so I have had to work around this problem to get things installed or updated. A swap file is the solution for Linux machines provided in the official docs and expanded in a StackOverflow answer.