We help IT Professionals succeed at work.

ISCSI in windows 20008

375 Views
Last Modified: 2014-08-26
I'm using rocket iscsi with a virtual disk image set up on another server.  I have a production server that connects to this iscsi drive using windows 2008 iscsi initiator.  When either server reboots, or loses power and the other one doesn't, it creates some wacky halt condition where the SQL server still runs, but in a very limited way (The SQL DB is not on the ISCSI volume, FYI-- nothing system related should be, no page, no index, etc) It won't run any maintenance plans and it won't gracefully shutdown.  I'm assuming there is some system patrol writing to this iscsi volume when the condition occurs, because the windows event viewer is plague with bad sector warnings.  

I've tried round-robin and failover, but the problem still occurs.  Is this native to ISCSI in 2008?  Is there a way to make it content with being removable?  Can I make it pause or increase a timeout value to 500 seconds?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
iSCSI treats the storage device as if it were a local, block driven I/O device and you should never have direct access to it from two different PC's.  Doing so is asking for data corruption.
M$ reccomends using a dedicated pair of NICs for access to the iSCSI device and then you should share it to other systems that need access: http://technet.microsoft.com/en-us/library/ee338476(v=ws.10).aspx
Chris HInfrastructure Manager
CERTIFIED EXPERT

Author

Commented:
I understand that.  There is one server connected to one iscsi share.  When either the storage server reboots or the 2008 server reboots, the 2008 server acts really stupid.  I need this to stop.  There is nothing system related, other than system volume information, which would have a lock on the drive.  I only have this issue with 2008 iscsi Initiator.  Vmware is much more graceful....
CERTIFIED EXPERT

Commented:
There must be something open on the storage server from the other server and assuming the iSCSI is a mapped drive, it could be the system volume information which you could disable on the 2nd server.  Its in the advanved system properties on the system restore or system protection tab.
If that ain't it, we need to figure out what is open.
Chris HInfrastructure Manager
CERTIFIED EXPERT

Author

Commented:
Interesting...  2008 sp1 (Not 2008 R2) does not contain system protection, but I think you're on to something.
Chris HInfrastructure Manager
CERTIFIED EXPERT

Author

Commented:
I started down the path you were going and found a lot of people trying to resolve the issue are using a program from MS called Handle.  This is a list of handle locks on the drive.  

 3F4: File  (R--)   F:\$Extend\$RmMetadata\$TxfLog\$TxfLog.blf
  538: File  (R--)   F:\$Extend\$RmMetadata\$TxfLog\$TxfLogContainer00000000000000000001
  580: File  (R--)   F:\$Extend\$RmMetadata\$TxfLog\$TxfLogContainer00000000000000000002
  58C: File  (RWD)   F:\$Extend\$RmMetadata\$Txf
  1FC: File  (RWD)   F:\$Extend\$ObjId
  204: File  (R--)   F:\System Volume Information\tracking.log

Any idea how to free these so the system doesn't halt if the drive disappears?
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Chris HInfrastructure Manager
CERTIFIED EXPERT

Author

Commented:
I gave up and went with unstoppable copier, some registry edits and a network share.  Pray for me...
Chris HInfrastructure Manager
CERTIFIED EXPERT

Author

Commented:
The downfall of 2008 ISCSI is that it must be persistent or redundant, otherwise a locally mapped drive with a windows volume will always demand access to the drive.  Bummer...  I believe the problem is resolved in windows 2008R2, in which the user is able to disable all the locking features on the drive, such as indexing and recovery.  Thanks for the suggestions!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.