[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Health] Problems with back and restore from Tryton client
From: |
Christoph H. Larsen |
Subject: |
[Health] Problems with back and restore from Tryton client |
Date: |
Mon, 20 Feb 2012 22:36:47 +0430 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.20) Gecko/20110820 Iceowl/1.0b2 Icedove/3.1.12 |
Dear All,
Sorry for cross-posting. The following has been submitted to the Tryton
list on 21 January 2012. No reply so far, so maybe you can help:
-----------------------------------------------------------------------
On a recent install of Tryton 2.2.1 inside a jail located inside a
well-established multi-jail server running FreeBSD 8.2. PostgreSQL
(version 9.1.2 used for server and clients throughout the jails) is
happily churning away on in a diffferent jail (and used by other
application in other jails, too). Packet Filter (pf) firewall is in
place and working nicely.
I seem to encounter the dreaded OpenERP backup/restore problem, albeit
partially:
I CANNOT do any backup using the Tryton client database management
faciltiies, unless I have been logged into the respective Tryton
instance. When logged in, I do strike luck.
So, if I am not logged into the respective Tryton database via the
Tryton cient, and try to do a backup using the correct Tryton
superuser password, I get:
-----------------------------------------------------------------------------------------------------------------
[Sat Jan 21 22:34:15 2012] INFO:database:DUMP DB: hmis_dkgmdc
----------------------------------------
Exception happened during processing of request from ('192.168.0.71',
34096)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/SocketServer.py", line 582, in
process_request_thread
self.finish_request(request, client_address)
File "/usr/local/lib/python2.7/SocketServer.py", line 323, in
finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/local/lib/python2.7/SocketServer.py", line 639, in
__init__
self.handle()
File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 345, in
handle
self.handle_one_request()
File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 313, in
handle_one_request
self.raw_requestline = self.rfile.readline(65537)
File "/usr/local/lib/python2.7/socket.py", line 476, in readline
data = self._sock.recv(self._rbufsize)
SysCallError: (-1, 'Unexpected EOF')
----------------------------------------
Exception in thread Thread-6:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/threading.py", line 552, in
__bootstrap_inner
self.run()
File "/usr/local/lib/python2.7/threading.py", line 505, in run
self.__target(*self.__args, **self.__kwargs)
File "/usr/local/lib/python2.7/SocketServer.py", line 586, in
process_request_thread
self.shutdown_request(request)
File "/usr/local/lib/python2.7/SocketServer.py", line 459, in
shutdown_request
request.shutdown(socket.SHUT_WR)
TypeError: shutdown() takes exactly 0 arguments (1 given)
-----------------------------------------------------------------------------------------------------------------
Restores of the backed-up file via the Tryton client are entirely
impossible and give this error message:
---------------------------------------------------------------------------------------------------------------------------------
[Sat Jan 21 22:11:32 2012] INFO:database:connect to "template1"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5370; 0 0 COMMENT
EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of extension plpgsql
Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural
language';
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges were granted for "public"
pg_restore: WARNING: no privileges were granted for "public"
WARNING: errors ignored on restore: 1
----------------------------------------
Exception happened during processing of request from ('192.168.0.71',
60833)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/SocketServer.py", line 582, in
process_request_thread
self.finish_request(request, client_address)
File "/usr/local/lib/python2.7/SocketServer.py", line 323, in
finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/local/lib/python2.7/SocketServer.py", line 639, in
__init__
self.handle()
File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 345, in
handle
self.handle_one_request()
File "/usr/local/lib/python2.7/BaseHTTPServer.py", line 313, in
handle_one_request
self.raw_requestline = self.rfile.readline(65537)
File "/usr/local/lib/python2.7/socket.py", line 476, in readline
data = self._sock.recv(self._rbufsize)
SysCallError: (-1, 'Unexpected EOF')
----------------------------------------
Exception in thread Thread-1:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/threading.py", line 552, in
__bootstrap_inner
self.run()
File "/usr/local/lib/python2.7/threading.py", line 505, in run
self.__target(*self.__args, **self.__kwargs)
File "/usr/local/lib/python2.7/SocketServer.py", line 586, in
process_request_thread
self.shutdown_request(request)
File "/usr/local/lib/python2.7/SocketServer.py", line 459, in
shutdown_request
request.shutdown(socket.SHUT_WR)
TypeError: shutdown() takes exactly 0 arguments (1 given)
---------------------------------------------------------------------------------------------------------------------------------
Given the strange error message (python-PgSQL is nowhere mentioned as
a dependency for Trytond) I did install in both client and server for
testing purposes, but did not get any different error message. The
unexpected EOF error might also indicate a defective backup file...
Anybody with any ideas how to approach this problem? (Please note that
I do NOT PostgreSQL on localhost with trust credentials, but via SSL
in a different jail.)
-----------------------------------------------------------------------
Thanks a lot, indeed -
Chris
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Health] Problems with back and restore from Tryton client,
Christoph H. Larsen <=