dnd 3.5e – Do you get the additional attack of a Haste spell that you cast with a duration of 1 round?

A rogue PC in my campaign has just taken the Trapsmith prestige class and won the spell that way. He took Haste as one of his first spells. Now I wonder: His current caster level is 1. If he is hurrying, how long does it last? Only the round he casts the spell? Then he would only benefit from increased speed (+30 feet or double, whichever is lower) and +1 dodge Reflex and AC until his next turn. Or could he transfer the advantage to the next turn, if he takes his movement action first and then casts the spell with the standard action?

dnd 5e – If I run True Polymorph on my dummy and focus for the duration, will re-launching Simulacrum still destroy it?

Dummy States:

If you cast this spell again, any currently active duplicates you created with this spell are instantly destroyed.

Does this mean that if I take my dummy and constantly transform it using true polymorph in, say, a dragon, that if I throw dummy again, would that instantly destroy this dragon I just produced?

amazon rds – PostgreSQL slow query log entries contain no query details, only duration

I have a PostgreSQL RDS instance hosted in AWS. I put the log_min_duration_statement setting at 1 second. When checking my log for slow queries, I found the following six entries that contain no queries / instructions:

slow request log

Anyone have any idea why this happened? How do you know which slow requests caused these log entries?

Sheet G How to obtain an average duration?

I have a duration series which is also the result of a formula in a column formatted in duration

Duration :
80:08:00
53:05:00
50:20:00
86:21:00
59:56:00
44:27:00
#VALUE!
35:44:00
39:29:00
133:45:00
35:07:00
32:20:00
.../...

I would like to get the MIN, MAX and AVERAGE values. For the average I tried this formula

=ARRAYFORMULA(AVERAGE(TIMEVALUE(E2:E305)))

I have this error:

#VALUE! ERROR TIMEVALUE parameter '' cannot be parsed to date/time

How to exclude the cell with no value inside?

What is a session duration?

What is a session duration?

video – mp4 to m3u8 bad duration

My problem is that the m3u8 file has a bad duration and that the video stream has no fps.

final.mp4 and test.m3u8 have a different duration.

How can I fix it?

Source file:

Input #0, matroska,webm, from 'panasonic.mkv':
  Metadata:
    ENCODER         : Lavf57.66.105
  Duration: 00:00:46.12, start: 0.000000, bitrate: 4548 kb/s
    Stream #0:0: Video: h264 (High), yuv420p(top coded first (swapped)), 1920x1080 (SAR 1:1 DAR 16:9), 25 fps, 25 tbr, 1k tbn, 50 tbc (default)
    Metadata:
      ENCODER         : Lavc57.83.101 libx264
      DURATION        : 00:00:46.083000000
    Stream #0:1: Audio: vorbis, 48000 Hz, stereo, fltp (default)
    Metadata:
      ENCODER         : Lavc57.83.101 libvorbis
      DURATION        : 00:00:46.115000000

1. Analyze the source file for remote encoding

ffmpeg -i panasonic.mkv -map 0:a -map 0:v -codec copy -f segment -segment_time $LEN -segment_format matroska tempfolder/chunk-%03d.orig

2. Encode all orig files

ffmpeg -i chunk-%03d.orig -threads 0 -vcodec libx264 -preset slow -crf 22 -vf scale="trunc(oh*a/2)*2:480" -threads 0 -acodec aac -ab 128k chunk-%03d.enc

3. Combine all enc files

echo "ffconcat version 1.0" > concat.txt
for f in `ls chunk-*.enc | sort`; do
    echo "file $f" >> concat.txt
done

ffmpeg -y -f concat -i concat.txt -map 0 -f matroska -c copy out.mp4

4. Repair file

ffmpeg -i out.mp4 -c copy final.mp4

5. MP4Box for the web

MP4Box -inter 500 -quiet -noprog final.mp4

6. Mp4 to m3u8

ffmpeg -i final.mp4 -c copy -start_number 1 -hls_list_size 0 hls/test.m3u8

Result

final output.mp4

Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'final.mp4':
  Metadata:
    major_brand     : isom
    minor_version   : 512
    compatible_brands: isomiso2avc1mp41
    encoder         : Lavf58.20.100
  Duration: 00:00:46.30, start: 0.000000, bitrate: 743 kb/s
    Stream #0:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p, 852x480 (SAR 640:639 DAR 16:9), 610 kb/s, SAR 1:1 DAR 71:40, 24.91 fps, 50 tbr, 16k tbn, 50 tbc (default)
    Metadata:
      handler_name    : VideoHandler
    Stream #0:1(und): Audio: aac (LC) (mp4a / 0x6134706D), 48000 Hz, stereo, fltp, 127 kb/s (default)
    Metadata:
      handler_name    : SoundHandler

Test.m3u8 output

