Can this Lair Action restore all the lich’s 8th or lower spell slots even when there’s no combat or any of the lich’s enemies within?

One of the Lair Actions of a lich does the following:

The lich rolls a d8 and regains a spell slot of that level or lower. If it has no spent spell slots of that level or lower, nothing happens.

A lich decided to attack the party, using some of its spell slots in the process, and then retreat to its lair to recover and await the party.

If the party manage to find the lich’s lair within 8 hours (i.e. before the lich can long rest and recover its spell slots that way), would the above Lair Action have (likely1) restored all of the lich’s spent spell slots (excluding the 9th level spell slot, obviously)?

Or is there some reason this wouldn’t work, such as the Lair Actions only being "active" when there are enemies of the lich actually in the lair (i.e. during combat)?


1 I say "likely" because there’s a dice roll involved, so technically it could not roll the numbers it needs to actually recover all its spell slots, but let’s discount that possibility as I imagine an hour or so of rolling will almost definitely roll the numbers that it needs eventually.

restore mysql database from ibdata1 and frm files

I am trying to restore some database data from my tables frm files. I am running a mariadb database. The data structure works fine and i can see the tables etc. But as soon as i add the ibdata1 and logfiles i run into trouble and get the errors below. I’ve tried to follow recommendations of the other similar posts but nothing seems to work… Any ideas? BR Lukas

my my.cnf config file:

[client-server]  # # This group is read by the server # [mysqld] # Disabling symbolic-links is recommended to prevent assorted security risks innodb_log_file_size=170M innodb_force_recovery = 1 symbolic-links=0  # # include all files from the config directory # !includedir /etc/my.cnf.d 

Journalctl -xe error:

jun 09 01:29:04 ipx.eu-central-1.compute.internal sudo[15322]: pam_unix(sudo:session): session opened for user root by ec2-user(uid=0) jun 09 01:29:04 ipx.eu-central-1.compute.internal systemd[1]: Starting MariaDB 10.2 database server... -- Subject: Unit mariadb.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel --  -- Unit mariadb.service has begun starting up. jun 09 01:29:04 ipx.eu-central-1.compute.internal mysql-prepare-db-dir[15360]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. jun 09 01:29:04 ipx.eu-central-1.compute.internal mysql-prepare-db-dir[15360]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. jun 09 01:29:05 ipx.eu-central-1.compute.internal mysqld[15399]: 2020-06-09  1:29:05 140284526120768 [Note] /usr/libexec/mysqld (mysqld 10.2.10-MariaDB) starting as process 15399 ... jun 09 01:29:05 ipx.eu-central-1.compute.internal mysqld[15399]: 2020-06-09  1:29:05 140284526120768 [Warning] Changed limits: max_open_files: 1024  max_connections: 151  table_cache: 431 jun 09 01:29:05 ipx.eu-central-1.compute.internal systemd[1]: Started MariaDB 10.2 database server. -- Subject: Unit mariadb.service has finished start-up -- Defined-By: systemd --  -- Unit mariadb.service has finished starting up. --  -- The start-up result is done. jun 09 01:29:05 ipx.eu-central-1.compute.internal sudo[15322]: pam_unix(sudo:session): session closed for user root 

mariadb.log file:

2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Page [page id: space=0, page number=308] log sequence number 41316604 is in the future! Current system log sequence number 1620080.     2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman$       2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: Operating system error number 13 in a file operation.     2020-06-09  1:17:36 140094574546752 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.     2020-06-09 01:17:36 0x7f6a4f59cf40  InnoDB: Assertion failure in file /builddir/build/BUILD/mariadb-10.2.10/storage/innobase/fil/fil0fil.cc line 752 

mongodump and restore in single command

How to perform mongo DB dump and restore in a single command, by providing source and sink DB and collection name separately?

I understand we can do mongodump and then mongorestore but if I need to this on an intermediate machine, this will mean I will need to wait for mongodump to complete before I can start mongorestore manually again. Is there a way to do it in a single command?

