Failed to load cache for server TdbArchiver/01

Hi tangoers,

For some time now, I cannot run or initialize the TdbArchiver DS. Whatever level (-v1, -v2…) I pass as argument, the DS is in 'FAULT' state with the following errors when calling the `DbGetDataForServerCache` command.

marrucho@srv-6:~$ sudo -E -u tango /opt/ArchivingRoot/device/linux/TdbArchiver 01
ERROR 2023-10-27 15:05:35,395 - main | o.t.c.d.cache.ServerCache.loadCache:56 - Failed to load cache for server TdbArchiver/01 on host srv-6
ERROR 2023-10-27 15:05:35,415 - main | o.t.c.d.cache.ServerCache.logDevFailed:126 - Error Level 0 :
ERROR 2023-10-27 15:05:35,418 - main | o.t.c.d.cache.ServerCache.logDevFailed:127 - - desc: The stored procedure failed with a MySQL error!!!
ERROR 2023-10-27 15:05:35,418 - main | o.t.c.d.cache.ServerCache.logDevFailed:128 - - origin: DataBase::DbGetDataForServerCache()
ERROR 2023-10-27 15:05:35,418 - main | o.t.c.d.cache.ServerCache.logDevFailed:129 - - reason: DB_StoredProcedureFailed
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:138 - - severity: ERROR
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:126 - Error Level 1 :
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:127 - - desc: Cannot execute command DbGetDataForServerCache on sys/database/2
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:128 - - origin: Connection.command_inout()
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:129 - - reason: TangoApi_CANNOT_EXECUTE_COMMAND
ERROR 2023-10-27 15:05:35,419 - main | o.t.c.d.cache.ServerCache.logDevFailed:138 - - severity: PANIC
INFO 2023-10-27 15:05:35,660 - archiving/tdb/tdbarchiver.01 Init | o.t.a.s.a.HdbArchiver.init:198 - init in
INFO 2023-10-27 15:05:35,661 - archiving/tdb/tdbarchiver.01 Init | o.t.a.s.a.HdbArchiver.init:205 - isforceUseEvents= false, isDedicated = false
INFO 2023-10-27 15:05:35,662 - archiving/tdb/tdbarchiver.01 Init | o.t.a.s.a.HdbArchiver.init:206 - reservedAttributes = [, ]
create file /var/archivage/tdb/01/tdbarchiver.01.log
ERROR 2023-10-27 15:05:35,668 - archiving/tdb/tdbarchiver.01 Init | o.t.s.device.InitImpl.manageInitError:199 - Init failed
java.lang.NullPointerException: null
at org.tango.archiving.server.archiver.HdbArchiver.init(HdbArchiver.java:214)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.tango.server.device.InitImpl.doInit(InitImpl.java:169)
at org.tango.server.device.InitImpl.access$200(InitImpl.java:60)
at org.tango.server.device.InitImpl$1.call(InitImpl.java:124)
at org.tango.server.device.InitImpl$1.call(InitImpl.java:119)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
INFO 2023-10-27 15:05:35,681 - main | o.t.server.ServerManager.init:245 - TANGO server TdbArchiver/01 started
INFO 2023-10-27 15:05:39,971 - RequestProcessor-5 | o.t.s.events.EventManager.initialize:200 - ZMQ (4.1.7) SERVER event system started

Used versions:
Debian 9.11
Tango 9.2
ArchivingRoot 22.4.0

Does anyone have an idea? Thanks.

Best regards,
JCM
This problem was due to unexpected values in the Tango Database.
See https://gitlab.com/tango-controls/TangoDatabase/-/issues/74 for more details.
Rosenberg's Law: Software is easy to make, except when you want it to do something new.
Corollary: The only software that's worth making is software that does something new.
 
Register or login to create to post a reply.