locked
Job stay in Queue - SQL Error in HpcScheduler log RRS feed

  • Question

  • When submitting jobs, one job stays in queue despite that resources are available. Below is the information in the Scheduler log files. Any suggestions?

    This is in HPC Pack 2012R2 Update 3.

    10/28/2019 10:56:13.609 w HpcScheduler 13400 5984 The scheduler got a SQL exception. [..exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 0, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6519;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 1, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6520;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 2, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6521;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 3, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6522;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 4, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6523;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 5, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6524;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 6, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6525;..........exec SP_OpenJobAllocationEntry 131762, 121, 519691042816, 7, 0, N'2019-10-28 10:56:13.474', N'2019-10-28 10:56:13.474', 6526;........] System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'NodeId', table 'HPCScheduler.dbo.AllocationHistory'; column does not allow nulls. INSERT fails...Cannot insert the value NULL into column 'NodeId', table 'HPCScheduler.dbo.AllocationHistory'; column does not allow nulls. INSERT fails...Cannot insert the value NULL into column 'NodeId', table 'HPCScheduler.dbo.AllocationHistory'; column does not allow nulls. INSERT fails...Cannot insert the value NULL into column 'NodeId', table 'HPCScheduler.dbo.AllocationHistory'; column does not allow nulls. INSERT fails...Cannot inse\RØû
    10/28/2019 10:56:13.612 i HpcScheduler 13400 5984 [Policy] Failed to commit transaction to schedule job 131762 with resources DKBDKB9GRA100A,8. Error:Microsoft.Hpc.Scheduler.Properties.SchedulerException: An exception occurred while attempting to access the scheduler database.  Please check the scheduler event log, or contact your cluster administrator...   at Microsoft.Hpc.Scheduler.Store.CallResult.Throw()..   at Microsoft.Hpc.Scheduler.Store.SchedulerStoreSvc.RunTransaction(StoreTransactionWrapper wrapper)..   at Microsoft.Hpc.Scheduler.PolicyEngine.SchedulerStrategy.RunJobAllocationTransaction(SchedulerJobInternal job, JobUnitType type, JobState previousState, List`1 allocatedNodes, Dictionary`2 allocationOnNodes, String allocatedResourcesString, JobUnitType allocationType, Int32 computedNodeListId)  


    Monday, October 28, 2019 1:33 PM