Your message dated Sat, 28 Sep 2013 00:34:37 +0000
with message-id <[email protected]>
and subject line Bug#721645: fixed in owncloud 5.0.12~rc1+dfsg-1
has caused the Debian Bug report #721645,
regarding [owncloud] PostgreSQL: null value in column "unencrypted_size"
violates not-null constraint
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.)
--
721645: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=721645
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: owncloud
Version: 5.0.10+dfsg-1
Severity: normal
--- Please enter the report below this line. ---
Hi!
There seems to be an error in the Owncloud database template for
PostgreSQL. Using OC 5.0.10+dfsg-1 and uploading a new file I want to
share, I get a hanging session/everlasting upload wheel in that
uploading browser windows and a white screen in other browser windows.
The cause seems to be a violation of the not-null constraint, when
looking at the pgsql database log:
2013-09-02 18:37:27.121 CEST owncloud owncloud DETAIL: parameters: $1 =
'image/png'
2013-09-02 18:37:27.121 CEST owncloud owncloud LOG: execute
pdo_stmt_0000001d: INSERT INTO "oc_filecache"("mimepart", "mimetype",
"mtime", "size", "etag", "path_hash", "path", "parent", "name",
"encrypted", "storage") VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)
2013-09-02 18:37:27.121 CEST owncloud owncloud DETAIL: parameters: $1 =
'3', $2 = '12', $3 = '1378137742', $4 = '68725', $5 = '5224bec6500cf',
$6 = 'eb0cf64fdaefa162e63b55f9aa51a55c', $7 = 'files/Bildschirmfoto
2013-09-02 um 18.01.30.png', $8 = '5', $9 = 'Bildschirmfoto 2013-09-02
um 18.01.30.png', $10 = '0', $11 = '2'
2013-09-02 18:37:27.122 CEST owncloud owncloud ERROR: null value in
column "unencrypted_size" violates not-null constraint
When looking at the database schema you can find this:
CREATE TABLE oc_filecache
(
fileid serial NOT NULL,
storage integer NOT NULL,
path character varying(512),
path_hash character varying(32) NOT NULL DEFAULT NULL::character varying,
parent integer NOT NULL,
name character varying(250),
mimetype integer NOT NULL,
mimepart integer NOT NULL,
size bigint NOT NULL,
mtime integer NOT NULL,
encrypted integer NOT NULL DEFAULT 0,
unencrypted_size bigint NOT NULL,
etag character varying(40) NOT NULL DEFAULT NULL::character varying,
CONSTRAINT oc_filecache_pkey PRIMARY KEY (fileid),
CONSTRAINT fs_storage_path_hash UNIQUE (storage, path_hash)
)
WITH (
OIDS=FALSE
);
unencrypted_size is of type bigint with constraint NOT NULL, but missing
the default value like it is for encrypted. Apparently, either the
INSERT is missing a value for unencrypted_size or the template should
contain
unencrypted_size bigint NOT NULL DEFAULT 0,
as it is for encrypted to avoid a NOT-NULL constraint violation.
Regards,
Ingo
--- System information. ---
Architecture: amd64
Kernel: Linux 3.10-2-amd64
Debian Release: jessie/sid
500 unstable www.deb-multimedia.org
500 unstable ftp.de.debian.org
--- Package information. ---
Depends (Version) | Installed
==============================================-+-===================
apache2 | 2.4.6-3
OR httpd |
fonts-font-awesome | 3.0.2-1
libjs-chosen | 0.9.11-1
libjs-jquery (>= 1.7.2-1) | 1.7.2+dfsg-3
libjs-jquery-fancybox | 8-2
libjs-jquery-jplayer | 2.3.4+dfsg-1
libjs-jquery-minicolors (<< 2~) | 1.2.1-1
libjs-jquery-mousewheel | 8-2
libjs-jquery-timepicker | 1.2-1
libjs-jquery-ui | 1.10.1+dfsg-1
libjs-pdf | 0.8.37+dfsg-1
libphp-phpmailer | 5.1-1
mediawiki (>= 1:1.19) | 1:1.19.7+dfsg-1
owncloud-doc | 0~20130715-1
owncloud-mysql (= 5.0.10+dfsg-1) | 5.0.10+dfsg-1
OR owncloud-pgsql (= 5.0.10+dfsg-1) |
OR owncloud-sqlite (= 5.0.10+dfsg-1) |
php-aws-sdk (<< 2~) | 1.5.6.2-1
php-crypt-blowfish | 1.1.0~RC2-1
php-getid3 (>= 1.9.3-1) | 1.9.6-1
php-mdb2 | 2.5.0b5-1
php-mdb2-schema | 0.8.5-1
php-pear | 5.5.1+dfsg-2
php-sabre-dav (<< 1.8~) | 1.7.6+dfsg-2
php-sabre-vobject | 2.0.7-1
php-seclib | 0.3.5-2
php-symfony-routing | 2.0.19-1
php-xml-parser | 1.3.4-6
php5 | 5.5.1+dfsg-2
php5-curl | 5.5.1+dfsg-2
php5-gd | 5.5.1+dfsg-2
php5-json | 1.3.1+dfsg-2
Recommends (Version) | Installed
===================================-+-===========
clamav | 0.97.8+dfsg-1
OR clamav-daemon | 0.97.8+dfsg-1
curl | 7.32.0-1
exim4 | 4.80-7
OR mail-transport-agent |
liboauth-php |
php-services-json |
php5-intl | 5.5.1+dfsg-2
php5-ldap | 5.5.1+dfsg-2
smbclient | 2:3.6.17-1
zendframework |
Suggests (Version) | Installed
=======================================-+-===========
libapache2-mod-xsendfile |
--
Ciao... // Fon: 0381-2744150
Ingo \X/ http://blog.windfluechter.net
Please don't share this address with Facebook or Google!
gpg pubkey: http://www.juergensmann.de/ij_public_key.asc
--- End Message ---
--- Begin Message ---
Source: owncloud
Source-Version: 5.0.12~rc1+dfsg-1
We believe that the bug you reported is fixed in the latest version of
owncloud, 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.
David Prévot <[email protected]> (supplier of updated owncloud 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: Fri, 27 Sep 2013 19:01:36 -0400
Source: owncloud
Binary: owncloud owncloud-mysql owncloud-pgsql owncloud-sqlite
Architecture: source all
Version: 5.0.12~rc1+dfsg-1
Distribution: experimental
Urgency: low
Maintainer: ownCloud for Debian maintainers
<[email protected]>
Changed-By: David Prévot <[email protected]>
Description:
owncloud - cloud storage for files, music, contacts, calendars and many more
owncloud-mysql - meta-package providing MySQL dependencies for ownCloud
owncloud-pgsql - meta-package providing PostgreSQL dependencies for ownCloud
owncloud-sqlite - meta-package providing SQLite dependencies for ownCloud
Closes: 718915 721645
Changes:
owncloud (5.0.12~rc1+dfsg-1) experimental; urgency=low
.
* Imported Upstream version 5.0.12~rc1+dfsg (Closes: #721645)
* Ship embedded libjs-jquery-ui copy (Closes: #718915)
* Depend on php-google-api-php-client instead of using embedded copy
* Fix path in last patches
* Use CSS provided by the latest fonts-font-awesome
Checksums-Sha1:
2474869ca8b66abed1e768a7d7711d0436d0a08e 1886 owncloud_5.0.12~rc1+dfsg-1.dsc
2eed4955d12fd5f9706133de50d69ffb457d9e8f 13123804
owncloud_5.0.12~rc1+dfsg.orig.tar.bz2
b26fcffba524d9be99d0d2079bd42821e8faaf53 67092
owncloud_5.0.12~rc1+dfsg-1.debian.tar.gz
be4ab179ecae102f921719187cf94b2acdefd007 2348512
owncloud_5.0.12~rc1+dfsg-1_all.deb
25b819773c9accb6197fe9c047164854d2541068 47828
owncloud-mysql_5.0.12~rc1+dfsg-1_all.deb
f4301fff246b0dfe2b4a1364b4207b51298a6ab8 68510
owncloud-pgsql_5.0.12~rc1+dfsg-1_all.deb
f174ad30d9416b4c564d5eb00d05a35811816318 68146
owncloud-sqlite_5.0.12~rc1+dfsg-1_all.deb
Checksums-Sha256:
ed90c9395ab07f80d45e4d6308454f5d0da7f8f9e0ddb7e37a1be1adcec2dd9d 1886
owncloud_5.0.12~rc1+dfsg-1.dsc
de2a23f006410a5248b59abbbd021ec3000c12f840a6213efae2d6444fa31fb4 13123804
owncloud_5.0.12~rc1+dfsg.orig.tar.bz2
3555197526252aa23c864078566e8e128d4c734c8b30e7696420e907ffd544b9 67092
owncloud_5.0.12~rc1+dfsg-1.debian.tar.gz
2395dce76d63ac2f98a3d7479a4b7b66403db2753f51231d80f3553cbbcf3f8b 2348512
owncloud_5.0.12~rc1+dfsg-1_all.deb
3a220fda0d8569a98fb07cf4cee75dd78f4a339191e6fdabad078a3b5c1507d6 47828
owncloud-mysql_5.0.12~rc1+dfsg-1_all.deb
d945d343dcfea038cb4d75215def0aaf8f774fab34ddc54065a403b8e727a6ef 68510
owncloud-pgsql_5.0.12~rc1+dfsg-1_all.deb
9919b004ba726f6eacdfaa581a17badc6cbf4eeca1aed7168613d04a01be2a25 68146
owncloud-sqlite_5.0.12~rc1+dfsg-1_all.deb
Files:
8930508ed491776b680ef380cc62f478 1886 web extra owncloud_5.0.12~rc1+dfsg-1.dsc
e64a827f523c47ca640eabea0b881d40 13123804 web extra
owncloud_5.0.12~rc1+dfsg.orig.tar.bz2
3fa5eb856826f265c680dd86d6a60112 67092 web extra
owncloud_5.0.12~rc1+dfsg-1.debian.tar.gz
0f64bbc9e6aa2cf7a19229b8822d632b 2348512 web extra
owncloud_5.0.12~rc1+dfsg-1_all.deb
880c595f694b51512a7e83d679f7c84a 47828 web extra
owncloud-mysql_5.0.12~rc1+dfsg-1_all.deb
56692840014bf45c2258fe5c969b2b92 68510 web extra
owncloud-pgsql_5.0.12~rc1+dfsg-1_all.deb
b07c934775ce7e621e6ac0cc09ae8ceb 68146 web extra
owncloud-sqlite_5.0.12~rc1+dfsg-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
iQEcBAEBCAAGBQJSRhjjAAoJEAWMHPlE9r08SRUH/0k/2zakuOtFTh/6WiiraJMq
JeFunjJz91pynaS0dou2U6L99jjGC5+U019Uu5kEj+C5HjDUhYkD60/pWTixLssl
bsLaOmuRy7z41PCEdHOkfxRrVYOonL1WTvhxaChC2841lC9p7FP316Y8vuybrwGq
2doEFtmhITjUdmwbT9q6Z51cIeXryzujl2JBZ005ODsg0R6Y6aQ1JxTdYcrBsoAV
bYbaCsiQlxjx8LqjdbHYS1JB4+doyB9xvhge7ngLhy0Vw9NYCA7YGxRLeVZ1Jkny
iNzDtIHp5LLUZJzX2BMtddxQptPjTMjZIZSYiEpu/K3UxZ2r2vwcTnmLENRU0xA=
=9YF0
-----END PGP SIGNATURE-----
--- End Message ---
