Bug#1062979: tango-db: the upgraded version of tango-db is not compatible with maria-db from bookworm

[Santiago Ruano Rincón]

El 25/10/24 a las 14:44, Santiago Ruano Rincón escribió:
[snip]
> Wouldn't you reporting an issue about a bookworm -> trixie upgrade?
> 
> I have tried the above mentioned steps upgrading from bookworm to
> testing, and tango-starter is unable to start:
> 
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Tango exception
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Severity = ERROR
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Error reason = DB_SQLError
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Desc : Failed to query TANGO database (error=Field 'date' doesn't have a default value)
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: .The query was: INSERT INTO property_device_hist SET device='tango/admin/bookworm-tango-db',id='43',name='polled_attr',count='1',value='hoststate'
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Origin : DataBase::db_put_device_property
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Tango exception
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Severity = ERROR
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Error reason = API_CommandFailed
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Desc : Failed to execute command_inout on device sys/database/2, command DbPutDeviceProperty
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Origin : virtual CORBA::Any_var Tango::Connection::command_inout(const std::string&, const CORBA::Any&) at (./lib/cpp/src/client/devapi_base.cpp:1531)
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Received a CORBA_Exception
> Oct 25 14:40:32 bookworm-tango-db Starter[11770]: Exiting
> Oct 25 14:40:32 bookworm-tango-db systemd[1]: tango-starter.service: Deactivated successfully.
> 
> Frédéric, would you mind confirming this?

Sorry for the noise. I can confirm there is an issue in bookworm, and it
is present even without upgrading from bullseye. Which makes sense with
https://gitlab.com/tango-controls/TangoDatabase/-/issues/69

I will propose a bookworm update soon.

Have a nice week-end,

 -- Santiago
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/debian-science-maintainers/attachments/20241025/0185ce89/attachment.sig>