package gforge-db-postgresql 4.6.99+svn6347-1 failed to install/upgrade:

[UpWeardale]

Binary package hint: gforge

8.04 update

ProblemType: Package
Architecture: i386
Date: Sat Apr 26 12:08:46 2008
DistroRelease: Ubuntu 8.04
ErrorMessage:
 ErrorMessage: subprocess post-installation script returned error exit status 1
NonfreeKernelModules: nvidia
Package: gforge-db-postgresql 4.6.99+svn6347-1
PackageArchitecture: all
SourcePackage: gforge
Title: package gforge-db-postgresql 4.6.99+svn6347-1 failed to install/upgrade:
Uname: Linux 2.6.22-14-generic i686

[rob terhaar (robbyt)]

i might be having the same problem:

 * Reloading PostgreSQL 8.3 database server [ OK ]
You'll see some debugging info during this installation.
Do not worry unless told otherwise.
Creating initial Sourceforge database from files.
Creating debian_meta_data table.
Inserting first data into debian_meta_data table.
Updating debian_meta_data table.
Committing.
Processing /usr/lib/gforge/db/sf-2.6-complete.sql
DETAIL: Found referencing table's trigger.
DETAIL: Found referenced table's DELETE trigger.
DETAIL: Found referenced table's UPDATE trigger.
DETAIL: Found referencing table's trigger.
DETAIL: Found referenced table's DELETE trigger.
DETAIL: Found referenced table's UPDATE trigger.
DBD::Pg::st execute failed: ERROR: constraint "forum_group_forum_id_fk" for relation "forum" already exists
Transaction aborted because DBD::Pg::st execute failed: ERROR: constraint "forum_group_forum_id_fk" for relation "forum" already exists
Transaction aborted because DBD::Pg::st execute failed: ERROR: constraint "forum_group_forum_id_fk" for relation "forum" already exists
Last SQL query was:
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
(end of query)
Your database schema is at version 2.5.9999
Please report this bug on the Debian bug-tracking system.
Please include the previous messages as well to help debugging.
You should not worry too much about this,
your DB is still in a consistent state and should be usable.
dpkg: error processing gforge-db-postgresql (--configure):
 subprocess post-installation script returned error exit status 1
Setting up postfix-pgsql (2.5.1-2ubuntu1) ...
Adding pgsql map entry to /etc/postfix/dynamicmaps.cf

dpkg: dependency problems prevent configuration of gforge-mta-postfix:
 gforge-mta-postfix depends on gforge-db-postgresql | gforge-db; however:
  Package gforge-db-postgresql is not configured yet.
  Package gforge-db is not installed.
  Package gforge-db-postgresql which provides gforge-db is not configured yet.
dpkg: error processing gforge-mta-postfix (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 gforge-db-postgresql
 gforge-mta-postfix
E: Sub-process /usr/bin/dpkg returned an error code (1)

[georgexsh (georgexsh)]

I met same problem too.

[TJ Hooka (hooka)]

if you search through /usr/lib/gforge/db/sf-2.6-complete.sql you'll find a line that contains:

CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');

the line it errored on... if you look up a bit there is another line that has "AFTER INSERT OR UPDATE ON" for the same fk, this double command needs to be removed... (seeing as the same reaction for INSERT or UPDATE is above I just commented it out in mine)

This leads to other problems with the install later on, but I'm still working on it ;)

Hope this is a help to somebody...
   TJ Hooka

[TJ Hooka (hooka)]

Ahh, more precise and accurate (aka, not just me messing around) info available here: http://lists.gforge.org/pipermail/gforge-commits/2008-February/000849.html

[Christopher (soft-kristal)]

Synaptics reported this error when trying to remove it:

gforge-db-postgresql: subprocess installed pre-removal script returned error exit status 100

[Datateknikk programming group (catopett-yahoo)]

To remove gforge error, siply mkdir an empty /usr/lib/gforge
Then do "sudo apt-get -f install" or "sudo apt-get -f purce/autoremove/remove" or similar!
THIS WORK , i got the error away this way!

No bugs can be undone at all!
All error with gforge is to be removed this way,

"mkdir /usr/lib/gforge" maybe
"chmod 777 /usr/lib/gforge" to, then
"sudo apt-get -f autoremove"

Worked for me!

[Datateknikk programming group (catopett-yahoo)]

Just had to try, just a far away blink in my brain told me "what if", i tried, it worked!

[Thorsten Glaser (mirabilos)]

Fixed upstream in r6385, so the Ubuntu employees can please pick up that.