| Bug #83868 | PHP Warning: mysql_pconnect(): Lost connection to MySQL server at 'reading init | ||
|---|---|---|---|
| Submitted: | 17 Nov 2016 12:24 | Modified: | 24 Nov 2016 15:07 |
| Reporter: | Altaf Badrudin | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.73-log | OS: | Red Hat (2.6. 32-504.8.1.el6.x86_64) |
| Assigned to: | CPU Architecture: | Any | |
[17 Nov 2016 13:13]
Altaf Badrudin
serious change to s2
[17 Nov 2016 13:56]
MySQL Verification Team
"system error: 113 " as far as I can tell, this means "#define EHOSTUNREACH 113 /* No route to host */" So, it is not bug within MySQL... check your networking.
[17 Nov 2016 14:27]
Altaf Badrudin
Is thier any trace i can enable to catch this. do you have previous cutomers report similar issue... Thanks.
[17 Nov 2016 19:00]
MySQL Verification Team
According Shane`s prior comment.
[24 Nov 2016 15:07]
Altaf Badrudin
still seeing the above issue... networks have not found mnuch information so far.
doing a query on information_schema.processlist i get the below. you can see the state "freeing items"
ID USER HOST DB COMMAND TIME STATE INFO
89053 arq-client 10.53.18.5:36184 hybrid_analytics Query 0 freeing items insert into 201611_ana_realtime_unique_viewers (longcode, channel_name, service_id, app_status, session_id) values ('201611240810', 'Create Craft', '24384', 'WATCHING_DTT', 'SAMJ4713.12334.72539089270' )
88978 arq-client 10.53.18.6:56600 hybrid_analytics Query 0 freeing items insert into 20161124_channel_by_min (longcode, channel_name, service_id, app_status, total, pk) values ('201611240810', 'QVC Beauty', '28288', 'DTT_IS_RUNNING', '1', 'QVC Beauty28288201611240810DTT_IS_RUNNING' ) ON DUPLICATE KEY UPDATE total = total+1
Can you let me know if this is a bug issue.....
Thanks
Description: We are getting erros reported by the php clients as below... PHP Warning: mysql_pconnect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 113 has occured on serval occasions during the week .... quries ID USER HOST DB COMMAND TIME STATE INFO 31483 arq-client 10.53.18.5:55002 hybrid_analytics Query 0 Opening tables DESCRIBE 2016_46_2_analytics 31480 arq-client 10.53.18.6:56441 hybrid_analytics Query 0 Opening tables DESCRIBE 2016_46_2_analytics 31236 arq-client 10.53.18.8:43268 hybrid_analytics Query 0 removing tmp table DESCRIBE 2016_46_2_analytics 31234 arq-client 10.53.18.8:43266 hybrid_analytics Query 0 Opening tables DESCRIBE 2016_46_2_analytics 31209 arq-client 10.53.18.6:55710 hybrid_analytics Query 0 freeing items delete from 201611_ana_realtime_unique_viewers where longcode < '201611152100' 31132 arq-client 10.53.18.8:43200 hybrid_analytics Query 0 removing tmp table DESCRIBE 2016_46_2_analytics 31103 arq-client 10.53.18.8:43176 hybrid_analytics Query 0 Sending data DESCRIBE 2016_46_2_analytics 30947 arq-client 10.53.18.6:55606 hybrid_analytics Query 0 updating delete from 201611_ana_realtime_unique_viewers where longcode < '201611152100' 29581 arq-client 10.53.18.5:54208 hybrid_analytics Query 0 update insert into 20161115_channel_by_hr (longcode, channel_name, service_id, app_status, total_00, total_01, total_02, total_03, total_04, total_05, total_06, total_07, total_08, total_09, total_10, total_11, total_12, total_13, total_14, total_15, total_16, total_17, total_18, total_19, total_20, total_21, total_22, total_23, day_total, pk) values ('20161115', 'Create Craft', '24384', 'WATCHING_DTT' Id User Host db Command Time State Info 28560 arq-client 10.53.18.6:54734 hybrid_analytics Sleep 72 NULL 28616 arq-client 10.53.18.7:44204 hybrid_analytics Sleep 72 NULL 28617 arq-client 10.53.18.5:51680 hybrid_analytics Sleep 8 NULL 28618 arq-client 10.53.18.7:44206 hybrid_analytics Sleep 9 NULL 28654 arq-client 10.53.18.5:51686 hybrid_analytics Sleep 9 NULL 28655 arq-client 10.53.18.5:51688 hybrid_analytics Sleep 1 NULL 28656 arq-client 10.53.18.7:44212 hybrid_analytics Sleep 9 NULL 28659 arq-client 10.53.18.7:44218 hybrid_analytics Sleep 72 NULL 28668 arq-client 10.53.18.5:51692 hybrid_analytics Sleep 72 NULL 28674 arq-client 10.53.18.8:41306 hybrid_analytics Sleep 12 NULL 28680 arq-client 10.53.18.5:51700 hybrid_analytics Sleep 1 NULL 28705 arq-client 10.53.18.5:51702 hybrid_analytics Sleep 8 NULL 28708 arq-client 10.53.18.5:51706 hybrid_analytics Sleep 17 NUL Uptime: 117231 Threads: 3136 Questions: 38181036 Slow queries: 16 Opens: 2969 Flush tables: 1 Open tables: 2959 Queries per second avg: 325.690 looks like a lot of sleep connections being held open... Thanks How to repeat: resart mysql server and the bugs starts to appear over a period of time.