[opencms-dev] Error while saving modified HTML file with editor

[Claus Priisholm]

Hi

When errors are logged that has to do with the database, make sure that 
you're not running out of connection i MySQL. OpenCms 5  leaks 
connections under certain circumstances and this may over time cause 
mysql to run out of connections.
Exactly how it manifest itself of course varies depending on when it 
occurs. But if it happens during a publish it is not unlikely that the 
result could be inconsistency between the normal file and the ditto in 
the bodies folder (and if you do a direct publish you would see special 
tempFileProject linger instead of disappear as it should do).

And once that happen, you may have issues even when you've restarted 
and flushed the leaked connections. Usually it can be fixed via the 
workplace by manually bringing the bodies stuff up to date. I've never 
seen the behaviour you're seeing so I cannot be of help there - have 
you tried to delete the "/kalender"-folder and then publish? This may 
clean up whatever confuses OpenCms and let you go on from there.

Claus

On 10/2-2005, at 10.31, ae_mustapha at freesurf.ch wrote:

> Hi there,
>
> I am using OpenCMS 5.0 for over a year now together with Tomcat 4 and 
> MySQL
> 4.1. Some days ago a user provoked following error by saving an edited 
> HTML
> content file with the built-in WYSIWYG editor:
> com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> [com.opencms.file.mySql.CmsDbAccess] Driver can not re-execute prepared
> statement when a parameter has been changed from a streaming type to an
> intrinsic data type without calling clearParameters() first..
>
> After accepting the message a temporary file with a ~ is created (e.g.
> ~index.html) which is locked with a grey flag belonging to a project 
> called
> "tempFileProject". This project does not exist explicitly in the 
> system.
>
> I have been trying to solve the problem in the past days and even 
> managed
> to
> create something like an endless loop. I had once of a sudden around 
> 140
> of
> these temporary files in the system. I managed to delete these files
> directly in the database according an entry I found in the archive
> (http://mail.opencms.org/pipermail/opencms-dev/2004q2/011743.html)
>
> For more details regarding the error message and to view a screenshot 
> follow
> this link: http://www.fcgrotkreuz.ch/error.html
>
> Any help is highly appreciated.
>
> Thanx.
> Erwin
>
>
> sunrise ADSL: gratis und so sicher wie noch nie
> http://www.sunrise.ch/home/proint/proint_ads-2.htm
>
>
>
>
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please 
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
OpenCms links & API's: http://www.codedroids.com/community/opencms
--
Claus Priisholm
+45 48 22 46 46
cpr <you know what> codedroids.com
http://www.codedroids.com