Windows Forms任务计划启动时FbDataReader偶发空引用异常排查

问题背景 #

通过任务计划程序以专用用户启动Windows Forms程序，使用FirebirdSql.Data.FirebirdClient 5.12.1版本执行数据库查询时，多数情况下正常，但偶发抛出System.NullReferenceException: 'Object reference not set to an instance of an object.'异常。尝试过手动管理连接、取消using语句等方式，问题仍未解决。错误触发点为readCommand3.ExecuteReader()调用，且该查询前的9个同库查询均执行正常，断点验证连接状态、命令文本均无异常。

问题代码 #

using (FbConnection ConnBMC = new FbConnection(BMC.connStringBMC))
{
    ConnBMC.Open();
    string ukaz = "SELECT IME,VREDNOST_STR,VREDNOST_REAL,VREDNOST_INT FROM PARAM WHERE IME = 'EPOSTA_UPORABNISKO_IME' OR IME = 'EPOSTA_GESLO' OR IME = 'EPOSTA_STREZNIK' OR IME = 'EPOSTA_VRATA' OR IME = 'EPOSTA_SEND_FROM_NOREPLY' OR IME = 'EPOSTA_NASLOV_INT'";

    using (FbCommand readCommand3 = new FbCommand(ukaz, ConnBMC))
    {
        using (FbDataReader myreader3 = readCommand3.ExecuteReader())
        {
            while (myreader3.Read())
            {
                if (myreader3["IME"].ToString().Trim() == "EPOSTA_UPORABNISKO_IME") BMC.emailUser = myreader3["VREDNOST_STR"].ToString().Trim();
                else if (myreader3["IME"].ToString().Trim() == "EPOSTA_GESLO") BMC.emailPass = myreader3["VREDNOST_STR"].ToString().Trim();
                else if (myreader3["IME"].ToString().Trim() == "EPOSTA_STREZNIK") BMC.emailServer = myreader3["VREDNOST_STR"].ToString().Trim();
                else if (myreader3["IME"].ToString().Trim() == "EPOSTA_VRATA") BMC.emailPort = myreader3["VREDNOST_STR"].ToString().Trim();
                else if (myreader3["IME"].ToString().Trim() == "EPOSTA_ENABLE_SSL") BMC.emailSSL = Convert.ToBoolean(myreader3["VREDNOST_INT"]);
                else if (myreader3["IME"].ToString().Trim() == "EPOSTA_NASLOV_INT") BMC.emailInternalAddress = myreader3["VREDNOST_STR"].ToString().Trim();
            }
        }
    }
}

堆栈跟踪 #

at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
   at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
   at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader()
   at BMC.Form1.readParam() in C:\Development\Visual Studio 2017\Projects\BMC\BMC\Form1.cs:line 1008
   at BMC.Form1.Form1_Load(Object sender, EventArgs e) in C:\Development\Visual Studio 2017\Projects\BMC\BMC\Form1.cs:line 103
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at DevExpress.XtraEditors.XtraForm.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
   at BMC.Form1.WndProc(Message& msg) in C:\Development\Visual Studio 2017\Projects\BMC\BMC\Form1.cs:line 455
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

问题分析 #

从堆栈跟踪可知，异常发生在Firebird客户端内部的事务初始化阶段，而非用户代码直接触发的空引用，大概率是以下场景导致：

• 连接池复用的连接处于异常状态（数据库端已断开但客户端未感知）
• 事务参数缓冲区（TPB）初始化时出现空引用
• 任务计划专用用户缺少系统资源访问权限，导致客户端组件初始化失败

解决步骤 #

1. 禁用连接池测试 #

在连接字符串中添加Pooling=false，避免复用可能异常的连接：

BMC.connStringBMC += ";Pooling=false";

若问题解决，后续可调整连接池参数（如Max Pool Size、Connection Lifetime）优化性能，而非长期禁用。

2. 显式管理事务与字段空值检查 #

手动创建事务并绑定到命令，同时添加DBNull检查避免字段为空时出错：

using (FbConnection ConnBMC = new FbConnection(BMC.connStringBMC))
{
    ConnBMC.Open();
    // 显式创建事务
    using (var transaction = ConnBMC.BeginTransaction(FbTransactionOptions.Default))
    {
        // 使用IN子句简化SQL
        string ukaz = "SELECT IME,VREDNOST_STR,VREDNOST_REAL,VREDNOST_INT FROM PARAM WHERE IME IN ('EPOSTA_UPORABNISKO_IME', 'EPOSTA_GESLO', 'EPOSTA_STREZNIK', 'EPOSTA_VRATA', 'EPOSTA_SEND_FROM_NOREPLY', 'EPOSTA_NASLOV_INT')";

        using (FbCommand readCommand3 = new FbCommand(ukaz, ConnBMC, transaction))
        {
            using (FbDataReader myreader3 = readCommand3.ExecuteReader())
            {
                while (myreader3.Read())
                {
                    // 先检查字段是否为DBNull再处理
                    var ime = myreader3["IME"] != DBNull.Value ? myreader3["IME"].ToString().Trim() : string.Empty;
                    switch(ime)
                    {
                        case "EPOSTA_UPORABNISKO_IME":
                            BMC.emailUser = myreader3["VREDNOST_STR"] != DBNull.Value ? myreader3["VREDNOST_STR"].ToString().Trim() : string.Empty;
                            break;
                        case "EPOSTA_GESLO":
                            BMC.emailPass = myreader3["VREDNOST_STR"] != DBNull.Value ? myreader3["VREDNOST_STR"].ToString().Trim() : string.Empty;
                            break;
                        case "EPOSTA_STREZNIK":
                            BMC.emailServer = myreader3["VREDNOST_STR"] != DBNull.Value ? myreader3["VREDNOST_STR"].ToString().Trim() : string.Empty;
                            break;
                        case "EPOSTA_VRATA":
                            BMC.emailPort = myreader3["VREDNOST_STR"] != DBNull.Value ? myreader3["VREDNOST_STR"].ToString().Trim() : string.Empty;
                            break;
                        case "EPOSTA_ENABLE_SSL":
                            BMC.emailSSL = myreader3["VREDNOST_INT"] != DBNull.Value ? Convert.ToBoolean(myreader3["VREDNOST_INT"]) : false;
                            break;
                        case "EPOSTA_NASLOV_INT":
                            BMC.emailInternalAddress = myreader3["VREDNOST_STR"] != DBNull.Value ? myreader3["VREDNOST_STR"].ToString().Trim() : string.Empty;
                            break;
                    }
                }
            }
            transaction.Commit();
        }
    }
}

3. 升级Firebird客户端版本 #

当前使用的5.12.1版本可能存在已知bug，升级到最新稳定版（如6.x系列），验证是否已修复事务初始化空引用问题。

4. 检查任务计划用户环境 #

• 确保专用用户拥有Firebird客户端安装目录的读取权限
• 验证用户能访问Firebird数据库服务器的默认端口（3050）
• 尝试在任务计划中勾选“以最高权限运行”测试

5. 添加异常重试机制 #

针对偶发异常，添加重试逻辑避免单次失败导致程序崩溃：

int retryCount = 3;
bool success = false;
while(retryCount > 0 && !success)
{
    try
    {
        // 插入修改后的查询代码
        success = true;
    }
    catch(NullReferenceException)
    {
        retryCount--;
        if(retryCount == 0) throw;
        Thread.Sleep(1000); // 等待1秒后重试
    }
}

内容的提问来源于stack exchange，提问作者A. Celarc