On Thu, 31 Aug 2017 11:47:51 +0800, Paul Wise wrote:

> > I guess you don't have the pentabarf.xml which caused you problems
> > lying around somewhere locally?
> I don't have it as ConfClerk doesn't appear to cache the file itself.

Right, it would have been a coincidence if you had downloaded the
file the debug and still have it around :)
 
> ConfClerk on my system is still exhibiting the same behaviour, even
> after I "Reloaded from URL" for DebConf17.
> 
> I then backed up and deleted the ConfClerk database and added the
> DebConf17 penta URL and now the issue is resolved.
> 
> I restored from the backup, deleted and re-added DebConf17 and the
> issue is again resolved.
> 
> I was able to fix the issue by executing this SQL on the database:
> 
> $ sqlite ~/.local/share/data/Toastfreeware/ConfClerk/ConfClerk.sqlite
> sqlite> DELETE FROM event WHERE id='';

Thanks.
This matches exactly the behaviour we've seen during DebCamp caused by
the broken XML file and ConfClerk messing up its database ...
 
> I was then able to reintroduce the issue by running this SQL:
> 
> $ sqlite ~/.local/share/data/Toastfreeware/ConfClerk/ConfClerk.sqlite
> sqlite> INSERT INTO event VALUES((SELECT id FROM conference WHERE 
> url='https://debconf17.debconf.org/schedule/pentabarf.xml'),'',1502562600,0,36,'',NULL,NULL,'',NULL,'','',0,0);
 
Oh, neat idea, thanks, this will help us to make ConfClerk more
resilient against the next breakage ...


Cheers,
gregor

-- 
 .''`.  https://info.comodo.priv.at/ - Debian Developer https://www.debian.org
 : :' : OpenPGP fingerprint D1E1 316E 93A7 60A8 104D  85FA BB3A 6801 8649 AA06
 `. `'  Member of VIBE!AT & SPI, fellow of the Free Software Foundation Europe
   `-   NP: Steppenwolf: Everybody's Next One

Attachment: signature.asc
Description: Digital Signature

Reply via email to