Announcement

Collapse
No announcement yet.

MySQL Error : The table 'session' is full

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

  • #16
    Originally posted by eva2000
    You can try both suggested fixes and see if it helps

    what vB version you're using as well as do you have any custom code in the footer template of your forums ? if you do revert your footer template. You made a change somewhere that stopped the Scheduled Tasks from running and clearing our this table on a regular basis
    What is the command that is in the footer to trigger the scheduled tasks?
    Have a nice day
    http://www.duneram.com

    Comment


    • #17
      Originally posted by hapbird
      Is max_heap_table_size the root issue here?
      The root cause depends on whether your cron tasks are running correctly.

      If your session table really is growng to over 16MB during normal use, then the root cause is the max_heap_table_size which defaults to 16MB. However, it takes a lot of sessions to fill up 16MB. How many active users are on your forum?

      It's more likely that that the cron task that cleans up stale sessions isn't running for some reason.
      http://britishexpats.com/ - British expatriate community

      Comment


      • #18
        i checked the footer and i found this:

        <!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
        $cronimage
        <!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

        It's there.

        Is it really bad if i convert the table to myisam? will it slow down the board significantly?

        Thanks.

        Originally posted by fastforward
        The root cause depends on whether your cron tasks are running correctly.

        If your session table really is growng to over 16MB during normal use, then the root cause is the max_heap_table_size which defaults to 16MB. However, it takes a lot of sessions to fill up 16MB. How many active users are on your forum?

        It's more likely that that the cron task that cleans up stale sessions isn't running for some reason.
        Have a nice day
        http://www.duneram.com

        Comment


        • #19
          Originally posted by hapbird
          i checked the footer and i found this:

          <!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
          $cronimage
          <!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

          It's there.

          Is it really bad if i convert the table to myisam? will it slow down the board significantly?

          Thanks.
          There's no need to convert it. Just increase the max_heap_table_size parameter.

          Converting it to MyISAM will cause additional problems with table level locking. HEAP tables also use table level locking, but they are fast enough not to have problems (usually). InnoDB would be OK, but again, unless you have thousands of concurrent users online, HEAP is just fine.

          As mentioned earlier, 16MB holds a lot of sessions and should be plenty for most boards. How many users do you have online?
          http://britishexpats.com/ - British expatriate community

          Comment


          • #20
            Thanks.
            We had roughly about 500 or so on when this occurred.

            What part of the software covers the session cleanup? I didn't see it on the scheduled task list. We haven't modified the scheduled tasks. What do i need to add to make the session clean up occur?

            Originally posted by fastforward
            There's no need to convert it. Just increase the max_heap_table_size parameter.

            Converting it to MyISAM will cause additional problems with table level locking. HEAP tables also use table level locking, but they are fast enough not to have problems (usually). InnoDB would be OK, but again, unless you have thousands of concurrent users online, HEAP is just fine.

            As mentioned earlier, 16MB holds a lot of sessions and should be plenty for most boards. How many users do you have online?
            Have a nice day
            http://www.duneram.com

            Comment


            • #21
              One of the hourly cleanups does it, there are two.

              Comment


              • #22
                Originally posted by Zachery
                One of the hourly cleanups does it, there are two.
                Hi any idea on the names?

                This is what shows up on our scheduled task list (that run hourly):
                • Restore temporarily banned users
                • User Promotions
                • Event Reminder
                • Thread Views
                • Attachment Views
                I just looked in my cron dir on the uploaded files area and there is a cleanup.php and a cleanup2.php file. However they are not configured in the scheduled tasks to run. Do I need to add them? what is the difference between the two scripts and what do they do?

                Thanks
                Last edited by hapbird; Wed 15 Mar '06, 10:24am.
                Have a nice day
                http://www.duneram.com

                Comment


                • #23
                  -bash:~/vb354/includes/cron$ grep session *
                  cleanup.php: DELETE FROM " . TABLE_PREFIX . "session
                  cleanup.php: ### Delete stale sessions ###
                  cleanup.php: DELETE FROM " . TABLE_PREFIX . "cpsession
                  cleanup.php: ### Delete stale cpsessions ###
                  cleanup2.php: DELETE FROM " . TABLE_PREFIX . "session
                  cleanup2.php: ### Delete stale sessions ###
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #24
                    Originally posted by Steve Machol
                    -bash:~/vb354/includes/cron$ grep session *
                    cleanup.php: DELETE FROM " . TABLE_PREFIX . "session
                    cleanup.php: ### Delete stale sessions ###
                    cleanup.php: DELETE FROM " . TABLE_PREFIX . "cpsession
                    cleanup.php: ### Delete stale cpsessions ###
                    cleanup2.php: DELETE FROM " . TABLE_PREFIX . "session
                    cleanup2.php: ### Delete stale sessions ###
                    It looks like I should definitely add those two to the scheduled tasks.

                    thanks
                    Have a nice day
                    http://www.duneram.com

                    Comment


                    • #25
                      They should already be there, they are called "hourly cleanup #1" and "hourly cleanup #2"

                      Comment


                      • #26
                        i have the same problem but i have this scheduled task cleanup1 every 5 minutes anche cleanup2 every 40 minutes..... i set max_heap_table_size to 33554432 but nothing....
                        The problem was born then i transfer the db and the forum into a new server... perhaps is this the cause of the problem?

                        Comment


                        • #27
                          BieDdos please start your own ticket.

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X