Re: [opensuse-kde] Again unable to save akonadi postgresql database :: corrupted compressed data

Top posting (sorry) In fact no updates on the kde side have entered the system stable kr412 at 4.12.2 Nor no changes in postgresql. But libqt4 was updated during the week in repo updates-oss On the other side, I'm receiving lot of mails during a week, and then perhaps one of them is wrongly encoded in the db. Also last sunday I was forced to reset completely the kdepim stack configuration and data and restart it from scratch. So all my imap offline stuff was re-downloaded and create new records in the database. As before there were some missing offline message, perhaps the bug was already there but not shown ? (this is a pure guess) What kind of bi-section path I can follow to find the root cause, and thus being able to deliver a good bug report to the right person ? /me thinking to buy a plane ticket for Barcelona ;-) On Monday 03 March 2014 09.26:43 Raymond Wooninck wrote:

Hi Bruno,

As that it worked last week, do you know if any update was installed ? As far as I know from a KDE/Qt perspective we didn't push any update last week. From where do you pull the KDE updates ? I am not sure if there was ever a patch against Qt or that it was within kdepim somewhere

Regards

Raymond

On Mon, Mar 3, 2014 at 8:20 AM, Bruno Friedmann wrote:

...

After some months of peace, there's again a trouble with QT KDE Akonadi and Postgresql

pg_dump -U postgres -Fc --encoding='UTF-8' -f /tmp/akondadi.dump bf_akonadi pg_dump: Dumping the contents of table "parttable" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: compressed data is corrupt pg_dump: The command was: COPY public.parttable (id, pimitemid, name, data, datasize, version, external) TO stdout;

Last week everything was working correctly :-(

Env : openSUSE 13.1 64bits, postgresql 9.2.4 (oss), kde 4.12.2

libqt installed zypper se -si libqt Loading repository data... Reading installed packages...

S | Name | Type | Version | Arch | Repository --+-----------------------------+---------+-------------------+--------+----------- i | libQTweetLib1_0 | package | 0.5-1.5 | x86_64 | packman i | libQtGLib-2_0-0 | package | 0.10.3-1.1 | x86_64 | oss i | libQtGLib-devel | package | 0.10.3-1.1 | x86_64 | oss i | libQtGStreamer-0_10-0 | package | 0.10.3-1.1 | x86_64 | oss i | libQtShiva0_2 | package | 0.9.3-2.1.2 | x86_64 | oss i | libQtWebKit-devel | package | 4.8.5+2.3.3-2.6.1 | x86_64 | update i | libQtWebKit4 | package | 4.8.5+2.3.3-2.6.1 | x86_64 | update i | libQtWebKit4-32bit | package | 4.8.5+2.3.3-2.6.1 | x86_64 | update i | libqt4 | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-devel | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-linguist | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-qt3support | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-qt3support-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-mysql | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-mysql-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-postgresql | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-postgresql-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-sqlite | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-sqlite-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-unixODBC | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-sql-unixODBC-32bit | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-x11 | package | 4.8.5-5.9.2 | x86_64 | update i | libqt4-x11-32bit | package | 4.8.5-5.9.2 | x86_64 | update

There was a bug against qt almost a year ago about the same kind of trouble. Did we have loose the patch in openSUSE update packages ?

--

Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch

openSUSE Member GPG KEY : D5C9B751C4653227 irc: tigerfoot -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org

-- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch openSUSE Member GPG KEY : D5C9B751C4653227 irc: tigerfoot -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org