export CATALINA_OPTS="-server -Xms256m -Xmx256m -Xss256k"

export JAVA_OPTS="-Xloggc:/usr/local/tomcat5/logs/gc.txt"

[0回]

凄い嵌った・・・
今日1日は、これで費やしてしまった・・・・

だって、C3P0の日本語サイト少ないし、しかもみんなハイバネートだし・・・

単体で、C3P0を使っている人は少ないようで、僕が特殊？

まぁ、そんな訳でエラーログを
2009.05.08,14:53:42,949,BaseCommandController.java:340,DEBUG,Creating new command of class [jp.co.leon.dto.Users]
2009.05.08,14:53:49,732,BaseCommandController.java:340,DEBUG,Creating new command of class [jp.co.leon.dto.Users]
2009.05.08,14:53:49,773,SimpleFormController.java:257,DEBUG,No errors -> processing submit
2009.05.08,14:54:03,042,BasicResourcePool.java:538,DEBUG,acquire test -- pool size: 0; target_pool_size: 10; desired target? 4
2009.05.08,14:54:03,043,BasicResourcePool.java:1291,DEBUG,awaitAvailable(): [unknown]
2009.05.08,14:54:03,044,BasicResourcePool.java:1644,DEBUG,trace com.mchange.v2.resourcepool.BasicResourcePool@303a60 [managed: 0, unused: 0, excluded: 0]
2009.05.08,14:54:49,706,BasicResourcePool.java:1831,DEBUG,An exception occurred while acquiring a poolable resource. Will retry.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
 at sun.reflect.GeneratedConstructorAccessor24.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.GeneratedConstructorAccessor22.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
 at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
 at sun.reflect.GeneratedConstructorAccessor24.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
 at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
 ... 16 more
Caused by: java.net.ConnectException: Connection timed out
 at java.net.PlainSocketImpl.socketConnect(Native Method)
 at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 at java.net.Socket.connect(Socket.java:519)
 at java.net.Socket.connect(Socket.java:469)
 at java.net.Socket.<init>(Socket.java:366)
 at java.net.Socket.<init>(Socket.java:209)
 at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
 at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
 ... 17 more
2009.05.08,14:54:49,706,BasicResourcePool.java:1831,DEBUG,An exception occurred while acquiring a poolable resource. Will retry.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

悪さをしていたのは、spring のBeanNameAutoProxyCreator

もっというとサーバの設定がちゃんとされてないじゃん！！
WEB1台、DBを2台使って、一つのDBに接続できず・・・

トランザクションを実行するとプールが消滅してる！？って思い、凄い嵌った・・・

iptables やるなら、ちゃんとやってくれよ・・・
 

[0回]

MYSQL でアクセスプログラムが、「Lost connection to MySQL server during query」　というエラーで落ちた

とりあえず、

Select Count(id) From table

とやっても、同じエラー

Select * From table limit 1

うん、表示される

やっぱ、DBサーバがショボイから落ちたのか

table には、28万件以上のデータがはいってるのに、メモリ386Mで、よく動いているよ、このテストサーバは

落ちても許そうｗ

[0回]

AU EZ-WEBで動画をダウンロードさせるときには、.htaccessかhttp.confに

AddType audio/3gpp2 .3g2 
AddType video/3gpp2 .3g2 
AddType application/x-mpeg .amc

記載

ないと、「ダウンロードデータが正しくありません」と返される

[0回]

DoCoMoの最新機種でも、リファラを送るらしい

DoCoMo/2.0 F09A(c500;TB;W23H16)
DoCoMo/2.0 F08A(c500;TB;W24H16)
DoCoMo/2.0 N07A(c500;TB;W30H20)
DoCoMo/2.0 N06A(c500;TB;W24H16)

これらの機種が送るっぽい

[0回]