Several times a minute, I get the following error message in my error logs. Is this something I need to be concerned about? Sometimes the number displayed is 36/38 instead.
2020-05-30 22:57:01|AccountsThread.Execute error: parameter list count mismatch (36/37)
2020-05-30 22:57:02|AccountsThread.Execute error: parameter list count mismatch (36/37)
2020-05-30 22:57:11|AccountsThread.Execute error: parameter list count mismatch (36/37)
2020-05-30 22:57:22|AccountsThread.Execute error: parameter list count mismatch (36/37)
AccountsThread.Execute
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: AccountsThread.Execute
Something got out of sync with the thread that makes updates to the Accounts.db database. You should close and restart as soon as possible.
-
- Posts: 19
- Joined: Mon Feb 24, 2020 10:53 pm
Re: AccountsThread.Execute
I usually restart my server every couple of weeks or so, so I went back and checked and this message started showing up about three hours after my last reboot. Is there anything I can do to prevent this from happening in the future?
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: AccountsThread.Execute
Not sure what caused it. I would like to see your Event Log from the timestamps just before those errors.loquacious wrote:Is there anything I can do to prevent this from happening in the future?
-
- Posts: 19
- Joined: Mon Feb 24, 2020 10:53 pm
Re: AccountsThread.Execute
Will this work? It looks like it happens the second time the API makes a change to Player7, in this example.
Code: Select all
2020-05-26 09:50:26|System|Traffic - Seconds: 30, Bytes in: 16486, Bytes out: 546503, Total: 562989, Threads: 343
2020-05-26 09:50:28|House|Ring -0.05 balance 13934.73 (Rake Table1)
2020-05-26 09:50:28|House|Rake +0.05 balance 324.06 (Table1)
2020-05-26 09:50:29|House|Master +0 balance -20211.85 (API Player7)
2020-05-26 09:50:29|House|Master2 +0 balance 0 (API Player7)
2020-05-26 09:50:29|API|AccountsEdit from 12.23.34.45
2020-05-26 09:50:29|API|LogsHandHistory from 12.23.34.45
2020-05-26 09:50:29|API|AccountsList from 12.23.34.45
2020-05-26 09:50:31|House|Ring -0.80 balance 13933.93 (Rake Table9)
2020-05-26 09:50:31|House|Rake +0.80 balance 324.86 (Table9)
2020-05-26 09:50:31|API|AccountsList from 12.23.34.45
2020-05-26 09:50:32|API|LogsHandHistory from 12.23.34.45
2020-05-26 09:50:32|API|AccountsList from 12.23.34.45
2020-05-26 09:50:33|API|LogsHandHistory from 12.23.34.45
2020-05-26 09:50:37|API|AccountsList from 12.23.34.45
2020-05-26 09:50:38|API|AccountsList from 12.23.34.45
2020-05-26 09:50:39|Connect|Player8 disconnects session 000000BE, PC 56E82BFC
2020-05-26 09:50:41|API|AccountsList from 12.23.34.45
2020-05-26 09:50:41|API|AccountsList from 12.23.34.45
2020-05-26 09:50:42|API|LogsHandHistory from 12.23.34.45
2020-05-26 09:50:43|API|LogsHandHistory from 12.23.34.45
2020-05-26 09:50:44|API|AccountsList from 12.23.34.45
2020-05-26 09:50:44|API|AccountsList from 12.23.34.45
2020-05-26 09:50:44|API|AccountsSessionKey from 12.23.34.45
2020-05-26 09:50:44|API|AccountsList from 12.23.34.45
2020-05-26 09:50:46|API|AccountsList from 12.23.34.45
2020-05-26 09:50:47|Connect|Connection 000000C1 accepted from IP 17.28.39.40, PC 908A3811
2020-05-26 09:50:47|API|AccountsList from 12.23.34.45
2020-05-26 09:50:47|House|Master +0 balance -20211.85 (API Player7)
2020-05-26 09:50:47|House|Master2 +0 balance 0 (API Player7)
2020-05-26 09:50:47|API|AccountsEdit from 12.23.34.45
-
- Posts: 19
- Joined: Mon Feb 24, 2020 10:53 pm
Re: AccountsThread.Execute
In this instance, this line is in the error log at that time:
2020-05-26 09:50:47|AccountsThread.Execute error: parameter list count mismatch (36/37)
2020-05-26 09:50:47|AccountsThread.Execute error: parameter list count mismatch (36/37)
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: AccountsThread.Execute
What change was being made here: "2020-05-26 09:50:47|API|AccountsEdit" ?loquacious wrote:In this instance, this line is in the error log at that time:
2020-05-26 09:50:47|AccountsThread.Execute error: parameter list count mismatch (36/37)
-
- Posts: 19
- Joined: Mon Feb 24, 2020 10:53 pm
Re: AccountsThread.Execute
Is that log event triggered when AccountsIncBalance or AccountsDecBalance are called?
-
- Site Admin
- Posts: 5880
- Joined: Wed Mar 19, 2008 8:47 pm
Re: AccountsThread.Execute
Every API call gets a record in the event log as does anything that triggers an account balance change. But I'm curious as to what was being changed by the AccountsEdit command since that timestamp lines up with those error messages.loquacious wrote:Is that log event triggered when AccountsIncBalance or AccountsDecBalance are called?
-
- Posts: 19
- Joined: Mon Feb 24, 2020 10:53 pm
Re: AccountsThread.Execute
I'll see if I can start tracking those changes.