Re: [kde-freebsd] Akonadi/mysqld problems
On Thu, Jun 14, 2012 at 1:49 AM, Alberto Villa avi...@freebsd.org wrote: Oh no, it isn't apparently. I think I just found an interesting thing. :N look like placeholders: QString( UPDATE table1 SET col = :0 FROM table2 WHERE ( ( SELECT table2.answer WHERE table2.t1_id = table1.id ) ( :2 ) ) ) bindVals; We might have a parsing error here. I'll make Akonadi print all the queries and see what fail. No error, actually. Simply, Akonadi prints the failed query without replacing :N placeholders. By the way, it looks like I get failures with other tables, too. It just depends on how long the timeout was (and how many things Akonadi is able to do before it). -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On Thursday 14 June 2012 08:29:06 Alberto Villa wrote: By the way, it looks like I get failures with other tables, too. It just depends on how long the timeout was (and how many things Akonadi is able to do before it). Found the problem. I was suspecting some kind of overflow, and in fact the working limit for wait_timeout here is 21474836, which is (2^31 - 1) / 100. Now, finding where the overflow is will be interesting. Meanwhile, we can patch the port to use that value. Akonadi works brilliantly now. -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla Woman would be more charming if one could fall into her arms without falling into her hands. -- DeGourmont signature.asc Description: This is a digitally signed message part. ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/QT/devel/qt4/files
SVN commit 8314 by makc: Enable CUPS support by default: it adds dependency on cups-client only. M +1 -4 Makefile.options ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/QT
SVN commit 8315 by makc: Add new port devel/qt4-qmlviewer Submitted by: gahr M +5 -2 Mk/bsd.qt.mk A devel/qt4-qmlviewer (directory) A devel/qt4-qmlviewer/Makefile A devel/qt4-qmlviewer/pkg-descr A devel/qt4-qmlviewer/pkg-plist M +1 -1 devel/qt4/Makefile ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/KDE/graphics/okular
SVN commit 8316 by makc: Sync with ports: chase graphics/djvulibre update M +2 -2 Makefile ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On Thursday 14 June 2012 09:59:26 Alberto Villa wrote: Found the problem. I was suspecting some kind of overflow, and in fact the working limit for wait_timeout here is 21474836, which is (2^31 - 1) / 100. I'm in contact with ale@, MySQL maintainer, and his tests return a different value, so would you guys - and anyone with some free time - please test the number above and report if it works? I'm especially interested in differences between i386 and amd64. -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla I call them as I see them. If I can't see them, I make them up. -- Biff Barf signature.asc Description: This is a digitally signed message part. ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On June 14, 2012 01:10:05 PM Alberto Villa wrote: On Thursday 14 June 2012 09:59:26 Alberto Villa wrote: Found the problem. I was suspecting some kind of overflow, and in fact the working limit for wait_timeout here is 21474836, which is (2^31 - 1) / 100. I'm in contact with ale@, MySQL maintainer, and his tests return a different value, so would you guys - and anyone with some free time - please test the number above and report if it works? I'm especially interested in differences between i386 and amd64. Hi Alberto, It didn't help me at all. I changed the value, commented out my net_read_timeout (to force the 30 second default) and started KDE. After a few minutes doing other stuff, I went to check my email. Wouldn't work. I suppose I should mention that my email is two imap accounts. Here's the mysql.err file from .local/share/akonadi/db_data/ 120614 9:20:39 InnoDB: The InnoDB memory heap is disabled 120614 9:20:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120614 9:20:39 InnoDB: Compressed tables use zlib 1.2.5 120614 9:20:39 InnoDB: Initializing buffer pool, size = 80.0M 120614 9:20:39 InnoDB: Completed initialization of buffer pool 120614 9:20:39 InnoDB: highest supported file format is Barracuda. 120614 9:20:39 InnoDB: Waiting for the background threads to start 120614 9:20:40 InnoDB: 1.1.8 started; log sequence number 21775976 120614 9:20:41 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.25' socket: '/home/dwayne/.local/share/akonadi/socket- hudson.private.lan/mysql.socket' port: 0 Source distribution 120614 9:21:11 [Warning] Aborted connection 5 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:11 [Warning] Aborted connection 4 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:11 [Warning] Aborted connection 6 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:12 [Warning] Aborted connection 8 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:13 [Warning] Aborted connection 7 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) Notice the Aborted connection stuff started exactly 30 seconds after mysqld was ready to accecpt connections. And the akonadiserver.error file: Database error: DataStore::beginTransaction Last driver error: QMYSQL: Unable to begin transaction Last database error: MySQL server has gone away Database error: DataStore::beginTransaction Last driver error: QMYSQL: Unable to begin transaction Last database error: MySQL server has gone away Database error: DataStore::beginTransaction Last driver error: QMYSQL: Unable to begin transaction Last database error: MySQL server has gone away I have both a i386 and amd64 box. Same behaviour on both. Cheers, DMK ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On Thursday 14 June 2012 09:58:57 Dwayne MacKinnon wrote: It didn't help me at all. I changed the value, commented out my net_read_timeout (to force the 30 second default) and started KDE. After a few minutes doing other stuff, I went to check my email. Wouldn't work. Perfect. Now try 2147483. Out of curiosity, what FreeBSD version are you running? -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla Love is like the measles; we all have to go through it. -- Jerome K. Jerome signature.asc Description: This is a digitally signed message part. ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/KDE/x11/kdelibs4/files
SVN commit 8317 by makc: Add patch from upstream that makes kdelibs 4.8.4 compatible with Soprano 2.7.6 A patch-git76e0376d ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/QT/devel/qt4-uic3
SVN commit 8318 by rakuco: qt4-uic3: Depend on qt4-porting. We were experiencing some weird uic3 crashes on the ixsystems tinderbox when building kdenetwork4. It turns out that uic3 needs q3porting.xml to work, and it is provided by our -porting port. M +2 -1 Makefile ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/KDE/misc/kde4-l10n/files
SVN commit 8319 by makc: Sync with ports: USE_QT_VER - USE_QT4 M +1 -2 bsd.l10n.mk ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/KDE
SVN commit 8320 by makc: Convert to USE_QT4 M +1 -2 deskutils/kcharselect/Makefile M +1 -2 security/ksecrets/Makefile ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/QT
SVN commit 8321 by makc: Sync with ports: USE_QT_VER - USE_QT4 M +2 -3 accessibility/qt4-accessible/Makefile M +2 -3 chinese/qt4-codecs-cn/Makefile M +2 -3 chinese/qt4-codecs-tw/Makefile M +2 -3 databases/qt4-ibase-plugin/Makefile M +2 -3 databases/qt4-mysql-plugin/Makefile M +2 -3 databases/qt4-odbc-plugin/Makefile M +2 -3 databases/qt4-pgsql-plugin/Makefile M +2 -3 databases/qt4-sql/Makefile M +2 -3 databases/qt4-sqlite-plugin/Makefile M +2 -3 databases/qt4-sqlite3-plugin/Makefile M +2 -3 devel/dbus-qt4/Makefile M +2 -3 devel/qt4-assistant-adp/Makefile M +2 -3 devel/qt4-assistant/Makefile M +2 -3 devel/qt4-corelib/Makefile M +2 -3 devel/qt4-declarative/Makefile M +2 -3 devel/qt4-designer/Makefile M +2 -3 devel/qt4-help-tools/Makefile M +2 -3 devel/qt4-help/Makefile M +2 -3 devel/qt4-libqtassistantclient/Makefile M +2 -3 devel/qt4-linguist/Makefile M +2 -3 devel/qt4-makeqpf/Makefile M +2 -3 devel/qt4-moc/Makefile M +2 -3 devel/qt4-porting/Makefile M +2 -3 devel/qt4-qdbusviewer/Makefile M +2 -3 devel/qt4-qdoc3/Makefile M +2 -3 devel/qt4-qt3support/Makefile M +2 -3 devel/qt4-qtestlib/Makefile M +2 -3 devel/qt4-qvfb/Makefile M +2 -3 devel/qt4-rcc/Makefile M +2 -3 devel/qt4-script/Makefile M +2 -3 devel/qt4-scripttools/Makefile M +2 -3 devel/qt4-uic/Makefile M +2 -3 devel/qt4-uic3/Makefile M +7 -8 devel/qt4/Makefile M +2 -3 graphics/qt4-iconengines/Makefile M +2 -3 graphics/qt4-imageformats/Makefile M +2 -3 graphics/qt4-pixeltool/Makefile M +2 -3 graphics/qt4-svg/Makefile M +2 -3 japanese/qt4-codecs-jp/Makefile M +2 -3 korean/qt4-codecs-kr/Makefile M +2 -2 misc/qt4-doc/Makefile M +2 -3 misc/qt4-l10n/Makefile M +3 -4 misc/qt4-qtconfig/Makefile M +2 -3 misc/qt4-qtdemo/Makefile M +2 -3 multimedia/qt4-multimedia/Makefile M +2 -3 multimedia/qt4-phonon-gst/Makefile M +2 -3 multimedia/qt4-phonon/Makefile M +2 -3 net/qt4-network/Makefile M +2 -3 textproc/qt4-clucene/Makefile M +2 -3 textproc/qt4-xml/Makefile M +2 -3 textproc/qt4-xmlpatterns-tool/Makefile M +2 -3 textproc/qt4-xmlpatterns/Makefile M +2 -3 www/qt4-webkit/Makefile M +2 -3 x11-toolkits/qt4-gui/Makefile M +2 -3 x11/qt4-graphicssystems-opengl/Makefile M +2 -3 x11/qt4-inputmethods/Makefile M +2 -3 x11/qt4-opengl/Makefile ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
[kde-freebsd] [SVN Commit] area51/PORTS/databases/akonadi
SVN commit 8322 by avilla: - Fix two serious bugs with local MySQL backend: * let Akonadi install default 'mysql' database; * lower 'wait_timeout' to avoid overflow and avoid premature connection closing. - Convert to OPTIONSng. - Sync with ports and bump PORTREVISION. KMail 2 and other Akonadi-enabled programs are now working successfully. Thanks to Dwayne MacKinnon and Mel Flynn who helped investigating the bug. M +26 -15Makefile A files/patch-server__src__storage__dbconfigmysql.cpp ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On Thursday 14 June 2012 10:55:54 Dwayne MacKinnon wrote: I think 2147483 is a winner. I'll keep an eye on things for the next while. Given that it's ~25 days, it should work out ok. Aaand the fixes are in ports now! Thanks guys! -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla He laughs at every joke three times... once when it's told, once when it's explained, and once when he understands it. signature.asc Description: This is a digitally signed message part. ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
Re: [kde-freebsd] Akonadi/mysqld problems
On Wednesday 30 May 2012 18:16:28 Jaap Boender wrote: Just to chime in here, I've been having the same problem (exact same messages); also with the internal postgres server where akonadi doesn't want to start because of 'pg_ctl: another server may be running' errors (which isn't the case, and it still does this even after I remove the .local/share/akonadi directory) Now that the default configuration is fixed, I want to address your problem. Can you attach your internal server configuration file, please? -- Alberto Villa, FreeBSD committer avi...@freebsd.org http://people.FreeBSD.org/~avilla Gossip, n.: Hearing something you like about someone you don't. -- Earl Wilson signature.asc Description: This is a digitally signed message part. ___ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
