Big query: error "Read timed out", when query executed via DASHBOARD

Get Help
1

Image:

image
image2970×878 146 KB

Error:

:parameters [],
  :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true}},
 :status :failed,
 :class java.net.SocketTimeoutException,
 :stacktrace
 ["java.base/java.net.SocketInputStream.socketRead0(Native Method)"
  "java.base/java.net.SocketInputStream.socketRead(Unknown Source)"
  "java.base/java.net.SocketInputStream.read(Unknown Source)"
  "java.base/java.net.SocketInputStream.read(Unknown Source)"
  "java.base/sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)"
  "java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)"
  "java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(Unknown Source)"
  "java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(Unknown Source)"
  "java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(Unknown Source)"
  "java.base/java.io.BufferedInputStream.fill(Unknown Source)"
  "java.base/java.io.BufferedInputStream.read1(Unknown Source)"
  "java.base/java.io.BufferedInputStream.read(Unknown Source)"
  "java.base/sun.net.www.http.HttpClient.parseHTTPHeader(Unknown Source)"
  "java.base/sun.net.www.http.HttpClient.parseHTTP(Unknown Source)"
  "java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)"
  "java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)"
  "java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)"
  "java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)"
  "com.google.api.client.http.javanet.NetHttpResponse.<init>(NetHttpResponse.java:36)"
  "com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:152)"
  "com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:84)"
  "com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1012)"
  "com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:565)"
  "com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:506)"
  "com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:616)"
  "com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.queryRpc(HttpBigQueryRpc.java:771)"
  "com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1373)"
  "com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1370)"
  "com.google.api.gax.retrying.DirectRetryingExecutor.submit(DirectRetryingExecutor.java:102)"
  "com.google.cloud.bigquery.BigQueryRetryHelper.run(BigQueryRetryHelper.java:86)"
  "com.google.cloud.bigquery.BigQueryRetryHelper.runWithRetries(BigQueryRetryHelper.java:49)"
  "com.google.cloud.bigquery.BigQueryImpl.queryRpc(BigQueryImpl.java:1369)"
  "com.google.cloud.bigquery.BigQueryImpl.query(BigQueryImpl.java:1357)"
  "--> driver.bigquery_cloud_sdk$execute_bigquery$fn__123933.invoke(bigquery_cloud_sdk.clj:600)"],
 :card_id nil,
 :context :ad-hoc,
 :error "Read timed out",
 :row_count 0,
 :running_time 0,
 :data {:rows [], :cols []}}
2

What query are you running exactly? Are you sure metabase is able to execute that query?

What happens when you query your DB directly? and how long does it take

3

@TonyC When this query was working it was taking 5 mins to execute

Below is the query we executed:

