This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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;'>[ | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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;'>[ | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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;'>[ | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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" | |
], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
param@lemmy:~/listenbrainz-server/listenbrainz_spark$ pwd | |
/home/param/listenbrainz-server/listenbrainz_spark | |
param@lemmy:~/listenbrainz-server/listenbrainz_spark$ ls -la | |
total 96 | |
drwxrwxr-x 10 param param 4096 Jul 15 18:12 . | |
drwxrwxr-x 12 param param 4096 Jul 14 16:55 .. | |
-rw-rw-r-- 1 param param 1398 Jul 14 16:55 config.py.sample | |
-rw-rw-r-- 1 param param 29 Mar 28 11:09 constants.py | |
-rw-rw-r-- 1 param param 3674 Jul 15 18:12 exceptions.py | |
drwxrwxr-x 3 param param 4096 Jul 15 18:12 ftp |