Number of archive rows with blank ar_sha1 on each wiki
ActivePublic
Actions

Authored by Catrope on Jun 11 2019, 10:23 PM.

Tags

None

Referenced Files

	F29467654: raw.txt
	Jun 11 2019, 10:23 PM

Subscribers

None

	arcwiki: 1
	arwiki: 1
	azwiki: 3
	bgwiki: 5
	cawiki: 1
	commonswiki: 282
	cswiki: 1
	dawiki: 2
	dewiki: 2718
	dewikiversity: 1
	dewikivoyage: 39105
	enwiki: 1684
	enwikibooks: 2
	enwikiquote: 2
	eswiki: 276
	eswiktionary: 64
	etwiki: 1
	fawiki: 1
	fiwiki: 1
	frwiki: 488
	frwikisource: 2
	hrwiki: 1
	huwiki: 14
	idwiki: 3
	itwiki: 262
	itwikivoyage: 45940
	jawiki: 51
	kowiki: 3
	kvwiki: 1
	metawiki: 3
	nlwiki: 8
	nlwiktionary: 605
	nowiki: 6
	oswiki: 1
	plwiki: 192
	ptwiki: 4
	ruwiki: 23
	ruwiktionary: 1
	slwiki: 4
	sourceswiki: 1
	srwiki: 4
	svwiki: 168
	tawiki: 1
	testwiki: 11
	trwiki: 1
	ukwiki: 1
	zhwiki: 18

Event Timeline

Catrope created this paste.Jun 11 2019, 10:23 PM

On stat1006:

(for wiki in $(cat ~/all.dblist); do echo -n "$wiki: "; echo "select count(*) from archive where ar_sha1='';" | analytics-mysql $wiki -N; done) | tee ~/empty-sha1
cat ~/empty-sha1 | grep -v ': 0'

Catrope mentioned this in T219816: Fatal IncompleteRevisionException when restoring an article (undelete page).Jun 11 2019, 11:32 PM

Number of archive rows with blank ar_sha1 on each wikiActivePublicActions

Event Timeline

Number of archive rows with blank ar_sha1 on each wiki
ActivePublic
Actions