Issue in running AzureSQLEdge module on IoT Edge Device

Athira Gopinath(UST,IN) 96 Reputation points
2023-05-11T10:50:05.8333333+00:00

Hi Team,

As part of my research, I have deployed AzureSQLEdge module from Marketplace.It was running earlier.But now seems to be faile due to the below exception

2023-05-11 09:56:45.81 spid9s      Starting up database 'msdb'.
2023-05-11 09:56:45.82 spid9s      Failed to get the volume information, -1073741772
2023-05-11 09:56:45.82 spid11s     [32767]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 0. CleanupUnderUserTransaction: 0.
2023-05-11 09:56:45.83 spid11s     Starting up database 'mssqlsystemresource'.
2023-05-11 09:56:45.83 spid9s      Failed to get the volume information, -1073741772
2023-05-11 09:56:45.83 spid9s      Error: 17204, Severity: 16, State: 1.
2023-05-11 09:56:45.83 spid9s      FCB::Open failed: Could not open file D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf for file number 1.  OS error: 2(The system cannot find the file specified.).
2023-05-11 09:56:45.83 spid11s     Refresh DEK for DBID: [32767] File Id: [1] - Copying encryption state
2023-05-11 09:56:45.84 spid9s      Error: 5120, Severity: 16, State: 101.
2023-05-11 09:56:45.84 spid9s      Unable to open the physical file "D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\MSDBData.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
2023-05-11 09:56:45.84 spid11s     DBID: [32767] File Header for File Id: [1] was read with state = 0.
2023-05-11 09:56:45.85 spid11s     DBID: [32767] No DEK update for File Id: [1] while existing DEK is null.
2023-05-11 09:56:45.85 spid9s      Failed to get the volume information, -1073741772
2023-05-11 09:56:45.85 spid11s     The resource datald version is 15.00.2000. This is an informational message only. No user action is required.
2023-05-11 09:56:45.86 spid9s      Failed to get the volume information, -1073741772
2023-05-11 09:56:45.86 spid11s     Refresh DEK for DBID: [32767] File Id: [2] - Copying encryption state
2023-05-11 09:56:45.86 spid9s      Error: 17207, Severity: 16, State: 1.
2023-05-11 09:56:45.86 spid9s      FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2023-05-11 09:56:45.86 spid11s     DBID: [32767] File Header for File Id: [2] was read with state = 0.
2023-05-11 09:56:45.87 spid9s      File activation failure. The physical file name "D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\MSDBLog.ldf" may be incorrect.
2023-05-11 09:56:45.87 spid11s     DBID: [32767] No DEK update for File Id: [2] while existing DEK is null.
2023-05-11 09:56:45.90 spid11s     [3]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 0. CleanupUnderUserTransaction: 0.
2023-05-11 09:56:45.91 spid11s     Starting up database 'model'.
2023-05-11 09:56:45.91 spid11s     Failed to get the volume information, -1073741772
2023-05-11 09:56:45.92 spid11s     Failed to get the volume information, -1073741772
2023-05-11 09:56:45.92 spid11s     Error: 17204, Severity: 16, State: 1.
2023-05-11 09:56:45.92 spid11s     FCB::Open failed: Could not open file D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\model.mdf for file number 1.  OS error: 2(The system cannot find the file specified.).
2023-05-11 09:56:45.93 spid11s     Error: 5120, Severity: 16, State: 101.
2023-05-11 09:56:45.93 spid11s     Unable to open the physical file "D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\model.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
2023-05-11 09:56:45.93 spid11s     Failed to get the volume information, -1073741772
2023-05-11 09:56:45.94 spid11s     Failed to get the volume information, -1073741772
2023-05-11 09:56:45.94 spid11s     Error: 17207, Severity: 16, State: 1.
2023-05-11 09:56:45.94 spid11s     FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2023-05-11 09:56:45.95 spid11s     File activation failure. The physical file name "D:\dbs\sh\asded\0613_175216\cmd\15\obj\x64retail\sql\mkmastr\databases\mkmastr.proj\modellog.ldf" may be incorrect.
2023-05-11 09:56:45.95 spid11s     Error: 945, Severity: 14, State: 2.
2023-05-11 09:56:45.95 spid11s     Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
2023-05-11 09:56:45.96 spid11s     SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2023-05-11 09:56:46.04 Server      Configuring Always Encrypted enclave in asynchronous mode.

Please suggest some solution for the same

Thanks,

Athira Gopinath

Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
46 questions
{count} votes

1 answer

Sort by: Most helpful
  1. LeelaRajeshSayana-MSFT 13,871 Reputation points
    2023-05-16T01:54:31.62+00:00

    Hi @Athira Gopinath(UST,IN) Thank you for sharing the resources. I have attempted to Add an Azure SQL Edge module using the resource Deploy Azure SQL Edge you have shared and it worked as expected.

    Based on the error message you are seeing and considering that it is only observed on your machine, I appreciate it if you can review the Container Create Options of the module and inspect the Binds section and Mounts section of the file and see if there are changes in comparison to other machines.

    To inspect this settings do the following-

    • Navigate to the IoT Edge device of the IoT Hub which has the module deployed on the Azure portal
    • Click on Set Modules on top and choose your Azure SQL Edge module.
    • Click on the Container Create options and inspect the settings.

    I would also like to know if you have made any custom changes to the container create options file while creating the module to perform any additional DB operations such as backup or restore. Also, have you done any reinstallation of the module on your machine where you are experiencing this?

    I appreciate it if you can share the above requested information to help us better understand the issue.

    0 comments No comments