Announcement

Collapse
No announcement yet.

2013 error - RSS related

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2013 error - RSS related

    I've started to get a dozen or so 2013 errors per day, all related to the RSS task. Looking at the causes for 2013, one of them is "invalid SQL", and that is exactly what the error is stating. Why is the SQL invalid, what can I change to fix it, and is there some limit in terms of # of RSS feeds or even RSS threads/posts that is causing this error? Thx.

    Code:
    Database error in vBulletin 3.6.0:
    
    
    Invalid SQL:
    
    
                            SELECT * FROM rsslog
                            WHERE uniquehash IN ('28f9d1b0cdf8915032c476f18d696b48', '55878ac4f9a66a7bba2bf9e1b70d8bc6', '9e4576c5b3cddcb12b66dbbcb0619d80', 'ac568e7de0d5a15133018759c30277a1', '***tons and tons removed***, 'e75413d337453b118372e509b7a3be2a');
    
    
    MySQL Error  : Lost connection to MySQL server during query
    Error Number : 2013
    Date         : Tuesday, August 15th 2006 @ 09:09:26 AM
    Script       : http://www.myforum.com/forums/cron.php?&rand=994579
    Referrer     : http://www.myforum.com/forums/
    IP Address   : 24.6.xxx.3xxx3
    Username     : Unregistered
    Classname    : vb_database
    Last edited by aciurczak; Tue 15 Aug '06, 9:34am.
    www.montgomerybikers.com / www.ninjette.org / www.cal24.com

  • #2
    Your mysql server doesn't like the amount of data that is being fed to it in that query. That entire query is only ~16kb which should be no problem anyway. You'll find other queries, such as those that insert language that send much more data to mysql.

    How many RSS feeds do you have?

    Comment


    • #3
      Well, alot. 22 configured feeds, 20 of them active. There are only about 20 new threads daily on all of them combined. Not sure what that query looking in RSSLOG is for, but if it is just looking up hashes of existing threads, does it really matter how many feeds there are? seems like rsslog would be the same size if it had 1 feed with 100 threads, or 100 feeds with one thread, right?

      I did have them all configured to pull all threads from all feeds with no limit, but I changed that to 2 threads only from each feed (knowing they'd eventually catch up and pull all threads anyway)

      Since I changed the limit to 2 threads only a few hours ago, I haven't had another 2013, but it's too early to tell if it really fixed it.
      www.montgomerybikers.com / www.ninjette.org / www.cal24.com

      Comment


      • #4
        I spoke too soon. 5 more errors this afternoon. Adding the limit of 2 per feed seemed to shorten the queries, but it still says invalid sql. Here is a full error I recently received:

        Code:
        Database error in vBulletin 3.6.0:
        
        
        Invalid SQL:
        
        
                                SELECT * FROM rsslog
                                WHERE uniquehash IN ('28f9d1b0cdf8915032c476f18d696b48', '55878ac4f9a66a7bba2bf9e1b70d8bc6', '049ddb8002cfa6c0989774cdb663c5ca', '3106a83e8dca0ae0abf981ecd57d5df6', '42389eb46dca2b5b002174d09cd46d7f', '8aeb8299048cb10e77e7139ec00cfc23', 'dc7a8780c8908c73a96bf59ddfef163b', '2b88f33f21f0102a0fc8ffb2b696ed80', 'd1492ce678ddadd7b68fa38953faad5c', '319554ed02ab5107be7512bc97321aaf', 'be28b54872a2f7f7fb46c0df4eba3095', 'b43f450248a54f80354f2e1b3896756b', 'b8b87a0b7d705ad471aaea82a0bd062b', 'd8d9ed2a1a79f859931e69e781fefe21', '5be8056dbd00eecbc2b6b26503825092', '073d42a66e0bebeed6a795bf8e1c58f4', '7ed0820311b2e4f17b60f089f4a05415', 'c3bac5c4516e4d5e45c2a441ed0a1c09', 'f7682133e385404890e052625e64efdb', '169e2b0db4b57b7293a98811c586cdb8', '0abf39a37e979cfa57d19cce183f92f5', 'd827ea84fe4f973693d0c5738804454a', 'b5482d66606779eb3f459e7a0221d573', '86fa05e89cc5df59ddcaa49e6c023861', '1bb339cc2bca63a53ec563add12a14e5', '227505003768a44d89a8fc99116a74e3', '21fb92f659bfaa8faf05d0d9da5ac551', '619d782bf76734f5df4378cd765cda99', 'd81d81fcc7f15b3ece1298574211c255', '65e3ee619fd36d617deaef6c8512d81d', '7860ad8565ad10adf70e69b31c731eac', '56fd43c7cd30b70aa9d267e28faf9aca', '9aca52916c74f30a1fdc38da9b94f316', '855eb842b618157b1591e632ff275d5a', '45891a36f5e998467c3d3bc1e157a61b', 'a9f8494211eb2fa7a64e65c8f55fd315', '9350d6798d7f3865b8bb1536b9866927', '0efab3fed2d4d45da1273ec1494fdc7a');
        
        
        MySQL Error  : Lost connection to MySQL server during query
        Error Number : 2013
        Date         : Tuesday, August 15th 2006 @ 05:18:42 PM
        Script       : http://www.xxx.com/forums/cron.php?&rand=281020
        Referrer     : http://www.xxx.com/forums/showthread.php?t=114
        IP Address   : xxx.xxx.xxx.xxx
        Username     : Unregistered
        Classname    : vb_database
        www.montgomerybikers.com / www.ninjette.org / www.cal24.com

        Comment


        • #5
          That is not much of a query at all. I would advise that you head over to the server config forum and go over your mysql configuration to determine why it is having a problem with this query.

          Comment

          Loading...
          Working...
          X