Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 3 mars 2013 00:28 CET, Holger Levsen hol...@layer-acht.org : Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitd iff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 seems right, yes, but it misses a pointer to instructions how to upgrade to a working installation. http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688634#99 is just a start, but at least that. I wonder if a pointer there, or somewhere better, could be added. So, here is a wiki page with a complete procedure for update. http://wiki.debian.org/Roundcube/DeprecationOfSQLitev2 I am uploading a version of Roundcube with the appropriate NEWS entry pointing to this page. -- Make it right before you make it faster. - The Elements of Programming Style (Kernighan Plauger) pgpjy8OWjT0d4.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hi Vincent, On Samstag, 16. März 2013, Vincent Bernat wrote: So, here is a wiki page with a complete procedure for update. http://wiki.debian.org/Roundcube/DeprecationOfSQLitev2 I am uploading a version of Roundcube with the appropriate NEWS entry pointing to this page. awesome, thanks a lot! (On a quick look so far only) this page looks really good! cheers, Holger -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 3 mars 2013 00:28 CET, Holger Levsen hol...@layer-acht.org : Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitd iff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 seems right, yes, but it misses a pointer to instructions how to upgrade to a working installation. http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688634#99 is just a start, but at least that. I wonder if a pointer there, or somewhere better, could be added. I will add a minimal page in wiki.debian.net with partial instructions. ETA: a few days. -- panic(aha1740.c); /* Goodbye */ 2.2.16 /usr/src/linux/drivers/scsi/aha1740.c pgpzSaox30pZ7.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 3 mars 2013 00:28 CET, Holger Levsen hol...@layer-acht.org : Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitd iff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 seems right, yes, but it misses a pointer to instructions how to upgrade to a working installation. http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688634#99 is just a start, but at least that. I wonder if a pointer there, or somewhere better, could be added. OK, I will add this. Meanwhile, I am out skiing for the week. I don't mind an NMU but if not, I will do it myself on sunday. -- Make sure every module hides something. - The Elements of Programming Style (Kernighan Plauger) pgpZ43xESAqOf.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
On Fri, Mar 1, 2013 at 16:17:34 -0800, Russ Allbery wrote: Hello folks, After reviewing the bug discussion, I believe the correct thing to do here is to remove the roundcube-sqlite package from wheezy entirely. That will block an upgrade from squeeze by forcing the admin to realize that they have to switch database backends, which is exactly the desired behavior (since there's no automated conversion process available). That's much better than a release note, since it blocks the upgrade until the admin decides what they want to do. Having a transitional package only makes sense when there is an automated transition available, and there isn't one here. The admin is going to have to take manual database actions, so we should fail the upgrade until they've done that and are prepared for the transition. Does that make sense? Do you need any help preparing that for wheezy? Sounds good to me, fwiw. Cheers, Julien signature.asc Description: Digital signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
On Samstag, 2. März 2013, Russ Allbery wrote: After reviewing the bug discussion, I believe the correct thing to do here is to remove the roundcube-sqlite package from wheezy entirely. That will block an upgrade from squeeze by forcing the admin to realize that they have to switch database backends, which is exactly the desired behavior (since there's no automated conversion process available). That's much better than a release note, since it blocks the upgrade until the admin decides what they want to do. I agree. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 2 mars 2013 01:17 CET, Russ Allbery r...@debian.org : After reviewing the bug discussion, I believe the correct thing to do here is to remove the roundcube-sqlite package from wheezy entirely. That will block an upgrade from squeeze by forcing the admin to realize that they have to switch database backends, which is exactly the desired behavior (since there's no automated conversion process available). That's much better than a release note, since it blocks the upgrade until the admin decides what they want to do. Having a transitional package only makes sense when there is an automated transition available, and there isn't one here. The admin is going to have to take manual database actions, so we should fail the upgrade until they've done that and are prepared for the transition. Does that make sense? Do you need any help preparing that for wheezy? If we agree this is the best solution (I agree too), despite the fact that the roundcube-sqlite package was introduced back because of bug #677803, I will do an upload removing it again in the next days. Thanks for your input. -- printk(HPFS: G... Kernel memory corrupted ... going on, but it'll crash very soon :-(\n); 2.4.3 linux/fs/hpfs/super.c pgpWcyfVFVQ4J.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 2 mars 2013 21:37 CET, Vincent Bernat ber...@debian.org : After reviewing the bug discussion, I believe the correct thing to do here is to remove the roundcube-sqlite package from wheezy entirely. That will block an upgrade from squeeze by forcing the admin to realize that they have to switch database backends, which is exactly the desired behavior (since there's no automated conversion process available). That's much better than a release note, since it blocks the upgrade until the admin decides what they want to do. Having a transitional package only makes sense when there is an automated transition available, and there isn't one here. The admin is going to have to take manual database actions, so we should fail the upgrade until they've done that and are prepared for the transition. Does that make sense? Do you need any help preparing that for wheezy? If we agree this is the best solution (I agree too), despite the fact that the roundcube-sqlite package was introduced back because of bug #677803, I will do an upload removing it again in the next days. Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitdiff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 -- panic(kmem_cache_init(): Offsets are wrong - I've been messed with!); 2.2.16 /usr/src/linux/mm/slab.c pgpOqN8rCHZC4.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Vincent Bernat ber...@debian.org writes: ❦ 2 mars 2013 21:37 CET, Vincent Bernat ber...@debian.org : If we agree this is the best solution (I agree too), despite the fact that the roundcube-sqlite package was introduced back because of bug #677803, I will do an upload removing it again in the next days. Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitdiff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 This looks correct to me. Thanks! In this case, #677803 is actually desired behavior. (Well, it's not *desired* in the sense that we'd prefer a transparent automatic upgrade if possible, but since we don't have one available, it's the desired behavior among the alternatives that we have.) -- Russ Allbery (r...@debian.org) http://www.eyrie.org/~eagle/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hi, On Sonntag, 3. März 2013, Russ Allbery wrote: Here is my proposition: http://anonscm.debian.org/gitweb/?p=pkg-roundcube/roundcube.git;a=commitd iff;h=15f5a10444c9d4c8bf7b3e83a82dd6f9e2a4b384 seems right, yes, but it misses a pointer to instructions how to upgrade to a working installation. http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=688634#99 is just a start, but at least that. I wonder if a pointer there, or somewhere better, could be added. cheers, Holger -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hello folks, After reviewing the bug discussion, I believe the correct thing to do here is to remove the roundcube-sqlite package from wheezy entirely. That will block an upgrade from squeeze by forcing the admin to realize that they have to switch database backends, which is exactly the desired behavior (since there's no automated conversion process available). That's much better than a release note, since it blocks the upgrade until the admin decides what they want to do. Having a transitional package only makes sense when there is an automated transition available, and there isn't one here. The admin is going to have to take manual database actions, so we should fail the upgrade until they've done that and are prepared for the transition. Does that make sense? Do you need any help preparing that for wheezy? (Of course, in an ideal world there would be an automated upgrade process, but we're too late in the release cycle to develop one now.) -- Russ Allbery (r...@debian.org) http://www.eyrie.org/~eagle/ -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
On 24/11/2012 15:03, Dominik George wrote: I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. Honestly, I think making a release note out of it is the way to go. Admins should be capable of migrating the data themselves. I installed the sqlite version of Roundcube at work because I don't understand databases (we are too small to employ a sysadmin, and if we did we would probably end up with a Windows server). At the rate things are going my (20) users are going to lose data and I wish I had installed Squirrelmail as I did at home. Roger -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
I installed the sqlite version of Roundcube at work because I don't understand databases (we are too small to employ a sysadmin, and if we did we would probably end up with a Windows server). At the rate things are going my (20) users are going to lose data and I wish I had installed Squirrelmail as I did at home. You could ask for help on one of the forums or mailing lists. Dumping SQLite and inserting into MySQL is trivial, so you should be going within no time. Again, the BTS is for reporting technical issues, not a support forum. -nik -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hi Holger, I stumbled upon this bug report at BSP Essen today and kindy wanted to ask you for a follow-up on the issue. If you do not have the time to provide a reasonable solution yourself, feel free to explain your thought on it here and I will look to fix the issue! Cheers, Nik -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 24 novembre 2012 15:13 CET, Dominik George n...@naturalnet.de : I stumbled upon this bug report at BSP Essen today and kindy wanted to ask you for a follow-up on the issue. If you do not have the time to provide a reasonable solution yourself, feel free to explain your thought on it here and I will look to fix the issue! The perfect solution would be a script to migrate from sqlite to MySQL (or PostgreSQL). It does not have to do the actuel migration, just to eat an sqldump from SQLite and turn it into a dump that could be used by MySQL. -- /* Identify the flock of penguins. */ 2.2.16 /usr/src/linux/arch/alpha/kernel/setup.c pgpGieCoOcy5f.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hi, The perfect solution would be a script to migrate from sqlite to MySQL (or PostgreSQL). It does not have to do the actuel migration, just to eat an sqldump from SQLite and turn it into a dump that could be used by MySQL. So you do not actually plan to have this script run automatically? I think, as I want to keep the most magical things out for now as it would make the unblock process more difficult, that the preinst script should actually only dump the database to /var/backups, just as slapd does for LDAP when upgrading the package. How about that? -nik -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 24 novembre 2012 15:34 CET, Dominik George n...@naturalnet.de : The perfect solution would be a script to migrate from sqlite to MySQL (or PostgreSQL). It does not have to do the actuel migration, just to eat an sqldump from SQLite and turn it into a dump that could be used by MySQL. So you do not actually plan to have this script run automatically? No, that would be too much difficult since we are using dbconfig-common. I think, as I want to keep the most magical things out for now as it would make the unblock process more difficult, that the preinst script should actually only dump the database to /var/backups, just as slapd does for LDAP when upgrading the package. Actually, upgrading from a version supporting sqlite to a version not supporting sqlite leaves the sqlite database untouched. There is no real data-loss. The data is still here but not usable anymore. We can of course backup the database in /var/backups but that won't change the situation of the user. I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. -- Don't sacrifice clarity for small gains in efficiency. - The Elements of Programming Style (Kernighan Plauger) pgpERx14hIJ9k.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. Honestly, I think making a release note out of it is the way to go. Admins should be capable of migrating the data themselves. Instructions on how to do that are best kept in the Roundcube wiki, not in Debian. -nik -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
Hi, On Samstag, 24. November 2012, Vincent Bernat wrote: Actually, upgrading from a version supporting sqlite to a version not supporting sqlite leaves the sqlite database untouched. thankfully, yes. (Happened to me recently and I was happy I had not go to backups to get roundcube back...) I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. I'm not sure how to not read this as: small installations don't matter :-( Somewhere there must be a script or at least a howto?! cheers, Holger -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 24 novembre 2012 16:03 CET, Dominik George n...@naturalnet.de : I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. Honestly, I think making a release note out of it is the way to go. Admins should be capable of migrating the data themselves. Instructions on how to do that are best kept in the Roundcube wiki, not in Debian. I agree with you. Unless someone comes with some script or instructions, I will write something for the release notes. I am just waiting a bit to let a change for someone to come with a fix. I think I will take action at mid-december. -- Make sure every module hides something. - The Elements of Programming Style (Kernighan Plauger) pgpYoaAFYL21o.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 24 novembre 2012 16:07 CET, Holger Levsen hol...@layer-acht.org : I have asked people that did successfuly upgrade real sqlite databse to MySQL if they could provide directions or a script but they don't remember how they did it exactly. If nobody can come up with a script, we will just have to put a note in the release notes about this. I personnaly don't think that there are large installations using SQLite databases. I'm not sure how to not read this as: small installations don't matter :-( Well, I think that there are many installation where there is only one user with no address book. So, it is just as easy to start from scratch. But I don't have any number to backup this claim. Let's just say that I didn't say anything about small installations. Somewhere there must be a script or at least a howto?! I just searched again and didn't find anything about this. -- panic(Fod fight!); 2.2.16 /usr/src/linux/drivers/scsi/aha1542.c pgp4VkH9SajhB.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
❦ 24 septembre 2012 12:43 CEST, Holger Levsen hol...@layer-acht.org : There is a debian/roundcube-sqlite.NEWS stating this, but I dont think this is enough. At the very least this must be mentioned in the release notes... (upgrade instructions would be better, automatic upgrades the best.) I have asked two users if they could provide instructions or directions about this. I wait a bit to get an answer for them before doing anything else. -- Parenthesise to avoid ambiguity. - The Elements of Programming Style (Kernighan Plauger) pgpGbh3pGZz65.pgp Description: PGP signature
Bug#688634: roundcube-sqlite upgrade causes serious data-loss
package: roundcube-sqlite version: 0.7.2-4 severity: critical Hi, roundcube-sqlite 0.7.2-4 is a transitional package depending on roundcube- mysql or -pysql, but without an actual upgrade path, leading to serious data loss, eg. user mail stati, user settings and also stuff like addressbook contents. There is a debian/roundcube-sqlite.NEWS stating this, but I dont think this is enough. At the very least this must be mentioned in the release notes... (upgrade instructions would be better, automatic upgrades the best.) #659041 Add SQLite 3.x support links to http://trac.roundcube.net/ticket/1488332, which claims sqlite3 support has been added to the 0.9 branch, but I don't think it's helpful for wheezy. cheers, Holger -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org