/*------------------------------------------------------------------------- * * plv8.cc : PL/v8 handler routines. * * Copyright (c) 2009-2012, the PLV8JS Development Group. *------------------------------------------------------------------------- */ #include "plv8.h" #ifdef _MSC_VER #undef open #endif #include "libplatform/libplatform.h" #include "plv8_allocator.h" #include extern "C" { #if PG_VERSION_NUM >= 90300 #include "access/htup_details.h" #endif #include "access/xact.h" #include "catalog/pg_proc.h" #include "catalog/pg_type.h" #include "commands/trigger.h" #include "executor/spi.h" #include "funcapi.h" #include "miscadmin.h" #include "utils/builtins.h" #include "utils/guc.h" #include "utils/memutils.h" #include "utils/lsyscache.h" #include "utils/rel.h" #include "utils/syscache.h" #if PG_VERSION_NUM >= 120000 #include "catalog/pg_database.h" #endif #if PG_VERSION_NUM >= 130000 #include "common/hashfn.h" #endif #include #ifdef EXECUTION_TIMEOUT #ifdef _MSC_VER #include #else #include #endif #endif PG_MODULE_MAGIC; PGDLLEXPORT Datum plv8_call_handler(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plv8_call_validator(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plcoffee_call_handler(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plcoffee_call_validator(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plls_call_handler(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plls_call_validator(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plv8_reset(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plv8_info(PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(plv8_call_handler); PG_FUNCTION_INFO_V1(plv8_call_validator); PG_FUNCTION_INFO_V1(plcoffee_call_handler); PG_FUNCTION_INFO_V1(plcoffee_call_validator); PG_FUNCTION_INFO_V1(plls_call_handler); PG_FUNCTION_INFO_V1(plls_call_validator); PG_FUNCTION_INFO_V1(plv8_reset); PG_FUNCTION_INFO_V1(plv8_info); PGDLLEXPORT void _PG_init(void); #if PG_VERSION_NUM >= 90000 PGDLLEXPORT Datum plv8_inline_handler(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plcoffee_inline_handler(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plls_inline_handler(PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(plv8_inline_handler); PG_FUNCTION_INFO_V1(plcoffee_inline_handler); PG_FUNCTION_INFO_V1(plls_inline_handler); #endif } // extern "C" using namespace v8; typedef struct plv8_proc_cache { Oid fn_oid; Persistent function; char proname[NAMEDATALEN]; char *prosrc; TransactionId fn_xmin; ItemPointerData fn_tid; Oid user_id; int nargs; bool retset; /* true if SRF */ Oid rettype; Oid argtypes[FUNC_MAX_ARGS]; } plv8_proc_cache; plv8_context *current_context = nullptr; size_t plv8_memory_limit = 0; size_t plv8_last_heap_size = 0; /* * The function and context are created at the first invocation. Their * lifetime is same as plv8_proc, but they are not palloc'ed memory, * so we need to clear them at the end of transaction. */ typedef struct plv8_exec_env { Isolate *isolate; Persistent recv; Persistent context; Local localContext() { return Local::New(isolate, context) ; } struct plv8_exec_env *next; } plv8_exec_env; /* * We cannot cache plv8_type inter executions because it has FmgrInfo fields. * So, we cache rettype and argtype in fn_extra only during one execution. */ typedef struct plv8_proc { plv8_proc_cache *cache; plv8_exec_env *xenv; TypeFuncClass functypclass; /* For SRF */ plv8_type rettype; plv8_type argtypes[FUNC_MAX_ARGS]; } plv8_proc; static HTAB *plv8_proc_cache_hash = NULL; static plv8_exec_env *exec_env_head = NULL; extern const unsigned char coffee_script_binary_data[]; extern const unsigned char livescript_binary_data[]; static void killPlv8Context(plv8_context *ctx); /* * lower_case_functions are postgres-like C functions. * They could raise errors with elog/ereport(ERROR). */ static plv8_proc *plv8_get_proc(Oid fn_oid, FunctionCallInfo fcinfo, bool validate, char ***argnames) throw(); static void plv8_xact_cb(XactEvent event, void *arg); /* * CamelCaseFunctions are C++ functions. * They could raise errors with C++ throw statements, or never throw exceptions. */ static plv8_exec_env *CreateExecEnv(Handle function, plv8_context *context); static plv8_exec_env *CreateExecEnv(Persistent& function, plv8_context *context); static plv8_proc *Compile(Oid fn_oid, FunctionCallInfo fcinfo, bool validate, bool is_trigger, Dialect dialect); static Local CompileFunction(plv8_context *global_context, const char *proname, int proarglen, const char *proargs[], const char *prosrc, bool is_trigger, bool retset, Dialect dialect); static Datum CallFunction(PG_FUNCTION_ARGS, plv8_exec_env *xenv, int nargs, plv8_type argtypes[], plv8_type *rettype); static Datum CallSRFunction(PG_FUNCTION_ARGS, plv8_exec_env *xenv, int nargs, plv8_type argtypes[], plv8_type *rettype); static Datum CallTrigger(PG_FUNCTION_ARGS, plv8_exec_env *xenv); static plv8_context *GetPlv8Context(); static Local GetGlobalObjectTemplate(Isolate *isolate); static void CreateIsolate(plv8_context *context); /* A GUC to specify a custom start up function to call */ static char *plv8_start_proc = NULL; /* A GUC to specify V8 flags (e.g. --es_staging) */ static char *plv8_v8_flags = NULL; /* A GUC to specify the ICU data directory */ static char *plv8_icu_data = NULL; /* A GUC to specify the remote debugger port */ static int plv8_debugger_port; #ifdef EXECUTION_TIMEOUT static int plv8_execution_timeout = 300; #endif static std::unique_ptr v8_platform = NULL; /* * We use vector instead of hash since the size of this array * is expected to be short in most cases. */ static std::vector ContextVector; #ifdef ENABLE_DEBUGGER_SUPPORT v8::Persistent debug_message_context; void DispatchDebugMessages() { // We are in some random thread. We should already have v8::Locker acquired // (we requested this when registered this callback). We was called // because new debug messages arrived; they may have already been processed, // but we shouldn't worry about this. // // All we have to do is to set context and call ProcessDebugMessages. // // We should decide which V8 context to use here. This is important for // "evaluate" command, because it must be executed some context. // In our sample we have only one context, so there is nothing really to // think about. v8::Context::Scope scope(debug_message_context); v8::Debug::ProcessDebugMessages(); } #endif // ENABLE_DEBUGGER_SUPPORT void OOMErrorHandler(const char* location, bool is_heap_oom) { Isolate *isolate = Isolate::GetCurrent(); isolate->TerminateExecution(); // set it to kill the user context and isolate current_context->is_dead = true; elog(ERROR, "Out of memory error"); } void GCEpilogueCallback(Isolate* isolate, GCType type, GCCallbackFlags /* flags */) { HeapStatistics heap_statistics; isolate->GetHeapStatistics(&heap_statistics); //elog(NOTICE, "Current memory: %lld => %lld", heap_statistics.used_heap_size(), plv8_memory_limit * 1_MB); if (type != GCType::kGCTypeIncrementalMarking && heap_statistics.used_heap_size() > plv8_memory_limit * 1_MB) { //elog(NOTICE, "Terminating"); const char *error_message = "Out of memory"; Local result = ToString(error_message, 13); isolate->ThrowException(result); //isolate->setData(MEM_SOFTLIMIT_REACHED); isolate->TerminateExecution(); } if (heap_statistics.used_heap_size() > plv8_memory_limit * 1_MB / 0.9 && plv8_last_heap_size < plv8_memory_limit * 1_MB / 0.9) { isolate->LowMemoryNotification(); } plv8_last_heap_size = heap_statistics.used_heap_size(); } size_t NearHeapLimitHandler(void* data, size_t current_heap_limit, size_t initial_heap_limit) { Isolate *isolate = Isolate::GetCurrent(); isolate->TerminateExecution(); // need to give back more space // to make sure it can unwind the stack and process exceptions return current_heap_limit + 1_MB; } void PromiseRejectCB(PromiseRejectMessage rejection) { auto event = rejection.GetEvent(); if (event == kPromiseRejectAfterResolved || event == kPromiseResolveAfterResolved) return; auto promise = rejection.GetPromise(); auto isolate = promise->GetIsolate(); if (rejection.GetEvent() == v8::kPromiseHandlerAddedAfterReject) { if (current_context->ignore_unhandled_promises) return; // Remove handled promises from the list auto& unhandled_promises = current_context->unhandled_promises; for (auto it = unhandled_promises.begin(); it != unhandled_promises.end(); ++it) { auto unhandled_promise = std::get<0>(*it).Get(isolate); if (unhandled_promise == promise) { unhandled_promises.erase(it--); } } return; } auto exception = rejection.GetValue(); Local message; // Assume that all objects are stack-traces. if (exception->IsObject()) { message = Exception::CreateMessage(isolate, exception); } if (!exception->IsNativeError() && (message.IsEmpty() || message->GetStackTrace().IsEmpty())) { // If there is no real Error object, manually throw and catch a stack trace. TryCatch try_catch(isolate); try_catch.SetVerbose(true); isolate->ThrowException(Exception::Error( v8::String::NewFromUtf8Literal(isolate, "Unhandled Promise."))); message = try_catch.Message(); exception = try_catch.Exception(); } if (current_context->ignore_unhandled_promises) return; current_context->unhandled_promises.emplace_back( v8::Global(isolate, promise), v8::Global(isolate, message), v8::Global(isolate, exception)); } void HandleUnhandledPromiseRejections() { // Avoid recursive calls to HandleUnhandledPromiseRejections. auto isolate = current_context->isolate; if (current_context->ignore_unhandled_promises) return; current_context->ignore_unhandled_promises = true; HandleScope scope(isolate); // Ignore promises that get added during error reporting. size_t i = 0; auto& unhandled_promises = current_context->unhandled_promises; for (; i < unhandled_promises.size(); i++) { const auto& tuple = unhandled_promises[i]; Local message = std::get<1>(tuple).Get(isolate); Local exception = std::get<2>(tuple).Get(isolate); js_error error(isolate, exception, message); error.log(WARNING, "Unhandled Promise rejection: %s"); } unhandled_promises.clear(); current_context->ignore_unhandled_promises = false; } static void CreateIsolate(plv8_context *context) { Isolate *isolate; Isolate::CreateParams params; params.array_buffer_allocator = new ArrayAllocator(plv8_memory_limit * 1_MB); //params.array_buffer_allocator = // v8::ArrayBuffer::Allocator::NewDefaultAllocator(); ResourceConstraints rc; rc.ConfigureDefaults(plv8_memory_limit * 1_MB * 2, plv8_memory_limit * 1_MB * 2); params.constraints = rc; isolate = Isolate::New(params); isolate->SetOOMErrorHandler(OOMErrorHandler); isolate->AddGCEpilogueCallback(GCEpilogueCallback); isolate->AddNearHeapLimitCallback(NearHeapLimitHandler, NULL); isolate->SetPromiseRejectCallback(PromiseRejectCB); context->isolate = isolate; context->array_buffer_allocator = params.array_buffer_allocator; } void _PG_init(void) { HASHCTL hash_ctl = { 0 }; hash_ctl.keysize = sizeof(Oid); hash_ctl.entrysize = sizeof(plv8_proc_cache); hash_ctl.hash = oid_hash; plv8_proc_cache_hash = hash_create("PLv8 Procedures", 32, &hash_ctl, HASH_ELEM | HASH_FUNCTION); DefineCustomStringVariable("plv8.start_proc", gettext_noop("PLV8 function to run once when PLV8 is first used."), NULL, &plv8_start_proc, NULL, PGC_USERSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); DefineCustomStringVariable("plv8.icu_data", gettext_noop("ICU data file directory."), NULL, &plv8_icu_data, NULL, PGC_USERSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); DefineCustomStringVariable("plv8.v8_flags", gettext_noop("V8 engine initialization flags (e.g. --harmony for all current harmony features)."), NULL, &plv8_v8_flags, NULL, PGC_USERSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); DefineCustomIntVariable("plv8.debugger_port", gettext_noop("V8 remote debug port."), gettext_noop("The default value is 35432. " "This is effective only if PLV8 is built with ENABLE_DEBUGGER_SUPPORT."), &plv8_debugger_port, 35432, 0, 65536, PGC_USERSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); #ifdef EXECUTION_TIMEOUT DefineCustomIntVariable("plv8.execution_timeout", gettext_noop("V8 execution timeout."), gettext_noop("The default value is 300 seconds. " "This allows you to override the default execution timeout."), &plv8_execution_timeout, 300, 1, 65536, PGC_USERSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); #endif DefineCustomIntVariable("plv8.memory_limit", gettext_noop("Per-isolate memory limit in MBytes"), gettext_noop("The default value is 256 MB"), (int*)&plv8_memory_limit, 256, 256, 3096, // hardcoded v8 limits for isolates PGC_SUSET, 0, #if PG_VERSION_NUM >= 90100 NULL, #endif NULL, NULL); RegisterXactCallback(plv8_xact_cb, NULL); EmitWarningsOnPlaceholders("plv8"); if (plv8_icu_data == NULL) { elog(DEBUG1, "no icu dir"); V8::InitializeICU(); } else { elog(DEBUG1, "init icu data %s", plv8_icu_data); V8::InitializeICU(plv8_icu_data); } #if (V8_MAJOR_VERSION == 4 && V8_MINOR_VERSION >= 6) || V8_MAJOR_VERSION >= 5 V8::InitializeExternalStartupData("plv8"); #endif if (!v8_platform) { v8_platform = platform::NewDefaultPlatform(); } V8::InitializePlatform(v8_platform.get()); V8::Initialize(); if (plv8_v8_flags != NULL) { V8::SetFlagsFromString(plv8_v8_flags, strlen(plv8_v8_flags)); } } static void plv8_xact_cb(XactEvent event, void *arg) { plv8_exec_env *env = exec_env_head; while (env) { if (!env->recv.IsEmpty()) { env->recv.Reset(); } env = env->next; /* * Each item was allocated in TopTransactionContext, so * it will be freed eventually. */ } exec_env_head = NULL; } static inline plv8_exec_env * plv8_new_exec_env(Isolate *isolate) { plv8_exec_env *xenv = (plv8_exec_env *) MemoryContextAllocZero(TopTransactionContext, sizeof(plv8_exec_env)); new(&xenv->context) Persistent(); new(&xenv->recv) Persistent(); xenv->isolate = isolate; /* * Add it to the list, which will be freed in the end of top transaction. */ xenv->next = exec_env_head; exec_env_head = xenv; return xenv; } static Datum common_pl_call_handler(PG_FUNCTION_ARGS, Dialect dialect) throw() { current_context = GetPlv8Context(); Oid fn_oid = fcinfo->flinfo->fn_oid; bool is_trigger = CALLED_AS_TRIGGER(fcinfo); try { #ifdef ENABLE_DEBUGGER_SUPPORT Locker lock; #endif // ENABLE_DEBUGGER_SUPPORT Isolate::Scope scope(current_context->isolate); HandleScope handle_scope(current_context->isolate); if (!fcinfo->flinfo->fn_extra) { plv8_proc *proc = Compile(fn_oid, fcinfo, false, is_trigger, dialect); proc->xenv = CreateExecEnv(proc->cache->function, current_context); fcinfo->flinfo->fn_extra = proc; } plv8_proc *proc = (plv8_proc *) fcinfo->flinfo->fn_extra; plv8_proc_cache *cache = proc->cache; if (is_trigger) return CallTrigger(fcinfo, proc->xenv); else if (cache->retset) return CallSRFunction(fcinfo, proc->xenv, cache->nargs, proc->argtypes, &proc->rettype); else return CallFunction(fcinfo, proc->xenv, cache->nargs, proc->argtypes, &proc->rettype); } catch (js_error& e) { e.rethrow(); } catch (pg_error& e) { e.rethrow(); } return (Datum) 0; // keep compiler quiet } Datum plv8_call_handler(PG_FUNCTION_ARGS) { return common_pl_call_handler(fcinfo, PLV8_DIALECT_NONE); } Datum plcoffee_call_handler(PG_FUNCTION_ARGS) { return common_pl_call_handler(fcinfo, PLV8_DIALECT_COFFEE); } Datum plls_call_handler(PG_FUNCTION_ARGS) { return common_pl_call_handler(fcinfo, PLV8_DIALECT_LIVESCRIPT); } static void killPlv8Context(plv8_context *ctx) { HASH_SEQ_STATUS status; plv8_proc_cache* cache; // need to search and reset all the user functions which were created in the old context hash_seq_init(&status, plv8_proc_cache_hash); cache = (plv8_proc_cache *) hash_seq_search(&status); while (cache != nullptr) { if (cache->user_id == ctx->user_id) { if (cache->prosrc) { pfree(cache->prosrc); cache->prosrc = NULL; } cache->function.Reset(); } cache = (plv8_proc_cache *) hash_seq_search(&status); } ctx->isolate->Dispose(); delete ctx->array_buffer_allocator; } Datum plv8_reset(PG_FUNCTION_ARGS) { Oid user_id = GetUserId(); unsigned long i; for (i = 0; i < ContextVector.size(); i++) { if (ContextVector[i]->user_id == user_id) { plv8_context * context = ContextVector[i]; ContextVector.erase(ContextVector.begin() + i); killPlv8Context(context); pfree(context); break; } } return (Datum) 0; } Datum plv8_info(PG_FUNCTION_ARGS) { unsigned long i; unsigned long size = ContextVector.size(); char **infos = nullptr; size_t *lengths = nullptr; size_t total_length = 3; // length of "[]\0" *infos = (char *) palloc(sizeof(char) * size); lengths = (size_t *) palloc(sizeof(size_t) * size); for (i = 0; i < size; i++) { Isolate *isolate = ContextVector[i]->isolate; Isolate::Scope scope(isolate); HandleScope handle_scope(isolate); Local context = ContextVector[i]->localContext(); Context::Scope context_scope(context); JSONObject JSON; Local result; Local obj = v8::Object::New(isolate); #if PG_VERSION_NUM >= 90500 char *username = GetUserNameFromId(ContextVector[i]->user_id, false); #else char *username = GetUserNameFromId(ContextVector[i]->user_id); #endif obj->Set(context, v8::String::NewFromUtf8Literal(isolate, "user"), v8::String::NewFromUtf8(isolate, username).ToLocalChecked()).Check(); GetMemoryInfo(obj); result = JSON.Stringify(obj); CString str(result); infos[i] = pstrdup(str.str()); lengths[i] = strlen(infos[i]); total_length += lengths[i] + 1; // add 1 byte for ',' } char *out = (char *) palloc0(total_length); out[0] = '['; size_t current = 0; for (i = 0; i < size; i++) { ++current; strcpy(out + current, infos[i]); pfree(infos[i]); current += lengths[i]; out[current] = ','; } out[current] = ']'; pfree(*infos); pfree(lengths); return CStringGetTextDatum(out); } #if PG_VERSION_NUM >= 90000 static Datum common_pl_inline_handler(PG_FUNCTION_ARGS, Dialect dialect) throw() { InlineCodeBlock *codeblock = (InlineCodeBlock *) DatumGetPointer(PG_GETARG_DATUM(0)); Assert(IsA(codeblock, InlineCodeBlock)); try { #ifdef ENABLE_DEBUGGER_SUPPORT Locker lock; #endif // ENABLE_DEBUGGER_SUPPORT current_context = GetPlv8Context(); Isolate::Scope scope(current_context->isolate); HandleScope handle_scope(current_context->isolate); char *source_text = codeblock->source_text; Persistent global_context; global_context.Reset(current_context->isolate, current_context->context); Local function = CompileFunction(current_context, NULL, 0, NULL, source_text, false, false, dialect); plv8_exec_env *xenv = CreateExecEnv(function, current_context); return CallFunction(fcinfo, xenv, 0, NULL, NULL); } catch (js_error& e) { e.rethrow(); } catch (pg_error& e) { e.rethrow(); } return (Datum) 0; // keep compiler quiet } Datum plv8_inline_handler(PG_FUNCTION_ARGS) { return common_pl_inline_handler(fcinfo, PLV8_DIALECT_NONE); } Datum plcoffee_inline_handler(PG_FUNCTION_ARGS) { return common_pl_inline_handler(fcinfo, PLV8_DIALECT_COFFEE); } Datum plls_inline_handler(PG_FUNCTION_ARGS) { return common_pl_inline_handler(fcinfo, PLV8_DIALECT_LIVESCRIPT); } #endif #ifdef EXECUTION_TIMEOUT /* * Breakout -- break out of a Call, with a thread * * This function breaks out of a javascript execution context. */ #ifdef _MSC_VER // windows DWORD WINAPI Breakout (LPVOID lpParam) { Isolate *isolate = (Isolate *) lpParam; Sleep(plv8_execution_timeout * 1000); isolate->TerminateExecution(); return 0; } #else // posix void * Breakout (void *d) { auto *isolate = (Isolate *) d; sleep(plv8_execution_timeout); pthread_setcancelstate(PTHREAD_CANCEL_DISABLE, NULL); isolate->TerminateExecution(); return NULL; } #endif #endif void *int_handler = NULL; void *term_handler = NULL; void *abt_handler = NULL; /* * signal handler * * This function kills the execution of the v8 process if a signal is called */ void signal_handler (int sig) { elog(DEBUG1, "cancelling execution"); auto running_context = GetPlv8Context(); running_context->interrupted = true; running_context->isolate->TerminateExecution(); // call the old handler if it exists switch(sig) { case SIGINT: if (int_handler != NULL) { ((void (*)(int)) int_handler)(sig); } break; case SIGTERM: if (term_handler != NULL) { ((void (*)(int)) term_handler)(sig); } break; case SIGABRT: if (abt_handler != NULL) { ((void (*)(int)) abt_handler)(sig); } break; } } /* * DoCall -- Call a JS function with SPI support. * * This function could throw C++ exceptions, but must not throw PG exceptions. */ static Local DoCall(Local ctx, Handle fn, Handle receiver, int nargs, Handle args[], bool nonatomic) { Isolate *isolate = ctx->GetIsolate(); TryCatch try_catch(isolate); if (isolate->IsExecutionTerminating() || current_context->interrupted) { isolate->CancelTerminateExecution(); if (current_context->interrupted) { current_context->interrupted = false; } } #if PG_VERSION_NUM >= 110000 if (SPI_connect_ext(nonatomic ? SPI_OPT_NONATOMIC : 0) != SPI_OK_CONNECT) throw js_error("could not connect to SPI manager"); #else if (SPI_connect() != SPI_OK_CONNECT) throw js_error("could not connect to SPI manager"); #endif // set up the signal handlers if (int_handler == NULL) { int_handler = (void *) signal(SIGINT, signal_handler); } if (term_handler == NULL) { term_handler = (void *) signal(SIGTERM, signal_handler); } if (abt_handler == NULL) { abt_handler = (void *) signal(SIGABRT, signal_handler); } #ifdef EXECUTION_TIMEOUT bool timeout = false; #ifdef _MSC_VER // windows HANDLE hThread; DWORD dwThreadId; hThread = CreateThread(NULL, 0, Breakout, isolate, 0, &dwThreadId); #else pthread_t breakout_thread; // set up the thread to break out the execution if needed pthread_create(&breakout_thread, NULL, Breakout, isolate); #endif #endif try { MaybeLocal result = fn->Call(ctx, receiver, nargs, args); int status = SPI_finish(); #ifdef EXECUTION_TIMEOUT #ifdef _MSC_VER if (TerminateThread(hThread, NULL) == 0) { timeout = true; } #else void *thread_result; pthread_cancel(breakout_thread); pthread_join(breakout_thread, &thread_result); if (thread_result == NULL) { timeout = true; } #endif #endif // reset signal handlers signal(SIGINT, (void (*)(int)) int_handler); signal(SIGTERM, (void (*)(int)) term_handler); signal(SIGABRT, (void (*)(int)) abt_handler); HandleUnhandledPromiseRejections(); if (result.IsEmpty()) { if (isolate->IsExecutionTerminating() || current_context->interrupted) { isolate->CancelTerminateExecution(); if (current_context->interrupted) { current_context->interrupted = false; throw js_error("Signal caught: interrupted"); } #ifdef EXECUTION_TIMEOUT if (timeout) { throw js_error("execution timeout exceeded"); } #endif throw js_error("Out of memory error"); } throw js_error(try_catch); } if (status < 0) throw js_error(FormatSPIStatus(status)); return result.ToLocalChecked(); } catch (int err) { elog(NOTICE, "Error caught"); } } static Datum CallFunction(PG_FUNCTION_ARGS, plv8_exec_env *xenv, int nargs, plv8_type argtypes[], plv8_type *rettype) { Local context = xenv->localContext(); Context::Scope context_scope(context); Handle args[FUNC_MAX_ARGS]; Handle plv8obj; #if PG_VERSION_NUM >= 110000 bool nonatomic = fcinfo->context && IsA(fcinfo->context, CallContext) && !castNode(CallContext, fcinfo->context)->atomic; #else bool nonatomic = false; #endif WindowFunctionSupport support(context, fcinfo); /* * In window function case, we cannot see the argument datum * in fcinfo. Instead, get them by WinGetFuncArgCurrent(). */ if (support.IsWindowCall()) { WindowObject winobj = support.GetWindowObject(); for (int i = 0; i < nargs; i++) { bool isnull; Datum arg = WinGetFuncArgCurrent(winobj, i, &isnull); args[i] = ToValue(arg, isnull, &argtypes[i]); } } else { for (int i = 0; i < nargs; i++) { #if PG_VERSION_NUM < 120000 args[i] = ToValue(fcinfo->arg[i], fcinfo->argnull[i], &argtypes[i]); #else args[i] = ToValue(fcinfo->args[i].value, fcinfo->args[i].isnull, &argtypes[i]); #endif } } Local recv = Local::New(xenv->isolate, xenv->recv); Local fn = Local::Cast(recv->GetInternalField(0)); Local result = DoCall(context, fn, recv, nargs, args, nonatomic); if (rettype) return ToDatum(result, &fcinfo->isnull, rettype); else PG_RETURN_VOID(); } static Tuplestorestate * CreateTupleStore(PG_FUNCTION_ARGS, TupleDesc *tupdesc) { Tuplestorestate *tupstore; PG_TRY(); { ReturnSetInfo *rsinfo = (ReturnSetInfo *) fcinfo->resultinfo; MemoryContext per_query_ctx; MemoryContext oldcontext; plv8_proc *proc = (plv8_proc *) fcinfo->flinfo->fn_extra; /* check to see if caller supports us returning a tuplestore */ if (rsinfo == NULL || !IsA(rsinfo, ReturnSetInfo)) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg("set-valued function called in context that cannot accept a set"))); if (!(rsinfo->allowedModes & SFRM_Materialize)) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg("materialize mode required, but it is not " \ "allowed in this context"))); if (!proc->functypclass) proc->functypclass = get_call_result_type(fcinfo, NULL, NULL); per_query_ctx = rsinfo->econtext->ecxt_per_query_memory; oldcontext = MemoryContextSwitchTo(per_query_ctx); tupstore = tuplestore_begin_heap(true, false, work_mem); rsinfo->returnMode = SFRM_Materialize; rsinfo->setResult = tupstore; /* Build a tuple descriptor for our result type */ if (proc->rettype.typid == RECORDOID) { if (proc->functypclass != TYPEFUNC_COMPOSITE) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg("function returning record called in context " "that cannot accept type record"))); } if (!rsinfo->setDesc) { *tupdesc = CreateTupleDescCopy(rsinfo->expectedDesc); rsinfo->setDesc = *tupdesc; } else *tupdesc = rsinfo->setDesc; MemoryContextSwitchTo(oldcontext); } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); return tupstore; } static Datum CallSRFunction(PG_FUNCTION_ARGS, plv8_exec_env *xenv, int nargs, plv8_type argtypes[], plv8_type *rettype) { plv8_proc *proc = (plv8_proc *) fcinfo->flinfo->fn_extra; TupleDesc tupdesc; Tuplestorestate *tupstore; #if PG_VERSION_NUM >= 110000 bool nonatomic = fcinfo->context && IsA(fcinfo->context, CallContext) && !castNode(CallContext, fcinfo->context)->atomic; #else bool nonatomic = false; #endif tupstore = CreateTupleStore(fcinfo, &tupdesc); Handle context = xenv->localContext(); Context::Scope context_scope(context); Converter conv(tupdesc, proc->functypclass == TYPEFUNC_SCALAR); Handle args[FUNC_MAX_ARGS + 1]; /* * In case this is nested via SPI, stash pre-registered converters * for the previous SRF. */ SRFSupport support(context, &conv, tupstore); for (int i = 0; i < nargs; i++) { #if PG_VERSION_NUM < 120000 args[i] = ToValue(fcinfo->arg[i], fcinfo->argnull[i], &argtypes[i]); #else args[i] = ToValue(fcinfo->args[i].value, fcinfo->args[i].isnull, &argtypes[i]); #endif } Local recv = Local::New(xenv->isolate, xenv->recv); Local fn = Local::Cast(recv->GetInternalField(0)); Handle result = DoCall(context, fn, recv, nargs, args, nonatomic); if (result->IsUndefined()) { // no additional values } else if (result->IsArray()) { Handle array = Handle::Cast(result); // return an array of records. int length = array->Length(); for (int i = 0; i < length; i++) conv.ToDatum(array->Get(context, i).ToLocalChecked(), tupstore); } else { // return a record or a scalar conv.ToDatum(result, tupstore); } /* clean up and return the tuplestore */ tuplestore_donestoring(tupstore); return (Datum) 0; } static Datum CallTrigger(PG_FUNCTION_ARGS, plv8_exec_env *xenv) { // trigger arguments are: // 0: NEW // 1: OLD // 2: TG_NAME // 3: TG_WHEN // 4: TG_LEVEL // 5: TG_OP // 6: TG_RELID // 7: TG_TABLE_NAME // 8: TG_TABLE_SCHEMA // 9: TG_ARGV TriggerData *trig = (TriggerData *) fcinfo->context; Relation rel = trig->tg_relation; TriggerEvent event = trig->tg_event; Handle args[10]; Datum result = (Datum) 0; #if PG_VERSION_NUM >= 110000 bool nonatomic = fcinfo->context && IsA(fcinfo->context, CallContext) && !castNode(CallContext, fcinfo->context)->atomic; #else bool nonatomic = false; #endif Handle context = xenv->localContext(); Context::Scope context_scope(context); if (TRIGGER_FIRED_FOR_ROW(event)) { TupleDesc tupdesc = RelationGetDescr(rel); Converter conv(tupdesc); if (TRIGGER_FIRED_BY_INSERT(event)) { result = PointerGetDatum(trig->tg_trigtuple); // NEW args[0] = conv.ToValue(trig->tg_trigtuple); // OLD args[1] = Undefined(xenv->isolate); } else if (TRIGGER_FIRED_BY_DELETE(event)) { result = PointerGetDatum(trig->tg_trigtuple); // NEW args[0] = Undefined(xenv->isolate); // OLD args[1] = conv.ToValue(trig->tg_trigtuple); } else if (TRIGGER_FIRED_BY_UPDATE(event)) { result = PointerGetDatum(trig->tg_newtuple); // NEW args[0] = conv.ToValue(trig->tg_newtuple); // OLD args[1] = conv.ToValue(trig->tg_trigtuple); } } else { args[0] = args[1] = Undefined(xenv->isolate); } // 2: TG_NAME args[2] = ToString(trig->tg_trigger->tgname); // 3: TG_WHEN if (TRIGGER_FIRED_BEFORE(event)) args[3] = v8::String::NewFromUtf8Literal(xenv->isolate, "BEFORE"); else args[3] = v8::String::NewFromUtf8Literal(xenv->isolate, "AFTER"); // 4: TG_LEVEL if (TRIGGER_FIRED_FOR_ROW(event)) args[4] = v8::String::NewFromUtf8Literal(xenv->isolate, "ROW"); else args[4] = v8::String::NewFromUtf8Literal(xenv->isolate, "STATEMENT"); // 5: TG_OP if (TRIGGER_FIRED_BY_INSERT(event)) args[5] = v8::String::NewFromUtf8Literal(xenv->isolate, "INSERT"); else if (TRIGGER_FIRED_BY_DELETE(event)) args[5] = v8::String::NewFromUtf8Literal(xenv->isolate, "DELETE"); else if (TRIGGER_FIRED_BY_UPDATE(event)) args[5] = v8::String::NewFromUtf8Literal(xenv->isolate, "UPDATE"); #ifdef TRIGGER_FIRED_BY_TRUNCATE else if (TRIGGER_FIRED_BY_TRUNCATE(event)) args[5] = v8::String::NewFromUtf8Literal(xenv->isolate, "TRUNCATE"); #endif else args[5] = v8::String::NewFromUtf8Literal(xenv->isolate, "?"); // 6: TG_RELID args[6] = Uint32::New(xenv->isolate, RelationGetRelid(rel)); // 7: TG_TABLE_NAME args[7] = ToString(RelationGetRelationName(rel)); // 8: TG_TABLE_SCHEMA args[8] = ToString(get_namespace_name(RelationGetNamespace(rel))); // 9: TG_ARGV Handle tgargs = Array::New(xenv->isolate, trig->tg_trigger->tgnargs); for (int i = 0; i < trig->tg_trigger->tgnargs; i++) tgargs->Set(context, i, ToString(trig->tg_trigger->tgargs[i])).Check(); args[9] = tgargs; TryCatch try_catch(xenv->isolate); Local recv = Local::New(xenv->isolate, xenv->recv); Local fn = Local::Cast(recv->GetInternalField(0)); Handle newtup = DoCall(context, fn, recv, lengthof(args), args, nonatomic); if (newtup.IsEmpty()) throw js_error(try_catch); /* * If the function specifically returned null, return NULL to * tell executor to skip the operation. Otherwise, the function * result is the tuple to be returned. */ if (newtup->IsNull() || !TRIGGER_FIRED_FOR_ROW(event)) { result = PointerGetDatum(NULL); } else if (!newtup->IsUndefined()) { TupleDesc tupdesc = RelationGetDescr(rel); Converter conv(tupdesc); HeapTupleHeader header; header = DatumGetHeapTupleHeader(conv.ToDatum(newtup)); /* We know it's there; heap_form_tuple stores with this layout. */ result = PointerGetDatum((char *) header - HEAPTUPLESIZE); } return result; } static Datum common_pl_call_validator(PG_FUNCTION_ARGS, Dialect dialect) throw() { current_context = GetPlv8Context(); Oid fn_oid = PG_GETARG_OID(0); HeapTuple tuple; Form_pg_proc proc; char functyptype; bool is_trigger = false; Isolate::Scope scope(current_context->isolate); if (!CheckFunctionValidatorAccess(fcinfo->flinfo->fn_oid, fn_oid)) PG_RETURN_VOID(); /* Get the new function's pg_proc entry */ tuple = SearchSysCache(PROCOID, ObjectIdGetDatum(fn_oid), 0, 0, 0); if (!HeapTupleIsValid(tuple)) elog(ERROR, "cache lookup failed for function %u", fn_oid); proc = (Form_pg_proc) GETSTRUCT(tuple); functyptype = get_typtype(proc->prorettype); /* Disallow pseudotype result */ /* except for TRIGGER, RECORD, INTERNAL, VOID or polymorphic types */ if (functyptype == TYPTYPE_PSEUDO) { #if PG_VERSION_NUM >= 130000 if (proc->prorettype == TRIGGEROID) #else /* we assume OPAQUE with no arguments means a trigger */ if (proc->prorettype == TRIGGEROID || (proc->prorettype == OPAQUEOID && proc->pronargs == 0)) #endif is_trigger = true; else if (proc->prorettype != RECORDOID && proc->prorettype != VOIDOID && proc->prorettype != INTERNALOID && !IsPolymorphicType(proc->prorettype)) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg("PL/v8 functions cannot return type %s", format_type_be(proc->prorettype)))); } ReleaseSysCache(tuple); try { #ifdef ENABLE_DEBUGGER_SUPPORT Locker lock; #endif // ENABLE_DEBUGGER_SUPPORT /* Don't use validator's fcinfo */ plv8_proc *proc = Compile(fn_oid, NULL, true, is_trigger, dialect); (void) CreateExecEnv(proc->cache->function, current_context); /* the result of a validator is ignored */ PG_RETURN_VOID(); } catch (js_error& e) { e.rethrow(); } catch (pg_error& e) { e.rethrow(); } return (Datum) 0; // keep compiler quiet } Datum plv8_call_validator(PG_FUNCTION_ARGS) { return common_pl_call_validator(fcinfo, PLV8_DIALECT_NONE); } Datum plcoffee_call_validator(PG_FUNCTION_ARGS) { return common_pl_call_validator(fcinfo, PLV8_DIALECT_COFFEE); } Datum plls_call_validator(PG_FUNCTION_ARGS) { return common_pl_call_validator(fcinfo, PLV8_DIALECT_LIVESCRIPT); } static plv8_proc * plv8_get_proc(Oid fn_oid, FunctionCallInfo fcinfo, bool validate, char ***argnames) throw() { HeapTuple procTup; plv8_proc_cache *cache; bool found; bool isnull; Datum prosrc; Oid *argtypes; char *argmodes; MemoryContext oldcontext; procTup = SearchSysCache(PROCOID, ObjectIdGetDatum(fn_oid), 0, 0, 0); if (!HeapTupleIsValid(procTup)) elog(ERROR, "cache lookup failed for function %u", fn_oid); cache = (plv8_proc_cache *) hash_search(plv8_proc_cache_hash,&fn_oid, HASH_ENTER, &found); if (found) { bool uptodate; /* * We need to check user id and dispose it if it's different from * the previous cache user id, as the V8 function is associated * with the context where it was generated. In most cases, * we can expect this doesn't affect runtime performance. */ uptodate = (!cache->function.IsEmpty() && cache->fn_xmin == HeapTupleHeaderGetXmin(procTup->t_data) && ItemPointerEquals(&cache->fn_tid, &procTup->t_self) && cache->user_id == GetUserId()); if (!uptodate) { if (cache->prosrc) { pfree(cache->prosrc); cache->prosrc = NULL; } cache->function.Reset(); } else { ReleaseSysCache(procTup); } } else { new(&cache->function) Persistent(); cache->prosrc = NULL; } if (cache->function.IsEmpty()) { Form_pg_proc procStruct; procStruct = (Form_pg_proc) GETSTRUCT(procTup); prosrc = SysCacheGetAttr(PROCOID, procTup, Anum_pg_proc_prosrc, &isnull); if (isnull) elog(ERROR, "null prosrc"); cache->retset = procStruct->proretset; cache->rettype = procStruct->prorettype; strlcpy(cache->proname, NameStr(procStruct->proname), NAMEDATALEN); cache->fn_xmin = HeapTupleHeaderGetXmin(procTup->t_data); cache->fn_tid = procTup->t_self; cache->user_id = GetUserId(); int nargs = get_func_arg_info(procTup, &argtypes, argnames, &argmodes); if (validate) { /* * Disallow non-polymorphic pseudotypes in arguments * (either IN or OUT). Internal type is used to declare * js functions for find_function(). */ for (int i = 0; i < nargs; i++) { if (get_typtype(argtypes[i]) == TYPTYPE_PSEUDO && argtypes[i] != INTERNALOID && !IsPolymorphicType(argtypes[i])) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg("PL/v8 functions cannot accept type %s", format_type_be(argtypes[i])))); } } oldcontext = MemoryContextSwitchTo(TopMemoryContext); cache->prosrc = TextDatumGetCString(prosrc); MemoryContextSwitchTo(oldcontext); ReleaseSysCache(procTup); int inargs = 0; for (int i = 0; i < nargs; i++) { Oid argtype = argtypes[i]; char argmode = argmodes ? argmodes[i] : PROARGMODE_IN; switch (argmode) { case PROARGMODE_IN: case PROARGMODE_INOUT: case PROARGMODE_VARIADIC: break; default: continue; } if (*argnames) (*argnames)[inargs] = (*argnames)[i]; cache->argtypes[inargs] = argtype; inargs++; } cache->nargs = inargs; } MemoryContext mcxt = CurrentMemoryContext; if (fcinfo) mcxt = fcinfo->flinfo->fn_mcxt; plv8_proc *proc = (plv8_proc *) MemoryContextAllocZero(mcxt, offsetof(plv8_proc, argtypes) + sizeof(plv8_type) * cache->nargs); proc->cache = cache; for (int i = 0; i < cache->nargs; i++) { Oid argtype = cache->argtypes[i]; /* Resolve polymorphic types, if this is an actual call context. */ if (fcinfo && IsPolymorphicType(argtype)) argtype = get_fn_expr_argtype(fcinfo->flinfo, i); plv8_fill_type(&proc->argtypes[i], argtype, mcxt); } Oid rettype = cache->rettype; /* Resolve polymorphic return type if this is an actual call context. */ if (fcinfo && IsPolymorphicType(rettype)) rettype = get_fn_expr_rettype(fcinfo->flinfo); plv8_fill_type(&proc->rettype, rettype, mcxt); return proc; } static plv8_exec_env * CreateExecEnv(Persistent& function, plv8_context *context) { plv8_exec_env *xenv; HandleScope handle_scope(context->isolate); PG_TRY(); { xenv = plv8_new_exec_env(context->isolate); } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); xenv->context.Reset(context->isolate, context->context); Local ctx = xenv->localContext(); Context::Scope scope(ctx); Local templ = Local::New(context->isolate, context->recv_templ); Local obj = templ->NewInstance(ctx).ToLocalChecked(); Local f = Local::New(context->isolate, function); obj->SetInternalField(0, f); xenv->recv.Reset(context->isolate, obj); return xenv; } static plv8_exec_env * CreateExecEnv(Handle function, plv8_context *context) { Isolate::Scope iscope(context->isolate); plv8_exec_env *xenv; HandleScope handle_scope(context->isolate); PG_TRY(); { xenv = plv8_new_exec_env(context->isolate); } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); xenv->context.Reset(context->isolate, context->context); Local ctx = xenv->localContext(); Context::Scope scope(ctx); Local templ = Local::New(context->isolate, context->recv_templ); Local obj = templ->NewInstance(ctx).ToLocalChecked(); Local f = Local::New(context->isolate, function); obj->SetInternalField(0, f); xenv->recv.Reset(context->isolate, obj); return xenv; } /* Source transformation from a dialect (coffee or ls) to js */ static char * CompileDialect(const char *src, Dialect dialect, plv8_context *global_context) { Isolate *isolate = Isolate::GetCurrent(); HandleScope handle_scope(isolate); Local ctx = Local::New(isolate, global_context->compile_context); Context::Scope context_scope(ctx); TryCatch try_catch(isolate); Local key; char *cresult; const char *dialect_binary_data; if (isolate->IsExecutionTerminating() || current_context->interrupted) { isolate->CancelTerminateExecution(); if (current_context->interrupted) { current_context->interrupted = false; } } switch (dialect) { case PLV8_DIALECT_COFFEE: if (coffee_script_binary_data[0] == '\0') throw js_error("CoffeeScript is not enabled"); key = v8::String::NewFromUtf8Literal(isolate, "CoffeeScript", NewStringType::kInternalized); dialect_binary_data = (const char *) coffee_script_binary_data; break; case PLV8_DIALECT_LIVESCRIPT: if (livescript_binary_data[0] == '\0') throw js_error("LiveScript is not enabled"); key = v8::String::NewFromUtf8Literal(isolate, "LiveScript", NewStringType::kInternalized); dialect_binary_data = (const char *) livescript_binary_data; break; default: throw js_error("Unknown Dialect"); } if (ctx->Global()->Get(ctx, key).ToLocalChecked()->IsUndefined()) { HandleScope handle_scope(isolate); v8::ScriptOrigin origin(key); v8::Local script; if (!Script::Compile(isolate->GetCurrentContext(), ToString(dialect_binary_data), &origin).ToLocal(&script)) throw js_error(try_catch); if (script.IsEmpty()) throw js_error(try_catch); v8::Local result; if (!script->Run(isolate->GetCurrentContext()).ToLocal(&result)) throw js_error(try_catch); HandleUnhandledPromiseRejections(); if (result.IsEmpty()) { if (isolate->IsExecutionTerminating()) throw js_error("Script is out of memory"); throw js_error(try_catch); } } Local compiler = Local::Cast(ctx->Global()->Get(ctx, key).ToLocalChecked()); Local func = Local::Cast( compiler->Get(ctx, v8::String::NewFromUtf8Literal(isolate, "compile", NewStringType::kInternalized)).ToLocalChecked()); const int nargs = 1; Handle args[nargs]; args[0] = ToString(src); MaybeLocal value = func->Call(ctx, compiler, nargs, args); HandleUnhandledPromiseRejections(); if (value.IsEmpty()) { if (isolate->IsExecutionTerminating()) throw js_error("Out of memory error"); throw js_error(try_catch); } CString result(value.ToLocalChecked()); PG_TRY(); { MemoryContext oldcontext = MemoryContextSwitchTo(TopMemoryContext); cresult = pstrdup(result.str()); MemoryContextSwitchTo(oldcontext); } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); return cresult; } /* * fcinfo should be passed if this is an actual function call context, where * we can resolve polymorphic types and use function's memory context. */ static plv8_proc * Compile(Oid fn_oid, FunctionCallInfo fcinfo, bool validate, bool is_trigger, Dialect dialect) { plv8_proc *proc; char **argnames; PG_TRY(); { proc = plv8_get_proc(fn_oid, fcinfo, validate, &argnames); } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); plv8_proc_cache *cache = proc->cache; if (cache->function.IsEmpty()) { /* * We need to create global context before entering CompileFunction * because GetPlv8Context could call startup procedure, which * could be this cache->function itself. In this scenario, * Compile is called recursively and plv8_get_proc tries to refresh * cache because cache->function is still not yet ready at this * point. Then some pointers of cache will become stale by pfree * and CompileFunction ends up compiling freed function source. */ current_context = GetPlv8Context(); Isolate::Scope scope(current_context->isolate); HandleScope handle_scope(current_context->isolate); Persistent global_context; global_context.Reset(current_context->isolate, current_context->context); cache->function.Reset(current_context->isolate, CompileFunction( current_context, cache->proname, cache->nargs, (const char **) argnames, cache->prosrc, is_trigger, cache->retset, dialect)); } return proc; } static Local CompileFunction( plv8_context *global_context, const char *proname, int proarglen, const char *proargs[], const char *prosrc, bool is_trigger, bool retset, Dialect dialect) { Isolate *isolate = Isolate::GetCurrent(); EscapableHandleScope handle_scope(isolate); StringInfoData src; initStringInfo(&src); if (dialect != PLV8_DIALECT_NONE) prosrc = CompileDialect(prosrc, dialect, global_context); /* * (function (){ * * }) */ appendStringInfo(&src, "(function ("); if (is_trigger) { if (proarglen != 0) throw js_error("trigger function cannot have arguments"); // trigger function has special arguments. appendStringInfo(&src, "NEW, OLD, TG_NAME, TG_WHEN, TG_LEVEL, TG_OP, " "TG_RELID, TG_TABLE_NAME, TG_TABLE_SCHEMA, TG_ARGV"); } else { for (int i = 0; i < proarglen; i++) { if (i > 0) appendStringInfoChar(&src, ','); if (proargs && proargs[i]) appendStringInfoString(&src, proargs[i]); else appendStringInfo(&src, "$%d", i + 1); // unnamed argument to $N } } if (dialect) appendStringInfo(&src, "){\nreturn %s\n})", prosrc); else appendStringInfo(&src, "){\n%s\n})", prosrc); Handle name; if (proname) name = ToString(proname); else name = Undefined(isolate); Local source = ToString(src.data, src.len); pfree(src.data); Local context = Local::New(isolate, global_context->context); Context::Scope context_scope(context); TryCatch try_catch(isolate); v8::ScriptOrigin origin(name); // set up the signal handlers if (int_handler == NULL) { int_handler = (void *) signal(SIGINT, signal_handler); } if (term_handler == NULL) { term_handler = (void *) signal(SIGTERM, signal_handler); } #ifdef EXECUTION_TIMEOUT bool timeout = false; #ifdef _MSC_VER // windows HANDLE hThread; DWORD dwThreadId; hThread = CreateThread(NULL, 0, Breakout, isolate, 0, &dwThreadId); #else pthread_t breakout_thread; // set up the thread to break out the execution if needed pthread_create(&breakout_thread, NULL, Breakout, isolate); #endif #endif v8::Local script; v8::Local result; if (current_context->interrupted) { isolate->CancelTerminateExecution(); current_context->interrupted = false; } if (Script::Compile(isolate->GetCurrentContext(), source, &origin).ToLocal(&script)) { if (!script.IsEmpty()) { if (!script->Run(isolate->GetCurrentContext()).ToLocal(&result)) throw js_error(try_catch); } } #ifdef EXECUTION_TIMEOUT #ifdef _MSC_VER if (TerminateThread(hThread, NULL) == 0) { timeout = true; } #else void *thread_result; pthread_cancel(breakout_thread); pthread_join(breakout_thread, &thread_result); if (thread_result == NULL) { timeout = true; } #endif #endif signal(SIGINT, (void (*)(int)) int_handler); signal(SIGTERM, (void (*)(int)) term_handler); HandleUnhandledPromiseRejections(); if (result.IsEmpty()) { if (isolate->IsExecutionTerminating() || current_context->interrupted) { isolate->CancelTerminateExecution(); if (current_context->interrupted) { current_context->interrupted = false; throw js_error("Signal caught: interrupted"); } #ifdef EXECUTION_TIMEOUT if (timeout) { throw js_error("compiler timeout exceeded"); } #endif throw js_error("Script is out of memory"); } throw js_error(try_catch); } return handle_scope.Escape(Local::Cast(result)); } Local find_js_function(Oid fn_oid) { HeapTuple tuple; Form_pg_proc proc; Oid prolang; NameData langnames[] = { {"plv8"}, {"plcoffee"}, {"plls"} }; int langno; int langlen = sizeof(langnames) / sizeof(NameData); Local func; Isolate *isolate = Isolate::GetCurrent(); tuple = SearchSysCache(PROCOID, ObjectIdGetDatum(fn_oid), 0, 0, 0); if (!HeapTupleIsValid(tuple)) elog(ERROR, "cache lookup failed for function %u", fn_oid); proc = (Form_pg_proc) GETSTRUCT(tuple); prolang = proc->prolang; ReleaseSysCache(tuple); /* Should not happen? */ if (!OidIsValid(prolang)) return func; /* See if the function language is a compatible one */ for (langno = 0; langno < langlen; langno++) { tuple = SearchSysCache(LANGNAME, NameGetDatum(&langnames[langno]), 0, 0, 0); if (HeapTupleIsValid(tuple)) { #if PG_VERSION_NUM < 120000 Oid langtupoid = HeapTupleGetOid(tuple); #else Form_pg_database datForm = (Form_pg_database) GETSTRUCT(tuple); Oid langtupoid = datForm->oid; #endif ReleaseSysCache(tuple); if (langtupoid == prolang) break; } } /* Not found or non-JS function */ if (langno >= langlen) return func; try { plv8_proc *proc = Compile(fn_oid, NULL, true, false, (Dialect) (PLV8_DIALECT_NONE + langno)); TryCatch try_catch(isolate); func = Local::New(isolate, proc->cache->function); } catch (js_error& e) { e.rethrow(); } catch (pg_error& e) { e.rethrow(); } return func; } /* * NOTICE: the returned buffer could be an internal static buffer. */ const char * FormatSPIStatus(int status) throw() { static char private_buf[1024]; if (status > 0) return "OK"; switch (status) { case SPI_ERROR_CONNECT: return "SPI_ERROR_CONNECT"; case SPI_ERROR_COPY: return "SPI_ERROR_COPY"; case SPI_ERROR_OPUNKNOWN: return "SPI_ERROR_OPUNKNOWN"; case SPI_ERROR_UNCONNECTED: case SPI_ERROR_TRANSACTION: return "current transaction is aborted, " "commands ignored until end of transaction block"; case SPI_ERROR_CURSOR: return "SPI_ERROR_CURSOR"; case SPI_ERROR_ARGUMENT: return "SPI_ERROR_ARGUMENT"; case SPI_ERROR_PARAM: return "SPI_ERROR_PARAM"; case SPI_ERROR_NOATTRIBUTE: return "SPI_ERROR_NOATTRIBUTE"; case SPI_ERROR_NOOUTFUNC: return "SPI_ERROR_NOOUTFUNC"; case SPI_ERROR_TYPUNKNOWN: return "SPI_ERROR_TYPUNKNOWN"; default: snprintf(private_buf, sizeof(private_buf), "SPI_ERROR: %d", status); return private_buf; } } static text * charToText(char *string) { int len = strlen(string); text *result = (text *) palloc(len + 1 + VARHDRSZ); SET_VARSIZE(result, len + VARHDRSZ); memcpy(VARDATA(result), string, len + 1); return result; } static plv8_context* GetPlv8Context() { Oid user_id = GetUserId(); unsigned int i; plv8_context *my_context = nullptr; for (i = 0; i < ContextVector.size(); i++) { if (ContextVector[i]->user_id == user_id) { my_context = ContextVector[i]; break; } } if (my_context && (my_context->is_dead || (my_context->isolate && my_context->isolate->IsDead()))) { // the isolate is dead because of OOM, kill it and dispose char *username = GetUserNameFromId(my_context->user_id, false); elog(LOG_SERVER_ONLY, "Disposing of a dead isolate for: %s", username); ContextVector.erase(ContextVector.begin() + i); if (my_context->isolate && my_context->isolate->IsInUse()) { my_context->isolate->Exit(); } killPlv8Context(my_context); pfree(my_context); my_context = nullptr; } if (!my_context) { my_context = (plv8_context *) MemoryContextAllocZero(TopMemoryContext, sizeof(plv8_context)); my_context->is_dead = false; my_context->interrupted = false; my_context->ignore_unhandled_promises = false; CreateIsolate(my_context); Isolate *isolate = my_context->isolate; Isolate::Scope scope(isolate); HandleScope handle_scope(isolate); Local global = Local::New(isolate, GetGlobalObjectTemplate(isolate)); new(&my_context->context) Persistent(); my_context->context.Reset(isolate, Context::New(isolate, NULL, global)); my_context->user_id = user_id; new(&my_context->recv_templ) Persistent(); Local templ = ObjectTemplate::New(isolate); templ->SetInternalFieldCount(1); my_context->recv_templ.Reset(isolate, templ); new(&my_context->compile_context) Persistent(); Local ctx = Context::New(isolate, (ExtensionConfiguration*)NULL); my_context->compile_context.Reset(isolate, ctx); auto toStringAttr = static_cast(v8::ReadOnly | v8::DontEnum); auto toStringSymbol = v8::Symbol::GetToStringTag(isolate); new(&my_context->plan_template) Persistent(); Local base = FunctionTemplate::New(isolate); Local planClassName = v8::String::NewFromUtf8Literal(isolate, "PreparedPlan", NewStringType::kInternalized); base->SetClassName(planClassName); base->PrototypeTemplate()->Set(toStringSymbol, planClassName, toStringAttr); templ = base->InstanceTemplate(); SetupPrepFunctions(templ); my_context->plan_template.Reset(isolate, templ); new(&my_context->cursor_template) Persistent(); base = FunctionTemplate::New(isolate); Local cursorClassName = v8::String::NewFromUtf8Literal(isolate, "Cursor", NewStringType::kInternalized); base->SetClassName(cursorClassName); base->PrototypeTemplate()->Set(toStringSymbol, cursorClassName, toStringAttr); templ = base->InstanceTemplate(); SetupCursorFunctions(templ); my_context->cursor_template.Reset(isolate, templ); new(&my_context->window_template) Persistent(); base = FunctionTemplate::New(isolate); Local windowClassName = v8::String::NewFromUtf8Literal(isolate, "WindowObject", NewStringType::kInternalized); base->SetClassName(windowClassName); base->PrototypeTemplate()->Set(toStringSymbol, windowClassName, toStringAttr); templ = base->InstanceTemplate(); SetupWindowFunctions(templ); my_context->window_template.Reset(isolate, templ); /* * Need to register it before running any code, as the code * recursively may want to the global context. */ ContextVector.push_back(my_context); /* * Run the start up procedure if configured. */ if (plv8_start_proc != NULL) { Local func; HandleScope handle_scope(isolate); Local context = my_context->localContext(); Context::Scope context_scope(context); TryCatch try_catch(isolate); MemoryContext ctx = CurrentMemoryContext; text *arg; #if PG_VERSION_NUM < 120000 FunctionCallInfoData fake_fcinfo; #else // Stack-allocate FunctionCallInfoBaseData with // space for 2 arguments: LOCAL_FCINFO(fake_fcinfo, 2); #endif FmgrInfo flinfo; char perm[16]; strcpy(perm, "EXECUTE"); arg = charToText(perm); PG_TRY(); { Oid funcoid = DatumGetObjectId(DirectFunctionCall1(regprocin, CStringGetDatum(plv8_start_proc))); #if PG_VERSION_NUM < 120000 MemSet(&fake_fcinfo, 0, sizeof(fake_fcinfo)); MemSet(&flinfo, 0, sizeof(flinfo)); fake_fcinfo.flinfo = &flinfo; flinfo.fn_oid = InvalidOid; flinfo.fn_mcxt = CurrentMemoryContext; fake_fcinfo.nargs = 2; fake_fcinfo.arg[0] = ObjectIdGetDatum(funcoid); fake_fcinfo.arg[1] = CStringGetDatum(arg); Datum ret = has_function_privilege_id(&fake_fcinfo); #else MemSet(&flinfo, 0, sizeof(flinfo)); fake_fcinfo->flinfo = &flinfo; flinfo.fn_oid = InvalidOid; flinfo.fn_mcxt = CurrentMemoryContext; fake_fcinfo->nargs = 2; fake_fcinfo->args[0].value = ObjectIdGetDatum(funcoid); fake_fcinfo->args[1].value = CStringGetDatum(arg); Datum ret = has_function_privilege_id(fake_fcinfo); #endif if (ret == 0) { elog(WARNING, "failed to find js function %s", plv8_start_proc); } else { if (DatumGetBool(ret)) { func = find_js_function(funcoid); } else { elog(WARNING, "no permission to execute js function %s", plv8_start_proc); } } } PG_CATCH(); { ErrorData *edata; MemoryContextSwitchTo(ctx); edata = CopyErrorData(); elog(WARNING, "failed to find js function %s", edata->message); FlushErrorState(); FreeErrorData(edata); } PG_END_TRY(); pfree(arg); if (!func.IsEmpty()) { Handle result = DoCall(context, func, my_context->localContext()->Global(), 0, NULL, false); if (result.IsEmpty()) throw js_error(try_catch); } } #ifdef ENABLE_DEBUGGER_SUPPORT debug_message_context = v8::Persistent::New(global_context); v8::Locker locker; v8::Debug::SetDebugMessageDispatchHandler(DispatchDebugMessages, true); v8::Debug::EnableAgent("plv8", plv8_debugger_port, false); #endif // ENABLE_DEBUGGER_SUPPORT } return my_context; } static Local GetGlobalObjectTemplate(Isolate *isolate) { Persistent global; if (global.IsEmpty()) { HandleScope handle_scope(isolate); Local templ = ObjectTemplate::New(isolate); // ERROR levels for elog templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG5", NewStringType::kInternalized), Int32::New(isolate, DEBUG5)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG4", NewStringType::kInternalized), Int32::New(isolate, DEBUG4)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG3", NewStringType::kInternalized), Int32::New(isolate, DEBUG3)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG2", NewStringType::kInternalized), Int32::New(isolate, DEBUG2)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG1", NewStringType::kInternalized), Int32::New(isolate, DEBUG1)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "DEBUG", NewStringType::kInternalized), Int32::New(isolate, DEBUG5)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "LOG", NewStringType::kInternalized), Int32::New(isolate, LOG)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "INFO", NewStringType::kInternalized), Int32::New(isolate, INFO)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "NOTICE", NewStringType::kInternalized), Int32::New(isolate, NOTICE)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "WARNING", NewStringType::kInternalized), Int32::New(isolate, WARNING)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "ERROR", NewStringType::kInternalized), Int32::New(isolate, ERROR)); global.Reset(isolate, templ); Local plv8 = ObjectTemplate::New(isolate); SetupPlv8Functions(plv8); plv8->Set(v8::String::NewFromUtf8Literal(isolate, "version", NewStringType::kInternalized), v8::String::NewFromUtf8Literal(isolate, PLV8_VERSION)); plv8->Set(v8::String::NewFromUtf8Literal(isolate, "v8_version", NewStringType::kInternalized), v8::String::NewFromUtf8Literal(isolate, V8_VERSION_STRING)); templ->Set(v8::String::NewFromUtf8Literal(isolate, "plv8", NewStringType::kInternalized), plv8); } return Local::New(isolate, global); } /* * Accessor to plv8_type stored in fcinfo. */ plv8_type * get_plv8_type(PG_FUNCTION_ARGS, int argno) { plv8_proc *proc = (plv8_proc *) fcinfo->flinfo->fn_extra; return &proc->argtypes[argno]; } Converter::Converter(TupleDesc tupdesc) : m_tupdesc(tupdesc), m_colnames(tupdesc->natts), m_coltypes(tupdesc->natts), m_is_scalar(false), m_memcontext(NULL) { Init(); } Converter::Converter(TupleDesc tupdesc, bool is_scalar) : m_tupdesc(tupdesc), m_colnames(tupdesc->natts), m_coltypes(tupdesc->natts), m_is_scalar(is_scalar), m_memcontext(NULL) { Init(); } Converter::~Converter() { if (m_memcontext != NULL) { MemoryContext ctx = CurrentMemoryContext; PG_TRY(); { MemoryContextDelete(m_memcontext); } PG_CATCH(); { ErrorData *edata; MemoryContextSwitchTo(ctx); // don't throw out from deconstructor edata = CopyErrorData(); elog(WARNING, "~Converter: %s", edata->message); FlushErrorState(); FreeErrorData(edata); } PG_END_TRY(); m_memcontext = NULL; } } void Converter::Init() { for (int c = 0; c < m_tupdesc->natts; c++) { if (TupleDescAttr(m_tupdesc, c)->attisdropped) continue; m_colnames[c] = ToString(NameStr(TupleDescAttr(m_tupdesc, c)->attname)); PG_TRY(); { if (m_memcontext == NULL) #if PG_VERSION_NUM < 110000 m_memcontext = AllocSetContextCreate( CurrentMemoryContext, "ConverterContext", ALLOCSET_SMALL_MINSIZE, ALLOCSET_SMALL_INITSIZE, ALLOCSET_SMALL_MAXSIZE); plv8_fill_type(&m_coltypes[c], m_tupdesc->attrs[c]->atttypid, m_memcontext); #else m_memcontext = AllocSetContextCreate( CurrentMemoryContext, "ConverterContext", ALLOCSET_DEFAULT_SIZES); plv8_fill_type(&m_coltypes[c], m_tupdesc->attrs[c].atttypid, m_memcontext); #endif } PG_CATCH(); { throw pg_error(); } PG_END_TRY(); } } // TODO: use prototype instead of per tuple fields to reduce // memory consumption. Local Converter::ToValue(HeapTuple tuple) { Isolate *isolate = Isolate::GetCurrent(); Local context = isolate->GetCurrentContext(); Local obj = Object::New(isolate); for (int c = 0; c < m_tupdesc->natts; c++) { Datum datum; bool isnull; if (TupleDescAttr(m_tupdesc, c)->attisdropped) continue; #if PG_VERSION_NUM >= 90000 datum = heap_getattr(tuple, c + 1, m_tupdesc, &isnull); #else /* * Due to the difference between C and C++ rules, * we cannot call heap_getattr from < 9.0 unfortunately. */ datum = nocachegetattr(tuple, c + 1, m_tupdesc, &isnull); #endif obj->Set(context, m_colnames[c], ::ToValue(datum, isnull, &m_coltypes[c])).Check(); } return obj; } Datum Converter::ToDatum(Handle value, Tuplestorestate *tupstore) { Isolate *isolate = Isolate::GetCurrent(); Local context = isolate->GetCurrentContext(); Datum result; TryCatch try_catch(isolate); Handle obj; if (!m_is_scalar) { if (!value->IsObject()) throw js_error("argument must be an object"); obj = Handle::Cast(value); if (obj.IsEmpty()) throw js_error(try_catch); } /* * Use vector instead of vector because version is * s specialized and different from bool[]. */ Datum *values = (Datum *) palloc(sizeof(Datum) * m_tupdesc->natts); bool *nulls = (bool *) palloc(sizeof(bool) * m_tupdesc->natts); if (!m_is_scalar) { Handle names = obj->GetPropertyNames(isolate->GetCurrentContext()).ToLocalChecked(); for (int c = 0; c < m_tupdesc->natts; c++) { if (TupleDescAttr(m_tupdesc, c)->attisdropped) continue; bool found = false; CString colname(m_colnames[c]); for (int d = 0; d < m_tupdesc->natts; d++) { CString fname(names->Get(context, d).ToLocalChecked()); if (strcmp(colname, fname) == 0) { found = true; break; } } if (!found) throw js_error("field name / property name mismatch"); } } for (int c = 0; c < m_tupdesc->natts; c++) { /* Make sure dropped columns are skipped by backend code. */ #if PG_VERSION_NUM < 110000 if (m_tupdesc->attrs[c]->attisdropped) #else if (m_tupdesc->attrs[c].attisdropped) #endif { nulls[c] = true; continue; } Handle attr = m_is_scalar ? value : obj->Get(context, m_colnames[c]).ToLocalChecked(); if (attr.IsEmpty() || attr->IsUndefined() || attr->IsNull()) nulls[c] = true; else values[c] = ::ToDatum(attr, &nulls[c], &m_coltypes[c]); } if (tupstore) { tuplestore_putvalues(tupstore, m_tupdesc, values, nulls); result = (Datum) 0; } else { result = HeapTupleGetDatum(heap_form_tuple(m_tupdesc, values, nulls)); } pfree(values); pfree(nulls); return result; } js_error::js_error() noexcept : m_msg(nullptr), m_code(0), m_detail(nullptr), m_hint(nullptr), m_context(nullptr) { } js_error::js_error(const char *msg) noexcept : js_error() { m_msg = pstrdup(msg); } js_error::js_error(Isolate *isolate, v8::Local exception, v8::Local message) noexcept : js_error() { init(isolate, exception, message); } js_error::js_error(v8::TryCatch &try_catch) noexcept : js_error() { Isolate *isolate = Isolate::GetCurrent(); HandleScope handle_scope(isolate); init(isolate, try_catch.Exception(), try_catch.Message()); } void js_error::init(Isolate *isolate, v8::Local exception, v8::Local message) noexcept { HandleScope handle_scope(isolate); v8::String::Utf8Value err_message(isolate, exception); Local context = isolate->GetCurrentContext(); try { m_msg = ToCStringCopy(err_message); StringInfoData detailStr; StringInfoData hintStr; StringInfoData contextStr; initStringInfo(&detailStr); initStringInfo(&hintStr); initStringInfo(&contextStr); Handle err; if (exception->ToObject(context).ToLocal(&err)) { if (!err.IsEmpty()) { v8::Local errCode; if (err->Get(context, v8::String::NewFromUtf8Literal(isolate, "code")).ToLocal(&errCode)) { if (!errCode->IsUndefined() && !errCode->IsNull()) { int32_t code = errCode->Int32Value(context).FromJust(); m_code = code; } } v8::Local errDetail; if (err->Get(context, v8::String::NewFromUtf8Literal(isolate, "detail")).ToLocal(&errDetail)) { if (!errDetail->IsUndefined() && !errDetail->IsNull()) { CString detail(errDetail); appendStringInfo(&detailStr, "%s", detail.str("?")); m_detail = detailStr.data; } } v8::Local errHint; if (err->Get(context, v8::String::NewFromUtf8Literal(isolate, "hint")).ToLocal(&errHint)) { if (!errHint->IsUndefined() && !errHint->IsNull()) { CString hint(errHint); appendStringInfo(&hintStr, "%s", hint.str("?")); m_hint = hintStr.data; } } v8::Local errContext; if (err->Get(context, v8::String::NewFromUtf8Literal(isolate, "context")).ToLocal(&errContext)) if (!errContext->IsUndefined() && !errContext->IsNull()) { CString str_context(errContext); appendStringInfo(&contextStr, "%s\n", str_context.str("?")); } } } if (!message.IsEmpty()) { CString script(message->GetScriptResourceName()); int lineno = message->GetLineNumber(context).FromJust(); CString source(message->GetSourceLine(context).ToLocalChecked()); // TODO: Get stack trace? //Handle stackTrace(message->GetStackTrace()); /* * Report lineno - 1 because "function _(...){" was added * at the first line to the javascript code. */ if (strstr(m_msg, "Error: ") == m_msg) m_msg += 7; appendStringInfo(&contextStr, "%s() LINE %d: %s", script.str("?"), lineno - 1, source.str("?")); } m_context = contextStr.data; } catch (...) { // nested error, keep quiet. } } Local js_error::error_object() { char *msg = pstrdup(m_msg ? m_msg : "unknown exception"); /* * Trim leading "Error: ", in case the message is generated from * another Error. */ if (strstr(msg, "Error: ") == msg) msg += 7; Local message = ToString(msg); return Exception::Error(message); } void js_error::log(int elevel, const char *msg_format) noexcept { if (elevel >= ERROR) { return rethrow(msg_format); } ereport(elevel, ( m_code ? errcode(m_code): 0, m_msg ? errmsg((msg_format ? msg_format : "%s"), m_msg) : 0, m_detail ? errdetail("%s", m_detail) : 0, m_hint ? errhint("%s", m_hint) : 0, m_context ? errcontext("%s", m_context) : 0 )); } __attribute__((noreturn)) void js_error::rethrow(const char *msg_format) noexcept { ereport(ERROR, ( m_code ? errcode(m_code): 0, m_msg ? errmsg((msg_format ? msg_format : "%s"), m_msg) : 0, m_detail ? errdetail("%s", m_detail) : 0, m_hint ? errhint("%s", m_hint) : 0, m_context ? errcontext("%s", m_context) : 0 )); exit(0); // keep compiler quiet } __attribute__((noreturn)) void pg_error::rethrow() throw() { PG_RE_THROW(); exit(0); // keep compiler quiet }