NTP_V2/src/NTP.Infrastructure/Persistence/SystemErrorLogger.cs

61 lines
2.9 KiB
C#

using System.Text;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using NTP.Application.Abstractions;
using Oracle.ManagedDataAccess.Client;
namespace NTP.Infrastructure.Persistence;
/// <summary>
/// Inserts into NTP.SYSTEM_ERRORS (ID from SEQ_SYSTEM_ERRORS, ERROR, ERRORDATE, IPADDRESS(15), USERID(50), BROWSER(200)).
/// Uses its own short-lived connection so it still works when the request's connection / transaction is the thing that failed,
/// and swallows every failure (logging an error must never hide the original one).
/// </summary>
internal sealed class SystemErrorLogger(IOptions<NtpSchemaOptions> options, ILogger<SystemErrorLogger> logger) : ISystemErrorLogger
{
public async Task LogAsync(Exception exception, string? userId, string? ipAddress, string? browser, string? requestInfo)
{
try
{
var cs = options.Value.ConnectionString;
if (string.IsNullOrWhiteSpace(cs)) return;
await using var con = new OracleConnection(cs);
await con.OpenAsync(CancellationToken.None);
await using var cmd = con.CreateCommand();
cmd.BindByName = true;
cmd.CommandText = """
INSERT INTO SYSTEM_ERRORS (ID, ERROR, ERRORDATE, IPADDRESS, USERID, BROWSER)
VALUES (SEQ_SYSTEM_ERRORS.NEXTVAL, :Err, SYSDATE, :Ip, :UserId, :Browser)
""";
cmd.Parameters.Add(new OracleParameter("Err", OracleDbType.Clob) { Value = Describe(exception, requestInfo) });
cmd.Parameters.Add(new OracleParameter("Ip", OracleDbType.Varchar2) { Value = Cut(ipAddress, 15) ?? "-" });
cmd.Parameters.Add(new OracleParameter("UserId", OracleDbType.Varchar2) { Value = Cut(userId, 50) });
cmd.Parameters.Add(new OracleParameter("Browser", OracleDbType.Varchar2) { Value = Cut(browser, 200) });
await cmd.ExecuteNonQueryAsync(CancellationToken.None);
}
catch (Exception ex)
{
logger.LogWarning(ex, "Could not save the error into SYSTEM_ERRORS");
}
}
private static string? Cut(string? v, int max) => string.IsNullOrEmpty(v) ? null : v.Length <= max ? v : v[..max];
/// <summary>Same layout as the legacy log: details, message, SQL (n/a), then where it happened.</summary>
private static string Describe(Exception ex, string? requestInfo)
{
var sb = new StringBuilder();
if (!string.IsNullOrEmpty(requestInfo)) sb.AppendLine("Request: " + requestInfo);
for (var e = ex; e is not null; e = e.InnerException!)
{
sb.AppendLine($"MSG: {e.GetType().FullName}: {e.Message}");
if (e is OracleException ora) sb.AppendLine($"ORA-{ora.Number:D5}");
if (e.InnerException is null) break;
}
sb.AppendLine("Details:");
sb.AppendLine(ex.ToString());
return sb.ToString();
}
}