Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 2962 by leedm...@gmail.com: Migrating from MySQL to PostgreSQL fails to properly initialize sequences
http://code.google.com/p/reviewboard/issues/detail?id=2962

What version are you running?

1.7.6

What's the URL of the page containing the problem?

/r/new/

What steps will reproduce the problem?
1. Install ReviewBoard with MySQL database backend
2. Use rb-site manage ${OLD_SITE} dumpdb to dump the database
3. Install ReviewBoard with PostgreSQL database backend
4. TRUNCATE django_content_type CASCADE
5. TRUNCATE django_content_type CASCADE
6. rb-site manage ${NEW_SITE} loaddb dumpdb.json
7. Try to add a comment, create a review, etc.

What is the expected output? What do you see instead?

If should add the comment or create the review. Instead there's a 500 error. The following errors are in the log.

2013-04-24 18:32:51,325 - ERROR - Exception thrown for user dlee at http://rbtest.digium.internal/r/new/ duplicate key value violates unique constraint "diffviewer_diffsethistory_pkey"
DETAIL:  Key (id)=(7) already exists.


What operating system are you using? What browser?

Server is Ubuntu 12.04, x86_64. Browser is Chrome on OS X.

Please provide any additional information below.

https://groups.google.com/d/msg/reviewboard/Ehv0JwthROg/OSMHZzucdKAJ

The following script seems to fix up the sequences.

psql -t ${DB} -c "SELECT E'select setval(\'' || c.relname || E'\', (select max(id)+1 from ' || replace(c.relname, '_id_seq', '') || '), false);' FROM pg_class c WHERE c.relkind = 'S';" | psql ${DB}


--
You received this message because this project is configured to send all issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

--
You received this message because you are subscribed to the Google Groups 
"reviewboard-issues" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard-issues+unsubscr...@googlegroups.com.
To post to this group, send email to reviewboard-issues@googlegroups.com.
Visit this group at http://groups.google.com/group/reviewboard-issues?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to