2010-12-02 13:40:50: (critical) MySQL Monitor Agent 2.3.1.2044 started. 2010-12-02 13:40:50: (critical) network-io.c:324: successfully reconnected to dashboard at https://agent@127.0.0.1:18443/heartbeat 2010-12-02 13:40:50: (critical) agent_mysqld.c:723: successfully connected to database at 127.0.0.1:5132 as user msandbox (with password: YES) 2010-12-02 13:41:31: (critical) MySQL Monitor Agent 2.3.1.2044 started. 2010-12-02 13:41:31: (critical) network-io.c:324: successfully reconnected to dashboard at https://agent@127.0.0.1:18443/heartbeat 2010-12-02 13:41:31: (critical) agent_mysqld.c:723: successfully connected to database at 127.0.0.1:5132 as user msandbox (with password: YES) 2010-12-02 13:42:08: (debug) path.c.121: adjusting relative path (lib/mysql-aggregator/lua/aggr.lua) to base_dir (/Applications/mysql/enterprise/2.3/agent-2.3.1.2044). New path: /Applications/mysql/enterprise/2.3/agent-2.3.1.2044/lib/mysql-aggregator/lua/aggr.lua 2010-12-02 13:42:08: (message) unix-daemon.c:136: [angel] we try to keep PID=3295 alive 2010-12-02 13:42:08: (debug) unix-daemon.c:157: waiting for 3295 2010-12-02 13:42:08: (debug) unix-daemon.c:121: we are the child: 3295 2010-12-02 13:42:08: (message) mysql-monitor-agent 2.3.1.2044 started 2010-12-02 13:42:25: (debug) aggr_curl.c:17: About to connect() to 127.0.0.1 port 18443 (#0) 2010-12-02 13:42:25: (debug) aggr_curl.c:17: Trying 127.0.0.1... 2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Client hello (1): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server hello (2): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, CERT (11): 2010-12-02 13:42:25: (debug) aggr_curl.c:17: 2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server key exchange (12): 2010-12-02 13:42:25: (debug) aggr_curl.c:17: 2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server finished (14): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Client key exchange (16): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS change cipher, Client hello (1): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Finished (20): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS change cipher, Client hello (1): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Finished (20): 2010-12-02 13:42:25: (debug) aggr_curl.c:17:  2010-12-02 13:42:25: (debug) aggr_curl.c:17: SSL connection using DHE-RSA-AES256-SHA 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Server certificate: 2010-12-02 13:42:26: (debug) aggr_curl.c:17: subject: C=US; O=Oracle Corporation; OU=MySQL Enterprise Tools; CN=MySQL Enterprise Monitor Test Certificate 2010-12-02 13:42:26: (debug) aggr_curl.c:17: start date: 2010-11-22 18:17:16 GMT 2010-12-02 13:42:26: (debug) aggr_curl.c:17: expire date: 2011-11-22 18:17:16 GMT 2010-12-02 13:42:26: (debug) aggr_curl.c:17: issuer: C=US; O=Oracle Corporation; OU=MySQL Enterprise Tools; CN=MySQL Enterprise Monitor Test Certificate 2010-12-02 13:42:26: (debug) aggr_curl.c:17: SSL certificate verify result: self signed certificate (18), continuing anyway. 2010-12-02 13:42:26: (debug) aggr_curl.c:17: GET /v2/rest/instances HTTP/1.1 Host: 127.0.0.1:18443 Accept: */* Authorization: Basic YWdlbnQ6bXlzcWw= User-Agent: MySQL Aggregator/ Content-Type: application/json 2010-12-02 13:42:26: (debug) aggr_curl.c:17: HTTP/1.1 404 Not Found 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Server: Apache-Coyote/1.1 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Content-Type: text/html;charset=utf-8 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Content-Length: 952 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Date: Thu, 02 Dec 2010 18:42:26 GMT 2010-12-02 13:42:26: (debug) aggr_curl.c:17: 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Apache Tomcat/6.0.14 - Error report

HTTP Status 404 -

type Status report

message

description The requested resource () is not available.

Apache Tomcat/6.0.14

