Windmill

W

Windmill

Join the community to ask questions about Windmill and get answers from other members.

Join

help

general

changelog

SQLite Query Compatibility

I am just getting involved in using windmill for process automation - mostly around data normalization in application data workflows (iCal / vCard / Bookmarking / Chat export / etc.). I'm trying to figure out a reliable way to connect external data files, specifically sqlite files in a way that would enable me to interact with them using scripts / flows. This is somewhat related to best practices to grant access to external "object" data (done with s3 interface in enterprise) / remote files - ideally with sftp? Sometimes these sqlite files do exceed 50mb....

Importing docx

question im using windmill web IDE and im importing Document from docx like so: from docx import Document but i get an error:...

dependencies on remote server

I created a requirments.txt and generated a lockfile by running wmill script generate-metadata ,but when I ran wmill sync push, I don't think the lockfile could be pushed to windmill , I can run the scrip without any issue by using the extension windmill in vs code when I turn on the button of ' use current lockfile' , buth when I login the remote windmill by using a browser, I still have an issue saying can't find the swiftclient module which is used in my code, and when I ran wmill sync pull...

Error migrating db

I'm attempting to use Supabase as an External DB but receiving the following errors in windmill-server: INFO windmill-api/src/db.rs: 154: Started applying migration 20241127171723: apply windmill roles INFO windmill-api/src/db.rs:181: Finished applying migration 20241127171723 Error: Error migrating db: Migrating database: while executing migration 20241127171723: error communicating with datbase: peer closed connection without sending TLS close_notify: https://docs.rs/rustls/latest/rustls/manual/_03_howto/index.html#unexpected-eof...

smtp not working

Hello. Trying to send email from a basic workflow : - I created a SMTP ressource under a workspace. - When trying to send an email, i got the following issue : ...

API Response of the scripts and variables it's different from the documentation

I'm using the APIs to list users and scripts on POstman and I'm getting a response differente that shows on the documentation.in my responses , I've missing fields such as created_by, folders,groups.Am I the only one with this problem?
No description

Error_Handler on Schedules

anyone else is having a problem when adding an handler_error script to their schedule, save it and then when u go see (via api GET lis schedules), there's no error handler assigned to that schedule?

Webhooks vs http triggers

Can someone please explain to me what is the difference between thes Webhooks and http triggers? I read the documentation but it doesn't make sense to me. Thank you!

Restoring Self-Hosted Instance - Login Issue

We are running a self-hosted Windmill Instance with Docker on a Linux server spun up in Azure. Very small env. I am in the process of testing restores on it and when I restore the server, I can get to it via http://azure-server-ip:8000 but I cannot login. I have MS SSO turned on, but also have a password for my user account. When I try to sign in with the non-third party it never signs in, just refreshes the page -- I don't usually get credential errors when attempting to sign in either. I have the base_url set up with our subdomain that we set up in our DNS. Could this be causing the issue? Should it be the default in the UI & then set up in the .env file so that it can be changed.. maybe? I don't think that having a backup user account for restore specifically is the answer.. but maybe it is? ...

ZOMBIE APOCALYPSE

My jobs are not blocking, I have plenty CPU / MEM headroom, yet my jobs seem to get killed with:
Job timed out after no ping from job since 2025-03-03 23:28:53.888358 UTC (ZOMBIE_JOB_TIMEOUT: 60, reason: "RestartLimit (3)
I'm running Deno scripts and each worker has 1 cpu and 512 request / 768 limit mem...

Schedule not followed, skips runs

Hi - I've had this issue for a while but haven't posted - my schedule doesn't run as normal, it consistently skips runs. Sometimes it works for a few days then goes back to skipping.
As pictured it should be running every 12 minutes, but the next run isn't for 5+ hours. If I turn off and back on the schedule it schedules a next run correctly soon, but then it adds another big gap again. Any ideas? Much appreciated!...
No description

Deployment and license key

Hello! I have some questions about best practices around provisioning instances with license keys. Context: We currently are storing a license key in a secret store and injecting it into the instance_settings.yaml an pushing those settings to our instance (running in ECS) at deploy-time. However, the license key in our secret manager goes out of sync with the one on the instance after the automatic daily key renewal. The approach we are considering is to 1. create an instance_settings.yaml using the license key in our secret store. This license key may be expired...

swiftclient can't be installed in windmill

When I ran the statement of import swiftclient by a python script, I had the error below { "error": { "name": "ExecutionErr", "message": "execution error:...

Script runs perfect when ran manually but it fails intermittently when add it to schedule

Script runs perfect when ran manually but it fails intermittently when add it to schedule with below error WaiterError: Waiter CommandExecuted failed: Max attempts exceeded. Previously accepted state: For expression "Status" we matched expected path: "InProgress"...

Inline OracleDB . How to use input variable as Oracle table name?

If I try the following query into InlineDB Oracle function I get the error message «{"name":"ExecutionErr","message":"execution error:\nError: OCI Error: ORA-00903: invalid table name» -- :name1 (text) -- :name2 (text) -- :table_name (text)...

My flows stopped working after updating windmill

I updated windmill today, running on coolify and it appears that many of my flows stopped working. Looks like something to do with package cache or lock file, any pointers on how to proceed? I am seeing stuff like : ```TypeError: Object is not a constructor (evaluating 'new import_woocommerce_rest_api.default({...

Can't import google-cloud-storage

Hello, I'm using the enterprise version, and I have setup a gcloud resource. I can't figure out how to import from google.gloud import storage that systematically fails, since it doesn't pick up that it needs to install google-cloud-storage. I've tried to formally add it at the top of the script using this ```...

Auditlog for user login info

I'm trying to get the info of the last time an user logged in on my workspace, as an admin, but in the API of audit logs, i can't find that information.Is there any available or other way i can get that information?

Stop stucked flow

Hi, we have stuck flow, how can I kill it? Cancel and force cancel don't work for some reason....
No description

Setting up a trigger when integrating with BigQuery

I want to only trigger the script when there is a file in my storage (BigQuery) has been modified. What kind of trigger should I set up and use to trigger processing in Windmill?