Zuva rakanaka, vadiwa vaKhabrovites! Nditendere kuti ndizvizivise ini, Alexander. Sisitimu maneja yeimwe diki asi inodada WEB-studio. Isu tinoda chaizvo kuti zvese zvishande nekukurumidza, zvakachengeteka uye nesoftware nyowani. Kuti tiite izvi, isu takatosimudza nagios + PhantomJS bundle pane intra-office komputa uye yega yega 30 maminetsi tinotarisa peji yekurodha kumhanya. Zvinoenderana nematemu ebasa, isu zvakare tinotarisisa 1C-Bitrix inogadziridza uye nekuiisa nguva dzose. Uye zvino rimwe zuva, mushure mekuvandudzwa kunotevera, tinoona meseji mune admin panel inotaura kuti kubva muzhizha ra2019, 1C-Bitrix inomira kushanda neMySQL 5.5 uye inoda kuvandudzwa. Vakomana vanobva kuISPSystem vakanaka uye vanogara vachiwedzera kushanda kwepaneti, iyo yakakosha kuvonga kwavari. Asi panguva ino zvaisaita kudzvanya zvese negonzo. Asi chii chakaitika uye kuti vangani vhudzi jena ikozvino ndebvu dzangu dzinogona kuwanikwa pasi pekugerwa.
Paingova nesarudzo yekuisa "imwe nzira yeDBMS server" iyo yakaiswa muDocker mudziyo. Ehe, ini ndinonzwisisa kuti Docker haina hutsinye nezviwanikwa, asi zvisinei kuti inoshanda sei, iyo yepamusoro icharamba iri> 0. Uye isu tiri, sekunge, tichirwa mugumi zvemasekondi uye nekunatsiridza nzvimbo dzese pamusuwo tisati tashambadza uye kusaina chibvumirano. Saka kwete sarudzo yangu.
Zvakanaka, chii chiri mugwaro? Chengetedza zvese, wedzera faira rine chinongedzo kuMariaDB repository kune yum.repos.d, wozo
rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-commonYum anozopika nenyaya yekuti mumwe munhu akabvisa mapakeji iye asingazive. Asi chekutanga - regai apike, zvakanaka. Uye chechipiri, kana iwe ukaita kudzima kuburikidza neyum, zvino inoedza kuputsa, pamwe naMariaDB, zvese zvine hukama nazvo nekutsamira, uye iyi iPHP neISPManager uye PHPmyadmin. Saka tichazogadzirisa netsikidzi gare gare.
yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-commonKazhinji, zvinhu zvose zvakagadziriswa uye zvakatanga. Chinhu chakanaka ndechokuti mabhesi akatorwa uye zvakanga zvisingakoshi kuti adzorere kubva pamarara. Ndakatarisa masaiti - anoshanda uye nekukurumidza. Ndakaenda kune akati wandei admin mapaneru kuti ndione kuti hapana chakadonha uye ndisina kunyoreswa kuna director kuti zvese zvaive zvakanaka. Musingasviki maminetsi makumi matatu, zvakazoitika kuti zvaive zvisina kana zvachose ...
Pandakaedza kuenda kune admin panel uye kuwedzera gadzirisa chero chinhu chiri mukati, meseji yakadonha
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']Sezvo zviri pasaiti zvichiwedzerwa nevashandi vedu, vatengi vanga vasati vaziva chero chinhu uye vanga vasati vatanga kutibvarura. Asi yaive nyaya yenguva, nekuti ruzivo rwemasaiti rwunoda kuvandudzwa, uye vatengi vazhinji vanotevera izvi zvakanyanya.
Kubva pane zvinyorwa zvekukanganisa, tinogona kugumisa kuti Bitrix ari kuyedza kuwedzera rekodhi nyowani kune dhatabhesi, uku achitsanangura kiyi yekutanga iyo chinyorwa chiri kupepetwa chaive nacho. Saka pane chikonzero chekufungidzira kuti dambudziko rinoitika parutivi rweBitrix. Enda kune webhusaiti yavo uye ubate rutsigiro. Kunenge pakarepo tinowana mhinduro βdambudziko rakaoma. Zvipe kune mainjiniya makuru - mirira ... "
Ini ndaifanira kumirira nguva yakareba (nhaurirano yese yakaitika kubva 25.06.2019/9.07.2019/10.4.6 kusvika XNUMX/XNUMX/XNUMX) uye mhedzisiro yaive meseji "dambudziko iri harina hukama nekushanda kweBitrix CMS, asi rine hukama. pakushanda kwedhatabhesi pachayo mu mariadb XNUMX uye, zvinosuruvarisa, nedivi resaiti dambudziko iri rekugadzirisa mukana usipo, zvichave zvakakodzera kutamira kune yekare vhezheni yeMariaDB. "
Sailed ... Ndakafunga nezve downgrade pakutanga nyaya, asi kuti hapagoni kuva nekuderedza. Batanidza dumps uye redeploy pane ichangobva kuiswa server. Avo. zvakanaka kuti handina kugadzirisa maseva ese kamwechete. Avo. "chete" zana masaiti (nervous chuckle :-)). Vakataurawo vachitsigira: "Kugadzirisa dambudziko kana uchishandisa dhatabhesi reMariaDB 10.4.6, unozofanirwa kubata MariaDB technical support kuti kutengeserana hakuzodzima rekodhi kubva mudhatabhesi kana chikumbiro chaitwa:
$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);β
Tariro yakapenya kwemaawa akati wandei kubva patakatanga kutaurirana nerutsigiro rweMariaDB, asi ndakazogashira tsamba yandakanyatso kuudzwa kuti ini handisi mushandisi wekutengesa saka hapana aizogadzirisa dambudziko rangu nemaune, asi pane forum pawebhusaiti yavo uye unogona kuedza kutsvaga sarudzo ipapo ... ini handingakufiri neruzivo. Hapana zvingasarudzwa ipapo.
ABOUT! Takatenga rezinesi reISP!
Mhoro, rutsigiro? Varume, batsirai!
-Tine hurombo, isu hatitsigire matsotsi anochinja mavhezheni eiyo DBMS. Kana iwe uchida, pane sarudzo ine imwe sevha mu docker.
- Asi vashandisi uye dhatabhesi vachasvika sei ikoko? Kuti docker?
- Zvakanaka, iwe unovakwevera ipapo nemaoko ako ...
- Ehe! Uye usakanganwa kuti chiteshi che mysql chichachinja uye iwe uchafanirwa kupfuura nekunyorazve ese magadzirirwo.
Ok thanks, ndichafunga nezvazvo...
Ndakafunga ndikafunga kuputsa 10.4 nezvibato uye kuisa 10.2 iyo pakanga pasina matambudziko pane mamwe maseva.
Nzira yacho yakanga isina kunyanya kusiyana nekugadzirisa maitiro. Chete chaive chakakosha kushandura 10.4 kusvika 10.2 mune chinongedzo kune repository, reset uye zvakare kugadzira cache yeyum. Zvakanaka, imwezve "trifle": mushure mekubvisa 10.4, tinoenda ku /var/lib/mysql todzima zvese kubva ipapo. Pasina danho iri, mushure mekuisa 10.2, iyo sevhisi inogara ichiparara uye iwe uchaona
ΠΠ΅ ΡΠ΄Π°Π»ΠΎΡΡ ΠΏΠΎΠ΄ΠΊΠ»ΡΡΠΈΡΡΡΡ ΠΊ Π±Π°Π·Π΅ Π΄Π°Π½Π½ΡΡ
'' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"Kana
Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104Ndisati ndapinza dhatabhesi, ini ndakatanga kuseta mysql midzi password iyo yakatsanangurwa muISP configs uye kunze kwenyika iyo mysql database dump. Zvakanaka, saka, sezvo pachitova nevashandisi uye kodzero, isu tinongopinza ese emushandisi dhatabhesi mumutsara nemudzi account.
Rugwaro rwekuraswa kwedatabase:
#!/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'Usati wapinza dhatabhesi, unofanirwa kuvhura iwo. Saka ingomhanya murairo
gunzip /BACK/*.gzUye chinhu chekupedzisira: nokuda kwechimwe chikonzero, hyphens inobvumirwa mumazita epa database (kana iwe ukaasika uchishandisa ISPmanager). Asi kana uchigadzira kana kuyedza kurodha dump kune dhatabhesi ine hyphen muzita, unowana meseji yekuti iyo yemubvunzo syntax haina kururama.
Verenga kusvika kumagumo emaropafadzo ose. Ndinokumbira ruregerero nekuda kwezvingangoita zvisina kuparadzaniswa makoma - vari mudambudziko. Kana pane zvishuwo zvechikumbiro chakanyatsotsanangurwa - nyora mumunhu nekuti mune zvakataurwa ndinotya kupotsa chimwe chinhu. Uye usapika zvakanyanya - ichi ndicho chinyorwa changu chekutanga π
UPD1:
Ndakapotsa ndakanganwa kutaura: pandakanga ndichiedza kutsvaga mhinduro kudambudziko pasina kuderedza MariaDB, ndaifanira kuvandudza ruzivo. Yakagadziridzwa seizvi: dhatabhesi rese rinoshandurwa kubva kuInnoDB kuenda kuMyISAM, infa inovandudzwa uye yozoshandurwa kudzokera kuInooDB.
UPD2:
Ndichangobva kugamuchira tsamba kubva ku1C-Bitrix ine zvinotevera zvirimo:
Chikumbiro chekudzokorora chapera
"Mushure mekugadzirisa mariadb ku10.4.6, kukanganisa kwakaitika pakuchengetedza infoblock element"
Module: iblock, vhezheni: isingazivikanwe
Solution: yarambwa
Saka ikozvino, sezviri pachena hazvigoneke kugadzirisa kusvika ku10.4 π
Source: www.habr.com