AW: [opencms-dev] Problems with publishing / Gray Flags

[Roth Olivier]

Hi,

I often have a similar problem: resources not getting published and then
being marked with a gray flag.
My solutions for this is to manually login into the database (mySql in my
case) and to kill some of the sleeping connections.
After that publishing is possible again.

The big question is: why is this happening ?
Why aren't these sleeping connections being resumed or terminated ?

Some info about my settings:
- in opencms.properties:
pool.mysql.minConn=10
pool.mysql.maxConn=20
pool.mysql.increaseRate=5
pool.mysql.timeout=120
pool.mysql.maxage=360
(online and backup pool same values)

- for mySql:
'max_connections','200'
'wait_timeout','14400'

Greetings,
	Olivier Roth

-----Ursprüngliche Nachricht-----
Von: opencms-dev-admin at opencms.org
[mailto:opencms-dev-admin at opencms.org]Im Auftrag von Kai Schliemann
Gesendet: Dienstag, 16. Dezember 2003 10:33
An: opencms-dev at opencms.org
Betreff: AW: [opencms-dev] Problems with publishing


Hi Mario,

may I ask if you already solved this problem? I am having the same problems
you have. But there is one difference. Before publishing a resource it is
marked as changed with a red flag. After publishing it, it has a gray flag
and the alt-text says "belongs to project ''". The '' indicating a empty
string.

Can you or anyone else help me?

TIA

Kai