Lots of 'relation "<tablename>" already exists' errors

More
4 years 8 months ago #89667 by ubuntourist
ubuntourist created the topic: Lots of 'relation "<tablename>" already exists' errors
Hi,

I'm on a Linux / PostgreSQL system trying to upgrade from 1.91 to 2.00+

I keep getting errors like:
CDbCommand failed to execute the SQL statement: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "participants" already exists

So, I restored the table and started the install from scratch after dropping the offending table. Lather, rinse, repeat, several times.

After tiring of that endless loop, I manually dropped ALL of the empty tables, and am now getting error messages about tables NOT existing.

Can you list which tables I should get rid of so that it will get through the creation of tables it doesn't check for?

Please Log in to join the conversation.

More
4 years 8 months ago - 4 years 8 months ago #89679 by ubuntourist
ubuntourist replied the topic: Lots of 'relation "<tablename>" already exists' errors
In the words of Alex Trebek "And, the answer is":

A previous failed attempt at upgrading from 1.91+ to 1.92 created some tables in the database that should not have been there. Rewinding to 1.91+ those extra tables were never dropped.

Installing a clean 1.91+ showed these extra empty tables:
  • expression_errors
  • participant_attribute
  • participant_attribute_names
  • participant_attribute_names_lang
  • participants
  • survey_links
  • survey_url_parameters
Plus two other tables that contained survey data.

Dropping the tables above and doing the 2.00+ install one more time appears to have worked correctly.

Thanks to Carsten Schmitz for pointing me in the right direction.
Last Edit: 4 years 8 months ago by ubuntourist.

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now