How to prove that the bootloader of a device is unlockable when it currently shows as locked?

A newly bought Pixel device from a random seller can switch between carriers but the bootloader shows as locked. Are all pixel devices’ bootloaders locked by default? And how to show that it is possible to unlock the bootloader? And how to re-lock it for Pixel 2 XL. Any sources would be appreciated.

This phone is model G011C.

Database and table size shows large difference

I was running a materialized view refresh command in my postgres database. While the query was running it hit out of storage space and crashed with the following error.

psql:refresh.sql:1: FATAL:  terminating connection due to administrator command SSL connection has been closed unexpectedly psql:refresh.sql:1: connection to server was lost psql:refresh.sql:1: WARNING:  terminating connection because of crash of another server process DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT:  In a moment you should be able to reconnect to the database and repeat your command. psql:refresh.sql:1: SSL SYSCALL error: EOF detected psql:refresh.sql:1: connection to server was lost psql:refresh.sql:9: ERROR:  could not write to hash-join temporary file: No space left on device 

I added additional storage to the database and did vacuum full but the storage that was used for the failed refresh ahs not been released. Currently my total table size is 183 Gib while database size is 375 Gib

Drupal 8 REST export View shows “This display has no path” in View UI and 404 Error on page

I’ve got a fresh install of Drupal 8.6.x with REST/API/JSON Web Services enabled and I’ve created a Rest export View with path: /api/test which returns the correct JSON View results when I append the required querystring:

?_format=json 

So all is well. Until I either create a second REST export View or a new Display in the working View. These seem to work fine in the View’s UI Preview but also displays “This display has no path” just above the Preview output. If I go to the new View/Display’s URL I get Page Not Found and if I append ?_format=json I get this:

{ "message": "No route found for \"GET /api/temp-view\"" } 

(/api/temp-view is my second View’s path).

It’s the strangest thing. Only the first, original view Display is working. I’ve created all sorts of different URL paths to test (and Saved each time). The View settings are standard and identical.

I’ve spent about 6 hours on this now…

Any help much appreciated.