[xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Hello ,

I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
oracle).

When I try to see the deleted attachments from the 'xwiki list of documents ', 
I got this error (see bellow).

There is just 2 deleted doc in the table;

I tried to save the page with admin account (who has programming rights), still 
 the same.

Any idea?

BR

Patrick




Failed to execute the [velocity] macro
org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity 
Macro for content [#if(!$xwiki.hasProgrammingRights())
  {{warning}}This document requires programming rights and needs to be saved by 
an administrator of this Wiki{{/warning}}
#else
#set($dateFormat = '  d, HH:mm')
#if(!$request.list)
$xwiki.ssx.use('XWiki.DeletedAttachments')##
$xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})##
##
#set($columns = ['datt.filename', 'datt.docName', 'datt.date', 'datt.deleter', 
'actions'])
#set($columnProperties = {
'datt.filename'  : { 'type' : 'text', 'size' : 10 },
'datt.docName'   : { 'type' : 'text', 'size' : 10 },
'datt.date'  : { 'type' : 'date', 'filterable' : false },
'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
false }
  })##
#set($options = {
'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
'list=1xpage=plainoutputSyntax=plain'),
   'callback'  : 'XWiki.index.trash.attachments.displayEntry',
'translationPrefix' : 'platform.index.trashAttachments.'
  })##
##
##
##
{{html wiki=true clean=false}}
div class=hidden
#livetable('attachmentTrash' $columns $columnProperties $options)
/div
{{/html}}

{{html wiki=true clean=false}}
noscript

  #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
DeletedAttachment as datt').execute().get(0))
  #if($deletedAttachments == 0)


{{info}}$services.localization.render('platform.index.trashAttachmentsEmpty'){{/info}}

  #else
  #macro(displayDeletedAttachment $id)
#set($datt = $xwiki.getDeletedAttachment($id))
#set($originalAttachment = $datt.getAttachment())
#set($originalDocument = $xwiki.getDocument($datt.docName))
tr
  tda 
href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename, 
$originalAttachment.version, rid=${datt.id}).replaceAll('', 
'amp;')$escapetool.xml($datt.filename)/a/td
  tda 
href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle) 
($escapetool.xml(${originalDocument.fullName}))/a/td
  td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
  td$xwiki.getUserName($datt.getDeleter())/td
  td class=itemActions
#if($datt.canDelete())
  a href=${originalDocument.getAttachmentURL($datt.filename, 
'delattachment', 
trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
 class=tool delete 
title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
#end
  /td
/tr
  #end
##
  #if($!{request.view} == '')
#set($queryParams = '')
  #else
#set($queryParams = view=$!{escapetool.url($request.view)})
  #end
  #set($paginationParameters = {
'totalItems' : $services.query.hql('select count(datt.id) from 
DeletedAttachment as datt').execute().get(0),
'defaultItemsPerPage' : 15,
'url' : $doc.getURL('view', $queryParams)
  })
  #pagination($paginationParameters)
  table id=searchResults class=xwiki-livetable xwiki-livetable-display
thead class=xwiki-livetable-display-headertr
  th scope=col class=xwiki-livetable-display-header-text selected 
asc$services.localization.render('platform.index.trashAttachments.datt.filename')/th
  th scope=col 
class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.docName')/th
  th scope=col 
class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.date')/th
  th scope=col 
class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.deleter')/th
  th scope=col 
class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.actions')/th
/tr/thead
tbody class=xwiki-livetable-display-body
#set ($query = $services.query.hql('select datt.id from DeletedAttachment 
as datt order by datt.filename asc'))
#foreach($item in 
$query.setLimit($paginationParameters.itemsPerPage).setOffset($paginationParameters.firstItem).execute())
  #displayDeletedAttachment($item)
#end
/tbody
  /table
  #set($discard = $paginationParameters.put('position', 'bottom'))
  #pagination($paginationParameters)
  #end ## deletedAttachments != 0
