What's the coil voltage on your relay? Also is this a raw relay or one on a PCB with a diode, etc?
It sounds like your relay wiring might be a little messed up. Assuming you don't have the auto return model, according to documentation on the US Solid site:
How to wire this valve?
In direct current (DC) situations, the red wire is connected to the positive terminal, and the blue wire is connected to the negative terminal. The valve opens when the yellow wire is simultaneously connected to the positive terminal with the red wire, and the valve closes when the yellow wire is disconnected and the red wire is connected to the positive terminal alone. This means that the red and blue wires are always connected to the positive and negative poles, respectively, and the valve is controlled by parallel or disconnection of the third yellow wire with the red wire.
So for that you want Red to the Positive on your 12 volt PSU, blue to the ground, and then the yellow on the NC or NO connection on the relay, with the common on the relay tied to +12VDC.
Check out Node-Red if you want an easy way to program on the PI and interact with the GPIO.