MySQL Forums
Forum List  »  Italian

Soluzione a 'Lost connection to mysql server during query'
Posted by:
Date: November 13, 2012 04:09AM

Vi riporto di seguito le caratteristiche del mio VPS tiscali:
-Operating system Ubuntu Linux 10.04
-Webmin version 1.600
-Kernel and CPU Linux 2.6.18-194.26.1.el5.028stab079.2 on i686
-Processor information Quad-Core AMD Opteron(tm) Processor 8356, 2 cores
-CPU load averages 0.51 (1 min) 0.60 (5 mins) 0.56 (15 mins)
-CPU usage 2% user, 1% kernel, 0% IO, 97% idle
-Real memory 2 GB total, 241.89 MB used
-Local disk space 28.61 GB total, 17.12 GB used

Stamattina ho verificato se ci fossero dei problemi strani tracciati nei log. Riporto di seguito quanto trovato in ognuno.


In “Mysql-err.log” ho trovato “ripetutamente”(in ogni minuto) tracciati i seguenti errori:
121101 10:26:01 [Note] Plugin 'FEDERATED' is disabled.
121101 10:26:01 [Note] Plugin 'InnoDB' is disabled.
121101 10:26:01 [Note] Event Scheduler: Loaded 0 events
121101 10:26:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
121101 10:26:01 [ERROR] /usr/sbin/mysqld: Table './shoponmyweb/disponib' is marked as crashed and should be repaired
121101 10:26:01 [Warning] Checking table: './shoponmyweb/disponib'


In “Mysql-slow-query.log” ho trovato “ripetutamente” tracciate le seguenti segnalazioni:
/usr/sbin/mysqld, Version: 5.1.41-3ubuntu12.6-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument


In “syslog” ho trovato “ripetutamente”(in ogni minuto) tracciati i seguenti errori:
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19599]: Upgrading MySQL tables if necessary.
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysql' as: /usr/bin/mysql
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19647]: Checking for insecure root accounts.
Nov 1 10:20:04 vps1490 /etc/mysql/debian-start[19664]: Triggering myisam-recover for all MyISAM tables


Nello script php che gestisce le query da inviare al db ho previsto la scrittura su file di tutte le query che crashano con i seguenti errori:
-Lost connection to mysql server during query
-Mysql has gone away

Nonostante l'ottimizzazione delle query fatta tenendo sottocontrollo il file delle slow-query, arrivando a gestire anche i campi fulltext, in questo file mi ritrovo ripetutamente query crashate per i 2 suddetti errori. Riporto di seguito degli esempi:
2012-11-13 9:25:01 - Lost connection to MySQL server during query
www.XXXXXX.com/item/TRISTAR-Tostapane-BR-1005-Porta-toast-e-vasetto-di-marmellata-30-801-50-LNK-PM0372-PMPN180810.html
select a.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTable dsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTable dsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index (i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('CS0001','CS0002','CS0018','CS0003','CS0017','CS0004','CS0019','CS0005','CS0006','CS0008','CS0007','CS0016','CS0010','CS0011','CS0009','CS0012','1','3','5','2','CS0013','CS0014','PM0041','CS0015','PM0680','DP0001','DP0002','DP0003','DP0004','DP0005','DP0007','DP0008','DP0009','DP0010','DP0011','DP0013','DP0014','DP0015','DP0016','PM0772','PM0928','PM0071','PM0467','PM0232','PM0429','PM0482','PM0570','PM0571','PM0664','PM0665','PM0166','PM0224','PM0771','PM0178','PM0276','PM0369','PM0517','PM0526','PM0528','PM0546','PM0556','PM0598','PM0629','PM0843','PM0863','PM0866','PM0896','PM0561','PM0967','PM0094','PM0121','PM0231','PM0239','PM0286','PM0532','PM0421','PM0029','PM0034','PM0036','PM0364','PM0587','PM0031','PM0038','PM0635','PM0636','PM0810','PM0840','PM0151','PM0153','PM0544','PM0628','PM0716','PM0886','PM0328','PM0431','PM0432','PM0538','PM0549','PM0611','PM0612','PM0618','PM0795','PM0798','PM0868','PM0919','PM0345','PM0370','PM0379','PM0382','PM0410','PM0766','PM0792','PM0847','PM0384','PM0508','PM0428','PM0572','PM0768','PM0841','PM0860','PM0959','PM0449','PM0709','PM0476','PM0622','PM0708','PM0478','PM0724','PM0790','PM0932','PM0955','PM0975','PM0978','PM0496','PM0864','PM0878','PM0592','PM0005','PM0707','PM0710','PM0205','PM0329','PM0706','PM0213','PM0888','PM0596','PM0674','PM0799','PM0781','PM0466','PM0920','PM0148','PM0395','PM0397','PM0398','PM0455','PM0520','PM0522','PM0876','PM0976','PM0892','PM0958','PM0901','PM0925','PM0998','PM1010','PM1012','PM0413','PM0784','PM0911','PM0651','PM0668','PM0922','PM0783','PM0913','PM0823','PM0969','PM0685','PM0567','PM0568','PM0569','PM0746','PM0723','PM0737','PM0921','PM0320','PM0389','PM0392','PM0393','PM0427','PM0516','PM0524','PM0606','PM0671','PM0675','PM0785','PM0786','PM0391','PM0614','PM0705','PM0796','PM0817','PM0818','PM0819','PM0820','PM0821','PM0880','PM0894','PM0645','PM0663','PM0693','PM0055','PM0812','PM0052','PM0057','PM0091','PM0095','PM0268','PM0333','PM0893','PM0113','PM0219','PM0518','PM0648','PM0728','PM0833','PM0852','PM0917','PM0962','PM0297','PM0315','PM0322','PM0731','PM0767','PM0856','PM0882','PM0923','PM1008','PM0350','PM0380','PM0762','PM0765','PM0941','PM0465','PM1004','PM1011','PM0470','PM0487','PM0513','PM0525','PM0553','PM0581','PM0610','PM0649','PM0726','PM0763','PM0802','PM0853','PM0854','PM0904','PM0965','PM0988','PM0999','PM0486','PM0758','PM0855','PM0877','PM0931','PM0935','PM0952','PM0993','PM0195','PM0196','PM0211','PM0247','PM0269','PM0271','PM0314','PM0323','PM0354','PM0357','PM0260','PM0270','PM0317','PM0325','PM0358','PM0373','PM0235','PM0381','PM0539','PM0540','PM0542','PM0623','PM0624','PM0729','PM0881','PM0356','PM0653','PM0654','PM0800','PM0447','PM0638','PM0451','PM0543','PM0550','PM0575','PM0548','PM0579','PM0580','PM0578','PM0828','PM0406','PM0068','PM0161','PM0197','PM0198','PM0199','PM0240','PM0279','PM0342','PM0351','PM0353','PM0363','PM0474','PM0658','PM0774','PM0910','PM0131','PM0142','PM0207','PM0226','PM0227','PM0228','PM0229','PM0283','PM0285','PM0290','PM0298','PM0299','PM0306','PM0307','PM0385','PM0646','PM0698','PM0699','PM0703','PM0972','PM0973','PM0362','PM0732','PM0626','PM0791','PM0670','PM0776','PM0735','PM0788','PM0744','PM0971','PM0761','PM0915','PM0060','PM0497','PM0278','PM0838','PM0715','PM0787','PM0809','PM0824','PM0829','PM0832','PM0916','PM0930','PM0826','PM0617','PM0804','PM0805','PM0970','PM0661','PM0673','PM0681','PM0682','PM0803','PM0087','PM0831','PM0689','PM0691','PM0918','PM0702','PM0713','PM0808','PM0871','PM0080','PM0141','PM0149','PM0537','PM0545','PM0144','PM0529','PM0630','PM0631','PM0632','PM0633','PM0634','PM0815','PM0842','PM0846','PM0865','PM0889','PM0248','PM0417','PM0221','PM0236','PM0415','PM0582','PM0584','PM0801','PM0419','PM0678','PM0679','PM0376','PM0748','PM0844','PM0425','PM0459','PM0530','PM0576','PM0851','PM0751','PM0759','PM0021','PM0024','PM0035','PM0256','PM0372','PM0590','PM0026','PM0179','PM0241','PM0261','PM0266','PM0273','PM0295','PM0033','PM0264','PM0265','PM0044','PM0075','PM0120','PM0125','PM0132','PM0242','PM0084','PM0098','PM0170','PM0138','PM0218','PM0243','PM0272','PM0347','PM0365','PM0160','PM0627','PM0797','PM0201','PM0289','PM0072','PM0073','PM0074','PM0102','PM0133','PM0146','PM0223','PM0437','PM0551','PM0945','PM1007','PM0014','PM0037','PM0049','PM0056','PM0023','PM0321','PM0326','PM0371','PM0409','PM0426','PM0483','PM0498','PM0509','PM0586','PM0657','PM0717','PM0727','PM0850','PM0898','PM0907','PM0040','PM0316','PM0462','PM0479','PM0484','PM0505','PM0506','PM0531','PM0599','PM0656','PM0070','PM0103','PM0107','PM0110','PM0111','PM0117','PM0140','PM0145','PM0154','PM0192','PM0457','PM0574','PM0655','PM0123','PM0443','PM0641','PM0849','PM0869','PM0906','PM0135','PM0189','PM0695','PM0948','PM0312','PM0535','PM0589','PM0602','PM0694','PM0733','PM0773','PM0946','PM0338','PM0442','PM0555','PM0583','PM0621','PM0368','PM0440','PM0491','PM0619','PM0895','PM0990','PM0991','PM0460','PM0468','PM0480','PM0481','PM0511','PM0512','PM0757','PM0848','PM0858','PM0608','PM0912','PM0640','PM0642','PM0672','PM0676','PM0686','PM0887','PM0933','PM0934','PM0947','PM0964','PM0779','PM0859','PM0984','PM0987','PM0940','PM0953','PM0944','PM1003','PM0885','PM0564','PM0255','PM0834','PM0835','PM0879','PM0929','PM0942','PM0697','PM0830','PM0116','PM0119','PM0184','PM0216','PM0510','PM0769','PM0186','PM0360','PM0560','PM0711','PM0129','PM0288','PM0181','PM0245','PM0262','PM0011','PM0155','PM0222','PM0257','PM0558','PM0077','PM0152','PM0282','PM0402','PM0403','PM0536','PM0643','PM0700','PM0902','PM0903','PM0974','PM0082','PM0104','PM0252','PM0258','PM0263','PM0401','PM0712','PM0980','PM0995','PM0106','PM0169','PM0400','PM0954','PM0109','PM0136','PM0139','PM0187','PM0214','PM0585','PM0718','PM0770','PM0775','PM0926','PM0158','PM0225','PM0905','PM0174','PM0206','PM0301','PM0303','PM0313','PM0346','PM0554','PM0747','PM0836','PM0862','PM0897','PM0176','PM0215','PM0753','PM0899','PM0183','PM0217','PM0230','PM0284','PM0291','PM0300','PM0302','PM0305','PM0334','PM0339','PM0725','PM0857','PM0453','PM0811','PM0816','PM0861','PM0490','PM0839','PM0515','PM0950','PM0494','PM0613','PM0704','PM0977','PM0008','PM0012','PM0015','PM0016','PM0018','PM0399','PM0989','PM0423','PM0433','PM0434','PM0438','PM0444','PM0541','PM0552','PM0557','PM0659','PM0741','PM0777','PM0436','PM0755','PM0756','PM0789','PM0872','PM0890','PM0986','PM1002','PM0501','PM0742','PM0745','PM0503','PM0504','PM0720','PM0721','PM0736','PM0738','PM0739','PM0740','PM0845','PM0090','PM0092','PM0096','PM0097','PM0190','PM0304','PM0601','PM0873','PM0408','PM0456','PM0473','PM0600','PM0605','PM0534','PM0604','PM0065','PM0249','PM0267','PM0281','PM0324','PM0461','PM0981','PM0203','PM0210','PM0441','PM0647','PM0730','PM0794','PM0874','PM0960','PM0101','PM0124','PM0156','PM0167','PM0168','PM0171','PM0172','PM0191','PM0666','PM0749','PM0837','PM0209','PM0332','PM0341','PM0352','PM0366','PM0377','PM0378','PM0386','PM0559','PM0609','PM0238','PM0331','PM0335','PM0336','PM0340','PM0343','PM0348','PM0387','PM0388','PM0620','PM0251','PM0280','PM0294','PM0308','PM0309','PM0310','PM0463','PM0793','PM0806','PM0293','PM0330','PM0908','PM0963','PM0472','PM0507','PM0523','PM0719','PM0957','PM0961','PM1000','PM0764','PM1006','PM0985','PM1005','PM0752','PM0814','PM0982','PM0924','PM0951','PM0968','PM0966','PM0927','PM0979','PM0994','PM0996','PM0938') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice and a.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 and MATCH (a.modello,a.des_lung,a.codice) AGAINST ('tristar tostapane br 1005 porta toast vasetto marmellata 30 801 50' IN BOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

2012-11-13 9:28:02 - Lost connection to MySQL server during query
www.XXXXXX.com/item/CONTINENTAL-SportContact-2-225-50-R17-94W-con-cerchione-a-striscia-AO-LNK-1-GDA009926.html?par_adv=IPB
select count(*) totrec from disponib a, marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index (i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('CS0001','CS0002','CS0018','CS0003','CS0017','CS0004','CS0019','CS0005','CS0006','CS0008','CS0007','CS0016','CS0010','CS0011','CS0009','CS0012','1','3','5','2','CS0013','CS0014','PM0041','CS0015','PM0680','DP0001','DP0002','DP0003','DP0004','DP0005','DP0007','DP0008','DP0009','DP0010','DP0011','DP0013','DP0014','DP0015','DP0016','PM0772','PM0928','PM0071','PM0467','PM0232','PM0429','PM0482','PM0570','PM0571','PM0664','PM0665','PM0166','PM0224','PM0771','PM0178','PM0276','PM0369','PM0517','PM0526','PM0528','PM0546','PM0556','PM0598','PM0629','PM0843','PM0863','PM0866','PM0896','PM0561','PM0967','PM0094','PM0121','PM0231','PM0239','PM0286','PM0532','PM0421','PM0029','PM0034','PM0036','PM0364','PM0587','PM0031','PM0038','PM0635','PM0636','PM0810','PM0840','PM0151','PM0153','PM0544','PM0628','PM0716','PM0886','PM0328','PM0431','PM0432','PM0538','PM0549','PM0611','PM0612','PM0618','PM0795','PM0798','PM0868','PM0919','PM0345','PM0370','PM0379','PM0382','PM0410','PM0766','PM0792','PM0847','PM0384','PM0508','PM0428','PM0572','PM0768','PM0841','PM0860','PM0959','PM0449','PM0709','PM0476','PM0622','PM0708','PM0478','PM0724','PM0790','PM0932','PM0955','PM0975','PM0978','PM0496','PM0864','PM0878','PM0592','PM0005','PM0707','PM0710','PM0205','PM0329','PM0706','PM0213','PM0888','PM0596','PM0674','PM0799','PM0781','PM0466','PM0920','PM0148','PM0395','PM0397','PM0398','PM0455','PM0520','PM0522','PM0876','PM0976','PM0892','PM0958','PM0901','PM0925','PM0998','PM1010','PM1012','PM0413','PM0784','PM0911','PM0651','PM0668','PM0922','PM0783','PM0913','PM0823','PM0969','PM0685','PM0567','PM0568','PM0569','PM0746','PM0723','PM0737','PM0921','PM0320','PM0389','PM0392','PM0393','PM0427','PM0516','PM0524','PM0606','PM0671','PM0675','PM0785','PM0786','PM0391','PM0614','PM0705','PM0796','PM0817','PM0818','PM0819','PM0820','PM0821','PM0880','PM0894','PM0645','PM0663','PM0693','PM0055','PM0812','PM0052','PM0057','PM0091','PM0095','PM0268','PM0333','PM0893','PM0113','PM0219','PM0518','PM0648','PM0728','PM0833','PM0852','PM0917','PM0962','PM0297','PM0315','PM0322','PM0731','PM0767','PM0856','PM0882','PM0923','PM1008','PM0350','PM0380','PM0762','PM0765','PM0941','PM0465','PM1004','PM1011','PM0470','PM0487','PM0513','PM0525','PM0553','PM0581','PM0610','PM0649','PM0726','PM0763','PM0802','PM0853','PM0854','PM0904','PM0965','PM0988','PM0999','PM0486','PM0758','PM0855','PM0877','PM0931','PM0935','PM0952','PM0993','PM0195','PM0196','PM0211','PM0247','PM0269','PM0271','PM0314','PM0323','PM0354','PM0357','PM0260','PM0270','PM0317','PM0325','PM0358','PM0373','PM0235','PM0381','PM0539','PM0540','PM0542','PM0623','PM0624','PM0729','PM0881','PM0356','PM0653','PM0654','PM0800','PM0447','PM0638','PM0451','PM0543','PM0550','PM0575','PM0548','PM0579','PM0580','PM0578','PM0828','PM0406','PM0068','PM0161','PM0197','PM0198','PM0199','PM0240','PM0279','PM0342','PM0351','PM0353','PM0363','PM0474','PM0658','PM0774','PM0910','PM0131','PM0142','PM0207','PM0226','PM0227','PM0228','PM0229','PM0283','PM0285','PM0290','PM0298','PM0299','PM0306','PM0307','PM0385','PM0646','PM0698','PM0699','PM0703','PM0972','PM0973','PM0362','PM0732','PM0626','PM0791','PM0670','PM0776','PM0735','PM0788','PM0744','PM0971','PM0761','PM0915','PM0060','PM0497','PM0278','PM0838','PM0715','PM0787','PM0809','PM0824','PM0829','PM0832','PM0916','PM0930','PM0826','PM0617','PM0804','PM0805','PM0970','PM0661','PM0673','PM0681','PM0682','PM0803','PM0087','PM0831','PM0689','PM0691','PM0918','PM0702','PM0713','PM0808','PM0871','PM0080','PM0141','PM0149','PM0537','PM0545','PM0144','PM0529','PM0630','PM0631','PM0632','PM0633','PM0634','PM0815','PM0842','PM0846','PM0865','PM0889','PM0248','PM0417','PM0221','PM0236','PM0415','PM0582','PM0584','PM0801','PM0419','PM0678','PM0679','PM0376','PM0748','PM0844','PM0425','PM0459','PM0530','PM0576','PM0851','PM0751','PM0759','PM0021','PM0024','PM0035','PM0256','PM0372','PM0590','PM0026','PM0179','PM0241','PM0261','PM0266','PM0273','PM0295','PM0033','PM0264','PM0265','PM0044','PM0075','PM0120','PM0125','PM0132','PM0242','PM0084','PM0098','PM0170','PM0138','PM0218','PM0243','PM0272','PM0347','PM0365','PM0160','PM0627','PM0797','PM0201','PM0289','PM0072','PM0073','PM0074','PM0102','PM0133','PM0146','PM0223','PM0437','PM0551','PM0945','PM1007','PM0014','PM0037','PM0049','PM0056','PM0023','PM0321','PM0326','PM0371','PM0409','PM0426','PM0483','PM0498','PM0509','PM0586','PM0657','PM0717','PM0727','PM0850','PM0898','PM0907','PM0040','PM0316','PM0462','PM0479','PM0484','PM0505','PM0506','PM0531','PM0599','PM0656','PM0070','PM0103','PM0107','PM0110','PM0111','PM0117','PM0140','PM0145','PM0154','PM0192','PM0457','PM0574','PM0655','PM0123','PM0443','PM0641','PM0849','PM0869','PM0906','PM0135','PM0189','PM0695','PM0948','PM0312','PM0535','PM0589','PM0602','PM0694','PM0733','PM0773','PM0946','PM0338','PM0442','PM0555','PM0583','PM0621','PM0368','PM0440','PM0491','PM0619','PM0895','PM0990','PM0991','PM0460','PM0468','PM0480','PM0481','PM0511','PM0512','PM0757','PM0848','PM0858','PM0608','PM0912','PM0640','PM0642','PM0672','PM0676','PM0686','PM0887','PM0933','PM0934','PM0947','PM0964','PM0779','PM0859','PM0984','PM0987','PM0940','PM0953','PM0944','PM1003','PM0885','PM0564','PM0255','PM0834','PM0835','PM0879','PM0929','PM0942','PM0697','PM0830','PM0116','PM0119','PM0184','PM0216','PM0510','PM0769','PM0186','PM0360','PM0560','PM0711','PM0129','PM0288','PM0181','PM0245','PM0262','PM0011','PM0155','PM0222','PM0257','PM0558','PM0077','PM0152','PM0282','PM0402','PM0403','PM0536','PM0643','PM0700','PM0902','PM0903','PM0974','PM0082','PM0104','PM0252','PM0258','PM0263','PM0401','PM0712','PM0980','PM0995','PM0106','PM0169','PM0400','PM0954','PM0109','PM0136','PM0139','PM0187','PM0214','PM0585','PM0718','PM0770','PM0775','PM0926','PM0158','PM0225','PM0905','PM0174','PM0206','PM0301','PM0303','PM0313','PM0346','PM0554','PM0747','PM0836','PM0862','PM0897','PM0176','PM0215','PM0753','PM0899','PM0183','PM0217','PM0230','PM0284','PM0291','PM0300','PM0302','PM0305','PM0334','PM0339','PM0725','PM0857','PM0453','PM0811','PM0816','PM0861','PM0490','PM0839','PM0515','PM0950','PM0494','PM0613','PM0704','PM0977','PM0008','PM0012','PM0015','PM0016','PM0018','PM0399','PM0989','PM0423','PM0433','PM0434','PM0438','PM0444','PM0541','PM0552','PM0557','PM0659','PM0741','PM0777','PM0436','PM0755','PM0756','PM0789','PM0872','PM0890','PM0986','PM1002','PM0501','PM0742','PM0745','PM0503','PM0504','PM0720','PM0721','PM0736','PM0738','PM0739','PM0740','PM0845','PM0090','PM0092','PM0096','PM0097','PM0190','PM0304','PM0601','PM0873','PM0408','PM0456','PM0473','PM0600','PM0605','PM0534','PM0604','PM0065','PM0249','PM0267','PM0281','PM0324','PM0461','PM0981','PM0203','PM0210','PM0441','PM0647','PM0730','PM0794','PM0874','PM0960','PM0101','PM0124','PM0156','PM0167','PM0168','PM0171','PM0172','PM0191','PM0666','PM0749','PM0837','PM0209','PM0332','PM0341','PM0352','PM0366','PM0377','PM0378','PM0386','PM0559','PM0609','PM0238','PM0331','PM0335','PM0336','PM0340','PM0343','PM0348','PM0387','PM0388','PM0620','PM0251','PM0280','PM0294','PM0308','PM0309','PM0310','PM0463','PM0793','PM0806','PM0293','PM0330','PM0908','PM0963','PM0472','PM0507','PM0523','PM0719','PM0957','PM0961','PM1000','PM0764','PM1006','PM0985','PM1005','PM0752','PM0814','PM0982','PM0924','PM0951','PM0968','PM0966','PM0927','PM0979','PM0994','PM0996','PM0938') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice and a.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 and MATCH (a.modello,a.des_lung,a.codice) AGAINST ('continental sportcontact 225 50 r17 94w cerchione striscia ao' IN BOOLEAN MODE)

2012-11-13 9:30:02 - Lost connection to MySQL server during query
www.XXXXXX.com/c-pneumatici-auto-1/rc-avon-zz3-245-40-r17-91y-bordino-gomma-protezione-cerchio-fianco-pnuovo-matico-sava.html?par_page=440&par_ordina=0&par_ricerca=Y&par_ricerca1=E
select a.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTable dsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTable dsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index (i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice and a.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 and MATCH (a.modello,a.des_lung,a.codice) AGAINST ('avon zz3 245 40 r17 91y bordino gomma protezione cerchio fianco pnuovo matico sava' IN BOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 6585,15

2012-11-13 9:30:02 - MySQL server has gone away
www.XXXXXX.com/c-pneumatici-auto-1/rc-bf-goodrich-grip-205-65-r15-94v.html?par_page=67&par_ordina=0&par_ricerca=Y
select trim(cod_rag_prop), trim(tipo_artic), trim(cod_prop), trim(des_prop), trim(def_val) from ana_prop where tipo_artic = '1' order by tipo_artic, cod_rag_prop, cod_prop, def_val

2012-11-13 9:32:01 - Lost connection to MySQL server during query
www.XXXXXX.it/c-pneumatici-auto-1/rc-cp-cp2-cp505-cp507-cp519-cp-cp2-205-60-r18-r18-r30-r18-re-rw-12v-2v-regala-regali-regalo-atlas-clear-dunlop-dot2009-viking-dot-2009-pneumant-gt-radial-dot-2004.html
select a.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTable dsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTable dsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index (i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice and a.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 and MATCH (a.modello,a.des_lung,a.codice) AGAINST ('cp cp2 cp505 cp507 cp519 205 60 r18 r30 re rw 12v 2v regala regali regalo atlas clear dunlop dot2009 viking dot 2009 pneumant gt radial 2004' IN BOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

2012-11-13 9:37:01 - Lost connection to MySQL server during query
www.XXXXXX.com/item/pneumatici-auto-LNK-1.html?par_adv=&par_ricerca=Y&par_modello=245+40+r18+vredestein
select a.codice,a.marca,a.modello,a.prop_art,a.des_lung,a.qta_ven_de1,a.prz_ven_de1,a.qta_ven_de2,a.prz_ven_de2,a.iva_ven_det,a.costi_imb,a.costi_cor,a.perc_com_ban,a.perc_ric,a.impor_ric,a.scon_online,a.qta_disp,a.img_prod,a.fl_homepg,a.fornit,a.prz_acq,b.dsrTable dsrTable1,a.link_ann,a.email_co,a.nome_con,a.tel_cont,a.sito_web,a.cod_naz,a.cod_reg,a.cod_pro,a.cod_cit,a.tipo_mezzo,c.dsrTable dsrTable2 from disponib a, marca b force index (PRIMARY,i_tipmez_1), pk_catego c force index (i_codice_1) where 1=1 and a.marca = b.codice and a.tipo_mezzo = b.tipo_mezzo and a.tipo_mezzo in('1') and a.tipo_mezzo = c.codice and b.tipo_mezzo = c.codice and a.flatt_am = 'Y' and a.fornit!=1 and a.fornit!=2 and a.fornit!=8 and MATCH (a.modello,a.des_lung,a.codice) AGAINST ('245 40 r18 vredestein' IN BOOLEAN MODE) order by a.prz_ven_de1,a.modello,b.dsrTable LIMIT 0,15

Il problema è che queste query crashate non me le ritrovo in alcun file di log di mysql! Inoltre il sito lo vedo girare sempre regolarmente, non so quindi se in quesi casi il sito crasha a video.

Per ovviare al problema al seguente link http://dev.mysql.com/doc/refman/5.1/en/error-lost-connection.html leggevo di aggiungere la seguente riga “mysqld: 127.0.0.1” al file “/etc/hosts.allow” e la seguente riga “skip-name-resolve” al file “my.cnf.”. Quest'ultimo settaggio mi ha permesso di non perdere ripetutamente la connessione al db dal mio client remoto. Mentre per i suddetti errori loggati non ho ancora trovato alcuna soluzione.

Come faccio a capire cos'è che va sistemato?

Attendo consigli.

Grazie.

Options: ReplyQuote


Subject
Views
Written By
Posted
Soluzione a 'Lost connection to mysql server during query'
3683
November 13, 2012 04:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.