vb.org Archive
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   vBulletin Crashing Database each morning (https://vborg.vbsupport.ru/showthread.php?t=315091)

Zachery 10-28-2014 04:58 AM
You should still upgrade to 4.2.2 for both security and bug fixes.

hilaryl 10-28-2014 05:45 AM
Quote:
Originally Posted by Zachery (Post 2520302)
You should still upgrade to 4.2.2 for both security and bug fixes.
I agree we should upgrade to 4.2.2 - but I would prefer to upgrade an error free version of vBulletin. I think upgrading while having potential corruption issues would just cause more trouble then it would be worth.

It is definitely something we will look at after getting over this obstacle though.

Marv 10-28-2014 11:39 AM
Quote:
Originally Posted by hilaryl (Post 2520299)
Actually yes, the back-up happens around the same time.

My host has moved the scheduled backup to an earlier time for tonight - seeing if that makes a difference.

Do you know of an issue that relates to the backup?
Yes, we had something similiar. We found out that our ftp/server-repository had no space left and the backup task was setup to lock the tables and site until the backup was complete. Esp. the last point locked us out, flagged the site as inactive and we had to set the status back to active (deleting the unfinished backup task and restarting the server) via ssl first. Because there was no space left on the repository device (misconfiguration 6 yrs ago ;) ) we had to alter the partition sizes used.

hilaryl 10-28-2014 11:32 PM
Quote:
Originally Posted by Marv (Post 2520325)
Yes, we had something similiar. We found out that our ftp/server-repository had no space left and the backup task was setup to lock the tables and site until the backup was complete.
Hi Marv,

Some great information there. Really appreciate it.

I have been speaking with my host and we are going to try a few things to hopefully isolate the cause of the crashes.

I'll come back with any new information I find.

Cheers!

AndrewSimm 10-29-2014 12:25 AM
cPanel doesn't do a good job with large databases. Currently I use R1Soft CDP backup with the mysql extension and have no issues. I haven't used it to restore from any issues but I would like a more traditional backup option myself. It would be interesting to see whatever everyone else is using.

cellarius 10-29-2014 06:29 AM
Always a good recommendation for backup: http://www.mysqldumper.net/

Also works if you don't have root access.

Marv 10-29-2014 07:12 AM
Quote:
Originally Posted by cellarius (Post 2520433)
Always a good recommendation for backup: http://www.mysqldumper.net/

Also works if you don't have root access.
MSQLD is a great tool. Unfortunal, MySQLDump wasn?t really helpful in our case. We had to repair some tables and a few were about 1.6 to 2.4GB. MSQLD couldn?t write this table back to the database, just because of the sheer amount of data. In the end we had to do this via the console. Any known workaround for MSQLD and big tables?

cellarius 10-29-2014 07:20 AM
mysqldump is not the same as mysqldumper ;)

Marv 10-29-2014 07:58 AM
Erm..I was just lazy and have shortend MySQLDumper to MySQLDump. Guess we?re still talking about the same thing, Sven ;)

Mark.B 10-29-2014 08:30 AM
Quote:
Originally Posted by hilaryl (Post 2520303)
I agree we should upgrade to 4.2.2 - but I would prefer to upgrade an error free version of vBulletin. I think upgrading while having potential corruption issues would just cause more trouble then it would be worth.

It is definitely something we will look at after getting over this obstacle though.
Sometimes such issues may be caused by bugs in earlier versions.

At the risk of sounding like a stuck record - you really need to upgrade.
It's not just about bugs, your site is *definitely* insecure at the moment due to unpatched security issues. To patch those you need to upgrade.


All times are GMT. The time now is 01:51 PM.
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01163 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete