I believe you're right. Keith, my sysadmin, suggested trying JNDI and was able to get it to work. Here's what he said:
---- Seems to be working using connection pooling again. The roller-custom.properties needed to reference the datasource jndi name like this: database.configuration=jndi database.jndi.name=java:comp/env/jdbc/rollerdb I'm still curious about the high number of database hits per HTTP request, but that's another story for another day. I don't think it would scale very well as it is though. Increasing MySQL in memory caching helped a lot though. ---- I switched to JDBC over JNDI back in March 2011: http://raibledesigns.com/rd/entry/upgraded_to_apache_roller_5 > On Nov 1, 2014, at 09:50, Dave <[email protected]> wrote: > > 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 <[email protected]> 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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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: >> [email protected] >> ) */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 >>
