I assume sqlite is mostly off the radar and just seen as legacy, but I think this should at least get a mention in bacula's docs: sqlite via libdbi is majorly broken (standard 686 platform). Reason is this: selects for bigints (and bacula's volume sizes are bigints) always return a 0 no matter what the actual value is.
I've confirmed this using bacula's debugging output (the native 'sqlite' client showed correct values with the exact same SELECT), but didn't bother with an actual stand-alone test case and just migrated to postgres. People at least should be aware of the problem (even if it's something extremely specific to my configuration, which I doubt). --mmazur ------------------------------------------------------------------------------ Register Now & Save for Velocity, the Web Performance & Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance & Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
