Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: rt_sevhistmon - Database error

rt_sevhistmon - Database error 4 years 1 month ago #10533

  • SS48
  • SS48's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 2
  • Karma: 0
Hi,
Configuration: PC, debian9, pwrrt_5.6, install mysql-server.
The database on pwrrt contains in node SevServer, SevHistMonitor, SevHistThread (one second).
In Plant contains Av's, each of which includes SevHist object. Fields Attribute, ThreadObject and StorageTime are correctly filled.
Some part of variables is written to the database mysql (65 of 123, all in float32 format). Another piece of data is not written.
In the logs on pwrrt:
E sev_server 2551 20-03-18 21:59:39.94 Database store error: , table O000_001_001_001......
.....
etc.

Why not all data is recorded? Help if anyone came across a similar!

/Sergey
Last Edit: 4 years 1 month ago by SS48.
The administrator has disabled public write access.

rt_sevhistmon - Database error 4 years 4 weeks ago #10534

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3176
  • Thank you received: 501
  • Karma: 133
Hi Sergey,

You can try to run sev_repair to fix this. sev_repair -h will show how to use it. Kill the sev_server before running sev_repair.
Make also sure that you use engine Innodb for the tables. sev_repair can be used also to alter the engine.

/Claes
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 8.676 seconds