ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | c-jdbc List | August 2004 Index

<--  Date Index  --> <--  Thread Index  -->

Re: [c-jdbc] severe problem on production system


Hi Özcan,

LOG:  statement: update community_account set
hobby='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
...
own='Witten', zip='58455', chattime='1', premiumsms=1093726031872 where
username='Zehra25'
ERROR:  value too long for type character varying(255)
It seems that your application try to update a field that is defined in the database schema as VARCHAR(255) with a String that contains more than 255 characters. This error is directly reported by Postgres.

Here you can see a thread dump from c-jdbc controller

http://www.bizimalem.com/cjdbc-thread-dump.txt
At the beginning of the log, you have entries containing:

2004-08-27 00:06:39,593 WARN  controller.core.Controller Driver protocol (5) 
is not compatible with controller. Update the driver on the client side.

This means that you are not using the right C-JDBC driver with the controller. You should update the driver on your application server side to use C-JDBC driver v1.0.1 shipped with C-JDBC 1.0.1.

2004-08-27 00:29:27,518 ERROR controller.core.Controller Failed to start the JMX server. (org.objectweb.cjdbc.common.jmx.JmxException: Port already in use: 1090; nested exception is: java.net.BindException: Address already in use) org.objectweb.cjdbc.common.jmx.JmxException: Port already in use: 1090; nested exception is: java.net.BindException: Address already in use

This means that you are starting 2 controllers with the same JMX port on the same machine. You should change the configuration of one of your controller to prevent this.

2004-08-27 05:50:13,259 ERROR controller.loadbalancer.RAIDb1 Request 737 
failed:
BackendThread localhost failed (org.postgresql.util.PSQLException: ERROR: duplicate key 
violates unique constraint "pk_com_guestbook"
)

These are errors of your application that violates constraints. This is reported by Postgres.

2004-08-28 18:10:37,595 WARN  VirtualDatabaseWorkerThread.baDB.26 Error 
during command execution (Failed to execute request update community_account 
set hobby='flir... because of (Request 7309 failed:
BackendThread db1 failed (org.postgresql.util.PSQLException: ERROR: value too 
long for type character varying(25)
)
BackendThread db2 failed (org.postgresql.util.PSQLException: ERROR: value too 
long for type character varying(25)
)


Once again your application does not respect the underlying database schema. String on VARCHAR(25) cannot exceed 25 characters.

Don't hesitate c-jdbc-pro@xxxxxxxxxxxxx for professional support, training and tuning for production environments.
Emmanuel
PS: Don't hesitate to send us a description of your application so that we can advertise it on our users page (http://c-jdbc.objectweb.org/users.html).

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature



<--  Date Index  --> <--  Thread Index  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.