[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#591375: marked as done (psql upgrade when going from lenny to squeeze breaks)



Your message dated Tue, 12 Jul 2011 15:50:08 +0000
with message-id <E1QgfDs-0005U4-AU@franck.debian.org>
and subject line Bug#633587: Removed package(s) from unstable
has caused the Debian Bug report #591375,
regarding psql upgrade when going from lenny to squeeze breaks
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 owner@bugs.debian.org
immediately.)


-- 
591375: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=591375
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message ---
Package: openerp-server
Version: 5.0.11-1
Severity: grave
Tags: upstream
Justification: renders package unusable

Please note that this report is made against 5.0.11-1 because of
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=590819
but it affect 5.0.12-1 as well.
 
When upgrading from lenny to squeeze, the postgresql database is upgraded
from 8.3 to 8.4. Part of the upgrade process is migrating the cluster
from the old version to the new version.

However, when this migration is done, the following error shows up:
Upgrading database erp...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5407; 0 93844 TABLE DATA ir_act_window openerp
pg_restore: [archiver (db)] COPY failed: ERROR:  null value in column "name" violates not-null constraint
CONTEXT:  COPY ir_act_window, line 175: "250    \N      ir.actions.act_window   \N      \N      account.analytic.line   form    [('account_id','child_of',[active_id])..."
WARNING: errors ignored on restore: 1

The migration ignores this error, and it is possible to connect to the 
server afterwards, but the client is rendered unusable with the 
error 'access denied'.

This issue affects upstream, it seems, and there are other reports on 
it [1,2,3].

Reference [3] suggests a workaround, namely looking for the affected rows
on the database *before* the upgrade, fixing them, and then moving on.

I am not sure how to best handle the issue, but it is certain to bite
many users on the upcoming lenny to squeeze upgrade. It should at least
be documented on the README.Debian file.

[1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=557803
[2] https://bugs.launchpad.net/ubuntu/+source/openerp-server/+bug/452439
[3] http://www.openerp.com/forum/post50636.html?sid=bbd3fb10580f3edde6a88ee32cb85dcb


-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (990, 'testing'), (80, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF8)
Shell: /bin/sh linked to /bin/bash

Versions of packages openerp-server depends on:
ii  adduser                       3.112      add and remove users and groups
ii  debconf [debconf-2.0]         1.5.33     Debian configuration management sy
ii  python                        2.6.5-5    An interactive high-level object-o
ii  python-libxslt1               1.1.26-5   Python bindings for libxslt1
ii  python-lxml                   2.2.6-1    pythonic binding for the libxml2 a
ii  python-psycopg2               2.2.1-1    Python module for PostgreSQL
ii  python-pychart                1.39-7     Python library for creating high q
ii  python-pydot                  1.0.2-1    Python interface to Graphviz's dot
ii  python-reportlab              2.4-1      ReportLab library to create PDF do
ii  python-tz                     2010b-1    Python version of the Olson timezo

Versions of packages openerp-server recommends:
ii  ghostscript               8.71~dfsg2-3   The GPL Ghostscript PostScript/PDF
ii  graphviz                  2.26.3-5       rich set of graph drawing tools
ii  postgresql                8.4.4-2        object-relational SQL database (su
ii  postgresql-client-8.3 [po 8.3.11-0lenny1 front-end programs for PostgreSQL 
ii  postgresql-client-8.4 [po 8.4.4-2        front-end programs for PostgreSQL 
ii  python-imaging            1.1.7-1+b1     Python Imaging Library
ii  python-matplotlib         0.99.3-1       Python based plotting system in a 
ii  python-openssl            0.10-1         Python wrapper around the OpenSSL 
ii  python-pyparsing          1.5.2-2        Python parsing module

Versions of packages openerp-server suggests:
ii  openerp-client                5.0.11-1   Enterprise Resource Management (cl

-- Configuration Files:
/etc/openerp-server.conf [Errno 13] Permission denied: u'/etc/openerp-server.conf'

-- debconf information:
  openerp-server/username: openerp



--- End Message ---
--- Begin Message ---
Version: 5.0.15-2+rm

Dear submitter,

as the package openerp-server has just been removed from the Debian archive
unstable we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see http://bugs.debian.org/633587

The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
ftpmaster@debian.org.

Debian distribution maintenance software
pp.
Luca Falavigna (the ftpmaster behind the curtain)


--- End Message ---

Reply to: