Unexplainable WDE0028 errors

Ask the community
,
1

I’m getting a lot of unexplainable WDE0028’s lately, in code that has been running for more than 2 years. The unexplainable part is this: same query (tru a job at 9:30 UTC0), same collection, same amount of rows (exchange rates, which get changed every friday for the last time at 20:30 UTC0 and for the first time again on Monday 15:30 UTC0).
The job on Saturday runs fine, the exactly same job with identical data on Sunday runs fine, the identical job on Monday returns WDE0028’s.
Anyone noticing likewise behaviour?

EDIT: additional info. Collection size on Sat, Sun, Mon 3259 items, 7 user type fields (date, text, num), query very inexpensive (select on 2 fields, date and type, first one carries descending index).
EDIT2: according to logs, it started on october 3, this year.

1 Like
2

Can you DM me with the affected site, some error messages/logs, and any other info you have?

3

Sure, if I knew where sending a DM is hidden in this app.

2 Likes
4

I’ll do it here then. Site: www.laguiadeines.com
Also, I’m suddenly getting all sorts of WDE0053’s. This never happened during the last 2 years. I fear something is wrong at Wix end, this is not normal.

Log overview: WDE0028 at the bottom. Please notice a lot of WDE0053’s since today.

DEFAULT 2023-10-30T16:48:23.961999893Z ["fnGetFuturesARS_fnWriteFutureRates = {\"msgType\":\"error\"}"]
DEFAULT 2023-10-30T16:48:23.959000110Z ["fnWriteFutureRates: error in bulkInserting exchange rates:Error: WDE0053: Internal wixData error: Unknown error."]
DEFAULT 2023-10-30T16:48:23.723999977Z ["fnDelAndInsert_boolOldRateError = true"]
DEFAULT 2023-10-30T16:48:23.720999956Z ["fnDelAndInsert_arrExistingFutures = {\"msgType\":\"error\",\"msgValue\":\"gbookxrates fnGetOldFuturesError in fetching exchange rate detail: Error: WDE0053: Internal wixData error: Unknown error.\"}"]
DEFAULT 2023-10-30T16:48:23.716000080Z ["fnGetExchangeRateDetail: error in exchange rate detail Normal:Error: WDE0053: Internal wixData error: Unknown error."]
ERROR 2023-10-30T16:31:03.487999916Z ["[BABEL] Note: The code generator has deoptimised the styling of /user-code/backend/gbookcore.js as it exceeds the max of 500KB."]
DEFAULT 2023-10-30T16:16:51.233999967Z ["fnGetFuturesARS_fnWriteFutureRates = {\"insertedItemIds\":[\"8c7ddbb1-40e0-463e-8ae0-7179d9208e41\",\"41d0f101-9609-46a7-8979-5a920bf0c74f\",\"f35ff991-2218-4e90-a31c-03280a33c17a\",\"682b699e-cf30-452e-a862-5b3e7f54a76e\",\"027e7249-0e6b-4eda-aeb4-8d823e50576d\",\"bfa7df5c-c622-4248-9861-0aace5f6cd4d\",\"2a4fa361-f947-4e63-8563-4f725a360d5b\",\"e07573d5-d259-43e6-80b4-4e2ad7010ae2\",\"cee80335-84a5-434c-9069-ab807032ae35\",\"cc7865fd-2c26-461c-855f-9dd1e9d16a32\",\"2aacf05e-5153-452b-a3cd-9e92e103a31b\"],\"inserted\":11,\"skipped\":0,\"updated\":0,\"errors\":[]}"]
DEFAULT 2023-10-30T16:16:50.941999912Z ["fnDelAndInsert_boolOldRateError = true"]
DEFAULT 2023-10-30T16:16:50.938999891Z ["fnDelAndInsert_arrExistingFutures = {\"msgType\":\"error\",\"msgValue\":\"No Exchange Rate details found.\"}"]
DEFAULT 2023-10-30T16:09:09.035000085Z ["fnGetFuturesARS_fnWriteFutureRates = {\"msgType\":\"error\"}"]
DEFAULT 2023-10-30T16:09:09.032000064Z ["fnDelAndInsert_objDeleted= {\"removedItemIds\":[\"cf52071e-3a42-42fe-9263-898b70ee98fe\",\"b0612ec9-a87e-4691-a337-8d734e93f6c0\",\"ed10283e-4823-49ac-91d2-6c6294331847\",\"5b2e5ddb-e7d7-4b83-a3b9-e41d6825a575\",\"284b18cd-e8e1-4e64-a575-dcf9075c211a\",\"36af7566-5732-4bf0-8e41-96b27e4fed66\",\"235e60b6-edca-4d00-8dd3-2cb4e4ede67f\",\"0f4e2895-33f8-4860-ac87-34348cf6f1a9\",\"d2a7abfe-1b78-4b0b-a814-1f762ad81bfc\",\"1de87cb9-187d-4584-b237-80b86a5096c7\",\"f6fd3aa1-2907-4694-9f6d-25b7e850f1bc\"],\"removed\":11,\"skipped\":0,\"errors\":[]}"]
DEFAULT 2023-10-30T16:09:08.453000068Z ["fnWriteFutureRates: error in bulkInserting exchange rates:Error: WDE0053: Internal wixData error: Unknown error."]
DEFAULT 2023-10-30T16:09:08.279999971Z ["fnDelAndInsert_boolOldRateError = false"]
DEFAULT 2023-10-30T16:00:24.224999904Z Error: Request failed with status code 504
ERROR 2023-10-30T16:00:13.341000080Z ["[BABEL] Note: The code generator has deoptimised the styling of /user-code/backend/gbookcore.js as it exceeds the max of 500KB."]
DEFAULT 2023-10-30T15:35:09.667000055Z ["fnGetFuturesARS_fnWriteFutureRates = {\"insertedItemIds\":[\"4f249fbf-9b80-4799-819b-43c3ddfa7167\",\"1fa98c1d-d485-445b-9341-4af5accd9c58\"],\"inserted\":2,\"skipped\":0,\"updated\":0,\"errors\":[]}"]
ERROR 2023-10-30T13:52:51.377000093Z Internal error.

NOTE: gCurrencies has 4 rows in it. Why on earth would a count take 5 secs?
  {
    "insertId": "09461c87-d121-4640-bee0-fa4af294b530",
    "jsonPayload": {
      "jsonContent": {
        "collection": "gCurrencies",
        "errorCode": "WDE0053",
        "operation": "count",
        "duration": 5010,
        "broadCode": "WD_UNKNOWN_ERROR"
      },
      "message": "Internal error.",
      "serviceContext": {
        "version": "none",
        "service": "UNKNOWN"
      }
    },
    "resource": {
      "type": "global",
      "labels": {
        "project_id": "corvid-managed-5661f9ba"
      }
    },
    "timestamp": "2023-10-30T13:52:51.377000093Z",
    "severity": "ERROR",
    "labels": {
      "tenantId": "6defb7d7-9c1c-49fc-9869-d9ba8d788686",
      "revision": "none",
      "corvidTimestamp": "2023-10-30T13:52:51.377Z",
      "siteUrl": "UNKNOWN",
      "viewMode": "Preview",
      "namespace": "Velo"
    },
    "logName": "projects/corvid-managed-5661f9ba/logs/6defb7d7-9c1c-49fc-9869-d9ba8d788686",
    "operation": {
      "id": "1698673946.820577111818727886",
      "producer": "backend"
    },
    "receiveTimestamp": "2023-10-30T13:52:51.636616859Z"
  }
