The database disk image is malformed database disk image is malformed

[zelatech]

Hello,

 

 

i'm getting this error when trying to open the Game Services page.

 

The database disk image is malformed database disk image is malformed

 

log content:

11/14/2011 11:29:42 System.Data.SQLite System.Data.SQLite.SQLiteException: The database disk image is malformed

database disk image is malformed

at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)

at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at TCAdmin.SDK.Database.DatabaseManager.Execute(String sql) - Parameters: SELECT tc_game_services.*, tc_server_ips.hostname AS hostname, tc_services.user_package_id AS user_package_id, tc_services.server_id AS server_id, tc_services.user_id AS user_id, tc_services.startup AS startup, tc_services.affinity AS affinity, tc_services.priority AS priority, tc_services.display_name AS display_name, tc_services.executable AS executable, tc_services.cmdline AS cmdline, tc_services.working_dir AS working_dir, tc_services.root_dir AS root_dir, tc_services.billing_id AS billing_id, tc_services.billing_status AS billing_status, tc_services.app_data AS service_app_data, tc_users.user_name AS user_name, tc_users.owner_id AS user_owner_id, tc_servers.display_name AS server_name, tc_games.display_name AS game_name, tc_games.short_name AS game_short_name, tc_games.is_voice_server AS is_voice_server, tc_game_service_live_stats.online AS live_online, tc_game_service_live_stats.max_players AS live_max_players, tc_game_service_live_stats.players AS live_players, tc_game_service_live_stats.cpu AS live_cpu, tc_game_service_live_stats.memory/1024 AS live_memory, tc_game_service_live_stats.bytes_sec AS live_bytes_sec, tc_game_service_live_stats.pid AS live_pid FROM tc_game_services, tc_users, tc_servers, tc_games, tc_services, tc_server_ips, tc_game_service_live_stats WHERE (tc_servers.enabled = 1 AND tc_games.is_voice_server = 0 AND tc_game_services.service_id = tc_services.service_id AND tc_services.user_id = tc_users.user_id AND tc_services.server_id = tc_servers.server_id AND tc_game_services.game_id = tc_games.game_id AND tc_game_services.ip_address = tc_server_ips.ip_address AND tc_services.server_id = tc_server_ips.server_id AND tc_services.service_id = tc_game_service_live_stats.service_id AND tc_game_services.service_id = tc_services.service_id AND tc_services.user_id = tc_users.user_id AND tc_services.server_id = tc_servers.server_id AND tc_game_services.game_id = tc_games.game_id AND tc_game_services.ip_address = tc_server_ips.ip_address AND tc_services.server_id = tc_server_ips.server_id AND tc_services.service_id = tc_game_service_live_stats.service_id) ORDER BY tc_game_services.service_id ASC

11/14/2011 11:29:42 TCAdmin.SDK TCAdmin.SDK.Database.DatabaseException: The database disk image is malformed

database disk image is malformed ---> System.Data.SQLite.SQLiteException: The database disk image is malformed

database disk image is malformed

at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)

at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at TCAdmin.SDK.Database.DatabaseManager.Execute(String sql)

--- End of inner exception stack trace ---

at TCAdmin.SDK.Database.DatabaseManager.Execute(String sql)

at TCAdmin.DatabaseProviders.SqLite.SqLiteManager.Execute(String sql)

at TCAdmin.SDK.Objects.ObjectBase.GetAllRecords(WhereList where)

at TCAdmin.SDK.Objects.ObjectBase.GetObjectList(WhereList where)

at TCAdmin.GameHosting.SDK.Objects.Service.GetGameServices(String search)

at Web.GameHosting.GameServers1.GridGameServers_NeedDataSource(Object source, GridNeedDataSourceEventArgs e)

 

Does anyone know ho to fix? I've allready restarted the server.

 

Thanks!

[zelatech]

Ok seems i've fixed this issue with:

 

https://www.zotero.org/utils/dbfix/?upload=1

[Felipe T]

Thanks zelatech, i've got the same problems, and fixed like you did

 

=)

[zelatech]

happy it worked for you!

[Flightwatch]

If you use sqlite, just do a "vacuum" on the database with a sqlite-editor to rebuild the corrupt database.