dancerfly / django-brambling

Event website manager, specifically designed for dance weekends or other events with multiple simultaneous tracks of classes.
BSD 3-Clause "New" or "Revised" License
11 stars 3 forks source link

Long text in order search box causes 500 OperationalError #836

Open melinath opened 7 years ago

melinath commented 7 years ago

Error text: SSL SYSCALL error: EOF detected

Here's the text that first caused the error:

“The Source for the Theatricals of Jane Austen’s Mansfield Park: A Discovery” Dr. Sayre Greenfield Saturday, January 28, 2017 11:30 Meet and Greet Luncheon at Noon The Wyndham Pittsburgh University Center 100 Lytton Avenue, 15213 (about one block from the Pittsburgh Athletic Association) " . . . the inclination to act was awakened, and in no one more strongly than in him [Tom Bertram] who was now master of the house; and who, having so much leisure as to make almost any novelty a certain good, had likewise such a degree of lively talents and comic taste, as were exactly adapted to the novelty of acting. The thought returned again and again. “Oh for the Ecclesford theatre and scenery to try something with.” Each sister could echo the wish; and Henry Crawford, to whom, in all the riot of his gratifications it was yet an untasted pleasure, was quite alive at the idea. “I really believe,” said he, “I could be fool enough at this moment to undertake any character that ever was written, from Shylock or Richard III down to the singing hero of a farce in his scarlet coat and cocked hat. I feel as if I could be anything or everything; as if I could rant and storm, or sigh or cut capers, in any tragedy or comedy in the English language. Let us be doing something. Be it only half a play, an act, a scene; what should prevent us?" We know that the Austen family enjoyed acting at home--but Sayre will share with us more insight into this brilliant theatrical interlude. Luncheon Choices: Portobello Florentino $25 A large Portobello Mushroom Cap stuffed with Creamy Spinach, Basil Pine Nut Stuffing Drizzled with a Balsamic reduction. Pecan Crusted Chicken $28 With a Dijon Mustard Sauce Grilled Salmon $28 With Orange-Infused Beurre Blanc All Entrees include: Freshly-brewed iced tea, freshly brewed regular and decaffeinated Starbucks Coffee and Tazo Tea, House Salad, Rolls & Butter, Chef’s Choice of Rice or Potato, Vegetable and Dessert. Parking for $5 is available in two lots under the hotel, one lot outside and adjacent to the hotel, and the UPMC lot across the street. Please pay at the hotel's front desk to receive your code to exit the parking lot. Please send a check and your luncheon choice to Treasurer Abigail Thompson, 201 Farmington Road, Pittsburgh PA 15215 by Saturday, January 21.

As far as I can tell, the issue here is that the order search endpoint has seven fields it searches - so the text is split by word and a massive OR query is constructed to see if any of the provided words match any of the seven fields. That OR query (I theorize) fails because it's so large.

This is not high priority since this was clearly a typo and not the intended use of the field.