Database connection lost whenever SQL query string is too long

I recently switched from running my Rails app on a single VM to running the database — MariaDB 10.3 — on a separate (Debian Buster) VM. Now that the database is on a separate server, Rails immediately throws Mysql2::Error::ConnectionError: MySQL server has gone away whenever it tries to make a query where the SQL itself is very long. (They query itself isn’t necessarily one that would put significant load on the system.)

An example query that causes the problem looks like this:

SELECT `articles`.`id` FROM `articles` WHERE `articles`.`namespace` = 0 AND `articles`.`wiki_id` = 1 AND `articles`.`title` IN ('Abortion', 'American_Civil_Liberties_Union', 'Auschwitz_concentration_camp', 'Agent_Orange', 'Ahimsa') 

… except the array of titles is about 5000 items long, and the full query string is ~158kB.

On the database side, this corresponds to warnings like this:

2021-03-25 15:47:13 10 [Warning] Aborted connection 10 to db: 'dashboard' user: 'outreachdashboard' host: 'programs-and-events-dashboard.globaleducation.eqiad1.wikimed' (Got an error reading communication packets)

The problem seems to be with the network layer, but I can’t get to the bottom of it. I’ve tried adjusting many MariaDB config variables (max_allowed_packet, innodb_log_buffer_size, innodb_log_file_size, innodb_buffer_pool_size) but none of those made a difference. The problem seems to be that the connection is aborted while it is attempting to transmit the long SQL query string from the app server to the database server. (There’s no corresponding problem with receiving large query results from the database.)

I’ve tried adjusting several timeout-related settings as well, although that seems unlikely to be the problem because I can replicate the connection error without any significant wait, just by issuing one of the long-SQL-string queries from a Rails console.

I’ve tried using tcpdump to see what’s coming in, but didn’t pick up any additional clues from that.

Can a bolt-action hunting rifle (long arm), be fired when target is at arm’s length? [closed]

Yesterday, I was running my homebrew system (D100), with a friend and one of my nephews over Discord. It was a zombie apocalypse theme. The situation occurred, when my friend (carrying a bolt-action hunting rifle), was rushed by an ‘infected’, and it did a ‘claw strike’, and missed. It was my friend’s turn next. He wanted to do a scoped shot with the bolt-action hunting rifle, but I informed him that the infected was at arms length (too close).

He said he still wanted to fire his rifle (which I considered a long arm), but I said the target was too close. I gave him the option of using the rifle stock to make a melee attack, but he still wanted to fire the rifle. The ‘discussion’ went on for some time, with me trying to explain to the 2 of them (a third one soon joined in), all saying that he could fire the rifle, even if the target was at arm’s length (1 to 1.5ft away?) Hunting rifle stats: Most full-size, bolt-action hunting rifles weigh more or less eight pounds, are around 41 to 42 inches long and have 22- to 24-inch barrels. This means that with scope, sling and everything hunt-ready, the typical rifle rig weighs-in at around nine pounds. So from above, the rifle needs 3.5 feet ‘clearance’ to fire.

I was telling my friend that because the target was so close, and the rifle was a ‘long arm’, he didn’t have enough ‘space’ to bring it to bare, and point the barrel end at the target (it was in his face’, almost).

Any advice would be most appreciated concerning this above situation.

How long would you say it would take to break through this trap?

Here is the description of the trap. I removed module specific details to avoid spoilers.

The stone walls of this corridor are carved to resemble a stack of bamboo-like logs. The passage slopes down from a single door on its western leg, the lintel of which has been crafted to represent a stylized cavern entrance.

If the trap triggers, several of the logs swing out from either wall and buffet the party. Once they swing out, the stone logs don’t swing back and thus effectively block the passage, since they bar the way from ceiling to floor with only a 6-inch gap remaining between the logs.

I don’t want it to be impenetrable. How would you rule PCs breaking through?

how could you maximize food production with magic items and spells over a long period of time?

Over the course of years, how would you appropriately maximize food production for a town or city? If you assume the small city/large town and its very large (100-mile radius) surrounding area can be created with this goal in mind, what spells and magic items could be useful? This should be ruling out spells that are very small individual buffs(Haste, Enlarge/Reduce etc). These options should be more efficient than Plant Growth unless they are lower level/repeatable. Creative options like the Decanter of Endless Water and similar would also be helpful!

I am asking this as a player: the premise is creating a city. Any spells are acceptable, lower magic is preferred(1-5), but higher-level options are also good to know. This question has a broader application than this related question that is only about the plant growth spell’s applicability.

How long do creatures from a Bag of Tricks last?

For reference, DMG p154 –

You can use an action to pull the fuzzy object from the bag and throw it up to 20 feet. When the object lands, it transforms into a creature you determine by rolling a d8 and consulting the table that correspond’s to the bag’s color. See the Monstor Manual for the creature’s statistics. The creature is friendly to you and your companions, and it acts on your turn. you can use a bonus action to command how the creature moves and what action it takes on it’s next turn, or to give it general orders, such as to attack your enemies. In the absence of such orders the creature acts in a fashion appropriate to it’s nature.

Is 4 hours long enough for a long rest for Elves?

The Long Rest rules read:

A long rest is a period of extended downtime, at least 8 hours long, during which you sleep or perform light activity: reading, talking, eating, or standing watch for no more than 2 hours of the rest period. If the rest is interrupted by a strenuous activity—such as attacking, taking damage, or casting a spell—you must start the rest over to gain any benefit from it, unless the interruption takes less than an hour. You must have at least 1 hit point to take a long rest. At the end of the rest, you regain all your hit points and half of your maximum number of Hit Dice (round up). You cannot benefit from more than one long rest in a 24-hour period.

The elven Trance racial trait reads as:

Trance: Elves do not need to sleep. Instead, they meditate deeply for 4 hours a day. (The Common word for such meditation is “trance.”) While meditating, you can dream after a fashion; such dreams are actually mental exercises that have become reflexive through years of practice. After resting in this way, you gain the same benefit that a human does from 8 hours of sleep.

I have heard two views regarding these rules:

  • An Elf can get the benefit of a Long Rest in only 4 hours.
  • The 4 hours only applies to not being exhausted, 8 hours is still required get the benefits of a Long Rest.

Which is it? Please provide supporting information, possibly from previous versions.

Can I as a Bloodhunter create mutagens without doing a short or long rest?

As a 2020 version of the Bloodhunter/mutagen order, at lvl 3 I can create one mutagens in a short/long rest.

I read this handbook:

As a possible fix: Instead of preparing your mutagens during a rest, you prepare reagents for mutagens.

Creating a mutagen requires one minute of uninterrupted work with these reagents and a set of alchemist’s tools. This allows the Blood Hunter a bit more flexibility with their mutagens, but not so much that they can change them during combat."

I don´t really understand where he gets that with the reagents. I can´t find it in the books and nothing about it on the internet.

This way I could do a 1 min pause and prepare the mutagen without doing a short rest.

I hope you can help me to understand it better.