You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Dave <sn...@gmail.com> on 2014/11/01 14:50:11 UTC
Re: Roller and database connections
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 <ma...@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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
>
Re: Roller and database connections
Posted by Matt Raible <ma...@raibledesigns.com>.
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 <sn...@gmail.com> 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 <ma...@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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.soklakov@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
>>