GOOGLE_SDK_NODE_LOGGING error on edge function

[JetUni]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

The function is throwing an error that was previously not there. It does not get to the Deno.serve portion of the code in the example below

To Reproduce

import 'jsr:@supabase/functions-js/edge-runtime.d.ts';
import { sheets } from 'npm:@googleapis/sheets';
import { JWT } from 'npm:google-auth-library';

// Create a new JWT client using the credentials
console.log('Creating Google JWT client');
const googleAuthJwt = new JWT({
  email: Deno.env.get('GOOGLE_SHEETS_API_CLIENT_EMAIL'),
  key: Deno.env.get('GOOGLE_SHEETS_API_PRIVATE_KEY'),
  scopes: ['https://www.googleapis.com/auth/spreadsheets'],
});

// Authorize and create a Google Sheets API instance
console.log('Connecting to Google Sheets API with JWT client');
const sheetsApi = sheets({ version: 'v4', auth: googleAuthJwt });

Deno.serve(async (req) => {
  return new Response('OK');
});

Expected behavior

A response is returned from the function

System information

• OS: Windows & GH Action
• Version of supabase-js: 2
• Version of Node.js: 20.17.0

Additional context

Error message I'm getting

{
  "event_message": "event loop error: TypeError: Cannot read properties of undefined (reading 'GOOGLE_SDK_NODE_LOGGING')\n    at Object.log (file:///var/tmp/sb-compile-edge-runtime/node_modules/localhost/google-logging-utils/0.0.2/build/src/logging-utils.js:356:36)\n    at Object.<anonymous> (file:///var/tmp/sb-compile-edge-runtime/node_modules/localhost/gcp-metadata/6.1.1/build/src/index.js:52:20)\n    at Object.<anonymous> (file:///var/tmp/sb-compile-edge-runtime/node_modules/localhost/gcp-metadata/6.1.1/build/src/index.js:409:4)\n    at Module._compile (node:module:731:34)\n    at Module._extensions..js (node:module:745:10)\n    at Module.load (node:module:656:32)\n    at Module._load (node:module:524:12)\n    at Module.require (node:module:675:19)\n    at require (node:module:790:16)\n    at Object.<anonymous> (file:///var/tmp/sb-compile-edge-runtime/node_modules/localhost/google-auth-library/9.14.0/build/src/auth/googleauth.js:31:21)",
  "id": "01d2fcd5-340d-42b6-85a5-0c477ed3b84c",
  "metadata": [
    {
      "boot_time": null,
      "cpu_time_used": null,
      "deployment_id": "box..._..._68",
      "event_type": "UncaughtException",
      "execution_id": "f6c241a9-65d7-4c2a-907f-f497b36cb441",
      "function_id": "...",
      "level": "error",
      "memory_used": [],
      "project_ref": "...",
      "reason": null,
      "region": "us-west-1",
      "served_by": "supabase-edge-runtime-1.66.5 (compatible with Deno v1.45.2)",
      "timestamp": "2025-02-02T15:34:11.110Z",
      "version": "68"
    }
  ],
  "timestamp": 1738510454102522
}

[linear]

FUNC-169 Process.env is now undefined

[JetUni]

I was hasty and jumped to conclusions of what the bug was. After I tested my own original "steps to reproduce", I found out I was wrong. So, I went back to the basics of what I understand and edited the description. Sorry if I created any confusion

[kallebysantos]

Hi @JetUni

The function is throwing an error that was previously not there.

Did you check if the google sdk you're using got some update? Since your imports doesn't have a pin version you may is getting a break change update - Not Edge Runtime related.
Btw, the current edge runtime from source code is v1.66.5 while Supabase hosting or supabase-cli functions serve are both using older versions.

EDIT: Already see that you're using the latest edge-runtime, so pls check the google lib side, from the logs seems that is a library break change. Try to rollback to the previous version you're using in the past. Example:

import { sheets } from 'npm:@googleapis/sheets@9.3.1';
import { JWT } from 'npm:google-auth-library@9.15.1';  // <- this one got an update 9 days ago

[JetUni]

I did already check from the dependency side by specifying a version that was in my lock file and was known to be working. In the future, I'll utilize the deno.json file now that I'm aware of it.

The only place this seems to be used in the Google code is here, which is why I rushed into thinking it was related to the process.env
https://github.com/googleapis/gax-nodejs/blob/c7e069656f7fb13e4fe82e374dbd1af49dbfdb16/logging-utils/src/logging-utils.ts#L470

In my commit, I locked them to these versions:

npm:@googleapis/sheets@9.3.1
npm:google-auth-library@9.14.0
npm:googleapis-common@7.2.0

