gpg error - connection already closed?

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()

Answer 1

I have the same problem, with no fix as yet.

I'm starting to think that it's caused by badly formatted data. I have 2 sections in my conf file, both the same apart from the file name and table name. One works fine and the other doesn't.

I will report back if I make any progress.