Skip to main content

SQL issues in CM12

I submitted this bug on Connect the other day:

Both my CAS and primary have had this error repeat since install. No ill effects noticed, but I think we should know what causes it.
Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'
Failed to flush the commit table to disk in dbid 5 due to error 2601. Check the errorlog for more information.

They recommended that I install CU14 for old SQL 2008 SP1.  They also state that this won't fix the issue, but it supposedly will keep the boxes from having the issue after we make the fix.

So I downloaded CU14 and tried to install it 500 times before it clicked in my head that just possibly the download was corrupted.  Redownloaded it and it just installed on the primary fine.  CAS up next.

  • Created on .