Sujay Pillai sujaypillai

2018 Update: Easiest option is Justin's repo and image

Just run this from your Mac terminal and it'll drop you in a container with full permissions on the Moby VM. This also works for Docker for Windows for getting in Moby Linux VM (doesn't work for Windows Containers).

docker run -it --rm --privileged --pid=host justincormack/nsenter1

more info: https://github.com/justincormack/nsenter1

	set autocommit=0;
	begin;

	-- get all active references to alf_prop_root
	create temporary table temp1 (id bigint(20), index (id));
	insert into temp1 select disabled_paths_id as id from alf_audit_app;
	insert into temp1 select audit_values_id as id from alf_audit_entry;
	insert into temp1 select prop1_id as id from alf_prop_unique_ctx;

	-- determine the obsolete entries from alf_prop_root

	select alf_content_url.content_url
	from alf_node
	left join alf_qname on alf_node.type_qname_id = alf_qname.id
	left join alf_node_properties on alf_node_properties.node_id = alf_node.id
	join alf_content_data on alf_content_data.id = alf_node_properties.long_value
	left join alf_content_url on alf_content_url.id = alf_content_data.content_url_id
	where
	alf_qname.local_name = 'dictionaryModel'
	and alf_content_url.content_url is not null

	delete from ACT_HI_TASKINST where not exists (select pd.ID_ from ACT_RE_PROCDEF pd where pd.ID_ = PROC_DEF_ID_);

	Failed to retrieve tasks assigned to authority {0} in state {1}.
	....
	Caused by: org.alfresco.service.cmr.workflow.WorkflowException: 04070413 Failed to retrieve tasks assigned to authority {0} in state {1}.
	....
	Caused by: org.activiti.engine.ActivitiException: no deployed process definition found with id 'RegConducereReg:1:14208'

	package main

	import (
	"golang.org/x/net/context"
	"github.com/docker/docker/api/types"
	"github.com/docker/docker/api/types/container"
	"github.com/docker/docker/api/types/network"
	"github.com/docker/docker/cli/command"
	"github.com/docker/docker/client"
	"fmt"

	BITS 32

	org 0x05000000
	db 0x7F, "ELF"
	dd 1
	dd 0
	dd $$
	dw 2
	dw 3
	dd 0x0500001B

	INSERT INTO ACT_HI_VARINST(
	ID_,
	PROC_INST_ID_,
	EXECUTION_ID_,
	TASK_ID_,
	NAME_,
	VAR_TYPE_,
	REV_,
	BYTEARRAY_ID_,
	DOUBLE_,

	SELECT relname AS "tablename", reltuples AS "rows", relpages * 8 / 1024 AS "MB" FROM pg_class
	WHERE relname like 'alf%'
	OR relname like 'act%'
	OR relname like 'avm%'
	OR relname like 'jbpm%'
	ORDER BY relpages DESC;

	#!/bin/bash

	if [ $# -lt 1 ]
	then
	cat << HELP

	dockertags -- list all tags for a Docker image on a remote registry.

	EXAMPLE:
	- list all tags for ubuntu: