energy reporting wrong since last core update

[MasterCATZ]

Describe the issue you are experiencing

energy readings have gone into the negatives and data from this month were 0'd other months seem to be still their in the long term statistics

Version	core-2022.7.6
Installation Type	Home Assistant OS
Development	false
Supervisor	true
Docker	true
User	root
Virtual Environment	false
Python Version	3.10.5
Operating System Family	Linux
Operating System Version	5.15.45
CPU Architecture	x86_64
Timezone	Australia/Brisbane
Configuration Directory	/config

What type of installation are you running?

Home Assistant OS

Which operating system are you running on?

Home Assistant Operating System

Which add-on are you reporting an issue with?

MariaDB

What is the version of the add-on?

2.5

Steps to reproduce the issue

using Mariadb 2.5

Version	core-2022.7.6
Installation Type	Home Assistant OS
Development	false
Supervisor	true
Docker	true
User	root
Virtual Environment	false
Python Version	3.10.5
Operating System Family	Linux
Operating System Version	5.15.45
CPU Architecture	x86_64
Timezone	Australia/Brisbane
Configuration Directory	/config

Anything in the Supervisor logs that might be useful for us?

No response

Anything in the add-on logs that might be useful for us?

[19:49:34] INFO: Starting MariaDB
220722 19:49:34 mysqld_safe Logging to '/data/databases/mariadb.err'.
220722 19:49:34 mysqld_safe Starting mariadbd daemon with databases from /data/databases
220722 19:49:34 mysqld_safe Starting mariadbd daemon with databases from /data/databases
2022-07-22 19:49:35 0 [Note] /usr/bin/mariadbd (server 10.6.8-MariaDB) starting as process 246 ...
2022-07-22 19:49:35 0 [Note] mariadbd: Aria engine: starting recovery
recovered pages: 0% 32% 52% 80% 100% (0.0 seconds); tables to flush: 2 1 0
 (0.0 seconds); 
2022-07-22 19:49:35 0 [Note] mariadbd: Aria engine: recovery done
2022-07-22 19:49:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-07-22 19:49:35 0 [Note] InnoDB: Number of pools: 1
2022-07-22 19:49:35 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-07-22 19:49:35 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2022-07-22 19:49:35 0 [Note] InnoDB: Using Linux native AIO
2022-07-22 19:49:35 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-07-22 19:49:35 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-22 19:49:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3827717083,3827717083
2022-07-22 19:49:35 0 [Note] InnoDB: Starting final batch to recover 1277 pages from redo log.
2022-07-22 19:49:36 0 [Note] InnoDB: 128 rollback segments are active.
2022-07-22 19:49:36 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-07-22 19:49:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-22 19:49:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-22 19:49:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-07-22 19:49:36 0 [Note] InnoDB: 10.6.8 started; log sequence number 3833192803; transaction id 29434
2022-07-22 19:49:36 0 [Note] InnoDB: Loading buffer pool(s) from /data/databases/ib_buffer_pool
2022-07-22 19:49:36 0 [Note] InnoDB: Buffer pool(s) load completed at 220722 19:49:36
2022-07-22 19:49:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-22 19:49:36 0 [Warning] 'innodb-buffer-pool-instances' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2022-07-22 19:49:36 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-07-22 19:49:36 0 [Note] Server socket created on IP: '::'.
2022-07-22 19:49:36 0 [Note] /usr/bin/mariadbd: ready for connections.
Version: '10.6.8-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
[19:49:36] INFO: Check data integrity and fix corruptions
mysql.column_stats                                 OK
mysql.columns_priv                                 OK

Additional information

No response

[mdegat01]

Didn't you just describe how you went directly into the DB and tried to reinsert all your data from this month here: https://github.com/home-assistant/addons/issues/2589#issuecomment-1182471131

Are you sure you did that right? Seems like that's exactly the range that's messed up.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.