Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-14383

Many duplicate key on "xwikirecyclebin_pkey" during upgrade

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • None
    • 5.4.1
    • None
    • PostgreSQL 9.3 (via JNDI)
      IcedTea 7.2.3.6
      Gentoo Linux

    Description

      While upgrading “XWiki Enterprise - UI - Main wiki” from 5.2-M1 to 5.4.1 dozen of these errors appears in upgrade wizard:

      SQL Error: 0, SQLState: 23505
      ERROR: duplicate key value violates unique constraint "xwikirecyclebin_pkey" Detail: Key (xdd_id)=(16) already exists.
      

      I dunno if it’s related, but I have xwiki.store.attachment.recyclebin.hint=file.

      There’s one complete example:

      Deleted document [XWikiSyntax]
      SQL Error: 0, SQLState: 23505
      Batch entry 0 insert into xwikirecyclebin (XDD_FULLNAME, XDD_LANGUAGE, XDD_DATE, XDD_DELETER, XDD_XML, XDD_ID) values ('WorkspaceManager.WebHome', '', '2014-02-12 18:21:51.400000 +01:00:00', 'XWiki.Admin', '<?xml version="1.0" encoding="UTF-8"?> <xwikidoc> <web>WorkspaceManager</web> <name>WebHome</name> <language></language> <defaultLanguage></defaultLanguage> <translation>0</translation> <parent>Main.WebHome</parent> <creator>XWiki.Admin</creator> <author>XWiki.Admin</author> <customClass></customClass> <contentAuthor>XWiki.Admin</contentAuthor> <creationDate>1379889066000</creationDate> <date>1379889066000</date> <contentUpdateDate>1379889066000</contentUpdateDate> <version>1.1</version> <title>$services.localization.render(''workspacemanager.browse'')</title> <defaultTemplate></defaultTemplate> <validationScript></validationScript> <comment>Import</comment> <minorEdit>false</minorEdit> <syntaxId>xwiki/2.0</syntaxId> <hidden>false</hidden> <object> <class&gt; <name>XWiki.StyleSheetExtension</name> <customClass></customClass> <customMapping></customMapping> <defaultViewSheet></defaultViewSheet> <defaultEditSheet></defaultEditSheet> <defaultWeb></defaultWeb> <nameField></nameField> <validationScript></validationScript> <cache> <cache>0</cache> <disabled>0</disabled> <displayType>select</displayType> <multiSelect>0</multiSelect> <name>cache</name> <number>5</number> <prettyName>Caching policy</prettyName> <relationalStorage>0</relationalStorage> <separator> </separator> <separators> ,|</separators> <size>1</size> <unmodifiable>0</unmodifiable> <values>long|short|default|forbid</values> <classType>com.xpn.xwiki.objects.classes.StaticListClass</classType> </cache> <code> <disabled>0</disabled> <name>code</name> <number>2</number> <prettyName>Code</prettyName> <rows>20</rows> <size>50</size> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.TextAreaClass</classType> </code> <name> <disabled>0</disabled> <name>name</name> <number>1</number> <prettyName>Name</prettyName> <size>30</size> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.StringClass</classType> </name> <parse> <disabled>0</disabled> <displayFormType>select</displayFormType> <displayType>yesno</displayType> <name>parse</name> <number>4</number> <prettyName>Parse content</prettyName> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.BooleanClass</classType> </parse> <use> <cache>0</cache> <disabled>0</disabled> <displayType>select</displayType> <multiSelect>0</multiSelect> <name>use</name> <number>3</number> <prettyName>Use this extension</prettyName> <relationalStorage>0</relationalStorage> <separator> </separator> <separators> ,|</separators> <size>1</size> <unmodifiable>0</unmodifiable> <values>currentPage=Always on this page|onDemand=On demand|always=Always on this wiki</values> <classType>com.xpn.xwiki.objects.classes.StaticListClass</classType> </use> </class&gt; <name>WorkspaceManager.WebHome</name> <number>0</number> <className>XWiki.StyleSheetExtension</className> <guid>82861b9a-aff1-49cc-ad6c-8ad1dcc9df38</guid> <property> <cache>long</cache> </property> <property> <code>.actionjoin { background-image: url("$xwiki.getSkinFile(''icons/silk/user_add.png'')"); } .actionleave { background-image: url("$xwiki.getSkinFile(''icons/silk/user_delete.png'')"); } .actionrequestJoin { background-image: url("$xwiki.getSkinFile(''icons/silk/bell.png'')"); } .actioncancelJoinRequest { background-image: url("$xwiki.getSkinFile(''icons/silk/bell_delete.png'')"); } .actionviewInvitation { background-image: url("$xwiki.getSkinFile(''icons/silk/script.png'')"); }</code> </property> <property> <name></name> </property> <property> <parse>1</parse> </property> <property> <use>currentPage</use> </property> </object> <content>{{velocity}} #set($columns = [''wikiprettyname'', ''description'', ''owner'', ''membershipType'']) #set($columnsProperties = { ''wikiprettyname'' : { ''type'' : ''text'', ''link'' : ''field'' }, ''description'' : { ''type'' : ''text'' , ''size'' : 50 }, ''owner'' : { ''type'' : ''text'', ''size'' : 10, ''html'' : ''true'' }, ''membershipType'' : { ''type'' : ''text'', ''class'' : ''WorkspaceManager.WorkspaceClass''} }) #set($options = { ''className'' : ''XWiki.XWikiServerClass'', ''rowCount'' : 10, ''resultPage'' : ''WorkspaceManager.BrowseWorkspacesLiveTableResults'', ''translationPrefix'' : ''workspacemanager.browse.'' }) #if(!$isGuest) #set($discard = $columns.add(''_actions'')) #set($discard = $columnsProperties.put(''_actions'', { ''actions'' : [''join'', ''requestJoin'', ''cancelJoinRequest'', ''viewInvitation'', ''leave'', ''delete''] })) #end #if($hasCreateWiki) [[{{translation key="platform.workspace.createNewWorkspaceLabel"/}}&gt;&gt;CreateNewWorkspace]] #end #livetable(''workspaces'', $columns, $columnsProperties, $options) {{/velocity}}</content> <versions>head 1.1; access; symbols; locks; strict; comment @# @; 1.1 date 2013.09.23.00.31.06; author XWiki_2EAdmin; state full; branches; next ; desc @@ 1.1 log @Import @ text @&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;xwikidoc&gt; &lt;web&gt;WorkspaceManager&lt;/web&gt; &lt;name&gt;WebHome&lt;/name&gt; &lt;language&gt;&lt;/language&gt; &lt;defaultLanguage&gt;&lt;/defaultLanguage&gt; &lt;translation&gt;0&lt;/translation&gt; &lt;parent&gt;Main.WebHome&lt;/parent&gt; &lt;creator&gt;XWiki.Admin&lt;/creator&gt; &lt;author&gt;XWiki.Admin&lt;/author&gt; &lt;customClass&gt;&lt;/customClass&gt; &lt;contentAuthor&gt;XWiki.Admin&lt;/contentAuthor&gt; &lt;creationDate&gt;1379889066000&lt;/creationDate&gt; &lt;date&gt;1379889066000&lt;/date&gt; &lt;contentUpdateDate&gt;1379889066000&lt;/contentUpdateDate&gt; &lt;version&gt;1.1&lt;/version&gt; &lt;title&gt;$services.localization.render(''workspacemanager.browse'')&lt;/title&gt; &lt;defaultTemplate&gt;&lt;/defaultTemplate&gt; &lt;validationScript&gt;&lt;/validationScript&gt; &lt;comment&gt;Import&lt;/comment&gt; &lt;minorEdit&gt;false&lt;/minorEdit&gt; &lt;syntaxId&gt;xwiki/2.0&lt;/syntaxId&gt; &lt;hidden&gt;false&lt;/hidden&gt; &lt;object&gt; &lt;class&amp;gt; &lt;name&gt;XWiki.StyleSheetExtension&lt;/name&gt; &lt;customClass&gt;&lt;/customClass&gt; &lt;customMapping&gt;&lt;/customMapping&gt; &lt;defaultViewSheet&gt;&lt;/defaultViewSheet&gt; &lt;defaultEditSheet&gt;&lt;/defaultEditSheet&gt; &lt;defaultWeb&gt;&lt;/defaultWeb&gt; &lt;nameField&gt;&lt;/nameField&gt; &lt;validationScript&gt;&lt;/validationScript&gt; &lt;cache&gt; &lt;cache&gt;0&lt;/cache&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayType&gt;select&lt;/displayType&gt; &lt;multiSelect&gt;0&lt;/multiSelect&gt; &lt;name&gt;cache&lt;/name&gt; &lt;number&gt;5&lt;/number&gt; &lt;prettyName&gt;Caching policy&lt;/prettyName&gt; &lt;relationalStorage&gt;0&lt;/relationalStorage&gt; &lt;separator&gt; &lt;/separator&gt; &lt;separators&gt; ,|&lt;/separators&gt; &lt;size&gt;1&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;values&gt;long|short|default|forbid&lt;/values&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StaticListClass&lt;/classType&gt; &lt;/cache&gt; &lt;code&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;name&gt;code&lt;/name&gt; &lt;number&gt;2&lt;/number&gt; &lt;prettyName&gt;Code&lt;/prettyName&gt; &lt;rows&gt;20&lt;/rows&gt; &lt;size&gt;50&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.TextAreaClass&lt;/classType&gt; &lt;/code&gt; &lt;name&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;name&gt;name&lt;/name&gt; &lt;number&gt;1&lt;/number&gt; &lt;prettyName&gt;Name&lt;/prettyName&gt; &lt;size&gt;30&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StringClass&lt;/classType&gt; &lt;/name&gt; &lt;parse&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayFormType&gt;select&lt;/displayFormType&gt; &lt;displayType&gt;yesno&lt;/displayType&gt; &lt;name&gt;parse&lt;/name&gt; &lt;number&gt;4&lt;/number&gt; &lt;prettyName&gt;Parse content&lt;/prettyName&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.BooleanClass&lt;/classType&gt; &lt;/parse&gt; &lt;use&gt; &lt;cache&gt;0&lt;/cache&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayType&gt;select&lt;/displayType&gt; &lt;multiSelect&gt;0&lt;/multiSelect&gt; &lt;name&gt;use&lt;/name&gt; &lt;number&gt;3&lt;/number&gt; &lt;prettyName&gt;Use this extension&lt;/prettyName&gt; &lt;relationalStorage&gt;0&lt;/relationalStorage&gt; &lt;separator&gt; &lt;/separator&gt; &lt;separators&gt; ,|&lt;/separators&gt; &lt;size&gt;1&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;values&gt;currentPage=Always on this page|onDemand=On demand|always=Always on this wiki&lt;/values&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StaticListClass&lt;/classType&gt; &lt;/use&gt; &lt;/class&amp;gt; &lt;name&gt;WorkspaceManager.WebHome&lt;/name&gt; &lt;number&gt;0&lt;/number&gt; &lt;className&gt;XWiki.StyleSheetExtension&lt;/className&gt; &lt;guid&gt;82861b9a-aff1-49cc-ad6c-8ad1dcc9df38&lt;/guid&gt; &lt;property&gt; &lt;cache&gt;long&lt;/cache&gt; &lt;/property&gt; &lt;property&gt; &lt;code&gt;.actionjoin { background-image: url("$xwiki.getSkinFile(''icons/silk/user_add.png'')"); } .actionleave { background-image: url("$xwiki.getSkinFile(''icons/silk/user_delete.png'')"); } .actionrequestJoin { background-image: url("$xwiki.getSkinFile(''icons/silk/bell.png'')"); } .actioncancelJoinRequest { background-image: url("$xwiki.getSkinFile(''icons/silk/bell_delete.png'')"); } .actionviewInvitation { background-image: url("$xwiki.getSkinFile(''icons/silk/script.png'')"); }&lt;/code&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;&lt;/name&gt; &lt;/property&gt; &lt;property&gt; &lt;parse&gt;1&lt;/parse&gt; &lt;/property&gt; &lt;property&gt; &lt;use&gt;currentPage&lt;/use&gt; &lt;/property&gt; &lt;/object&gt; &lt;content&gt;{{velocity}} #set($columns = [''wikiprettyname'', ''description'', ''owner'', ''membershipType'']) #set($columnsProperties = { ''wikiprettyname'' : { ''type'' : ''text'', ''link'' : ''field'' }, ''description'' : { ''type'' : ''text'' , ''size'' : 50 }, ''owner'' : { ''type'' : ''text'', ''size'' : 10, ''html'' : ''true'' }, ''membershipType'' : { ''type'' : ''text'', ''class'' : ''WorkspaceManager.WorkspaceClass''} }) #set($options = { ''className'' : ''XWiki.XWikiServerClass'', ''rowCount'' : 10, ''resultPage'' : ''WorkspaceManager.BrowseWorkspacesLiveTableResults'', ''translationPrefix'' : ''workspacemanager.browse.'' }) #if(!$isGuest) #set($discard = $columns.add(''_actions'')) #set($discard = $columnsProperties.put(''_actions'', { ''actions'' : [''join'', ''requestJoin'', ''cancelJoinRequest'', ''viewInvitation'', ''leave'', ''delete''] })) #end #if($hasCreateWiki) [[{{translation key="platform.workspace.createNewWorkspaceLabel"/}}&amp;gt;&amp;gt;CreateNewWorkspace]] #end #livetable(''workspaces'', $columns, $columnsProperties, $options) {{/velocity}}&lt;/content&gt;&lt;/xwikidoc&gt; @ </versions></xwikidoc>', 16) was aborted. Call getNextException to see the cause.
      SQL Error: 0, SQLState: 23505
      ERROR: duplicate key value violates unique constraint "xwikirecyclebin_pkey" Detail: Key (xdd_id)=(16) already exists.
      Batch entry 0 insert into xwikirecyclebin (XDD_FULLNAME, XDD_LANGUAGE, XDD_DATE, XDD_DELETER, XDD_XML, XDD_ID) values ('WorkspaceManager.WebHome', '', '2014-02-12 18:21:51.400000 +01:00:00', 'XWiki.Admin', '<?xml version="1.0" encoding="UTF-8"?> <xwikidoc> <web>WorkspaceManager</web> <name>WebHome</name> <language></language> <defaultLanguage></defaultLanguage> <translation>0</translation> <parent>Main.WebHome</parent> <creator>XWiki.Admin</creator> <author>XWiki.Admin</author> <customClass></customClass> <contentAuthor>XWiki.Admin</contentAuthor> <creationDate>1379889066000</creationDate> <date>1379889066000</date> <contentUpdateDate>1379889066000</contentUpdateDate> <version>1.1</version> <title>$services.localization.render(''workspacemanager.browse'')</title> <defaultTemplate></defaultTemplate> <validationScript></validationScript> <comment>Import</comment> <minorEdit>false</minorEdit> <syntaxId>xwiki/2.0</syntaxId> <hidden>false</hidden> <object> <class&gt; <name>XWiki.StyleSheetExtension</name> <customClass></customClass> <customMapping></customMapping> <defaultViewSheet></defaultViewSheet> <defaultEditSheet></defaultEditSheet> <defaultWeb></defaultWeb> <nameField></nameField> <validationScript></validationScript> <cache> <cache>0</cache> <disabled>0</disabled> <displayType>select</displayType> <multiSelect>0</multiSelect> <name>cache</name> <number>5</number> <prettyName>Caching policy</prettyName> <relationalStorage>0</relationalStorage> <separator> </separator> <separators> ,|</separators> <size>1</size> <unmodifiable>0</unmodifiable> <values>long|short|default|forbid</values> <classType>com.xpn.xwiki.objects.classes.StaticListClass</classType> </cache> <code> <disabled>0</disabled> <name>code</name> <number>2</number> <prettyName>Code</prettyName> <rows>20</rows> <size>50</size> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.TextAreaClass</classType> </code> <name> <disabled>0</disabled> <name>name</name> <number>1</number> <prettyName>Name</prettyName> <size>30</size> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.StringClass</classType> </name> <parse> <disabled>0</disabled> <displayFormType>select</displayFormType> <displayType>yesno</displayType> <name>parse</name> <number>4</number> <prettyName>Parse content</prettyName> <unmodifiable>0</unmodifiable> <classType>com.xpn.xwiki.objects.classes.BooleanClass</classType> </parse> <use> <cache>0</cache> <disabled>0</disabled> <displayType>select</displayType> <multiSelect>0</multiSelect> <name>use</name> <number>3</number> <prettyName>Use this extension</prettyName> <relationalStorage>0</relationalStorage> <separator> </separator> <separators> ,|</separators> <size>1</size> <unmodifiable>0</unmodifiable> <values>currentPage=Always on this page|onDemand=On demand|always=Always on this wiki</values> <classType>com.xpn.xwiki.objects.classes.StaticListClass</classType> </use> </class&gt; <name>WorkspaceManager.WebHome</name> <number>0</number> <className>XWiki.StyleSheetExtension</className> <guid>82861b9a-aff1-49cc-ad6c-8ad1dcc9df38</guid> <property> <cache>long</cache> </property> <property> <code>.actionjoin { background-image: url("$xwiki.getSkinFile(''icons/silk/user_add.png'')"); } .actionleave { background-image: url("$xwiki.getSkinFile(''icons/silk/user_delete.png'')"); } .actionrequestJoin { background-image: url("$xwiki.getSkinFile(''icons/silk/bell.png'')"); } .actioncancelJoinRequest { background-image: url("$xwiki.getSkinFile(''icons/silk/bell_delete.png'')"); } .actionviewInvitation { background-image: url("$xwiki.getSkinFile(''icons/silk/script.png'')"); }</code> </property> <property> <name></name> </property> <property> <parse>1</parse> </property> <property> <use>currentPage</use> </property> </object> <content>{{velocity}} #set($columns = [''wikiprettyname'', ''description'', ''owner'', ''membershipType'']) #set($columnsProperties = { ''wikiprettyname'' : { ''type'' : ''text'', ''link'' : ''field'' }, ''description'' : { ''type'' : ''text'' , ''size'' : 50 }, ''owner'' : { ''type'' : ''text'', ''size'' : 10, ''html'' : ''true'' }, ''membershipType'' : { ''type'' : ''text'', ''class'' : ''WorkspaceManager.WorkspaceClass''} }) #set($options = { ''className'' : ''XWiki.XWikiServerClass'', ''rowCount'' : 10, ''resultPage'' : ''WorkspaceManager.BrowseWorkspacesLiveTableResults'', ''translationPrefix'' : ''workspacemanager.browse.'' }) #if(!$isGuest) #set($discard = $columns.add(''_actions'')) #set($discard = $columnsProperties.put(''_actions'', { ''actions'' : [''join'', ''requestJoin'', ''cancelJoinRequest'', ''viewInvitation'', ''leave'', ''delete''] })) #end #if($hasCreateWiki) [[{{translation key="platform.workspace.createNewWorkspaceLabel"/}}&gt;&gt;CreateNewWorkspace]] #end #livetable(''workspaces'', $columns, $columnsProperties, $options) {{/velocity}}</content> <versions>head 1.1; access; symbols; locks; strict; comment @# @; 1.1 date 2013.09.23.00.31.06; author XWiki_2EAdmin; state full; branches; next ; desc @@ 1.1 log @Import @ text @&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;xwikidoc&gt; &lt;web&gt;WorkspaceManager&lt;/web&gt; &lt;name&gt;WebHome&lt;/name&gt; &lt;language&gt;&lt;/language&gt; &lt;defaultLanguage&gt;&lt;/defaultLanguage&gt; &lt;translation&gt;0&lt;/translation&gt; &lt;parent&gt;Main.WebHome&lt;/parent&gt; &lt;creator&gt;XWiki.Admin&lt;/creator&gt; &lt;author&gt;XWiki.Admin&lt;/author&gt; &lt;customClass&gt;&lt;/customClass&gt; &lt;contentAuthor&gt;XWiki.Admin&lt;/contentAuthor&gt; &lt;creationDate&gt;1379889066000&lt;/creationDate&gt; &lt;date&gt;1379889066000&lt;/date&gt; &lt;contentUpdateDate&gt;1379889066000&lt;/contentUpdateDate&gt; &lt;version&gt;1.1&lt;/version&gt; &lt;title&gt;$services.localization.render(''workspacemanager.browse'')&lt;/title&gt; &lt;defaultTemplate&gt;&lt;/defaultTemplate&gt; &lt;validationScript&gt;&lt;/validationScript&gt; &lt;comment&gt;Import&lt;/comment&gt; &lt;minorEdit&gt;false&lt;/minorEdit&gt; &lt;syntaxId&gt;xwiki/2.0&lt;/syntaxId&gt; &lt;hidden&gt;false&lt;/hidden&gt; &lt;object&gt; &lt;class&amp;gt; &lt;name&gt;XWiki.StyleSheetExtension&lt;/name&gt; &lt;customClass&gt;&lt;/customClass&gt; &lt;customMapping&gt;&lt;/customMapping&gt; &lt;defaultViewSheet&gt;&lt;/defaultViewSheet&gt; &lt;defaultEditSheet&gt;&lt;/defaultEditSheet&gt; &lt;defaultWeb&gt;&lt;/defaultWeb&gt; &lt;nameField&gt;&lt;/nameField&gt; &lt;validationScript&gt;&lt;/validationScript&gt; &lt;cache&gt; &lt;cache&gt;0&lt;/cache&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayType&gt;select&lt;/displayType&gt; &lt;multiSelect&gt;0&lt;/multiSelect&gt; &lt;name&gt;cache&lt;/name&gt; &lt;number&gt;5&lt;/number&gt; &lt;prettyName&gt;Caching policy&lt;/prettyName&gt; &lt;relationalStorage&gt;0&lt;/relationalStorage&gt; &lt;separator&gt; &lt;/separator&gt; &lt;separators&gt; ,|&lt;/separators&gt; &lt;size&gt;1&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;values&gt;long|short|default|forbid&lt;/values&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StaticListClass&lt;/classType&gt; &lt;/cache&gt; &lt;code&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;name&gt;code&lt;/name&gt; &lt;number&gt;2&lt;/number&gt; &lt;prettyName&gt;Code&lt;/prettyName&gt; &lt;rows&gt;20&lt;/rows&gt; &lt;size&gt;50&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.TextAreaClass&lt;/classType&gt; &lt;/code&gt; &lt;name&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;name&gt;name&lt;/name&gt; &lt;number&gt;1&lt;/number&gt; &lt;prettyName&gt;Name&lt;/prettyName&gt; &lt;size&gt;30&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StringClass&lt;/classType&gt; &lt;/name&gt; &lt;parse&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayFormType&gt;select&lt;/displayFormType&gt; &lt;displayType&gt;yesno&lt;/displayType&gt; &lt;name&gt;parse&lt;/name&gt; &lt;number&gt;4&lt;/number&gt; &lt;prettyName&gt;Parse content&lt;/prettyName&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.BooleanClass&lt;/classType&gt; &lt;/parse&gt; &lt;use&gt; &lt;cache&gt;0&lt;/cache&gt; &lt;disabled&gt;0&lt;/disabled&gt; &lt;displayType&gt;select&lt;/displayType&gt; &lt;multiSelect&gt;0&lt;/multiSelect&gt; &lt;name&gt;use&lt;/name&gt; &lt;number&gt;3&lt;/number&gt; &lt;prettyName&gt;Use this extension&lt;/prettyName&gt; &lt;relationalStorage&gt;0&lt;/relationalStorage&gt; &lt;separator&gt; &lt;/separator&gt; &lt;separators&gt; ,|&lt;/separators&gt; &lt;size&gt;1&lt;/size&gt; &lt;unmodifiable&gt;0&lt;/unmodifiable&gt; &lt;values&gt;currentPage=Always on this page|onDemand=On demand|always=Always on this wiki&lt;/values&gt; &lt;classType&gt;com.xpn.xwiki.objects.classes.StaticListClass&lt;/classType&gt; &lt;/use&gt; &lt;/class&amp;gt; &lt;name&gt;WorkspaceManager.WebHome&lt;/name&gt; &lt;number&gt;0&lt;/number&gt; &lt;className&gt;XWiki.StyleSheetExtension&lt;/className&gt; &lt;guid&gt;82861b9a-aff1-49cc-ad6c-8ad1dcc9df38&lt;/guid&gt; &lt;property&gt; &lt;cache&gt;long&lt;/cache&gt; &lt;/property&gt; &lt;property&gt; &lt;code&gt;.actionjoin { background-image: url("$xwiki.getSkinFile(''icons/silk/user_add.png'')"); } .actionleave { background-image: url("$xwiki.getSkinFile(''icons/silk/user_delete.png'')"); } .actionrequestJoin { background-image: url("$xwiki.getSkinFile(''icons/silk/bell.png'')"); } .actioncancelJoinRequest { background-image: url("$xwiki.getSkinFile(''icons/silk/bell_delete.png'')"); } .actionviewInvitation { background-image: url("$xwiki.getSkinFile(''icons/silk/script.png'')"); }&lt;/code&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;&lt;/name&gt; &lt;/property&gt; &lt;property&gt; &lt;parse&gt;1&lt;/parse&gt; &lt;/property&gt; &lt;property&gt; &lt;use&gt;currentPage&lt;/use&gt; &lt;/property&gt; &lt;/object&gt; &lt;content&gt;{{velocity}} #set($columns = [''wikiprettyname'', ''description'', ''owner'', ''membershipType'']) #set($columnsProperties = { ''wikiprettyname'' : { ''type'' : ''text'', ''link'' : ''field'' }, ''description'' : { ''type'' : ''text'' , ''size'' : 50 }, ''owner'' : { ''type'' : ''text'', ''size'' : 10, ''html'' : ''true'' }, ''membershipType'' : { ''type'' : ''text'', ''class'' : ''WorkspaceManager.WorkspaceClass''} }) #set($options = { ''className'' : ''XWiki.XWikiServerClass'', ''rowCount'' : 10, ''resultPage'' : ''WorkspaceManager.BrowseWorkspacesLiveTableResults'', ''translationPrefix'' : ''workspacemanager.browse.'' }) #if(!$isGuest) #set($discard = $columns.add(''_actions'')) #set($discard = $columnsProperties.put(''_actions'', { ''actions'' : [''join'', ''requestJoin'', ''cancelJoinRequest'', ''viewInvitation'', ''leave'', ''delete''] })) #end #if($hasCreateWiki) [[{{translation key="platform.workspace.createNewWorkspaceLabel"/}}&amp;gt;&amp;gt;CreateNewWorkspace]] #end #livetable(''workspaces'', $columns, $columnsProperties, $options) {{/velocity}}&lt;/content&gt;&lt;/xwikidoc&gt; @ </versions></xwikidoc>', 16) was aborted. Call getNextException to see the cause.
      SQL Error: 0, SQLState: 25P02
      ERROR: current transaction is aborted, commands ignored until end of transaction block
      

      Attachments

        Activity

          People

            tmortagne Thomas Mortagne
            jirutka Jakub Jirutka
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: