Recreation DB - ams fails on second user

[ryzom-pipeline]

Original report by Michael Ambrus (Bitbucket: Aprak, GitHub: Aprak).

---

Repeatable issue (3 times in a row):

Code tip: changeset: 4060:4fc7c5e3b2dc branch: php-mysqli-refactor tag: tip parent: 4058:e7d85474f1c7 user: Cédric OCHS kervala@gmail.com date: Fri Jan 10 14:03:12 2014 +0100 summary: Close branch php-mysqli-refactor

To recreate:

Stop shard

Clean out all DB:s

DROP DATABASE nel; DROP DATABASE nel_tool; DROP DATABASE ring_open; DROP DATABASE ryzom_ams; DROP DATABASE ryzom_ams_lib;

Stop apache

( logrotate, not needed for issue - just makes cleaner logs)

logrotate --force /etc/logrotate.d/mysql-server logrotate --force /etc/logrotate.d/apache2

recreate DB:

rm ./ryzom/tools/server/ryzom_ams/www/is_installed http://ryzomcity.org/ shard start

Attachement details:

(3 parts.)

• Apache/sql logs after recreate DB
• Apache/sql logs after SUCCESSFUL creating 1:st user (4 time access-buttin click in client)
• Apache/sql logs after FAILING creating 2:nd user (4 time access-button click in client)

Other

Might be relevant. Another host (64-bit Ubuntu, 13.11) Issue can't be recreated. That code is slightly older:

Code tip: changeset: 4046:a0ffdb662317 tag: tip user: botanic date: Mon Dec 30 10:03:49 2013 -0800 summary: dont force null driver, doesnt work on all cards and disable maximising max while running pipeline

Host details: uname -a Linux localhost 3.12.6-x86-linode55 #2 SMP Tue Jan 14 08:41:36 EST 2014 i686 i686 i686 GNU/Linux

lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 13.04 Release: 13.04 Codename: raring

[ryzom-pipeline]

Original comment by Michael Ambrus (Bitbucket: Aprak, GitHub: Aprak).

---

Confirmed. Reverting to #4046 solves the issue. Definitely a DB setup problem (no rebuild needed, just change the scripts). Found the following (of a few) commit that satisfies the criteria in-between #4046 and #4060.

https://bitbucket.org/ryzom/ryzomcore/commits/b3edf560384a2dfc8491be80cf833a28b103c49f#chg-code/ryzom/tools/server/ryzom_ams/www/config.default.php

[ryzom-pipeline]

Original comment by Matthew Lagoe (Bitbucket: botanic, GitHub: botanic).

---

Changeset 73ea588

backed out the changes

[ryzom-pipeline]

Original comment by Michael Ambrus (Bitbucket: Aprak, GitHub: Aprak).

---

Confirmed to resolve the issue. This is a revert of 73ea588 iow