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