Wongm's Rail Gallery » Home

Recent uploads

Last updated Thursday, 22 July 2021 (3 days ago)

10 photos added in the past 3 days, 10 photos added in the past 7 days, a total of 78,973 photos sorted by when they were uploaded.

  • Thursday, 22 July

    10 new photos in the CDC Melbourne, V/Line hired locomotives, The lighter side of..., Unsafe 'safety' zone in Ascot Vale, Seymour Railway Heritage Centre depot, Rail threader wagon CFCF 1 and Pacific National Warrnambool freight albums

  • Monday, 12 July

    38 new photos in the Southern Shorthaul Railroad Bendigo locomotive transfers, Metro Trains Melbourne - Northern group, Transit Systems Victoria, V/Line - Standard gauge to Albury, CDC Melbourne, Transdev Melbourne, Public transport response to the Coronavirus pandemic, Melbourne suburban bits and pieces, Bus bits and pieces, Kastoria Bus Lines, Qube Logistics Apex quarry train, V/Line - Regional Rail Link, V/Line around Melbourne, Pacific National standard gauge grain, Melbourne railway traction substations and Vandals and scroats albums

  • Sunday, 11 July

    64 new photos in the Southern Shorthaul Railroad works trains, Tullamarine Bus Lines, Dee Decker Tours, Metro Trains Melbourne - Northern group, Melbourne Airport Rail, Sunbury Line Upgrade, Transdev Melbourne, Kastoria Bus Lines, V/Line rail replacement buses, V/Line - Regional Rail Link, Track, rail and sleepers, Pacific National interstate steel trains, ARTC trackwork, Qube Logistics Ettamogah freight, Pacific National - Western standard gauge and Melbourne signals and signalling equipment albums

  • Saturday, 10 July

    1 new photo in the V/Line rail replacement buses album

  • Tuesday, 6 July

    1 new photo in the Bus stops and infrastructure in Victoria album

  • Monday, 5 July

    184 new photos in the Flinders Street Station ballroom, Melbourne tram works, Locomotives, light engines, and lashups, Melbourne Yard, Yarra Trams - Melbourne CBD and Docklands, Metro Trains Melbourne - inner suburban, Sunbury Line Upgrade replacement buses, Metro Trains Melbourne - Northern group, Transdev Melbourne, Transit Systems Victoria, V/Line - Regional Rail Link, Railway advertising and promotions, V/Line at Southern Cross Station, Flinders Street Station, Bus bits and pieces, V/Line workshops, yards and shunting, Qube Logistics broad gauge cement train, V/Line carriage interiors, Melbourne infrastructure inspection trams, Melbourne suburban bits and pieces, Metro Tunnel works at South Kensington, Road coaches, North Dynon, Long Island steel train, Metro Tunnel works at CBD South, Flinders Street Station upgrade, V/Line around Melbourne, Failing infrastructure at Southern Cross Station, High Capacity Metro Train test running, Yarra Trams - diverted and out of place, Public transport response to the Coronavirus pandemic, V/Line trackwork and maintenance, TPWS in suburban Melbourne and Amskan RFID train identifier tags albums

  • Sunday, 4 July

    33 new photos in the Pacific National interstate steel trains, Transdev Melbourne, Car parking at Melbourne stations, Sunbury Line Upgrade, Transit Systems Victoria, Sunbury Line Upgrade replacement buses, V/Line rail replacement buses, Bus stops and infrastructure in Victoria, Public transport response to the Coronavirus pandemic and Containers - railway owned albums

  • Saturday, 3 July

    32 new photos in the Bellarine Peninsula Railway, Grounded wagons, carriages and trams, McHarry's Buslines, Pacific National standard gauge grain, Locomotives, light engines, and lashups, Southern Shorthaul Railroad Kensington grain, Road coaches, Qube Logistics hay train, CDC Geelong, Pacific National broad gauge grain and Airport buses of Victoria albums

On this day

5 years ago, 25 July 2016

Passenger shelters at the Sir Robert Risson tram terminus on Elizabeth Street.

Shooting myself in the foot

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.

I'm now on Instagram as well

1 April 2021 00:11 AM

I've been on Facebook and Twitter for some time now, and thanks to the magic of automation I'm now on Instagram as well - you can follow me at @wongmsrailgallery. There you'll find my usual notifications of new photos, as well as my daily 'on this day' posts.