[horde] horde_histories not-null constraint

[Hannes Tismer]

Dear Horde list,

I've just noticed that my Horde Webmail instance hasn't added any  
horde_histories entries since 2021. Looking at the logs any change I  
make in Kronolith results in errors like these:

ERR: HORDE [kronolith] SQL QUERY FAILED: SQLSTATE[23502]: Not null  
violation: 7 ERROR:  null value in column "history_modseq" violates  
not-null constraint
DETAIL:  Failing row contains (19117,  
kronolith:xxxxxxxxxxxxx at xxxxx..., modify, 1670970360, null, xxxxx,  
a:2:{s:3:"new";a:2:{s:11:"event_start";s:19:"2022-12-15 23:00:00...,  
null).
         INSERT INTO horde_histories (object_uid, history_ts, history_who,
           history_desc, history_action, history_modseq, history_extra) VALUES
           ('kronolith:xxxxxxxxxxxxxxxxxxxx', 1670970360, 'panni',  
NULL, 'modify', NULL,
           'a:2:{s:3:"new";a:2:{s:11:"event_start";s:19:"2022-12-15
           23:00:00";s:9:"event_end";s:19:"2022-12-16
            
00:00:00";}s:3:"old";a:2:{s:11:"event_start";N;s:9:"event_end";N;}}')  
[pid 108 on line 243 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
2022-12-13T23:26:00+01:00 ERR: HORDE [kronolith] SQLSTATE[23502]: Not  
null violation: 7 ERROR:  null value in column "history_modseq"  
violates not-null constraint



All migrations are applied as far as I can see and when manually  
inserting an entry into horde_histories_modseq, an incremented  
history_modseq is created, just as Horde/History/Sql.php:_nextModSeq()  
tries to  
(https://github.com/horde/History/blob/c112235f0327baf7202d56236c8f823fb40b6741/lib/Horde/History/Sql.php#L358).

Somehow it tries to insert a NULL value for history_modseq for the new  
horde_histories entry.


Horde Version: Webmail Edition 5.2.22
PostgreSQL: 12.13 (Ubuntu 12.13-1.pgdg22.04+1)
OS: Ubuntu Server 18.04.4 LTS (bionic)



Any ideas?

Thanks!
-- 
Hannes Tismer
Herzogstr. 4
41238 Mönchengladbach

PGP: DEBE887AD13C3CF27FEB22F45A2BC7A889FDE98A
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2187 bytes
Desc: Öffentlicher PGP-Schlüssel
URL: <https://lists.horde.org/archives/horde/attachments/20221213/437dd68f/attachment.key>