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

Bug #222488 reported by UpWeardale on 2008-04-26
22
This bug affects 2 people
Affects Status Importance Assigned to Milestone
gforge (Ubuntu)
Undecided
Unassigned

Bug Description

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

UpWeardale (upweardale) wrote :
rob terhaar (robbyt) wrote :

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) wrote :

I met same problem too.

TJ Hooka (hooka) wrote :

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) wrote :

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

Changed in gforge:
status: New → Confirmed
Christopher (soft-kristal) wrote :

Synaptics reported this error when trying to remove it:

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

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!

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

Thorsten Glaser (mirabilos) wrote :

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

Changed in gforge (Ubuntu):
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers