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 -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
