Getting errors loading TDF
- RainKing
- Doll Advisor
- Posts: 500
- Joined: Tue Feb 20, 2018 9:02 pm
- Location: North Louisiana
- Contact:
Getting errors loading TDF
Possibly a lot of people connected at once.
Also noted a lot of new doll questions in the help forum.
May want to change the name to Forum Support/Bug Reporting
I think some new folks think its a help for doll questions.
thanks,
RainKing
Formerly known as SillyconeLover (it was only for a week)
-
- Vendor Affiliated
- Posts: 1458
- Joined: Sun May 28, 2017 8:02 pm
- Contact:
Re: Getting errors loading TDF
- RainKing
- Doll Advisor
- Posts: 500
- Joined: Tue Feb 20, 2018 9:02 pm
- Location: North Louisiana
- Contact:
Re: Getting errors loading TDF
thanks, Optical!
Formerly known as SillyconeLover (it was only for a week)
-
- Vendor Affiliated
- Posts: 1458
- Joined: Sun May 28, 2017 8:02 pm
- Contact:
Re: Getting errors loading TDF
- siliconefun
- Doll Guru
- Posts: 5359
- Joined: Sun May 13, 2012 12:21 pm
- Location: Luxembourg - The Land of the Red Rocks -
- Contact:
Re: Getting errors loading TDF
- SF -
Re: Getting errors loading TDF
If Innodb is the used storage engine you can add --single-transaction to the dump command and you will still get a consistent dump without locking tables.
If you are using myisam you can set up a slave (replicated) database and snapshot that one with locked tables instead. This will not effect the primary database that PHP is using once set up.
https://dba.stackexchange.com/questions ... and-writes
I suppose uploaded images etc are backed up too. But perhaps the best way would be to setup filesystem replication that run in the background. In addition disk snapshots can be done if running in virtual environments.
These backup downtimes are really not nesessary, it can be done more or less seamless.
I do know it is some work putting everything together and I fully respect if this is not possible due to lack om man hours!
- Nescio50
- Site Manager - CoverDoll
- Posts: 23454
- Joined: Fri Jan 14, 2011 11:06 am
- Location: In TLC, The Low Countries, surrounded by dolls
- Contact:
Re: Getting errors loading TDF
We are aware of this issue. We need to do a software upgrade to fully solve this. Upgrading the software is not that easy, but we're looking into this.Sofos wrote:You are using mysql right?
If Innodb is the used storage engine you can add --single-transaction to the dump command and you will still get a consistent dump without locking tables.
-
- Doll Mentor
- Posts: 1152
- Joined: Tue Aug 18, 2015 1:44 pm
- Location: with Nele, Kiko, Mamamba and Ms. StrangeLove in cyba's space
- Contact:
Re: Getting errors loading TDF
While you are at it:Nescio50 wrote:We need to do a software upgrade to fully solve this.
I was getting a sql-error when I tried to use a Unicode 7 element.
It previews just fine, but can't be submitted.
Yet here I am, dreaming about reality again...
- Nescio50
- Site Manager - CoverDoll
- Posts: 23454
- Joined: Fri Jan 14, 2011 11:06 am
- Location: In TLC, The Low Countries, surrounded by dolls
- Contact:
Re: Getting errors loading TDF
Do not use any special character in the subject title of your post. Be sure your device does not add a special character here (iphone is notorious to do so).nukeno wrote:I was getting a sql-error when I tried to use a Unicode 7 element.
In the message body you should be able to use special characters.
-
- Doll Mentor
- Posts: 1152
- Joined: Tue Aug 18, 2015 1:44 pm
- Location: with Nele, Kiko, Mamamba and Ms. StrangeLove in cyba's space
- Contact:
Re: Getting errors loading TDF
Nope, that doesn't work either.Nescio50 wrote:In the message body you should be able to use special characters.
Yet here I am, dreaming about reality again...
- Nescio50
- Site Manager - CoverDoll
- Posts: 23454
- Joined: Fri Jan 14, 2011 11:06 am
- Location: In TLC, The Low Countries, surrounded by dolls
- Contact:
Re: Getting errors loading TDF
If it's the body text, you are the first reporting this issue
If this is the case I have found out which code pages are supported. Maybe Phreddie knows.
Still, are you sure there's no special character in the topic title.
Re: Getting errors loading TDF
Nescio50 wrote:We are aware of this issue. We need to do a software upgrade to fully solve this. Upgrading the software is not that easy, but we're looking into this.Sofos wrote:You are using mysql right?
If Innodb is the used storage engine you can add --single-transaction to the dump command and you will still get a consistent dump without locking tables.
Nescio50 wrote:Are you sure this isn't the topic title?
If it's the body text, you are the first reporting this issue
If this is the case I have found out which code pages are supported. Maybe Phreddie knows.
Still, are you sure there's no special character in the topic title.
I can confirm the problem in the message text.
viewtopic.php?f=14&t=96411&hilit=Unicode
My guess?
The table is set to utf8 which in mysql is a limited utf8 encoding 1-3 bytes. Kinda stupid of mysql if you ask me. For normal utf8 (1-4) bytes they have a special name
https://dev.mysql.com/doc/refman/5.7/en ... icode.html
- Nescio50
- Site Manager - CoverDoll
- Posts: 23454
- Joined: Fri Jan 14, 2011 11:06 am
- Location: In TLC, The Low Countries, surrounded by dolls
- Contact:
Re: Getting errors loading TDF
Re: Getting errors loading TDF
- Phreddie
- Server Admin
- Posts: 550
- Joined: Wed Dec 07, 2011 11:31 pm
- Location: Winchester, VA
- Contact:
Re: Getting errors loading TDF
As for the filesystem backup, it's 30 minutes for 456G isnt too bad. We're not virtualized, but using rsync snapshot style backups, so doing a cp -al first (use hardlinks), then rsync the data. Doing this method, we're not really IO bound too much (raid1 is handy), and we're getting a nice set of daily/weekly/monthly backups tossed over to the spare server. Sure, something like DRBD would be nice, but then we'd need a 3rd server for actual backups. But the main issue is this new 10 minute window for SQL backups. If these SQL problems occur outside of around 4:00-4:30 then the issue is something else (the backup script is sequential as to not have two types of backup processes going at once).
as for the utf8 thing... will have to look into it a bit more. Maybe the PHPBB upgrade will help in properly escaping/encoding more things.