how pseudo direct addressing works?

In pseudo direct addressing mode the 26 bit of the jump instruction are joined to the upper 4 bits of the PC .

  • how could this help in jumping to relative positions suppose I want to jump backward instead of forward ( i.e. if i want to jump to the beginning of a loop after executing it’s body ),

  • What I get is this will limit the jump to be 2^28 from the following instruction but Is this applicable backward too ? I am really confused by this so excuse me for such a silly question…

Does Heat Metal works with Descent Into Avernus vehicles?

As the title says, I’d like to know if I can use Heat Metal spell in Descent Into Avernus module and target a vehicle.

And more specifically, what happens about that part of the spell:

If a creature is holding or wearing the object and takes the damage from it, the creature must succeed on a Constitution saving throw or drop the object if it can.

What happens to the passengers?
Can the pilot continue to pilot?

My website gives “everybody” an error but it works just fine

I have website which runs just fine. I'm visiting it on PC, mobile, tablet and I'm even using Google Search Console & Analytics. And it just runs OK 100%. No issues whatsoever for me.

But when I'm promoting it (like direct Emails, social media etc.) I'm quite regularly getting responses "that website doesn't work" or "that link gives me an error". This issue lasts for months. I checked it on all my devices. I tried online web tests. Checked blacklists. Everything is OK. But…

My website gives "everybody" an error but it works just fine

Beginner looking to clarify how hiding works

I’ve just bought a starter set, and struggle a little to understand the concept of hiding. Do I roll a d20 + DEX (stealth) when I first want to hide, and note down the number. Then, for each turn that a creature is actively looking, roll a WIS (perception) for it and compare this against the written value?

What about passive perception? If a creature isn’t actively looking, do I instead compare its “WIS (perception) score + 10” to the written value?

And a slightly more general question – the rulebook isn’t clear on what happens when a “check” results in a draw. Who “wins” here? In the example of hiding, who does a draw count in favour of?

Certificate check works with root but fails with Intermediate CA [duplicate]

I have 3 certificates, server.crt issued by Intermediate CA which is issued by Root. The server.crt is configured on apache2 (version 2.4.29-1) on Ubuntu 18.04.

However when I am trying to connect to the server URL through openssl (version 1.1.1) using the intermediate CA as the CAfile parameter, I receive error as Verify return code: 2 (unable to get issuer certificate) Command used : openssl s_client -connect server_URL:443 -CAfile Intermediate.pem

But when I try to connect the same URL using the root certificate it works with return code 0. Command used : openssl s_client -connect server_URL:443 -CAfile Root.pem — Works fine

How can I make the the certificate check work using the intermediate CA and not Root certificate.

Note that the below certificate chain verification are all successful.

openssl verify -CAfile root.pem Internal_CA.pem — OK

openssl verify -CAfile root_and_intemediate_combined.pem server.pem — OK

Also I got same results for using both pem and crt formats for all certificates.

How bitly.com to bit.ly works

I have a question about how bitly.com to bit.ly work. My questions is not about shorting url from a long url to short one. Like the service Bitly provide.

Suppose I have website with the domain name freely.com and I want to access my website by tying free.ly in the url box. So, what setting I do in DNS field or something else.

Queries on large database kill connection to the server, works with LIMIT

I’m trying to run queries on a large-ish database without killing the connection to the server.

I’m using Postgres 12.1 on a mac with 16gb of memory, and about 40gb of free disk. The database is 78gb according to pg_database_size with the largest table being 20gb according do pg_total_relation_size.

The error I get (from the log), regardless of which non-working query I run, is:

server process (PID xxx) was terminated by signal 9: Killed: 9 

In VS code the error is "lost connection to server".

Two examples that don’t work are:

UPDATE table SET column = NULL WHERE column = 0; 
select columnA from table1 where columnA NOT IN ( select columnB from table2 ); 

I can run some of the queries (the above one, for example) by adding a LIMIT of, say, 1,000,000.

I suspected that I was running out of disk due to temp files, but in the log (with log_temp_files = 0), I can’t see any temp files being written.

I tried increasing and decreasing work_mem, maintenance_work_mem, shared_buffers, and temp_buffers. None worked, the performance was about the same.

I tried dropping all indexes, which brought down the “cost” on some of the queries, but they still killed the connection to the server.

What could be my problem and how can I troubleshoot this further?

Additionally, I read that temp files from timed-out queries are stored in pqsql_tmp. I checked the folder, and it does not have files of significant size. Could the temp files be stored somewhere else?


The log file for running a failed query looks like:

2020-02-17 09:31:08.626 CET [94908] LOG:  server process (PID xxx) was terminated by signal 9: Killed: 9 2020-02-17 09:31:08.626 CET [94908] DETAIL:  Failed process was running: update table         set columnname = NULL         where columnname = 0;  2020-02-17 09:31:08.626 CET [94908] LOG:  terminating any other active server processes 2020-02-17 09:31:08.626 CET [94919] WARNING:  terminating connection because of crash of another server process 2020-02-17 09:31:08.626 CET [94919] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exi$   2020-02-17 09:31:08.626 CET [94919] HINT:  In a moment you should be able to reconnect to the database and repeat your command. 2020-02-17 09:31:08.626 CET [94914] WARNING:  terminating connection because of crash of another server process 2020-02-17 09:31:08.626 CET [94914] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exi$   2020-02-17 09:31:08.626 CET [94914] HINT:  In a moment you should be able to reconnect to the database and repeat your command. 2020-02-17 09:31:08.629 CET [94908] LOG:  all server processes terminated; reinitializing 2020-02-17 09:31:08.698 CET [94927] LOG:  database system was interrupted; last known up at 2020-02-17 09:30:57 CET 2020-02-17 09:31:08.901 CET [94927] LOG:  database system was not properly shut down; automatic recovery in progress 2020-02-17 09:31:08.906 CET [94927] LOG:  invalid record length at 17/894C438: wanted 24, got 0 2020-02-17 09:31:08.906 CET [94927] LOG:  redo is not required 

How Does the Sleep spell works?

I just started playing AD&D 1E:

I’m confused by the table and the note:

  • HD/ Number Affected
    • up to 1/ 4d4
    • 1+1 to 2/ 2d4
    • 2+1 to 3/ 1d4
    • 3+1 to 4/ 1d2
    • 4+1 to 4+4/ 1d2-1

DM’s Advice: In a mixed group, the spell affects the lowest HD or levels first.

I know the area is 3” diameter within range (wich is 30ft diameter in 3.5 (24 squares)correct? indoor is feet and outside is yard? (according to this Answer) How much feets are yards?)

So how many total ennemies can be affected? (I have no clue what 1+1,2+1,3+1,4+1 and 4+4 means for the HD):

  • 16 up to 1
  • 8 1+1 to 2
  • 4 2+1to 3
  • etc. up to 24 indoors, and if the area outside permits it up to 31 creatures or did I miss something what does the note to the DM suggests?