/noscript
{{/html}}##
#else ## request.list
## 

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to
say what exactly is the cause, you might want to look at
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick
patrick.mo...@curia.europa.eu wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to be saved 
 by an administrator of this Wiki{{/warning}}
 #else
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})##
 ##
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
 'datt.deleter', 'actions'])
 #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
 false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options)
 /div
 {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)

 
 {{info}}$services.localization.render('platform.index.trashAttachmentsEmpty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
  class=tool delete 
 title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
 #end
   /td
 /tr
   #end
 ##
   #if($!{request.view} == '')
 #set($queryParams = '')
   #else
 #set($queryParams = view=$!{escapetool.url($request.view)})
   #end
   #set($paginationParameters = {
 'totalItems' : $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0),
 'defaultItemsPerPage' : 15,
 'url' : $doc.getURL('view', $queryParams)
   })
   #pagination($paginationParameters)
   table id=searchResults class=xwiki-livetable xwiki-livetable-display
 thead class=xwiki-livetable-display-headertr
   th scope=col class=xwiki-livetable-display-header-text selected 
 asc$services.localization.render('platform.index.trashAttachments.datt.filename')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.docName')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.date')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.deleter')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.actions')/th
 /tr/thead
 tbody class=xwiki-livetable-display-body
 #set ($query = $services.query.hql('select datt.id from DeletedAttachment 
 as datt order by datt.filename asc'))
 #foreach($item in 
 

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Thanks Thomas,

I'll look that because we have made some test with those JAVAOPTS parameters 
for massive import :

-Xms3072m
-Xmx3072m
-XX:MaxPermSize=256M

Seems not good :)


I'll try with those one  :




-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 9:43
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to say what 
exactly is the cause, you might want to look at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick patrick.mo...@curia.europa.eu 
wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to be 
 saved by an administrator of this Wiki{{/warning}} #else 
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
 'datt.deleter', 'actions']) #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
 false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options) 
 /div {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)

 
 {{info}}$services.localization.render('platform.index.trashAttachments
 Empty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
  class=tool delete 
 title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
 #end
   /td
 /tr
   #end
 ##
   #if($!{request.view} == '')
 #set($queryParams = '')
   #else
 #set($queryParams = view=$!{escapetool.url($request.view)})
   #end
   #set($paginationParameters = {
 'totalItems' : $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0),
 'defaultItemsPerPage' : 15,
 'url' : $doc.getURL('view', $queryParams)
   })
   #pagination($paginationParameters)
   table id=searchResults class=xwiki-livetable xwiki-livetable-display
 thead class=xwiki-livetable-display-headertr
   th scope=col class=xwiki-livetable-display-header-text selected 
 asc$services.localization.render('platform.index.trashAttachments.datt.filename')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.docName')/th
   th scope=col 
 class=xwiki-livetable-display-header-text$services.localization.render('platform.index.trashAttachments.datt.date')/th
   th scope=col 
 class=xwiki-livetable-display

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Thanks Thomas,

I'll look that because we have made some test with those JAVAOPTS parameters 
for massive import :


-Xms3072m
-Xmx3072m
-XX:MaxPermSize=256M

Seems not good , I f you have any idea to optimize memory  tuning for Xwiki 6.1 
on solaris (tomcat oracle) with around 100-150 concurent users


I'll try with those one  :
-d64
-Xms1536m
-Xmx1536m
-XX:MaxPermSize=200M
-XX:+UseConcMarkSweepGC
-Dfile.encoding=utf-8
-Dxwiki.data.dir=/opt/curia/wikidgt/data/
-Doracle.net.tns_admin=${TNS_ADMIN}



-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 9:43
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to say what 
exactly is the cause, you might want to look at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick patrick.mo...@curia.europa.eu 
wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to be 
 saved by an administrator of this Wiki{{/warning}} #else 
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
 'datt.deleter', 'actions']) #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
 false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options) 
 /div {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)

 
 {{info}}$services.localization.render('platform.index.trashAttachments
 Empty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
  class=tool delete 
 title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
 #end
   /td
 /tr
   #end
 ##
   #if($!{request.view} == '')
 #set($queryParams = '')
   #else
 #set($queryParams = view=$!{escapetool.url($request.view)})
   #end
   #set($paginationParameters = {
 'totalItems' : $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0),
 'defaultItemsPerPage' : 15,
 'url' : $doc.getURL('view', $queryParams)
   })
   #pagination($paginationParameters)
   table id=searchResults class=xwiki-livetable xwiki-livetable-display
 thead class=xwiki-livetable-display-headertr
   th scope=col class=xwiki-livetable-display-header-text selected 
 asc$services.localization.render('platform.index.trashAttachments.datt.filename')/th
   th scope=col 
 class=xwiki

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
Well the one you tries should me enough for most use case.

How big is the attachment you are trying to delete ? Your issue might
be related to http://jira.xwiki.org/browse/XWIKI-8910.

