I wonder if that open-and-close behavior is the result of configuring Roller via what we call JDBC rather than JNDI.
As I recall, with JDBC we use the standard JDBC driver manager which does not provide a connection pool, so each time we need a connect (I assume) we open and close one. I think that means we would open an close a connection for each request (since we ensure that each request only uses one connection). With JNDI, we as the Servlet container for the connection and it usually comes from a pool of connections that remain open long-term. - Dave On Thu, Oct 30, 2014 at 5:29 PM, Matt Raible <m...@raibledesigns.com> wrote: > Hey all, > > I saw the following error in my logs today, so I sent them to my hosting > provider and asked them to look into it. > > SEVERE: Servlet.service() for servlet [jsp] in context with path [] threw > exception [<openjpa-2.0.1-r422266:989424 fatal general error> > org.apache.openjpa.persistence.PersistenceException: User raible already > has more than 'max_user_connections' active connections > FailedObject: SELECT w FROM WeblogTemplate w WHERE w.website = ?1 AND > w.name= > ?2 [java.lang.String]] with root cause > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User raible > already has more than 'max_user_connections' active connections > > Their response: > ---- > I just checked raibledesigns.com and it is serving pages. You currently > have 2 connections to the database, and the maximum for the raible user is > 40. > > The JVM was restarted 20 minutes ago, which would have cleared open > database connections. > ---- > > A bit later, they responded with: > ---- > Ok, I'm a bit confused. Raibledesigns.com is serving pages, but the > database isn't showing connections to the database. > > Are you connecting somewhere other than raible@localhost for > raibledesigns? > --- > > 30 minutes later, they sent me another email: > ---- > It looks like the reason that I didn't see any connections to your database > is that the app seems to be connecting/disconnecting for each query. > > I am full mysql logging for about four minutes, and it is > connecting/disconnecting about 1000 times per minute during that time > period. > --- > > To prove this, they sent me the following logs. I have my database > connection configured in $CATALINA_HOME/lib/roller-custom.properties. Any > ideas? > > I'm running Roller 5.0.3 on and "java -version" returns the following: > > $ java -version > java version "1.8.0_20" > Java(TM) SE Runtime Environment (build 1.8.0_20-b26) > Java HotSpot(TM) 64-Bit Server VM (build 25.20-b23, mixed mode) > > Thanks, > > Matt > > ---- > All this was logged in ONE second! I filtered some of the results to keep > this a reasonable size, but you can see the timestamp at the beginning and > the end, and the transaction count for each of the connections. > > 141030 14:49:09 794 Connect raible@localhost on raible > 794 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 794 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 794 Query SHOW COLLATION > 794 Query SET NAMES latin1 > 794 Query SET character_set_results = NULL > 794 Query SET autocommit=1 > 794 Query SET sql_mode='STRICT_TRANS_TABLES' > 794 Query SET autocommit=0 > 794 Query SELECT t0.about, t0.isactive, > t0.allowcomments, t0.blacklist, t1.id, t1.description, > t1.image, t1.name, t2.id, t2.description, t2.image, > t2.name, t2.path, t2.websiteid, t1.path, t3.id, > t3.about, t3.isactive, t3.allowcomments, t3.blacklist, > t3.bloggercatid, t3.creator, t3.customstylesheet, > t3.datecreated, t3.defaultallowcomments, > t3.defaultcatid, t3.defaultcommentdays, > t3.defaultpageid, t3.defaultplugins, t3.description, > t3.editorpage, t3.editortheme, t3.emailaddress, > t3.emailcomments, t3.emailfromaddress, > t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, > t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, > t3.locale, t3.commentmod, t3.name, t3.pagemodels, > t3.showalllangs, t3.timeZone, t3.weblogdayid, > t0.creator, t0.customstylesheet, t0.datecreated, > t0.defaultallowcomments, t4.id, t4.description, > t4.image, t4.name, t4.parentid, t4.path, t4.websiteid, > t0.defaultcommentdays, t0.defaultpageid, > t0.defaultplugins, t0.description, t0.editorpage, > t0.editortheme, t0.emailaddress, t0.emailcomments, > t0.emailfromaddress, t0.enablebloggerapi, > t0.enablemultilang, t0.isenabled, t0.displaycnt, > t0.handle, t0.icon, t0.lastmodified, t0.locale, > t0.commentmod, t0.name, t0.pagemodels, t0.showalllangs, > t0.timeZone, t0.weblogdayid FROM website t0 LEFT OUTER > JOIN weblogcategory t1 ON t0.bloggercatid = t1.id LEFT > OUTER JOIN weblogcategory t4 ON t0.defaultcatid = t4.id > LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id > LEFT OUTER JOIN website t3 ON t1.websiteid = t3.id WHERE > t0.id = '192197110220102821600270800003' > 794 Query rollback > 794 Quit > > > > 795 Connect raible@localhost on raible > 795 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 795 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 795 Query SHOW COLLATION > 795 Query SET NAMES latin1 > 795 Query SET character_set_results = NULL > 795 Query SET autocommit=1 > 795 Query SET sql_mode='STRICT_TRANS_TABLES' > 795 Query SET autocommit=0 > 795 Query SELECT t0.value FROM roller_properties t0 > WHERE t0.name = 'site.frontpage.weblog.aggregated' > 795 Query rollback > 795 Quit > > > 796 Connect raible@localhost on raible > 796 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 796 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 796 Query SHOW COLLATION > 796 Query SET NAMES latin1 > 796 Query SET character_set_results = NULL > 796 Query SET autocommit=1 > 796 Query SET sql_mode='STRICT_TRANS_TABLES' > 796 Query SET autocommit=0 > 796 Query SELECT t0.value FROM roller_properties t0 > WHERE t0.name = 'site.frontpage.weblog.handle' > 796 Query rollback > 796 Quit > > 797 Connect raible@localhost on raible > 797 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 797 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 797 Query SHOW COLLATION > 797 Query SET NAMES latin1 > 797 Query SET character_set_results = NULL > 797 Query SET autocommit=1 > 797 Query SET sql_mode='STRICT_TRANS_TABLES' > 797 Query SET autocommit=0 > 797 Query SELECT t0.id, t0.description, t0.image, > t0.name, t1.id, t1.description, t1.image, t1.name, > t1.path, t1.websiteid, t0.path, t2.id, t2.about, > t2.isactive, t2.allowcomments, t2.blacklist, t3.id, > t3.description, t3.image, t3.name, t3.parentid, t3.path, > t3.websiteid, t2.creator, t2.customstylesheet, > t2.datecreated, t2.defaultallowcomments, t4.id, > t4.description, t4.image, t4.name, t4.parentid, t4.path, > t4.websiteid, t2.defaultcommentdays, t2.defaultpageid, > t2.defaultplugins, t2.description, t2.editorpage, > t2.editortheme, t2.emailaddress, t2.emailcomments, > t2.emailfromaddress, t2.enablebloggerapi, > t2.enablemultilang, t2.isenabled, t2.displaycnt, > t2.handle, t2.icon, t2.lastmodified, t2.locale, > t2.commentmod, t2.name, t2.pagemodels, t2.showalllangs, > t2.timeZone, t2.weblogdayid FROM weblogcategory t0 LEFT > OUTER JOIN weblogcategory t1 ON t0.parentid = t1.id LEFT > OUTER JOIN website t2 ON t0.websiteid = t2.id LEFT OUTER > JOIN weblogcategory t3 ON t2.bloggercatid = t3.id LEFT > OUTER JOIN weblogcategory t4 ON t2.defaultcatid = t4.id > WHERE (t0.path = '/Roller' AND t0.websiteid = > '192197110220102821600270800003') > 797 Query rollback > 797 Quit > > 798 Connect raible@localhost on raible > 798 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 798 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 798 Query SHOW COLLATION > 798 Query SET NAMES latin1 > 798 Query SET character_set_results = NULL > 798 Query SET autocommit=1 > 798 Query SET sql_mode='STRICT_TRANS_TABLES' > 798 Query SET autocommit=0 > 798 Query SELECT t0.id, t0.action, t0.template, > t0.decorator, t0.description, t0.hidden, t0.updatetime, > t0.link, t0.name, t0.navbar, t0.outputtype, > t0.templatelang, t1.id, t1.about, t1.isactive, > t1.allowcomments, t1.blacklist, t2.id, t2.description, > t2.image, t2.name, t3.id, t3.description, t3.image, > t3.name, t3.path, t3.websiteid, t2.path, t4.id, > t4.about, t4.isactive, t4.allowcomments, t4.blacklist, > t4.bloggercatid, t4.creator, t4.customstylesheet, > t4.datecreated, t4.defaultallowcomments, > t4.defaultcatid, t4.defaultcommentdays, > t4.defaultpageid, t4.defaultplugins, t4.description, > t4.editorpage, t4.editortheme, t4.emailaddress, > t4.emailcomments, t4.emailfromaddress, > t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, > t4.displaycnt, t4.handle, t4.icon, t4.lastmodified, > t4.locale, t4.commentmod, t4.name, t4.pagemodels, > t4.showalllangs, t4.timeZone, t4.weblogdayid, > t1.creator, t1.customstylesheet, t1.datecreated, > t1.defaultallowcomments, t5.id, t5.description, > t5.image, t5.name, t5.parentid, t5.path, t5.websiteid, > t1.defaultcommentdays, t1.defaultpageid, > t1.defaultplugins, t1.description, t1.editorpage, > t1.editortheme, t1.emailaddress, t1.emailcomments, > t1.emailfromaddress, t1.enablebloggerapi, > t1.enablemultilang, t1.isenabled, t1.displaycnt, > t1.handle, t1.icon, t1.lastmodified, t1.locale, > t1.commentmod, t1.name, t1.pagemodels, t1.showalllangs, > t1.timeZone, t1.weblogdayid FROM webpage t0 LEFT OUTER > JOIN website t1 ON t0.websiteid = t1.id LEFT OUTER JOIN > weblogcategory t2 ON t1.bloggercatid = t2.id LEFT OUTER > JOIN weblogcategory t5 ON t1.defaultcatid = t5.id LEFT > OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT > OUTER JOIN website t4 ON t2.websiteid = t4.id WHERE > (t0.websiteid = '192197110220102821600270800003') ORDER > BY t0.name ASC > 798 Query rollback > 798 Quit > > > . > . > . > > > 814 Connect raible@localhost on raible > 814 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 814 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 814 Query SHOW COLLATION > 814 Query SET NAMES latin1 > 814 Query SET character_set_results = NULL > 814 Query SET autocommit=1 > 814 Query SET sql_mode='STRICT_TRANS_TABLES' > 814 Query SET autocommit=0 > 814 Query SELECT t0.value FROM roller_properties t0 > WHERE t0.name = 'site.frontpage.weblog.aggregated' > 813 Query rollback > 814 Query rollback > 814 Quit > > > 815 Connect raible@localhost on raible > 815 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 815 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 815 Query SHOW COLLATION > 815 Query SET NAMES latin1 > 815 Query SET character_set_results = NULL > 815 Query SET autocommit=1 > 815 Query SET sql_mode='STRICT_TRANS_TABLES' > 815 Query SET autocommit=0 > 815 Query SELECT t0.value FROM roller_properties t0 > WHERE t0.name = 'site.frontpage.weblog.handle' > 815 Query rollback > 813 Quit > 815 Quit > > > 816 Connect raible@localhost on raible > 816 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 816 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 816 Query SHOW COLLATION > 816 Query SET NAMES latin1 > 816 Query SET character_set_results = NULL > 816 Query SET autocommit=1 > 816 Query SET sql_mode='STRICT_TRANS_TABLES' > 816 Query SET autocommit=0 > 816 Query SELECT t0.id, t0.action, t0.template, > t0.decorator, t0.description, t0.hidden, t0.updatetime, > t0.link, t0.name, t0.navbar, t0.outputtype, > t0.templatelang, t1.id, t1.about, t1.isactive, > t1.allowcomments, t1.blacklist, t2.id, t2.description, > t2.image, t2.name, t3.id, t3.description, t3.image, > t3.name, t3.path, t3.websiteid, t2.path, t4.id, > t4.about, t4.isactive, t4.allowcomments, t4.blacklist, > t4.bloggercatid, t4.creator, t4.customstylesheet, > t4.datecreated, t4.defaultallowcomments, > t4.defaultcatid, t4.defaultcommentdays, > t4.defaultpageid, t4.defaultplugins, t4.description, > t4.editorpage, t4.editortheme, t4.emailaddress, > t4.emailcomments, t4.emailfromaddress, > t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, > t4.displaycnt, t4.handle, t4.icon, t4.lastmodified, > t4.locale, t4.commentmod, t4.name, t4.pagemodels, > t4.showalllangs, t4.timeZone, t4.weblogdayid, > t1.creator, t1.customstylesheet, t1.datecreated, > t1.defaultallowcomments, t5.id, t5.description, > t5.image, t5.name, t5.parentid, t5.path, t5.websiteid, > t1.defaultcommentdays, t1.defaultpageid, > t1.defaultplugins, t1.description, t1.editorpage, > t1.editortheme, t1.emailaddress, t1.emailcomments, > t1.emailfromaddress, t1.enablebloggerapi, > t1.enablemultilang, t1.isenabled, t1.displaycnt, > t1.handle, t1.icon, t1.lastmodified, t1.locale, > t1.commentmod, t1.name, t1.pagemodels, t1.showalllangs, > t1.timeZone, t1.weblogdayid FROM webpage t0 LEFT OUTER > JOIN website t1 ON t0.websiteid = t1.id LEFT OUTER JOIN > weblogcategory t2 ON t1.bloggercatid = t2.id LEFT OUTER > JOIN weblogcategory t5 ON t1.defaultcatid = t5.id LEFT > OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT > OUTER JOIN website t4 ON t2.websiteid = t4.id WHERE > (t0.websiteid = '192197110220102848590607100006') ORDER > BY t0.name ASC > 816 Query rollback > > > > 817 Connect raible@localhost on raible > 817 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 817 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 817 Query SHOW COLLATION > 817 Query SET NAMES latin1 > 817 Query SET character_set_results = NULL > 817 Query SET autocommit=1 > 817 Query SET sql_mode='STRICT_TRANS_TABLES' > 817 Query SET autocommit=0 > 817 Query SELECT t0.id, t0.content, t0.contenttype, > t0.email, t0.name, t0.notify, t0.plugins, t0.posttime, > t0.referrer, t0.remotehost, t0.status, t0.url, > t0.useragent, t1.id, t1.allowcomments, t1.anchor, t2.id, > t2.description, t2.image, t2.name, t3.id, > t3.description, t3.image, t3.name, t3.path, > t3.websiteid, t2.path, t4.id, t4.about, t4.isactive, > t4.allowcomments, t4.blacklist, t5.id, t5.description, > t5.image, t5.name, t5.parentid, t5.path, t5.websiteid, > t4.creator, t4.customstylesheet, t4.datecreated, > t4.defaultallowcomments, t6.id, t6.description, > t6.image, t6.name, t6.parentid, t6.path, t6.websiteid, > t4.defaultcommentdays, t4.defaultpageid, > t4.defaultplugins, t4.description, t4.editorpage, > t4.editortheme, t4.emailaddress, t4.emailcomments, > t4.emailfromaddress, t4.enablebloggerapi, > t4.enablemultilang, t4.isenabled, t4.displaycnt, > t4.handle, t4.icon, t4.lastmodified, t4.locale, > t4.commentmod, t4.name, t4.pagemodels, t4.showalllangs, > t4.timeZone, t4.weblogdayid, t1.commentdays, > t1.content_src, t1.content_type, t1.creator, t1.link, > t1.locale, t1.pinnedtomain, t1.plugins, t1.pubtime, > t1.righttoleft, t1.status, t1.summary, t1.text, > t1.title, t1.updatetime, t7.id, t7.about, t7.isactive, > t7.allowcomments, t7.blacklist, t7.bloggercatid, > t7.creator, t7.customstylesheet, t7.datecreated, > t7.defaultallowcomments, t7.defaultcatid, > t7.defaultcommentdays, t7.defaultpageid, > t7.defaultplugins, t7.description, t7.editorpage, > t7.editortheme, t7.emailaddress, t7.emailcomments, > t7.emailfromaddress, t7.enablebloggerapi, > t7.enablemultilang, t7.isenabled, t7.displaycnt, > t7.handle, t7.icon, t7.lastmodified, t7.locale, > t7.commentmod, t7.name, t7.pagemodels, t7.showalllangs, > t7.timeZone, t7.weblogdayid FROM roller_comment t0 LEFT > OUTER JOIN weblogentry t1 ON t0.entryid = t1.id LEFT > OUTER JOIN weblogcategory t2 ON t1.categoryid = t2.id > LEFT OUTER JOIN website t7 ON t1.websiteid = t7.id LEFT > OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT > OUTER JOIN website t4 ON t2.websiteid = t4.id LEFT OUTER > JOIN weblogcategory t5 ON t4.bloggercatid = t5.id LEFT > OUTER JOIN weblogcategory t6 ON t4.defaultcatid = t6.id > WHERE (t0.entryid = > 'f5c63539-4fdc-43bf-aa8c-64a2378b7a1b' AND t0.status = > 'APPROVED') ORDER BY t0.posttime ASC > 817 Query rollback > 817 Quit > > 818 Connect raible@localhost on raible > 818 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 818 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 818 Query SHOW COLLATION > 818 Query SET NAMES latin1 > 818 Query SET character_set_results = NULL > 818 Query SET autocommit=1 > 818 Query SET sql_mode='STRICT_TRANS_TABLES' > 818 Query SET autocommit=0 > 818 Query SELECT t0.name, t0.value FROM > roller_properties t0 > 818 Query rollback > 818 Quit > > > > 819 Connect raible@localhost on raible > 819 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 819 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 819 Query SHOW COLLATION > 819 Query SET NAMES latin1 > 819 Query SET character_set_results = NULL > 819 Query SET autocommit=1 > 819 Query SET sql_mode='STRICT_TRANS_TABLES' > 819 Query SET autocommit=0 > 819 Query SELECT t0.about, t0.isactive, > t0.allowcomments, t0.blacklist, t1.id, t1.description, > t1.image, t1.name, t2.id, t2.description, t2.image, > t2.name, t2.path, t2.websiteid, t1.path, t3.id, > t3.about, t3.isactive, t3.allowcomments, t3.blacklist, > t3.bloggercatid, t3.creator, t3.customstylesheet, > t3.datecreated, t3.defaultallowcomments, > t3.defaultcatid, t3.defaultcommentdays, > t3.defaultpageid, t3.defaultplugins, t3.description, > t3.editorpage, t3.editortheme, t3.emailaddress, > t3.emailcomments, t3.emailfromaddress, > t3.enablebloggerapi, t3.enablemultilang, t3.isenabled, > t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, > t3.locale, t3.commentmod, t3.name, t3.pagemodels, > t3.showalllangs, t3.timeZone, t3.weblogdayid, > t0.creator, t0.customstylesheet, t0.datecreated, > t0.defaultallowcomments, t4.id, t4.description, > t4.image, t4.name, t4.parentid, t4.path, t4.websiteid, > t0.defaultcommentdays, t0.defaultpageid, > t0.defaultplugins, t0.description, t0.editorpage, > t0.editortheme, t0.emailaddress, t0.emailcomments, > t0.emailfromaddress, t0.enablebloggerapi, > t0.enablemultilang, t0.isenabled, t0.displaycnt, > t0.handle, t0.icon, t0.lastmodified, t0.locale, > t0.commentmod, t0.name, t0.pagemodels, t0.showalllangs, > t0.timeZone, t0.weblogdayid FROM website t0 LEFT OUTER > JOIN weblogcategory t1 ON t0.bloggercatid = t1.id LEFT > OUTER JOIN weblogcategory t4 ON t0.defaultcatid = t4.id > LEFT OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id > LEFT OUTER JOIN website t3 ON t1.websiteid = t3.id WHERE > t0.id = '192197110220102821600270800003' > 819 Query rollback > 819 Quit > > 820 Connect raible@localhost on raible > 820 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VARIABLES WHERE Variable_name ='language' OR > Variable_name = 'net_write_timeout' OR Variable_name = > 'interactive_timeout' OR Variable_name = 'wait_timeout' > OR Variable_name = 'character_set_client' OR > Variable_name = 'character_set_connection' OR > Variable_name = 'character_set' OR Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' > OR Variable_name = 'transaction_isolation' OR > Variable_name = 'character_set_results' OR Variable_name > = 'timezone' OR Variable_name = 'time_zone' OR > Variable_name = 'system_time_zone' OR Variable_name = > 'lower_case_table_names' OR Variable_name = > 'max_allowed_packet' OR Variable_name = > 'net_buffer_length' OR Variable_name = 'sql_mode' OR > Variable_name = 'query_cache_type' OR Variable_name = > 'query_cache_size' OR Variable_name = 'init_connect' > 820 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT @@session.auto_increment_increment > 820 Query SHOW COLLATION > 820 Query SET NAMES latin1 > 820 Query SET character_set_results = NULL > 820 Query SET autocommit=1 > 820 Query SET sql_mode='STRICT_TRANS_TABLES' > 820 Query SET autocommit=0 > 820 Query SELECT t0.id, t0.action, t0.template, > t0.decorator, t0.description, t0.hidden, t0.updatetime, > t0.link, t0.name, t0.navbar, t0.outputtype, > t0.templatelang, t1.id, t1.about, t1.isactive, > t1.allowcomments, t1.blacklist, t2.id, t2.description, > t2.image, t2.name, t3.id, t3.description, t3.image, > t3.name, t3.path, t3.websiteid, t2.path, t4.id, > t4.about, t4.isactive, t4.allowcomments, t4.blacklist, > t4.bloggercatid, t4.creator, t4.customstylesheet, > t4.datecreated, t4.defaultallowcomments, > t4.defaultcatid, t4.defaultcommentdays, > t4.defaultpageid, t4.defaultplugins, t4.description, > t4.editorpage, t4.editortheme, t4.emailaddress, > t4.emailcomments, t4.emailfromaddress, > t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, > t4.displaycnt, t4.handle, t4.icon, t4.lastmodified, > t4.locale, t4.commentmod, t4.name, t4.pagemodels, > t4.showalllangs, t4.timeZone, t4.weblogdayid, > t1.creator, t1.customstylesheet, t1.datecreated, > t1.defaultallowcomments, t5.id, t5.description, > t5.image, t5.name, t5.parentid, t5.path, t5.websiteid, > t1.defaultcommentdays, t1.defaultpageid, > t1.defaultplugins, t1.description, t1.editorpage, > t1.editortheme, t1.emailaddress, t1.emailcomments, > t1.emailfromaddress, t1.enablebloggerapi, > t1.enablemultilang, t1.isenabled, t1.displaycnt, > t1.handle, t1.icon, t1.lastmodified, t1.locale, > t1.commentmod, t1.name, t1.pagemodels, t1.showalllangs, > t1.timeZone, t1.weblogdayid FROM webpage t0 LEFT OUTER > JOIN website t1 ON t0.websiteid = t1.id LEFT OUTER JOIN > weblogcategory t2 ON t1.bloggercatid = t2.id LEFT OUTER > JOIN weblogcategory t5 ON t1.defaultcatid = t5.id LEFT > OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT > OUTER JOIN website t4 ON t2.websiteid = t4.id WHERE > (t0.websiteid = '192197110220102848590607100006' AND > t0.link = 'custom.css') > 820 Query rollback > 820 Quit > > . > . > . > > > > 862 Connect raible@localhost on raible > 862 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VA > RIABLES WHERE Variable_name ='language' OR Variable_name = > 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR > Variable_name = 'wait_tim > eout' OR Variable_name = 'character_set_client' OR Variable_name = > 'character_set_connection' OR Variable_name = 'character_set' OR > Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name > = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Va > riable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = > 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variabl > e_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR > Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR > Variable > _name = 'query_cache_size' OR Variable_name = 'init_connect' > 862 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT > @@session.auto_increment_increment > 862 Query SHOW COLLATION > 862 Query SET NAMES latin1 > 862 Query SET character_set_results = NULL > 862 Query SET autocommit=1 > 862 Query SET sql_mode='STRICT_TRANS_TABLES' > 862 Query SET autocommit=0 > 862 Query SELECT t0.activationcode, t0.datecreated, > t0.emailaddress, t0.isenabled, t0.fullname, t0.locale, > t0.passphrase, t0.s > creenname, t0.timeZone, t0.username FROM rolleruser t0 WHERE t0.id = > '192197110220102848590604200004' > 862 Query rollback > 862 Quit > > > > 863 Connect raible@localhost on raible > 863 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SHOW VA > RIABLES WHERE Variable_name ='language' OR Variable_name = > 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR > Variable_name = 'wait_tim > eout' OR Variable_name = 'character_set_client' OR Variable_name = > 'character_set_connection' OR Variable_name = 'character_set' OR > Variable_name = > 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name > = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Va > riable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = > 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variabl > e_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR > Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR > Variable > _name = 'query_cache_size' OR Variable_name = 'init_connect' > 863 Query /* mysql-connector-java-5.1.27 ( Revision: > alexander.sokla...@oracle.com-20131021093118-gtm1bh1vb450xipt > ) */SELECT > @@session.auto_increment_increment > 863 Query SHOW COLLATION > 863 Query SET NAMES latin1 > 863 Query SET character_set_results = NULL > 863 Query SET autocommit=1 > 863 Query SET sql_mode='STRICT_TRANS_TABLES' > 863 Query SET autocommit=0 > 863 Query SELECT t0.about, t0.isactive, > t0.allowcomments, t0.blacklist, t1.id, t1.description, > t1.image, t1.name, t2.id, t2.de > scription, t2.image, t2.name, t2.path, t2.websiteid, t1.path, t3.id, > t3.about, t3.isactive, t3.allowcomments, t3.blacklist, t3.bloggercatid, > t3.crea > tor, t3.customstylesheet, t3.datecreated, t3.defaultallowcomments, > t3.defaultcatid, t3.defaultcommentdays, t3.defaultpageid, > t3.defaultplugins, t3.d > escription, t3.editorpage, t3.editortheme, t3.emailaddress, > t3.emailcomments, t3.emailfromaddress, t3.enablebloggerapi, > t3.enablemultilang, t3.isena > bled, t3.displaycnt, t3.handle, t3.icon, t3.lastmodified, t3.locale, > t3.commentmod, t3.name, t3.pagemodels, t3.showalllangs, t3.timeZone, > t3.weblogd > ayid, t0.creator, t0.customstylesheet, t0.datecreated, > t0.defaultallowcomments, t4.id, t4.description, t4.image, t4.name, > t4.parentid, t4.path, t4.w > ebsiteid, t0.defaultcommentdays, t0.defaultpageid, t0.defaultplugins, > t0.description, t0.editorpage, t0.editortheme, t0.emailaddress, > t0.emailcommen > ts, t0.emailfromaddress, t0.enablebloggerapi, t0.enablemultilang, > t0.isenabled, t0.displaycnt, t0.handle, t0.icon, t0.lastmodified, > t0.locale, t0.co > mmentmod, t0.name, t0.pagemodels, t0.showalllangs, t0.timeZone, > t0.weblogdayid FROM website t0 LEFT OUTER JOIN weblogcategory t1 ON > t0.bloggercatid > = t1.id LEFT OUTER JOIN weblogcategory t4 ON t0.defaultcatid = t4.id LEFT > OUTER JOIN weblogcategory t2 ON t1.parentid = t2.id LEFT OUTER JOIN websit > e t3 ON t1.websiteid = t3.id WHERE t0.id = > '192197110220102848590607100006' > 863 Query rollback > 863 Quit > > > > > 141030 14:49:10 864 Query SET NAMES latin1 > 864 Query SET character_set_results = NULL > 864 Query SET autocommit=1 > 864 Query SET sql_mode='STRICT_TRANS_TABLES' > 864 Query SET autocommit=0 > 864 Query SELECT t0.value FROM roller_properties t0 > WHERE t0.name = 'site.frontpage.weblog.aggregated' > 864 Query rollback > 864 Quit >
