Skip to content
Snippets Groups Projects
  1. Mar 28, 2023
  2. Mar 21, 2023
  3. Mar 13, 2023
  4. Feb 21, 2023
  5. Feb 17, 2023
  6. Feb 16, 2023
  7. Feb 13, 2023
  8. Feb 02, 2023
  9. Jan 06, 2023
  10. Dec 19, 2022
  11. Dec 07, 2022
    • vlorentz's avatar
      Remove tool ids from Kafka messages · e8549400
      vlorentz authored
      1. they are internal to the DB so they do not belong in Kafka
      2. on unrelated errors, they cause swh.journal to crash because it does
         not know how to handle integers in the output of unique_key()
      v2.9.2
      e8549400
  12. Nov 30, 2022
  13. Nov 29, 2022
  14. Nov 28, 2022
    • vlorentz's avatar
    • vlorentz's avatar
      storage: Insert from temporary tables in consistent order · f7833b7e
      vlorentz authored
      This avoids having a transaction inserting row A then B, while another
      inserts row B then A; which (probably) leads to deadlocks like this:
      
      ```
      DeadlockDetected: deadlock detected
      DETAIL:  Process 1842336 waits for ShareLock on transaction 1051957280; blocked by process 64261.
      Process 64261 waits for ShareLock on transaction 1051957281; blocked by process 1842336.
      HINT:  See server log for query details.
      CONTEXT:  while inserting index tuple (1972253,5) in relation "origin_extrinsic_metadata"
      SQL statement "insert into origin_extrinsic_metadata (id, metadata, indexer_configuration_id, from_remd_id, metadata_tsvector, mappings)
      ```
      
      https://sentry.softwareheritage.org/share/issue/52b06caae89f4235a758887fd6817656/
      
      This was already mitigating by sorting before inserting in temporary
      tables, then expecting postgresql to read from temporary tables in the
      same order rows where inserted. This is often true, but not guaranteed.
      
      No test for this, because I do not see a way to replicate this more than
      existing deadlock tests do.
      f7833b7e
  15. Nov 21, 2022
  16. Nov 03, 2022
  17. Nov 02, 2022
  18. Oct 26, 2022
  19. Oct 25, 2022
  20. Oct 24, 2022
  21. Oct 18, 2022
  22. Oct 07, 2022
  23. Sep 28, 2022
  24. Sep 27, 2022
  25. Sep 12, 2022
  26. Sep 08, 2022
Loading