topic Re: 3.4a upgrade problem: relation 'avm_stores_seq' already exis in Alfresco Archive

3.4a upgrade problem: relation 'avm_stores_seq' already exis

jturmelle — Wed, 20 Oct 2010 17:43:04 GMT

Sorry for the repeat-post, please see http://forums.alfresco.com/en/viewtopic.php?f=8&t=35327#p102607The search functionality of the forums didn't show me the related message.I just tried to upgrade my community edition from 3.3.0 to 3.4a and had the following error: org.postgresql.util.PSQLExce

Re: 3.4a upgrade problem: relation 'avm_stores_seq' already exis

derek — Fri, 22 Oct 2010 23:49:28 GMT

Hi,
It appears that the patch is running when it should not.
Please post the bit of the startup log giving the Alfresco version from BEFORE the upgrade, so that we can fix this. Better still, raise a JIRA ticket with those details and the details you gave here. If all the sequences are already present, then you can bypass the patch by marking it as executed.
Locate the file that was being executed
Copy the bit at the bottom where the row is inserted into the alf_applied_patch table.
Go back to pre-upgrade data.
Run the SQL you copied i.e. mark the script as completed already.
Upgrade again and the script will think that it should not run (which it appears it should not).

Please report the issue in JIRA with appropriate details so that we can sort it out.

Re: 3.4a upgrade problem: relation 'avm_stores_seq' already exis

derek — Sat, 23 Oct 2010 00:09:16 GMT

Actually, I've already raised it: http://issues.alfresco.com/jira/browse/ALF-5344

Re: 3.4a upgrade problem: relation 'avm_stores_seq' already exis

derek — Sat, 23 Oct 2010 00:47:04 GMT

Please post the version details of the server from before the upgrade. Those sequences were only introduced in 3.4 (before that the inserts used the 'hibernate_sequence') so we'll need a bit more history of the upgrades.

Re: 3.4a upgrade problem: relation 'avm_stores_seq' already exis

jturmelle — Mon, 25 Oct 2010 14:32:20 GMT

Is this the string you're looking for:

16:44:38,238  INFO  [service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.3.0 (g 2860) schema 4100 - Originally installed version 3.2.0 (r2 2440) schema 3300
‍‍