Game mode: Online Private
Type of issue: Server Crash
Server type: Any
Region: NA
When using RCON to send SQL queries to a dedicated server, the server will crash under the following conditions.
- The query is a “select” statement
- The result of the query would contain at least one row where at least one of the columns has a null value
From server log:
[2020.05.25-19.45.49:803][761]LogWindows:Error: === Critical error: ===
[2020.05.25-19.45.49:804][761]LogWindows:Error:
[2020.05.25-19.45.49:805][761]LogWindows:Error: Fatal error!
[2020.05.25-19.45.49:805][761]LogWindows:Error:
[2020.05.25-19.45.49:806][761]LogWindows:Error: Unhandled Exception:
EXCEPTION_ACCESS_VIOLATION reading address 0x00000000
[2020.05.25-19.45.49:806][761]LogWindows:Error:
[2020.05.25-19.45.49:806][761]LogWindows:Error: !0x0000000000000000
[2020.05.25-19.45.49:807][761]LogWindows:Error:
Please provide a step-by-step process of how the bug can be reproduced. The more details you provide us with the easier it will be for us to find and fix the bug:
- Run a dedicated server with Rcon enabled
- Ensure there is at least one character created on the server that is not in a clan
- Connect to the server using an Rcon client (such as mcrcon 0.0.5)
- Run the following command from the connected Rcon client.
sql select * from characters - The server will crash and never respond to the Rcon client (because the guild and rank columns have null values)