Notices by gled (gled@mastodon.host)

Makes you feel it was written by a great team of professionals for almost everyone...

not only for experienced sysadmins...

#serverannounce

Thanks to @ajroach42 we found that our peertube instance https://peertube.mastodon.host lost some videos.. no idea how it happened but it seems like videos that were not transcoded ( because below the 480p minimum transcode resolution activated ) were lost. Not present anymore on disk, and I only keep 2 days of peertube data backups ( space issue, you can imagine why ).

The database though was still referencing those videos, so I ran a cleanup sanity check. It impacted 442 entries, that are now deleted from the DB.

Apparently it appeared on other instances too, so instance owners, you may want to check. We are currently suspecting an issue during an upgrade...

( Easy one liner to adapt to your pgsql creds and domain and min resolution supported, you also may want to remove the psql DELETE for just a sanity check ):

cd /var/www/peertube/storage/videos; psql -U peertube -p 5432 -h 127.0.0.1 -q -c "select url from video where url like 'YOURFULLURL/%';" peertube_prod | grep https | cut -d / -f 6 | while read -r uuid; do if [ ! -f $uuid-480.mp4 ]; then echo "File not found: $uuid"; psql -U peertube -p 6432 -h 127.0.0.1 -q -c "DELETE FROM video where url = 'YOURFULLURL/videos/watch/$uuid'" peertube_prod; fi; done

Solar powered micro datacenter in the work: the autonomous Datashedter ( need a better name, or sleep a bit more before naming things ... )

- 400W solar panels on top and a bunch of batteries for up to 4 days operations in the dark.
- Fiber uplink to main building.
- Wifi backup Uplink.
- the 3 Ham antennas in the picture are used for emergencies at crazy distances in case of all down in a 150-1000miles radius ( 1k miles is very very low bandwidth ofc ).

Next:
- DYI isolation in the work
- Moar shelves inside and probably power box overhaul.
- Testing/testing/testing.
- Migrating some services there ?

it should be fun to self host stuff :)

Being public and transparent:

I do host https://fediverse.blog but this belongs to the Plume project and db/media and domain will be given to them the moment they decide so ( I will ofc help them transfer everything so that the transition is smooth when they want it ). I pledged that to Baptiste, Plume author, and now it's also public.

I will be funding and hosting it in the meantime ( which can last as long as they decide and I am able to continue ), to help and contribute to a sane fediverse.

https://plume.mastodon.host will also stay under the m.h usual service terms :)

Plume needs a logo !!

Contest details at https://fediverse.blog/~/PlumeDevelopment@baptiste.gelez.xyz/plume-needs-a-logo/

If any graphic designer would be kind enough to bless them with greatness, I'll personally contribute to the reward :)

@dansup I did not forget you, Pixelfed will also appear on m.h :) Just need time to setup my workbooks for it now that there's federation !

@tagomago I updated the instance to beta7 as it fix a few of those. Thanks for the report !

I say this I say nothing:
https://philsturgeon.uk/2016/11/16/tips-on-sidekiq-queues/

....

@galaxis @kaniini let me demistify that. Mastodon.host sees around 51% of the federation according to @federationbot . Indexing the DB took north of 6hours. Now it is done real-time with a trigger, and that trigger takes less than 10ms to execute ( I do not log lower than that ). The average size of the tsvector index is around 100B and the average time for a tsquery here is oscillating between 10 and 20ms... not that expensive it seems... Oh and the patch is less than 10lines...

@kaniini @segfault @claire it takes just more space in the DB and requires an index to be created to each record... After that it is not that expensive... We have a limited FTS here and the patch is ridiculously small ( the initial indexing of the DB though took forever ).

Regarding the whole 'oh no bad terrible' args, let's say that the implementation here is on purpose limited, and in the open, contrary to the crawling bots indexing your every toot for which nobody seems to care...