Wongm's Rail Gallery » Home

Recent uploads

Last updated Thursday, 21 October 2021 (today)

60 photos added in the past 3 days, 167 photos added in the past 7 days, a total of 80,822 photos sorted by when they were uploaded.

  • Wednesday, 20 October

    15 new photos in the Qube Logistics hay train, Southern Shorthaul Railroad Kensington grain, Southern Shorthaul Railroad standard gauge grain, Qube Logistics Apex quarry train and Metro Trains Melbourne - Northern group albums

  • Tuesday, 19 October

    2 new photos in the CDC Melbourne and Transit Systems Victoria albums

  • Monday, 18 October

    30 new photos in the Qube Logistics hay train, CDC Melbourne, Transdev Melbourne, Pacific National standard gauge grain, Metro Trains Melbourne - Northern group, HCMT set 34 delivery transfer, October 2021, Qube Logistics Apex quarry train and V/Line - Regional Rail Link albums

  • Sunday, 17 October

    13 new photos in the Pacific National interstate steel trains, Stored Comeng trains, Pacific National standard gauge grain, V/Line - Standard gauge to Albury and Pacific National - Western standard gauge albums

  • Saturday, 16 October

    35 new photos in the SCT Logistics - Melbourne/Perth services, Metro Trains Melbourne - Northern group, CDC Melbourne, V/Line transfers, Melbourne suburban bits and pieces, Pacific National - North East standard gauge freight, McIntyre Loop, Qube Logistics standard gauge cement train, SCT Logistics - Melbourne/Brisbane services and Sunbury Line Upgrade albums

  • Friday, 15 October

    30 new photos in the Steamrail - K183 test runs, October 2021, Metro Trains Melbourne - Northern group, Transit Systems Victoria, SCT Logistics - Melbourne/Brisbane services, AK track recording cars, V/Line - Regional Rail Link, Pacific National - North East standard gauge freight and Pacific National - Sadleirs Logistics albums

  • Thursday, 14 October

    20 new photos in the SCT Logistics - Sadleirs Logistics, Metro Trains Melbourne - Northern group, Pacific National interstate steel trains and Rail creep monuments albums

  • Wednesday, 13 October

    22 new photos in the Southern Shorthaul Railroad standard gauge grain, Stored Comeng trains, V/Line - standard gauge VLocity testing, CDC Melbourne, V/Line - Regional Rail Link, ARTC trackwork, Metro Trains Melbourne - Northern group, SCT Logistics - Altona depot and light engine moves, North Dynon locomotives, Pacific National - Western standard gauge, Pacific National - North East standard gauge freight and SCT Logistics - Melbourne/Brisbane services albums

On this day

5 years ago, 21 October 2016

New 'Video monitoring in tunnel' signage at the Northern Loop platform at Flagstaff station.

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.