mrnelgin

Untitled

May 3rd, 2021
65
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Quite a few failures
  2.  
  3. musicbrainz@wibble:/restore/musicbrainz/musicbrainz-docker$ date && sudo docker-compose exec mq rabbitmqadmin -u sir -p sir -V /search-index-rebuilder list queues
  4. Mon 03 May 2021 05:56:44 PM CDT
  5. +---------------+----------+
  6. | name | messages |
  7. +---------------+----------+
  8. | search.delete | 139 |
  9. | search.failed | 304 | <-----
  10. | search.index | 12537 |
  11. | search.retry | 0 |
  12. +---------------+----------+
  13.  
  14. Then my log has a ton of these. Anything I can do to tweak/fix it? Should I open a ticket because I've mentioned this in channel a couple of times.
  15. musicbrainz@wibble:/restore/musicbrainz/musicbrainz-docker$ sudo docker-compose logs --tail 20 --timestamps indexer Attaching to musicbrainz-docker_indexer_1
  16. indexer_1 | 2021-05-03T21:43:56.576948347Z 2021-05-03 21:43:56,576: Successfully processed 2 messages
  17. indexer_1 | 2021-05-03T21:44:39.017199032Z 2021-05-03 21:44:39,016: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  18. indexer_1 | 2021-05-03T21:51:07.291250444Z 2021-05-03 21:51:07,290: Successfully processed 2 messages
  19. indexer_1 | 2021-05-03T21:51:36.151927193Z 2021-05-03 21:51:36,151: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  20. indexer_1 | 2021-05-03T21:58:24.164983584Z 2021-05-03 21:58:24,164: Successfully processed 2 messages
  21. indexer_1 | 2021-05-03T21:59:13.747666801Z 2021-05-03 21:59:13,747: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  22. indexer_1 | 2021-05-03T22:05:49.439808264Z 2021-05-03 22:05:49,439: Successfully processed 2 messages
  23. indexer_1 | 2021-05-03T22:06:17.055217078Z 2021-05-03 22:06:17,054: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  24. indexer_1 | 2021-05-03T22:12:57.436672741Z 2021-05-03 22:12:57,436: Successfully processed 2 messages
  25. indexer_1 | 2021-05-03T22:13:42.173474156Z 2021-05-03 22:13:42,173: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  26. indexer_1 | 2021-05-03T22:20:11.039072912Z 2021-05-03 22:20:11,038: Successfully processed 2 messages
  27. indexer_1 | 2021-05-03T22:20:34.702178477Z 2021-05-03 22:20:34,701: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  28. indexer_1 | 2021-05-03T22:27:09.612699264Z 2021-05-03 22:27:09,612: Successfully processed 2 messages
  29. indexer_1 | 2021-05-03T22:27:54.878535166Z 2021-05-03 22:27:54,878: Index limit exceeded. Entity: recording, Total Rows: 5100749, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  30. indexer_1 | 2021-05-03T22:34:23.434561295Z 2021-05-03 22:34:23,434: Successfully processed 2 messages
  31. indexer_1 | 2021-05-03T22:34:56.955954262Z 2021-05-03 22:34:56,955: Index limit exceeded. Entity: recording, Total Rows: 5100771, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  32. indexer_1 | 2021-05-03T22:41:32.928671935Z 2021-05-03 22:41:32,928: Successfully processed 2 messages
  33. indexer_1 | 2021-05-03T22:42:19.145307007Z 2021-05-03 22:42:19,145: Index limit exceeded. Entity: recording, Total Rows: 5100771, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  34. indexer_1 | 2021-05-03T22:48:47.834122571Z 2021-05-03 22:48:47,833: Successfully processed 2 messages
  35. indexer_1 | 2021-05-03T22:49:18.166532606Z 2021-05-03 22:49:18,166: Index limit exceeded. Entity: recording, Total Rows: 5100771, Extra Data: {'path': 'tracks.medium.release.artist_credit', 'table_name': u'artist_credit', 'select_query': 'SELECT recording_1.id AS recording_1_id \nFROM musicbrainz.recording AS recording_1 JOIN musicbrainz.track AS track_1 ON recording_1.id = track_1.recording JOIN musicbrainz.medium AS medium_1 ON medium_1.id = track_1.medium JOIN musicbrainz.release AS release_1 ON release_1.id = medium_1.release JOIN musicbrainz.artist_credit ON musicbrainz.artist_credit.id = release_1.artist_credit \nWHERE musicbrainz.artist_credit.id = :id_1'}
  36. musicbrainz@wibble:/restore/musicbrainz/musicbrainz-docker$ date && sudo docker-compose exec mq rabbitmqadmin -u sir -p sir -V /search-index-rebuilder list queues
  37.  
  38.  
RAW Paste Data