[3/13] Bluestone: FAILED ((sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DiskFullError'>: could not resize shared memory segment "/PostgreSQL.294207508" to 4194304 bytes: No space left on device
[SQL:
SELECT
initcap(lower(trim(va.attribute_value))) AS label,
COUNT(DISTINCT p.id) AS count
FROM variant_attributes va
JOIN product_variants pv ON pv.id = va.variant_id
JOIN product p ON p.id = pv.product_id
WHERE p.brand_id = $1
AND lower(va.attribute_name) IN ('metal_colour', 'metal_color', 'colour', 'color')
AND va.attribute_value IS NOT NULL
AND trim(va.attribute_value) <> ''
GROUP BY initcap(lower(trim(va.attribute_value)))
ORDER BY count DESC, label ASC
]
[parameters: (UUID('049cf13e-94b4-40c7-a06c-2fc27d33e63f'),)]
(Background on this error at: https://sqlalche.me/e/20/dbapi))10 views