Petronald Green ronaldgrn

Rancher v2.1.8 single install embedded etcd maintenance

This is not official documentation, have/make backups, use at your own risk.

v2.1.8 only (for 2.2.x, see https://gist.github.com/superseb/f223b15949c031983da2cb850f56a897)

When etcd db size exceeds quota, it will raise an alarm and throw the error mvcc: database space exceeded.

Rancher container is running

Switching between AHCI and RAID on the Dell XPS 15 (9560)

This guide likely applies to other models and, potentially, even laptops from other OEMs that have NVME drives. However, I've only tested this on my Dell XPS 15 (9560) with the OEM Windows installation from the Signature Edition model.

Switching from RAID to AHCI

Switching from RAID to AHCI is significantly simpler than switching from AHCI to RAID. All that's needed is a successful boot to Safe Mode.

To set the default boot mode to Safe Mode, use msconfig.exe or open an admin cmd/PowerShell window and run:

Fields	null=True	blank=True
CharField, TextField, SlugField, EmailField, CommaSeparatedIntegerField	DON'T Django's convention is to store empty values as the empty string, and to always retrieve NULL or empty values as the empty string for consistency.	OK Do this if you want the corresponding form widget to accept empty values. If you set this, empty values get stored as empty strings in the database.
BooleanField	DON'T Use NullBooleanField instead.	DON'T
IntegerField, FloatField, DecimalField	OK If you wabt to be able to set the value to NULL in the database	OK if you want the corresponding form widget to accept empty values. if so out will also want to set null=True
DateTimeField, DateField, TimeField	OK if you want to be able to set the value to NULL in the database.	OK If you want the corresponding form widget to accept empty values, or if you are using auto now or auto now add. If so, you will al

	import logging

	from django.contrib.gis.db.backends.postgis.base import \
	DatabaseWrapper as PostgisDBWrapper
	from django.db import ProgrammingError

	from .schema import TimescaleSchemaEditor

	logger = logging.getLogger(__name__)

	// Add / Update a key-value pair in the URL query parameters
	function updateUrlParameter(uri, key, value) {
	// remove the hash part before operating on the uri
	var i = uri.indexOf('#');
	var hash = i === -1 ? '' : uri.substr(i);
	uri = i === -1 ? uri : uri.substr(0, i);

	var re = new RegExp("([?&])" + key + "=.*?(&\|$)", "i");
	var separator = uri.indexOf('?') !== -1 ? "&" : "?";
	if (uri.match(re)) {