Page MenuHomePhabricator

Section suggestion seems broken?
Open, MediumPublicBUG REPORT

Description

Error

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY source_title, frequency DESC' at line 5

exception.trace
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
				ORDER BY source_title, frequency DESC' at line 5
    at Query.Sequence._packetToError (/srv/service/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/srv/service/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/srv/service/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/srv/service/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/srv/service/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/srv/service/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/srv/service/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/srv/service/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
    --------------------
    at Protocol._enqueue (/srv/service/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Connection.query (/srv/service/node_modules/mysql/lib/Connection.js:198:25)
    at node:internal/util:361:7
    at new Promise (<anonymous>)
    at Connection.query (node:internal/util:347:12)
    at SectionSuggester.querySectionMapping (/srv/service/lib/suggestion/SectionSuggester.js:54:27)
    at SectionSuggester.getSectionMapping (/srv/service/lib/suggestion/SectionSuggester.js:119:30)
    at SectionSuggester.getMissingSections (/srv/service/lib/suggestion/SectionSuggester.js:159:30)
    at async RoutesV2.suggestSections (/srv/service/lib/routes/v2.js:334:20)
Impact
  • Unknown

Event Timeline

Change 884858 had a related patch set uploaded (by Nik Gkountas; author: Nik Gkountas):

[mediawiki/services/cxserver@master] section mapping query: check if any section is given before querying

https://gerrit.wikimedia.org/r/884858

Change 886829 had a related patch set uploaded (by Nik Gkountas; author: Nik Gkountas):

[mediawiki/services/cxserver@master] section mapping query: check if any section is given before querying

https://gerrit.wikimedia.org/r/886829

Change 886829 abandoned by Nik Gkountas:

[mediawiki/services/cxserver@master] section mapping query: check if any section is given before querying

Reason:

duplicate of Ic4f357ba67041c5f2ab133c7bff6439f71a08d48

https://gerrit.wikimedia.org/r/886829

ngkountas triaged this task as Medium priority.Feb 8 2023, 6:52 PM

I've updated the link to logstash with the latest errors. The error rate is approx 40 errors per week as of now.