April 2024 - discuss - lists.mariadb.org

Why is configuring init-file causing the error COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary'
by i18n.site 07 Apr '24

07 Apr '24

Why is configuring init-file causing the error COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary' I use default character-set-server=binary ❯ rg binary conf.d/mariadb.cnf 7:character-set-server=binary 8:collation-server=binary ❯ /usr/local/mysql/bin/mariadbd --init-file=/etc/mysql/init.sql --defaults-file=/etc/mysql/mariadb.cnf 2024-04-07 12:07:40 0 [ERROR] COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary' 2024-04-07 12:07:40 0 [ERROR] Aborting ❯ cat /etc/mysql/init.sql STOP SLAVE;CHANGE MASTER TO master_use_gtid=slave_pos, MASTER_USER='sync',MASTER_HOST='xx',MASTER_PORT=2002,MASTER_PASSWORD='xx',MASTER_CONNECT_RETRY=1; START SLAVE; /etc/mysql

1 0

LOCK TABLES FOR WRITE with mysqldump imports
by stephan.vos＠metacom.net 05 Apr '24

05 Apr '24

I noticed that my data archiving process has been adding LOCK TABLES (table) FOR WRITE to the mysqldump file. I am now worried that if I ever need to import this data into the 3 node Galera cluster it will cause deadlocking as described in the MariaDB known issues article. Does MariaDB with Galera still lock up when this statement is executed or would it just ignore the LOCK TABLES command?

1 0

Help - Creating a loop to go through every row in a table, no errors, not working
by ram3n 02 Apr '24

02 Apr '24

Hi all, I've ran into a little roadblock while creating a WHILE loop within a procedure that's intended to go through every row within a table, *world.creature_template*. Query runs fine in my database, no warnings or errors, but it's not actually changing anything at all. Affected rows are always at 0. Link to the code is below, thanks in advance. https://srcb.in/YVuGJQU4o8 Some sample records: entrydifficulty_entry_1difficulty_entry_2difficulty_entry_3KillCredit1 KillCredit2modelid1modelid2modelid3modelid4namesubnameIconNamegossip_menu_id minlevelmaxlevelexpfactionnpcflagspeed_walkspeed_runscalerankdmgschool BaseAttackTimeRangeAttackTimeBaseVarianceRangeVarianceunit_classunit_flags unit_flags2dynamicflagsfamilytypetype_flagslootidpickpocketlootskinloot PetSpellDataIdVehicleIdmingoldmaxgoldAINameMovementTypeHoverHeight HealthModifierManaModifierArmorModifierDamageModifierExperienceModifier RacialLeadermovementIdRegenHealthmechanic_immune_mask spell_school_immune_maskflags_extraScriptNameVerifiedBuild 29 0 0 0 25499 0 25275 0 0 0 Kanrethad Master of Death 0 90 90 0 35 0 1 1.14286 1 0 0 2000 2000 1 1 1 0 2048 0 0 7 0 0 0 0 0 0 0 0 0 1 1250 1 1 1 1 0 0 1 0 0 0 12340 30 0 0 0 0 0 382 0 0 0 Forest Spider 0 5 6 0 22 0 1 0.85714 1 0 0 2000 2000 1 1 1 0 2048 0 3 1 1 30 0 0 5880 0 0 0 SmartAI 1 1 1 1 1 1 1 0 100 1 0 0 0 12340 31 0 0 0 0 0 145 0 0 0 Furbolg 0 1 2 0 35 0 1.2 1.14286 1 0 0 2000 2000 1 1 1 0 2048 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 0 1 0 0 0 12340 36 0 0 0 0 0 367 0 0 0 Harvest Golem 0 11 12 0 14 0 1 1.14286 1 0 0 2000 2000 1 1 1 0 2048 0 0 9 32768 36 0 0 0 0 13 21 1 1 1 1 1 1 1 0 0 1 16384 0 0 12340 38 0 0 0 0 0 5035 5036 0 0 Defias Thug 0 3 4 0 7 0 1 0.85714 1 0 0 2000 2000 1 1 1 0 2048 0 0 7 0 38 38 0 0 0 2 7 SmartAI 1 1 1 1 1 1 1 0 100 1 0 0 0 12340 40 0 0 0 0 0 373 0 0 0 Kobold Miner 0 6 7 0 26 0 1 0.85714 1 0 0 2000 2000 1 1 1 0 2048 0 0 7 0 40 40 0 0 0 5 12 SmartAI 1 1 1 1 1 1 1 0 100 1 0 0 0 12340 *generated 2024-03-31 22:08:23 by HeidiSQL 12.1.0.6537 <https://www.heidisql.com/>*

1 0