Re: Problems with the last update to akonadi [Solved]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



El Mar 15 Abr 2014 15:22:42 Daniel Vrátil escribió:
> On Monday 14 of April 2014 06:02:49 Rex Dieter wrote:
> > On 04/14/2014 05:56 AM, Laurent Rineau wrote:
> > > Le Monday 14 April 2014 10:13:20 José Matos a écrit :
> > >> On Thursday 10 April 2014 23:29:57 José Matos wrote:
> > >>> Hi Daniel,
> > >>> 
> > >>>       the akonadi server seems to be trapped in a continuous loop. 
If
> > >>>       I
> > >>> 
> > >>> kill one another one is started. So it is not obvious how to 
proceed.
> > >>> 
> > >>> Looking to top I notice that there is a mysqld process running for 
55
> > >>> min (the computer is now up for 7h24m).
> > >>> 
> > >>> This seems to be the same pattern of yesterday.
> > >> 
> > >> Just a followup, in case anyone has the same problem.
> > >> 
> > >> I have solved this last Thursday with Daniel's help.
> > >> 
> > >> The culprit was:
> > >> 
> > >> Sql error: The total number of locks exceeds the lock table size
> > >> QMYSQL:
> > >> Unable to execute query
> > >> Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) 
REFERENCES
> > >> PimItemTable(id) ON UPDATE CASCADES ON DELETE CASCADE
> > >> 
> > >> and the solution was, since I am using an internal mysql server, 
was to
> > >> increase the value of the innodb_buffer_pool_size parameter on
> > >> ~/.local/share/akonadi/mysql.conf
> > >> 
> > >> The value that was there was of 8M and I have set it to 128M.
> > > 
> > > I was impacted by that bug too, but I did not found the correct fix. I
> > > removed my Akonadi database last Friday.
> > > 
> > > I think that should be reported to upstream KDE, so that they find a 
way
> > > to
> > > smooth the upgrade.
> 
> Hi,
> 
> > As a downstream/packaging issue, fedoras akonadi packaging 
currently
> > opts to default to using the values in:
> > /etc/akonadi/mysql-global-mobile.conf
> > and not
> > /etc/akonadi/mysql-global-big.conf
> > (ie, compare each to /etc/aknoadi/mysql-global.conf)
> > 
> > The rationale being that the -big config, well, was *too* big,
> > especially for casual users.  Perhaps we will have to rethink that.
> 
> Upstream doesn't think that 80MB innodb_buffer_pool_size is too big :-) 
and
> is in favor of using mysql-global.conf by default (as shown above, 
there's
> a reason for those values).  Upstream is actually not surprised that so
> many people complain about poor Akonadi performance, since they are 
all
> using what could be called a misconfigured database.
> innodb_buffer_pool_size is one of the most critical values for us that
> directly impact performance of queries and IO. I admit it's partly my 
fault
> for not noticing this when I took over the package, but it never occur to
> me someone would willingly used the crippled config :-)
> 
> Unless someone has a *real* reason not to do it, I'm going to switch to 
the
> -not-really-that-big config in our packages.
> 
> > In the meantime, yes, if the values in -mobile are problematic, then
> > upstream should also consider adjusting things too.
> 
> The -mobile config assumes a device with limited HW resources, where 
so
> small innodb_buffer_pool_size actually makes sense. This is however 
not the
> case on desktop.
> 
> With my Akonadi maintainer hat on, I think that we should actually 
remove
> this config now, since it's not tested at all and there's no real usecase
> for Akonadi on mobile device ATM. With my latest fixes to our fork of 
the
> SQLite driver, using SQLite backend should be much less pain and 
notably
> faster, so we can recommend mobile distributions to opt-in for SQLite.
> 
> 
> Cheers,
> Dan
> 
> > -- Rex
> > _______________________________________________
> > kde mailing list
> > kde@xxxxxxxxxxxxxxxxxxxxxxx
> > https://admin.fedoraproject.org/mailman/listinfo/kde
> > New to KDE4? - get help from http://userbase.kde.org

My *real* reason to not use the /etc/akonadi/mysql-global-big.conf is a 
stream of crashes. Daniel, is it possible to make a mysql.conf file tailored 
for Akonadi?
_______________________________________________
kde mailing list
kde@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/kde
New to KDE4? - get help from http://userbase.kde.org





[Index of Archives]     [KDE Users]     [Fedora General Discussion]     [Older Fedora Users Mail]     [Fedora Advisory Board]     [Fedora Security]     [Fedora Maintainers]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [ATA RAID]     [Fedora Marketing]     [Fedora Mentors]     [Fedora Package Announce]     [Fedora Package Review]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Triage]     [Coolkey]     [Yum Users]     [Yosemite Forum]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]

  Powered by Linux