sexyrealsexdolls.com

Getting errors loading TDF

Report any bugs or problematic issues with the website here.
User avatar
RainKing
Doll Advisor
Doll Advisor
Posts: 500
Joined: Tue Feb 20, 2018 9:02 pm
Location: North Louisiana
Contact:

Getting errors loading TDF

Post by RainKing »

I am not sure if the admins are aware, but sometimes I have been getting a "general error" or database error. I think also says the server is already over max connections.

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
MDBG
Formerly known as SillyconeLover (it was only for a week)

optical delusion
Vendor Affiliated
Vendor Affiliated
Posts: 1458
Joined: Sun May 28, 2017 8:02 pm
Contact:

Re: Getting errors loading TDF

Post by optical delusion »

it happens during the server back ups around this time everyday. it comes good after a short while

User avatar
RainKing
Doll Advisor
Doll Advisor
Posts: 500
Joined: Tue Feb 20, 2018 9:02 pm
Location: North Louisiana
Contact:

Re: Getting errors loading TDF

Post by RainKing »

Yeah, it self-corrected... I forgot about Server DT (downtime for backing up Dbase) doh!!

thanks, Optical!
MDBG
Formerly known as SillyconeLover (it was only for a week)

optical delusion
Vendor Affiliated
Vendor Affiliated
Posts: 1458
Joined: Sun May 28, 2017 8:02 pm
Contact:

Re: Getting errors loading TDF

Post by optical delusion »

no worries, i think at some stage we have all wondered that

User avatar
siliconefun
Doll Guru
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

Post by siliconefun »

Server backup, better wait a 1/2 hrs and the site loads as usual. This may happen ~10:00 CET.

- SF -

User avatar
Sofos
Doll Mentor
Doll Mentor
Posts: 1891
Joined: Sat Dec 06, 2014 9:00 am
Location: Sweden
Contact:

Re: Getting errors loading TDF

Post by Sofos »

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.

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!

User avatar
Nescio50
Site Manager - CoverDoll
Site Manager - CoverDoll
Posts: 23441
Joined: Fri Jan 14, 2011 11:06 am
Location: In TLC, The Low Countries, surrounded by dolls
Contact:

Re: Getting errors loading TDF

Post by Nescio50 »

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.
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.

nukeno
Doll Mentor
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

Post by nukeno »

Nescio50 wrote:We need to do a software upgrade to fully solve this.
While you are at it:
I was getting a sql-error when I tried to use a Unicode 7 element.
It previews just fine, but can't be submitted.
Life is a strange game: "The only winning move is not to play."
Yet here I am, dreaming about reality again...

User avatar
Nescio50
Site Manager - CoverDoll
Site Manager - CoverDoll
Posts: 23441
Joined: Fri Jan 14, 2011 11:06 am
Location: In TLC, The Low Countries, surrounded by dolls
Contact:

Re: Getting errors loading TDF

Post by Nescio50 »

nukeno wrote:I was getting a sql-error when I tried to use a Unicode 7 element.
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).
In the message body you should be able to use special characters.

nukeno
Doll Mentor
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

Post by nukeno »

Nescio50 wrote:In the message body you should be able to use special characters.
Nope, that doesn't work either. :(
sql-error.png
Life is a strange game: "The only winning move is not to play."
Yet here I am, dreaming about reality again...

User avatar
Nescio50
Site Manager - CoverDoll
Site Manager - CoverDoll
Posts: 23441
Joined: Fri Jan 14, 2011 11:06 am
Location: In TLC, The Low Countries, surrounded by dolls
Contact:

Re: Getting errors loading TDF

Post by Nescio50 »

Are you sure this isn't the topic title?

If it's the body text, you are the first reporting this issue :o
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.

User avatar
Sofos
Doll Mentor
Doll Mentor
Posts: 1891
Joined: Sat Dec 06, 2014 9:00 am
Location: Sweden
Contact:

Re: Getting errors loading TDF

Post by Sofos »

Nescio50 wrote:
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.
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.

:thumbs_up: :D
Nescio50 wrote:Are you sure this isn't the topic title?

If it's the body text, you are the first reporting this issue :o
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 :roll:

https://dev.mysql.com/doc/refman/5.7/en ... icode.html

User avatar
Nescio50
Site Manager - CoverDoll
Site Manager - CoverDoll
Posts: 23441
Joined: Fri Jan 14, 2011 11:06 am
Location: In TLC, The Low Countries, surrounded by dolls
Contact:

Re: Getting errors loading TDF

Post by Nescio50 »

I'll ask Phreddie to look into this. He's our server admin :)

User avatar
viktorsx
Active Member
Active Member
Posts: 120
Joined: Fri Mar 09, 2018 7:45 am
Location: EU
Contact:

Re: Getting errors loading TDF

Post by viktorsx »

get a sound foundation like a noSQL for data . since this is going to explode in users and posts . so prepare ...
/* Simplicity is very Complex ... */

User avatar
Phreddie
Server Admin
Server Admin
Posts: 550
Joined: Wed Dec 07, 2011 11:31 pm
Location: Winchester, VA
Contact:

Re: Getting errors loading TDF

Post by Phreddie »

Sofos; thank you for your input. We're using myisam, as my experience is that innodb creates these MONSTER ibdata files that seemingly can't be trimmed. DB backup seems to take 10 minutes now (4 gigs). In janurary, it took 3 minutes, and last year it took 1 minute. Seems that march 17th is when it jumpped from 3 minutes to 10 minutes. Odd. Guess I have to dig deeper to see what changes. So yeah, the DB dump was a quick non-issue. I had been wanting to setup a replica on our spare server, but last I looked (quite a few years ago), you actually needed a total of 3 servers, probably due to dealing with quorums.. or maybe that was for full HA, perhaps a replica would be fine.
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.

Post Reply

INFORMATIONS