I am having the same problem, I have tried again what you just said by erasing DataBase but then you still have the same problems. Also on other systems tried there you have the same error message.Assuming this is a new installation, can you try deleting the TimeTrex database and going through the web-based installer again to see if the error persists?
Unable to complete installation
-
- Posts: 4
- Joined: Thu Jul 25, 2019 2:21 am
Unable to complete installation
Re: Unable to complete installation
We need to confirm if it is in fact the same underlying error or not. Please enable debug logging as described in this FAQ, then try to connect again and attach a copy of the log file here, it should contain a more specific error message.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
-
- Posts: 4
- Joined: Thu Jul 25, 2019 2:21 am
Re: Unable to complete installation
Here you can find the more specific error log
Re: Unable to complete installation
Upon further investigation it appears this is actually a bug in PostgreSQL v9.4.23, v9.5.18, v9.6.14, v10.9 (version you are running) and v11.4. All of which were released on 20-Jun-2019 and the specific bug was introduced by the release note item: "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)". The bug has already been fixed and is just waiting on the next release of PostgreSQL which is due out in early August 2019.
It only affects new installations of TimeTrex, or upgrades from TimeTrex versions prior to v11.0.0. We are looking at possible work-arounds from our end, but it may not be possible or practical due to the nature of the bug, and in either case will take some time to implement, test and release ourselves.
However installing an earlier point release of Ubuntu 18.04 or downgrading PostgreSQL to 10.8 or earlier would also allow the install to complete. Once the installation is completed you could upgrade to the latest point release and TimeTrex won't be affected anymore.
It only affects new installations of TimeTrex, or upgrades from TimeTrex versions prior to v11.0.0. We are looking at possible work-arounds from our end, but it may not be possible or practical due to the nature of the bug, and in either case will take some time to implement, test and release ourselves.
However installing an earlier point release of Ubuntu 18.04 or downgrading PostgreSQL to 10.8 or earlier would also allow the install to complete. Once the installation is completed you could upgrade to the latest point release and TimeTrex won't be affected anymore.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
Re: Unable to complete installation
Hello but the problem to install TimeTrex is also with the latest version of Postgresql for Ubuntu - psql (11.4 (Ubuntu 11.4-1.pgdg16.04+1))
Still it fails while filling in the main database during the install process.
What is the manual workaround to install it please?
I can't install TimeTrex to test it so I can't put it in our company into a candidate for time tracking SW in the future...
Can you provide an earlier version of TimeTrex that is not affected by this bug?
Still it fails while filling in the main database during the install process.
What is the manual workaround to install it please?
I can't install TimeTrex to test it so I can't put it in our company into a candidate for time tracking SW in the future...
Can you provide an earlier version of TimeTrex that is not affected by this bug?
Re: Unable to complete installation
The problem isn't with TimeTrex, its with a bug in all of the latest versions of PostgreSQL. Downgrading PostgreSQL by one version (ie: from 11.4 to 11.3) will resolve the issue. We are looking into a possible way to work around the bug in PostgreSQL, but that doesn't change the fact that the problem is with PostgreSQL and not TimeTrex.lumirl wrote: ↑Mon Jul 29, 2019 8:23 am Hello but the problem to install TimeTrex is also with the latest version of Postgresql for Ubuntu - psql (11.4 (Ubuntu 11.4-1.pgdg16.04+1))
Still it fails while filling in the main database during the install process.
What is the manual workaround to install it please?
I can't install TimeTrex to test it so I can't put it in our company into a candidate for time tracking SW in the future...
Can you provide an earlier version of TimeTrex that is not affected by this bug?
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
Re: Unable to complete installation
We have posted a quick guide on how to work around the PostgreSQL bug that is affecting new TimeTrex installs here:
viewtopic.php?f=6&t=7837
viewtopic.php?f=6&t=7837
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
Re: Unable to install Timetrex on Ubuntu
Hello,
there is a new version of Postgres 11.4.1 and still I cannot install your timetrex.
I cannot downgrade according your howto because I have Ubunutu 16.04
So what is the workaround for me?
there is a new version of Postgres 11.4.1 and still I cannot install your timetrex.
I cannot downgrade according your howto because I have Ubunutu 16.04
So what is the workaround for me?
Re: Unable to install Timetrex on Ubuntu
Unfortunately the PostgreSQL community has not yet released a new version that fixes the bug causing TimeTrex to fail during the install/upgrade yet, though its expected to be released soon.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!
Re: Unable to complete installation
If you are using the PGDB APT repository, you can download old versions of the PostgreSQL packages (ie: v11.3) from there and install them in a similar way as described in the FAQ.
This link may help to find the files you need to download: http://apt.postgresql.org/pub/repos/apt ... gresql-11/
This link may help to find the files you need to download: http://apt.postgresql.org/pub/repos/apt ... gresql-11/
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Help motivate us to continue by showing your appreciation!