best thing to do is unsolder the lamp base clean out old adheasive and try to find Glassbond lamp cement.
i think u cure it by heating the cap up.
Yes, i am aware of Glassbond Cement. The problem is that you cant really buy the stuff, the manufacturer seems to only sell it to bigger lamp manufacturers and from what i understand the shelf life of the unused cement powder is quite short. I have been looking at high temperature epoxy and silicone but these does a MAXIMUM of about 200 degrees celcius. This is waaaay too low for a 250W mercury bulb.
When it comes to a flourescent tube end cap i guess it would be no problem to use a high temperature epoxy. I know there are also some silicon adhesives around that can tolerate high temperatures.
https://www.biltema.se/bygg/kemikalier/silikon/silikon-hogtemperatur-2000017141This one from a Swedish retailer can stand up to 250 degrees celcius. No problem at all for most flourescent tubes as they dont really get that warm as long as they are fairly low wattage.