Archives Nov. 16, 2004

Something in the code introduced to improve the discovery process has managed to produce a failure where the main operations block for too long, causing the zombie watcher to attempt to restart, but it's unable to kill the main process.

Have to figure out a reliable way to force the killing... also need to figure ...

Cinemon was displaying some strange behaviour during discovery, mostly dropping off modems and/or discovering them only after 4 or 5 scans. Haven't been able to isolate the proximate cause yet, but the effect seems to have been fixed.

I hate it when a fix works but I don't know why.

I use the DBAPI's pyformat query format exclusively. It's supported by both the PostgreSQL and MySQL drivers, and it's just a superior mechanism for creating queries (especially with PyTable's SQLQuery class). So, of course, as I was writing the SQLite driver for PyTable I was obviously using pyformat queries.

Problem was, SQLite doesn't support them, ...

SQLite has this annoying habit of reporting all syntax errors with just the text "error preparing statement". That becomes a serious PITA when you're auto-generating huge query strings, but even with the short schema-discovery queries I'm finding it frustrating.