(An Untitled Masterwork)
ActivePublic
Actions

Authored by Bawolff on Sep 30 2015, 12:32 AM.

Tags

None

Referenced Files

	F2645471:
	Sep 30 2015, 12:32 AM

Subscribers

None

	T114099

	MariaDB [commonswiki_p]> select substr( log_timestamp, 1, 8 ), log_action, log_user_text, count(*) from logging_logindex where log_type = 'gwtoolset' and log_timestamp > '20150900000000' group by substr( log_timestamp, 1, 8 ), log_action, log_user_text order by 2, 1;
	+-------------------------------+-------------------------+--------------------------+----------+
	\| substr( log_timestamp, 1, 8 ) \| log_action \| log_user_text \| count(*) \|
	+-------------------------------+-------------------------+--------------------------+----------+
	\| 20150901 \| mediafile-job-failed \| DimitraCharalampidou \| 17 \|
	\| 20150902 \| mediafile-job-failed \| Jason.nlw \| 393 \|
	\| 20150902 \| mediafile-job-failed \| DimitraCharalampidou \| 22 \|
	\| 20150910 \| mediafile-job-failed \| Hansmuller \| 7676 \|
	\| 20150910 \| mediafile-job-failed \| DimitraCharalampidou \| 899 \|
	\| 20150911 \| mediafile-job-failed \| DimitraCharalampidou \| 1268 \|
	\| 20150911 \| mediafile-job-failed \| Hansmuller \| 4072 \|
	\| 20150912 \| mediafile-job-failed \| Hansmuller \| 5 \|
	\| 20150913 \| mediafile-job-failed \| Hansmuller \| 1273 \|
	\| 20150914 \| mediafile-job-failed \| DimitraCharalampidou \| 56 \|
	\| 20150914 \| mediafile-job-failed \| Hansmuller \| 868 \|
	\| 20150915 \| mediafile-job-failed \| Hansmuller \| 10 \|
	\| 20150916 \| mediafile-job-failed \| Hansmuller \| 2883 \|
	\| 20150917 \| mediafile-job-failed \| Hansmuller \| 4110 \|
	\| 20150917 \| mediafile-job-failed \| LizzyJongma \| 272 \|
	\| 20150922 \| mediafile-job-failed \| LizzyJongma \| 200 \|
	\| 20150923 \| mediafile-job-failed \| LizzyJongma \| 1528 \|
	\| 20150924 \| mediafile-job-failed \| Hansmuller \| 21 \|
	\| 20150924 \| mediafile-job-failed \| LizzyJongma \| 1142 \|
	\| 20150925 \| mediafile-job-failed \| LizzyJongma \| 1452 \|
	\| 20150925 \| mediafile-job-failed \| Hansmuller \| 12 \|
	\| 20150926 \| mediafile-job-failed \| LizzyJongma \| 13 \|
	\| 20150928 \| mediafile-job-failed \| Hansmuller \| 5 \|
	\| 20150901 \| mediafile-job-succeeded \| DimitraCharalampidou \| 15 \|
	\| 20150902 \| mediafile-job-succeeded \| DimitraCharalampidou \| 5 \|
	\| 20150902 \| mediafile-job-succeeded \| Pdproject \| 15 \|
	\| 20150902 \| mediafile-job-succeeded \| Jason.nlw \| 1 \|
	\| 20150903 \| mediafile-job-succeeded \| DimitraCharalampidou \| 4 \|
	\| 20150903 \| mediafile-job-succeeded \| Pdproject \| 8 \|
	\| 20150907 \| mediafile-job-succeeded \| Hansmuller \| 1325 \|
	\| 20150908 \| mediafile-job-succeeded \| Hansmuller \| 2923 \|
	\| 20150909 \| mediafile-job-succeeded \| Hansmuller \| 3419 \|
	\| 20150910 \| mediafile-job-succeeded \| Basel University Library \| 1 \|
	\| 20150910 \| mediafile-job-succeeded \| DimitraCharalampidou \| 5050 \|
	\| 20150910 \| mediafile-job-succeeded \| Hansmuller \| 2675 \|
	\| 20150911 \| mediafile-job-succeeded \| DimitraCharalampidou \| 1070 \|
	\| 20150911 \| mediafile-job-succeeded \| Hansmuller \| 2536 \|
	\| 20150912 \| mediafile-job-succeeded \| Hansmuller \| 386 \|
	\| 20150913 \| mediafile-job-succeeded \| Hansmuller \| 5951 \|
	\| 20150914 \| mediafile-job-succeeded \| Hansmuller \| 3961 \|
	\| 20150914 \| mediafile-job-succeeded \| DimitraCharalampidou \| 1693 \|
	\| 20150915 \| mediafile-job-succeeded \| Hansmuller \| 6070 \|
	\| 20150916 \| mediafile-job-succeeded \| Hansmuller \| 1860 \|
	\| 20150917 \| mediafile-job-succeeded \| LizzyJongma \| 350 \|
	\| 20150917 \| mediafile-job-succeeded \| Hansmuller \| 55 \|
	\| 20150918 \| mediafile-job-succeeded \| Hansmuller \| 57 \|
	\| 20150923 \| mediafile-job-succeeded \| Hansmuller \| 262 \|
	\| 20150923 \| mediafile-job-succeeded \| LizzyJongma \| 297 \|
	\| 20150924 \| mediafile-job-succeeded \| LizzyJongma \| 598 \|
	\| 20150924 \| mediafile-job-succeeded \| Hansmuller \| 463 \|
	\| 20150925 \| mediafile-job-succeeded \| Hansmuller \| 546 \|
	\| 20150925 \| mediafile-job-succeeded \| LizzyJongma \| 490 \|
	\| 20150926 \| mediafile-job-succeeded \| Hansmuller \| 380 \|
	\| 20150927 \| mediafile-job-succeeded \| Hansmuller \| 316 \|
	\| 20150928 \| mediafile-job-succeeded \| Hansmuller \| 397 \|
	\| 20150929 \| mediafile-job-succeeded \| Hansmuller \| 230 \|
	\| 20150901 \| metadata-job \| DimitraCharalampidou \| 4 \|
	\| 20150902 \| metadata-job \| Pdproject \| 15 \|
	\| 20150902 \| metadata-job \| Jason.nlw \| 14 \|
	\| 20150902 \| metadata-job \| DimitraCharalampidou \| 3 \|
	\| 20150903 \| metadata-job \| Pdproject \| 8 \|
	\| 20150903 \| metadata-job \| DimitraCharalampidou \| 1 \|
	\| 20150907 \| metadata-job \| Hansmuller \| 265 \|
	\| 20150908 \| metadata-job \| Hansmuller \| 585 \|
	\| 20150909 \| metadata-job \| Hansmuller \| 545 \|
	\| 20150910 \| metadata-job \| Basel University Library \| 1 \|
	\| 20150910 \| metadata-job \| DimitraCharalampidou \| 1098 \|
	\| 20150910 \| metadata-job \| Hansmuller \| 651 \|
	\| 20150911 \| metadata-job \| Hansmuller \| 486 \|
	\| 20150911 \| metadata-job \| DimitraCharalampidou \| 277 \|
	\| 20150912 \| metadata-job \| Hansmuller \| 39 \|
	\| 20150913 \| metadata-job \| Hansmuller \| 626 \|
	\| 20150914 \| metadata-job \| Hansmuller \| 429 \|
	\| 20150914 \| metadata-job \| DimitraCharalampidou \| 343 \|
	\| 20150915 \| metadata-job \| Hansmuller \| 607 \|
	\| 20150916 \| metadata-job \| Hansmuller \| 433 \|
	\| 20150917 \| metadata-job \| LizzyJongma \| 22 \|
	\| 20150917 \| metadata-job \| Hansmuller \| 258 \|
	\| 20150918 \| metadata-job \| Hansmuller \| 7 \|
	\| 20150922 \| metadata-job \| LizzyJongma \| 6 \|
	\| 20150923 \| metadata-job \| LizzyJongma \| 38 \|
	\| 20150923 \| metadata-job \| Hansmuller \| 27 \|
	\| 20150924 \| metadata-job \| Hansmuller \| 47 \|
	\| 20150924 \| metadata-job \| LizzyJongma \| 49 \|
	\| 20150925 \| metadata-job \| Hansmuller \| 55 \|
	\| 20150925 \| metadata-job \| LizzyJongma \| 49 \|
	\| 20150926 \| metadata-job \| Hansmuller \| 38 \|
	\| 20150927 \| metadata-job \| Hansmuller \| 32 \|
	\| 20150928 \| metadata-job \| Hansmuller \| 42 \|
	\| 20150929 \| metadata-job \| Hansmuller \| 23 \|
	+-------------------------------+-------------------------+--------------------------+----------+
	90 rows in set (0.58 sec)

