[Buildbot-commits] [Buildbot] #2308: change classification fallback to update fails on postgres

[Buildbot]

#2308: change classification fallback to update fails on postgres
---------------------+--------------------
Reporter:  dustin    |       Owner:
    Type:  defect    |      Status:  new
Priority:  minor     |   Milestone:  0.8.+
 Version:  0.8.6p1   |  Resolution:
Keywords:  database  |
---------------------+--------------------
Changes (by dustin):

 * milestone:  0.8.7 => 0.8.+


Comment:

 This *is* tested, and the tests pass on Postgres.  From the logs:

 {{{
 Jun  2 15:15:54 knuth postgres[23450]: [76-1] LOG:  execute
 pg8000_statement_0/pg8000_portal_0: BEGIN TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [77-1] LOG:  execute
 <unnamed>/pg8000_portal_44: INSERT INTO scheduler_changes (objectid,
 changeid, important) VALUES ($1, $2, $3)
 Jun  2 15:15:54 knuth postgres[23450]: [77-2] DETAIL:  parameters: $1 =
 '24', $2 = '3', $3 = '0'
 Jun  2 15:15:54 knuth postgres[23450]: [78-1] LOG:  execute
 pg8000_statement_1/pg8000_portal_1: COMMIT TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [79-1] LOG:  execute
 pg8000_statement_2/pg8000_portal_2: ROLLBACK TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [80-1] LOG:  execute
 pg8000_statement_0/pg8000_portal_0: BEGIN TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [81-1] LOG:  execute
 <unnamed>/pg8000_portal_45: INSERT INTO scheduler_changes (objectid,
 changeid, important) VALUES ($1, $2, $3)
 Jun  2 15:15:54 knuth postgres[23450]: [81-2] DETAIL:  parameters: $1 =
 '24', $2 = '3', $3 = '1'
 Jun  2 15:15:54 knuth postgres[23450]: [82-1] ERROR:  duplicate key value
 violates unique constraint "scheduler_changes_unique"
 Jun  2 15:15:54 knuth postgres[23450]: [82-2] STATEMENT:  INSERT INTO
 scheduler_changes (objectid, changeid, important) VALUES ($1, $2, $3)
 Jun  2 15:15:54 knuth postgres[23450]: [83-1] LOG:  execute
 pg8000_statement_2/pg8000_portal_2: ROLLBACK TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [84-1] LOG:  execute
 pg8000_statement_0/pg8000_portal_0: BEGIN TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [85-1] LOG:  execute
 <unnamed>/pg8000_portal_46: UPDATE scheduler_changes SET important=$1
 WHERE scheduler_changes.objectid = $2 AND scheduler_changes.changeid = $3
 Jun  2 15:15:54 knuth postgres[23450]: [85-2] DETAIL:  parameters: $1 =
 '1', $2 = '24', $3 = '3'
 Jun  2 15:15:54 knuth postgres[23450]: [86-1] LOG:  execute
 pg8000_statement_1/pg8000_portal_1: COMMIT TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [87-1] LOG:  execute
 pg8000_statement_2/pg8000_portal_2: ROLLBACK TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [88-1] LOG:  execute
 pg8000_statement_0/pg8000_portal_0: BEGIN TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [89-1] LOG:  execute
 <unnamed>/pg8000_portal_47: SELECT scheduler_changes.objectid,
 scheduler_changes.changeid, scheduler_changes.important
 Jun  2 15:15:54 knuth postgres[23450]: [89-2]   FROM scheduler_changes
 ORDER BY scheduler_changes.changeid
 Jun  2 15:15:54 knuth postgres[23450]: [90-1] LOG:  execute
 pg8000_statement_2/pg8000_portal_2: ROLLBACK TRANSACTION
 Jun  2 15:15:54 knuth postgres[23450]: [91-1] LOG:  execute
 pg8000_statement_0/pg8000_portal_0: BEGIN TRANSACTION
 }}}

 Possibilities:
  * sqlalchemy version (but metabuildbot tests the supported versions)
  * postgres version (I'm using 8.4)
  * postgres driver (I'm using pg8000, as the logs show)

 Harry, what versions are you using?

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2308#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation