Postgresql & 4.7 : incomplete database creation, resulting in unusable app

Question

Running the windows installer against a remote Postgresql 8.4 server with a blank database (UTF-8).

The first startup of Tomcat fires a bunch of warnings and fatal errors regarding schema creation :

OUTPUT>10011 [main] ERROR platformLogger  - org.postgresql.util.PSQLException: ERROR: relation "twk_issue" does not exist
OUTPUT>  Position : 16
OUTPUT>14553 [main] FATAL platformLogger  - ERROR: column "loadfromplan" does not exist
OUTPUT>  Position : 51
OUTPUT>org.postgresql.util.PSQLException: ERROR: column "loadfromplan" does not exist

There is a lot more like these full catalina out

When looking at schemaHistory.log , the given columns don't appear and thus haven't ben created.

Next, when trying to use the app, number of exceptions get raised in multiple areas.

Subsequent Tomcat startups / shutdowns don't fire anymore these errors.

Teamwork is just broken on Postgresql ! Any help is welcomed !

Accepted Answer

0	See here how to use Teamwork on PostgreSQl http://answers.twproject.com/questions/2317/faq-teamwork-and-postgresql answered Jul 05 '11 at 09:08 Silvia Chelazzi ♦♦ 4085●1●9

Answer 2

Actually, the same happens with MySQL :

2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'loadFromPlan' in 'where clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'loadFromPlan' in 'where clause'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'estimatedDurationx' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'estimatedDurationx' in 'field list'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'messageBody' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'messageBody' in 'field list'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'hourlyCost' in 'where clause'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'content' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'content' in 'field list'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'm.description' in 'on clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm.description' in 'on clause'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'm.minutex' in 'on clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm.minutex' in 'on clause'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_taskclassass'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_taskclass'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_resourceclassass'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_resclass'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_docclassass'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'twk_docclass'
2011 juin 28 18:05:41 FATAL platformLogger:243 - Unknown column 'status' in 'where clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'status' in 'where clause'
2011 juin 28 18:05:41 ERROR platformLogger:268 - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'comment' in 'where clause'

see the full log file

https://content.wuala.com/contents/openseo/taf/teamwork/platform.mysql51.log?key=vQvgYG1ZIdDc&dl=1

Answer 3

These errors are generated at the application startup by the schema updater due to schema changes between Teamwork versions, these errors are actually warnings and do not cause any errors in the application. If you encounter some of those while using Teamwork maybe probably there is another reason. When they occur post here the log recorded and we will try to help you.

This is a space where the community of Teamwork users can ask for support, explanations,
and also vote up or down questions, answers and feature requests.
>> Back to Teamwork's site.

Postgresql & 4.7 : incomplete database creation, resulting in unusable app

Follow this question

FAQs

> Back to Teamwork's site

Suggest ideas!

We want to hear from you!

Vote up your favourite suggestions or add your own!

Other products:

Related questions

This is a space where the community of Teamwork users can ask for support, explanations, and also vote up or down questions, answers and feature requests. >> Back to Teamwork's site.

Postgresql & 4.7 : incomplete database creation, resulting in unusable app

Follow this question

FAQs

> Back to Teamwork's site

Suggest ideas!

We want to hear from you!

Vote up your favourite suggestions or add your own!

Other products:

Related questions

This is a space where the community of Teamwork users can ask for support, explanations,
and also vote up or down questions, answers and feature requests.
>> Back to Teamwork's site.