I will add a little here ....... I have had this problem for some time, or one similar to it.
I have two optical drives in this PC.
One is a DVD Multiplayer (/dev/sr0) while the other is a Superwritemaster burner (not 'seen')
Both are connected by IDE cable.
According to PCC Hardware
/dev/sr0 is using pata_amd module. This drive used to close immediately it was opened ...... some update seems to have corrected that carry on.
The second drive (burner) does not register at all apparently. (I have been using an USB connected optical drive for a while, and just never got around to looking at this problem.)
It is 4 am so will catch up on this tomorrow ..... when I can do some tests etc.
EDIT: Probably should not have posted at all.
On checking this am it seems that the second optical drive which is not seen at all is a SATA drive ...... and the reason it ain't seen now is that the SATA cable has bee disconnected!
It sure looks as if that was my "temporary" 'fix' until I got around to looking at this again.
Without the external burner that might have been a long time ago