Comments (6)
Can this be reproduced repeatedly? If so, could you set the LOG_LEVEL
config option 1 to error
or debug
and see whether you get more information on what exactly happens before the crash?
The flow seems to run fine, and is doing it's job on the data, but I can't see the logs for that specific flow..
So you're saying the server doesn't crash, from running the Flow itself, and would continue to do so, unless you open the logs for this Flow?
Footnotes
from directus.
Can this be reproduced repeatedly? If so, could you set the LOG_LEVEL config option 1 to error or debug and see whether you get more information on what exactly happens before the crash?
Yes, happens every time I try to open the logs on the flow..
these are the logs with log level error:
2024-03-03T13:29:45.888153936Z 2024-03-03T13:29:45: PM2 log: Launching in no daemon mode
2024-03-03T13:29:45.929001524Z 2024-03-03T13:29:45: PM2 log: App [directus:0] starting in -cluster mode-
2024-03-03T13:29:48.976416487Z 2024-03-03T13:29:48: PM2 log: App [directus:0] online
2024-03-03T13:31:00.770266928Z 2024-03-03T13:31:00: PM2 log: App name:directus id:0 disconnected
2024-03-03T13:31:00.770297826Z 2024-03-03T13:31:00: PM2 log: App [directus:0] exited with code [0] via signal [SIGKILL]
2024-03-03T13:31:00.770755975Z 2024-03-03T13:31:00: PM2 error: Error caught while calling pidusage
2024-03-03T13:31:00.777004125Z 2024-03-03T13:31:00: PM2 error: Error: ESRCH: no such process, read
2024-03-03T13:31:00.779213429Z 2024-03-03T13:31:00: PM2 error: Error caught while calling pidusage
2024-03-03T13:31:00.788640401Z 2024-03-03T13:31:00: PM2 error: Error: ESRCH: no such process, read
2024-03-03T13:31:00.796780119Z 2024-03-03T13:31:00: PM2 log: 0 application online, retry = 3
2024-03-03T13:31:02.802610351Z 2024-03-03T13:31:02: PM2 log: 0 application online, retry = 2
2024-03-03T13:31:04.805999042Z 2024-03-03T13:31:04: PM2 log: 0 application online, retry = 1
2024-03-03T13:31:06.810083048Z 2024-03-03T13:31:06: PM2 log: 0 application online, retry = 0
2024-03-03T13:31:06.938613102Z 2024-03-03T13:31:06: PM2 log: PM2 successfully stopped
These are the logs with log level debug:
2024-03-03T13:34:33.074742682Z [13:34:32.661] INFO: Initializing bootstrap...
2024-03-03T13:34:33.074798035Z [13:34:32.664] INFO: Database already initialized, skipping install
2024-03-03T13:34:33.074801432Z [13:34:32.664] INFO: Running migrations...
2024-03-03T13:34:33.074803796Z [13:34:32.685] INFO: Done
2024-03-03T13:34:33.652385072Z 2024-03-03T13:34:33: PM2 log: Launching in no daemon mode
2024-03-03T13:34:33.718656501Z 2024-03-03T13:34:33: PM2 log: App [directus:0] starting in -cluster mode-
2024-03-03T13:34:36.787107302Z 2024-03-03T13:34:36: PM2 log: App [directus:0] online
2024-03-03T13:34:38.964615723Z [13:34:38.572] WARN: PUBLIC_URL should be a full URL
2024-03-03T13:34:38.965194839Z [13:34:38.576] WARN: PostGIS isn't installed. Geometry type support will be limited.
2024-03-03T13:34:38.965318261Z [13:34:38.744] INFO: GraphQL Subscriptions started at ws://0.0.0.0:8055/graphql
2024-03-03T13:34:38.965429810Z [13:34:38.745] INFO: WebSocket Server started at ws://0.0.0.0:8055/websocket
2024-03-03T13:34:38.965675841Z [13:34:38.778] INFO: Server started at http://0.0.0.0:8055
2024-03-03T13:35:03.936449008Z [13:35:03] GET /admin/settings/flows/ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7 304 31ms
2024-03-03T13:35:03.936795437Z [13:35:03] GET /extensions/sources/index.js 200 18ms
2024-03-03T13:35:04.061980386Z [13:35:04] POST /auth/refresh 200 77ms
2024-03-03T13:35:04.191572347Z [13:35:04] GET /auth 304 18ms
2024-03-03T13:35:04.194090258Z [13:35:04] GET /server/info 304 37ms
2024-03-03T13:35:04.258639252Z [13:35:04] GET /translations?fields[]=language&fields[]=key&fields[]=value&filter[language][_eq]=en-US&limit=-1 304 26ms
2024-03-03T13:35:04.386769162Z [13:35:04] GET /users/me?fields[]=*&fields[]=avatar.id&fields[]=role.admin_access&fields[]=role.app_access&fields[]=role.id&fields[]=role.enforce_tfa 200 13ms
2024-03-03T13:35:04.422400994Z [13:35:04] GET /permissions?filter[role][_eq]=d0238a22-ab93-4ea0-8748-08e17ce433e6 304 18ms
2024-03-03T13:35:04.482381882Z [13:35:04] GET /fields 304 67ms
2024-03-03T13:35:04.624037704Z [13:35:04] GET /presets?filter[user][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&limit=-1 304 26ms
2024-03-03T13:35:04.628298011Z [13:35:04] GET /collections 304 58ms
2024-03-03T13:35:04.638526852Z [13:35:04] GET /settings 304 35ms
2024-03-03T13:35:04.638884502Z [13:35:04] GET /presets?filter[role][_null]=true&filter[user][_null]=true&limit=-1 304 53ms
2024-03-03T13:35:04.697139313Z [13:35:04] GET /relations 304 34ms
2024-03-03T13:35:04.705537280Z [13:35:04] GET /dashboards?fields[]=*&sort[]=name&limit=-1 304 47ms
2024-03-03T13:35:04.706076862Z [13:35:04] GET /panels?fields[]=*&sort[]=dashboard&limit=-1 304 38ms
2024-03-03T13:35:04.729880444Z [13:35:04] GET /flows?fields[]=*&fields[]=operations.*&limit=-1 304 65ms
2024-03-03T13:35:04.730688730Z [13:35:04] GET /notifications?filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox&aggregate[count]=id 304 44ms
2024-03-03T13:35:04.730949809Z [13:35:04] GET /presets?filter[role][_eq]=d0238a22-ab93-4ea0-8748-08e17ce433e6&filter[user][_null]=true&limit=-1 304 34ms
2024-03-03T13:35:04.795257579Z [13:35:04] GET /translations?fields[]=language&fields[]=key&fields[]=value&filter[language][_eq]=en-US&limit=-1 304 7ms
2024-03-03T13:35:05.054970335Z [13:35:04] GET /notifications?filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox&aggregate[countDistinct]=id 304 31ms
2024-03-03T13:35:05.062282786Z [13:35:04] GET /notifications?aggregate[countDistinct]=id 304 32ms
2024-03-03T13:35:05.063463370Z [13:35:04] GET /notifications?limit=25&fields[]=id&fields[]=subject&fields[]=message&fields[]=collection&fields[]=item&fields[]=timestamp&sort[]=-timestamp&page=1&filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox 304 57ms
2024-03-03T13:35:05.064681113Z [13:35:05] GET /revisions?filter[_and][0][collection][_eq]=directus_flows&filter[_and][1][item][_eq]=ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7&filter[_and][2][version][_null]=true&filter[_and][3][activity][action][_eq]=run&aggregate[count]=id 304 91ms
2024-03-03T13:35:05.066734744Z [13:35:05] GET /assets/d8a475c5-bb8b-4762-96e5-09d247064eca 200 120ms
2024-03-03T13:35:05.578194068Z [13:35:05] PATCH /users/me/track/page 204 50ms
2024-03-03T13:35:42.624872541Z 2024-03-03T13:35:42: PM2 log: App name:directus id:0 disconnected
2024-03-03T13:35:42.625279986Z 2024-03-03T13:35:42: PM2 log: App [directus:0] exited with code [0] via signal [SIGKILL]
2024-03-03T13:35:42.666156342Z 2024-03-03T13:35:42: PM2 error: Error caught while calling pidusage
2024-03-03T13:35:42.681506876Z 2024-03-03T13:35:42: PM2 error: Error: ESRCH: no such process, read
2024-03-03T13:35:44.587140789Z 2024-03-03T13:35:44: PM2 log: 0 application online, retry = 3
2024-03-03T13:35:46.591351958Z 2024-03-03T13:35:46: PM2 log: 0 application online, retry = 2
So you're saying the server doesn't crash, from running the Flow itself, and would continue to do so, unless you open the logs for this Flow?
Yes, it's just the log, the flow updates some data if it has changed, and I see those changes happening when I run the flow 🤷♂️
I realize that just recreating the same flow might be the simplest answer here, it's not that complicated, but it would be nice to avoid ending up with a more complicated broken flow log 😅 also if it is a corrupt log or something messing this up, do you know if deleting a flow will delete it's associated flow logs?
Unfortunately I havent figured out how to connect directly to the database created by coolify yet, so it's hard to take a direct look at it.
I'll try recreating the flow next, run it, and see if the logs get broken there too, then at least we might know if it's a likely one-off or something reproducible 💪
from directus.
Thanks for the feedback!
I'm sorry, I meant to write setting the log level to debug
or trace
😅 Could you run it again with trace
enabled? Will probably spit out a lot of output, but might contain some helpful info.
from directus.
I recreated the flow, and it seems to work fine, and I can read the logs, I will try to crash it again with trace on! 😊
Btw, the web request spits out an api result of about 58000 lines, which I see in the log; I don't know if that's an enormous amount, or should be fine 🤷♂️ just in case this could be why. since I have about 78 logs on the crashing one, and only 2 on the new working one..
from directus.
Here is the trace level log:
2024-03-03T13:57:41.473232973Z [13:57:41.012] TRACE: [14.545ms]
2024-03-03T13:57:41.473942624Z SELECT
2024-03-03T13:57:41.473952423Z rel.relname AS name
2024-03-03T13:57:41.473958023Z FROM
2024-03-03T13:57:41.473963323Z pg_class rel
2024-03-03T13:57:41.473968423Z WHERE
2024-03-03T13:57:41.473973803Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:57:41.473979303Z AND rel.relkind = 'r'
2024-03-03T13:57:41.473984643Z AND rel.relname = $1
2024-03-03T13:57:41.473989683Z ORDER BY rel.relname
2024-03-03T13:57:41.473994993Z [directus_collections]
2024-03-03T13:57:41.474250461Z [13:57:41.022] TRACE: [3.287ms] select "version" from "directus_migrations" []
2024-03-03T13:57:41.474595288Z [13:57:41.073] TRACE: [22.340ms]
2024-03-03T13:57:41.474632348Z SELECT relname as table_name
2024-03-03T13:57:41.474640463Z , pg_attribute.attname as column_name
2024-03-03T13:57:41.474645703Z FROM pg_index
2024-03-03T13:57:41.474650963Z , pg_class
2024-03-03T13:57:41.474655832Z , pg_attribute
2024-03-03T13:57:41.474660991Z , pg_namespace
2024-03-03T13:57:41.474665851Z WHERE
2024-03-03T13:57:41.474670990Z indrelid = pg_class.oid
2024-03-03T13:57:41.474676180Z AND nspname IN ($1)
2024-03-03T13:57:41.474681380Z AND pg_class.relnamespace = pg_namespace.oid
2024-03-03T13:57:41.474686449Z AND pg_attribute.attrelid = pg_class.oid
2024-03-03T13:57:41.474691679Z AND pg_attribute.attnum = ANY (pg_index.indkey)
2024-03-03T13:57:41.474717577Z AND indisprimary
2024-03-03T13:57:41.474724781Z AND indnatts = 1
2024-03-03T13:57:41.474729771Z AND relkind != 'S'
2024-03-03T13:57:41.474737435Z [public]
2024-03-03T13:57:41.474905531Z [13:57:41.104] TRACE: [68.047ms]
2024-03-03T13:57:41.474916482Z SELECT c.table_name
2024-03-03T13:57:41.474921671Z , c.column_name
2024-03-03T13:57:41.474951818Z , c.column_default as default_value
2024-03-03T13:57:41.474957689Z , c.data_type
2024-03-03T13:57:41.474962618Z , c.character_maximum_length as max_length
2024-03-03T13:57:41.474968159Z , c.is_generated = 'ALWAYS' is_generated
2024-03-03T13:57:41.474973569Z , CASE WHEN c.is_identity = 'YES' THEN true ELSE false END is_identity
2024-03-03T13:57:41.474978899Z , CASE WHEN c.is_nullable = 'YES' THEN true ELSE false END is_nullable
2024-03-03T13:57:41.474995119Z FROM
2024-03-03T13:57:41.475000369Z information_schema.columns c
2024-03-03T13:57:41.475005378Z LEFT JOIN information_schema.tables t
2024-03-03T13:57:41.475010358Z ON c.table_name = t.table_name
2024-03-03T13:57:41.475015297Z WHERE
2024-03-03T13:57:41.475043520Z t.table_type = 'BASE TABLE'
2024-03-03T13:57:41.475048850Z AND c.table_schema IN ($1);
2024-03-03T13:57:41.475054040Z [public]
2024-03-03T13:57:41.475525464Z [13:57:41.105] TRACE: [1.318ms] SELECT oid FROM pg_proc WHERE proname = 'postgis_version' []
2024-03-03T13:57:41.476058002Z [13:57:41.108] TRACE: [1.056ms] select "collection", "singleton", "note", "sort_field", "accountability" from "directus_collections" []
2024-03-03T13:57:41.476266533Z [13:57:41.113] TRACE: [2.953ms] select "id", "collection", "field", "special", "note", "validation" from "directus_fields" []
2024-03-03T13:57:41.476520539Z [13:57:41.126] TRACE: [1.820ms] select "directus_relations"."id", "directus_relations"."many_collection", "directus_relations"."many_field", "directus_relations"."one_collection", "directus_relations"."one_field", "directus_relations"."one_collection_field", "directus_relations"."one_allowed_collections", "directus_relations"."junction_field", "directus_relations"."sort_field", "directus_relations"."one_deselect_action" from "directus_relations" order by "directus_relations"."id" asc []
2024-03-03T13:57:41.476909880Z [13:57:41.138] TRACE: [8.764ms]
2024-03-03T13:57:41.476951979Z SELECT
2024-03-03T13:57:41.476967537Z con.conname AS constraint_name,
2024-03-03T13:57:41.476982676Z rel.relname AS table,
2024-03-03T13:57:41.476989980Z att.attname AS column,
2024-03-03T13:57:41.476997774Z frel.relnamespace::regnamespace::text AS foreign_key_schema,
2024-03-03T13:57:41.477005138Z frel.relname AS foreign_key_table,
2024-03-03T13:57:41.477053699Z fatt.attname AS foreign_key_column,
2024-03-03T13:57:41.477062726Z CASE con.confupdtype
2024-03-03T13:57:41.477069589Z WHEN 'r' THEN
2024-03-03T13:57:41.477076241Z 'RESTRICT'
2024-03-03T13:57:41.477082954Z WHEN 'c' THEN
2024-03-03T13:57:41.477089566Z 'CASCADE'
2024-03-03T13:57:41.477096389Z WHEN 'n' THEN
2024-03-03T13:57:41.477102842Z 'SET NULL'
2024-03-03T13:57:41.477109223Z WHEN 'd' THEN
2024-03-03T13:57:41.477115775Z 'SET DEFAULT'
2024-03-03T13:57:41.477166130Z WHEN 'a' THEN
2024-03-03T13:57:41.477173083Z 'NO ACTION'
2024-03-03T13:57:41.477193060Z ELSE
2024-03-03T13:57:41.477200013Z NULL
2024-03-03T13:57:41.477207137Z END AS on_update,
2024-03-03T13:57:41.477214291Z CASE con.confdeltype
2024-03-03T13:57:41.477251650Z WHEN 'r' THEN
2024-03-03T13:57:41.477260006Z 'RESTRICT'
2024-03-03T13:57:41.477266819Z WHEN 'c' THEN
2024-03-03T13:57:41.477273732Z 'CASCADE'
2024-03-03T13:57:41.477280705Z WHEN 'n' THEN
2024-03-03T13:57:41.477287828Z 'SET NULL'
2024-03-03T13:57:41.477294931Z WHEN 'd' THEN
2024-03-03T13:57:41.477302035Z 'SET DEFAULT'
2024-03-03T13:57:41.477309148Z WHEN 'a' THEN
2024-03-03T13:57:41.477342711Z 'NO ACTION'
2024-03-03T13:57:41.477349925Z ELSE
2024-03-03T13:57:41.477356457Z NULL
2024-03-03T13:57:41.477363250Z END AS on_delete
2024-03-03T13:57:41.477369782Z FROM
2024-03-03T13:57:41.477376524Z pg_constraint con
2024-03-03T13:57:41.477382787Z LEFT JOIN pg_class rel ON con.conrelid = rel.oid
2024-03-03T13:57:41.477389880Z LEFT JOIN pg_class frel ON con.confrelid = frel.oid
2024-03-03T13:57:41.477396492Z LEFT JOIN pg_attribute att ON att.attrelid = con.conrelid AND att.attnum = con.conkey[1]
2024-03-03T13:57:41.477431277Z LEFT JOIN pg_attribute fatt ON fatt.attrelid = con.confrelid AND fatt.attnum = con.confkey[1]
2024-03-03T13:57:41.477441366Z WHERE con.connamespace IN ('public'::regnamespace)
2024-03-03T13:57:41.477448700Z AND array_length(con.conkey, 1) <= 1
2024-03-03T13:57:41.477456505Z AND (con.confkey IS NULL OR array_length(con.confkey, 1) = 1)
2024-03-03T13:57:41.477463578Z AND con.contype = 'f'
2024-03-03T13:57:41.477470982Z
2024-03-03T13:57:41.477477854Z []
2024-03-03T13:57:41.477748323Z [13:57:41.160] TRACE: [1.349ms] select "directus_extensions"."name", "directus_extensions"."enabled" from "directus_extensions" order by "directus_extensions"."name" asc []
2024-03-03T13:57:41.478003752Z [13:57:41.289] INFO: Initializing bootstrap...
2024-03-03T13:57:41.478487689Z [13:57:41.290] TRACE: [0.676ms] SELECT 1 []
2024-03-03T13:57:41.478950467Z [13:57:41.291] TRACE: [0.823ms]
2024-03-03T13:57:41.478964163Z SELECT
2024-03-03T13:57:41.479014918Z rel.relname AS name
2024-03-03T13:57:41.479024876Z FROM
2024-03-03T13:57:41.479031940Z pg_class rel
2024-03-03T13:57:41.479039143Z WHERE
2024-03-03T13:57:41.479046256Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:57:41.479053641Z AND rel.relkind = 'r'
2024-03-03T13:57:41.479060674Z AND rel.relname = $1
2024-03-03T13:57:41.479099657Z ORDER BY rel.relname
2024-03-03T13:57:41.479109114Z [directus_collections]
2024-03-03T13:57:41.479312235Z [13:57:41.292] INFO: Database already initialized, skipping install
2024-03-03T13:57:41.479716123Z [13:57:41.292] INFO: Running migrations...
2024-03-03T13:57:41.479949651Z [13:57:41.295] TRACE: [1.817ms] select * from "directus_migrations" order by "version" asc []
2024-03-03T13:57:41.480339372Z [13:57:41.311] INFO: Done
2024-03-03T13:57:42.118940100Z 2024-03-03T13:57:42: PM2 log: Launching in no daemon mode
2024-03-03T13:57:42.168086648Z 2024-03-03T13:57:42: PM2 log: App [directus:0] starting in -cluster mode-
2024-03-03T13:57:45.221675666Z 2024-03-03T13:57:45: PM2 log: App [directus:0] online
2024-03-03T13:57:47.373632734Z [13:57:46.934] TRACE: [5.899ms]
2024-03-03T13:57:47.373888594Z SELECT
2024-03-03T13:57:47.373892591Z rel.relname AS name
2024-03-03T13:57:47.373895196Z FROM
2024-03-03T13:57:47.373897611Z pg_class rel
2024-03-03T13:57:47.373899844Z WHERE
2024-03-03T13:57:47.373902169Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:57:47.373904564Z AND rel.relkind = 'r'
2024-03-03T13:57:47.373906777Z AND rel.relname = $1
2024-03-03T13:57:47.373908962Z ORDER BY rel.relname
2024-03-03T13:57:47.373911186Z [directus_collections]
2024-03-03T13:57:47.374433597Z [13:57:46.940] TRACE: [1.600ms] select "version" from "directus_migrations" []
2024-03-03T13:57:47.374693353Z [13:57:46.981] TRACE: [7.222ms]
2024-03-03T13:57:47.374702020Z SELECT relname as table_name
2024-03-03T13:57:47.374704795Z , pg_attribute.attname as column_name
2024-03-03T13:57:47.374707099Z FROM pg_index
2024-03-03T13:57:47.374709343Z , pg_class
2024-03-03T13:57:47.374711498Z , pg_attribute
2024-03-03T13:57:47.374713772Z , pg_namespace
2024-03-03T13:57:47.374716026Z WHERE
2024-03-03T13:57:47.374718190Z indrelid = pg_class.oid
2024-03-03T13:57:47.374720384Z AND nspname IN ($1)
2024-03-03T13:57:47.374731926Z AND pg_class.relnamespace = pg_namespace.oid
2024-03-03T13:57:47.374734290Z AND pg_attribute.attrelid = pg_class.oid
2024-03-03T13:57:47.374736505Z AND pg_attribute.attnum = ANY (pg_index.indkey)
2024-03-03T13:57:47.374738698Z AND indisprimary
2024-03-03T13:57:47.374740883Z AND indnatts = 1
2024-03-03T13:57:47.374743017Z AND relkind != 'S'
2024-03-03T13:57:47.374745361Z [public]
2024-03-03T13:57:47.374988968Z [13:57:47.007] TRACE: [52.764ms]
2024-03-03T13:57:47.374996733Z SELECT c.table_name
2024-03-03T13:57:47.374999227Z , c.column_name
2024-03-03T13:57:47.375001422Z , c.column_default as default_value
2024-03-03T13:57:47.375006571Z , c.data_type
2024-03-03T13:57:47.375008775Z , c.character_maximum_length as max_length
2024-03-03T13:57:47.375011210Z , c.is_generated = 'ALWAYS' is_generated
2024-03-03T13:57:47.375013484Z , CASE WHEN c.is_identity = 'YES' THEN true ELSE false END is_identity
2024-03-03T13:57:47.375015849Z , CASE WHEN c.is_nullable = 'YES' THEN true ELSE false END is_nullable
2024-03-03T13:57:47.375018073Z FROM
2024-03-03T13:57:47.375020206Z information_schema.columns c
2024-03-03T13:57:47.375022370Z LEFT JOIN information_schema.tables t
2024-03-03T13:57:47.375024575Z ON c.table_name = t.table_name
2024-03-03T13:57:47.375026739Z WHERE
2024-03-03T13:57:47.375028843Z t.table_type = 'BASE TABLE'
2024-03-03T13:57:47.375030997Z AND c.table_schema IN ($1);
2024-03-03T13:57:47.375033161Z [public]
2024-03-03T13:57:47.375424304Z [13:57:47.008] TRACE: [0.945ms] SELECT oid FROM pg_proc WHERE proname = 'postgis_version' []
2024-03-03T13:57:47.375788247Z [13:57:47.012] TRACE: [0.928ms] select "collection", "singleton", "note", "sort_field", "accountability" from "directus_collections" []
2024-03-03T13:57:47.376154123Z [13:57:47.017] TRACE: [1.151ms] select "id", "collection", "field", "special", "note", "validation" from "directus_fields" []
2024-03-03T13:57:47.376619315Z [13:57:47.030] TRACE: [1.810ms] select "directus_relations"."id", "directus_relations"."many_collection", "directus_relations"."many_field", "directus_relations"."one_collection", "directus_relations"."one_field", "directus_relations"."one_collection_field", "directus_relations"."one_allowed_collections", "directus_relations"."junction_field", "directus_relations"."sort_field", "directus_relations"."one_deselect_action" from "directus_relations" order by "directus_relations"."id" asc []
2024-03-03T13:57:47.377124914Z [13:57:47.040] TRACE: [3.866ms]
2024-03-03T13:57:47.377133641Z SELECT
2024-03-03T13:57:47.377141656Z con.conname AS constraint_name,
2024-03-03T13:57:47.377144141Z rel.relname AS table,
2024-03-03T13:57:47.377146414Z att.attname AS column,
2024-03-03T13:57:47.377148649Z frel.relnamespace::regnamespace::text AS foreign_key_schema,
2024-03-03T13:57:47.377151023Z frel.relname AS foreign_key_table,
2024-03-03T13:57:47.377153227Z fatt.attname AS foreign_key_column,
2024-03-03T13:57:47.377155462Z CASE con.confupdtype
2024-03-03T13:57:47.377157646Z WHEN 'r' THEN
2024-03-03T13:57:47.377159950Z 'RESTRICT'
2024-03-03T13:57:47.377162204Z WHEN 'c' THEN
2024-03-03T13:57:47.377164479Z 'CASCADE'
2024-03-03T13:57:47.377166643Z WHEN 'n' THEN
2024-03-03T13:57:47.377168816Z 'SET NULL'
2024-03-03T13:57:47.377172614Z WHEN 'd' THEN
2024-03-03T13:57:47.377174808Z 'SET DEFAULT'
2024-03-03T13:57:47.377177002Z WHEN 'a' THEN
2024-03-03T13:57:47.377179176Z 'NO ACTION'
2024-03-03T13:57:47.377181430Z ELSE
2024-03-03T13:57:47.377183595Z NULL
2024-03-03T13:57:47.377185768Z END AS on_update,
2024-03-03T13:57:47.377187963Z CASE con.confdeltype
2024-03-03T13:57:47.377190116Z WHEN 'r' THEN
2024-03-03T13:57:47.377192291Z 'RESTRICT'
2024-03-03T13:57:47.377194515Z WHEN 'c' THEN
2024-03-03T13:57:47.377196699Z 'CASCADE'
2024-03-03T13:57:47.377198873Z WHEN 'n' THEN
2024-03-03T13:57:47.377201017Z 'SET NULL'
2024-03-03T13:57:47.377203191Z WHEN 'd' THEN
2024-03-03T13:57:47.377205325Z 'SET DEFAULT'
2024-03-03T13:57:47.377207509Z WHEN 'a' THEN
2024-03-03T13:57:47.377209643Z 'NO ACTION'
2024-03-03T13:57:47.377211827Z ELSE
2024-03-03T13:57:47.377214001Z NULL
2024-03-03T13:57:47.377216165Z END AS on_delete
2024-03-03T13:57:47.377218340Z FROM
2024-03-03T13:57:47.377220484Z pg_constraint con
2024-03-03T13:57:47.377222657Z LEFT JOIN pg_class rel ON con.conrelid = rel.oid
2024-03-03T13:57:47.377226976Z LEFT JOIN pg_class frel ON con.confrelid = frel.oid
2024-03-03T13:57:47.377229250Z LEFT JOIN pg_attribute att ON att.attrelid = con.conrelid AND att.attnum = con.conkey[1]
2024-03-03T13:57:47.377231565Z LEFT JOIN pg_attribute fatt ON fatt.attrelid = con.confrelid AND fatt.attnum = con.confkey[1]
2024-03-03T13:57:47.377233869Z WHERE con.connamespace IN ('public'::regnamespace)
2024-03-03T13:57:47.377236093Z AND array_length(con.conkey, 1) <= 1
2024-03-03T13:57:47.377238498Z AND (con.confkey IS NULL OR array_length(con.confkey, 1) = 1)
2024-03-03T13:57:47.377240842Z AND con.contype = 'f'
2024-03-03T13:57:47.377243066Z
2024-03-03T13:57:47.377245230Z []
2024-03-03T13:57:47.377751620Z [13:57:47.056] TRACE: [1.333ms] select "directus_extensions"."name", "directus_extensions"."enabled" from "directus_extensions" order by "directus_extensions"."name" asc []
2024-03-03T13:57:47.378094713Z [13:57:47.212] WARN: PUBLIC_URL should be a full URL
2024-03-03T13:57:47.378474164Z [13:57:47.214] TRACE: [0.490ms] SELECT 1 []
2024-03-03T13:57:47.379043051Z [13:57:47.215] TRACE: [0.865ms] select "oid" from "pg_proc" where "proname" = $1 [postgis_version]
2024-03-03T13:57:47.379347021Z [13:57:47.215] WARN: PostGIS isn't installed. Geometry type support will be limited.
2024-03-03T13:57:47.379773280Z [13:57:47.216] TRACE: [0.545ms]
2024-03-03T13:57:47.379780975Z SELECT
2024-03-03T13:57:47.379783740Z rel.relname AS name
2024-03-03T13:57:47.379786084Z FROM
2024-03-03T13:57:47.379788299Z pg_class rel
2024-03-03T13:57:47.379790493Z WHERE
2024-03-03T13:57:47.379792687Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:57:47.379795041Z AND rel.relkind = 'r'
2024-03-03T13:57:47.379797245Z AND rel.relname = $1
2024-03-03T13:57:47.379799409Z ORDER BY rel.relname
2024-03-03T13:57:47.379801613Z [directus_collections]
2024-03-03T13:57:47.380081349Z [13:57:47.217] TRACE: [0.522ms] select "version" from "directus_migrations" []
2024-03-03T13:57:47.382091679Z [13:57:47.231] TRACE: [4.352ms] select "directus_flows"."id", "directus_flows"."name", "directus_flows"."icon", "directus_flows"."color", "directus_flows"."description", "directus_flows"."status", "directus_flows"."trigger", "directus_flows"."accountability", "directus_flows"."options", "directus_flows"."operation", "directus_flows"."date_created", "directus_flows"."user_created" from "directus_flows" where "directus_flows"."status" = $1 order by "directus_flows"."id" asc [active]
2024-03-03T13:57:47.382364360Z [13:57:47.239] TRACE: [4.443ms] select "directus_operations"."id", "directus_operations"."name", "directus_operations"."key", "directus_operations"."type", "directus_operations"."position_x", "directus_operations"."position_y", "directus_operations"."options", "directus_operations"."resolve", "directus_operations"."reject", "directus_operations"."flow", "directus_operations"."date_created", "directus_operations"."user_created" from "directus_operations" where "directus_operations"."flow" in ($1, $2, $3, $4, $5) order by "directus_operations"."id" asc limit $6 [0699eae5-21d0-4c5d-b9fd-c90c61376b0a, 06b00c7c-245d-4066-9b7e-e63c9a57b6aa, 1d133b1b-8a66-445d-8074-2c3ad6c38f3b, e749a5da-2ea8-4f5e-a55e-844118c2d698, ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7, 25000]
2024-03-03T13:57:47.382539960Z [13:57:47.265] TRACE: [1.249ms] select "directus_webhooks"."id", "directus_webhooks"."name", "directus_webhooks"."method", "directus_webhooks"."url", "directus_webhooks"."status", "directus_webhooks"."data", "directus_webhooks"."actions", "directus_webhooks"."collections", "directus_webhooks"."headers" from "directus_webhooks" where "directus_webhooks"."status" = $1 order by "directus_webhooks"."id" asc limit $2 [active, 100]
2024-03-03T13:57:47.382719207Z [13:57:47.309] INFO: GraphQL Subscriptions started at ws://0.0.0.0:8055/graphql
2024-03-03T13:57:47.382935663Z [13:57:47.309] INFO: WebSocket Server started at ws://0.0.0.0:8055/websocket
2024-03-03T13:57:47.383162818Z [13:57:47.320] TRACE: [3.965ms] select count(*) as "count" from "directus_dashboards" limit $1 [1]
2024-03-03T13:57:47.384039983Z [13:57:47.322] TRACE: [1.500ms] select count(*) as "count" from "directus_extensions" limit $1 [1]
2024-03-03T13:57:47.384223467Z [13:57:47.330] TRACE: [7.798ms] select count(*) as "count" from "directus_files" limit $1 [1]
2024-03-03T13:57:47.384396662Z [13:57:47.331] TRACE: [15.194ms] select count("directus_users"."id") as "count", "directus_roles"."admin_access", "directus_roles"."app_access" from "directus_users" left join "directus_roles" on "directus_users"."role" = "directus_roles"."id" group by "directus_roles"."admin_access", "directus_roles"."app_access" []
2024-03-03T13:57:47.384567363Z [13:57:47.337] TRACE: [6.484ms] select count(*) as "count" from "Treningsgrupper" limit $1 [1]
2024-03-03T13:57:47.386053159Z [13:57:47.338] TRACE: [6.911ms] select count(*) as "count" from "Gymnaster_Treningsgrupper" limit $1 [1]
2024-03-03T13:57:47.386238658Z [13:57:47.349] INFO: Server started at http://0.0.0.0:8055
2024-03-03T13:57:47.386401873Z [13:57:47.352] TRACE: [15.072ms] select count(*) as "count" from "spond_login" limit $1 [1]
2024-03-03T13:57:47.386577573Z [13:57:47.353] TRACE: [15.727ms] select count(*) as "count" from "directus_flows" limit $1 [1]
2024-03-03T13:57:47.386779020Z [13:57:47.357] TRACE: [4.454ms] select count(*) as "count" from "directus_roles" limit $1 [1]
2024-03-03T13:57:47.388200486Z [13:57:47.359] TRACE: [5.379ms] select count(*) as "count" from "directus_shares" limit $1 [1]
2024-03-03T13:57:47.648591788Z [13:57:47.365] TRACE: [7.264ms] select count(*) as "count" from "Gymnaster" limit $1 [1]
2024-03-03T13:58:28.667408096Z [13:58:28] POST /auth/refresh 200 93ms
2024-03-03T13:58:28.739454494Z [13:58:27.948] TRACE: [4.006ms] select "ip_access" from "directus_roles" where "id" is null limit $1 [1]
2024-03-03T13:58:28.740134610Z [13:58:27.969] TRACE: [2.763ms] select * from "directus_permissions" where "role" is null []
2024-03-03T13:58:28.740375401Z [13:58:28.004] TRACE: [13.226ms] select "s"."expires" as "session_expires", "u"."id" as "user_id", "u"."first_name" as "user_first_name", "u"."last_name" as "user_last_name", "u"."email" as "user_email", "u"."password" as "user_password", "u"."status" as "user_status", "u"."provider" as "user_provider", "u"."external_identifier" as "user_external_identifier", "u"."auth_data" as "user_auth_data", "r"."id" as "role_id", "r"."admin_access" as "role_admin_access", "r"."app_access" as "role_app_access", "d"."id" as "share_id", "d"."item" as "share_item", "d"."role" as "share_role", "d"."collection" as "share_collection", "d"."date_start" as "share_start", "d"."date_end" as "share_end", "d"."times_used" as "share_times_used", "d"."max_uses" as "share_max_uses" from "directus_sessions" as "s" left join "directus_users" as "u" on "s"."user" = "u"."id" left join "directus_shares" as "d" on "s"."share" = "d"."id" left join "directus_roles" as "r" on "r"."id" in ("u"."role", "d"."role") where "s"."token" = $1 and "s"."expires" >= $2 and ("d"."date_end" is null or "d"."date_end" >= $3) and ("d"."date_start" is null or "d"."date_start" <= $4) limit $5 [MeIKneMJWE02kU9MdY2Izkr62S-zSe4jtm_chkegFYDEUPPXRI1JF3k79d7hYoc-, Sun Mar 03 2024 13:58:27 GMT+0000 (Coordinated Universal Time), Sun Mar 03 2024 13:58:27 GMT+0000 (Coordinated Universal Time), Sun Mar 03 2024 13:58:27 GMT+0000 (Coordinated Universal Time), 1]
2024-03-03T13:58:28.740524431Z [13:58:28.020] TRACE: [4.472ms] update "directus_sessions" set "token" = $1, "expires" = $2 where "token" = $3 [I4e8Ej5Yc0mesK3Kow9UdjJytpPyS0Zxp9txhQqKIrm5O7FI1jRx9IMf-sMuZhPf, Sun Mar 10 2024 13:58:28 GMT+0000 (Coordinated Universal Time), MeIKneMJWE02kU9MdY2Izkr62S-zSe4jtm_chkegFYDEUPPXRI1JF3k79d7hYoc-]
2024-03-03T13:58:28.740686464Z [13:58:28.022] TRACE: [1.348ms] update "directus_users" set "last_access" = $1 where "id" = $2 [Sun Mar 03 2024 13:58:28 GMT+0000 (Coordinated Universal Time), de071886-10c5-497e-afd4-c9e227c045fb]
2024-03-03T13:58:29.183784546Z [13:58:29] GET /admin/settings/flows/ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7 304 6ms
2024-03-03T13:58:29.698470325Z [13:58:29] GET /extensions/sources/index.js 200 14ms
2024-03-03T13:58:29.700418900Z [13:58:29] POST /auth/refresh 200 24ms
2024-03-03T13:58:29.766472457Z [13:58:29.497] TRACE: [1.049ms] select "ip_access" from "directus_roles" where "id" is null limit $1 [1]
2024-03-03T13:58:29.769293719Z [13:58:29.507] TRACE: [0.761ms] select * from "directus_permissions" where "role" is null []
2024-03-03T13:58:29.769594484Z [13:58:29.629] TRACE: [0.911ms] select "ip_access" from "directus_roles" where "id" is null limit $1 [1]
2024-03-03T13:58:29.770059305Z [13:58:29.639] TRACE: [0.728ms] select * from "directus_permissions" where "role" is null []
2024-03-03T13:58:29.770882139Z [13:58:29.642] TRACE: [1.594ms] select "s"."expires" as "session_expires", "u"."id" as "user_id", "u"."first_name" as "user_first_name", "u"."last_name" as "user_last_name", "u"."email" as "user_email", "u"."password" as "user_password", "u"."status" as "user_status", "u"."provider" as "user_provider", "u"."external_identifier" as "user_external_identifier", "u"."auth_data" as "user_auth_data", "r"."id" as "role_id", "r"."admin_access" as "role_admin_access", "r"."app_access" as "role_app_access", "d"."id" as "share_id", "d"."item" as "share_item", "d"."role" as "share_role", "d"."collection" as "share_collection", "d"."date_start" as "share_start", "d"."date_end" as "share_end", "d"."times_used" as "share_times_used", "d"."max_uses" as "share_max_uses" from "directus_sessions" as "s" left join "directus_users" as "u" on "s"."user" = "u"."id" left join "directus_shares" as "d" on "s"."share" = "d"."id" left join "directus_roles" as "r" on "r"."id" in ("u"."role", "d"."role") where "s"."token" = $1 and "s"."expires" >= $2 and ("d"."date_end" is null or "d"."date_end" >= $3) and ("d"."date_start" is null or "d"."date_start" <= $4) limit $5 [I4e8Ej5Yc0mesK3Kow9UdjJytpPyS0Zxp9txhQqKIrm5O7FI1jRx9IMf-sMuZhPf, Sun Mar 03 2024 13:58:29 GMT+0000 (Coordinated Universal Time), Sun Mar 03 2024 13:58:29 GMT+0000 (Coordinated Universal Time), Sun Mar 03 2024 13:58:29 GMT+0000 (Coordinated Universal Time), 1]
2024-03-03T13:58:29.771306334Z [13:58:29.647] TRACE: [1.552ms] update "directus_sessions" set "token" = $1, "expires" = $2 where "token" = $3 [EIGsf6H90X11hW_cy92imgPG9uMKh1fKrR35Zmb3Ggemr1YfALXrRkvne_ikBYZB, Sun Mar 10 2024 13:58:29 GMT+0000 (Coordinated Universal Time), I4e8Ej5Yc0mesK3Kow9UdjJytpPyS0Zxp9txhQqKIrm5O7FI1jRx9IMf-sMuZhPf]
2024-03-03T13:58:29.771701515Z [13:58:29.649] TRACE: [1.172ms] update "directus_users" set "last_access" = $1 where "id" = $2 [Sun Mar 03 2024 13:58:29 GMT+0000 (Coordinated Universal Time), de071886-10c5-497e-afd4-c9e227c045fb]
2024-03-03T13:58:29.772090384Z [13:58:29.726] TRACE: [1.246ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:29.773321003Z [13:58:29.752] TRACE: [0.985ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:29.774959286Z [13:58:29] GET /auth 304 27ms
2024-03-03T13:58:29.777607854Z [13:58:29.770] TRACE: [3.960ms] select "directus_settings"."project_name", "directus_settings"."project_descriptor", "directus_settings"."project_logo", "directus_settings"."project_color", "directus_settings"."default_appearance", "directus_settings"."default_theme_light", "directus_settings"."default_theme_dark", "directus_settings"."theme_light_overrides", "directus_settings"."theme_dark_overrides", "directus_settings"."default_language", "directus_settings"."public_foreground", "directus_settings"."public_favicon", "directus_settings"."public_note", "directus_settings"."custom_css", "directus_settings"."public_background", "directus_settings"."id" from "directus_settings" order by "directus_settings"."id" asc limit $1 [1]
2024-03-03T13:58:29.781882871Z [13:58:29.776] TRACE: [2.361ms] select "directus_files"."id", "directus_files"."type" from "directus_files" where 1 = $1 [0]
2024-03-03T13:58:29.784797768Z [13:58:29] GET /server/info 304 32ms
2024-03-03T13:58:29.911294562Z [13:58:29.854] TRACE: [1.374ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:29.911622076Z [13:58:29.868] TRACE: [1.903ms] select "directus_translations"."language", "directus_translations"."key", "directus_translations"."value", "directus_translations"."id" from "directus_translations" where "directus_translations"."language" = $1 order by "directus_translations"."id" asc [en-US]
2024-03-03T13:58:29.912839270Z [13:58:29] GET /translations?fields[]=language&fields[]=key&fields[]=value&filter[language][_eq]=en-US&limit=-1 304 20ms
2024-03-03T13:58:29.976377541Z [13:58:29.940] TRACE: [0.896ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:29.976660381Z [13:58:29.955] TRACE: [3.278ms] select "directus_users"."id", "directus_users"."first_name", "directus_users"."last_name", "directus_users"."email", "directus_users"."password", "directus_users"."location", "directus_users"."title", "directus_users"."description", "directus_users"."tags", "directus_users"."language", "directus_users"."tfa_secret", "directus_users"."status", "directus_users"."token", "directus_users"."last_access", "directus_users"."last_page", "directus_users"."provider", "directus_users"."external_identifier", "directus_users"."auth_data", "directus_users"."email_notifications", "directus_users"."appearance", "directus_users"."theme_dark", "directus_users"."theme_light", "directus_users"."theme_light_overrides", "directus_users"."theme_dark_overrides", "directus_users"."avatar", "directus_users"."role" from "directus_users" where "directus_users"."id" = $1 order by "directus_users"."id" asc limit $2 [de071886-10c5-497e-afd4-c9e227c045fb, 100]
2024-03-03T13:58:29.976878720Z [13:58:29.957] TRACE: [0.499ms] select "directus_files"."id" from "directus_files" where 1 = $1 [0]
2024-03-03T13:58:29.976918244Z [13:58:29] GET /users/me?fields[]=*&fields[]=avatar.id&fields[]=role.admin_access&fields[]=role.app_access&fields[]=role.id&fields[]=role.enforce_tfa 200 24ms
2024-03-03T13:58:29.977153135Z [13:58:29.959] TRACE: [0.570ms] select "directus_roles"."admin_access", "directus_roles"."app_access", "directus_roles"."id", "directus_roles"."enforce_tfa" from "directus_roles" where "directus_roles"."id" in ($1) [d0238a22-ab93-4ea0-8748-08e17ce433e6]
2024-03-03T13:58:30.040721250Z [13:58:30.031] TRACE: [2.643ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.047034312Z [13:58:30.037] TRACE: [6.394ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.051345277Z [13:58:30.043] TRACE: [7.144ms] select "directus_permissions"."id", "directus_permissions"."role", "directus_permissions"."collection", "directus_permissions"."action", "directus_permissions"."permissions", "directus_permissions"."validation", "directus_permissions"."presets", "directus_permissions"."fields" from "directus_permissions" where "directus_permissions"."role" = $1 order by "directus_permissions"."id" asc [d0238a22-ab93-4ea0-8748-08e17ce433e6]
2024-03-03T13:58:30.062710292Z [13:58:30.049] TRACE: [6.239ms] select "directus_fields"."id", "directus_fields"."collection", "directus_fields"."field", "directus_fields"."special", "directus_fields"."interface", "directus_fields"."options", "directus_fields"."display", "directus_fields"."display_options", "directus_fields"."readonly", "directus_fields"."hidden", "directus_fields"."sort", "directus_fields"."width", "directus_fields"."translations", "directus_fields"."note", "directus_fields"."conditions", "directus_fields"."required", "directus_fields"."group", "directus_fields"."validation", "directus_fields"."validation_message" from "directus_fields" order by "directus_fields"."id" asc []
2024-03-03T13:58:30.063859439Z [13:58:30.056] TRACE: [0.888ms] SHOW server_version []
2024-03-03T13:58:30.072430283Z [13:58:30.069] TRACE: [12.346ms]
2024-03-03T13:58:30.072477712Z SELECT
2024-03-03T13:58:30.072484565Z con.contype AS type,
2024-03-03T13:58:30.072490015Z rel.relname AS table,
2024-03-03T13:58:30.072495145Z att.attname AS column,
2024-03-03T13:58:30.072500365Z frel.relnamespace::regnamespace::text AS foreign_key_schema,
2024-03-03T13:58:30.072506016Z frel.relname AS foreign_key_table,
2024-03-03T13:58:30.072511055Z fatt.attname AS foreign_key_column,
2024-03-03T13:58:30.072516124Z CASE
2024-03-03T13:58:30.072521254Z WHEN con.contype = 'p' THEN pg_get_serial_sequence(att.attrelid::regclass::text, att.attname) != ''
2024-03-03T13:58:30.072526704Z ELSE NULL
2024-03-03T13:58:30.072534058Z END AS has_auto_increment
2024-03-03T13:58:30.072541612Z FROM
2024-03-03T13:58:30.072548805Z pg_constraint con
2024-03-03T13:58:30.072556279Z LEFT JOIN pg_class rel ON con.conrelid = rel.oid
2024-03-03T13:58:30.072563693Z LEFT JOIN pg_class frel ON con.confrelid = frel.oid
2024-03-03T13:58:30.072571138Z LEFT JOIN pg_attribute att ON att.attrelid = con.conrelid AND att.attnum = con.conkey[1]
2024-03-03T13:58:30.072578521Z LEFT JOIN pg_attribute fatt ON fatt.attrelid = con.confrelid AND fatt.attnum = con.confkey[1]
2024-03-03T13:58:30.072586507Z WHERE con.connamespace IN ('public'::regnamespace)
2024-03-03T13:58:30.072593890Z AND array_length(con.conkey, 1) <= 1
2024-03-03T13:58:30.072599631Z AND (con.confkey IS NULL OR array_length(con.confkey, 1) = 1)
2024-03-03T13:58:30.072605202Z
2024-03-03T13:58:30.072610221Z
2024-03-03T13:58:30.072615110Z []
2024-03-03T13:58:30.105155501Z [13:58:30.085] TRACE: [28.839ms]
2024-03-03T13:58:30.105192751Z SELECT
2024-03-03T13:58:30.105196398Z att.attname AS name,
2024-03-03T13:58:30.105198833Z rel.relname AS table,
2024-03-03T13:58:30.105201198Z rel.relnamespace::regnamespace::text as schema,
2024-03-03T13:58:30.105203462Z att.atttypid::regtype::text AS data_type,
2024-03-03T13:58:30.105205686Z NOT att.attnotnull AS is_nullable,
2024-03-03T13:58:30.105221997Z
2024-03-03T13:58:30.105224441Z CASE WHEN att.attgenerated = 's' THEN pg_get_expr(ad.adbin, ad.adrelid) ELSE null END AS generation_expression,
2024-03-03T13:58:30.105226875Z CASE WHEN att.attgenerated = '' THEN pg_get_expr(ad.adbin, ad.adrelid) ELSE null END AS default_value,
2024-03-03T13:58:30.105229210Z att.attgenerated = 's' AS is_generated,
2024-03-03T13:58:30.105231494Z
2024-03-03T13:58:30.105233859Z CASE
2024-03-03T13:58:30.105236163Z WHEN att.atttypid IN (1042, 1043) THEN (att.atttypmod - 4)::int4
2024-03-03T13:58:30.105238517Z WHEN att.atttypid IN (1560, 1562) THEN (att.atttypmod)::int4
2024-03-03T13:58:30.105240852Z ELSE NULL
2024-03-03T13:58:30.105243156Z END AS max_length,
2024-03-03T13:58:30.105245410Z des.description AS comment,
2024-03-03T13:58:30.105247665Z CASE att.atttypid
2024-03-03T13:58:30.105249898Z WHEN 21 THEN 16
2024-03-03T13:58:30.105252123Z WHEN 23 THEN 32
2024-03-03T13:58:30.105254327Z WHEN 20 THEN 64
2024-03-03T13:58:30.105256521Z WHEN 1700 THEN
2024-03-03T13:58:30.105258775Z CASE WHEN atttypmod = -1 THEN NULL
2024-03-03T13:58:30.105261110Z ELSE (((atttypmod - 4) >> 16) & 65535)::int4
2024-03-03T13:58:30.105263624Z END
2024-03-03T13:58:30.105265899Z WHEN 700 THEN 24
2024-03-03T13:58:30.105268153Z WHEN 701 THEN 53
2024-03-03T13:58:30.105270367Z ELSE NULL
2024-03-03T13:58:30.105272581Z END AS numeric_precision,
2024-03-03T13:58:30.105274845Z CASE
2024-03-03T13:58:30.105277069Z WHEN atttypid IN (21, 23, 20) THEN 0
2024-03-03T13:58:30.105279394Z WHEN atttypid = 1700 THEN
2024-03-03T13:58:30.105281628Z CASE
2024-03-03T13:58:30.105283893Z WHEN atttypmod = -1 THEN NULL
2024-03-03T13:58:30.105286177Z ELSE ((atttypmod - 4) & 65535)::int4
2024-03-03T13:58:30.105288491Z END
2024-03-03T13:58:30.105290705Z ELSE null
2024-03-03T13:58:30.105292930Z END AS numeric_scale
2024-03-03T13:58:30.105295214Z FROM
2024-03-03T13:58:30.105301936Z pg_attribute att
2024-03-03T13:58:30.105307086Z LEFT JOIN pg_class rel ON att.attrelid = rel.oid
2024-03-03T13:58:30.105309461Z LEFT JOIN pg_attrdef ad ON (att.attrelid, att.attnum) = (ad.adrelid, ad.adnum)
2024-03-03T13:58:30.105311805Z LEFT JOIN pg_description des ON (att.attrelid, att.attnum) = (des.objoid, des.objsubid)
2024-03-03T13:58:30.105314199Z WHERE
2024-03-03T13:58:30.105316394Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:58:30.105318627Z
2024-03-03T13:58:30.105320811Z
2024-03-03T13:58:30.105323086Z AND rel.relkind = 'r'
2024-03-03T13:58:30.105325300Z AND att.attnum > 0
2024-03-03T13:58:30.105327595Z AND NOT att.attisdropped
2024-03-03T13:58:30.105329839Z ORDER BY rel.relname, att.attnum;
2024-03-03T13:58:30.105332103Z []
2024-03-03T13:58:30.121204042Z [13:58:30.103] TRACE: [1.674ms] SELECT oid FROM pg_proc WHERE proname = 'postgis_version' []
2024-03-03T13:58:30.125311036Z [13:58:30] GET /permissions?filter[role][_eq]=d0238a22-ab93-4ea0-8748-08e17ce433e6 304 22ms
2024-03-03T13:58:30.125606639Z [13:58:30.115] TRACE: [1.396ms] select * from "directus_fields" []
2024-03-03T13:58:30.137526936Z [13:58:30] GET /fields 304 94ms
2024-03-03T13:58:30.254058479Z [13:58:30.213] TRACE: [4.306ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.255233172Z [13:58:30.217] TRACE: [4.852ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.255428428Z [13:58:30.224] TRACE: [6.696ms] select "directus_presets"."id", "directus_presets"."bookmark", "directus_presets"."user", "directus_presets"."role", "directus_presets"."collection", "directus_presets"."search", "directus_presets"."layout", "directus_presets"."layout_query", "directus_presets"."layout_options", "directus_presets"."refresh_interval", "directus_presets"."filter", "directus_presets"."icon", "directus_presets"."color" from "directus_presets" where "directus_presets"."user" = $1 order by "directus_presets"."id" asc [de071886-10c5-497e-afd4-c9e227c045fb]
2024-03-03T13:58:30.256842080Z [13:58:30.226] TRACE: [5.304ms]
2024-03-03T13:58:30.256850596Z SELECT
2024-03-03T13:58:30.256853732Z rel.relnamespace::regnamespace::text AS schema,
2024-03-03T13:58:30.256856197Z rel.relname AS name,
2024-03-03T13:58:30.256858541Z des.description AS comment
2024-03-03T13:58:30.256860855Z FROM
2024-03-03T13:58:30.256863110Z pg_class rel
2024-03-03T13:58:30.256865444Z LEFT JOIN pg_description des ON rel.oid = des.objoid AND des.objsubid = 0
2024-03-03T13:58:30.256867859Z WHERE
2024-03-03T13:58:30.256880462Z rel.relnamespace IN ('public'::regnamespace)
2024-03-03T13:58:30.256882836Z
2024-03-03T13:58:30.256885101Z AND rel.relkind = 'r'
2024-03-03T13:58:30.256887385Z ORDER BY rel.relname
2024-03-03T13:58:30.256889569Z []
2024-03-03T13:58:30.261451636Z [13:58:30.227] TRACE: [3.420ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.261467055Z [13:58:30.235] TRACE: [2.345ms] select "directus_presets"."id", "directus_presets"."bookmark", "directus_presets"."user", "directus_presets"."role", "directus_presets"."collection", "directus_presets"."search", "directus_presets"."layout", "directus_presets"."layout_query", "directus_presets"."layout_options", "directus_presets"."refresh_interval", "directus_presets"."filter", "directus_presets"."icon", "directus_presets"."color" from "directus_presets" where ("directus_presets"."role" = $1 and "directus_presets"."user" is null) order by "directus_presets"."id" asc [d0238a22-ab93-4ea0-8748-08e17ce433e6]
2024-03-03T13:58:30.261472535Z [13:58:30.237] TRACE: [10.047ms] select "directus_collections"."collection", "directus_collections"."icon", "directus_collections"."note", "directus_collections"."display_template", "directus_collections"."hidden", "directus_collections"."singleton", "directus_collections"."translations", "directus_collections"."archive_field", "directus_collections"."archive_app_filter", "directus_collections"."archive_value", "directus_collections"."unarchive_value", "directus_collections"."sort_field", "directus_collections"."accountability", "directus_collections"."color", "directus_collections"."item_duplication_fields", "directus_collections"."sort", "directus_collections"."group", "directus_collections"."collapse", "directus_collections"."preview_url", "directus_collections"."versioning" from "directus_collections" order by "directus_collections"."collection" asc []
2024-03-03T13:58:30.261477986Z [13:58:30.240] TRACE: [4.357ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.261481342Z [13:58:30.246] TRACE: [2.196ms] select "directus_presets"."id", "directus_presets"."bookmark", "directus_presets"."user", "directus_presets"."role", "directus_presets"."collection", "directus_presets"."search", "directus_presets"."layout", "directus_presets"."layout_query", "directus_presets"."layout_options", "directus_presets"."refresh_interval", "directus_presets"."filter", "directus_presets"."icon", "directus_presets"."color" from "directus_presets" where ("directus_presets"."role" is null and "directus_presets"."user" is null) order by "directus_presets"."id" asc []
2024-03-03T13:58:30.261485640Z [13:58:30.250] TRACE: [4.234ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.276829789Z [13:58:30] GET /presets?filter[user][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&limit=-1 304 18ms
2024-03-03T13:58:30.289016997Z [13:58:30] GET /presets?filter[role][_eq]=d0238a22-ab93-4ea0-8748-08e17ce433e6&filter[user][_null]=true&limit=-1 304 15ms
2024-03-03T13:58:30.289894131Z [13:58:30] GET /collections 304 27ms
2024-03-03T13:58:30.290159589Z [13:58:30] GET /presets?filter[role][_null]=true&filter[user][_null]=true&limit=-1 304 13ms
2024-03-03T13:58:30.294482688Z [13:58:30.266] TRACE: [11.711ms] select "directus_settings"."id", "directus_settings"."project_name", "directus_settings"."project_url", "directus_settings"."project_color", "directus_settings"."project_logo", "directus_settings"."public_foreground", "directus_settings"."public_background", "directus_settings"."public_note", "directus_settings"."auth_login_attempts", "directus_settings"."auth_password_policy", "directus_settings"."storage_asset_transform", "directus_settings"."storage_asset_presets", "directus_settings"."custom_css", "directus_settings"."storage_default_folder", "directus_settings"."basemaps", "directus_settings"."mapbox_key", "directus_settings"."module_bar", "directus_settings"."project_descriptor", "directus_settings"."default_language", "directus_settings"."custom_aspect_ratios", "directus_settings"."public_favicon", "directus_settings"."default_appearance", "directus_settings"."default_theme_light", "directus_settings"."theme_light_overrides", "directus_settings"."default_theme_dark", "directus_settings"."theme_dark_overrides" from "directus_settings" order by "directus_settings"."id" asc limit $1 [1]
2024-03-03T13:58:30.294697741Z [13:58:30.268] TRACE: [19.738ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.300515774Z [13:58:30.280] TRACE: [13.695ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.300762246Z [13:58:30.286] TRACE: [12.973ms] select "directus_relations"."id", "directus_relations"."many_collection", "directus_relations"."many_field", "directus_relations"."one_collection", "directus_relations"."one_field", "directus_relations"."one_collection_field", "directus_relations"."one_allowed_collections", "directus_relations"."junction_field", "directus_relations"."sort_field", "directus_relations"."one_deselect_action" from "directus_relations" order by "directus_relations"."id" asc []
2024-03-03T13:58:30.304154529Z [13:58:30] GET /settings 304 24ms
2024-03-03T13:58:30.317134494Z [13:58:30.296] TRACE: [15.648ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.317427673Z [13:58:30.301] TRACE: [14.862ms] select "directus_dashboards"."id", "directus_dashboards"."name", "directus_dashboards"."icon", "directus_dashboards"."note", "directus_dashboards"."date_created", "directus_dashboards"."user_created", "directus_dashboards"."color" from "directus_dashboards" order by "directus_dashboards"."name" asc []
2024-03-03T13:58:30.317605918Z [13:58:30.309] TRACE: [12.160ms]
2024-03-03T13:58:30.317615656Z SELECT
2024-03-03T13:58:30.317618992Z con.conname AS constraint_name,
2024-03-03T13:58:30.317621637Z rel.relname AS table,
2024-03-03T13:58:30.317624001Z att.attname AS column,
2024-03-03T13:58:30.317626336Z frel.relnamespace::regnamespace::text AS foreign_key_schema,
2024-03-03T13:58:30.317640923Z frel.relname AS foreign_key_table,
2024-03-03T13:58:30.317643268Z fatt.attname AS foreign_key_column,
2024-03-03T13:58:30.317645702Z CASE con.confupdtype
2024-03-03T13:58:30.317647936Z WHEN 'r' THEN
2024-03-03T13:58:30.317650150Z 'RESTRICT'
2024-03-03T13:58:30.317661843Z WHEN 'c' THEN
2024-03-03T13:58:30.317664207Z 'CASCADE'
2024-03-03T13:58:30.317666411Z WHEN 'n' THEN
2024-03-03T13:58:30.317668605Z 'SET NULL'
2024-03-03T13:58:30.317670819Z WHEN 'd' THEN
2024-03-03T13:58:30.317673044Z 'SET DEFAULT'
2024-03-03T13:58:30.317675277Z WHEN 'a' THEN
2024-03-03T13:58:30.317677592Z 'NO ACTION'
2024-03-03T13:58:30.317680046Z ELSE
2024-03-03T13:58:30.317682381Z NULL
2024-03-03T13:58:30.317684585Z END AS on_update,
2024-03-03T13:58:30.317686819Z CASE con.confdeltype
2024-03-03T13:58:30.317689043Z WHEN 'r' THEN
2024-03-03T13:58:30.317691287Z 'RESTRICT'
2024-03-03T13:58:30.317693502Z WHEN 'c' THEN
2024-03-03T13:58:30.317695716Z 'CASCADE'
2024-03-03T13:58:30.317697940Z WHEN 'n' THEN
2024-03-03T13:58:30.317700154Z 'SET NULL'
2024-03-03T13:58:30.317702368Z WHEN 'd' THEN
2024-03-03T13:58:30.317704572Z 'SET DEFAULT'
2024-03-03T13:58:30.317706807Z WHEN 'a' THEN
2024-03-03T13:58:30.317709051Z 'NO ACTION'
2024-03-03T13:58:30.317711285Z ELSE
2024-03-03T13:58:30.317713499Z NULL
2024-03-03T13:58:30.317715713Z END AS on_delete
2024-03-03T13:58:30.317717928Z FROM
2024-03-03T13:58:30.317720112Z pg_constraint con
2024-03-03T13:58:30.317722356Z LEFT JOIN pg_class rel ON con.conrelid = rel.oid
2024-03-03T13:58:30.317724640Z LEFT JOIN pg_class frel ON con.confrelid = frel.oid
2024-03-03T13:58:30.317726974Z LEFT JOIN pg_attribute att ON att.attrelid = con.conrelid AND att.attnum = con.conkey[1]
2024-03-03T13:58:30.317729349Z LEFT JOIN pg_attribute fatt ON fatt.attrelid = con.confrelid AND fatt.attnum = con.confkey[1]
2024-03-03T13:58:30.317734308Z WHERE con.connamespace IN ('public'::regnamespace)
2024-03-03T13:58:30.317736583Z AND array_length(con.conkey, 1) <= 1
2024-03-03T13:58:30.317739047Z AND (con.confkey IS NULL OR array_length(con.confkey, 1) = 1)
2024-03-03T13:58:30.317741432Z AND con.contype = 'f'
2024-03-03T13:58:30.317743736Z
2024-03-03T13:58:30.317745970Z []
2024-03-03T13:58:30.317930587Z [13:58:30.311] TRACE: [9.954ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.326550203Z [13:58:30.316] TRACE: [5.538ms] select "directus_panels"."id", "directus_panels"."dashboard", "directus_panels"."name", "directus_panels"."icon", "directus_panels"."color", "directus_panels"."show_header", "directus_panels"."note", "directus_panels"."type", "directus_panels"."position_x", "directus_panels"."position_y", "directus_panels"."width", "directus_panels"."height", "directus_panels"."options", "directus_panels"."date_created", "directus_panels"."user_created" from "directus_panels" order by "directus_panels"."dashboard" asc []
2024-03-03T13:58:30.326749587Z [13:58:30.320] TRACE: [8.186ms] select "directus_panels"."dashboard", "directus_panels"."id" from "directus_panels" where "directus_panels"."dashboard" in ($1) order by "directus_panels"."id" asc limit $2 [62637208-fe04-4689-9e16-a4df08d7ed2d, 25000]
2024-03-03T13:58:30.342531086Z [13:58:30.324] TRACE: [7.359ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.342749696Z [13:58:30.330] TRACE: [9.727ms] select "directus_flows"."id", "directus_flows"."name", "directus_flows"."icon", "directus_flows"."color", "directus_flows"."description", "directus_flows"."status", "directus_flows"."trigger", "directus_flows"."accountability", "directus_flows"."options", "directus_flows"."operation", "directus_flows"."date_created", "directus_flows"."user_created" from "directus_flows" order by "directus_flows"."id" asc []
2024-03-03T13:58:30.349018623Z [13:58:30] GET /relations 304 63ms
2024-03-03T13:58:30.351747251Z [13:58:30] GET /panels?fields[]=*&sort[]=dashboard&limit=-1 304 42ms
2024-03-03T13:58:30.352041243Z [13:58:30.336] TRACE: [6.923ms] select count("directus_notifications"."id") as "count->id" from "directus_notifications" where ("directus_notifications"."recipient" = $1 and "directus_notifications"."status" = $2) limit $3 [de071886-10c5-497e-afd4-c9e227c045fb, inbox, 100]
2024-03-03T13:58:30.352208307Z [13:58:30] GET /dashboards?fields[]=*&sort[]=name&limit=-1 304 67ms
2024-03-03T13:58:30.352551821Z [13:58:30.339] TRACE: [8.023ms] select "directus_operations"."id", "directus_operations"."name", "directus_operations"."key", "directus_operations"."type", "directus_operations"."position_x", "directus_operations"."position_y", "directus_operations"."options", "directus_operations"."resolve", "directus_operations"."reject", "directus_operations"."flow", "directus_operations"."date_created", "directus_operations"."user_created" from "directus_operations" where "directus_operations"."flow" in ($1, $2, $3, $4, $5) order by "directus_operations"."id" asc limit $6 [0699eae5-21d0-4c5d-b9fd-c90c61376b0a, 06b00c7c-245d-4066-9b7e-e63c9a57b6aa, 1d133b1b-8a66-445d-8074-2c3ad6c38f3b, e749a5da-2ea8-4f5e-a55e-844118c2d698, ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7, 25000]
2024-03-03T13:58:30.352990433Z [13:58:30] GET /notifications?filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox&aggregate[count]=id 304 31ms
2024-03-03T13:58:30.353416923Z [13:58:30] GET /flows?fields[]=*&fields[]=operations.*&limit=-1 304 53ms
2024-03-03T13:58:30.481943454Z [13:58:30.419] TRACE: [1.768ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.482346169Z [13:58:30.430] TRACE: [4.728ms] select "directus_translations"."language", "directus_translations"."key", "directus_translations"."value", "directus_translations"."id" from "directus_translations" where "directus_translations"."language" = $1 order by "directus_translations"."id" asc [en-US]
2024-03-03T13:58:30.483171126Z [13:58:30] GET /translations?fields[]=language&fields[]=key&fields[]=value&filter[language][_eq]=en-US&limit=-1 304 17ms
2024-03-03T13:58:30.610469453Z [13:58:30.579] TRACE: [1.074ms] select "ip_access" from "directus_roles" where "id" is null limit $1 [1]
2024-03-03T13:58:30.610689425Z [13:58:30.590] TRACE: [4.222ms] select * from "directus_permissions" where "role" is null []
2024-03-03T13:58:30.643289340Z [13:58:30.602] TRACE: [10.982ms] select "storage_asset_presets", "storage_asset_transform" from "directus_settings" limit $1 [1]
2024-03-03T13:58:30.643799196Z [13:58:30.615] TRACE: [25.002ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.644216418Z [13:58:30.622] TRACE: [27.242ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.645181488Z [13:58:30.629] TRACE: [30.450ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.649902483Z [13:58:30.637] TRACE: [15.725ms] select count("directus_notifications"."id") as "countDistinct->id" from "directus_notifications" where ("directus_notifications"."recipient" = $1 and "directus_notifications"."status" = $2) limit $3 [de071886-10c5-497e-afd4-c9e227c045fb, inbox, 100]
2024-03-03T13:58:30.650243472Z [13:58:30.639] TRACE: [10.500ms] select count("directus_notifications"."id") as "countDistinct->id" from "directus_notifications" limit $1 [100]
2024-03-03T13:58:30.650573190Z [13:58:30.640] TRACE: [37.902ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:30.650948765Z [13:58:30.648] TRACE: [11.239ms] select "directus_notifications"."id", "directus_notifications"."subject", "directus_notifications"."message", "directus_notifications"."collection", "directus_notifications"."item", "directus_notifications"."timestamp" from "directus_notifications" where ("directus_notifications"."recipient" = $1 and "directus_notifications"."status" = $2) order by "directus_notifications"."timestamp" desc limit $3 [de071886-10c5-497e-afd4-c9e227c045fb, inbox, 25]
2024-03-03T13:58:30.686720598Z [13:58:30.661] TRACE: [1.664ms] select "project_logo", "public_background", "public_foreground", "public_favicon" from "directus_settings" limit $1 [1]
2024-03-03T13:58:30.687232117Z [13:58:30.682] TRACE: [2.829ms] select "directus_files"."id", "directus_files"."storage", "directus_files"."filename_disk", "directus_files"."filename_download", "directus_files"."title", "directus_files"."type", "directus_files"."folder", "directus_files"."uploaded_by", "directus_files"."uploaded_on", "directus_files"."modified_by", "directus_files"."modified_on", "directus_files"."charset", "directus_files"."filesize", "directus_files"."width", "directus_files"."height", "directus_files"."duration", "directus_files"."embed", "directus_files"."description", "directus_files"."location", "directus_files"."tags", "directus_files"."metadata", "directus_files"."focal_point_x", "directus_files"."focal_point_y" from "directus_files" where "directus_files"."id" = $1 order by "directus_files"."id" asc limit $2 [d8a475c5-bb8b-4762-96e5-09d247064eca, 1]
2024-03-03T13:58:30.695365923Z [13:58:30.691] TRACE: [44.287ms] select count("directus_revisions"."id") as "count->id" from "directus_revisions" left join "directus_activity" as "zcjzt" on "directus_revisions"."activity" = "zcjzt"."id" where ("directus_revisions"."collection" = $1 and "directus_revisions"."item" = $2 and "directus_revisions"."version" is null and "zcjzt"."action" = $3) limit $4 [directus_flows, ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7, run, 100]
2024-03-03T13:58:30.739931318Z [13:58:30] GET /notifications?filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox&aggregate[countDistinct]=id 304 51ms
2024-03-03T13:58:30.741758084Z [13:58:30] GET /notifications?aggregate[countDistinct]=id 304 47ms
2024-03-03T13:58:30.742102250Z [13:58:30] GET /notifications?limit=25&fields[]=id&fields[]=subject&fields[]=message&fields[]=collection&fields[]=item&fields[]=timestamp&sort[]=-timestamp&page=1&filter[_and][0][recipient][_eq]=de071886-10c5-497e-afd4-c9e227c045fb&filter[_and][1][status][_eq]=inbox 304 52ms
2024-03-03T13:58:30.742454350Z [13:58:30] GET /revisions?filter[_and][0][collection][_eq]=directus_flows&filter[_and][1][item][_eq]=ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7&filter[_and][2][version][_null]=true&filter[_and][3][activity][action][_eq]=run&aggregate[count]=id 304 94ms
2024-03-03T13:58:30.742746418Z [13:58:30] GET /assets/d8a475c5-bb8b-4762-96e5-09d247064eca 200 118ms
2024-03-03T13:58:31.209183774Z [13:58:31.052] TRACE: [1.137ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:31.209359032Z [13:58:31.070] TRACE: [0.858ms] update "directus_users" set "last_page" = $1 where "id" in ($2) [/settings/flows/ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7, de071886-10c5-497e-afd4-c9e227c045fb]
2024-03-03T13:58:31.253965154Z [13:58:31] PATCH /users/me/track/page 204 59ms
2024-03-03T13:58:35.276605337Z [13:58:34.425] TRACE: [1.200ms] select "ip_access" from "directus_roles" where "id" = $1 limit $2 [d0238a22-ab93-4ea0-8748-08e17ce433e6, 1]
2024-03-03T13:58:35.795614846Z [13:58:35.616] TRACE: [1182.109ms] select "directus_revisions"."id", "directus_revisions"."data", "directus_revisions"."delta", "directus_revisions"."collection", "directus_revisions"."item", "directus_revisions"."activity" from "directus_revisions" left join "directus_activity" as "jwftt" on "directus_revisions"."activity" = "jwftt"."id" where ("directus_revisions"."collection" = $1 and "directus_revisions"."item" = $2 and "directus_revisions"."version" is null and "jwftt"."action" = $3) order by "directus_revisions"."id" desc limit $4 [directus_flows, ed6033e5-b08d-4047-b5c8-d76fc3f1c5e7, run, 10]
2024-03-03T13:58:35.795919668Z [13:58:35.642] TRACE: [10.440ms] select "directus_activity"."action", "directus_activity"."timestamp", "directus_activity"."ip", "directus_activity"."user_agent", "directus_activity"."origin", "directus_activity"."user", "directus_activity"."id" from "directus_activity" where "directus_activity"."id" in ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) [7267, 7181, 7092, 6899, 6782, 6665, 6528, 6444, 6344, 6233]
2024-03-03T13:59:05.978846037Z 2024-03-03T13:59:05: PM2 log: App name:directus id:0 disconnected
2024-03-03T13:59:05.982603644Z 2024-03-03T13:59:05: PM2 log: App [directus:0] exited with code [0] via signal [SIGKILL]
2024-03-03T13:59:06.012891140Z 2024-03-03T13:59:05: PM2 error: Error caught while calling pidusage
2024-03-03T13:59:06.017845923Z 2024-03-03T13:59:06: PM2 log: 0 application online, retry = 3
2024-03-03T13:59:06.017879676Z 2024-03-03T13:59:06: PM2 error: Error: ESRCH: no such process, read
2024-03-03T13:59:08.046576092Z 2024-03-03T13:59:08: PM2 log: 0 application online, retry = 2
from directus.
Heya! There isn't enough information available to keep investigating this issue at present time, so it'll be closed until more information becomes available. Thanks!
from directus.
Related Issues (20)
- Boolean default value = false is not working HOT 2
- Hard refresh on Admin App logout session and breaks app until container restart HOT 4
- Flows HOT 2
- Project name with colon in it breaks client mail sender parsing HOT 1
- Missing authentication() in documentation Home HOT 3
- Undefined address in the logs for websocket
- MariaDB errors on introspection HOT 2
- Nextjs 14 documentation issue HOT 3
- SDK: prettify rest command output type in IDE HOT 2
- LDAP autorization dosn't work HOT 2
- Migration Error: Missing `uploaded_on` Field in `directus_files` Table After Update to 11.0.2 HOT 2
- LDAP authentication error with INVALID_CREDENTIALS HOT 4
- Allow static prefix / suffix on input-translated-string interface
- z-index issue for translation-drawer on bookmark creation / editing HOT 1
- Can't preselect "Archive" value on bookmarks HOT 1
- Language-Fallback on custom translations HOT 3
- Block editor image attributes such as "Stretch image" are buggy in admin UI HOT 2
- Race condition in api/websocket dispatch subscription handler
- Existing field relationship is overwritten when new field with the same name is created. HOT 1
- REST API create empty content when "Content-Type" header is not defined
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from directus.