[JetUni]

I've also attempted to rule out this project by deploying my functions using an earlier version of the CLI, but I can't get it to use an earlier version of the edge-runtime. I've also tried deleting all my functions and re-deploying with the older CLI. Is there some other way that I can downgrade the version for my project?

[kallebysantos]

Hi, thank you

The only place this seems to be used in the Google code is here, which is why I rushed into thinking it was related to the process.env

I did tried doing some tracing but unfortunately I can't give you an answer for that. Seems that process is undefined during the npm module load. My knowledge of the codebase is to limited 😔 so I'm afraid that I can't help you too much.

some other way that I can downgrade the version for my project

I'm not sure about that, I did looked into older questions and seems that you can't control the hosted version especially for free accounts. If you have a paid account, there're some discussions that mentioned to contact support service.
I also found some reference pointing to infrastructure tab, but I didn't found any downgrade option - only upgrade pg

I would like to help more, but probably you will need to wait someone with more understanding of the problem 😔

[Aereli]

@JetUni I had the same exact error and found another way to get the jwt token avoiding the node specific dependencies of googleSDK

import 'jsr:@supabase/functions-js/edge-runtime.d.ts';
import serviceAccount from './accountKey.json' with { type: 'json' }
import jwt from 'npm:jsonwebtoken@9.0.2';

const createJWT = () => {
  const payload = {
    iss: serviceAccount.client_email, // Service account email
    scope: 'https://www.googleapis.com/auth/firebase.messaging', 
    aud: 'https://oauth2.googleapis.com/token',
    exp: Math.floor(Date.now() / 1000) + 3600, // Expiration time (1 hour)
    iat: Math.floor(Date.now() / 1000), // Issued at time
  };

  // Sign the JWT using the private key from the service account
  return jwt.sign(payload, serviceAccount.private_key, { algorithm: 'RS256' });
};

Deno.serve(async (req) => {
  const token = createJWT();
  console.log('Token:', token);
  return new Response('OK');
});

You'll have to change the scope and pass your iss, private_key
this JWT would be sent to Google’s OAuth2 token endpoint (https://oauth2.googleapis.com/token) to exchange it for an access token.
The exp and iat fields are not mandatory but are recommended
Running this should return you your token in the console.

[nyannyacha]

Hey folks,

This problem seems to have been caused by google-logging-utils.
The package claims the process.env did not exist, but when I checked, it actually existed, and it seems to be caused by the fact that the env key was not recognized during the invoking of the built-in function __importStar generated by tsc.

I tried to reproduce this issue in Deno 2.1.4 standalone binary to see if it was an issue within the edge runtime area, but it also returned undefined.

var __createBinding = (this && this.__createBinding) || (Object.create ? (function(o, m, k, k2) {
    if (k2 === undefined) k2 = k;
    var desc = Object.getOwnPropertyDescriptor(m, k);
    if (!desc || ("get" in desc ? !m.__esModule : desc.writable || desc.configurable)) {
      desc = { enumerable: true, get: function() { return m[k]; } };
    }
    Object.defineProperty(o, k2, desc);
}) : (function(o, m, k, k2) {
    if (k2 === undefined) k2 = k;
    o[k2] = m[k];
}));
var __setModuleDefault = (this && this.__setModuleDefault) || (Object.create ? (function(o, v) {
    Object.defineProperty(o, "default", { enumerable: true, value: v });
}) : function(o, v) {
    o["default"] = v;
});
var __importStar = (this && this.__importStar) || (function () {
    var ownKeys = function(o) {
        ownKeys = Object.getOwnPropertyNames || function (o) {
            var ar = [];
            for (var k in o) if (Object.prototype.hasOwnProperty.call(o, k)) ar[ar.length] = k;
            return ar;
        };
        return ownKeys(o);
    };
    return function (mod) {
        if (mod && mod.__esModule) return mod;
        var result = {};
        if (mod != null) for (var k = ownKeys(mod), i = 0; i < k.length; i++) if (k[i] !== "default") __createBinding(result, mod, k[i]);
        __setModuleDefault(result, mod);
        return result;
    };
})();

const process = __importStar(require("node:process"));

console.log(process.env); // It shows the undefined value on the edge runtime or Deno 2.

Also, I have confirmed that the issue with this issue is already open in gax-nodejs, which is an actual repository that releases the google-logging-utils.

The issue appears to be a problem with that package, not a problem with the edge runtime or Deno, so I will close this.
Thank you!

[nyannyacha]

After further checking, I've confirmed there's a PR that solves this issue in the Deno repo.
This issue is fixed directly upstream, so the edge runtime will also reflect the change.

denoland/deno#27891