Input #0, hls,applehttp, from 'test.m3u8':
  Duration: 00:00:23.04, start: 1.480000, bitrate: 0 kb/s
  Program 0
    Metadata:
      variant_bitrate : 0
    Stream #0:0: Video: h264 (High) ((27)(0)(0)(0) / 0x001B), yuv420p, 852x480 (SAR 640:639 DAR 16:9), 50 tbr, 90k tbn, 50 tbc
    Metadata:
      variant_bitrate : 0
    Stream #0:1: Audio: aac (LC) ((15)(0)(0)(0) / 0x000F), 48000 Hz, stereo, fltp
    Metadata:
      variant_bitrate : 0

javascript – Generate ISO 8601 duration string from two date objects

I wrote a function that should generate an ISO 8601 duration string, with two dates as input.

import {
  differenceInYears,
  differenceInMonths,
  differenceInWeeks,
  differenceInDays,
  getDaysInYear,
  eachYearOfInterval,
} from 'date-fns/esm'; // v2.11.0

/**
 * Given a start Date and an end Date, returns an ISO 8601 duration string
 * Only supports Year, Month, Week, and Day. Does not support Hour or smaller.
 * @param  {Date} start
 * @param  {Date} end
 * @return {string} ISO 8601 Duration
 * @example
 * ```js
 * toISODurationString(new Date('2020'), new Date('2021'));
 * // => PY1
 * ```
 */
export function toISODurationString(start, end) {
  const differenceInDaysOverYears =
    eachYearOfInterval({ start, end })
      .map(getDaysInYear)
      .map(days => days % 365)
      .reduce(add) - 365;

  const Y = differenceInYears(end, start);
  const M = differenceInMonths(end, start) - 12;
  const W = differenceInWeeks(end, start) - 52;
  const D = differenceInDays(end, start) - (365 + differenceInDaysOverYears);

  return Object.entries({ Y, M, W, D })
    .reduce((s, (c, v)) => `${s}${v !== 0 ? c + v : ''}`, 'P');
}

I am concerned about the differenceInDaysOverYears part. Is this code reliable? Specifically, will it robustly manage any date you give it?

pathfinder 1e – If you cast a spell with a focus component and a long duration, does it end if the focus component is missing?

Unless the spell says otherwise, the components of a spell should only be satisfied when casting the spell: On the components says, "The components of a spell explain what you need to do or possess to cast the spell ", and among these components is a focus component. Later, the cast time details when a spell comes into effect, ending its cast, and no longer requiring the caster to satisfy the components of the spell.

So, in the same way that a spell must say that it requires that the caster act continuously throughout its duration, otherwise the duration of the spell ends (none to my knowledge, by the way ), a spell must also say that any concentration component is required for the duration of the spell and explain the consequences of his loss.

For example, the change of shape The focus of the spell is a jade circle with a price of 1500 gp, but after casting the spell, the caster can do anything with that circle without worrying about the premature end of the spell or anything another effect. (Using the change of shape the spell to change shape can merge the circle with the caster – see Transmutation on polymorph – but cast the spell then remove the circle then take a free action to change shape using the effect of the spell is completely legitimate.) Likewise, the fate real resurrection has as its component of divine concentration a diamond with a price of 25,000 in, but a new return of the dead buddy does not explode, as, if the caster gives the diamond to another after the caster has finished the spell.

Compare these examples to the consequences described for destroying the focus of the magic pot while the life force of the caster is inside the foyer.


Note: The in the Pathfinder antecedent D&D 3.5 the spell real resurrection had diamonds with a market price of 25,000 gp as a material component, so these diamonds were annihilated with each launch of a real resurrection spell. This unusual Scout the change had gone unnoticed by this long time Scout aficionado so far.

mysql – A long duration innodb request generates a large cancellation file in mariadb

I have a big request in php using MYSQLI_USE_RESULT to not put all the results in php memory. Because if I use MYSQLI_STORE_RESULT, this will put all the data in memory for all the results, which takes several GB of RAM, instead of getting line by line. it returns millions of lines and each line will generate an API request, so the query will run for days. In the meantime, I have other mysql queries that update / insert the tables related to the first query, and I think it increases the cancellation log without stopping.

I have configured innodb_undo_tablespaces = 2 and innodb_undo_log_truncate = ON so that the cancellation log is separated from ibdata1, but the cancellation files are always large until I kill requests that have been executed for days.

I ran "SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;" before executing the long request, hoping that it would prevent the growth of the rollback file, but this is not the case.

Other requests that update / insert have automatic validation.

In 1-2 days, the cancellation file is already 40 GB.

The question: how to prevent the increase of this cancellation file? Since I don't want to keep the previous version of the data while the query is running. It does not matter if I get updated data instead of the data that was at the time of the query.

What is a session duration?

What is a session duration?