You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Matt Raible <ma...@raibledesigns.com> on 2014/10/30 22:29:08 UTC

Roller and database connections

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
>> 

Re: Roller and database connections

Posted by Dave <sn...@gmail.com>.
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
>