Wongm's Rail Gallery » Home

Recent uploads

Last updated Monday, 27 September 2021 (1 day ago)

80,208 photos sorted by when they were uploaded.

  • Friday, 17 September

    18 new photos in the Track and overhead inspection vehicle EV120, McIntyre Loop, Metro Trains Melbourne - Northern group, Southern Shorthaul Railroad Bendigo locomotive transfers, Protective Services Officers, V/Line COVID-19 outbreak disruptions, V/Line bits and pieces, Transit Systems Victoria and Bus bits and pieces albums

  • Thursday, 16 September

    25 new photos in the Southern Shorthaul Railroad Kensington grain, Metro Trains Melbourne - Northern group, Transdev Melbourne, Automatic rail lubricators, V/Line - Regional Rail Link, V/Line COVID-19 outbreak disruptions, Melbourne suburban passenger information displays, Transit Systems Victoria, Pacific National - Sadleirs Logistics, Qube Logistics standard gauge cement train, SCT Logistics - Dooen freight, Metro Tunnel works at CBD South and Containers - railway owned albums

  • Monday, 13 September

    5 new photos in the Transit Systems Victoria, V/Line road coaches and CDC Melbourne albums

  • Sunday, 12 September

    18 new photos in the CDC Melbourne, Bus stops and infrastructure in Victoria, Transdev Melbourne, Transit Systems Victoria, Melbourne suburban passenger information displays, V/Line COVID-19 outbreak disruptions, Pacific National interstate steel trains and Myki albums

  • Saturday, 11 September

    36 new photos in the SCT Logistics - Sadleirs Logistics, Comeng retirement transfer, 11 September 2021, Metro Trains Melbourne - Northern group, Level crossings, Transit Systems Victoria, Melbourne suburban passenger information displays, CDC Melbourne, Commercialising commuters and Pacific National standard gauge grain albums

  • Friday, 10 September

    10 new photos in the Pacific National standard gauge Mildura freight, Vandals and scroats, Transdev Melbourne, Transit Systems Victoria, Bayside Coaches and Pacific National standard gauge grain albums

  • Thursday, 9 September

    7 new photos in the Pacific National - Sadleirs Logistics, V/Line - Regional Rail Link, Metro Trains Melbourne - Northern group, V/Line - Standard gauge to Albury and Southern Shorthaul Railroad works trains albums

  • Wednesday, 8 September

    1 new photo in the Transdev Melbourne album

On this day

15 years ago, 28 September 2006

N454 running 'wrong' line with an all stations train at Corio about to be overtaken by a VLocity train running express to North Melbourne.

80,000 photos!

Wednesday 15 September 2021 21:00 PM

It's taken sixteen years, but today I passed a milestone in photos uploaded to this site - 80,000!

This is the first time I've actually noticed such a milestone - I hit 10,000 photos way back in April 2009, 25,000 photos in April 2012 and 50,000 photos in August 2017.

Here's to a few thousand more!

Shooting myself in the foot

Thursday 22 July 2021 22:12 PM

The other night I did my usual updates to the web server that drives this website, and in the process I managed to blow away all of my data! Thankfully it's all back to normal now, and it only took me a few hours of wasted effort!

The backstory

My attempt to upgrade my webserver nuked the symlink to the data directory, then my attempt to recreate the symlink to get stuff working again, I deleted the actual data!

I have automated backups of the web server and the MySQL database, but I don't have automated backups of the data directory.

I eventually worked out how to recreate a working symlink to the data directory - I never documented it in my server build plan.

The next step was to reupload the 78900+ deleted files from my local backups, then check to see how out of sync that backup is!

On the upside, I had the database side of the restore working rather quickly and all of the metadata was available - I just need the files they describe to hurry up and get onto to the cloud - only 27.3 GB of data to upload! 

By monkeying around with my SFTP settings I was able to max out my upload bandwidth - have gone from 8 Mb/s to 9.5 Mb/s. Eventually it finished at 7.30am this morning.

The rest of the time has been syncing the out of date directory tree of files with what the database says was the "real" hierarchy. I did this by running SQL queries to generate bash scripts to move files to where they're supposed to go, and then create another set of scripts to delete duplicate files.