How to restore hit point maximum?

As a DM, I’ve been using a Mummy and one of my players really lost a lot of hit point maximum. In my head, it was clear they’d go to the nearest town and ask for heal to the priest who can cast remove curse to halt the bleeding and greater restoration to get back their hit point maximum, but they only removed the curse (by spell swapping at a level up) and went on.

So I might throw another way to get their hit point maximum on the road, but what? Besides greater restoration (and wish), what are the other ways of getting back all of part of someone’s hit point maximum, especially at level 4-5?

Unable to open default database after delete and restore it with a backup from another computer

I’m using SQL Server 13.0.4259.

I have created an user for my database with this script:

— Create TRZF db user.

USE [master] GO  if not exists(SELECT name                  FROM [master].[sys].[server_principals]                WHERE name = N'trzf_user') begin     CREATE LOGIN [trzf_user] WITH PASSWORD = '**********', DEFAULT_DATABASE=[$  (DatabaseName)], DEFAULT_LANGUAGE=[Español] end  USE [$  (DatabaseName)] GO  IF NOT EXISTS (SELECT name                  FROM [sys].[database_principals]                 WHERE name = N'trzf_user') Begin     CREATE USER [trzf_user] FOR LOGIN [trzf_user] WITH DEFAULT_SCHEMA=[dbo] end ALTER ROLE [db_datareader] ADD MEMBER [trzf_user] ALTER ROLE [db_datawriter] ADD MEMBER [trzf_user]  GRANT EXECUTE TO [trzf_user]  GO 

But I have had to delete it and restore it from another client’s database. After doing that, I have tried to login with the user trzf_user, using Management Studio, but I get this error message:

Unable to open user default database. Login error. Login failed for user 'trzf_user'. (.Net SqlClient Data Provider) 

I have tried this script:

USE [master] GO  ALTER LOGIN [trzf_user] WITH DEFAULT_DATABASE=[TRZIC-F] GO  USE [TRZIC-F] GO  IF NOT EXISTS (SELECT name                  FROM [sys].[database_principals]                 WHERE name = N'trzf_user') Begin     CREATE USER [trzf_user] FOR LOGIN [trzf_user] WITH DEFAULT_SCHEMA=[dbo] end ALTER ROLE [db_datareader] ADD MEMBER [trzf_user] ALTER ROLE [db_datawriter] ADD MEMBER [trzf_user]  GRANT EXECUTE TO [trzf_user]  GO 

But I’m can’t login.

How can I fix this problem?

I have run all the scripts and restored the database using sa user.

Before deleting the database, I can login with user trzf_user.

Possible to restore LUKS header from partition that uses the exact same password and keyfile?

I was in Windows 10 and it told me I needed to Initialize Disk so I clicked it and now my LUKS header has been overwritten. I created my encrypted partitions in Linux with cryptsetup command. However, I have another drive that uses the same password and keyfile as the one with the overwritten partition header, … and I was wondering if it would be possible to backup the good partition header and use it for the one that has been overwritten since both LUKS encrypted partitions were created the same time, and with the exact same password/keyfile?

If anyone has experience in my position, I would be immensely grateful if you could point me in the right direction, or just tell me if am I screwed.

Thanks so much…

Does Healing Restore Blood?

Without going into too much detail, a question has come up in a Non-Adventurer’s League game that I am running where a player has asked me whether healing their character would restore blood loss from self-inflicted harm.

The difference, as I understand it, between hit points (HP) is that it is the amount of wounds or damage a person can sustain before falling to the dying state where their body works to heal themselves, as represented by the death saving throw rolls, before they die.

So if a person is purposefully bloodletting from their body, would simply healing them restore the immediate blood that they lost and allow them to reopen the wound and drain more blood as if they had never lost any to begin with?

I am pretty sure there is no definitive rules or rulings on this so I am trying to understand more of what healing represents in this context.