1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/TEST/t_sqlfilesrvcrash1.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,255 @@
1.4 +// Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +//
1.18 +
1.19 +/**
1.20 +Instructions:
1.21 +
1.22 +This is a manual test created to verify DEFXXXXX, 2 executables needs to be run to do this test
1.23 +1) t_sqlfilesrvcrash1.exe - Generate a corrupted journal file, this will cause the device to reset.
1.24 +2) t_sqlfilesrvcrash2.exe - After the reboot, tests if SQL can handle the courrpted journal file.
1.25 +
1.26 +This test requires a non-rugged drive to store the database file and therefore will only work in hardware mode
1.27 +*/
1.28 +
1.29 +#include <e32test.h>
1.30 +#include <f32file.h>
1.31 +#include <sqldb.h>
1.32 +
1.33 +RTest TheTest(_L("t_sqlfilesrvcrash1 test"));
1.34 +
1.35 +#if !defined __WINS__ && !defined __WINSCW__
1.36 +
1.37 +RFs TheFs;
1.38 +RSqlDatabase TheDb;
1.39 +
1.40 +const TInt KControlIoRuggedOn=2;
1.41 +const TInt KControlIoRuggedOff=3;
1.42 +const TInt KControlIoIsRugged=4;
1.43 +
1.44 +const TChar KDrvLetter = ('E');
1.45 +_LIT(KTestDir, "E:\\test\\");
1.46 +_LIT(KDbName, "E:\\test\\t_sqlfilesrvcrash.db");
1.47 +_LIT8(KConfigStr, "page_size=32768");
1.48 +_LIT(KFileSrvName, "efile.exe");
1.49 +
1.50 +///////////////////////////////////////////////////////////////////////////////////////
1.51 +//Deletes all created test files.
1.52 +void DeleteTestFiles()
1.53 + {
1.54 + TheDb.Close();
1.55 + (void)RSqlDatabase::Delete(KDbName);
1.56 + }
1.57 +
1.58 +///////////////////////////////////////////////////////////////////////////////////////
1.59 +//Test macros and functions
1.60 +void Check(TInt aValue, TInt aLine)
1.61 + {
1.62 + if(!aValue)
1.63 + {
1.64 + DeleteTestFiles();
1.65 + RDebug::Print(_L("*** Line %d\r\n"), aLine);
1.66 + TheTest(EFalse, aLine);
1.67 + }
1.68 + }
1.69 +void Check(TInt aValue, TInt aExpected, TInt aLine)
1.70 + {
1.71 + if(aValue != aExpected)
1.72 + {
1.73 + DeleteTestFiles();
1.74 + RDebug::Print(_L("*** Expected error: %d, got: %d\r\n"), aExpected, aValue);
1.75 + TheTest(EFalse, aLine);
1.76 + }
1.77 + }
1.78 +
1.79 +#define TEST(arg) ::Check((arg), __LINE__)
1.80 +#define TEST2(aValue, aExpected) ::Check(aValue, aExpected, __LINE__)
1.81 +
1.82 +///////////////////////////////////////////////////////////////////////////////////////
1.83 +//Set the drive to Rugged or non-rugged depending on the input parameter
1.84 +void SetDrive(TBool aSetToRugged)
1.85 + {
1.86 + TUint8 isRugged;
1.87 + TPtr8 pRugged(&isRugged,1,1);
1.88 +
1.89 + TInt drvNum;
1.90 + TInt err = TheFs.CharToDrive(KDrvLetter, drvNum);
1.91 + TEST2(err, KErrNone);
1.92 + err=TheFs.ControlIo(drvNum,KControlIoIsRugged,pRugged);
1.93 + TEST2(err, KErrNone);
1.94 +
1.95 + if(!aSetToRugged)
1.96 + {
1.97 + if(isRugged)
1.98 + {
1.99 + err=TheFs.ControlIo(drvNum,KControlIoRuggedOff);
1.100 + TEST2(err, KErrNone);
1.101 + }
1.102 + }
1.103 + else
1.104 + {
1.105 + if(!isRugged)
1.106 + {
1.107 + err=TheFs.ControlIo(drvNum,KControlIoRuggedOn);
1.108 + TEST2(err, KErrNone);
1.109 + }
1.110 + }
1.111 + }
1.112 +
1.113 +//Creates file session instance and the test directory
1.114 +void CreateTestEnv()
1.115 + {
1.116 + TInt err = TheFs.Connect();
1.117 + TEST2(err, KErrNone);
1.118 +
1.119 + //Set the drive to non-rugged
1.120 + TBool setDriveToRugged = EFalse;
1.121 + SetDrive(setDriveToRugged);
1.122 +
1.123 + err = TheFs.MkDir(KTestDir);
1.124 + TEST(err == KErrNone || err == KErrAlreadyExists);
1.125 + }
1.126 +
1.127 +TInt KillProcess(const TDesC& aProcessName)
1.128 + {
1.129 + TFullName name;
1.130 + //RDebug::Print(_L("Find and kill \"%S\" process.\n"), &aProcessName);
1.131 + TBuf<64> pattern(aProcessName);
1.132 + TInt length = pattern.Length();
1.133 + pattern += _L("*");
1.134 + TFindProcess procFinder(pattern);
1.135 +
1.136 + while (procFinder.Next(name) == KErrNone)
1.137 + {
1.138 + if (name.Length() > length)
1.139 + {//If found name is a string containing aProcessName string.
1.140 + TChar c(name[length]);
1.141 + if (c.IsAlphaDigit() ||
1.142 + c == TChar('_') ||
1.143 + c == TChar('-'))
1.144 + {
1.145 + //RDebug::Print(_L(":: Process name: \"%S\".\n"), &name);
1.146 + continue;
1.147 + }
1.148 + }
1.149 + RProcess proc;
1.150 + if (proc.Open(name) == KErrNone)
1.151 + {
1.152 + RDebug::Print(_L("About to kill process \"%S\", This will force a reboot\n"), &name);
1.153 + proc.Kill(0);
1.154 +
1.155 + }
1.156 + proc.Close();
1.157 + }
1.158 + return KErrNone;
1.159 + }
1.160 +
1.161 +/**
1.162 +@SYMTestCaseID PDS-SQL-CT-4164
1.163 +@SYMTestCaseDesc Tests for DEF144027: SQL Open returns error if the reported and actual file size are different
1.164 + This function creates a corrupted jorunal file on a non-rugged FAT, where the actual and
1.165 + reported file size is different. This is done by killing the file server forcing the device to
1.166 + reset. After the reset t_sqlfilesrvcrash2.exe is used to verify SQL can handle this corrupted
1.167 + journal file properly.
1.168 +@SYMTestActions DEF144027: SQL Open returns error if the reported and actual file size are different
1.169 +@SYMTestExpectedResults Test must not fail
1.170 +@SYMTestPriority Medium
1.171 +@SYMDEF DEF144027
1.172 + DEF144238
1.173 +*/
1.174 +void DEF144027()
1.175 + {
1.176 + TInt err = TheDb.Create(KDbName, &KConfigStr);
1.177 + TEST2(err, KErrNone);
1.178 +
1.179 + err = TheDb.Exec(_L("CREATE TABLE t1(NUM INTEGER)"));
1.180 + TEST2(err, 1);
1.181 + err = TheDb.Exec(_L("CREATE TABLE t2(NUM INTEGER)"));
1.182 + TEST2(err, 1);
1.183 +
1.184 + err = TheDb.Exec(_L("INSERT INTO t1(NUM) VALUES (1)"));
1.185 + TEST2(err, 1);
1.186 +
1.187 + err = TheDb.Exec(_L("INSERT INTO t2(NUM) VALUES (1)"));
1.188 + TEST2(err, 1);
1.189 +
1.190 + TheDb.Close();
1.191 +
1.192 + err = TheDb.Open(KDbName);
1.193 + TEST2(err, KErrNone);
1.194 +
1.195 + err = TheDb.Exec(_L("BEGIN"));
1.196 + TEST(err >= 0);
1.197 +
1.198 + err = TheDb.Exec(_L("CREATE TABLE t3(NUM INTEGER)"));
1.199 + TEST2(err, KErrNone);
1.200 +
1.201 + err = TheDb.Exec(_L("INSERT INTO t1(NUM) VALUES (1)"));
1.202 + TEST2(err, 1);
1.203 +
1.204 + err = TheDb.Exec(_L("INSERT INTO t2(NUM) VALUES (1)"));
1.205 + TEST2(err, 1);
1.206 +
1.207 + err = TheDb.Exec(_L("INSERT INTO t3(NUM) VALUES (1)"));
1.208 + TEST2(err, 1);
1.209 +
1.210 +
1.211 + //Here the transaction is committed but the database is not close
1.212 + //this makes sure that the journal is truncated but not deleted
1.213 + err = TheDb.Exec(_L("COMMIT"));
1.214 + TEST(err >= 0);
1.215 +
1.216 + //Reset the drive to rugged
1.217 + TBool setDriveToRugged = ETrue;
1.218 + SetDrive(setDriveToRugged);
1.219 +
1.220 + //When the file server is killed, the file size meta data will not be updated
1.221 + KillProcess(KFileSrvName);
1.222 + }
1.223 +
1.224 +void DoTests()
1.225 + {
1.226 + TheTest.Start(_L(" @SYMTestCaseID:PDS-SQL-CT-4164 DEF144027: SQL Open returns error if the reported and actual file size are different"));
1.227 + DEF144027();
1.228 + }
1.229 +#endif //#if !defined __WINS__ && !defined __WINSCW__
1.230 +
1.231 +TInt E32Main()
1.232 + {
1.233 + TheTest.Title();
1.234 +
1.235 + CTrapCleanup* tc = CTrapCleanup::New();
1.236 +
1.237 + __UHEAP_MARK;
1.238 +
1.239 +#if !defined __WINS__ && !defined __WINSCW__
1.240 + CreateTestEnv();
1.241 + DeleteTestFiles();
1.242 + DoTests();
1.243 + TheFs.Close();
1.244 + TheTest.End();
1.245 +#else
1.246 + TheTest.Start(_L("This test works only works on hardware!"));
1.247 + TheTest.End();
1.248 +#endif
1.249 +
1.250 + __UHEAP_MARKEND;
1.251 +
1.252 + TheTest.Close();
1.253 +
1.254 + delete tc;
1.255 +
1.256 + User::Heap().Check();
1.257 + return KErrNone;
1.258 + }