SELECT
codexId,
ARRAY_TO_STRING(
ARRAY(
SELECT JSON_EXTRACT_SCALAR(icd, '$'),
FROM UNNEST(JSON_EXTRACT_ARRAY(summary.contextInfo.providerCharges)) AS pcs,
UNNEST(JSON_EXTRACT_ARRAY(pcs.icdCiphers)) AS icd
), ', '
) AS ICDs,
ARRAY_TO_STRING(
ARRAY(
SELECT JSON_EXTRACT_SCALAR(VC, '$.type'),
FROM UNNEST(JSON_EXTRACT_ARRAY(summary.contextInfo.visit.classifications)) AS VC
), ', '
) AS VCs,
ARRAY_TO_STRING(
ARRAY(
SELECT DISTINCT JSON_VALUE(IMOC, '$'),
from
unnest(json_extract_array(summary.freeTextData)) as FT,
UNNEST(JSON_EXTRACT_ARRAY(FT, '$.templateElements')) AS TEMPLATE,
UNNEST(JSON_EXTRACT_ARRAY(TEMPLATE, '$.imoCodes')) AS IMOC
where
json_value(TEMPLATE, '$.type') = 'DIAGNOSIS'
and json_value(FT,'$.section') in ('ASSESSMENT_PLAN', 'PLAN')
),
', '
) AS DX
FROM
us-ar-liv-11.codex_molecules.molecules_data
WHERE
(TIMESTAMP_TRUNC(created_at, DAY) = TIMESTAMP("2024-12-04")
OR
TIMESTAMP_TRUNC(created_at, DAY) = TIMESTAMP("2024-12-09"))
and codexId in
(
'codex_2024120412305338645dbsbd8dfdee0888c054a60',
'codex_20241204122923983811a064c67af06e403e',
'codex_20241204122546976413b42366f939ae4d33',
'codex_20241204122547170791d4cac8f1d8a1482f',
'codex_202412041231182bnsdb8188811632b02352c406d',
'codex_20241204122949375648299ffe015377438d',
'codex_20241204122757584460996bff42c1c7456c',
'codex_2024120412293247154655f18c7b507b4652',
'codex_2024120bwbebnw41229413854234503bf52ecb34ae2',
'codex_20241204123023588812ef18bb78c6104860',
'codex_202412041228472841867c6830a377a24727',
'codex_20241204hjewhje122839382226537376b3a10d4aae',
'codex_202412041229216924360d29affdd9bd4132',
'codex_20241204122606589794fcda47d8ef0641cb',
'codex_2024120hhwhhj412270278850293a3c4905e6b4014',
'codex_20241204122921532913f0622368663b467b',
'codex_20241204123023886325db557ab0e88d4046',
'codex_2024120412255028017781bccf20cc024ba3',
'codex_20241204hjqehjqehj1230256812144a45ae49f27b423f',
'codex_202412041229262552649ab21748a1f24e4f',
'codex_20241204122934378802ee8552c649274eff',
'codex_202412041225500597157cdd885b510a4b82',
'codex_20241204123023575292797c217c66884e41',
'codex_20241204122603479309a27bed8226f34879',
'codex_2024120412303047349288fcd479ae3a4856',
'codex_2024120412305378155755184e9a21ab4268',
'codex_202412041225501802206386cc74754d43d3',
'codex_2024120hjehj41225534873136ae70cec17724681',
'codex_2024120412255799021219f29b31993247ca',
'codex_202412041225596737532593469e52dc41ed',
'codex_202412041230355846139170df2f65ca4ba1',
'codex_20241204123045574560d85935125e78444b',
'codex_20241204122551579932a9dd0a41673f4354',
'codex_20241204123045641763850724d994fb4f11',
'codex_20241204122716273101e9873a0aa7204096',
'codex_20241204123109378514a86bf0f7c70b419d',
'codex_20241204123117076799a168e31fe2c04007',
'codex_20241204123120389108ee278f0f35b4493e',
'codex_202412041231311796755d76d55538164fdd',
'codex_202412041231350794645df9cdf01cb64e7f',
'codex_20241204123023584909f004332b51b44589',
'codex_202412041230405716288f0eb08ef6fd451d',
'codex_2024120412304667688206ce20f79553475d',
'codex_202412041231026882962dd82491fc1949f3',
'codex_20241204123126179703c71d57ea9eb1410f',
'codex_20241204123128055991ffcfc7ced8a54704',
'codex_2024120412261127587521826466a78a4d68',
'codex_20241204123125893933afd6c884ad954459',
'codex_2024120412313005616769fab74c197546cb',
'codex_202412041227259939011d3f8a5ef0274a2c',
'codex_2024120412274507817fec75548ed594506',
'codex_202412041227464794796960492fa836490e',
'codex_2024120412274258076263af68328e8d45d3',
'codex_202412041227447873514c2888aff2864a90',
'codex_20241204122757373762eb9fc74e720b4e54',
'codex_20241204122758691485b175bf9280924cde',
'codex_202412041227336605650b915fa7a0884805',
'codex_20241204122806080435fdbed5c9ff2d47b3',
'codex_2024120412280189061041a4ba936b9d469c',
'codex_202412041228012811103c0c3c27e78f494e',
'codex_20241204122807656501ce27025c279d48bc',
'codex_202412041228140908865f0466b8f7d54554',
'codex_20241204122808478805377d30660b904b03',
'codex_202412041228103812497d9f09905e3d4e59',
'codex_20241204122811372862d70e084d630e4fc4',
'codex_20241204122929975799c3b7f0db18f94253',
'codex_202412041228167788425673a7f306f446bd',
'codex_2024120412282048413d6638da5acd546a9',
'codex_20241204122840674835cfac574087054da9',
'codex_20241204122848183325c15c4c934099481a',
'codex_2024120412285298992113857990b3a44b2c',
'codex_202412041228551896702dd0dec974d84580',
'codex_202412041228596796596a17eaf6cd5d40f7',
'codex_202412041228560541853dde78b1a60245f1',
'codex_20241204122856853612c8909bf9f3a64c0e',
'codex_20241204122910345620ec119d3f878147ba',
'codex_202412041229029424501448e6add2574a29',
'codex_202412041229050823696e2b908653dd433f',
'codex_20241204122908555719a9f0e284265746b5',
'codex_2024120412291738264521c0cea5b6d24b58',
'codex_20241204122923172397d03b8eb25e024821',
'codex_20241204122926593987b41c17d5ff694c0f',
'codex_2024120412292847119391451cfc89841c5',
'codex_20241204122933853545f6b32165e5dd42d2',
'codex_20241204122930654875f4c29b4c7e674b7d',
'codex_20241204122934583525c578e7913def4cf9',
'codex_20241204122935378572e277ef0075d441f3',
'codex_2024120412293777913867948fcd49e847f4',
'codex_202412041229483798688a4d58875e594536',
'codex_2024120412294769025829205c9261ce42ad',
'codex_202412041230005388571d00f2df7bd4481e',
'codex_20241204123003410214fa5bfde368f34fcb',
'codex_20241204123002040315b0fef771e70c4089',
'codex_20241204123002844354268f9c824be44d79',
'codex_202412041230040332269a872f4e22d34a96',
'codex_2024120412301274582261a51bb31fd54d34',
'codex_2024120412301409181068c9abcc6f404a07',
'codex_202412041230185331923203e7b93feb4dfa',
'codex_2024120412301850926478610c7eb8a64fa9',
'codex_20241204123119286576e138a1bc59bf43a2',
'codex_20241204123022932411b0c249cf4f594393',
'codex_20241204123022687500a8b8362f39f44145',
'codex_202412041230330817948183e72d27be4bb7',
'codex_2024120412303509571260df2974979348d7',
'codex_202412041230406703223eec63bbbf8f4b4f',
'codex_202412041230372755993402c4032c104783',
'codex_20241204123041757333b056296cf1024eb5',
'codex_2024120412304044383720c061c41cfd4a98',
'codex_20241204123047980554e296eebb6614404c',
'codex_202412041230471725223a9f3cc55e3b4401',
'codex_202412041230469823814cf6c9a50b6b48a2',
'codex_20241204123050540832b9c816ddfd804383',
'codex_2024120412305178779c12a94be709c4e85',
'codex_20241204123055090658b97a1a3d6d0a4a2d',
'codex_20241204123056984808d571009934df4f58',
'codex_202412041230570418453886ccd483944ff8',
'codex_202412041230565766475e0219bc85194d4d',
'codex_20241204123101490374a86022ef9449447b',
'codex_20241204123058884233439c01e238f64523',
'codex_2024120412310145664894ba00ba901c429a',
'codex_2024120412310998097945f5657730394971',
'codex_20241204123108674296aca4d118cc1541b9',
'codex_20241204123120087749e3d3f5ed6ea443e2',
'codex_20241204123121535916409f17790cd3444a',
'codex_20241204123113086715e97e3328f1544868',
'codex_202412041231170909721370dca4a7884cae',
'codex_2024120412311989924771d4f182cf6541f7',
'codex_20241204123122995747897e6b06b2954cbb',
'codex_202412041231233322642b14ab8217944210',
'codex_20241204123126374886184e75979f544baa',
'codex_20241204123127071400c67f8f33a4164dcc',
'codex_20241204123125687249f3d1defc06954984',
'codex_2024120412313079411820dd7c8e8fb4460f',
'codex_202412041231318904249633457a8b914230',
'codex_202412041231363912136cd699d182e446b0',
'codex_202412041231362747117ad86a767d3f4ee8',
'codex_20241204123136047394bbf8c03758a84f39',
'codex_2024120412313888519942f7636bc5f6404b',
'codex_20241204123139790192e6de7c13df014156',
'codex_20241204123140295711a7ac342379334cf0',
'codex_2024120412314258011759e9f5f5fba84dad',
'codex_20241204123144490325e9402ceb56a84c28',
'codex_20241204123145657319a8c9a961ecda479f',
'codex_202412041231463835293a1cf951564a45dc',
'codex_20241204123147742466875436811da4939',
'codex_20241204123147708861d4bdc60fb7ce437a',
'codex_202412041226033773587c9bd6f04de64cf7',
'codex_2024120412255675722201d0c1d645ad4dc6',
'codex_202412041226084824086711c0e212414b16',
'codex_2024120412261227163099e598eeac59408e',
'codex_2024120412261597064782ff845dd38b4b49',
'codex_2024120412262215245029e1355eacca4526',
'codex_2024120412262567830195b2d36725014a6b',
'codex_2024120412263447790507bff10bb4894d87',
'codex_2024120412263328836822196527f73f4e5a',
'codex_20241204122639283302567da4f9af464595',
'codex_20241204122631771387f98d8e2ff1d9436e',
'codex_202412041226420557735a41c5cd21434409',
'codex_20241204122649455434389073d2681d4ca9',
'codex_202412041226463803301a649164f4a84ccc',
'codex_20241204122659673220b525afff148e48ca',
'codex_202412041227029849409c9240e82a8b4a58',
'codex_20241204122706784401a4748967b41d4c60',
'codex_20241204122706087545e2a56911bd0c4d05',
'codex_20241204123005384546fea424ea197f4483',
'codex_20241204122608789276abae5fbdb76c42f8',
'codex_202412041226257800b20f40c7d48e4698',
'codex_20241204122621989159cde2d05d54444c0f',
'codex_20241204122555272188d95455a8cf9640bc',
'codex_2024120412271427828002e9d9730ee44650',
'codex_202412041225574899792c78467a19114919',
'codex_202412041226039849913999bae76744a49',
'codex_20241204122604774239406034df7ac7444e',
'codex_20241204122714182824638f23ae33c14dc8',
'codex_202412041230570532728356beb7a5474632',
'codex_2024120412261178924887117f2312784e62',
'codex_2024120412314843475705e9a05de8b644c2',
'codex_202412041226114758163d405d7573b0466e',
'codex_20241204122748851585d22ee78855984788',
'codex_20241204122613779748138012b250e545f6',
'codex_20241204122615987347029ad24a5f1c4308',
'codex_20241204122924781639408e03a0e2d94aaa',
'codex_20241204122556274919fd619df500134491',
'codex_202412041230060002171f43451805e04ee2',
'codex_20241204123000570255de03178d85024cca',
'codex_202412041229115321805d99570359514c60',
'codex_20241204122920554511e0a2d3db9b4e4788',
'codex_20241204123127600217cc8be6fc6a954cae',
'codex_20241204123132046163d686f088a0c94f78',
'codex_202412041225531878741cf4c0afaa6944f2',
'codex_202412041226070779146572a42a5c754742',
'codex_20241204122614953614d54d65cd9f394f51',
'codex_20241204123000182926801b74d41d594c17',
'codex_20241204122808476349007d77fe67be4b44',
'codex_2024120412281777926651d64be6eb634817',
'codex_2024120412272368254183e4167995dc4e1c',
'codex_2024120412272277628515f62272aa8b4639',
'codex_2024120412282147052030a106026be84691',
'codex_20241204122841784834a8948a82a277411d',
'codex_2024120412290550830210c62ee053b54b78',
'codex_202412041230380904738c98e892a63f4f30',
'codex_202412041231117085356010afdece7d4980',
'codex_2024120412302637989683b58256afca41ab',
'codex_2024120412303589076079fa05e7a1294219',
'codex_2024120412304135560229f928d228a64c69',
'codex_202412041231039844355970d91e4ca048e0',
'codex_202412041231273523100a55e385d8844dea',
'codex_20241204123124775166a8deb8bf752c4877',
'codex_20241204123147881158773ff647680140f3',
'codex_202412041230549478285115d40f9dff4208',
'codex_20241204122655579138fbba450671c54b65',
'codex_20241204123053911228c53557a8c82449dd',
'codex_20241204122852747647d246f876d36048bf',
'codex_20241204122731112699db71f94f092840c8',
'codex_202412041225472553237c7c59544f2b4928',
'codex_202412041231260118932a6832187ed4a68',
'codex_2024120412293729183606bd96014f684f14',
'codex_20241204123131048914bc45d2088152470d',
'codex_20241204122640085459ea964f75bfed4e5e',
'codex_2024120412261597395745f53d1a08414c06',
'codex_2024120412291051013619f0a48e23894195',
'codex_20241204122724678755d04ee8ca31d24170',
'codex_2024120412313408814594964339b5c348eb',
'codex_20241204122812389824c7d20ad7c66d4fb3',
'codex_202412041228578537005791ed155e11492a',
'codex_20241204122948989220b960fe63ad16431c',
'codex_20241204123100209185f47ce1a51031476a',
'codex_20241204123133655938e3b3201988ea4402',
'codex_20241204123143539189a4e7073c6bc4632',
'codex_20241204123106586668fecd986dd44d4a9c',
'codex_20241204122914044608b01f6920156549ee',
'codex_202412041227395859286301dd89dbf44992',
'codex_2024120412294060355606cb6842e9c643c3',
'codex_20241204123008482364190968bc54004abd',
'codex_20241204123031651967ed71e6db5c474b6b',
'codex_202412041231258464296cd53373e1a745da',
'codex_2024120412305197367875efba58e11e4cec',
'codex_20241204123101954200df63fead27b4b15',
'codex_202412041231442856528d519c7c4e93416d',
'codex_202412041227022752726cba26878e4d46c2',
'codex_2024120412313368780868ba7058415c45d7',
'codex_20241204122757554267089cf91b94174306',
'codex_20241204122959735615e4f413f813ef41b6',
'codex_20241204122804379334aadfb478599b4466',
'codex_20241204122952882169db1a4e9b256048c8',
'codex_20241204123138729573de2a0a4714314bff',
'codex_20241204122938185426b9058db774a24d8c',
'codex_202412041231154802620889537e5c2e43f6',
'codex_202412041226416524670b087199705445f7',
'codex_2024120412261387789257ecfb0950f48e9',
'codex_2024120412280528690248572f70d3114074',
'codex_20241204122810390183ce69616683ad4db8',
'codex_20241204123125008722483ece386f4e4df1',
'codex_2024120412292027486928a9dfa31a3d493d',
'codex_20241204122750374328a320ba4d6af34fcc',
'codex_202412041229154864080607e4ad69b64490',
'codex_202412041227565922911aa7bd7fea594ff5',
'codex_20241204122925358576e9970b5b2ec74176',
'codex_20241204122813877761bf0b76cf0c3c4fa4',
'codex_20241204123016690815dce1e7af8d64b6b',
'codex_20241204123052936998f44e9dfb9a1e4528',
'codex_2024120412284817770599dbb87f1cd24bf7',
'codex_2024120412314446228a0efcb51c32d4418',
'codex_202412041230239331542478ca2b1ee742f7',
'codex_20241204123105948325281b6f6ca25441ba',
'codex_202412041225470948444198068fe7944c6',
'codex_202412041227474727099ee4a186ed024dab',
'codex_20241204122756774271d5d80de64f9242b0',
'codex_2024120412275209217261772b4345b14308',
'codex_202412041229390869132aa86555adf74631',
'codex_20241204122900678585a45f8c9270e84689',
'codex_202412041228052865449ca3f5f0852b4587',
'codex_20241204122811551902ff2a6923bef4e46',
'codex_20241204122844055243dbc3334de55843f6',
'codex_20241204122805180772461f5ddf54024c5c',
'codex_2024120412284523611729d0f3573f1a4f50',
'codex_20241204122854290609bdeb6c64e3ed43f5',
'codex_20241204122943793923ea11325f9d744416',
'codex_202412041229187806153a7813a7efb2484d',
'codex_202412041229201898264c42d8cdb23a4896',
'codex_202412041230025774118926b982fbf14688',
'codex_202412041229594806448a6b522ab89b4af5',
'codex_202412041230297700e5ba4c204e494b1c',
'codex_20241204123139836604a6c4b3f26bca4c36',
'codex_20241204122606284783a9150c10e1194963',
'codex_202412041229552225119b22723565d6447c',
'codex_202412041229542902508bae5c91bf914f2a',
'codex_2024120412303398963458470541d775453c',
'codex_2024120412305825633563048a38344e4eb7',
'codex_2024120412302560969077cbd0def2364112',
'codex_2024120412305260834889fdf03906d44424',
'codex_20241204123047640543847014e4124a4f0b',
'codex_202412041230400091604c82a538eacf4a4d',
'codex_20241204123113586327e2d629dae966422a',
'codex_2024120412311308169ba5f76ec2fc74d13',
'codex_20241204123113377553e0db3002830648ea',
'codex_20241204123121979654cd0d43e983784bbc',
'codex_20241204123105573281e624abfe82d8425b',
'codex_202412041230594092876f146aa6b9f446ba',
'codex_2024120412273027463551f9137bd5b14a89',
'codex_2024120412271968285367a4adf45b3b4396',
'codex_2024120412275640215544c11c5905d14370',
'codex_2024120412275858499839e9230527ab4b59',
'codex_202412041228081816510482595600f340f9',
'codex_20241204122810390461d4bb8e6263a84cba',
'codex_20241204122815168797feca6b6a69714f9d',
'codex_2024120412281599440827385ec927384ce5',
'codex_2024120412285011265165f492a44df94036',
'codex_2024120412285057894500f0fe5cb0054903',
'codex_20241204122901400494f1261597b3d64eec',
'codex_202412041229100788583a1db8ebbbfe49af',
'codex_20241204122904772789dca3e7ec2deb4422',
'codex_2024120412291797836454c518f78e024935',
'codex_2024120412291728823c2cddbcc706a4b7e',
'codex_20241204122922185521073d386ba47b4546',
'codex_202412041229308861067b9f31bb190d4744',
'codex_2024120412293147462927cae60af7f745aa',
'codex_202412041229399734266007fa100b8a4c1b',
'codex_20241204122946679569102765cf743e4d8c',
'codex_202412041229535947719ed432973ac1476f',
'codex_2024120412295828891996234517b8af492b',
'codex_20241204123002653822a7164c88773e4828',
'codex_20241204123008906540d713f929ab524dd9',
'codex_20241204123012435379d8195c5ed78b4bbb',
'codex_20241204123018041803d3b1f1bd075f40e9',
'codex_2024120412302097530850243131ab794168',
'codex_20241204123027629397870852cc3f204d0d',
'codex_20241204123028489184bf496b52d4de4238',
'codex_20241204123032883283855f26100ff04ea9',
'codex_2024120412303839017475c286e74bd54da0',
'codex_202412041230423425373f06a8002f7245f4',
'codex_20241204123050071565493ab4de2bf44d14',
'codex_20241204123055943326ea3d9efe7d04a90',
'codex_2024120412305907088354a56925caf640b9',
'codex_20241204123055357714af5c8eca1414492',
'codex_20241204123106243600c73ba274f9eb4989',
'codex_202412041231081063954f4fae95969348ed',
'codex_20241204123110592244b6a91711f20b4122',
'codex_2024120412311429010724335643d4a74490',
'codex_20241204123113778925da764c728b6e4735',
'codex_202412041231124861813234e57085ff42dd',
'codex_20241204123118987746b9ad701d9e3b4c52',
'codex_20241204123123754885016955bac084e2b',
'codex_20241204123123676105e9ef8d38b5eb4223',
'codex_202412041231322467262d639bd080f84c8f',
'codex_202412041231303888727bbc03c94cc342e1',
'codex_20241204123136203424d92b5d0ce414583',
'codex_20241204123137393542e79e3f3d8e614f4a',
'codex_20241204123139944554fef1810d63664b6d',
'codex_202412041231433896737f6e3a8e150d4db3',
'codex_20241204122554084207ed28798ed12b44f1',
'codex_20241204122604651615a0dd3c419c274a70',
'codex_202412041226150714682d5f703775fb4399',
'codex_20241204122614093877f57647292d54283',
'codex_2024120412261818781cc8bf9867947447d',
'codex_2024120412261927794511f7981c2e614c04',
'codex_20241204122622190702c326ee6640884923',
'codex_2024120412262738038656dfe9ba7a0f46fd',
'codex_20241204122627883988ba5c7512b424465e',
'codex_20241204122649850685f4d2d6a15e3f4b6b',
'codex_20241204122712788767061eb6b6d6ed4ec2',
'codex_202412041225534884016d049c9d099e4b18',
'codex_2024120412271567033249aaad4c3260447f',
'codex_20241204122709798943cb5e379108bb485a',
'codex_2024120412264427755344a54a166539457f',
'codex_202412041227432917421e35ed8ab6a74aec',
'codex_2024120412294898743226002300847c4962',
'codex_20241204123018611870fdde08ab19a4914',
'codex_20241204123008196333d5a861a1628f4a24',
'codex_2024120412302164967501c37c6a16964757',
'codex_202412041230215882385ff751fc0fce4dd8',
'codex_202412041230206332074c7b83f0447146a3',
'codex_20241204123135991747244d9507837e400d',
'codex_20241209122954262495ba1a53559eaf42c5',
'codex_2024120912252518916f6edcd0710a343a9',
'codex_20241209122535391624a65df2b300c147eb',
'codex_20241209122731822748b04b39f5f8594659',
'codex_20241209122541412176ce6a1a56dafd4e6f',
'codex_20241209122531457576cf9d795564854e47',
'codex_2024120912253249266384ac851b0df94c8e',
'codex_202412091225288808309ea1a07a96024626',
'codex_20241209122530687807044bedf8d52444b',
'codex_20241209122530920237c2ad11d9316f4673',
'codex_20241209122528303944106aea2b7eb04728',
'codex_20241209122533809918215aaafc07024a03',
'codex_202412091225281874073749bd641cea429f',
'codex_202412091227291392528c79a78498954c70',
'codex_2024120912253386796ab74d622b66a4445',
'codex_20241209122539505908e68bbc0bc3044b0e',
'codex_2024120912253428222846d34578241148cb',
'codex_20241209122732387959059659d8d2204c33',
'codex_202412091225371917814a6adc955764384',
'codex_202412091225337736472c4da2437d8042f4',
'codex_2024120912294439328373064a07be484fc7',
'codex_2024120912273367680039106c383b074391',
'codex_2024120912273140679968d9c37711334c9b',
'codex_20241209122535374125bbaf63c7527d41ff',
'codex_20241209122928186601fd7851323fc34535',
'codex_20241209122732988727649280bdd74443a0',
'codex_20241209122536172685ce9367a00e9642e6',
'codex_20241209122732076842ab3491688bf8419d',
'codex_20241209122541478180aa27f73002f346a5',
'codex_20241209122542084249990ba35523974a14',
'codex_20241209122538165680eb55dcd8a6f440c5',
'codex_202412091225368525ea02970c42fc4527',
'codex_202412091225400802573c9652f0bba448cd',
'codex_20241209122542766977b5f5ce52547b46a2',
'codex_20241209122541245494ca74168197294a6b',
'codex_2024120912253939967da9297845c84436a',
'codex_202412091225403932700db40672524a47f7',
'codex_202412091225398897264275433a0f64f55',
'codex_20241209122543003580d833a166a07c4a55',
'codex_20241209122549934101ff1de1239c81473f',
'codex_2024120912254213332028a300b51e7c4598',
'codex_20241209122727738859a0c45a9642d1498f',
'codex_20241209122545472794e6c847ebecdf4e4f',
'codex_20241209122543782709fedb998c3178434b',
'codex_202412091225468822812cd71792faba4c1d',
'codex_20241209122543712852c2be6ff18bbb435e',
'codex_2024120912254618162037f72f9c17d74660',
'codex_20241209122542511752632423c3f09d4b9b',
'codex_20241209122546183924acdee1af6bb84565',
'codex_2024120912254242899c77a122959ac42a0',
'codex_20241209122745599259c62d06b330a546d1',
'codex_202412091225469846123db6f92e4c92447a',
'codex_202412091227315832305a96156cc2f74091',
'codex_20241209122544884460aa7e94d1af2f45eb',
'codex_2024120912265708496872e563a9eb0249e2',
'codex_20241209122549391644d4ca221bcc174d4f',
'codex_20241209122550791297be1156d45c974fe5',
'codex_2024120912275734842fc636ddbdc304bac',
'codex_20241209122731697192c52752b264924d45',
'codex_202412091225497861563bdb7a9d85c4371',
'codex_202412091225470532930cd53c891d2f4fad',
'codex_202412091225520968956231f8739b7d4b1c',
'codex_2024120912273245622387ec9839babb4331',
'codex_202412091225522178977c434f6faa544d02',
'codex_2024120912255431526937da5cadbc3d43f3',
'codex_202412091227348937989f264c547ed54483',
'codex_2024120912255848312d2f2bd37bc0749fc',
'codex_20241209122552088809d7be4d9d9ea848f3',
'codex_202412091225522613273d9694f329c4619',
'codex_202412091227335498179dcf06d012cc42c6',
'codex_2024120912255589799709fd51d6689042c9',
'codex_20241209122733281674408a1a79672e4f24',
'codex_202412091227597842701025b8a857fd43e1',
'codex_20241209122557175153639b20dbc28f4dce',
'codex_202412091225541474946dee324a35f14279',
'codex_20241209122555998483200d5cdc0ecc49f1',
'codex_20241209122557282205dd9cc9a8e8284125',
'codex_202412091227356115716161478a61e543f5',
'codex_2024120912255717257798ee584f872547c0',
'codex_202412091227360942014eeb0fc0c7ba4e11',
'codex_20241209122557542704303e8fbc0b084fbb',
'codex_202412091225594847016e330fc7ef874775',
'codex_20241209122602492811f7e28eec42194582',
'codex_20241209122658091889fad4114c75ca40ed',
'codex_20241209122601015254faafc5e67dfe4ff7',
'codex_202412091229289094595e0a3ccef75e4dab',
'codex_202412091225478986860e0a2ab569c140b3',
'codex_20241209122748994669bcf704de189542a4',
'codex_202412091225583353911b1fa8f6ced7455a',
'codex_202412091226127023090ebc3057f0ef4a68',
'codex_20241209122601882552fbeca67896ea4212',
'codex_20241209122602066649e926a83690be4807',
'codex_2024120912255787546380a189b7f9f943b0',
'codex_202412091227462776875d51b815c2b54077',
'codex_2024120912274681195d7e85177a45344b0',
'codex_202412091226033102108d947d5886324466',
'codex_202412091226051764436a631609af7646d6',
'codex_2024120912260147044608aeaa5a1010470f',
'codex_2024120912261618112720fd02da31654006',
'codex_202412091226016975319f85822cd914474b',
'codex_2024120912255957939941c04baf38664aec',
'codex_20241209122603335979268395c99ed5497d',
'codex_202412091226015719572e6a34a2fdb147a4',
'codex_20241209122606188787d666a26ecb5e4119',
'codex_20241209122613299288ceea098d57664d72',
'codex_202412091226177038717238b16d46814cd3',
'codex_202412091226013202787b43e43870b5418f',
'codex_20241209122601466642d9670378be044e14',
'codex_20241209122606858150f618797a7e9b4852',
'codex_2024120912260609768fa9b6ab14f7c4c1f',
'codex_202412091226048834847db615e7f1404f64',
'codex_202412091226013438089cfb884e359b4ba2',
'codex_202412091226078926351608a25fe5c644d6',
'codex_2024120912260811148835186a4d769b4f80',
'codex_20241209122931089974f4907a10675e4fd5',
'codex_202412091226054512547c2398c2d35e444b',
'codex_20241209122558307400e6028c0c1c694927',
'codex_202412091226038721858ad72ff32d57495e',
'codex_202412091226086813293578e71bf92049c6',
'codex_202412091226079814791a9a13f2a80a4ce9',
'codex_20241209122733195765bacf6d8d235d4792',
'codex_20241209122733247316ce79d82ddf7f4a95',
'codex_202412091226022807747d0d6787fe294292',
'codex_202412091226120141880b635c14db84c6a',
'codex_20241209122800935531da89be5996e74566',
'codex_202412091226068901953c97c2cbb83949d7',
'codex_20241209122611744717cc62e1aa894240aa',
'codex_20241209122607440892c98c0decae194bed',
'codex_202412091227010722dd95b1ff222e4935',
'codex_20241209122611135832572d6fe9b34e4fcc',
'codex_202412091226126486890bceee6a69c43c8',
'codex_202412091226086498886308d7816174b9c',
'codex_2024120912261566694188845874d2d2433c',
'codex_2024120912260770911137f58ecc1f214ecb',
'codex_2024120912260973955594e9ebb120fb4064',
'codex_2024120912270260352135dacbe4812b4744',
'codex_202412091226105783409942ec76624e4dd3',
'codex_20241209122612393426b3d287bd7e2c4bc8',
'codex_202412091226152118763f2eb73dbed84e84',
'codex_2024120912273599664283d3bc071aed4c72',
'codex_2024120912261249576601516c50e20c4016',
'codex_20241209122612186388003f215eceff4f69',
'codex_20241209122614474345b403c252278c41eb',
'codex_20241209122610876286b5916a7ad29348c6',
'codex_2024120912261519459247ea0e19962147bd',
'codex_20241209122613977867268ec3e950164d2e',
'codex_20241209122617910286af793331cac9494b',
'codex_20241209122616075862ef35022645664b3e',
'codex_20241209122734476620ade4deaa81b24d43',
'codex_20241209122617201769f74e67ae3e534879',
'codex_20241209122612610872859464d2d1ec4660',
'codex_20241209122619451416728bea718b374e4b',
'codex_20241209122618566268480f75bf89104934',
'codex_202412091226181103890ac20139a9ff4679',
'codex_20241209122618105453882938847eef4306',
'codex_202412091226163855353e89a7e9a8654947',
'codex_2024120912261814896807b1598058a84eb7',
'codex_20241209122625880151686f9d57d9064bd2',
'codex_2024120912261513333441989945462044b1',
'codex_2024120912261448413188b6c9ad4c7f46c1',
'codex_202412091226197853430a702a85a2194861',
'codex_20241209122734145517997599cd2ac54a98',
'codex_2024120912262020687971114d0f917c4fde',
'codex_202412091226213122998abceed804344650',
'codex_202412091226203785021f6e4f957b1447c6',
'codex_202412091226260737166b70e51e12334dc1',
'codex_202412091226255785989bc05330ecb645cc',
'codex_2024120912262048996317b486a61ca64ab9',
'codex_202412091226225739616514f373a8804a6c',
'codex_20241209122734885697fdcae38165b24a7d',
'codex_202412091226229921714e22300ad88f46db',
'codex_20241209122621788127e3c586903d1a4d4b',
'codex_202412091227336959273ee4ff56cd7b4156',
'codex_20241209122736458990250284f713314f28',
'codex_202412091226210847089180a6bbbd4c4f3d',
'codex_202412091227357988823e48b2591374319',
'codex_20241209122638103596251355c2f810411a',
'codex_20241209122621502307a04a23d0e7854e01',
'codex_202412091227319053780a94fded11214728',
'codex_2024120912273984878150a994208b864194',
'codex_20241209122626497276a85bd60b38cd47cd',
'codex_2024120912262328078199e8d8801eb4f83',
'codex_2024120912262622030c587ea0b3b9c440f',
'codex_202412091226238032597b87975d5bd64133',
'codex_20241209122642988477f8a196adeb49427d',
'codex_2024120912264259340013be5dec22a5491c',
'codex_2024120912262721487047ffca8f27974975',
'codex_202412091226297827525e63e84285004489',
'codex_202412091226312131732e94c523768c48dd',
'codex_2024120912263390863878935dd1204449e0',
'codex_20241209122930066793c5e2dc3a15b44c73',
'codex_20241209122626321484d6c831e5f4b140f8',
'codex_20241209122734711555d639207cccbc474a',
'codex_20241209122736879569965210fefa48434b',
'codex_202412091226276085742b645dd5189e4cd6',
'codex_202412091226266321946f80407bbc0b4acf',
'codex_20241209122631873946fd2509977f7c47e8',
'codex_202412091229301337630227d4e1acf547d6',
'codex_20241209122643276915a4144a252e3c4f5c',
'codex_202412091226285013559f67627b02ac4657',
'codex_2024120912262401193204bb08b7b4854ba9',
'codex_20241209122626577172a34d49fcc4614e30',
'codex_20241209122630901878163b4239fbf845e9',
'codex_20241209122646377341f6cbffa9290d4f0a',
'codex_202412091226296046964a0eca90f1624ff2',
'codex_20241209123002301303629683ff2aef4a43',
'codex_20241209122738285478013d0e6a682b4972',
'codex_202412091226323967551aa7ae75b4d24070',
'codex_2024120912263113526446b4a7762a6e41c6',
'codex_2024120912263444432628e32a537db44b3a',
'codex_20241209122625848408eee8bb04f6734ac1',
'codex_202412091226285044458872df569f6e40ad',
'codex_202412091226314856784abc19b1f33947e8',
'codex_20241209122634300737942123c04cc94d38',
'codex_20241209122631277220571a82874ba847a3',
'codex_20241209122635311543fc78b65e3e8244d5',
'codex_2024120912262949180502caf158fb024baa',
'codex_2024120912263355028f81844fe3c844f3',
'codex_20241209122628466595a34d2ae040484bb8',
'codex_20241209122632081553c60706bb366744a5',
'codex_20241209122635089821f42c857c02cf447c',
'codex_202412091226284614117fdd9a95124a4820',
'codex_202412091226356886444ecc70028d4d4128',
'codex_20241209122635070953945e525ea8b74d3d',
'codex_202412091226325034051e5dbfa3e8464731',
'codex_20241209122635483251951b0e0b7f1140b0',
'codex_20241209122638041713be7dc4f7e5804394',
'codex_2024120912263503414065d7276992674229',
'codex_20241209122634895392caec811c4fdc4b05',
'codex_2024120912263448344df6ece948aeb4ce6',
'codex_20241209122634008225a2aeaf3149f040c3',
'codex_20241209122749778369aa34aa3234824692',
'codex_20241209122636092346b0b4368017ed4a17',
'codex_2024120912263647563576c6f5ed7a6c4d55',
'codex_20241209122642145461da3d4d67f4124c20',
'codex_20241209122701687947d62f02c497f946c4',
'codex_202412091226364757125a690d4b0a80478b',
'codex_202412091229547699daa521f14b3f4873',
'codex_20241209122638757228e8ecfee4f5ad490d',
'codex_20241209122639562118976bf054284e4045',
'codex_20241209122637373490c067958feb04f74',
'codex_2024120912270319223051ee571a9a794f50',
'codex_202412091226370412098d74a1ab4506497d',
'codex_202412091229468663306362e300840841ac',
'codex_20241209122638473414e5f1189ed4604b2f',
'codex_202412091226395808656364b9c0849d4c47',
'codex_20241209122639889457c056a3919b104fed',
'codex_20241209122641014853168cefa765c640ff',
'codex_20241209122640210261d9eb96c7b6a54d69',
'codex_20241209122641318745aced0deb5bd44281',
'codex_20241209122638208541b94e3fa965754bc2',
'codex_202412091226454515572fba2d3a8d784437',
'codex_2024120912264263726965747fe12e0546bb',
'codex_20241209122734799103153edfd433024f34',
'codex_2024120912264498561261fc9e770dc5495d',
'codex_202412091227023781388acc3a9ac3f740f9',
'codex_2024120912264078586825ed212f4d944659',
'codex_202412091226434039510f95b8d31b214196',
'codex_202412091226454364396c7d1d0fa0034e4c',
'codex_202412091226470826488c610ec83c8341f6',
'codex_20241209122646078354b45c7e6028654fbf',
'codex_20241209122644835926de9d895888d34587',
'codex_20241209122738072187b945e5be6cbf4d9a',
'codex_20241209122644184537838e8e4a0df844f5',
'codex_202412091227400885449a082d6c931c48f7',
'codex_2024120912274614096403e2dff7b9c04712',
'codex_2024120912280844320851298d1284be4e1e',
'codex_202412091226482366197b1a4bb6fd864c0b',
'codex_202412091226459835797c29e0e2eda64778',
'codex_202412091226515996351974911b99d84454',
'codex_202412091226472951073203feb81e534987',
'codex_20241209122955390310f5c9654147ab4131',
'codex_20241209122648789125308edc1f34db4775',
'codex_2024120912274989025098aa6029700e4efb',
'codex_2024120912264878752317cc18fcbd2244f3',
'codex_20241209122644916882608fa3a3e1dc4260',
'codex_2024120912265229238303af875202a04f35',
'codex_20241209122742668589cbd5e9e79b4643b2',
'codex_20241209122645388584933105cacf1c4cdf',
'codex_202412091226551752302c9e8964f569426d',
'codex_20241209122733633213cc920a76b87b4711',
'codex_202412091228100875352433f2b2fef8403d',
'codex_20241209122651166632da945cda0fb4922',
'codex_20241209122646654756210cad7dc74e4088',
'codex_2024120912265050941063f2d6d2310f4c40',
'codex_20241209122650435981e98d1a01389749bc',
'codex_202412091226493723716f7da03904ce4924',
'codex_202412091227017564480d750ff1c18345c2',
'codex_202412091226537759542cccb739dc43406f',
'codex_2024120912265608566f5ce494a7c68425a',
'codex_202412091227034905748e969412ebf24d05',
'codex_20241209122710503249a0a5e6ea3a5e4447',
'codex_202412091226549181958d6d8d9c4bb2460e',
'codex_20241209122654005436617e9108ad334367',
'codex_20241209122659279460610c67a522dd4476',
'codex_202412091227078722938176c33aebce4e05',
'codex_20241209122653847516a10c02e377e4471b',
'codex_20241209122658654233b7e04285652a4457',
'codex_2024120912265730956201586f5f57aa4e41',
'codex_20241209122706388348389c00f2bf6a4b5e',
'codex_202412091226569892590fe261766a614992',
'codex_202412091227369921495bf32d9d6d2446d8',
'codex_20241209122657935102321b9f791fd9487b',
'codex_2024120912265961545232d4af2b5cc242bb',
'codex_202412091226585385744d1cdf57c534981',
'codex_20241209122658770668f59e419fba3d4573',
'codex_20241209122742290143c979b0f359354e01',
'codex_2024120912274187992432cc63324ed346fe',
'codex_2024120912273946280362528497226d4fd3',
'codex_20241209122657855969750778fea29a461d',
'codex_2024120912270227514986ede9bccf4d51',
'codex_20241209122742478171c0cdf84e46af4ba0',
'codex_202412091227008246782ebf943fd2a744fb',
'codex_2024120912265851650fa8925e9e00344c5',
'codex_202412091227026451585cae4fb25674c75',
'codex_20241209122700960760d250a495cc58495f',
'codex_202412091227385829321d63f60ee4e5499e',
'codex_2024120912274183582633f475eb51b34b67',
'codex_20241209122740156141875a1d249434b04',
'codex_2024120912274170022455cf81b727814887',
'codex_2024120912292988177f93863b87a344034',
'codex_20241209123002449767d76ae033d0646d9',
'codex_202412091227004943484e3cd7795c2b44a1',
'codex_20241209122658659270cef874824f034f3a',
'codex_202412091227006584891b38af3f472940aa',
'codex_202412091227439614818d698f8974db40d9',
'codex_202412091227036941205a06861433794411',
'codex_202412091227028857198115c174b7424453',
'codex_202412091227050891278fd2e53ab3f4f1f',
'codex_20241209122945605544cb13de1602c44d75',
'codex_202412091227015274910516c3ce092c4086',
'codex_202412091227429156420f2d18224a7748b4',
'codex_202412091227027948849d115d3a31104f34',
'codex_202412091227048779804e35789fce2143e7',
'codex_202412091227038147295a3507b461d94dd9',
'codex_202412091227042339779a2b9acbe28f4e17',
'codex_20241209122706495515cc9b3db30e4e4b68',
'codex_202412091227100749521d000835d514557',
'codex_202412091227082772168390bc1f0aa541e8',
'codex_202412091227068977792196982ec6964958',
'codex_202412091227110886930620ae992674407',
'codex_202412091227076789685b439c9430e54f28',
'codex_2024120912270761733cb8b6d002daa4978',
'codex_20241209123004396553d42d3c9d10514fa3',
'codex_20241209122708213922ade3f8c777204616',
'codex_2024120912271007530313006789d69c40a3',
'codex_20241209122814434665672aa13343fc4251',
'codex_20241209122710306265bab574960e5c419f',
'codex_202412091228584108478f2037da077c41bf',
'codex_2024120912293116193793c89b3f2af64830',
'codex_2024120912271069648ef38e76fee904865',
'codex_202412091227118885677a2f486748f4717',
'codex_202412091227100709404d7777e6945f47f8',
'codex_2024120912271299236bbf67bc4f6147e7',
'codex_202412091227145734451cc7090bae6c4e4f',
'codex_20241209122716413582c60d808ea506405d',
'codex_20241209122740311743cff3d7c859944c3f',
'codex_202412091227147909797c99756797024f06',
'codex_2024120912271189925954b36b07ed044549',
'codex_202412091227126362303271ecaf079749cd',
'codex_20241209122717179240c160ea013d0c4ee9',
'codex_20241209122712699958d1a8257a5eae4661',
'codex_2024120912274490563b1e968e334b444e9',
'codex_2024120912271048687599dda5162cff40fc',
'codex_20241209122714146718e5e1c48753444c0b',
'codex_202412091227124341695dd7cd9e41eb4239',
'codex_202412091227141715e6dc9d2a767143ac',
'codex_202412091227119045754f61660f3d4844cb',
'codex_20241209122715361514a91b263e4e5f4ca0',
'codex_20241209122714855932f2f07789654f4798',
'codex_202412091227163416270cc919571ccc4cc6',
'codex_20241209122715611937f77f00785b2b4481',
'codex_202412091227153945350fe96015e2f24130',
'codex_20241209122714995890cc261c56fac4ebb',
'codex_202412091227157847640378a1fd488a4516',
'codex_202412091227132776942d6623519c8f45e4',
'codex_2024120912271703412417f930dc012e4e4f',
'codex_20241209122717489513a4300d1944134fab',
'codex_20241209122740657489c2dac34374640a7',
'codex_20241209122717491668f3d31e15db02408f',
'codex_20241209122713884204935dc526e16b43f2',
'codex_202412091227213527405df3b7e4250c4d70',
'codex_202412091227208659252ec3ba8a44c04edb',
'codex_20241209122744482411b55e8aa124f34c9e',
'codex_20241209122716680315ccece623e7c14768',
'codex_20241209122745275305f1c1a2450bd848a4',
'codex_20241209122718694323f9c9188146fd4b99',
'codex_20241209122716851136e90484f24d5648ff',
'codex_20241209122718057911214566856869469d',
'codex_202412091227144103341e7a1d76ad72402c',
'codex_202412091227183837505f31c28a7d354b33',
'codex_20241209122718553142243569eb536f41e3',
'codex_20241209122721090279b0260db8115a4dba',
'codex_202412091227222414449676c64eeb4840b8',
'codex_20241209122715892864b715b5cb7ed5420f',
'codex_202412091227224103126169e93e73fe48a4',
'codex_202412091227270918724f803f0d61184d41',
'codex_202412091227195656067c58aaaff7b9410a',
'codex_20241209122743683299db72a922e217482e',
'codex_2024120912274564389050810da5f0d340ba',
'codex_202412091227262753762c90fa1a345412b',
'codex_2024120912272044470055802316c7e04747',
'codex_2024120912272469446685e36a8a7a11472a',
'codex_2024120912272090849f4c9763b6b604265',
'codex_20241209122725973530797556bdcb314350',
'codex_202412091227253024601943507dda374665',
'codex_202412091227437088615de75438cc734867',
'codex_202412091227233825176797750781084aa5',
'codex_20241209122724465878a260e5688ed04266',
'codex_20241209122725983489d7890533c84b41a0',
'codex_202412091227249928286bfc96b101e14b9f',
'codex_20241209122728182405ce401bbc2e64130',
'codex_202412091227255441890a8b948f862845ae',
'codex_20241209122727946250a1ef1abf5c6a4dc7',
'codex_20241209122746608885bfbc5ff2b8c74dfc',
'codex_202412091227298955524f6a7adaa822441b',
'codex_20241209122747108694bd3253917ca546d4',
'codex_20241209122743634881052dc67e5e26458a',
'codex_2024120912273127687406080df26f3d4152',
'codex_20241209122742341905e80bb68240f2411d',
'codex_20241209122743638267b4f2c2dce7364d55',
'codex_20241209122750098383525a2431f204749',
'codex_20241209122929842793d5917aad705d4254',
'codex_2024120912274987415870a3a5a8cefa47c0',
'codex_202412091227504549745fbd7c999ada4117',
'codex_20241209122751588196124b9da05c3e4dde',
'codex_20241209122748615329e91f2092e4c64fc5',
'codex_20241209122751306953af89dc2b46824a92',
'codex_202412091227515037643ecd2ae4fe0c497f',
'codex_20241209122748540312c43575cdb5574969',
'codex_202412091227476585930197947991634d4f',
'codex_202412091227530116883b93bc9b77044d7e',
'codex_202412091229457896784a6a83e71aae4249',
'codex_202412091230056443376f0eebef596f4a0c',
'codex_20241209122756061640c92300d0f7dc45a8',
'codex_2024120912293367433075f5f3851cf64caf',
'codex_202412091227540947254d867b47a1cd4807',
'codex_202412091227549883441fcc63f50f264767',
'codex_20241209122754090813e1d9ee7a7fa44386',
'codex_20241209122755141642cff4430e893e4053',
'codex_20241209122754178610679f67be12894149',
'codex_2024120912275736544c21580c18b5f49ee',
'codex_202412091227563883557cf719550a0d4892',
'codex_2024120912275825674679a32e417c954715',
'codex_20241209122932767658f08f0292cd004032',
'codex_20241209122754385663c27a68d047e4d41',
'codex_202412091227541773217a8800264f6e45c9',
'codex_20241209122758202704fbc059cc58ff43ab',
'codex_20241209122756671833708fc23ade144083',
'codex_202412091227555745442479d49ae1854192',
'codex_202412091227592089565f11d1299a564021',
'codex_20241209122758056810da779d05f52f489d',
'codex_202412091227581115509b0f1d21d35c460b',
'codex_20241209122757802939128eec02797f4d6f',
'codex_20241209122756848794976b79b8f2574661',
'codex_20241209122757183568789ea59d115f43f0',
'codex_20241209122932901250ee90148a4ca44e16',
'codex_2024120912275979621eb3d1e6330be43fb',
'codex_2024120912275470159371ce433ce08e4a00',
'codex_20241209122758994975af60855a10f648e2',
'codex_20241209122913958655d2e3db2f9ef6463f',
'codex_202412091227568609656bcf760e015a4721',
'codex_2024120912280015344b3c12c7f3aea4d21',
'codex_202412091228009866236a4b059cb3e440a9',
'codex_20241209122801784448dcd6329a40d943e5',
'codex_20241209122758911153c87dd9bee7aa4c9e',
'codex_2024120912275857280178c1782346234ca7',
'codex_20241209122809779346f323ec1679974e40',
'codex_2024120912280159826c717ab8f0fa0419e',
'codex_202412091228026838365d834968ed7e4e95',
'codex_202412091228023624307e5775cfe7734807',
'codex_20241209122805373575976968854d0f4f74',
'codex_20241209122933083942b20e07f4b019439c',
'codex_20241209122932000451efc5ae28419940f3',
'codex_2024120912293233773205ecd8fa31b649aa',
'codex_202412091228020948101f7b169e69a74546',
'codex_20241209122803539366841470216b0d45fd',
'codex_20241209122932939596dc2b4f8c454b480a',
'codex_2024120912280297545250e0e5b71d7b42d7',
'codex_202412091228053448005bd24fa24dd34152',
'codex_20241209122929686263b9a8e7eb07a749fb',
'codex_202412091228020815518ed0eeb32df74d5e',
'codex_202412091228009873156837b2611c8c4ee0',
'codex_202412091228065387737e0bd2e2f10c4a28',
'codex_202412091229336339048c75f7a0d00e4670',
'codex_202412091229330753012edcb9659ca840fd',
'codex_20241209122935455998b951a853d5084066',
'codex_202412091229350828923a8908ef2e94873',
'codex_20241209122932462257aa476e8055d740dc',
'codex_202412091228030984085b6746f3d45e4da3',
'codex_2024120912293273418961393db29eb0484e',
'codex_20241209122935685827557971ceb8444d9f',
'codex_202412091228026181296c2204aa29dc4802',
'codex_202412091228040481030f3aab2220b74af7',
'codex_20241209122805882111dbe8b61c54a04661',
'codex_20241209122934983564987a0184e7be4810',
'codex_2024120912280966639589b1b83189ed449e',
'codex_20241209122911366463e7ba5b0f0a074088',
'codex_20241209122806367355cd80ae1c50764025',
'codex_20241209122808409876b8d45dafd56d483b',
'codex_2024120912281149066883641c57e54d4028',
'codex_202412091230073945775c0a7d6cea334a30',
'codex_2024120912291327018655ba6159d98c4fc5',
'codex_20241209122811593837faf4122dee5a492e',
'codex_202412091228066067701414d0bae0d041d4',
'codex_20241209122811796551e2c760d74894437d',
'codex_20241209122915310108119e7b764180403d',
'codex_20241209122915237665b138999331ff45a2',
'codex_202412091228097103281bf947ac058242d9',
'codex_202412091229142809064bdf1fd3861b4156',
'codex_202412091229118899309dffd46ceec1417e',
'codex_20241209122812564791ccf2c712c5254e2f',
'codex_20241209122813801333caea8397dfd2474a',
'codex_20241209122933582965d8a878e991694cac',
'codex_2024120912281887781991e9c0ada8294e4b',
'codex_20241209122811346151dfb540db8a16455d',
'codex_20241209122812386178e9e4792b288b4900',
'codex_202412091228193065664f2334523a6d416e',
'codex_20241209122935909426a8fbbdb791c419c',
'codex_20241209122810386324d8efebdc1bbc40ba',
'codex_202412091228131392718d83f99f741a4d51',
'codex_20241209122811908345281954210c314c58',
'codex_202412091228130967867871f34714464b33',
'codex_2024120912281355845349095790166645f2',
'codex_202412091228117081349a1b2054f6314283',
'codex_20241209122933650500a9a8a288e7a34eb1',
'codex_2024120912281093446539fd2c3bf4354a41',
'codex_202412091228146475682c255e39587a496c',
'codex_202412091228137726229b3174da7b0843dc',
'codex_202412091229356079380f33254572464706',
'codex_20241209122815875116fd84e672dea848de',
'codex_2024120912281240552159084071f117452f',
'codex_20241209122936540875a851335b9f55478f',
'codex_20241209122814874454d15973cd57df4c85',
'codex_20241209122934484699b76d1857fe364425',
'codex_202412091229344159515b7aaa9baa7448cb',
'codex_2024120912281550977546a761a0c8664732',
'codex_20241209122936961307aa26fe476c2e48e0',
'codex_20241209122815762786bfc753838f224d38',
'codex_2024120912281457634094e90f03894246f6',
'codex_20241209122817557201e7ed3699b36f4b04',
'codex_20241209122816480719277fd7023cd4760',
'codex_202412091228187913720a328c9c656d4e04',
'codex_202412091228198427174ff35039bd874f9e',
'codex_20241209122820380366c586a5f080bd4d29',
'codex_2024120912281759935446a1fd2cbea04240',
'codex_2024120912281723662303708fcaa6094965',
'codex_2024120912293743783368083f47f7a848ef',
'codex_202412091228164083161b769e221ad344e8',
'codex_202412091228169584557e48d1bf94784cca',
'codex_202412091228216833445b4479a135c64126',
'codex_202412091228224065570424f006a76e4f1c',
'codex_20241209122817549226071f4f6851824825',
'codex_2024120912281378810768ba25a906a94d4b',
'codex_2024120912281927373009d64c33629b4a09',
'codex_2024120912282318084bddd52f9e1b24141',
'codex_20241209122904412795fdc10f2b5d0645a7',
'codex_2024120912282200586322486d6d8732455c',
'codex_20241209122821890626bd7394489c664369',
'codex_202412091228238393796180aafa79b347b3',
'codex_202412091228205331879dad3f05f3a44235',
'codex_20241209122828305965c8419a30f0a14d49',
'codex_20241209122820081841e1c7b885f02f4a27',
'codex_202412091228217534905c1cb83df3c049ce',
'codex_202412091228241856698407a1013d554228',
'codex_20241209122824267362edb05035f53c4b19',
'codex_202412091228234993575dc1fd6c99b64889',
'codex_202412091228231112465cd43584f89d48a8',
'codex_20241209122823845246efa28c5a46d84222',
'codex_202412091228252959246fba99682eb8486f',
'codex_20241209122823457421b9b65a42be814bc5',
'codex_202412091228210946970150b0c2347a4086',
'codex_20241209122823091725093389810a3d44aa',
'codex_20241209122825402891f22a9d5b29274b66',
'codex_202412091225436819984ddba31c16064db1',

)

4

And how long does that take to run when you execute it directly on your DB?

5

it takes around 3 minutes if we execute query directly @TonyC

6

and how long does metabase take before you get the Read timed out

7

it timeout after 5 mins approx

8

is it possible big query is killing this question? There is a timeout setting or something of that sort

9

(post deleted by author)

10

Query timeout is not set in biqquery @TonyC

11

Then i am not sure but SocketTimeoutException seems to indicate something is killing the connection between metabase and bigquery

12

there is a lb between metabase and biq query where timeout is set to 12 min, is that could be the reason? @TonyC

13

No idea, you need to check the logs of this load balancer ... Maybe you're fetching too much data? Something is killing that connection, you need to troubleshoot the logs at every layer this query is passing