missing row (i think)
i think my import got fucked up, what is this and how do i manually fix it? i have admin access to the db
Solution:
Jump to solution
if it fails can try some of these:
```// Set MySQL timeout configurations
metadataContext.Database.ExecuteSqlRaw(@"SET GLOBAL wait_timeout=3600"); // 1 hour
metadataContext.Database.ExecuteSqlRaw(@"SET GLOBAL interactive_timeout=3600"); // 1 hour...
28 Replies
like where is this meant to be in the db so i can fix it
try running ingest again
already did that
:Erm:
@Zin you know anything?
can you screenshot your maple-data db, and in table - itemoptionrandom.xml row?
is that not the problem
that it doesn't exist
that's my point
yeah it's not there lol like the log says
if it doesn't exist then whatever xml you're giving your server is corrupt
could try getting latest from the repo
:hmm:
fixing it
just waiting for navicat to work
nevermind fucked everything worse
erm
i dont understand what you're doing lol
"navicat to work" huh?
why is navicat "working" ?
my db manager, i'm just copying the row from my old db
but why are you doing this
because it's not there
if ingest is not properly ingesting then you have a more serious problem with the data you're feeding it
what you're doing it just going to lead to more problems
if my ms2 install corrupted overnight without any powercut or anything i think there's a wizard in my rack
:hmm: try deleting the whole db and running ingest
i used to run my db on the same machine as my server, which was fine, i'm just having teething issues moving
ingest is too impatient on larger queries
the timeout is too low
:hmm:
weird never seen this issue
my server is just a little slow so the timeout is too low :(
ohh
she needs a little time
god i hate mysql
running ingest again we'll see if it's magically patient enough
okay it seems to be working fine fingers crossed
yeah the row is actually in navi now so i'm expecting it'll be fine after ingest is done
Solution
if it fails can try some of these:
thank u boss will do
need this to be done so i can eat in peace
never touching mysql again praise be