On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick
patrick.mo...@curia.europa.eu wrote:
 Thanks Thomas,

 I'll look that because we have made some test with those JAVAOPTS parameters 
 for massive import :


 -Xms3072m
 -Xmx3072m
 -XX:MaxPermSize=256M

 Seems not good , I f you have any idea to optimize memory  tuning for Xwiki 
 6.1 on solaris (tomcat oracle) with around 100-150 concurent users


 I'll try with those one  :
 -d64
 -Xms1536m
 -Xmx1536m
 -XX:MaxPermSize=200M
 -XX:+UseConcMarkSweepGC
 -Dfile.encoding=utf-8
 -Dxwiki.data.dir=/opt/curia/wikidgt/data/
 -Doracle.net.tns_admin=${TNS_ADMIN}



 -Original Message-
 From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
 Sent: mardi 16 septembre 2014 9:43
 To: XWiki Users
 Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

 The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to say what 
 exactly is the cause, you might want to look at 
 http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

 On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
 patrick.mo...@curia.europa.eu wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to be
 saved by an administrator of this Wiki{{/warning}} #else
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ##
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date',
 'datt.deleter', 'actions']) #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
 false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options)
 /div {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)


 {{info}}$services.localization.render('platform.index.trashAttachments
 Empty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
  class=tool delete 
 title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
 #end
   /td
 /tr
   #end
 ##
   #if($!{request.view} == '')
 #set($queryParams = '')
   #else
 #set($queryParams = view=$!{escapetool.url($request.view)})
   #end
   #set($paginationParameters = {
 'totalItems' : $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0),
 'defaultItemsPerPage' : 15,
 'url' : $doc.getURL('view', $queryParams)
   })
   #pagination($paginationParameters)
   table id=searchResults class

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Moens Patrick
Between 50-70 mo

But its before trying to deleted them. It's when I open the deleted attachments 
page.

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
Sent: mardi 16 septembre 2014 10:11
To: XWiki Users
Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

Well the one you tries should me enough for most use case.

How big is the attachment you are trying to delete ? Your issue might be 
related to http://jira.xwiki.org/browse/XWIKI-8910.

On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick patrick.mo...@curia.europa.eu 
wrote:
 Thanks Thomas,

 I'll look that because we have made some test with those JAVAOPTS parameters 
 for massive import :


 -Xms3072m
 -Xmx3072m
 -XX:MaxPermSize=256M

 Seems not good , I f you have any idea to optimize memory  tuning for 
 Xwiki 6.1 on solaris (tomcat oracle) with around 100-150 concurent 
 users


 I'll try with those one  :
 -d64
 -Xms1536m
 -Xmx1536m
 -XX:MaxPermSize=200M
 -XX:+UseConcMarkSweepGC
 -Dfile.encoding=utf-8
 -Dxwiki.data.dir=/opt/curia/wikidgt/data/
 -Doracle.net.tns_admin=${TNS_ADMIN}



 -Original Message-
 From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas 
 Mortagne
 Sent: mardi 16 septembre 2014 9:43
 To: XWiki Users
 Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

 The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to say what 
 exactly is the cause, you might want to look at 
 http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

 On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
 patrick.mo...@curia.europa.eu wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to 
 be saved by an administrator of this Wiki{{/warning}} #else 
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ## 
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date', 
 'datt.deleter', 'actions']) #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' : 
 false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 'view', 
 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options) 
 /div {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) from 
 DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)


 {{info}}$services.localization.render('platform.index.trashAttachment
 s
 Empty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url($!request.getQueryString()))}
  class=tool delete 
 title=$services.localization.render('platform.index.trashAttachmentsActionsDeleteTooltip')$services.localization.render('platform.index.trashAttachmentsDeleteText')/a
 #end
   /td
 /tr
   #end
 ##
   #if($!{request.view} == '')
 #set($queryParams = '')
   #else
 #set($queryParams = view

Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

