App Stopped, bug?

The app has stopped working since today. Neither the Edge nor Chrome versions can track my activity. Is this a bug?

1 Like

@zackieryu Sorry to hear you are running into this issue. We would like you to help us, get the Error details. For that,

Please follow these steps (Windows):
Run the Desktop app in debug mode

  1. Go to the following folder:
    C:/Users/your-username/AppData/Local/distill_web_monitor/app-4.1.0-beta/
    (“your-username” will be your actual Windows username)

  2. Inside this folder, look for:
    distill-web-monitor.exe (lowercase name)

  3. Open Command Prompt in this folder
    Run this command:
    distill-web-monitor.exe --enable-dev-tools

4. The Desktop app will open with developer tools
5. Go to the Console tab

Please take screenshots of the entire Console Tab and share it with us. This will help us identify the issue and fix it quickly.

1 Like

I’m not the original poster, but am seeing the same error today. Attaching screenshot of console …

1 Like

Also pasting from the command prompt …

Failed to init distill service: RangeError: The supplied SQL string contains more than one statement
at Database.prepare (C:\Users\####\AppData\Local\distill_web_monitor\app-4.1.0-beta\resources\app\node_modules\better-sqlite3\lib\methods\wrappers.js:5:21)
at execQuery (file:///C:/Users/####/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/electron/store.js:100:28)
at file:///C:/Users/####/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:101:12
at new Promise ()
at file:///C:/Users/####/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:100:14
at createViews (file:///C:/Users/####/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:209:11)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async file:///C:/Users/####/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:247:9
dom-utils: app ready
electron-main:dom-utils:ready: opening main app window

I downgraded to 4.0.2 beta from the website, and it launched OK. Unfortunately I don’t see any option to disable automatic updates, so I’ll probably get pushed to 4.1.0 beta again and need to downgrade again on next reboot…

Hi @zackieryu and @benfishbus,

Thank you for reporting this issue and for sharing the error info.

We haven’t been able to reproduce the problem on our end. As a next step, we’d like to request your help in trying a custom build of the app. I understand this is a bit of an involved request, and we really appreciate your time and effort here.

Link to custom build: link

This build is identical to the current version but includes additional logging to help us diagnose the issue more effectively.

Please install the build using the link and launch it from the terminal as previously described by @srijith. When possible, could you share the logs from both the developer console and the terminal?
There will likely be a large volume of logs. Please do share them in full

Thanks again for your support. We truly appreciate it and look forward to your update.

Thank you,
Jayakrishnan

Edit:

I’ll probably get pushed to 4.1.0 beta again and need to downgrade again on next reboot…

We have disabled auto-updates to 4.1.0-beta, so user’s don’t need to worry about this.

I have the same error. Started less than 12 hours ago.

can’t upload the log file so here you go. No console tools were available, looked the same as my screenshot in the previous post.

PS C:\Users\userD\AppData\Local\distill_web_monitor\app-4.1.0-beta> .\distill-web-monitor.exe --enable-dev-tools
PS C:\Users\userD\AppData\Local\distill_web_monitor\app-4.1.0-beta>
execquery:sql: PRAGMA journal_mode = TRUNCATE []
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'maint_logs' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'maint_logs' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'clients' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'clients' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'users' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'users' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'sieves' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'sieves' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'tags' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'tags' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'sieve_data' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'sieve_data' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'actions' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'actions' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'rules' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'rules' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'attrs' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'attrs' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'errors' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'errors' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'works' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'works' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'popup_messages' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'popup_messages' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'kv' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'kv' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'users_clients_groups' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'users_clients_groups' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'sieve_snapshots' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'sieve_snapshots' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'macros' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'macros' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'workflows' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'workflows' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'datasources' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'datasources' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'logs' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'logs' ]
execquery:sql: SELECT name FROM sqlite_master WHERE name = ?; [ 'workspaces' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'workspaces' ]
execquery:sql: SELECT * FROM maint_logs WHERE name = ? ORDER BY "ts"  DESC NULLS first LIMIT 1; [ 'view_sieve_data_user' ]
An instance is already running. Quitting this instance
electron-main: app.js loaded
execquery:sql: DROP VIEW IF EXISTS view_sieve_data_user; CREATE VIEW IF NOT EXISTS view_sieve_data_user AS
      SELECT
        sd.*,
        s.user_id,
        s.state AS sieve_state,
        s.name AS name,
        s.uri  AS uri,
        s.tags AS tags,
        s.content_type AS content_type
      FROM sieve_data sd
      INNER JOIN sieves s ON s.id = sd.sieve_id
     []
Execquery error SQL: DROP VIEW IF EXISTS view_sieve_data_user; CREATE VIEW IF NOT EXISTS view_sieve_data_user AS
      SELECT
        sd.*,
        s.user_id,
        s.state AS sieve_state,
        s.name AS name,
        s.uri  AS uri,
        s.tags AS tags,
        s.content_type AS content_type
      FROM sieve_data sd
      INNER JOIN sieves s ON s.id = sd.sieve_id
     VALUES [] Error: RangeError: The supplied SQL string contains more than one statement
    at Database.prepare (C:\Users\userD\AppData\Local\distill_web_monitor\app-4.1.0-beta\resources\app\node_modules\better-sqlite3\lib\methods\wrappers.js:5:21)
    at execQuery (file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/electron/store.js:101:28)
    at file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:101:12
    at new Promise (<anonymous>)
    at file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:100:14
    at createViews (file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:209:11)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:247:9
Failed to init distill service: RangeError: The supplied SQL string contains more than one statement
    at Database.prepare (C:\Users\userD\AppData\Local\distill_web_monitor\app-4.1.0-beta\resources\app\node_modules\better-sqlite3\lib\methods\wrappers.js:5:21)
    at execQuery (file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/electron/store.js:101:28)
    at file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:101:12
    at new Promise (<anonymous>)
    at file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/util.js:100:14
    at createViews (file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:209:11)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async file:///C:/Users/userD/AppData/Local/distill_web_monitor/app-4.1.0-beta/resources/app/common/store-sql.js:247:9
dom-utils: app ready
electron-main:dom-utils:ready: opening main app window
[22000:0408/194220.298:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.300:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.301:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.302:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.302:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.336:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[22000:0408/194220.353:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.353:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[22000:0408/194220.357:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.357:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[22000:0408/194220.357:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.357:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[22000:0408/194220.357:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.357:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[22000:0408/194220.357:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.357:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[22000:0408/194220.359:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
[22000:0408/194220.359:ERROR:gpu\ipc\host\gpu_disk_cache.cc:724] Gpu Cache Creation failed: -2
[37572:0408/194221.778:ERROR:net\disk_cache\cache_util_win.cc:25] Unable to move the cache: Access is denied. (0x5)
[37572:0408/194221.778:ERROR:net\disk_cache\disk_cache.cc:236] Unable to create cache
Closing connection to db

@zackieryu @benfishbus @Timo Thank you for your help for getting the log files of the terminal and the screenshots.

As a workaround, please try reinstalling the desktop app:
First, uninstall the current app:
Open Start menu → search for Distill Web Monitor → right-click → Uninstall
Or go to Control Panel → Programs and Features and uninstall it from there

Then, download and install the latest version of the app from our website
https://distill.io/apps/web-monitor/

This should help resolve the issue.

4.1.1 working well, thanks!

1 Like

Hello again @Timo @zackieryu @benfishbus,

We’ve released Desktop App version 4.1.1 earlier today with a fix for the issue.

Thanks for the details shared here. It really helped us track down and resolve it quickly

2 Likes

Fixed for me too thanks for quick turnaround

1 Like