LED lights with a dim light in open circuit
WARNING - ELECTROCUTION HAZARD

READ MY ANSWER HERE.

The bulb that you are holding in the picture that you posted very possibly has live mains on it. If so, the photo subject is at grave risk of electrocution. 

Being in contact with a grounded or "somewhat grounded" object or surface at the same time could result in a possibly fatal electric shock.

______________________________

Lightly edited exerpt from my other answer (posted just now).

WARNING - ELECTROCUTION HAZARD

If reversing the polarity of the circuit or using the other "leg" fixes the problem then you probably have Phase / Live connected to the circuit at all times and it is improperly wired and a "death trap".

If only lighting equipment without grounded metal accessible to users is used then you may not have anyone killed.

But if you use equipment on the circuit where neutral and ground are connected (as happens even though it shouldn't) then such equipment will be "safe enough" on a properly connected circuit BUT lethally dangerous on this one.

Getting it fixed while everyone is still alive is liable to be "a good idea".