FreeBSD 5.3-RELEASE + JDK1.4 native in a Jail -> hangs 99% cpu on kserel

[Joris Verschoor]

Achilleus Mantzios wrote:

>Just some thoughts:
>
>- Postgresql unfortunately cant be jailified since IPC is not
>meant to be jailified itself.
>(BTW have you set security.jail.sysvipc_allowed=1 ??)
>  
>
Yep I've set that

>Hmm. native,green,classic is not an option anymore.
>Only -client,-server (hotspot).
>  
>
right..

>
>Always have an eye on the postgresql log.
>Maybe the backend was non gracefully restarted due to a
>jail IPC failure.
>What does the postgresql log say?
>  
>
I've only some constraint errors when I do something wrong myself :)

>Which postgresql are you running?
>I suggest 7.4.6 (the lastest stable).
>  
>
I'm running 7.4.6

>Also make sure the jdbc driver in in sync
>with your backend.
>  
>
pg74.215.jdbc3.jar

>Also... an advice: Dont use the ports for postgresql.
>Manually manage your installations, because even for 
>minor releases updates you could do a real harm to your
>database if you rely on the ports/packages upgrade mechanisms.
>  
>
When I upgrade, I always use pg_dump to backup dbs

>No script will ever do :
>
>UPDATE pg_type where oid=... ;
>
>kinds of things.
>  
>
I'm  doing only user table queries..