Event Timeline

Bawolff edited the content of this paste. (Show Details)Sep 30 2015, 12:32 AM

Bawolff updated the paste's language from autodetect to autodetect.

Bawolff mentioned this in T114099: Could GWToolset upload faster please?.

	T114099

	MariaDB [commonswiki_p]> select substr( log_timestamp, 1, 8 ), log_action, log_user_text, count(*) from logging_logindex where log_type = 'gwtoolset' and log_timestamp > '20150900000000' group by substr( log_timestamp, 1, 8 ), log_action, log_user_text order by 2, 1;
	+-------------------------------+-------------------------+--------------------------+----------+
	\| substr( log_timestamp, 1, 8 ) \| log_action \| log_user_text \| count(*) \|
	+-------------------------------+-------------------------+--------------------------+----------+
	\| 20150901 \| mediafile-job-failed \| DimitraCharalampidou \| 17 \|
	\| 20150902 \| mediafile-job-failed \| Jason.nlw \| 393 \|
	\| 20150902 \| mediafile-job-failed \| DimitraCharalampidou \| 22 \|
	\| 20150910 \| mediafile-job-failed \| Hansmuller \| 7676 \|
	\| 20150910 \| mediafile-job-failed \| DimitraCharalampidou \| 899 \|
	\| 20150911 \| mediafile-job-failed \| DimitraCharalampidou \| 1268 \|
	\| 20150911 \| mediafile-job-failed \| Hansmuller \| 4072 \|
	\| 20150912 \| mediafile-job-failed \| Hansmuller \| 5 \|
	\| 20150913 \| mediafile-job-failed \| Hansmuller \| 1273 \|
	\| 20150914 \| mediafile-job-failed \| DimitraCharalampidou \| 56 \|
	\| 20150914 \| mediafile-job-failed \| Hansmuller \| 868 \|
	\| 20150915 \| mediafile-job-failed \| Hansmuller \| 10 \|
	\| 20150916 \| mediafile-job-failed \| Hansmuller \| 2883 \|
	\| 20150917 \| mediafile-job-failed \| Hansmuller \| 4110 \|
	\| 20150917 \| mediafile-job-failed \| LizzyJongma \| 272 \|
	\| 20150922 \| mediafile-job-failed \| LizzyJongma \| 200 \|
	\| 20150923 \| mediafile-job-failed \| LizzyJongma \| 1528 \|
	\| 20150924 \| mediafile-job-failed \| Hansmuller \| 21 \|
	\| 20150924 \| mediafile-job-failed \| LizzyJongma \| 1142 \|
	\| 20150925 \| mediafile-job-failed \| LizzyJongma \| 1452 \|
	\| 20150925 \| mediafile-job-failed \| Hansmuller \| 12 \|
	\| 20150926 \| mediafile-job-failed \| LizzyJongma \| 13 \|
	\| 20150928 \| mediafile-job-failed \| Hansmuller \| 5 \|
	\| 20150901 \| mediafile-job-succeeded \| DimitraCharalampidou \| 15 \|
	\| 20150902 \| mediafile-job-succeeded \| DimitraCharalampidou \| 5 \|
	\| 20150902 \| mediafile-job-succeeded \| Pdproject \| 15 \|
	\| 20150902 \| mediafile-job-succeeded \| Jason.nlw \| 1 \|
	\| 20150903 \| mediafile-job-succeeded \| DimitraCharalampidou \| 4 \|
	\| 20150903 \| mediafile-job-succeeded \| Pdproject \| 8 \|
	\| 20150907 \| mediafile-job-succeeded \| Hansmuller \| 1325 \|
	\| 20150908 \| mediafile-job-succeeded \| Hansmuller \| 2923 \|
	\| 20150909 \| mediafile-job-succeeded \| Hansmuller \| 3419 \|
	\| 20150910 \| mediafile-job-succeeded \| Basel University Library \| 1 \|
	\| 20150910 \| mediafile-job-succeeded \| DimitraCharalampidou \| 5050 \|
	\| 20150910 \| mediafile-job-succeeded \| Hansmuller \| 2675 \|
	\| 20150911 \| mediafile-job-succeeded \| DimitraCharalampidou \| 1070 \|
	\| 20150911 \| mediafile-job-succeeded \| Hansmuller \| 2536 \|
	\| 20150912 \| mediafile-job-succeeded \| Hansmuller \| 386 \|
	\| 20150913 \| mediafile-job-succeeded \| Hansmuller \| 5951 \|
	\| 20150914 \| mediafile-job-succeeded \| Hansmuller \| 3961 \|
	\| 20150914 \| mediafile-job-succeeded \| DimitraCharalampidou \| 1693 \|
	\| 20150915 \| mediafile-job-succeeded \| Hansmuller \| 6070 \|
	\| 20150916 \| mediafile-job-succeeded \| Hansmuller \| 1860 \|
	\| 20150917 \| mediafile-job-succeeded \| LizzyJongma \| 350 \|
	\| 20150917 \| mediafile-job-succeeded \| Hansmuller \| 55 \|
	\| 20150918 \| mediafile-job-succeeded \| Hansmuller \| 57 \|
	\| 20150923 \| mediafile-job-succeeded \| Hansmuller \| 262 \|
	\| 20150923 \| mediafile-job-succeeded \| LizzyJongma \| 297 \|
	\| 20150924 \| mediafile-job-succeeded \| LizzyJongma \| 598 \|
	\| 20150924 \| mediafile-job-succeeded \| Hansmuller \| 463 \|
	\| 20150925 \| mediafile-job-succeeded \| Hansmuller \| 546 \|
	\| 20150925 \| mediafile-job-succeeded \| LizzyJongma \| 490 \|
	\| 20150926 \| mediafile-job-succeeded \| Hansmuller \| 380 \|
	\| 20150927 \| mediafile-job-succeeded \| Hansmuller \| 316 \|
	\| 20150928 \| mediafile-job-succeeded \| Hansmuller \| 397 \|
	\| 20150929 \| mediafile-job-succeeded \| Hansmuller \| 230 \|
	\| 20150901 \| metadata-job \| DimitraCharalampidou \| 4 \|
	\| 20150902 \| metadata-job \| Pdproject \| 15 \|
	\| 20150902 \| metadata-job \| Jason.nlw \| 14 \|
	\| 20150902 \| metadata-job \| DimitraCharalampidou \| 3 \|
	\| 20150903 \| metadata-job \| Pdproject \| 8 \|
	\| 20150903 \| metadata-job \| DimitraCharalampidou \| 1 \|
	\| 20150907 \| metadata-job \| Hansmuller \| 265 \|
	\| 20150908 \| metadata-job \| Hansmuller \| 585 \|
	\| 20150909 \| metadata-job \| Hansmuller \| 545 \|
	\| 20150910 \| metadata-job \| Basel University Library \| 1 \|
	\| 20150910 \| metadata-job \| DimitraCharalampidou \| 1098 \|
	\| 20150910 \| metadata-job \| Hansmuller \| 651 \|
	\| 20150911 \| metadata-job \| Hansmuller \| 486 \|
	\| 20150911 \| metadata-job \| DimitraCharalampidou \| 277 \|
	\| 20150912 \| metadata-job \| Hansmuller \| 39 \|
	\| 20150913 \| metadata-job \| Hansmuller \| 626 \|
	\| 20150914 \| metadata-job \| Hansmuller \| 429 \|
	\| 20150914 \| metadata-job \| DimitraCharalampidou \| 343 \|
	\| 20150915 \| metadata-job \| Hansmuller \| 607 \|
	\| 20150916 \| metadata-job \| Hansmuller \| 433 \|
	\| 20150917 \| metadata-job \| LizzyJongma \| 22 \|
	\| 20150917 \| metadata-job \| Hansmuller \| 258 \|
	\| 20150918 \| metadata-job \| Hansmuller \| 7 \|
	\| 20150922 \| metadata-job \| LizzyJongma \| 6 \|
	\| 20150923 \| metadata-job \| LizzyJongma \| 38 \|
	\| 20150923 \| metadata-job \| Hansmuller \| 27 \|
	\| 20150924 \| metadata-job \| Hansmuller \| 47 \|
	\| 20150924 \| metadata-job \| LizzyJongma \| 49 \|
	\| 20150925 \| metadata-job \| Hansmuller \| 55 \|
	\| 20150925 \| metadata-job \| LizzyJongma \| 49 \|
	\| 20150926 \| metadata-job \| Hansmuller \| 38 \|
	\| 20150927 \| metadata-job \| Hansmuller \| 32 \|
	\| 20150928 \| metadata-job \| Hansmuller \| 42 \|
	\| 20150929 \| metadata-job \| Hansmuller \| 23 \|
	+-------------------------------+-------------------------+--------------------------+----------+
	90 rows in set (0.58 sec)

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions