00:04:05 <sommerfeld> ah, the field that is causing trouble is declared as VARCHAR.   sqlite2 dumps some rows as integers, others as strings
00:04:40 <sommerfeld> sqlite3 dumps them all as strings, but turned the large unsigned into a double on read
00:07:02 <sommerfeld> (and dumped it as '1.84467440737096e+19'
00:07:05 <sommerfeld> )
00:49:20 <alanc> we had a python script dump the sqlite2 db, process the output, then import to sqlite3
00:49:39 <alanc> I am thankfully ignorant of the details of getting that working
00:52:57 <sommerfeld> yeah, I can now see why that was needed.
17:26:04 <gitomat> [illumos-gate] 15167 Panic when halting a zone with self-created links -- Andy Fiddaman <illumos⊙fn>
18:47:54 <jclulow> Assuming both the 2 and 3 shlib can be linked at once, I think we would probably aim for a C program that does the conversion and any checks, etc.
18:48:08 <jclulow> SQLite3 is pretty great, it would be good to ditch the old stuff.
18:54:22 <sommerfeld> Just to make it trickier, there are two other consumers of SQLite 2 in illumos-gate: idmapd and smbsrv's libsmb
18:55:49 <sommerfeld> and the version of sqlite 2 in the gate has been extended with UTF8 case conversion functions (used by idmap in sql constraints)
19:42:23 <jbk> it'd be nice.. i'm pretty sure there's a lurking consistency bug in the current version that leads to corrupt repository.db files during unclean shutdowns
19:48:02 <richlowe> I have done a million unclean shutdowns of late without corruption
19:48:16 <richlowe> but that doesn't mean much, except it's hard to trigger
20:59:06 <jclulow> sommerfeld: We may be able to assemble a framework to do all three of those conversions in at least a broadly similar fashion