SQL Rollover failure

[Mapantz]

I've only just noticed this in the log file

Code: Select all

2021-07-01 00:00:00.201 CustomSqlRollover: Error encountered during MySQL operation.
2021-07-01 00:00:00.201 Could not load file or assembly 'System.Memory, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Code: Select all

INSERT IGNORE INTO Lightning (LogDate,StrikesToday) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#LightningStrikesToday>)

Never had an issue with it before.

[jlmr731]

I looked at mine and see no Rollover error but do see something kinda same but different

Code: Select all

2021-06-11 13:45:39.060 CustomSqlSecs: Error encountered during MySQL operation.
2021-06-11 13:45:39.060 CustomSqlSecs: SQL was - "INSERT INTO ........ 

it goes for a few then nothing for a while then starts up again, what is strange that it happens at 45 minute and 0 top of the hour. When these errors occur nothing is entered in to the database at that time. Must be something within the custom SQL entries. Guessing Mapantz you have this only done at rollover as mine is writing every minute (never noticed it till you found it)

[mcrossley]

Can you post the full SQL statements that are failing please.

[Mapantz]

Code: Select all

INSERT IGNORE INTO Lightning (LogDate,StrikesToday) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#LightningStrikesToday>)

That's the only one I use

[mcrossley]

Yes, but I need to see the statement that fails with the data not the variables.

[Mapantz]

There's no other information apart from the two lines I put in my first post..

[mcrossley]

You will need to switch on debug logging, then it should log the insert statement.

[jlmr731]

I just looked and I haven't had the error since June 24. SO hard to say why it happens next time I restart ill check but mapantz problem looks like it happens often