ERROR 2023-10-30T13:52:38.917000055Z Internal error.
DEFAULT 2023-10-30T09:31:19.937999963Z ["gautomail_fnCreateReport_objFutures={\"msgType\":\"error\",\"msgValue\":\"gautomail_fnQueryCollection:error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded.\"}"]
DEFAULT 2023-10-30T09:31:19.927999973Z ["gautomail_fnCreateReport_objOfficial={\"msgType\":\"error\",\"msgValue\":\"gautomail_fnQueryCollection:error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded.\"}"]
DEFAULT 2023-10-30T09:31:03.104000091Z ["gautomail_fnQueryDayRates_objDaily={\"msgType\":\"error\",\"msgValue\":\"gautomail_fnQueryCollection:error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded.\"}"]
DEFAULT 2023-10-30T09:31:03.098999977Z ["gautomail_fnQueryCollection: error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded."]
ERROR 2023-10-30T09:31:03.084000110Z Operation time limit exceeded.
DEFAULT 2023-10-30T09:30:58.019999980Z ["gautomail_fnQueryFutureRates_objFutures={\"msgType\":\"error\",\"msgValue\":\"gautomail_fnQueryCollection:error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded.\"}"]
DEFAULT 2023-10-30T09:30:58.005000114Z ["gautomail_fnQueryCollection: error in fetching items from gExRatesDetail:Error: WDE0028: Operation time limit exceeded."]
ERROR 2023-10-30T09:30:57.862999916Z Operation time limit exceeded.

type or paste code here

Detail log of a WDE0028


{
  "insertId": "e7565953-002e-4e11-8f3e-780338f44684",
  "jsonPayload": {
    "message": "Operation time limit exceeded.",
    "serviceContext": {
      "service": "UNKNOWN",
      "version": "4707"
    },
    "jsonContent": {
      "broadCode": "WD_REQUEST_TIMED_OUT",
      "operation": "find",
      "collection": "gExRatesDetail",
      "errorCode": "WDE0028",
      "duration": 5014
    }
  },
  "resource": {
    "type": "global",
    "labels": {
      "project_id": "corvid-managed-5661f9ba"
    }
  },
  "timestamp": "2023-10-30T09:30:57.862999916Z",
  "severity": "ERROR",
  "labels": {
    "revision": "4707",
    "siteUrl": "UNKNOWN",
    "corvidTimestamp": "2023-10-30T09:30:57.864Z",
    "namespace": "Velo",
    "tenantId": "6defb7d7-9c1c-49fc-9869-d9ba8d788686",
    "viewMode": "Site"
  },
  "logName": "projects/corvid-managed-5661f9ba/logs/6defb7d7-9c1c-49fc-9869-d9ba8d788686",
  "operation": {
    "id": "6e0780ac-a125-46af-9544-9df32040eb68",
    "producer": "backend"
  },
  "receiveTimestamp": "2023-10-30T09:30:58.940919827Z"
}
5

This caught my attention, lately, we’ve seen this type of error code on Wix logs WDE0028 on several different projects not just on the same project, but goes away after some time, we thought it has been due to maintenance on the server or something like that? would be great to hear an explanation.

However it shouldn’t be there, no client would accept this due to server tasks or issues but it has been happening and as long as is happening the web applications are quite slow or simply stop working.

1 Like
6

Thank you both for the feedback. Will forward this all to the relevant teams.

For future reference you can send DM’s by clicking on a user’s profile picture:

image

7

Thanks, but believe me, I did that. I get this:

image_2023-10-30_181512497
image_2023-10-30_181512497824×373 44.5 KB

1 Like
8

Thanks for chipping in. I get the distinct suspicion that there is something wrong with wix-data since a month or so. This part of code completely stable for almost 2 years, recently execution is problematic. There’s another thread of somebody here with code written by a Wix Master, and now I get it too, as do you, as you state.
Hope Wix can look into this. I could understand that due to current IRL-situations, Wix techs might be understaffed because of being drafted. I will be the first to declare my website less important than fighting in an army, so I won’t push hard, other things are more relevant.

2 Likes
9

Gotcha, probably a setting. I should have messaged you first then. Will make a note for the future and thanks for letting me know!

10

Hi everyone!
I am facing the same error, in all my sites. As you can see, sometimes it is impossible to debug, there is no enough information to do so. It happens on collections with 1500 items and also with 15000 items. Sometimes work pretty fine for days, then it starts failing continuosly, there is no pattern for the error. Any ideia on how to overcome this?

Example of logs (from Google Cloud Console, integrated to Wix Velo)

