Barka da rana, masoyi mazauna Khabrovsk! Bari in gabatar da kaina, Alexander. Mai kula da tsarin na ɗayan ƙaramin ɗakin studio na WEB mai alfahari. Muna son komai ya yi aiki da sauri, cikin aminci kuma tare da sabuwar software. Don yin wannan, mun ma shigar da nagios+PhantomJS dam akan kwamfutar intra-ofis kuma mu duba saurin loda shafin kowane minti 30. Dangane da sharuɗɗan sabis, muna kuma saka idanu akan sabuntawar 1C-Bitrix kuma muna shigar dasu akai-akai. Sannan wata rana, bayan sabuntawa na gaba, muna ganin saƙo a cikin kwamitin gudanarwa cewa tun lokacin bazara na 2019, 1C-Bitrix ya daina aiki tare da MySQL 5.5 kuma muna buƙatar sabuntawa. Mutanen daga ISPSystem suna da kyau kuma suna faɗaɗa ayyukan kwamitin akai-akai, wanda godiya ta musamman gare su. Amma wannan lokacin bai yiwu a danna komai da linzamin kwamfuta ba. Amma za ku iya gano abin da ya faru da kuma yawan gashin gashi a yanzu a cikin gemu na a karkashin yanke.
Akwai kawai zaɓi don shigar da "madadin uwar garken DBMS" wanda aka shigar a cikin akwati na Docker. Tabbas, na fahimci cewa Docker yana da matukar fa'ida tare da albarkatu, amma komai girman aikinsa, babban abin zai kasance> 0. Kuma a nan muna da alama muna fada a cikin goma na dakika da inganta duk shafuka a ƙofar kafin buga su kuma sanya hannu kan yarjejeniya. Don haka ba zabina ba.
Ok, menene takardar ta ce? Ajiye komai, ƙara fayil zuwa yum.repos.d tare da hanyar haɗi zuwa ma'ajiyar MariaDB, sannan
rpm -e --nodeps MariaDB-server MariaDB-client MariaDB-commonDaga baya Yum zai rantse cewa wani ya share fakitin ba tare da saninsa ba. Amma da farko, bari ya rantse, ba shi da kyau. Na biyu kuma, idan kun yi gogewa ta yum, to yana ƙoƙarin cirewa, tare da MariaDB, duk abin da ke da alaƙa da shi ta hanyar dogaro, kuma wannan ya haɗa da PHP da ISPmanager da PHPmyadmin. Don haka, za mu yi magana game da rantsuwa daga baya.
yum clean all
yum update
yum install MariaDB-server MariaDB-client MariaDB-commonGabaɗaya, an shigar da komai kuma an fara. Abu mai kyau shine cewa an tattara bayanan bayanai kuma babu buƙatar mayar da su daga juji. Na duba shafukan - suna aiki kuma suna da sauri. Na shiga wasu wuraren admin guda biyu don tabbatar da cewa babu abin da ya fado na rubuta wa daraktan cewa komai yayi daidai. Kasa da mintuna 30 sai ya zama babu lafiya ko kadan...
Lokacin da na yi ƙoƙarin shiga yankin admin kuma in ƙara da gyara wani abu a cikin abubuwan, saƙo ya tashi
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']Tun da abubuwan da ke cikin rukunin yanar gizon sun kara da namu ma'aikatan, abokan ciniki ba su san komai ba tukuna kuma ba su fara yayyaga mu ba. Amma wani al'amari ne na lokaci, saboda bayanan da ke cikin rukunin yanar gizon suna buƙatar sabuntawa, kuma yawancin abokan ciniki suna sa ido kan wannan da kansu.
Daga rubutun kuskuren, zamu iya yanke shawarar cewa Bitrix yana ƙoƙarin ƙara sabon shigarwa a cikin bayanan yayin da yake ƙayyade maɓalli na farko da ke cikin labarin da ake gyarawa. Wannan yana nufin akwai dalili don zargin cewa matsalar ta taso a gefen Bitrix. Muna zuwa gidan yanar gizon su kuma mu tuntuɓi tallafi. Kusan nan da nan mun sami amsar "matsala mai rikitarwa. Ya ba manyan injiniyoyi - jira..."
Dole ne mu jira dogon lokaci (duk tattaunawar ta gudana daga Yuni 25.06.2019, 9.07.2019 zuwa Yuli 10.4.6, XNUMX) kuma sakamakon shine saƙon "wannan matsalar ba ta da alaƙa da aikin Bitrix CMS, amma yana da alaƙa da aiki na bayanan kanta a cikin mariadb XNUMX kuma, da rashin alheri, tare da A gefen rukunin yanar gizon, babu wata hanyar magance wannan matsalar; kuna buƙatar canzawa zuwa tsohuwar sigar MariaDB.
Sun iso... Na yi tunanin rage darajar a farkon labarin, amma cewa ba za a iya rage darajar ba. Juji juji kuma sake turawa akan sabar da aka shigar gabaki ɗaya. Wadancan. Yana da kyau ban sabunta duk sabar lokaci guda ba. Wadancan. "kawai" shafuka dari (dariya mai ban tsoro :-)). Taimakon ya kuma ce: "Don magance matsalar yayin amfani da bayanan MariaDB 10.4.6, kuna buƙatar tuntuɓar tallafin fasaha na MariaDB cewa ma'amalar ba za ta share rikodin daga bayanan ba idan an yi buƙatar:
$DB->Query("DELETE FROM ".$strTable." WHERE ID = ".$res["ID"]);
$results = $DB->Query("SELECT * FROM ".$strTable." WHERE ID = ".$res["ID"]);”
Fata ya haskaka tsawon sa'o'i biyu daga lokacin da na fara sadarwa tare da tallafin MariaDB, amma sai na sami wasiƙar da suka gaya mani daidai cewa ni ba mai amfani da kasuwanci ba ne don haka babu wanda zai magance matsalata da gangan, amma akwai dandalin tattaunawa akan gidan yanar gizon su kuma a can zaku iya ƙoƙarin neman zaɓuɓɓuka ... Ba zan ba ku cikakken bayani ba. Babu zaɓuɓɓuka a wurin.
GAME! Mun sayi lasisin ISP!
- Sannu, tallafi? Jama'a, ku taimaka!
- Yi haƙuri, ba mu goyan bayan ƴan damfara waɗanda ke canza nau'ikan DBMS na asali. Idan kuna so, akwai zaɓi tare da madadin uwar garken a Docker.
- Amma ta yaya masu amfani da bayanan bayanai zasu isa can? Don docker?
- To, ka ja su can da hannunka...
- Da! Kuma kar ku manta cewa tashar jiragen ruwa don mysql za ta canza kuma kuna buƙatar shiga cikin duk saitunan kuma sake rubuta su.
- Ok, na gode, zan yi tunani game da shi ...
Na yi tunani game da shi kuma na yanke shawarar rushe 10.4 da hannu kuma in shigar da 10.2 wanda babu matsaloli akan wasu sabobin.
Tsarin bai bambanta da tsarin sabuntawa ba. Dole ne in canza 10.4 zuwa 10.2 a cikin hanyar haɗin yanar gizo zuwa ma'ajiyar, sake saitawa da sake ƙirƙirar cache don yum. Da kyau, ƙarin “kananan abu”: bayan cire 10.4, je zuwa /var/lib/mysql kuma share komai daga can. Ba tare da wannan mataki ba bayan shigar 10.2, sabis ɗin zai ci gaba da faɗuwa kuma zaku gani
Не удалось подключиться к базе данных '' Lost connection to MySQL server at 'reading initial communication packet', system error: 104 "Connection reset by peer"Ko
Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104Kafin shigo da bayanan bayanan, na fara saita tushen kalmar sirri don mysql wanda aka ƙayyade a cikin saitunan ISP kuma na shigo da juji na bayanan mysql. To, to, tunda muna da masu amfani da haƙƙoƙin, muna shigo da duk bayanan mai amfani a jere ta hanyar amfani da tushen asusun.
Rubutun rubutun don zubar da bayanai:
#!/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'Kafin shigo da bayanan bayanai, kuna buƙatar buɗe su. Don haka muna gudanar da umarni kawai
gunzip /BACK/*.gzKuma a ƙarshe: saboda wasu dalilai, ana ba da izinin saƙa a cikin sunan bayanan (idan kun ƙirƙira ta ta ISPmanager). Amma lokacin da ka ƙirƙira ko ƙoƙarin loda juji zuwa ma'ajin bayanai wanda ke da saƙo a cikin sunansa, za ka karɓi saƙon cewa kalmar ma'anar ba daidai ba ce.
Fatan alkhairi ga masu karantawa har zuwa karshe. Ina neman afuwar mafi kusantar waƙafi ba daidai ba - suna da matsala. Idan kuna da wasu shawarwari game da ainihin abin da aka kwatanta, rubuta a cikin saƙo na sirri saboda ina jin tsoron in rasa wani abu a cikin sharhi. Kuma kada ku yi rantsuwa da yawa - wannan shine labarina na farko :)
UPD1:
Na kusan manta da ambaton: yayin da nake ƙoƙarin neman mafita ga matsalar ba tare da rage darajar MariaDB ba, dole in sabunta bayanin ko ta yaya. An sabunta shi kamar haka: ana jujjuya dukkan bayanan daga InnoDB zuwa MyISAM, an sabunta bayanan sannan a koma InooDB.
UPD2:
Na karɓi wasiƙa daga 1C-Bitrix tare da abun ciki mai zuwa:
An kammala buƙatar bita
"Bayan haɓaka mariadb zuwa 10.4.6, kuskure ya faru lokacin adana abubuwan infoblock"
Module: iblock, sigar: ba a sani ba
Magani: ƙi
Don haka da alama ba zai yuwu a sabunta zuwa 10.4 a yanzu 🙁
source: www.habr.com