MYSQL ERROR: Can't create/write to file '/tmp/#sql-temptable-d8b-1e970d-d548.MAI' (Errcode: 30 "Read-only file system")

Query: SELECT *, COUNT(*) AS count, SUM(cart_qty) AS qty FROM ms_cart WHERE cart_photo_prod>'0' AND cart_session='1811815915720250419102927' AND cart_client='' AND cart_photo_prod_connect!='0' AND cart_order='0' GROUP BY cart_photo_prod_connect, cart_dis_on