[Bug 433100] New: migration to SQLite -very- unpleasant ...
https://bugzilla.novell.com/show_bug.cgi?id=433100 Summary: migration to SQLite -very- unpleasant ... Product: openSUSE 11.1 Version: Beta 2 Platform: Other OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: Evolution AssignedTo: bnc-team-evolution@forge.provo.novell.com ReportedBy: mmeeks@novell.com QAContact: lakhil@novell.com Found By: --- So, I've been running this for several minutes, and - it's taking a long time. I have all my mail stored locally, but the migration process seems to take a -long- time; also, the dialog is too succinct and the grammar could be improved. Interestingly we're not using 100% CPU - though we're doing a lot of I/O. The dialog also unfortunately gives no idea of the amount of time left; when this is a really long task. - so far running 10+ minutes and showing 0% on the progress bar. My console output so far looks like this: (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 51/51 dirty records of Mail/archive/gb (evolution:9548): camel-WARNING **: Could not open converter for 'unknown-8bit' to 'UTF-8' charset Saving 2731/2731 dirty records of Mail/archive/StarDivision Saving 8/8 dirty records of Mail/archive/vte Saving 77/77 dirty records of Mail/archive/old-inbox Saving 166/166 dirty records of Mail/archive/disksim Saving 2079/2079 dirty records of Mail/archive/gnome-vfs Saving 1107/1107 dirty records of Mail/archive/gconf Saving 164/164 dirty records of Mail/archive/julia (evolution:9548): camel-WARNING **: Could not open converter for 'X-UNKNOWN' to 'UTF-8' charset (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 2490/2490 dirty records of Mail/archive/gnome-love Saving 64183/64183 dirty records of Mail/archive/gnomecvs Saving 286/286 dirty records of Mail/archive/gnome-print Saving 12/12 dirty records of Mail/archive/hub (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 5016/5016 dirty records of Mail/archive/foundation Saving 758/758 dirty records of Mail/archive/dia Saving 1184/1184 dirty records of Mail/archive/Gnome Office (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 775/775 dirty records of Mail/archive/gst Saving 10/10 dirty records of Mail/archive/eog (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 5758/5758 dirty records of Mail/archive/gnumeric Saving 36/36 dirty records of Mail/archive/gpdf Saving 254/254 dirty records of Mail/archive/dung (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 23550/23550 dirty records of Mail/1OpenOffice Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' [no such table: Mail/1OpenOffice/archive] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' WHERE junk = 1 [no such table: Mail/1OpenOffice/archive] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' WHERE deleted = 1 [no such table: Mail/1OpenOffice/archive] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' WHERE read = 0 [no such table: Mail/1OpenOffice/archive] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' WHERE junk = 0 AND deleted = 0 [no such table: Mail/1OpenOffice/archive] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Mail/1OpenOffice/archive' WHERE junk = 1 AND deleted = 0 [no such table: Mail/1OpenOffice/archive] (evolution:9548): camel-local-provider-WARNING **: Hmm, the xev headers shouldn't have changed size, but they did (evolution:9548): camel-local-provider-WARNING **: failed a quick-sync, trying a full sync Saving 39/39 dirty records of Mail/1OpenOffice/archive/0martink Saving 3208/3208 dirty records of Mail/1OpenOffice/suse-gcc (evolution:9548): camel-WARNING **: Could not open converter for 'HZ-GB-2312' to 'UTF-8' charset Saving 37473/37473 dirty records of Mail/1OpenOffice/suse-gcc/gcc (evolution:9548): camel-WARNING **: Could not open converter for 'UNKNOWN' to 'UTF-8' charset Saving 14986/14986 dirty records of Mail/1OpenOffice/suse-gcc/binutils (evolution:9548): camel-WARNING **: Could not find key entry for word '000000000000000000000000000p': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word '0000000000001l': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word 'ffffffffffffe00000000000000p': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word '0000000000001l': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word '0000000d620000000000p': No such file or directory ... (evolution:9548): camel-WARNING **: Could not find key entry for word '0x7ff0000000000000l': No such file or directory Saving 2830/2830 dirty records of Mail/1OpenOffice/suse-gcc/libc-alpha Saving 3/3 dirty records of Mail/1OpenOffice/oolists Saving 1575/1575 dirty records of Mail/1OpenOffice/oolists/council Saving 170/170 dirty records of Mail/1OpenOffice/oolists/specs Saving 392/392 dirty records of Mail/1OpenOffice/oolists/ui (evolution:9548): camel-WARNING **: Could not find key entry for word 'getimportpropertymapper': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word 'getimportpropertymapper': No such file or directory Saving 1199/1199 dirty records of Mail/1OpenOffice/oolists/installation Saving 11500/11500 dirty records of Mail/1OpenOffice/oolists/api Saving 311/311 dirty records of Mail/1OpenOffice/oolists/ooxml Saving 209/209 dirty records of Mail/1OpenOffice/oolists/ucb Saving 13189/13189 dirty records of Mail/1OpenOffice/oolists/debian (evolution:9548): camel-WARNING **: Could not open converter for 'X-UNKNOWN' to 'UTF-8' charset (evolution:9548): camel-WARNING **: Could not find key entry for word 'c000000000000046': No such file or directory (evolution:9548): camel-WARNING **: Could not find key entry for word 'c000000000000046': No such file or directory Saving 1166/1166 dirty records of Mail/1OpenOffice/oolists/groupware Saving 6658/6658 dirty records of Mail/1OpenOffice/oolists/native-lang Saving 1346/1346 dirty records of Mail/1OpenOffice/oolists/udk-dev Saving 9045/9045 dirty records of Mail/1OpenOffice/oolists/releases So - what I would like to see is: a) this done in another thread - such that the progress dialog can update and re-draw while the conversion is happening. b) a better idea of the time this is going to take: we should be able to get that done at least in bytes migrated. c) better text giving some idea that this is really intended to take a long time, and people should sit tight and wait patiently. (10+ minutes already and still at 0% ;-) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=433100
Suman Manjunath
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c1
Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c2
Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c3
Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
User mmeeks@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c4
--- Comment #4 from Michael Meeks
https://bugzilla.novell.com/show_bug.cgi?id=433100
User psankar@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c5
--- Comment #5 from Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
User psankar@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c6
--- Comment #6 from Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
User psankar@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c7
--- Comment #7 from Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c8
--- Comment #8 from Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
User lakhil@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c9
--- Comment #9 from Akhil Laddha
https://bugzilla.novell.com/show_bug.cgi?id=433100
User psankar@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c10
Sankar P
Patch went smoothly for me. I tried with all three back ends (IMAP/GW/Exchange). I still get errors on terminal
Local as well I suppose ;-) It is more important as people will have years of mails in local folders.
(evolution:6857): camel-WARNING **: No summary path set. Unable to migrate
This is because this folder is never visited earlier with old version of evolution. So, no summary is created for them.
(evolution:6857): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
This looks like an issue to me. Can you see if the number of tables in your folders.db is same as the number of folders (with summary) ? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c11
--- Comment #11 from Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
User psankar@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c12
--- Comment #12 from Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
Akhil Laddha
https://bugzilla.novell.com/show_bug.cgi?id=433100
Akhil Laddha
https://bugzilla.novell.com/show_bug.cgi?id=433100
User mmeeks@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c13
Michael Meeks
https://bugzilla.novell.com/show_bug.cgi?id=433100
User mmeeks@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c14
--- Comment #14 from Michael Meeks
https://bugzilla.novell.com/show_bug.cgi?id=433100
User mmeeks@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c15
--- Comment #15 from Michael Meeks
https://bugzilla.novell.com/show_bug.cgi?id=433100
User pchenthill@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c16
Chenthill palanisamy
https://bugzilla.novell.com/show_bug.cgi?id=433100
User sragavan@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c17
--- Comment #17 from Srinivasa Ragavan V
https://bugzilla.novell.com/show_bug.cgi?id=433100
User mmeeks@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c18
--- Comment #18 from Michael Meeks
https://bugzilla.novell.com/show_bug.cgi?id=433100
User lakhil@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c19
--- Comment #19 from Akhil Laddha
https://bugzilla.novell.com/show_bug.cgi?id=433100
Sankar P
https://bugzilla.novell.com/show_bug.cgi?id=433100
User swamp@suse.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=433100#c20
Swamp Script User
participants (1)
-
bugzilla_noreply@novell.com