Categories
CMS Magento Mastering Development

Index.php process causing CPU Max Usage

I recently had my website moved to a new server. After a day my CPU is maxed out. There are not any errors in my logs and my cache is running. When I check the processes I see that the same command has ran multiple times and is taking up all the resources. What would […]

Categories
CMS Magento Mastering Development

Magento 2 not spawning consumer processes i DB (RabbitMQ)

I have setup Magento 2.4 with RabbitMQ. You can see my configuration here. ‘queue’ => [ ‘amqp’ => [ ‘host’ => ‘rabbitmq.host’, ‘port’ => ‘53003’, ‘user’ => ‘username’, ‘password’ => ‘password’, ‘virtualhost’ => ‘/’ ], ‘consumers_wait_for_messages’ => 1 ], ‘cron_consumers_runner’ => [ ‘cron_run’ => true, ‘max_messages’ => 20000, ‘consumers’ => [ ‘async.operations.all’, ‘product_action_attribute.update’, ‘product_action_attribute.website.update’, ‘inventory.source.items.cleanup’, […]

Categories
CMS Magento Mastering Development

Magento 2 not spawning consumer processes i DB (RabbitMQ)

I have setup Magento 2.4 with RabbitMQ. You can see my configuration here. ‘queue’ => [ ‘amqp’ => [ ‘host’ => ‘rabbitmq.host’, ‘port’ => ‘53003’, ‘user’ => ‘username’, ‘password’ => ‘password’, ‘virtualhost’ => ‘/’ ], ‘consumers_wait_for_messages’ => 1 ], ‘cron_consumers_runner’ => [ ‘cron_run’ => true, ‘max_messages’ => 20000, ‘consumers’ => [ ‘async.operations.all’, ‘product_action_attribute.update’, ‘product_action_attribute.website.update’, ‘inventory.source.items.cleanup’, […]

Categories
Database Development

How to distribution count between rows SQL Server

Unequal division = distribution How to retrieve output with example : CREATE TABLE yourTable ( id varchar(55), code int, count1 int, count2 int ); INSERT INTO yourTable (id, code,count1,count2) VALUES (‘no-29’, 12345, 4, 1), (‘no-29’, 32346, 4, 1) always count1-count2 and results distribution between others rows with same id: example : 4-1 = 3 and […]

Categories
Ask Games Video Games

A minecraft command that gives you a villager spawn egg with custom trades 1.16

I want to make an overpowered kit that uses one command and I need the custom trade villager to be in a pre-filled chest and I’ve tried /give @p chest{BlockEnityTag:{Items:[{Slot:2,id:villager_spawn_egg,Count:127,tag:{EntityTag:{VillagerData:{profession:armorer,level:5,type:plains},Offers:{Recipes:[{buy:{id:stick,Count:1},sell:{id:emerald_block,Count:64},maxUses:9999999},{buy:{id:emerald,Count:1},sell:{id:stick,Count:64},maxUses:9999999},{buy:{id:stick,Count:1},sell:{id:paper,Count:64},maxUses:9999999},{buy:{id:stick,Count:1},sell:{id:gunpowder,Count:64},maxUses:9999999},{buy:{id:stick,Count:1},sell:{id:oak_log,Count:64},maxUses:9999999},{buy:{id:stick,Count:1},sell:{id:netherite_block,Count:64},maxUses:9999999}]}}}}]}} 1 it seems to be working but it gives nothing in the chest and I’m not sure if it can be done and I have […]

Categories
Ask Games Video Games

Custom model data not working

/summon minecraft:zombie ~ ~ ~ {CanBreakDoors:1,DrownedConversionTime:999999,Glowing:1,LeftHanded:1,Silent:1,HandItems:[{id:iron_sword,Count:1,CustomModelData:123456}],Attributes:[{Name:"generic.movement_speed",Base:0.3F},{Name:"generic.attack_damage",Base:6.0F},{Name:"generic.attack_speed",Base:6.0F},{Name:"generic.max_health",Base:40.0F},{Name:"generic.follow_range",Base:80.0F}],HandDropChances:[0F]}

Categories
Mastering Development

Jest mock readFile, writeFile doesn’t load my mocks

General question before. When I use jest.mock() can I only mock the whole module? Or also exported functions, constants. In my app.js, I use for example const fileSystem = require(‘fs’). I’m trying to test the app, which has a method where it reads a file with fs. Do I have now to mock the ‘fs’ […]

Categories
CMS Magento Mastering Development

URI is not valid and cannot be converted into a string

I’m struggling with an error that is thrown in the debug.log. The problem is that multiple indexers are not updated allthough the cronjobs are running. Re-indexing by CLI is working properly on all indexers but that cannot be the solution. The debug.log [2020-09-17 05:25:12] main.ERROR: Cron Job indexer_reindex_all_invalid has an error: URI is not valid […]

Categories
Ask Games Video Games

Minecraft skeleton spawn egg command

Ive got a command to spawn a mob, when i give the spawn egg to myself it shows that it has NBT tags but them tags dont take effect and it spawns a normal skeleton. What have i done wrong? /give 1r2x skeleton_spawn_egg 1 0 {Health:10000,Glowing:1,PersistenceRequired:1,Silent:1,HandItems:[{id:bow,tag:{Enchantments:[{id:power,lvl:40}],Unbreakable:1},Count:1}],HandDropChances:[0.00F],ArmorItems:[{id:netherite_boots,Count:1},{id:netherite_leggings,Count:1},{id:netherite_chestplate,Count:1},{id:skeleton_skull,Count:1}],ArmorDropChances:[0.00F,0.00F,0.00F,0.00F],Attributes:[{Name:"generic.armor",Base:300.0F},{Name:"generic.armor_toughness",Base:10.0F},{Name:"generic.max_health",Base:1024.0F},{Name:"generic.max_health",Base:10000F}]}

Categories
Ask Games Video Games

I posted this question once but it got flagged as a duplicate Ive searched for ages and still not fonud a fix [duplicate]

I’ve got a command to spawn the mob i want which uses a spawner, but i want it to spawn through a spawn egg. No this is not a duplicate of that 1.13 question as when i do the command he used which fixed it shows up with unknown item name. This is the command […]