--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: openerp-server: postgresql upgrade when going from leeny to squeeze breaks openerp
- From: pedro gapski <gapski@reckon.com.br>
- Date: Mon, 02 Aug 2010 12:56:16 -0300
- Message-id: <20100802155616.803.71733.reportbug@pioneer.reckon.com.br>
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 ---