#705: ProgrammingError: relation "bloodhound_relations" does not exist
------------------------+-------------------------------------------
Reporter: olemis | Owner: nobody
Type: defect | Status: new
Priority: blocker | Milestone: Release 8
Component: installer | Version:
Resolution: | Keywords: postgresql, relations upgrade
------------------------+-------------------------------------------
Changes (by olemis):
* component: => installer
* priority: major => blocker
* keywords: => postgresql, relations upgrade
* milestone: => Release 8
* owner: => nobody
Old description:
> I'm experiencing this error running 0.8-dev (r1517775)
> bloodhound_installer.py to create a fresh PostgreSQL environment.
>
> {{{#!sh
>
> $ sudo python bloodhound_setup.py --default-product-prefix=default
> --environments_directory=/opt/bh --database-type=postgres --database-
> name=dbname --user=bloodhound --admin-user=admin --admin-password=secret
> --project=prj
> Enter a new password for "bloodhound":
> Please reenter the password:
> Creating and Initializing Project
>
> ---------------------------------------------------------------------
> Project environment for 'prj' created.
>
> You may now configure the environment by editing the file:
>
> /opt/bh/prj/conf/trac.ini
>
> If you'd like to take this new project environment for a test drive,
> try running the Trac standalone web server `tracd`:
>
> tracd --port 8000 /opt/bh/prj
>
> Then point your browser to http://localhost:8000/prj.
> There you can also browse the documentation for your installed
> version of Trac, including information on further setup (such as
> deploying Trac to a real web server).
>
> The latest documentation can also always be found on the project
> website:
>
> http://trac.edgewall.org/
>
> Congratulations!
>
> Adding TRAC_ADMIN permissions to the admin user admin
> Running upgrades
> The upgrade failed. Please fix the issue and try again.
>
> ProgrammingError: relation "bloodhound_relations" does not exist
> LINE 1: ...ype","destination","comment","author","time" FROM
> bloodhound...
> ^
>
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
> Running wiki upgrades
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
> Running wiki Bloodhound upgrades
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
> Loading default product wiki
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
> Running default product wiki upgrades
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
> Running default product wiki Bloodhound upgrades
> TracError: The Trac Environment needs to be upgraded.
>
> Run "trac-admin /opt/bh/prj upgrade"
>
> You can now start Bloodhound by running:
>
> tracd --port=8000 /opt/bh/prj
>
> And point your browser at http://localhost:8000/prj
> }}}
>
> See [attachment:pg_txxx.dump.sql] to inspect DB contents immediately
> after failure. It's been generated by executing the following commands
>
> {{{#!sh
>
> $ sudo su - postgres
> $ pg_dump dbname > pg_txxx.dump.sql
> }}}
>
> PS: sqlite DBs are successfully installed
New description:
I'm experiencing this error running 0.8-dev (r1517775)
bloodhound_installer.py to create a fresh PostgreSQL environment.
{{{#!sh
$ sudo python bloodhound_setup.py --default-product-prefix=default
--environments_directory=/opt/bh --database-type=postgres --database-
name=dbname --user=bloodhound --admin-user=admin --admin-password=secret
--project=prj
Enter a new password for "bloodhound":
Please reenter the password:
Creating and Initializing Project
---------------------------------------------------------------------
Project environment for 'prj' created.
You may now configure the environment by editing the file:
/opt/bh/prj/conf/trac.ini
If you'd like to take this new project environment for a test drive,
try running the Trac standalone web server `tracd`:
tracd --port 8000 /opt/bh/prj
Then point your browser to http://localhost:8000/prj.
There you can also browse the documentation for your installed
version of Trac, including information on further setup (such as
deploying Trac to a real web server).
The latest documentation can also always be found on the project
website:
http://trac.edgewall.org/
Congratulations!
Adding TRAC_ADMIN permissions to the admin user admin
Running upgrades
The upgrade failed. Please fix the issue and try again.
ProgrammingError: relation "bloodhound_relations" does not exist
LINE 1: ...ype","destination","comment","author","time" FROM bloodhound...
^
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
Running wiki upgrades
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
Running wiki Bloodhound upgrades
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
Loading default product wiki
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
Running default product wiki upgrades
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
Running default product wiki Bloodhound upgrades
TracError: The Trac Environment needs to be upgraded.
Run "trac-admin /opt/bh/prj upgrade"
You can now start Bloodhound by running:
tracd --port=8000 /opt/bh/prj
And point your browser at http://localhost:8000/prj
}}}
See [attachment:pg_t705.dump.sql] to inspect DB contents immediately after
failure. It's been generated by executing the following commands
{{{#!sh
$ sudo su - postgres
$ pg_dump dbname > pg_t705.dump.sql
}}}
PS: sqlite DBs are successfully installed
--
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/705#comment:1>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