{
“insertId”: “b8dab86b-2839-4589-b58f-533cd0a64c58”,
“jsonPayload”: {
“jsonContent”: {
“duration”: 131,
“errorCode”: “WDE0053”,
“collection”: “flightfids”,
“operation”: “bulkInsert”,
“broadCode”: “WD_UNKNOWN_ERROR”
},
“message”: “Internal error.”,
“serviceContext”: {
“service”: “UNKNOWN”,
“version”: “92”
}
},
“resource”: {
“type”: “global”,
“labels”: {
“project_id”: “wix-managed-af461372”
}
},
“timestamp”: “2023-12-14T09:59:02.726999998Z”,
“severity”: “ERROR”,
“labels”: {
“revision”: “92”,
“viewMode”: “Site”,
“siteUrl”: “UNKNOWN”,
“namespace”: “Velo”,
“corvidTimestamp”: “2023-12-14T09:59:02.727Z”,
“tenantId”: “5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”
},
“logName”: “projects/wix-managed-af461372/logs/5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”,
“operation”: {
“id”: “1702547942.364152653921516454”,
“producer”: “backend”
},
“receiveTimestamp”: “2023-12-14T09:59:02.849562979Z”
}

{
“insertId”: “…4SG2gIir_DFdiwyLpk.NNH”,
“jsonPayload”: {
“message”: “["WDE0053: Internal error."]”,
“serviceContext”: {
“service”: “https://zenfly.app/”,
“version”: “92”
}
},
“resource”: {
“type”: “global”,
“labels”: {
“project_id”: “wix-managed-af461372”
}
},
“timestamp”: “2023-12-14T09:59:02.785000085Z”,
“severity”: “ERROR”,
“labels”: {
“tenantId”: “5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”,
“revision”: “92”,
“viewMode”: “Site”,
“siteUrl”: “https://zenfly.app/”,
“namespace”: “Velo”,
“corvidTimestamp”: “2023-12-14T09:59:02.816Z”
},
“logName”: “projects/wix-managed-af461372/logs/5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”,
“operation”: {
“id”: “1702547942.364152653921516454”,
“producer”: “backend”
},
“sourceLocation”: {
“file”: “backend/flights.js”,
“line”: “19”
},
“receiveTimestamp”: “2023-12-14T09:59:04.602429226Z”
}

{
“insertId”: “0db2cbcd-e194-49e9-bc31-88bf9f21822c”,
“jsonPayload”: {
“jsonContent”: {
“broadCode”: “WD_UNKNOWN_ERROR”,
“operation”: “find”,
“collection”: “flights”,
“duration”: 388,
“errorCode”: “WDE0053”
},
“serviceContext”: {
“service”: “UNKNOWN”,
“version”: “92”
},
“message”: “Internal error.”
},
“resource”: {
“type”: “global”,
“labels”: {
“project_id”: “wix-managed-af461372”
}
},
“timestamp”: “2023-12-14T09:59:02.984999895Z”,
“severity”: “ERROR”,
“labels”: {
“siteUrl”: “UNKNOWN”,
“revision”: “92”,
“viewMode”: “Site”,
“tenantId”: “5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”,
“corvidTimestamp”: “2023-12-14T09:59:02.986Z”,
“namespace”: “Velo”
},
“logName”: “projects/wix-managed-af461372/logs/5ccdecc4-8cda-496a-a39e-6d92fcf7f0ca”,
“operation”: {
“id”: “1702547942.364152653921516454”,
“producer”: “backend”
},
“receiveTimestamp”: “2023-12-14T09:59:04.384975849Z”
}

11

This issue is really disgusting and It must be embarrassing for a PRO Database, the error was in a simple query like this, and after hundreds of updates and debugging for it, today I found out a solution that I want to share with all of you.

The query that throw this error was this:
await wixData.query(‘History’)
.eq(‘_owner’, userId)
.descending(‘_createdDate’)
.limit(10)
.find()
.then( (results2) => {
if(results2.items.length > 0){
}
})
.catch((error)=>{
return error;
});

I found that the root error is that the property length it is not reachable (unexplainable) and the solution for me is assigning the results2.items to a var called views,
now it looks like this without this Unexplainable error.

await wixData.query(‘History’)
.eq(‘_owner’, userId)
.descending(‘_createdDate’)
.limit(10)
.find()
.then( (results2) => {
let views = results2.items;
if(views.length > 0){
}
})
.catch((error)=>{
return error;
});

Good luck!