HTTP Status 500 issue (SQL Error)

[Justyn]

I read the READ HERE FIRST: FIXED. But that is incorrect, because today I have been getting this error a lot, especially when trying to gift friends back. It just won't let me stay connected to the game! VERY ANNOYING.

[Simcurieux]

Quand j'essais d'envoyer à 26 personnes (comme c'est possible en les sélectionnant), 1 cadeau ca m'envois une page de code de programmation.

En détail en ex.:

Onglet: Cadeaux gratuits;
Je choisi un cadeau quelconque;
Onglet: Zombie Lane amis;
Je sélectionne mes 26 amis;
Je click sur: Envoyer une demande de zombie Lane gift;
Je click sur: Envoyer


HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

com.sf.ddao.DaoException: Failed to execute sql operation for public abstract void com.dchoc.charlie.services.counter.dao.CounterDao. incrementCounter(com.dchoc.charlie.core.account.da ta.AccountEntity,java.lang.String,int)
com.sf.ddao.ops.UpdateSqlOperation.execute(UpdateS qlOperation.java:75)
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:191)
com.sf.ddao.chain.MethodInvocationHandler.invoke(M ethodInvocationHandler.java:73)
com.sf.ddao.chain.ChainInvocationHandler.invoke(Ch ainInvocationHandler.java:47)
$Proxy30.incrementCounter(Unknown Source)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:38)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:33)
com.dchoc.dead.services.gifts.GiftServiceImpl.save Gifts(GiftServiceImpl.java:131)
com.dchoc.dead.adapters.gifts.GiftServiceFacebookA dapter.saveGifts(GiftServiceFacebookAdapter.java:4 9)
com.dchoc.dead.servlet.GiftSentCallbackServlet.doP ost(GiftSentCallbackServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
com.google.inject.servlet.ServletDefinition.doServ ice(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.servic e(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.s ervice(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.do Filter(FilterChainInvocation.java:62)
com.google.inject.servlet.ManagedFilterPipeline.di spatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(Gui ceFilter.java:113)

root cause

com.sf.ddao.factory.StatementFactoryException: Failed to prepare statement 'INSERT INTO counters (account_id, counter_key, value, created_at) VALUES (?, ?, ?, NOW()) ON DUPLICATE KEY UPDATE value = value + ?'
com.sf.ddao.factory.DefaultStatementFactory.create Statement(DefaultStatementFactory.java:136)
com.sf.ddao.ops.UpdateSqlOperation.execute(UpdateS qlOperation.java:67)
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:191)
com.sf.ddao.chain.MethodInvocationHandler.invoke(M ethodInvocationHandler.java:73)
com.sf.ddao.chain.ChainInvocationHandler.invoke(Ch ainInvocationHandler.java:47)
$Proxy30.incrementCounter(Unknown Source)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:38)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:33)
com.dchoc.dead.services.gifts.GiftServiceImpl.save Gifts(GiftServiceImpl.java:131)
com.dchoc.dead.adapters.gifts.GiftServiceFacebookA dapter.saveGifts(GiftServiceFacebookAdapter.java:4 9)
com.dchoc.dead.servlet.GiftSentCallbackServlet.doP ost(GiftSentCallbackServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
com.google.inject.servlet.ServletDefinition.doServ ice(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.servic e(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.s ervice(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.do Filter(FilterChainInvocation.java:62)
com.google.inject.servlet.ManagedFilterPipeline.di spatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(Gui ceFilter.java:113)

root cause

java.sql.SQLException: Failed to retrieve shard for key 1328574175(class java.math.BigInteger)
com.sf.ddao.shards.conn.ShardedConnectionHandler.c reateConnection(ShardedConnectionHandler.java:138)
com.sf.ddao.conn.ConnectionHandlerHelper.getConnec tion(ConnectionHandlerHelper.java:68)
com.sf.ddao.factory.DefaultStatementFactory.create Statement(DefaultStatementFactory.java:120)
com.sf.ddao.ops.UpdateSqlOperation.execute(UpdateS qlOperation.java:67)
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:191)
com.sf.ddao.chain.MethodInvocationHandler.invoke(M ethodInvocationHandler.java:73)
com.sf.ddao.chain.ChainInvocationHandler.invoke(Ch ainInvocationHandler.java:47)
$Proxy30.incrementCounter(Unknown Source)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:38)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:33)
com.dchoc.dead.services.gifts.GiftServiceImpl.save Gifts(GiftServiceImpl.java:131)
com.dchoc.dead.adapters.gifts.GiftServiceFacebookA dapter.saveGifts(GiftServiceFacebookAdapter.java:4 9)
com.dchoc.dead.servlet.GiftSentCallbackServlet.doP ost(GiftSentCallbackServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
com.google.inject.servlet.ServletDefinition.doServ ice(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.servic e(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.s ervice(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.do Filter(FilterChainInvocation.java:62)
com.google.inject.servlet.ManagedFilterPipeline.di spatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(Gui ceFilter.java:113)

root cause

java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.dchoc.delta.gd.DataSourceFIsolator.exec(DataSo urceFIsolator.java:75)
com.dchoc.delta.gd.DataSourceFIsolator.getConnecti on(DataSourceFIsolator.java:26)
com.sf.ddao.shards.conn.ShardedConnectionHandler.c reateConnection(ShardedConnectionHandler.java:136)
com.sf.ddao.conn.ConnectionHandlerHelper.getConnec tion(ConnectionHandlerHelper.java:68)
com.sf.ddao.factory.DefaultStatementFactory.create Statement(DefaultStatementFactory.java:120)
com.sf.ddao.ops.UpdateSqlOperation.execute(UpdateS qlOperation.java:67)
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:191)
com.sf.ddao.chain.MethodInvocationHandler.invoke(M ethodInvocationHandler.java:73)
com.sf.ddao.chain.ChainInvocationHandler.invoke(Ch ainInvocationHandler.java:47)
$Proxy30.incrementCounter(Unknown Source)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:38)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:33)
com.dchoc.dead.services.gifts.GiftServiceImpl.save Gifts(GiftServiceImpl.java:131)
com.dchoc.dead.adapters.gifts.GiftServiceFacebookA dapter.saveGifts(GiftServiceFacebookAdapter.java:4 9)
com.dchoc.dead.servlet.GiftSentCallbackServlet.doP ost(GiftSentCallbackServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
com.google.inject.servlet.ServletDefinition.doServ ice(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.servic e(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.s ervice(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.do Filter(FilterChainInvocation.java:62)
com.google.inject.servlet.ManagedFilterPipeline.di spatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(Gui ceFilter.java:113)

root cause

java.util.concurrent.ExecutionException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
java.util.concurrent.FutureTask$Sync.innerGet(Futu reTask.java:232)
java.util.concurrent.FutureTask.get(FutureTask.jav a:91)
net.sf.fisolator.FaultIsolator.invoke(FaultIsolato r.java:84)
com.dchoc.delta.gd.DataSourceFIsolator.exec(DataSo urceFIsolator.java:69)
com.dchoc.delta.gd.DataSourceFIsolator.getConnecti on(DataSourceFIsolator.java:26)
com.sf.ddao.shards.conn.ShardedConnectionHandler.c reateConnection(ShardedConnectionHandler.java:136)

[Simcurieux]

com.sf.ddao.conn.ConnectionHandlerHelper.getConnec tion(ConnectionHandlerHelper.java:68)
com.sf.ddao.factory.DefaultStatementFactory.create Statement(DefaultStatementFactory.java:120)
com.sf.ddao.ops.UpdateSqlOperation.execute(UpdateS qlOperation.java:67)
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:191)
com.sf.ddao.chain.MethodInvocationHandler.invoke(M ethodInvocationHandler.java:73)
com.sf.ddao.chain.ChainInvocationHandler.invoke(Ch ainInvocationHandler.java:47)
$Proxy30.incrementCounter(Unknown Source)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:38)
com.dchoc.charlie.services.counter.CounterServiceI mpl.incrementCounter(CounterServiceImpl.java:33)
com.dchoc.dead.services.gifts.GiftServiceImpl.save Gifts(GiftServiceImpl.java:131)
com.dchoc.dead.adapters.gifts.GiftServiceFacebookA dapter.saveGifts(GiftServiceFacebookAdapter.java:4 9)
com.dchoc.dead.servlet.GiftSentCallbackServlet.doP ost(GiftSentCallbackServlet.java:136)
javax.servlet.http.HttpServlet.service(HttpServlet .java:637)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
com.google.inject.servlet.ServletDefinition.doServ ice(ServletDefinition.java:263)
com.google.inject.servlet.ServletDefinition.servic e(ServletDefinition.java:178)
com.google.inject.servlet.ManagedServletPipeline.s ervice(ManagedServletPipeline.java:91)
com.google.inject.servlet.FilterChainInvocation.do Filter(FilterChainInvocation.java:62)
com.google.inject.servlet.ManagedFilterPipeline.di spatch(ManagedFilterPipeline.java:118)
com.google.inject.servlet.GuiceFilter.doFilter(Gui ceFilter.java:113)

root cause

java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtil s.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtil s.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool. checkoutPooledConnection(C3P0PooledConnectionPool. java:527)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(AbstractPoolBackedDataSource.jav a:128)
com.dchoc.delta.gd.DataSourceFIsolator$1.call(Data SourceFIsolator.java:28)
com.dchoc.delta.gd.DataSourceFIsolator$1.call(Data SourceFIsolator.java:26)
net.sf.fisolator.ServiceTrackerImpl.taskExec(Servi ceTrackerImpl.java:52)
net.sf.fisolator.FaultIsolator$2.call(FaultIsolato r.java:80)
java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:908)
java.lang.Thread.run(Thread.java:619)

root cause

com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@4819 d373 -- timeout at awaitAvailable()
com.mchange.v2.resourcepool.BasicResourcePool.awai tAvailable(BasicResourcePool.java:1317)
com.mchange.v2.resourcepool.BasicResourcePool.prel imCheckoutResource(BasicResourcePool.java:557)
com.mchange.v2.resourcepool.BasicResourcePool.chec koutResource(BasicResourcePool.java:477)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool. checkoutPooledConnection(C3P0PooledConnectionPool. java:525)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSou rce.getConnection(AbstractPoolBackedDataSource.jav a:128)
com.dchoc.delta.gd.DataSourceFIsolator$1.call(Data SourceFIsolator.java:28)
com.dchoc.delta.gd.DataSourceFIsolator$1.call(Data SourceFIsolator.java:26)
net.sf.fisolator.ServiceTrackerImpl.taskExec(Servi ceTrackerImpl.java:52)
net.sf.fisolator.FaultIsolator$2.call(FaultIsolato r.java:80)
java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:908)
java.lang.Thread.run(Thread.java:619)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.
Apache Tomcat/6.0.29

Donnez-moi votre avis

[Simcurieux]

j'ai même envoyé un thread tantot au sujet de quand j'envois un cadeau à 26 amis

[Mally]

I read the READ HERE FIRST: FIXED. But that is incorrect, because today I have been getting this error a lot, especially when trying to gift friends back. It just won't let me stay connected to the game! VERY ANNOYING.

I am not sure they update that list... and I think there are problems with the Digital Chocolate servers today since another game of theirs is not functioning very well if at all. At least we can play Zombie Lane -- until or unless it breaks too. lol

[snappa76]

About 9 times out ten, when i try to send multiple gifts, i get this error message:



Now i've tried all that business with clearing the cache, changing browsers, setting fire to the keyboard, etc but this has started after the recent "maintenance upgrade" and i can see from other complaints that it's obviously not a user issue.
Also, i've only just started to see my neighbours again!

[Snipah]

Hey snappa76,

I am not sure about it but worth a try.
When you are sending gifts to your friends, pay attention to the first person you are supposed to send gifts in the next group. Before that person, no one is supposed to appear unless you didn't send to someone.

Reason for assumption:
Sometime back there was an issue(Either with Facebook or with the game) that after sending a gift for some players, their name wasn't removed from the list thus creating an error(Not sure if it is this one or not) because you can't send more than 1 specific gift per 1 player in the given time.

Snipah

[Sam Owen]

Been getting that error for awhile now...

[vlastimir]

same here

[hopieg]

Hey snappa76,

I am not sure about it but worth a try.
When you are sending gifts to your friends, pay attention to the first person you are supposed to send gifts in the next group. Before that person, no one is supposed to appear unless you didn't send to someone.

Reason for assumption:
Sometime back there was an issue(Either with Facebook or with the game) that after sending a gift for some players, their name wasn't removed from the list thus creating an error(Not sure if it is this one or not) because you can't send more than 1 specific gift per 1 player in the given time.

Snipah

I have been paying attention to that. I do for an easy way to count my neighbors. (send x gifts x times= x neighbors) That isn't the problem.