Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-15319

Database update v310\style_update_p2 fails to drop sequences

    XMLWordPrintable

Details

    Description

      During upgrade process I get following errors

      [13-Aug-2017 11:04:40 UTC] PHP Fatal error: SQL ERROR [ postgres ]<br /><br />ERROR: sequence "phpbb3_styles_imageset_data_seq" does not exist []<br /><br />SQL<br /><br />DROP SEQUENCE phpbb3_styles_imageset_data_seq;
      in /var/www/html/phpbb/db/driver/driver.php on line 999
      

      for phpbb3_styles_imageset_data_seq, phpbb3_styles_imageset_seq, phpbb3_styles_template_data_seq, phpbb3_styles_template_seq, phpbb3_styles_theme_seq sequences.

      It looks that these sequences may drop automatically after DROP TABLE <tablename>; because these errors happen only once per sequence; after restarting migration process everything goes fine.

      To prevent these errors we can use DROP SEQUENCE IF EXISTS as a more robust solution.

      Attachments

        Activity

          People

            Marc Marc
            Tarzanych Tarzanych [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: