Page 1 of 1
SQL Rollover failure
Posted: Wed 30 Jun 2021 11:39 pm
by 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.
Re: SQL Rollover failure
Posted: Thu 01 Jul 2021 1:24 am
by 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)
Re: SQL Rollover failure
Posted: Sat 03 Jul 2021 11:34 am
by mcrossley
Can you post the full SQL statements that are failing please.
Re: SQL Rollover failure
Posted: Sat 03 Jul 2021 11:52 am
by Mapantz
Code: Select all
INSERT IGNORE INTO Lightning (LogDate,StrikesToday) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#LightningStrikesToday>)
That's the only one I use
Re: SQL Rollover failure
Posted: Sat 03 Jul 2021 5:04 pm
by mcrossley
Yes, but I need to see the statement that fails with the data not the variables.
Re: SQL Rollover failure
Posted: Sat 03 Jul 2021 5:37 pm
by Mapantz
There's no other information apart from the two lines I put in my first post..
Re: SQL Rollover failure
Posted: Sat 03 Jul 2021 8:04 pm
by mcrossley
You will need to switch on debug logging, then it should log the insert statement.
Re: SQL Rollover failure
Posted: Sun 04 Jul 2021 2:02 am
by 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