Your message dated Wed, 20 Nov 2013 15:19:00 +0000 with message-id <[email protected]> and subject line Bug#716922: fixed in akonadi 1.10.3-1 has caused the Debian Bug report #716922, regarding Wrong handling of postgreSQL's bytea datatype to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 716922: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=716922 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: akonadi-backend-postgresql Version: 1.9.2-2 Severity: important --- Please enter the report below this line. --- Greetings. Thanks for including akonadi-backend-postgresql in Sid... I'm hoping to use it when I can get it working. I'm having a lot of trouble when trying to use PostgreSQL 9.1 as the backend for Akonadi; I can't tell for sure that this is the correct package to file this bug against, but this seems the most logical place to start. [The next logical alternative is the 'kmail' package.] When migrating from KMail1 to KMail2, KMail2 shows a dialog box indicating that all mail has been migrated, but email does not show up and PostgreSQL continuously spits out errors to the log with: 2013-07-16 17:51:52 EDT ERROR: invalid input syntax for type bytea at character 24 2013-07-16 17:51:52 EDT STATEMENT: EXECUTE qpsqlpstmt_7d ('\SEEN') 2013-07-16 17:51:52 EDT ERROR: invalid input syntax for type bytea at character 24 2013-07-16 17:51:52 EDT STATEMENT: EXECUTE qpsqlpstmt_7d ('\SEEN') ... After letting the system run for about 24 hours, the postgresql log grows to about 650 MB containing about 9 million lines of the above, and about 200 emails (out of thousands) show up in KMail2 (in various folders, and none of the messages in the "inbox" folder ever showed up) from my main IMAP account, and new ones show up very slowly -- which I believe seems to be related to the errors. This is repeatable. Steps to replicate ------------------ 1. Install akonadi-backend-postgresql, which pulls in dependencies: postgresql:amd64 postgresql-9.1:amd64 postgresql-client-9.1:amd64 postgresql-client-common:amd64 postgresql-common:amd64 Modify /etc/postgresql/9.1/main/postgresql.conf to uncomment: standard_conforming_strings = on (this was suggested in akonadiconsole) 2. 'su' to root, then 'su - postgres' to become the postgres user 3. Create a role for a normal user with CreateDB ability pgsql -d template1 -> CREATE ROLE cknadle WITH CREATEDB LOGIN; \q exit; exit; [to become regular user again] 4. Create new database as a regular user psql -d template1 -> CREATE DATABASE "akonadi-chris"; \q 5. Delete previous files for akonadi: rm -rf ~/.local/share/akonadi rm -rf ~/.config/akonadi/agent* rm -rf ~/.kde/share/akonadi_* rm -rf ~/.kde/share/akonadi-* Delete settings for kmail2 and kmail-migrator rm -rf ~/.kde/share/config/kmail2* rm -rf ~/.kde/share/config/kmail-migrator* 6. Open akonadiconsole as user, set to use the akonadi-chris database, start Akonadi 7. Start KMail2 and choose "Migrate" Setps 5 through 7 work just fine when using the the Akonadi MySQL backend, and likewise KMail2 seems to work fine afterwards. Please let me know if I can be of further assistance. Thanks! -- Chris -- Chris Knadle [email protected] --- System information. --- Architecture: amd64 Kernel: Linux 3.9-1-amd64 Debian Release: jessie/sid 500 unstable www.deb-multimedia.org 500 unstable ftp.us.debian.org 500 unstable debian-packages.coredump.us 500 testing security.debian.org 500 testing ftp.us.debian.org 500 stable-updates ftp.us.debian.org 500 stable security.debian.org 500 stable ftp.us.debian.org 500 sid linux.dropbox.com --- Package information. --- Depends (Version) | Installed ==============================-+-=========== libqt4-sql-psql | 4:4.8.5+dfsg-2 Recommends (Version) | Installed =============================-+-=========== akonadi-server | 1.9.2-2 postgresql | 9.3+142really9.1+145 Package's Suggests field is empty.
--- End Message ---
--- Begin Message ---Source: akonadi Source-Version: 1.10.3-1 We believe that the bug you reported is fixed in the latest version of akonadi, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Maximiliano Curia <[email protected]> (supplier of updated akonadi package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Wed, 20 Nov 2013 14:53:11 +0100 Source: akonadi Binary: akonadi-server libakonadiprotocolinternals1 libakonadi-dev akonadi-backend-mysql akonadi-backend-postgresql akonadi-backend-sqlite akonadi-dbg Architecture: source amd64 all Version: 1.10.3-1 Distribution: unstable Urgency: medium Maintainer: Debian Qt/KDE Maintainers <[email protected]> Changed-By: Maximiliano Curia <[email protected]> Description: akonadi-backend-mysql - MySQL storage backend for Akonadi akonadi-backend-postgresql - PostgreSQL storage backend for Akonadi akonadi-backend-sqlite - SQLite storage backend for Akonadi akonadi-dbg - debugging symbols for the Akonadi PIM storage service akonadi-server - Akonadi PIM storage service libakonadi-dev - development files for the Akonadi PIM storage service libakonadiprotocolinternals1 - libraries for the Akonadi PIM storage service Closes: 716922 729615 Changes: akonadi (1.10.3-1) unstable; urgency=medium . * New upstream release. (Closes: #729615, #716922) * Update build dependencies. Checksums-Sha1: 5ba3cc9465394d99c6e9b5c3dc52e936a5a467da 2659 akonadi_1.10.3-1.dsc 701fbdde01a2787ec47fc085da02ad6238cf3b92 228633 akonadi_1.10.3.orig.tar.bz2 879303f06a696ad97d5b1e7787be8501f233c28c 12855 akonadi_1.10.3-1.debian.tar.gz 7fe182c72a2bc220a3bdaa7bd464fcf05ad82a0b 561126 akonadi-server_1.10.3-1_amd64.deb 3abc9072921b1c731453bacc2f097becb96abad1 65034 libakonadiprotocolinternals1_1.10.3-1_amd64.deb ffca219dddbaa59cc1069e232a295a485aacf427 20680 libakonadi-dev_1.10.3-1_amd64.deb 686b7bc09eaa5beec48718dfbb3120808b8837fe 11880 akonadi-backend-mysql_1.10.3-1_all.deb c7ca0ac99cafe39251a1fc2310716fcb470fbda3 10244 akonadi-backend-postgresql_1.10.3-1_all.deb a9118ea236f542b12896c304330d6bba0f17a890 28970 akonadi-backend-sqlite_1.10.3-1_amd64.deb a082d6c324ef0fd94af9400bc7be259185894d32 13990236 akonadi-dbg_1.10.3-1_amd64.deb Checksums-Sha256: 2713eecda9af88a98e4cadca041340971a5a2ff149e8bc4745a5ae7805928cdb 2659 akonadi_1.10.3-1.dsc a8f66eec479c235ec67e77befac50c42743f627663fe2bb49238e82e6fbfffb0 228633 akonadi_1.10.3.orig.tar.bz2 9d968a778394ca219ce8cc65213d593a99c3769ba1e7d2bc9a02786467b220f7 12855 akonadi_1.10.3-1.debian.tar.gz 836ea40345a62686d1a13612b97e1d70e429da3e91472960b645012623c25866 561126 akonadi-server_1.10.3-1_amd64.deb 5de8b3f5b3ffdb65c32b4e426eeb035a4fdc1210555c217e8b09ef2342f2c451 65034 libakonadiprotocolinternals1_1.10.3-1_amd64.deb cb071231890f212b07a0ff8b1649a23d8c2176ac93563eb82b919cf465e993c6 20680 libakonadi-dev_1.10.3-1_amd64.deb 9cf6fd4f2203d95951a666a5990ecf825b92eb10849b4cb10465f3601e6412c7 11880 akonadi-backend-mysql_1.10.3-1_all.deb cc90e1e6f61ab2dbe8e85bbda4d58e114bcee85af3571a459332ac1f814eccc2 10244 akonadi-backend-postgresql_1.10.3-1_all.deb 02615f0bf20a973be5cebdbd16ac7bd7395e1283c7e89775a6737416f8c1a2a9 28970 akonadi-backend-sqlite_1.10.3-1_amd64.deb 6570a352585389107694316c862ae41ca7e371b00cee2d2de09d733d71d3dabe 13990236 akonadi-dbg_1.10.3-1_amd64.deb Files: d7bb651c76a35722c2e5feac4941c7a3 2659 libs extra akonadi_1.10.3-1.dsc 3929b765baa3dc0d548a26893c64abcf 228633 libs extra akonadi_1.10.3.orig.tar.bz2 1068c1214e8688daf93cf95c90405930 12855 libs extra akonadi_1.10.3-1.debian.tar.gz 56f5531d48d21ec8f60ecec528588290 561126 net extra akonadi-server_1.10.3-1_amd64.deb 13645a5281eef7cab804992ee83b2994 65034 libs extra libakonadiprotocolinternals1_1.10.3-1_amd64.deb d5bd42e636d58f92e23cf333134b0736 20680 libdevel extra libakonadi-dev_1.10.3-1_amd64.deb 03ec97cf8763d0881f381dcb118e3cef 11880 misc extra akonadi-backend-mysql_1.10.3-1_all.deb cdd8dc2fb54b790573f589e712b872e2 10244 misc extra akonadi-backend-postgresql_1.10.3-1_all.deb 089c5dfad029bab048c2b5a310941722 28970 misc extra akonadi-backend-sqlite_1.10.3-1_amd64.deb 6e1cc048da2416296e0d8f0faa06cfc4 13990236 debug extra akonadi-dbg_1.10.3-1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.15 (GNU/Linux) iQIcBAEBCAAGBQJSjMCaAAoJEMcZdpmymyMqtyEP/ic4upRKE2WTU+mOr7kbIdKQ kMRr4RsoKcHxlo9+vNfu23kSQ7/2n4VVgx1O6/wIqvv2x1hQ62B1aqxBHNOw0jE9 XONxYnSp+bnLrhcuVvzpTnZo0c08iIlhzDJwBRQeU+VL+smpxhOCVozA8EbJxqNg bcutuEDViY9grbOQebUoAMQYcF4j12ssMkuMlo6jaM1h2gjY5reAeLn+uWhiMBO9 fzJOEgscwyNpyk+kzOHt+BDpFoP3lXti5/tHKI2QTlADXR+lzreyQi0OKU0OAu4n q8q35u7k1uDEaw/mqr7QJgWby0OjL01s1/eii3JST1C0x3o06LglyYWuZTzJQSjk CTSHp6mROFoedm1WTPyj+AullR7CRbiFopoRJIjPfL8IAR279kfGvLJ6kzgPzNj1 s1MDncUorl/VYXmWiq9QfqYJ3Qz2rhM8kSNAzoAGdHptu2AIyLIMkhPujBwhS3oP aAYH1cYbfrFLDzE/EApwh8WHAFwhyK1I8hxuG8xWLU1UmPD9Nujz8y2oWqZxCpQV L/7q8iG5AJD0evdnee6xcGK76JiQWDYDIKCf4uORswcoOH8rZzVc8CvSAKP/RTsg Y3om8H5nw7lNbcVIgEvj6oaVCUvqugMVWx6sva1L+iFpLy1hGArQag48xv1oNqwM KkJKpeHnxfC7nYwTxk6X =8Ca6 -----END PGP SIGNATURE-----
--- End Message ---
