Ubuntu Pastebin

Paste from Colin Watson at Thu, 6 Aug 2015 08:30:15 +0000

Download as text 
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
0-1@SQL-main-master DROP TABLE IF EXISTS "temp_potemplate_holding_distribution-100000_target","temp_translationtemplateitem_holding_distribution-100000_target","temp_pofile_holding_distribution-100000_target"
----------------------------------------------------------------------
0-7@SQL-main-master 
                CREATE  TABLE "temp_potemplate_holding_distribution-100000_target" AS
                SELECT DISTINCT ON (source.id)
                    source.*, nextval('potemplate_id_seq'::regclass) AS new_id
                FROM potemplate source
                WHERE (distroseries = 14 AND iscurrent
            AND sourcepackagename NOT IN (
                SELECT sourcepackagename FROM potemplate
                WHERE distroseries = 15)
            )
                ORDER BY id
----------------------------------------------------------------------
0-3@SQL-main-master 
            CREATE UNIQUE INDEX "temp_potemplate_holding_distribution-100000_target_id"
            ON "temp_potemplate_holding_distribution-100000_target" (id)
        
----------------------------------------------------------------------
0-3@SQL-main-master 
        UPDATE "temp_potemplate_holding_distribution-100000_target"
        SET
            distroseries = 15,
            datecreated =
                timezone('UTC'::text,
                    ('now'::text)::timestamp(6) with time zone)
    
----------------------------------------------------------------------
0-3@SQL-main-master 
                CREATE  TABLE "temp_translationtemplateitem_holding_distribution-100000_target" AS
                SELECT DISTINCT ON (source.id)
                    source.*,"temp_potemplate_holding_distribution-100000_target".new_id AS new_potemplate, nextval('translationtemplateitem_id_seq'::regclass) AS new_id
                FROM translationtemplateitem source,"temp_potemplate_holding_distribution-100000_target"
                WHERE potemplate = "temp_potemplate_holding_distribution-100000_target".id AND (sequence > 0)
                ORDER BY id
----------------------------------------------------------------------
0-1@SQL-main-master UPDATE "temp_translationtemplateitem_holding_distribution-100000_target" SET potemplate = new_potemplate
----------------------------------------------------------------------
0-1@SQL-main-master ALTER TABLE "temp_translationtemplateitem_holding_distribution-100000_target" DROP COLUMN new_potemplate
----------------------------------------------------------------------
0-2@SQL-main-master 
            CREATE UNIQUE INDEX "temp_translationtemplateitem_holding_distribution-100000_target_id"
            ON "temp_translationtemplateitem_holding_distribution-100000_target" (id)
        
----------------------------------------------------------------------


Error in test lp.translations.tests.test_distroseries_translations_copy.TestDistroSeriesTranslationsCopying.test_skip_duplicates
Traceback (most recent call last):
_StringException: Traceback (most recent call last):
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/translations/tests/test_distroseries_translations_copy.py", line 158, in test_skip_duplicates
    skip_duplicates=True)
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/translations/model/distroseries_translations_copy.py", line 150, in copy_active_translations
    copier.extract('translationtemplateitem', ['potemplate'], 'sequence > 0')
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/services/database/multitablecopy.py", line 399, in extract
    self._indexIdColumn(holding_table, source_table, cur)
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/services/database/multitablecopy.py", line 501, in _indexIdColumn
    ''' % (self.getHoldingTableName(source_table, 'id'), holding_table))
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/services/database/sqlbase.py", line 609, in execute
    self._result = self._connection.execute(query)
  File "/home/cjwatson/src/canonical/launchpad/lp-sourcedeps/eggs/storm-0.19.0.99_lpwithnodatetime_r406-py2.7-linux-i686.egg/storm/databases/postgres.py", line 266, in execute
    return Connection.execute(self, statement, params, noresult)
  File "/home/cjwatson/src/canonical/launchpad/lp-sourcedeps/eggs/storm-0.19.0.99_lpwithnodatetime_r406-py2.7-linux-i686.egg/storm/database.py", line 238, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/home/cjwatson/src/canonical/launchpad/lp-sourcedeps/eggs/storm-0.19.0.99_lpwithnodatetime_r406-py2.7-linux-i686.egg/storm/databases/postgres.py", line 276, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/home/cjwatson/src/canonical/launchpad/lp-sourcedeps/eggs/storm-0.19.0.99_lpwithnodatetime_r406-py2.7-linux-i686.egg/storm/database.py", line 322, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/home/cjwatson/src/canonical/launchpad/lp-sourcedeps/eggs/storm-0.19.0.99_lpwithnodatetime_r406-py2.7-linux-i686.egg/storm/database.py", line 371, in _check_disconnect
    return function(*args, **kwargs)
  File "/home/cjwatson/src/canonical/launchpad/lp-branches/copy-translations-duplicates/lib/lp/testing/pgsql.py", line 122, in execute
    return self.real_cursor.execute(*args, **kwargs)
ProgrammingError: relation "temp_translationtemplateitem_holding_distribution-100000_target" already exists
Download as text