2010-12-02 13:42:26: (debug) aggr_curl.c:17: Connection #0 to host 127.0.0.1 left intact 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Re-using existing connection! (#0) with host 127.0.0.1 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Connected to 127.0.0.1 (127.0.0.1) port 18443 (#0) 2010-12-02 13:42:26: (debug) aggr_curl.c:17: GET /v2/rest/instance/mysql/StatementAnalysisSupport/46ad1a40-200c-43bc-8a63-35eec19e9aa2 HTTP/1.1 Host: 127.0.0.1:18443 Accept: */* Authorization: Basic YWdlbnQ6bXlzcWw= User-Agent: MySQL Aggregator/ Content-Type: application/json 2010-12-02 13:42:26: (debug) aggr_curl.c:17: HTTP/1.1 200 OK 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Server: Apache-Coyote/1.1 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Content-Type: application/json 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Transfer-Encoding: chunked 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Date: Thu, 02 Dec 2010 18:42:26 GMT 2010-12-02 13:42:26: (debug) aggr_curl.c:17: 2010-12-02 13:42:26: (debug) aggr_curl.c:17: 146 { "name": "46ad1a40-200c-43bc-8a63-35eec19e9aa2", "parent": "/instance/mysql/Server/46ad1a40-200c-43bc-8a63-35eec19e9aa2", "values": { "auto_explain_min_exec_time_ms": 1, "capture_examples": "true", "capture_explain": "true", "enabled": "true", "frequency": null } } 2010-12-02 13:42:26: (debug) aggr_curl.c:17: 0 2010-12-02 13:42:26: (debug) aggr_curl.c:17: Connection #0 to host 127.0.0.1 left intact 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Re-using existing connection! (#0) with host 127.0.0.1 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Connected to 127.0.0.1 (127.0.0.1) port 18443 (#0) 2010-12-02 13:43:09: (debug) aggr_curl.c:17: PUT /v2/rest/instance/mysql/statement/46ad1a40-200c-43bc-8a63-35eec19e9aa2.phorum5_linux.d122e849a01a0074d23c26630cddf3a0.1 HTTP/1.1 Host: 127.0.0.1:18443 Accept: */* Authorization: Basic YWdlbnQ6bXlzcWw= X-MySQL-Monitor-Data-Timestamp: 2010-10-20T19:34:21Z User-Agent: MySQL Aggregator/ Content-Type: application/json Content-Length: 1315 Expect: 100-continue 2010-12-02 13:43:09: (debug) aggr_curl.c:17: About to connect() to 127.0.0.1 port 18443 (#1) 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Trying 127.0.0.1... 2010-12-02 13:43:09: (debug) aggr_curl.c:17: connected 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Connected to 127.0.0.1 (127.0.0.1) port 18443 (#1) 2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Client hello (1): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: HTTP/1.1 100 Continue 2010-12-02 13:43:09: (debug) aggr_curl.c:17: { "attributes": null, "name": "46ad1a40-200c-43bc-8a63-35eec19e9aa2.phorum5_linux.d122e849a01a0074d23c26630cddf3a0.1", "parent": "/instance/mysql/statementsummary/46ad1a40-200c-43bc-8a63-35eec19e9aa2.phorum5_linux.d122e849a01a0074d23c26630cddf3a0", "values": { "bytes": 2063, "comment": "", "connection_id": 15017, "errors": 0, "exec_time": 381, "host_from": "tyr55", "host_to": "bur02.norway.sun.com", "no_good_index_used": 0, "no_index_used": 1, "rows": 10, "source_location": "[0] /usr/local/apache/htdocs/phorum/include/db/mysql/mysqli.php:145 mysqli_real_query()\n[1] /usr/local/apache/htdocs/phorum/include/db/mysql.php:759 phorum_db_interact()\n[2] /usr/local/apache/htdocs/phorum/mods/announcements/announcements.php:54 phorum_db_get_recent_messages()\n[3] :0 phorum_setup_announcements()\n[4] /usr/local/apache/htdocs/phorum/common.php:1691 call_user_func_array()\n[5] /usr/local/apache/htdocs/phorum/common.php:853 phorum_hook()\n[6] /usr/local/apache/htdocs/phorum/index.php:21 include_once()\n", "text": "SELECT *\n FROM _messages\n USE INDEX (new_threads)\n WHERE status=2 AND forum_id = 1 AND moved = 0 AND parent_id = 0 ORDER BY message_id DESC LIMIT 5", "user": "phorum5", "warnings": 0 } } 2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server hello (2): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, CERT (11): 2010-12-02 13:43:09: (debug) aggr_curl.c:17: 2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server key exchange (12): 2010-12-02 13:43:09: (debug) aggr_curl.c:17: 2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Server finished (14): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Client key exchange (16): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS change cipher, Client hello (1): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Finished (20): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS change cipher, Client hello (1): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSLv3, TLS handshake, Finished (20): 2010-12-02 13:43:09: (debug) aggr_curl.c:17:  2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSL connection using DHE-RSA-AES256-SHA 2010-12-02 13:43:09: (debug) aggr_curl.c:17: HTTP/1.1 204 No Content 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Server: Apache-Coyote/1.1 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Date: Thu, 02 Dec 2010 18:43:09 GMT 2010-12-02 13:43:09: (debug) aggr_curl.c:17: 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Connection #0 to host 127.0.0.1 left intact 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Server certificate: 2010-12-02 13:43:09: (debug) aggr_curl.c:17: subject: C=US; O=Oracle Corporation; OU=MySQL Enterprise Tools; CN=MySQL Enterprise Monitor Test Certificate 2010-12-02 13:43:09: (debug) aggr_curl.c:17: start date: 2010-11-22 18:17:16 GMT 2010-12-02 13:43:09: (debug) aggr_curl.c:17: expire date: 2011-11-22 18:17:16 GMT 2010-12-02 13:43:09: (debug) aggr_curl.c:17: issuer: C=US; O=Oracle Corporation; OU=MySQL Enterprise Tools; CN=MySQL Enterprise Monitor Test Certificate 2010-12-02 13:43:09: (debug) aggr_curl.c:17: SSL certificate verify result: self signed certificate (18), continuing anyway. 2010-12-02 13:43:09: (debug) aggr_curl.c:17: PUT /v2/rest/instance/mysql/statementsummary/46ad1a40-200c-43bc-8a63-35eec19e9aa2.phorum5_linux.d122e849a01a0074d23c26630cddf3a0 HTTP/1.1 Host: 127.0.0.1:18443 Accept: */* Authorization: Basic YWdlbnQ6bXlzcWw= User-Agent: MySQL Aggregator/ Content-Type: application/json Content-Length: 793 2010-12-02 13:43:09: (debug) aggr_curl.c:17: { "attributes": null, "name": "46ad1a40-200c-43bc-8a63-35eec19e9aa2.phorum5_linux.d122e849a01a0074d23c26630cddf3a0", "parent": "/instance/mysql/server/46ad1a40-200c-43bc-8a63-35eec19e9aa2", "values": { "bytes": 2063, "count": 1, "database": "phorum5_linux", "errors": 0, "exec_time": 381, "max_bytes": 2063, "max_exec_time": 381, "max_rows": 10, "min_bytes": 2063, "min_exec_time": 381, "min_rows": 10, "no_good_index_used": 0, "no_index_used": 1, "query_type": "SELECT", "rows": 10, "text": "SELECT * FROM _messages USE INDEX ( new_threads ) WHERE status = ? AND forum_id = ? AND moved = ? AND parent_id = ? ORDER BY message_id DESC LIMIT ? ", "text_hash": "d122e849a01a0074d23c26630cddf3a0", "warnings": 0 } } 2010-12-02 13:43:09: (debug) aggr_curl.c:17: HTTP/1.1 204 No Content 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Server: Apache-Coyote/1.1 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Date: Thu, 02 Dec 2010 18:43:09 GMT 2010-12-02 13:43:09: (debug) aggr_curl.c:17: 2010-12-02 13:43:09: (debug) aggr_curl.c:17: Connection #1 to host 127.0.0.1 left intact 2010-12-02 13:49:08: (message) Initiating shutdown, requested from signal handler 2010-12-02 13:49:08: (debug) aggr_mainloop.c:822: ping thread going down 2010-12-02 13:49:08: (debug) aggr_curl_thread.c:257: curl-request thread going down 2010-12-02 13:49:08: (debug) aggr_curl_thread.c:320: curl thread going down 2010-12-02 13:49:08: (debug) aggr_mainloop.c:769: aggr thread going down 2010-12-02 13:49:09: (message) shutting down normally, exit code is: 0 2010-12-02 13:49:09: (debug) unix-daemon.c:167: 3295 returned: 3295 2010-12-02 13:49:09: (message) unix-daemon.c:176: [angel] PID=3295 exited normally with exit-code = 0 (it used 3188 kBytes max) 2010-12-02 13:49:09: (message) Initiating shutdown, requested from mysql-monitor-agent-cli.c:571 2010-12-02 13:49:09: (message) shutting down normally, exit code is: 0