2014-09-16 Thread Thomas Mortagne
Deleted attachments management is not very efficient (mostly for the
reasons described in http://jira.xwiki.org/browse/XWIKI-8910.), AFAIK
when you display it it's loaded in memory with it's whole history so
if you have several versions it might take quite some memory.

On Tue, Sep 16, 2014 at 10:14 AM, Moens Patrick
patrick.mo...@curia.europa.eu wrote:
 Between 50-70 mo

 But its before trying to deleted them. It's when I open the deleted 
 attachments page.

 -Original Message-
 From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas Mortagne
 Sent: mardi 16 septembre 2014 10:11
 To: XWiki Users
 Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

 Well the one you tries should me enough for most use case.

 How big is the attachment you are trying to delete ? Your issue might be 
 related to http://jira.xwiki.org/browse/XWIKI-8910.

 On Tue, Sep 16, 2014 at 9:59 AM, Moens Patrick 
 patrick.mo...@curia.europa.eu wrote:
 Thanks Thomas,

 I'll look that because we have made some test with those JAVAOPTS parameters 
 for massive import :


 -Xms3072m
 -Xmx3072m
 -XX:MaxPermSize=256M

 Seems not good , I f you have any idea to optimize memory  tuning for
 Xwiki 6.1 on solaris (tomcat oracle) with around 100-150 concurent
 users


 I'll try with those one  :
 -d64
 -Xms1536m
 -Xmx1536m
 -XX:MaxPermSize=200M
 -XX:+UseConcMarkSweepGC
 -Dfile.encoding=utf-8
 -Dxwiki.data.dir=/opt/curia/wikidgt/data/
 -Doracle.net.tns_admin=${TNS_ADMIN}



 -Original Message-
 From: users [mailto:users-boun...@xwiki.org] On Behalf Of Thomas
 Mortagne
 Sent: mardi 16 septembre 2014 9:43
 To: XWiki Users
 Subject: Re: [xwiki-users] [XWIKI 6.1] error for deleted attachments

 The issue is  java.lang.OutOfMemoryError: Java heap space. Hard to say 
 what exactly is the cause, you might want to look at 
 http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HMemory.

 On Tue, Sep 16, 2014 at 9:39 AM, Moens Patrick 
 patrick.mo...@curia.europa.eu wrote:
 Hello ,

 I've a small problem with a fresh install of xwiki 6.1 on solaris (tomcat, 
 oracle).

 When I try to see the deleted attachments from the 'xwiki list of documents 
 ', I got this error (see bellow).

 There is just 2 deleted doc in the table;

 I tried to save the page with admin account (who has programming rights), 
 still  the same.

 Any idea?

 BR

 Patrick




 Failed to execute the [velocity] macro
 org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate 
 Velocity Macro for content [#if(!$xwiki.hasProgrammingRights())
   {{warning}}This document requires programming rights and needs to
 be saved by an administrator of this Wiki{{/warning}} #else
 #set($dateFormat = '  d, HH:mm')
 #if(!$request.list)
 $xwiki.ssx.use('XWiki.DeletedAttachments')##
 $xwiki.jsx.use('XWiki.DeletedAttachments', {'minify' : 'false'})## ##
 #set($columns = ['datt.filename', 'datt.docName', 'datt.date',
 'datt.deleter', 'actions']) #set($columnProperties = {
 'datt.filename'  : { 'type' : 'text', 'size' : 10 },
 'datt.docName'   : { 'type' : 'text', 'size' : 10 },
 'datt.date'  : { 'type' : 'date', 'filterable' : false },
 'datt.deleter'   : { 'type' : 'text', 'size' : 10 },
 'actions': { 'type' : 'text', 'filterable' : false, 'sortable' 
 : false }
   })##
 #set($options = {
 'url'   : $xwiki.getURL('XWiki.DeletedAttachments', 
 'view', 'list=1xpage=plainoutputSyntax=plain'),
'callback'  : 'XWiki.index.trash.attachments.displayEntry',
 'translationPrefix' : 'platform.index.trashAttachments.'
   })##
 ##
 ##
 ##
 {{html wiki=true clean=false}}
 div class=hidden
 #livetable('attachmentTrash' $columns $columnProperties $options)
 /div {{/html}}

 {{html wiki=true clean=false}}
 noscript

   #set($deletedAttachments = $services.query.hql('select count(datt.id) 
 from DeletedAttachment as datt').execute().get(0))
   #if($deletedAttachments == 0)


 {{info}}$services.localization.render('platform.index.trashAttachment
 s
 Empty'){{/info}}

   #else
   #macro(displayDeletedAttachment $id)
 #set($datt = $xwiki.getDeletedAttachment($id))
 #set($originalAttachment = $datt.getAttachment())
 #set($originalDocument = $xwiki.getDocument($datt.docName))
 tr
   tda 
 href=$originalDocument.getAttachmentRevisionURL($originalAttachment.filename,
  $originalAttachment.version, rid=${datt.id}).replaceAll('', 
 'amp;')$escapetool.xml($datt.filename)/a/td
   tda 
 href=$originalDocument.getURL()$escapetool.xml($originalDocument.plainTitle)
  ($escapetool.xml(${originalDocument.fullName}))/a/td
   td$xwiki.formatDate($datt.getDate(), $dateFormat)/td
   td$xwiki.getUserName($datt.getDeleter())/td
   td class=itemActions
 #if($datt.canDelete())
   a href=${originalDocument.getAttachmentURL($datt.filename, 
 'delattachment', 
 trashId=${datt.id}amp;xredirect=$escapetool.url($!request.getRequestURI())?$escapetool.url