Skip to content

Instantly share code, notes, and snippets.

View mayhem's full-sized avatar
💭
Hell bent on total world domination!

Robert Kaye mayhem

💭
Hell bent on total world domination!
169 followers · 7 following
View GitHub Profile
@mayhem
mayhem / gist:862ce3631e44d4414d770b2629e15bf8
Created July 25, 2020 22:35
WITH RECURSIVE area_descendants AS (
SELECT entity0 AS parent, entity1 AS descendant, 1 AS depth
FROM l_area_area laa
JOIN link ON laa.link = link.id
WHERE link.link_type = 356
AND entity1 IN (13703, 81)
UNION
SELECT entity0 AS parent, descendant, (depth + 1) AS depth
FROM l_area_area laa
JOIN link ON laa.link = link.id
@mayhem
mayhem / gist:3a6fc996fa5756944dceff13e5ae1da5
Created July 25, 2020 14:14
musicbrainz_db=# SELECT ac.id AS artist_credit_id,
musicbrainz_db-# ar.name AS area_name,
musicbrainz_db-# code AS area_code,
musicbrainz_db-# array_agg(a.gid) AS artist_credit_mbids
musicbrainz_db-# FROM artist_credit ac
musicbrainz_db-# JOIN artist_credit_name acn
musicbrainz_db-# ON ac.id = acn.artist_credit
musicbrainz_db-# JOIN artist a
musicbrainz_db-# ON acn.artist = a.id
musicbrainz_db-# JOIN area ar
@mayhem
mayhem / gist:d52e7a1699712ef3d908163293049e83
Created July 24, 2020 19:07
[2020-07-24 18:54:11,421] INFO in request_consumer: Received a request!
[2020-07-24 18:54:12,387] INFO in candidate_sets: Fetching listens to get top artists...
[2020-07-24 18:54:12,397] INFO in candidate_sets: Fetching top artists...
[2020-07-24 18:54:12,438] INFO in candidate_sets: Preparing top artists candidate set...
[2020-07-24 18:54:12,464] INFO in candidate_sets: Fetching similar artists...
[2020-07-24 18:54:12,544] INFO in candidate_sets: Preparing similar artists candidate set...
[2020-07-24 18:54:12,573] INFO in candidate_sets: Saving candidate sets...
[2020-07-24 18:54:37,736] INFO in candidate_sets: Done!
[2020-07-24 19:04:10,156] INFO in candidate_sets: Saving HTML...
20/07/24 19:05:57 ERROR TaskSchedulerImpl: Lost executor 1 on 10.0.1.212: Remote RPC client disassociated. Likely due to containers exceeding thresholds, or network issues. Check driver logs for WARN messages.
@mayhem
mayhem / gist:da5c5c6011a0124a713978b75b577172
Created July 24, 2020 15:34
<!DOCTYPE html>
<html>
<head>
<title>OpenPost Redirector</title>
</head>
<body onLoad="javascript: document.getElementById('postform').submit();">
<form method="post" name="postform" id="postform" action="https://listenbrainz.org/player">
<textarea name='listens' id='listens' form='postform' style='display: none;'>[
{
@mayhem
mayhem / gist:85126481ed629f62bc227b0adf93bd69
Created July 23, 2020 21:40
<!DOCTYPE html>
<html>
<head>
<title>OpenPost Redirector</title>
</head>
<body onLoad="javascript: document.getElementById('postform').submit();">
<form method="post" name="postform" id="postform" action="https://listenbrainz.org/player">
<textarea name='listens' id='listens' form='postform' style='display: none;'>[
{
@mayhem
mayhem / gist:58eab38f4fa957fffa5aa6bc36396e40
Last active July 23, 2020 21:37
<!DOCTYPE html>
<html>
<head>
<title>OpenPost Redirector</title>
</head>
<body onLoad="javascript: document.getElementById('postform').submit();">
<form method="post" name="postform" id="postform" action="https://listenbrainz.org/player">
<textarea name='listens' id='listens' form='postform' style='display: none;'>[
{
@mayhem
mayhem / gist:ba976ab3a3a5992580ad737b2d6e7d1a
Created July 23, 2020 19:49
{
"payload": {
"count": 3,
"last_updated": 1595499525,
"type": "top_artist",
"mbids": [
"00440193-f84c-4e3d-b23c-a96d21c050e6",
"0222ff68-4590-49b7-b063-c625e0f735ed",
"03037817-867c-445d-8fbf-56e754b4a537"
],
@mayhem
mayhem / gist:740c4b06e063b3913562cb9537fa80a0
Created July 22, 2020 17:21
robert@trille:~$ ./rabbitmqadmin --username ruaok --password ruaok -P 65414 -V /listenbrainz delete queue name=incoming_ts_migration
queue deleted
robert@trille:~$ ./rabbitmqadmin --username ruaok --password ruaok -P 65414 -V /listenbrainz list queues
+--------------------+----------+
| name | messages |
+--------------------+----------+
| beta_bigquery_jobs | 4 |
| beta_follow_list | 0 |
| beta_incoming | 0 |
| beta_playing_now | 0 |
@mayhem
mayhem / gist:c4c1b628dcdc62e52359f5ec0ef8c9bb
Created July 17, 2020 08:00
Traceback (most recent call last):
File "manage.py", line 225, in <module>
cli()
File "/usr/local/lib/python3.7/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
@mayhem
mayhem / gist:b891d084dd3913836e00a3990278e0bc
Created July 16, 2020 16:00
[2020-07-16 16:00:40,728] CRITICAL in utils: Error while connecting to RabbitMQ
Traceback (most recent call last):
File "/rec/listenbrainz_spark/utils.py", line 92, in init_rabbitmq
return pika.BlockingConnection(connection_parameters)
File "/usr/local/lib/python3.6/site-packages/pika/adapters/blocking_connection.py", line 377, in __init__
self._process_io_for_connection_setup()
File "/usr/local/lib/python3.6/site-packages/pika/adapters/blocking_connection.py", line 417, in _process_io_for_connection_setup
self._open_error_result.is_ready)
File "/usr/local/lib/python3.6/site-packages/pika/adapters/blocking_connection.py", line 469, in _flush_output
raise maybe_exception