Saturday, March 27, 2010

gpg error - connection already closed?

Programmer Question

omg... hope someone can help me because I am so lost as to what to try next.... I don't know what is causing the error to happen, and I don't see how to figure it out... Keep going between the pgloader.conf examples and what I have, and I don't understand why I keep getting the 'connection already closed' error? The first few lines of my fr.conf is at the very end...



I'd really appreciate / love some guidance here... Been trying to get this thing going all morning, and am even getting stuck just on this part...



Running this command at the command line:



/usr/bin/pgloader -c /var/mybin/pgconfs/fr.conf


Yields this in the pgloader.log (with the process just hanging)



more /tmp/pgloader.log
27-03-2010 12:22:53 pgloader INFO Logger initialized
27-03-2010 12:22:53 pgloader INFO Reformat path is ['/usr/share/python-support/pgloader/reformat']
27-03-2010 12:22:53 pgloader INFO Will consider following sections:
27-03-2010 12:22:53 pgloader INFO fixed
27-03-2010 12:22:54 fixed INFO fixed processing
27-03-2010 12:22:54 pgloader INFO All threads are started, wait for them to terminate
27-03-2010 12:22:57 fixed ERROR connection already closed
27-03-2010 12:22:57 fixed INFO closing current database connection

[pgsql]
host = localhost
port = 5432
base = frdb
user = username
pass = password


[fixed]
table = fr
format = fixed
filename = /var/www/fr.txt
...


So, maybe a python issue? Any idea how to fix it?



Traceback (most recent call last):
File "/usr/lib/python2.6/threading.py", line 525, in __bootstrap_inner
self.run()
File "/usr/lib/pymodules/python2.6/pgloader/pgloader.py", line 847, in run
self.terminate()
File "/usr/lib/pymodules/python2.6/pgloader/pgloader.py", line 874, in terminate
self.db.close()
File "/usr/lib/pymodules/python2.6/pgloader/db.py", line 103, in close
self.dbconn.close()


Find the answer here

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails