14 Replies Last post: May 15, 2008 2:46 PM by Vinh  
Click to view sgaddam's profile Novice 28 posts since
Sep 14, 2005

Apr 10, 2008 10:21 AM

clear space community not working with MS Sql server

Hello,

I tried with both the SQL server 2000 and 2005 with tomcat 6.0.16 and JDK 1.6. With 2000 there are more issues, seems I cannot register the users.

 

With 2005, I can register the users. But I see the following error message. I can not create the subcommunity, it says system error. That's all. There is no error message in the log file.

 

I have only one following error message in the jive.error.log while clearspace starting up .

 

[error] WARNING: failed to obtain next ID block due to thread contention. Trying again...

 

Thank you,

-Sreeni.

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

What version of Clearspace Community is this?

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

SQL Server 2005 is a supported database.

 

Is that the entire error log?

 

Was the database empty before installing Clearspace?

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

Hi Sreeni,

 

I'm sorry about the long delay in replies. I am still not sure what's wrong, but I've got a couple questions/requests if you're still experiencing problems with this:

 

  • Is anything showing up in any of your tomcat logs when you encounter this system error?
  • Can you get a thread dump when this error occurs?

 

Please let me know what you find out.

 

Thanks,

Vinh

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

Thank you Sreeni. I assume the error log still just says, "error WARNING: failed to obtain next ID block due to thread contention. Trying again..." at the time of the error?

 

Thanks,

Vinh

Click to view Bruce Ritchie's profile Expert 2,283 posts since
Jun 28, 2001

Can you try with the jTDS jdbc driver instead of using the microsoft driver? I've never had much luck with the MS drivers, especially the older ones.

 

 

Regards,

 

Bruce Ritchie

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

Thanks for being so patient, Sreeni.

 

Vinh

 

(And thanks for the suggestion, Bruce )

Click to view Vinh's profile Expert 1,212 posts since
Apr 1, 2008

I've talked to Bruce about it and it seems the code for Microsoft's JDBC driver leaves a little to be desired. I'm not sure no the specifics, but I think the latest Microsoft JDBC driver is more stable than the older ones, but the jTDS driver is your best choice by far for Clearspace.

 

Thanks,

Vinh

More Like This

  • Retrieving data ...