* [gentoo-user] akonadi ... don't you just love it? @ 2014-08-09 20:00 Mick 2014-08-10 9:34 ` J. Roeleveld ` (2 more replies) 0 siblings, 3 replies; 29+ messages in thread From: Mick @ 2014-08-09 20:00 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: Text/Plain, Size: 2860 bytes --] First some general observations that relate to kmail2: I thought of giving the latest kmail-4.12.5 a spin. So installed it on a machine and set up a couple of IMAP4 servers to get messages from. An account with a messages in the low hundreds works fine. An account with messages in the 100k plus range works like a dog. While kmail fetches headers and then akonadi sets off to organise threads and whatever else it wants to do the application becomes pretty much unresponsive and the CPU climbs up to 98%. Half an hour later I can get back to it. :-@ Anyway, this is not the current problem. I updated mysql to 5.5.39, then I kmail would not start with akonadi failing with "mysql log containing errors". So I ran: mysql_upgrade --socket=/tmp/akonadi-michael.NFvLpB/mysql.socket which completed without an error. Kmail still failed to start. Trying to start akonadi console states: "Failed to connect to database. Driver not loaded" Then the pop up Details window says MySQL log contains errors, just like when I try to start kmail. This is what I see in .local/share/akonadi/db_data/mysql.err: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140809 20:58:42 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140809 20:58:42 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html 140809 20:58:42 InnoDB: Could not open or create data files. 140809 20:58:42 InnoDB: If you tried to add new data files, and it failed here, 140809 20:58:42 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140809 20:58:42 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140809 20:58:42 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140809 20:58:42 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140809 20:58:42 InnoDB: remove old data files which contain your precious data! 140809 20:58:42 [ERROR] Plugin 'InnoDB' init function returned error. 140809 20:58:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140809 20:58:42 [ERROR] Unknown/unsupported storage engine: innodb 140809 20:58:42 [ERROR] Aborting So I moved ./ibdata* and tried again with the same error. Is there something else I should be doing here to get this going? -- Regards, Mick [-- Attachment #2: This is a digitally signed message part. --] [-- Type: application/pgp-signature, Size: 473 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-09 20:00 [gentoo-user] akonadi ... don't you just love it? Mick @ 2014-08-10 9:34 ` J. Roeleveld 2014-08-12 7:05 ` Mick 2014-08-11 18:01 ` Volker Armin Hemmann 2014-08-11 19:05 ` [gentoo-user] " Mick 2 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-10 9:34 UTC (permalink / raw To: gentoo-user On Saturday, August 09, 2014 09:00:48 PM Mick wrote: > First some general observations that relate to kmail2: > > I thought of giving the latest kmail-4.12.5 a spin. So installed it on a > machine and set up a couple of IMAP4 servers to get messages from. An > account with a messages in the low hundreds works fine. An account with > messages in the 100k plus range works like a dog. While kmail fetches > headers and then akonadi sets off to organise threads and whatever else it > wants to do the application becomes pretty much unresponsive and the CPU > climbs up to 98%. Half an hour later I can get back to it. :-@ > > Anyway, this is not the current problem. I updated mysql to 5.5.39, then I > kmail would not start with akonadi failing with "mysql log containing > errors". So I ran: <snipped> Why do you run unstable mysql with stable kmail? -- Joost ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-10 9:34 ` J. Roeleveld @ 2014-08-12 7:05 ` Mick 0 siblings, 0 replies; 29+ messages in thread From: Mick @ 2014-08-12 7:05 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: Text/Plain, Size: 1023 bytes --] On Sunday 10 Aug 2014 10:34:44 J. Roeleveld wrote: > On Saturday, August 09, 2014 09:00:48 PM Mick wrote: > > First some general observations that relate to kmail2: > > > > I thought of giving the latest kmail-4.12.5 a spin. So installed it on a > > machine and set up a couple of IMAP4 servers to get messages from. An > > account with a messages in the low hundreds works fine. An account with > > messages in the 100k plus range works like a dog. While kmail fetches > > headers and then akonadi sets off to organise threads and whatever else > > it wants to do the application becomes pretty much unresponsive and the > > CPU climbs up to 98%. Half an hour later I can get back to it. :-@ > > > > Anyway, this is not the current problem. I updated mysql to 5.5.39, then > > I kmail would not start with akonadi failing with "mysql log containing > > > errors". So I ran: > <snipped> > > Why do you run unstable mysql with stable kmail? mysql-5.5.39 is stable now. -- Regards, Mick [-- Attachment #2: This is a digitally signed message part. --] [-- Type: application/pgp-signature, Size: 473 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-09 20:00 [gentoo-user] akonadi ... don't you just love it? Mick 2014-08-10 9:34 ` J. Roeleveld @ 2014-08-11 18:01 ` Volker Armin Hemmann 2014-08-11 21:45 ` Mick 2014-08-11 19:05 ` [gentoo-user] " Mick 2 siblings, 1 reply; 29+ messages in thread From: Volker Armin Hemmann @ 2014-08-11 18:01 UTC (permalink / raw To: gentoo-user Am 09.08.2014 um 22:00 schrieb Mick: > First some general observations that relate to kmail2: > > I thought of giving the latest kmail-4.12.5 a spin. So installed it on a > machine and set up a couple of IMAP4 servers to get messages from. An account > with a messages in the low hundreds works fine. An account with messages in > the 100k plus range works like a dog. While kmail fetches headers and then > akonadi sets off to organise threads and whatever else it wants to do the > application becomes pretty much unresponsive and the CPU climbs up to 98%. > Half an hour later I can get back to it. :-@ > > Anyway, this is not the current problem. I updated mysql to 5.5.39, then I > kmail would not start with akonadi failing with "mysql log containing errors". > So I ran: > > mysql_upgrade --socket=/tmp/akonadi-michael.NFvLpB/mysql.socket > > which completed without an error. Kmail still failed to start. Trying to > start akonadi console states: > > "Failed to connect to database. Driver not loaded" > > Then the pop up Details window says MySQL log contains errors, just like when > I try to start kmail. This is what I see in > .local/share/akonadi/db_data/mysql.err: > > InnoDB: Unable to lock ./ibdata1, error: 11 > InnoDB: Check that you do not already have another mysqld process > InnoDB: using the same InnoDB data or log files. > InnoDB: Unable to lock ./ibdata1, error: 11 > InnoDB: Check that you do not already have another mysqld process > InnoDB: using the same InnoDB data or log files. > 140809 20:58:42 InnoDB: Unable to open the first data file > InnoDB: Error in opening ./ibdata1 > 140809 20:58:42 InnoDB: Operating system error number 11 in a file operation. > InnoDB: Error number 11 means 'Resource temporarily unavailable'. > InnoDB: Some operating system error numbers are described at > InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html > 140809 20:58:42 InnoDB: Could not open or create data files. > 140809 20:58:42 InnoDB: If you tried to add new data files, and it failed > here, > 140809 20:58:42 InnoDB: you should now edit innodb_data_file_path in my.cnf > back > 140809 20:58:42 InnoDB: to what it was, and remove the new ibdata files InnoDB > created > 140809 20:58:42 InnoDB: in this failed attempt. InnoDB only wrote those files > full of > 140809 20:58:42 InnoDB: zeros, but did not yet use them in any way. But be > careful: do not > 140809 20:58:42 InnoDB: remove old data files which contain your precious > data! > 140809 20:58:42 [ERROR] Plugin 'InnoDB' init function returned error. > 140809 20:58:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE > failed. > 140809 20:58:42 [ERROR] Unknown/unsupported storage engine: innodb > 140809 20:58:42 [ERROR] Aborting > > > So I moved ./ibdata* and tried again with the same error. Is there something > else I should be doing here to get this going? > isn't it great? back in the days when kmail stored emails in files, everything worked great and even folders with 100k mails were not a problem. But, no, they had to break that. I lost ca 500k emails thanks to akonadi-crap and errors like that. I really loved kmail and thunderbird is garbage compared - but akonadi took away that choice. Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-11 18:01 ` Volker Armin Hemmann @ 2014-08-11 21:45 ` Mick 2014-08-12 5:36 ` J. Roeleveld 0 siblings, 1 reply; 29+ messages in thread From: Mick @ 2014-08-11 21:45 UTC (permalink / raw To: gentoo-user On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote: > isn't it great? back in the days when kmail stored emails in files, > everything worked great and even folders with 100k mails were not a problem. > > But, no, they had to break that. > > I lost ca 500k emails thanks to akonadi-crap and errors like that. I > really loved kmail and thunderbird is garbage compared - but akonadi > took away that choice. > > Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* I share your feelings although I haven't lost messages in my current attempt to road test kmail2. I am dreading the moment when kmail1 will stop working due to bitrot and I'll have to make a choice. :-( -- Regards, Mick ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-11 21:45 ` Mick @ 2014-08-12 5:36 ` J. Roeleveld 2014-08-12 6:42 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-12 5:36 UTC (permalink / raw To: gentoo-user On Monday, August 11, 2014 10:45:07 PM Mick wrote: > On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote: > > isn't it great? back in the days when kmail stored emails in files, > > everything worked great and even folders with 100k mails were not a > > problem. > > > > But, no, they had to break that. > > > > I lost ca 500k emails thanks to akonadi-crap and errors like that. I > > really loved kmail and thunderbird is garbage compared - but akonadi > > took away that choice. > > > > Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* > > I share your feelings although I haven't lost messages in my current attempt > to road test kmail2. I am dreading the moment when kmail1 will stop > working due to bitrot and I'll have to make a choice. :-( With a modern machine and the latest versions, it's not too bad and responds quicker then kmail-1 did. With the old version, I often had kmail become unresponsive when synchronizing the email. I didn't loose any emails, but that is more likely related to the emails being stored on an imap server, rather then being lucky. I really don't see the point of forcing mysql as a backend. Sqlite would have been a better choice. -- Joost ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 5:36 ` J. Roeleveld @ 2014-08-12 6:42 ` Alan McKinnon 2014-08-12 9:10 ` Mick 0 siblings, 1 reply; 29+ messages in thread From: Alan McKinnon @ 2014-08-12 6:42 UTC (permalink / raw To: gentoo-user On 12/08/2014 07:36, J. Roeleveld wrote: > On Monday, August 11, 2014 10:45:07 PM Mick wrote: >> On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote: >>> isn't it great? back in the days when kmail stored emails in files, >>> everything worked great and even folders with 100k mails were not a >>> problem. >>> >>> But, no, they had to break that. >>> >>> I lost ca 500k emails thanks to akonadi-crap and errors like that. I >>> really loved kmail and thunderbird is garbage compared - but akonadi >>> took away that choice. >>> >>> Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* >> >> I share your feelings although I haven't lost messages in my current attempt >> to road test kmail2. I am dreading the moment when kmail1 will stop >> working due to bitrot and I'll have to make a choice. :-( > > With a modern machine and the latest versions, it's not too bad and responds > quicker then kmail-1 did. With the old version, I often had kmail become > unresponsive when synchronizing the email. > > I didn't loose any emails, but that is more likely related to the emails being > stored on an imap server, rather then being lucky. > > I really don't see the point of forcing mysql as a backend. Sqlite would have > been a better choice. Way back when in the dark days of KDE-4.4 or thereabouts, the KDE devs did do extensive tests with mysql vs sqlite and found sqlite lacking in horsepower. Remember that it must store the metadata for all your mails and some of us have lots of mail. IIRC there was also serious contention issues with multiple threads. sqlite is an amazing little product, but it does have it's limits. It performs really well as an embedded datastore to replace flat file storage with an SQL interface, and my gut-feel evaluation is that it runs out of steam at similar orders of magnitude of data. Amarok incidentally has almost exactly the same issues and the same solution was adopted -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 6:42 ` Alan McKinnon @ 2014-08-12 9:10 ` Mick 2014-08-12 12:06 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: Mick @ 2014-08-12 9:10 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: Text/Plain, Size: 2568 bytes --] On Tuesday 12 Aug 2014 07:42:46 Alan McKinnon wrote: > On 12/08/2014 07:36, J. Roeleveld wrote: > > On Monday, August 11, 2014 10:45:07 PM Mick wrote: > >> On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote: > >>> isn't it great? back in the days when kmail stored emails in files, > >>> everything worked great and even folders with 100k mails were not a > >>> problem. > >>> > >>> But, no, they had to break that. > >>> > >>> I lost ca 500k emails thanks to akonadi-crap and errors like that. I > >>> really loved kmail and thunderbird is garbage compared - but akonadi > >>> took away that choice. > >>> > >>> Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* > >> > >> I share your feelings although I haven't lost messages in my current > >> attempt to road test kmail2. I am dreading the moment when kmail1 will > >> stop working due to bitrot and I'll have to make a choice. :-( > > > > With a modern machine and the latest versions, it's not too bad and > > responds quicker then kmail-1 did. With the old version, I often had > > kmail become unresponsive when synchronizing the email. > > > > I didn't loose any emails, but that is more likely related to the emails > > being stored on an imap server, rather then being lucky. > > > > I really don't see the point of forcing mysql as a backend. Sqlite would > > have been a better choice. > > Way back when in the dark days of KDE-4.4 or thereabouts, the KDE devs > did do extensive tests with mysql vs sqlite and found sqlite lacking in > horsepower. Remember that it must store the metadata for all your mails > and some of us have lots of mail. IIRC there was also serious contention > issues with multiple threads. > > sqlite is an amazing little product, but it does have it's limits. It > performs really well as an embedded datastore to replace flat file > storage with an SQL interface, and my gut-feel evaluation is that it > runs out of steam at similar orders of magnitude of data. > > Amarok incidentally has almost exactly the same issues and the same > solution was adopted Only to add that it's more than just mail. It is the meta/data of the whole caboodle of the PIM suite of applications. I recall the devs explicitly stating early enough in the KDE4 development that sqlite is not man enough for the job and advising everyone to move over to mysql. Someone was looking at postgresql as an alternative to mysql, but I'm not sure that this would bring any benefit. -- Regards, Mick [-- Attachment #2: This is a digitally signed message part. --] [-- Type: application/pgp-signature, Size: 473 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 9:10 ` Mick @ 2014-08-12 12:06 ` Alan McKinnon 2014-08-12 13:28 ` J. Roeleveld 0 siblings, 1 reply; 29+ messages in thread From: Alan McKinnon @ 2014-08-12 12:06 UTC (permalink / raw To: gentoo-user On 12/08/2014 11:10, Mick wrote: > I recall the devs explicitly stating early enough in the KDE4 development that > sqlite is not man enough for the job and advising everyone to move over to > mysql. > > Someone was looking at postgresql as an alternative to mysql, but I'm not sure > that this would bring any benefit. pg is a fine database, but for this use will always be a 2nd class citizen. Most users will already have mysql installed, or will be willing to install it. The number of folks with pg and without mysql will probably be small -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 12:06 ` Alan McKinnon @ 2014-08-12 13:28 ` J. Roeleveld 2014-08-12 13:38 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-12 13:28 UTC (permalink / raw To: gentoo-user On 12 August 2014 14:06:07 CEST, Alan McKinnon <alan.mckinnon@gmail.com> wrote: >On 12/08/2014 11:10, Mick wrote: >> I recall the devs explicitly stating early enough in the KDE4 >development that >> sqlite is not man enough for the job and advising everyone to move >over to >> mysql. >> >> Someone was looking at postgresql as an alternative to mysql, but I'm >not sure >> that this would bring any benefit. > > >pg is a fine database, but for this use will always be a 2nd class >citizen. Most users will already have mysql installed, or will be >willing to install it. > >The number of folks with pg and without mysql will probably be small Not necessarily. People who care about databases actually supporting SQL properly and performing properly will prefer PostgreSQL. I don't like to be forced to run a MySQL instance as well. It's often the laziness of developers that causes the difficulty of supporting a different database when they started with MySQL. If you start with a different one, like PostgrSQL, supporting different database engines is very simple. -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 13:28 ` J. Roeleveld @ 2014-08-12 13:38 ` Alan McKinnon 2014-08-12 14:10 ` J. Roeleveld 0 siblings, 1 reply; 29+ messages in thread From: Alan McKinnon @ 2014-08-12 13:38 UTC (permalink / raw To: gentoo-user On 12/08/2014 15:28, J. Roeleveld wrote: > On 12 August 2014 14:06:07 CEST, Alan McKinnon <alan.mckinnon@gmail.com> wrote: >> On 12/08/2014 11:10, Mick wrote: >>> I recall the devs explicitly stating early enough in the KDE4 >> development that >>> sqlite is not man enough for the job and advising everyone to move >> over to >>> mysql. >>> >>> Someone was looking at postgresql as an alternative to mysql, but I'm >> not sure >>> that this would bring any benefit. >> >> >> pg is a fine database, but for this use will always be a 2nd class >> citizen. Most users will already have mysql installed, or will be >> willing to install it. >> >> The number of folks with pg and without mysql will probably be small > > Not necessarily. > People who care about databases actually supporting SQL properly and performing properly will prefer PostgreSQL. > > I don't like to be forced to run a MySQL instance as well. It's often the laziness of developers that causes the difficulty of supporting a different database when they started with MySQL. > If you start with a different one, like PostgrSQL, supporting different database engines is very simple. I don't think you read what I said. I didn't say postgresql shouldn't be supported, I said it would always end up being a second class citizen as the number of people who'd be happy with mysql will vastly outnumber the number of people who highly desire postgresql. So, logically, a postgresql driver in this case will probably just bitrot away. Whihc nicely explains the likely reason why that driver is not there. People like yourself who care about databases are very much in the minority of users, even on Linux. Most users across the boards just don't give a shit. Them's the breaks. -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 13:38 ` Alan McKinnon @ 2014-08-12 14:10 ` J. Roeleveld 2014-08-12 18:21 ` Volker Armin Hemmann 0 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-12 14:10 UTC (permalink / raw To: gentoo-user On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: > On 12/08/2014 15:28, J. Roeleveld wrote: > > On 12 August 2014 14:06:07 CEST, Alan McKinnon <alan.mckinnon@gmail.com> wrote: > >> On 12/08/2014 11:10, Mick wrote: > >>> I recall the devs explicitly stating early enough in the KDE4 > >> > >> development that > >> > >>> sqlite is not man enough for the job and advising everyone to move > >> > >> over to > >> > >>> mysql. > >>> > >>> Someone was looking at postgresql as an alternative to mysql, but I'm > >> > >> not sure > >> > >>> that this would bring any benefit. > >> > >> pg is a fine database, but for this use will always be a 2nd class > >> citizen. Most users will already have mysql installed, or will be > >> willing to install it. > >> > >> The number of folks with pg and without mysql will probably be small > > > > Not necessarily. > > People who care about databases actually supporting SQL properly and > > performing properly will prefer PostgreSQL. > > > > I don't like to be forced to run a MySQL instance as well. It's often the > > laziness of developers that causes the difficulty of supporting a > > different database when they started with MySQL. If you start with a > > different one, like PostgrSQL, supporting different database engines is > > very simple. > > I don't think you read what I said. Sorry, didn't read the below in what you put. > I didn't say postgresql shouldn't be supported, I said it would always > end up being a second class citizen as the number of people who'd be > happy with mysql will vastly outnumber the number of people who highly > desire postgresql. So, logically, a postgresql driver in this case will > probably just bitrot away. Whihc nicely explains the likely reason why > that driver is not there. It wouldn't bitrot away as there would be people willing to keep it working, provided it wouldn't require a MySQL -> SQL translator to be kept up-to-date. > People like yourself who care about databases are very much in the > minority of users, even on Linux. Most users across the boards just > don't give a shit. Them's the breaks. Users never care about what they install. I just wish the majority of developers would actually be willing to follow some simple guidelines to make it actually possible to others to write and maintain the drivers to connect to different databases. Several attempts have been made by people to add support for different databases to various projects. I've tried to do it myself on occasion, but even when patches are accepted by upstream, they get broken by upstream at a future release again because of the bad design that is often employed by lazy developers. -- Joost ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 14:10 ` J. Roeleveld @ 2014-08-12 18:21 ` Volker Armin Hemmann 2014-08-12 19:00 ` J. Roeleveld 0 siblings, 1 reply; 29+ messages in thread From: Volker Armin Hemmann @ 2014-08-12 18:21 UTC (permalink / raw To: gentoo-user Am 12.08.2014 um 16:10 schrieb J. Roeleveld: > On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: >> On 12/08/2014 15:28, J. Roeleveld wrote: >>> On 12 August 2014 14:06:07 CEST, Alan McKinnon <alan.mckinnon@gmail.com> > wrote: >>>> On 12/08/2014 11:10, Mick wrote: >>>>> I recall the devs explicitly stating early enough in the KDE4 >>>> development that >>>> >>>>> sqlite is not man enough for the job and advising everyone to move >>>> over to >>>> >>>>> mysql. >>>>> >>>>> Someone was looking at postgresql as an alternative to mysql, but I'm >>>> not sure >>>> >>>>> that this would bring any benefit. >>>> pg is a fine database, but for this use will always be a 2nd class >>>> citizen. Most users will already have mysql installed, or will be >>>> willing to install it. >>>> >>>> The number of folks with pg and without mysql will probably be small >>> Not necessarily. >>> People who care about databases actually supporting SQL properly and >>> performing properly will prefer PostgreSQL. >>> >>> I don't like to be forced to run a MySQL instance as well. It's often the >>> laziness of developers that causes the difficulty of supporting a >>> different database when they started with MySQL. If you start with a >>> different one, like PostgrSQL, supporting different database engines is >>> very simple. >> I don't think you read what I said. > Sorry, didn't read the below in what you put. > >> I didn't say postgresql shouldn't be supported, I said it would always >> end up being a second class citizen as the number of people who'd be >> happy with mysql will vastly outnumber the number of people who highly >> desire postgresql. So, logically, a postgresql driver in this case will >> probably just bitrot away. Whihc nicely explains the likely reason why >> that driver is not there. > It wouldn't bitrot away as there would be people willing to keep it working, > provided it wouldn't require a MySQL -> SQL translator to be kept up-to-date. > >> People like yourself who care about databases are very much in the >> minority of users, even on Linux. Most users across the boards just >> don't give a shit. Them's the breaks. > Users never care about what they install. I just wish the majority of > developers would actually be willing to follow some simple guidelines to make > it actually possible to others to write and maintain the drivers to connect to > different databases. > > Several attempts have been made by people to add support for different > databases to various projects. I've tried to do it myself on occasion, but > even when patches are accepted by upstream, they get broken by upstream at a > future release again because of the bad design that is often employed by lazy > developers. > > -- > Joost > > wasn't qtsql once supposed to that? ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 18:21 ` Volker Armin Hemmann @ 2014-08-12 19:00 ` J. Roeleveld 2014-08-12 19:20 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-12 19:00 UTC (permalink / raw To: gentoo-user On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann <volkerarmin@googlemail.com> wrote: >Am 12.08.2014 um 16:10 schrieb J. Roeleveld: >> On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: >>> On 12/08/2014 15:28, J. Roeleveld wrote: >>>> On 12 August 2014 14:06:07 CEST, Alan McKinnon ><alan.mckinnon@gmail.com> >> wrote: >>>>> On 12/08/2014 11:10, Mick wrote: >>>>>> I recall the devs explicitly stating early enough in the KDE4 >>>>> development that >>>>> >>>>>> sqlite is not man enough for the job and advising everyone to >move >>>>> over to >>>>> >>>>>> mysql. >>>>>> >>>>>> Someone was looking at postgresql as an alternative to mysql, but >I'm >>>>> not sure >>>>> >>>>>> that this would bring any benefit. >>>>> pg is a fine database, but for this use will always be a 2nd class >>>>> citizen. Most users will already have mysql installed, or will be >>>>> willing to install it. >>>>> >>>>> The number of folks with pg and without mysql will probably be >small >>>> Not necessarily. >>>> People who care about databases actually supporting SQL properly >and >>>> performing properly will prefer PostgreSQL. >>>> >>>> I don't like to be forced to run a MySQL instance as well. It's >often the >>>> laziness of developers that causes the difficulty of supporting a >>>> different database when they started with MySQL. If you start with >a >>>> different one, like PostgrSQL, supporting different database >engines is >>>> very simple. >>> I don't think you read what I said. >> Sorry, didn't read the below in what you put. >> >>> I didn't say postgresql shouldn't be supported, I said it would >always >>> end up being a second class citizen as the number of people who'd be >>> happy with mysql will vastly outnumber the number of people who >highly >>> desire postgresql. So, logically, a postgresql driver in this case >will >>> probably just bitrot away. Whihc nicely explains the likely reason >why >>> that driver is not there. >> It wouldn't bitrot away as there would be people willing to keep it >working, >> provided it wouldn't require a MySQL -> SQL translator to be kept >up-to-date. >> >>> People like yourself who care about databases are very much in the >>> minority of users, even on Linux. Most users across the boards just >>> don't give a shit. Them's the breaks. >> Users never care about what they install. I just wish the majority of > >> developers would actually be willing to follow some simple guidelines >to make >> it actually possible to others to write and maintain the drivers to >connect to >> different databases. >> >> Several attempts have been made by people to add support for >different >> databases to various projects. I've tried to do it myself on >occasion, but >> even when patches are accepted by upstream, they get broken by >upstream at a >> future release again because of the bad design that is often employed >by lazy >> developers. >> >> -- >> Joost >> >> >wasn't qtsql once supposed to that? If a framework like qtsql is used, swapping the database is easy. Most developers seem to prefer to reinvent the wheel and often come up with something that vaguely resembles a circle and is held together with a mixture of glue and duck tape. -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 19:00 ` J. Roeleveld @ 2014-08-12 19:20 ` Alan McKinnon 2014-08-13 6:38 ` J. Roeleveld 0 siblings, 1 reply; 29+ messages in thread From: Alan McKinnon @ 2014-08-12 19:20 UTC (permalink / raw To: gentoo-user On 12/08/2014 21:00, J. Roeleveld wrote: > On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann <volkerarmin@googlemail.com> wrote: >> Am 12.08.2014 um 16:10 schrieb J. Roeleveld: >>> On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: >>>> On 12/08/2014 15:28, J. Roeleveld wrote: >>>>> On 12 August 2014 14:06:07 CEST, Alan McKinnon >> <alan.mckinnon@gmail.com> >>> wrote: >>>>>> On 12/08/2014 11:10, Mick wrote: >>>>>>> I recall the devs explicitly stating early enough in the KDE4 >>>>>> development that >>>>>> >>>>>>> sqlite is not man enough for the job and advising everyone to >> move >>>>>> over to >>>>>> >>>>>>> mysql. >>>>>>> >>>>>>> Someone was looking at postgresql as an alternative to mysql, but >> I'm >>>>>> not sure >>>>>> >>>>>>> that this would bring any benefit. >>>>>> pg is a fine database, but for this use will always be a 2nd class >>>>>> citizen. Most users will already have mysql installed, or will be >>>>>> willing to install it. >>>>>> >>>>>> The number of folks with pg and without mysql will probably be >> small >>>>> Not necessarily. >>>>> People who care about databases actually supporting SQL properly >> and >>>>> performing properly will prefer PostgreSQL. >>>>> >>>>> I don't like to be forced to run a MySQL instance as well. It's >> often the >>>>> laziness of developers that causes the difficulty of supporting a >>>>> different database when they started with MySQL. If you start with >> a >>>>> different one, like PostgrSQL, supporting different database >> engines is >>>>> very simple. >>>> I don't think you read what I said. >>> Sorry, didn't read the below in what you put. >>> >>>> I didn't say postgresql shouldn't be supported, I said it would >> always >>>> end up being a second class citizen as the number of people who'd be >>>> happy with mysql will vastly outnumber the number of people who >> highly >>>> desire postgresql. So, logically, a postgresql driver in this case >> will >>>> probably just bitrot away. Whihc nicely explains the likely reason >> why >>>> that driver is not there. >>> It wouldn't bitrot away as there would be people willing to keep it >> working, >>> provided it wouldn't require a MySQL -> SQL translator to be kept >> up-to-date. >>> >>>> People like yourself who care about databases are very much in the >>>> minority of users, even on Linux. Most users across the boards just >>>> don't give a shit. Them's the breaks. >>> Users never care about what they install. I just wish the majority of >> >>> developers would actually be willing to follow some simple guidelines >> to make >>> it actually possible to others to write and maintain the drivers to >> connect to >>> different databases. >>> >>> Several attempts have been made by people to add support for >> different >>> databases to various projects. I've tried to do it myself on >> occasion, but >>> even when patches are accepted by upstream, they get broken by >> upstream at a >>> future release again because of the bad design that is often employed >> by lazy >>> developers. >>> >>> -- >>> Joost >>> >>> >> wasn't qtsql once supposed to that? > > If a framework like qtsql is used, swapping the database is easy. > > Most developers seem to prefer to reinvent the wheel and often come up with something that vaguely resembles a circle and is held together with a mixture of glue and duck tape. I blame php and others of it's ilk. The good thing about php is that everyone and their dog can knock out running code. The bad thing about php is that they do. Substitute mysql and bash if you will and tweak the content to suit - it all works out the same. Sensible languages (like, oh I dunno - python maybe?) have this trick about them - you have to work hard to write awful code. You also have to work hard to write awesome code, but if you just follow the book you usually end up with acceptable code. I will refrain from commenting on perl. -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-12 19:20 ` Alan McKinnon @ 2014-08-13 6:38 ` J. Roeleveld 2014-08-13 7:10 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: J. Roeleveld @ 2014-08-13 6:38 UTC (permalink / raw To: gentoo-user On Tuesday, August 12, 2014 09:20:59 PM Alan McKinnon wrote: > On 12/08/2014 21:00, J. Roeleveld wrote: > > On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann <volkerarmin@googlemail.com> wrote: > >> Am 12.08.2014 um 16:10 schrieb J. Roeleveld: > >>> On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote: > >>>> On 12/08/2014 15:28, J. Roeleveld wrote: > >>>>> On 12 August 2014 14:06:07 CEST, Alan McKinnon > >> > >> <alan.mckinnon@gmail.com> > >> > >>> wrote: > >>>>>> On 12/08/2014 11:10, Mick wrote: > >>>>>>> I recall the devs explicitly stating early enough in the KDE4 > >>>>>> > >>>>>> development that > >>>>>> > >>>>>>> sqlite is not man enough for the job and advising everyone to > >> > >> move > >> > >>>>>> over to > >>>>>> > >>>>>>> mysql. > >>>>>>> > >>>>>>> Someone was looking at postgresql as an alternative to mysql, but > >> > >> I'm > >> > >>>>>> not sure > >>>>>> > >>>>>>> that this would bring any benefit. > >>>>>> > >>>>>> pg is a fine database, but for this use will always be a 2nd class > >>>>>> citizen. Most users will already have mysql installed, or will be > >>>>>> willing to install it. > >>>>>> > >>>>>> The number of folks with pg and without mysql will probably be > >> > >> small > >> > >>>>> Not necessarily. > >>>>> People who care about databases actually supporting SQL properly > >> > >> and > >> > >>>>> performing properly will prefer PostgreSQL. > >>>>> > >>>>> I don't like to be forced to run a MySQL instance as well. It's > >> > >> often the > >> > >>>>> laziness of developers that causes the difficulty of supporting a > >>>>> different database when they started with MySQL. If you start with > >> > >> a > >> > >>>>> different one, like PostgrSQL, supporting different database > >> > >> engines is > >> > >>>>> very simple. > >>>> > >>>> I don't think you read what I said. > >>> > >>> Sorry, didn't read the below in what you put. > >>> > >>>> I didn't say postgresql shouldn't be supported, I said it would > >> > >> always > >> > >>>> end up being a second class citizen as the number of people who'd be > >>>> happy with mysql will vastly outnumber the number of people who > >> > >> highly > >> > >>>> desire postgresql. So, logically, a postgresql driver in this case > >> > >> will > >> > >>>> probably just bitrot away. Whihc nicely explains the likely reason > >> > >> why > >> > >>>> that driver is not there. > >>> > >>> It wouldn't bitrot away as there would be people willing to keep it > >> > >> working, > >> > >>> provided it wouldn't require a MySQL -> SQL translator to be kept > >> > >> up-to-date. > >> > >>>> People like yourself who care about databases are very much in the > >>>> minority of users, even on Linux. Most users across the boards just > >>>> don't give a shit. Them's the breaks. > >>> > >>> Users never care about what they install. I just wish the majority of > >>> > >>> developers would actually be willing to follow some simple guidelines > >> > >> to make > >> > >>> it actually possible to others to write and maintain the drivers to > >> > >> connect to > >> > >>> different databases. > >>> > >>> Several attempts have been made by people to add support for > >> > >> different > >> > >>> databases to various projects. I've tried to do it myself on > >> > >> occasion, but > >> > >>> even when patches are accepted by upstream, they get broken by > >> > >> upstream at a > >> > >>> future release again because of the bad design that is often employed > >> > >> by lazy > >> > >>> developers. > >>> > >>> -- > >>> Joost > >> > >> wasn't qtsql once supposed to that? > > > > If a framework like qtsql is used, swapping the database is easy. > > > > Most developers seem to prefer to reinvent the wheel and often come up > > with something that vaguely resembles a circle and is held together with > > a mixture of glue and duck tape. > I blame php and others of it's ilk. My point exactly. > The good thing about php is that everyone and their dog can knock out > running code. > The bad thing about php is that they do. Not PHP's fault, lazy developers' fault. > Substitute mysql and bash if you will and tweak the content to suit - it > all works out the same. > > Sensible languages (like, oh I dunno - python maybe?) have this trick > about them - you have to work hard to write awful code. You also have to > work hard to write awesome code, but if you just follow the book you > usually end up with acceptable code. I agree, to a fashion. I've seen some really bad examples of Python code though. > I will refrain from commenting on perl. I'm surprised noone came up with a Desktop Environment (like KDE and Gnome) written as a perl one-liner yet. ;) -- Joost ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-13 6:38 ` J. Roeleveld @ 2014-08-13 7:10 ` Alan McKinnon 2014-08-13 12:18 ` Alec Ten Harmsel 0 siblings, 1 reply; 29+ messages in thread From: Alan McKinnon @ 2014-08-13 7:10 UTC (permalink / raw To: gentoo-user On 13/08/2014 08:38, J. Roeleveld wrote: >> The good thing about php is that everyone and their dog can knock out >> > running code. >> > The bad thing about php is that they do. > Not PHP's fault, lazy developers' fault. > I disagree. It starts with the language. If a language makes it trivially simple to write atrocious code, and makes the developer jump through hoops to write decent code, then the language is faulty. PHP is like that. Bash is also like that, omfg; bash seems to have been designed to make decent code fundamentally impossible to write... -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-13 7:10 ` Alan McKinnon @ 2014-08-13 12:18 ` Alec Ten Harmsel 2014-08-13 12:26 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: Alec Ten Harmsel @ 2014-08-13 12:18 UTC (permalink / raw To: gentoo-user On Wed 13 Aug 2014 03:10:22 AM EDT, Alan McKinnon wrote: > Bash is also like that, omfg; bash seems to have been designed to make > decent code fundamentally impossible to write... I mean, if you're trying to write anything more than a screenful in Bash you should definitely use Ruby or Python IMNHO. The RVM (Ruby Version Manager) project recently was raising money to pay a developer to port ~20,000 lines of Bash to Ruby, which is just embarrassing. > I will refrain from commenting on perl I wrote 250 lines of perl and forgot how it worked a day later ;) Write it, ship it, forget about it. Alec ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] akonadi ... don't you just love it? 2014-08-13 12:18 ` Alec Ten Harmsel @ 2014-08-13 12:26 ` Alan McKinnon 0 siblings, 0 replies; 29+ messages in thread From: Alan McKinnon @ 2014-08-13 12:26 UTC (permalink / raw To: gentoo-user On 13/08/2014 14:18, Alec Ten Harmsel wrote: > On Wed 13 Aug 2014 03:10:22 AM EDT, Alan McKinnon wrote: >> Bash is also like that, omfg; bash seems to have been designed to make >> decent code fundamentally impossible to write... > > I mean, if you're trying to write anything more than a screenful in Bash > you should definitely use Ruby or Python IMNHO. The RVM (Ruby Version > Manager) project recently was raising money to pay a developer to port > ~20,000 lines of Bash to Ruby, which is just embarrassing. :-) > >> I will refrain from commenting on perl > > I wrote 250 lines of perl and forgot how it worked a day later ;) Write > it, ship it, forget about it. I had the pleasure of maintaining an exceptionally well-written bespoke perl app of 20,000+ lines. Written by an exceptional mathematician with 10+ years of sysadmin experience, that code base was a dream. It all just made so much sense, perl notwithstanding. At the same time I also had to maintain another giant 5,000 line monolithic beast that brought any strong developer to their knees. Oh, the pain, the pain. So with perl it can go both ways -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
* [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-09 20:00 [gentoo-user] akonadi ... don't you just love it? Mick 2014-08-10 9:34 ` J. Roeleveld 2014-08-11 18:01 ` Volker Armin Hemmann @ 2014-08-11 19:05 ` Mick 2014-08-11 22:21 ` Neil Bothwick 2 siblings, 1 reply; 29+ messages in thread From: Mick @ 2014-08-11 19:05 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: Text/Plain, Size: 4294 bytes --] On Saturday 09 Aug 2014 21:00:48 Mick wrote: > First some general observations that relate to kmail2: > > I thought of giving the latest kmail-4.12.5 a spin. So installed it on a > machine and set up a couple of IMAP4 servers to get messages from. An > account with a messages in the low hundreds works fine. An account with > messages in the 100k plus range works like a dog. While kmail fetches > headers and then akonadi sets off to organise threads and whatever else it > wants to do the application becomes pretty much unresponsive and the CPU > climbs up to 98%. Half an hour later I can get back to it. :-@ > > Anyway, this is not the current problem. I updated mysql to 5.5.39, then I > kmail would not start with akonadi failing with "mysql log containing > errors". So I ran: > > mysql_upgrade --socket=/tmp/akonadi-michael.NFvLpB/mysql.socket > > which completed without an error. Kmail still failed to start. Trying to > start akonadi console states: > > "Failed to connect to database. Driver not loaded" > > Then the pop up Details window says MySQL log contains errors, just like > when I try to start kmail. This is what I see in > .local/share/akonadi/db_data/mysql.err: > > InnoDB: Unable to lock ./ibdata1, error: 11 > InnoDB: Check that you do not already have another mysqld process > InnoDB: using the same InnoDB data or log files. > InnoDB: Unable to lock ./ibdata1, error: 11 > InnoDB: Check that you do not already have another mysqld process > InnoDB: using the same InnoDB data or log files. > 140809 20:58:42 InnoDB: Unable to open the first data file > InnoDB: Error in opening ./ibdata1 > 140809 20:58:42 InnoDB: Operating system error number 11 in a file > operation. InnoDB: Error number 11 means 'Resource temporarily > unavailable'. > InnoDB: Some operating system error numbers are described at > InnoDB: > http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html > 140809 20:58:42 InnoDB: Could not open or create data files. > 140809 20:58:42 InnoDB: If you tried to add new data files, and it failed > here, > 140809 20:58:42 InnoDB: you should now edit innodb_data_file_path in my.cnf > back > 140809 20:58:42 InnoDB: to what it was, and remove the new ibdata files > InnoDB created > 140809 20:58:42 InnoDB: in this failed attempt. InnoDB only wrote those > files full of > 140809 20:58:42 InnoDB: zeros, but did not yet use them in any way. But be > careful: do not > 140809 20:58:42 InnoDB: remove old data files which contain your precious > data! > 140809 20:58:42 [ERROR] Plugin 'InnoDB' init function returned error. > 140809 20:58:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE > failed. > 140809 20:58:42 [ERROR] Unknown/unsupported storage engine: innodb > 140809 20:58:42 [ERROR] Aborting > > > So I moved ./ibdata* and tried again with the same error. Is there > something else I should be doing here to get this going? Kids, when in doubt, go back to the basics! :-p I thought that I *had* run revdep-rebuild, but perhaps I am losing count with the different machines I look after? Ha, ha! Anyway, after another irrelevant update today revdep-rebuild showed this: ======================================================================== * Checking dynamic linking consistency [ 33% ] * broken /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so (requires libmysqlclient_r.so.16) [ 85% ] * broken /usr/lib64/qt4/plugins/sqldrivers/libqsqlmysql.so (requires libmysqlclient_r.so.16) [ 100% ] * Generated new 3_broken.rr * Assigning files to packages * /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so -> dev-qt/qtsql * /usr/lib64/qt4/plugins/sqldrivers/libqsqlmysql.so -> dev-qt/qtsql * Generated new 4_raw.rr and 4_owners.rr * Cleaning list of packages to rebuild * Generated new 4_pkgs.rr * Assigning packages to ebuilds * Generated new 4_ebuilds.rr * Evaluating package order * Generated new 5_order.rr * All prepared. Starting rebuild emerge --complete-graph=y --oneshot --verbose -a dev-qt/qtsql:4 ======================================================================== Now all works as expected - apologies for the noise! -- Regards, Mick [-- Attachment #2: This is a digitally signed message part. --] [-- Type: application/pgp-signature, Size: 473 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-11 19:05 ` [gentoo-user] " Mick @ 2014-08-11 22:21 ` Neil Bothwick 2014-08-12 0:38 ` Rich Freeman 2014-08-12 1:00 ` Dale 0 siblings, 2 replies; 29+ messages in thread From: Neil Bothwick @ 2014-08-11 22:21 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: text/plain, Size: 1129 bytes --] On Mon, 11 Aug 2014 20:05:51 +0100, Mick wrote: > Anyway, after another irrelevant update today revdep-rebuild showed > this: > ======================================================================== > * Checking dynamic linking consistency > [ 33% ] * broken /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so > (requires libmysqlclient_r.so.16) > [ 85% ] * broken /usr/lib64/qt4/plugins/sqldrivers/libqsqlmysql.so > (requires libmysqlclient_r.so.16) [snip] > ======================================================================== > > Now all works as expected - apologies for the noise! It appears the recent mysql update broke quite a few things, my MythTV fronted started sulking while the backend just sucked up all the CPU cycles. Something else broke too, but I can't remember more than two things these days. @preserved-rebuild showed nothing but revdep-rebuild cleaned things up. It appears that revdep-rebuild is not ready for retirement yet, although this is the first time in ages that I've needed it. -- Neil Bothwick "Energize!" said Picard and the pink bunny appeared... [-- Attachment #2: signature.asc --] [-- Type: application/pgp-signature, Size: 181 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-11 22:21 ` Neil Bothwick @ 2014-08-12 0:38 ` Rich Freeman 2014-08-12 7:31 ` Neil Bothwick 2014-08-12 1:00 ` Dale 1 sibling, 1 reply; 29+ messages in thread From: Rich Freeman @ 2014-08-12 0:38 UTC (permalink / raw To: gentoo-user On Mon, Aug 11, 2014 at 6:21 PM, Neil Bothwick <neil@digimed.co.uk> wrote: > It appears the recent mysql update broke quite a few things, my MythTV > fronted started sulking while the backend just sucked up all the CPU > cycles. Something else broke too, but I can't remember more than two > things these days. @preserved-rebuild showed nothing but revdep-rebuild > cleaned things up. It appears that revdep-rebuild is not ready for > retirement yet, although this is the first time in ages that I've needed > it. I had a similar experience on two Gentoo boxes, including MythTV. I don't think it was myth itself but rather something in-between. I did catch a missing slot operator dep on mythplugins and will be fixing that in the next bump, which I should be doing soon anyway if I get a weekend without a car wreck. Rich ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 0:38 ` Rich Freeman @ 2014-08-12 7:31 ` Neil Bothwick 2014-08-12 8:08 ` Peter Humphrey 2014-08-12 14:38 ` Daniel Frey 0 siblings, 2 replies; 29+ messages in thread From: Neil Bothwick @ 2014-08-12 7:31 UTC (permalink / raw To: gentoo-user [-- Attachment #1: Type: text/plain, Size: 952 bytes --] On Mon, 11 Aug 2014 20:38:57 -0400, Rich Freeman wrote: > > It appears the recent mysql update broke quite a few things, my MythTV > > fronted started sulking while the backend just sucked up all the CPU > > cycles. Something else broke too, but I can't remember more than two > > things these days. @preserved-rebuild showed nothing but > > revdep-rebuild cleaned things up. It appears that revdep-rebuild is > > not ready for retirement yet, although this is the first time in ages > > that I've needed it. > > I had a similar experience on two Gentoo boxes, including MythTV. I > don't think it was myth itself but rather something in-between. Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that dev-python/mysql-python was rebuilt at the same time, so that must have been missed too, whereas dev-perl/DBD-mysql was re-emerged right after mysql. -- Neil Bothwick Top Oxymorons Number 2: Exact estimate [-- Attachment #2: signature.asc --] [-- Type: application/pgp-signature, Size: 181 bytes --] ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 7:31 ` Neil Bothwick @ 2014-08-12 8:08 ` Peter Humphrey 2014-08-12 14:38 ` Daniel Frey 1 sibling, 0 replies; 29+ messages in thread From: Peter Humphrey @ 2014-08-12 8:08 UTC (permalink / raw To: gentoo-user On Tuesday 12 August 2014 08:31:34 Neil Bothwick wrote: > On Mon, 11 Aug 2014 20:38:57 -0400, Rich Freeman wrote: > > > It appears the recent mysql update broke quite a few things, my MythTV > > > fronted started sulking while the backend just sucked up all the CPU > > > cycles. Something else broke too, but I can't remember more than two > > > things these days. @preserved-rebuild showed nothing but > > > revdep-rebuild cleaned things up. It appears that revdep-rebuild is > > > not ready for retirement yet, although this is the first time in ages > > > that I've needed it. It's so long since I last needed it that I didn't even think of it this time. > > I had a similar experience on two Gentoo boxes, including MythTV. I > > don't think it was myth itself but rather something in-between. > > Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that > dev-python/mysql-python was rebuilt at the same time, so that must have > been missed too, whereas dev-perl/DBD-mysql was re-emerged right after > mysql. It broke kmail here. @preserved-rebuild rebuilt dev-perl/DBD-mysql but didn't catch qtsql. Thank you all for reminding me of revdep-rebuild. -- Regards Peter ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 7:31 ` Neil Bothwick 2014-08-12 8:08 ` Peter Humphrey @ 2014-08-12 14:38 ` Daniel Frey 2014-08-12 17:54 ` Rich Freeman 1 sibling, 1 reply; 29+ messages in thread From: Daniel Frey @ 2014-08-12 14:38 UTC (permalink / raw To: gentoo-user On 08/12/2014 12:31 AM, Neil Bothwick wrote: > > Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that > dev-python/mysql-python was rebuilt at the same time, so that must have > been missed too, whereas dev-perl/DBD-mysql was re-emerged right after > mysql. > > It most definitely was, I just updated my backend and 3 remote frontends and had this issue. Portage missed this completely, it was revdep-rebuild that found this breakage and repaired it. From what I remember there was a python sql package that wound up being broken too. Dan ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 14:38 ` Daniel Frey @ 2014-08-12 17:54 ` Rich Freeman 0 siblings, 0 replies; 29+ messages in thread From: Rich Freeman @ 2014-08-12 17:54 UTC (permalink / raw To: gentoo-user On Tue, Aug 12, 2014 at 10:38 AM, Daniel Frey <djqfrey@gmail.com> wrote: > On 08/12/2014 12:31 AM, Neil Bothwick wrote: >> >> Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that >> dev-python/mysql-python was rebuilt at the same time, so that must have >> been missed too, whereas dev-perl/DBD-mysql was re-emerged right after >> mysql. >> >> > > It most definitely was, I just updated my backend and 3 remote frontends > and had this issue. Portage missed this completely, it was > revdep-rebuild that found this breakage and repaired it. From what I > remember there was a python sql package that wound up being broken too. Yup. My frontends broke after updating the backend. Clearly there is some kind of incompatibility between client/server cross-version. This isn't just a linking issue. I suspect qtsql was the issue - I just didn't recall that when I made my last post. Rich ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-11 22:21 ` Neil Bothwick 2014-08-12 0:38 ` Rich Freeman @ 2014-08-12 1:00 ` Dale 2014-08-12 7:57 ` Walter Dnes 1 sibling, 1 reply; 29+ messages in thread From: Dale @ 2014-08-12 1:00 UTC (permalink / raw To: gentoo-user Neil Bothwick wrote: > It appears the recent mysql update broke quite a few things, my MythTV > fronted started sulking while the backend just sucked up all the CPU > cycles. Something else broke too, but I can't remember more than two > things these days. @preserved-rebuild showed nothing but > revdep-rebuild cleaned things up. It appears that revdep-rebuild is > not ready for retirement yet, although this is the first time in ages > that I've needed it. Jeez Neil. If you can remember two things at the same time, you may have me beat. < scratches head > Now where did that mouse go? Dale :-) :-) ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 1:00 ` Dale @ 2014-08-12 7:57 ` Walter Dnes 2014-08-12 8:19 ` Alan McKinnon 0 siblings, 1 reply; 29+ messages in thread From: Walter Dnes @ 2014-08-12 7:57 UTC (permalink / raw To: gentoo-user On Mon, Aug 11, 2014 at 08:00:33PM -0500, Dale wrote > Neil Bothwick wrote: > > It appears the recent mysql update broke quite a few things, my MythTV > > fronted started sulking while the backend just sucked up all the CPU > > cycles. Something else broke too, but I can't remember more than two > > things these days. @preserved-rebuild showed nothing but > > revdep-rebuild cleaned things up. It appears that revdep-rebuild is > > not ready for retirement yet, although this is the first time in ages > > that I've needed it. > > Jeez Neil. If you can remember two things at the same time, you may > have me beat. < scratches head > Now where did that mouse go? > > Dale They say that memory is the second thing to go. I forget what the first is. -- Walter Dnes <waltdnes@waltdnes.org> I don't run "desktop environments"; I run useful applications ^ permalink raw reply [flat|nested] 29+ messages in thread
* Re: [gentoo-user] Re: akonadi ... don't you just love it? 2014-08-12 7:57 ` Walter Dnes @ 2014-08-12 8:19 ` Alan McKinnon 0 siblings, 0 replies; 29+ messages in thread From: Alan McKinnon @ 2014-08-12 8:19 UTC (permalink / raw To: gentoo-user On 12/08/2014 09:57, Walter Dnes wrote: > On Mon, Aug 11, 2014 at 08:00:33PM -0500, Dale wrote >> Neil Bothwick wrote: >>> It appears the recent mysql update broke quite a few things, my MythTV >>> fronted started sulking while the backend just sucked up all the CPU >>> cycles. Something else broke too, but I can't remember more than two >>> things these days. @preserved-rebuild showed nothing but >>> revdep-rebuild cleaned things up. It appears that revdep-rebuild is >>> not ready for retirement yet, although this is the first time in ages >>> that I've needed it. >> >> Jeez Neil. If you can remember two things at the same time, you may >> have me beat. < scratches head > Now where did that mouse go? >> >> Dale > > They say that memory is the second thing to go. I forget what the > first is. > mojo? -- Alan McKinnon alan.mckinnon@gmail.com ^ permalink raw reply [flat|nested] 29+ messages in thread
end of thread, other threads:[~2014-08-13 12:27 UTC | newest] Thread overview: 29+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2014-08-09 20:00 [gentoo-user] akonadi ... don't you just love it? Mick 2014-08-10 9:34 ` J. Roeleveld 2014-08-12 7:05 ` Mick 2014-08-11 18:01 ` Volker Armin Hemmann 2014-08-11 21:45 ` Mick 2014-08-12 5:36 ` J. Roeleveld 2014-08-12 6:42 ` Alan McKinnon 2014-08-12 9:10 ` Mick 2014-08-12 12:06 ` Alan McKinnon 2014-08-12 13:28 ` J. Roeleveld 2014-08-12 13:38 ` Alan McKinnon 2014-08-12 14:10 ` J. Roeleveld 2014-08-12 18:21 ` Volker Armin Hemmann 2014-08-12 19:00 ` J. Roeleveld 2014-08-12 19:20 ` Alan McKinnon 2014-08-13 6:38 ` J. Roeleveld 2014-08-13 7:10 ` Alan McKinnon 2014-08-13 12:18 ` Alec Ten Harmsel 2014-08-13 12:26 ` Alan McKinnon 2014-08-11 19:05 ` [gentoo-user] " Mick 2014-08-11 22:21 ` Neil Bothwick 2014-08-12 0:38 ` Rich Freeman 2014-08-12 7:31 ` Neil Bothwick 2014-08-12 8:08 ` Peter Humphrey 2014-08-12 14:38 ` Daniel Frey 2014-08-12 17:54 ` Rich Freeman 2014-08-12 1:00 ` Dale 2014-08-12 7:57 ` Walter Dnes 2014-08-12 8:19 ` Alan McKinnon
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox