芪æãªããããã人ã®çãããããã«ã¡ã¯ïŒ èªå·±çŽ¹ä»ããããŠãã ãããã¢ã¬ã¯ãµã³ããŒã å°ãããªãããèªãé«ãWEBã¹ã¿ãžãªã®ã·ã¹ãã 管çè
ã ç§ãã¡ã¯ããã¹ãŠãè¿
éãå®å
šã«ããããŠææ°ã®ãœãããŠã§ã¢ã§åäœããããšãæ¬åœã«æãã§ããŸãã ãããè¡ãããã«ããªãã£ã¹å
ã®ã³ã³ãã¥ãŒã¿ãŒäžã§ nagios + PhantomJS ãã³ãã«ãèµ·åãã30 åããšã«ããŒãžã®èªã¿èŸŒã¿é床ããã§ãã¯ããŸããã å©çšèŠçŽã«åŸã£ãŠã1C-Bitrix ã®ã¢ããããŒããç£èŠããå®æçã«ã€ã³ã¹ããŒã«ããŸãã ãããŠããæ¥ã次ã®ã¢ããããŒãã®åŸã管çããã«ã«ã2019 幎ã®å€ä»¥éã1C-Bitrix 㯠MySQL 5.5 ã§ã®åäœãåæ¢ãããããã¢ããããŒãããå¿
èŠããããšããã¡ãã»ãŒãžã衚瀺ãããŸãã ISPSystem ã®ã¹ã¿ããã¯ãã³ãµã ã§ãå®æçã«ããã«ã®æ©èœãæ¡åŒµããŠããŸãã圌ãã«ã¯ç¹ã«æè¬ããŠããŸãã ããããä»åã¯ããŠã¹ã§ãã¹ãŠãã¯ãªãã¯ããããšã¯ã§ããŸããã§ããã ããããäœãèµ·ãã£ãã®ãããããŠä»ç§ã®ã²ãã«äœæ¬ã®çœé«ªãããã®ãââã¯ãã«ããã®äžã«èŠã€ããããšãã§ããŸãã
Dockerã³ã³ããã«ã€ã³ã¹ããŒã«ãããã代æ¿DBMSãµãŒããŒããã€ã³ã¹ããŒã«ãããªãã·ã§ã³ãããããŸããã§ããã ãã¡ãããDocker ããªãœãŒã¹ãéåžžã«ç¯çŽããŠããããšã¯ç解ããŠããŸããããããã©ãã»ã©åªããåäœãããŠãããªãŒããŒããã㯠> 0 ã§ãã ãããŠããã§ç§ãã¡ã¯ãããã°ã³ã³ãæ°ç§ã§æŠããå
¬éããŠå¥çŽãçµã¶åã«å
¥ãå£ã§ãã¹ãŠã®ãµã€ããæé©åããŠããŸãã ã ããç§ã®éžæã§ã¯ãããŸããã
ããŠãããã¥ã¡ã³ãã«ã¯äœãæžããŠããã§ããããïŒ ãã¹ãŠãããã¯ã¢ããããMariaDB ãªããžããªãžã®ãªã³ã¯ãå«ããã¡ã€ã«ã yum.repos.d ã«è¿œå ããŠã
rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-common
ã€ã ã¯ãã®åŸã誰ããç¥ããªããã¡ã«ããã±ãŒãžãåé€ãããšããäºå®ã眵ãããšã«ãªããŸãã ããããŸãæåã«ã圌ã«èªã£ãŠããããŸãããã倧äžå€«ã§ãã 次ã«ãyum ãä»ããŠåé€ãè¡ããšãMariaDB ãšãšãã«ãäŸåé¢ä¿ã«ãã£ãŠé¢é£ä»ããããŠãããã¹ãŠã®ãã® (PHPãISPManagerãããã³ PHPmyadmin) ãç Žå£ããããšããŸãã ãããã£ãŠããã°ã«ã€ããŠã¯åŸã§å¯ŸåŠããŸãã
yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-common
äžè¬çã«ããã¹ãŠãã»ããã¢ãããããéå§ãããŸããã è¯ãç¹ã¯ãåºå°ãæŸããããã³ããã埩å ããå¿ èŠããªãããšã§ãã ãµã€ãããã§ãã¯ããŸããããããã«åäœããŸãã ç§ã¯ããã€ãã®ç®¡çããã«ã«è¡ããäœãèœã¡ãŠããªãããšã確èªãããã¹ãŠãæ£åžžã§ããããšããã£ã¬ã¯ã¿ãŒã«ç»é²è§£é€ããŸããã 30åãçµããªããã¡ã«ããŸã£ããåé¡ãªãããšãå€æããŸãã...
管çããã«ã«ç§»åããŠã³ã³ãã³ãã«ç·šéãè¿œå ããããšãããšãã¡ãã»ãŒãžã衚瀺ãããŸããã§ãã
MySQL Query Error: INSERT INTO b_iblock_element_property (ID, IBLOCK_ELEMENT_ID, IBLOCK_PROPERTY_ID, VAL UE, VALUE_NUM) SELECT 10555 ,2201 ,P.ID ,'3607' ,3607.0000 FR OM b_iblock_property P WHERE ID = 184 [[1062] Duplicate entry '10555' for key 'PRIMARY']
ãµã€ãã®ã³ã³ãã³ãã¯åœç€Ÿã®åŸæ¥å¡ã«ãã£ãŠè¿œå ããããã®ã§ãããããã¯ã©ã€ã¢ã³ãã¯ãŸã äœãç¥ãããç§ãã¡ãåŒãè£ãå§ããŠããŸããã§ããã ãããããµã€ãäžã®æ å ±ãæŽæ°ããå¿ èŠããããå€ãã®ã¯ã©ã€ã¢ã³ããããã泚ææ·±ãç£èŠããŠãããããããã¯æéã®åé¡ã§ããã
ãšã©ãŒã®æé¢ãããBitrix ã¯ç·šéäžã®èšäºãšåãäž»ããŒãæå®ããªãããããŒã¿ããŒã¹ã«æ°ããã¬ã³ãŒããè¿œå ããããšããŠãããšçµè«ä»ããããšãã§ããŸãã ãããã£ãŠãåé¡ã Bitrix åŽã§çºçããŠãããšçãçç±ããããŸãã Web ãµã€ãã«ã¢ã¯ã»ã¹ãããµããŒãã«ãåãåãããã ããã ã»ãšãã©ããã«ããé£ããåé¡ã§ããããšããçããåŸãããŸãã äžçŽãšã³ãžãã¢ã«äžããããŸãã - åŸ ã£ãŠãã ãã...ã
ããªãé·ãæéåŸ ããªããã°ãªããŸããã§ãã (å¯Ÿè©±å šäœã¯ 25.06.2019 幎 9.07.2019 æ 10.4.6 æ¥ãã XNUMX 幎 XNUMX æ XNUMX æ¥ãŸã§è¡ãããŸãã)ããã®çµæãããã®åé¡ã¯ Bitrix CMS ã®åäœãšã¯é¢ä¿ãããŸããããé¢é£ããŠããããšããã¡ãã»ãŒãžã衚瀺ãããŸããã mariadb XNUMX ã§ã¯ããŒã¿ããŒã¹èªäœã®åäœã«åé¡ããããæ®å¿µãªãããã®åé¡ã解決ãããµã€ããæ¬ èœããŠãããããå€ãããŒãžã§ã³ã® MariaDB ã«ç§»è¡ããå¿ èŠããããŸããã
åºèªâŠç©èªåé ã§ã¯ããŠã³ã°ã¬ãŒããèããŸãããã
$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);â
MariaDB ãµããŒããšã®ããåããéå§ããç¬éããæ°æéã¯åžæãèŠããŸãããããã®åŸãç§ãåçšãŠãŒã¶ãŒã§ã¯ãªããããæå³çã«ç§ã®åé¡ã解決ããŠããã人ã¯èª°ãããªããšéåžžã«æ£ç¢ºã«éç¥ãããæçŽãåãåããŸããã Web ãµã€ãã®ãã©ãŒã©ã ã«ã¢ã¯ã»ã¹ããŠãããã§ãªãã·ã§ã³ãæ¢ããŠã¿ãŠãã ããã詳现ã«ã€ããŠã¯èª¬æããŸããã ããã«ã¯éžæè¢ã¯ãããŸããã
ã ãããïŒ ISPã®ã©ã€ã»ã³ã¹ã賌å
¥ããŸããïŒ
ããã«ã¡ã¯ããµããŒãã§ããïŒ ã¿ããªãå©ããŠïŒ
- ç³ãèš³ãããŸããããDBMS ã®ãã€ãã£ã ããŒãžã§ã³ãå€æŽããå¶æªç¯ã¯ãµããŒãããŠããŸããã å¿
èŠã«å¿ããŠãdocker ã«ä»£æ¿ãµãŒããŒã䜿çšãããªãã·ã§ã³ããããŸãã
- ãããããŠãŒã¶ãŒãšããŒã¿ããŒã¹ã¯ã©ã®ããã«ããŠããã«å°éããã®ã§ãããã? 枯湟åŽåè
ã«?
- ããŠãããªãã¯æã§ããã«ãã©ãã°ããŸã...
- ã¯ãïŒ ãŸããmysql ã®ããŒããå€æŽãããããããã¹ãŠã®èšå®ã確èªããŠæžãçŽãå¿
èŠãããããšãå¿ããªãã§ãã ããã
ããããŸãããããããšããèããŠã¿ãŸã...
ãšèãããã³ãã«ä»ãã®10.4ãç Žå£ããåé¡ã®ãªãã£ã10.2ãä»ã®ãµãŒããŒã«ã€ã³ã¹ããŒã«ããããšã«ããŸããã
ãã®ããã»ã¹ã¯ã¢ããã°ã¬ãŒã ããã»ã¹ãšããŸãå€ãããŸããã§ããã ãªããžããªãžã®ãªã³ã¯ã§ 10.4 ã 10.2 ã«å€æŽããyum ã®ãã£ãã·ã¥ããªã»ããããŠåäœæããã ãã§æžã¿ãŸããã ããŠããã 10.4 ã€ã®ãäºçŽ°ãªãããšã§ãã10.2 ãåé€ããåŸã/var/lib/mysql ã«ç§»åãããããããã¹ãŠãåé€ããŸãã ãã®æé ãè¡ããªããšãXNUMX ãã€ã³ã¹ããŒã«ããåŸããµãŒãã¹ãåžžã«ã¯ã©ãã·ã¥ãã次ã®ãããªã¡ãã»ãŒãžã衚瀺ãããŸãã
Ðе ÑЎалПÑÑ Ð¿ÐŸÐŽÐºÐ»ÑÑОÑÑÑÑ Ðº базе ЎаММÑÑ
'' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"
ãŸãã¯
Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104
ããŒã¿ããŒã¹ãã€ã³ããŒãããåã«ããŸã ISP æ§æã§æå®ããã mysql root ãã¹ã¯ãŒããèšå®ããmysql ããŒã¿ããŒã¹ ãã³ããã€ã³ããŒãããŸããã ã§ã¯ããã§ã«ãŠãŒã¶ãŒãšæš©éãããã®ã§ãroot ã¢ã«ãŠã³ãã䜿çšããŠãã¹ãŠã®ãŠãŒã¶ãŒ ããŒã¿ããŒã¹ãé£ç¶ããŠã€ã³ããŒãããã ãã§ãã
ããŒã¿ããŒã¹ ãã³ãã®ã¹ã¯ãªãã ããã¹ã:
#!/bin/bash
echo 'show databases' | mysql -u root --password="ÐаРПÐÑ_РУТÐ" --skip-column-names | grep -v information_schema | xargs -I {} -t bash -c 'mysqldump -u root --password="ÐаРПÐÑ_РУТÐ" {} | gzip > /BACK/back-$(hostname)-{}-$(date +%Y-%m-%d-%H.%M.%S).sql.gz'
ããŒã¿ããŒã¹ãã€ã³ããŒãããåã«ãããŒã¿ããŒã¹ã解åããå¿ èŠããããŸãã ã³ãã³ããå®è¡ããã ãã§ã
gunzip /BACK/*.gz
ãããŠæåŸã«ãäœããã®çç±ã§ãããŒã¿ããŒã¹åã«ãã€ãã³ã䜿çšã§ããŸã (ISPmanager ã䜿çšããŠããŒã¿ããŒã¹ãäœæããå Žå)ã ãã ããååã«ãã€ãã³ãå«ãŸããããŒã¿ããŒã¹ã«ãã³ããäœæãŸãã¯ã¢ããããŒãããããšãããšãã¯ãšãªæ§æãæ£ãããªããšããã¡ãã»ãŒãžã衚瀺ãããŸãã
ãã¹ãŠã®ç¥çŠãæåŸãŸã§èªãã§ãã ããã ã«ã³ããå ¥ã£ãŠããªãå¯èœæ§ãé«ãããšããè©«ã³ããŸããåé¡ãçºçããŠããŸãã æ¬è³ªçã«èª¬æãããææ¡ã«å¯Ÿããåžæãããå Žåã¯ãã³ã¡ã³ãã«äœããèŠéããŠããŸãã®ãæãã®ã§ãå人çãªããšãæžããŠãã ããã ããŸãæªå£ãèšããªãã§ãã ãã - ããã¯ç§ã®æåã®èšäºã§ã ð
UPD1ïŒ
èšãå¿ãããšããã§ããããMariaDB ãããŠã³ã°ã¬ãŒãããã«åé¡ã®è§£æ±ºçãèŠã€ããããšããŠãããšãã«ãäœããã®æ¹æ³ã§æ
å ±ãæŽæ°ããå¿
èŠããããŸããã ãã®ããã«æŽæ°ãããŸãããããŒã¿ããŒã¹å
šäœã InnoDB ãã MyISAM ã«å€æãããinfa ãæŽæ°ãããŠãããInooDB ã«å€æãããŸãã
UPD2ïŒ
1C-Bitrix ãã次ã®å 容ã®æçŽãåãåããŸããã
ä¿®æ£ãªã¯ãšã¹ããå®äºããŸãã
ãmariadb ã 10.4.6 ã«æŽæ°ããåŸãæ å ±ãããã¯èŠçŽ ãä¿åãããšãã«ãšã©ãŒãçºçããŸããã
ã¢ãžã¥ãŒã«: iblockãããŒãžã§ã³: äžæ
解決ç: æåŠãããŸãã
ãããã£ãŠãä»ã®ãšããã10.4ã«ã¢ããããŒãããããšã¯äžå¯èœã®ããã§ã ð
åºæïŒ habr.com