[opensuse-kde] Again unable to save akonadi postgresql database :: corrupted compressed data
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
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
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
-- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org
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
Hi Bruno,
Checking the logfiles, etc. The only commit that is PostgreSQL is this one:
Mon Oct 7 13:06:08 UTC 2013 - hrvoje.senjan@gmail.com
- Drop 0007-postgresql-driver-escape-backslashes-only-when-serve.patch
bug has been fixed properly with akonadi 1.10.3, and the patch
conflicts with the resolution in akonadi
But as you can see, this was submitted already last year and was
actually the last update to Qt4 before 13.1 was released.
What it could be is that the solution in Akonadi might not be working
100% in all cases and that with you reloading your mail database,
found exactly a situation that still causes issues. In this case, I
guess your best chance is to talk to Dan Vratil, as that this is his
area.
Raymond
On Mon, Mar 3, 2014 at 9:53 AM, Bruno Friedmann
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
-- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org
On Monday 03 March 2014 10.23:00 Raymond Wooninck wrote:
Hi Bruno,
Checking the logfiles, etc. The only commit that is PostgreSQL is this one:
Mon Oct 7 13:06:08 UTC 2013 -
- Drop 0007-postgresql-driver-escape-backslashes-only-when-serve.patch bug has been fixed properly with akonadi 1.10.3, and the patch conflicts with the resolution in akonadi
But as you can see, this was submitted already last year and was actually the last update to Qt4 before 13.1 was released.
What it could be is that the solution in Akonadi might not be working 100% in all cases and that with you reloading your mail database, found exactly a situation that still causes issues. In this case, I guess your best chance is to talk to Dan Vratil, as that this is his area.
Raymond
Did you have an email or irc nickname for Dan ? (could be private) -- 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
participants (2)
-
Bruno Friedmann
-
Raymond Wooninck