If one had to depart and unable to bring the respective guns with you, it was not an uncommon practice to blow up, disable, or discard the weapon so it cant be used by the enemy, and/or immediately back against you. Many accounts of gun tubes being dumped in rivers, old wells, or detached from its carriage and buried if no other options were immediately at hand... and you had the time to do so...
When leaving Petersburg a number of Confederate guns were dumped in the Appomattox River... one was located and retrieved back in the 1960's by a couple locals swimming in the river one summer day... They also found three others nearby... The one they retrieved was quickly confiscated by the Govt. a few days later... they didn't tell about the others.... and they still remain in the river....
Some of the Confederates stationed on the Howlett Line just North of Petersburg, ditched their gun tubes in a nearby water well... never yet recovered to my knowledge...
I know of at least one gun tube discovered in the Chickahominy Swamp just east of Richmond... the location being so remote and very difficult to reach.... it also still remains there...
I personally found a 10in mortar tube in the James River around Richmond.... its still there too... no means to recover...
Ft.Branch in NC tossed several in the river both large siege guns and field pieces still attached to their carriages... A few tried to recover them for their own profit but NC stopped that... and they later recovered the others found in the river too... all on display at a small museum there at the site now....
Appomattox Campaign.... various accounts of CS artillery units burying their detached gun tubes, when the artilleryman were consolidated into Infantry battalions... and/or lost ability or horses to carry them any further... Federal accounts of discovering and retrieving at least a couple of them... No one knows how many may have been buried or if there are others still out there to be discovered....
Spiking was a quick method if you didn't have time to do anything else... it was also considered a temporary measure... It typically would prevent the enemy from immediately turning the guns on you till you could get away or recover it.... most experienced gunners could un-spike a gun tube rather quickly... Another method that took a little longer to fix was to fill the gun tube with shot or shells interlaced with mud... a couple shells secured with small wooden wedges rammed in... so the gun couldn't be emptied by inverting the gun tube or fished out with the worm as easy...