One Yukkuri Place

Read the rules before proceeding!

Topic: Mr. Bugs can't take it easy.

Posted under Bugs & Features

boom

Clicking on the "My Account" link results in a 15 to 20-second wait and afterwards, the following pops up: "The database timed out running your query."

This means I can't access my account information. I'm scared to log out because I don't know if I'll be able to log back in.

  • ID: 10477
  • Permalink
  • BaronMind

    It's been doing that to me for ages. It usually ends up working eventually.

  • ID: 10478
  • Permalink
  • exitstrategy

    Sounds like somebody forgot to put mister index on mister database table (assuming it's properly keyed of course).

  • ID: 10479
  • Permalink
  • Toawa

    Mister index is right where he should be; mister query engine isn't using them right for some reason...

  • ID: 10482
  • Permalink
  • Toawa

    Ok, I just restarted Postgres and now its using the indexes correctly. I'm not really familiar with Postgres, does anyone know what might have caused that?

  • ID: 10483
  • Permalink
  • exitstrategy

    I don't know the Postgres engine at all. It would probably help to check any documentation regarding schema modification. It wouldn't hurt to look for a known issues log (or patches) for the version that you are using.

  • ID: 10484
  • Permalink
  • BaronMind

    In other news, I still can't delete my comments.

  • ID: 10494
  • Permalink
  • BaronMind

    Bump. Comment deletion is still broken.

    OP's problem is back too, at least for me.

  • ID: 11150
  • Permalink
  • poweryoga

    Usually we just reboot the server when this happens, but this happens every once in a while. Not much we can do about it unfortunately...

  • ID: 11151
  • Permalink
  • BaronMind

    Okuu did puff-puff and mister deletion grew on its own.

    Mister profile is still taking it too easy though...

  • ID: 11152
  • Permalink
  • Ruukasu

    Are the issues related to the Danbooru version that OYP is using? If so, does it cost considerable amount of time and money to update Danbooru?

  • ID: 11154
  • Permalink
  • poweryoga

    It's the posgresql DB. It randomly loses the index so the queries take a really long time. Usually restarting helps but it's just a bandaid fix. Not sure what causes it to be honest.

  • ID: 11155
  • Permalink
  • exitstrategy

    Is there a newer, stable build you can use or is the forum software only compatible with certain versions?

  • ID: 11157
  • Permalink
  • poweryoga

    I'm not sure entirely, would require some testing. The older danbooru version was only compatible up to a certain point. I'm not comfortable enough with server backend to be honest, toawa does 100% of the work related to it. I just pay the bills.

  • ID: 11158
  • Permalink
  • EasyV

    I don't know if this was discussed already somewhere else, but when making notes, there is a button labeled as "mark as translated", which adds the tag "translated_available"
    It should be "translation_available" (or what is more appropriate) instead

  • ID: 11220
  • Permalink
  • poweryoga

    yeah, that's a known bug. I just have an alias setup to run, can't find the hard coded value in the code for some reason.

  • ID: 11221
  • Permalink
  • 1