| Index: third_party/sqlite/src/test/threadtest3.c
|
| diff --git a/third_party/sqlite/src/test/threadtest3.c b/third_party/sqlite/src/test/threadtest3.c
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..cb7e2fa41b190d7ccc2613503ac6a60dcf1aae72
|
| --- /dev/null
|
| +++ b/third_party/sqlite/src/test/threadtest3.c
|
| @@ -0,0 +1,1461 @@
|
| +
|
| +/*
|
| +** The code in this file runs a few multi-threaded test cases using the
|
| +** SQLite library. It can be compiled to an executable on unix using the
|
| +** following command:
|
| +**
|
| +** gcc -O2 threadtest3.c sqlite3.c -ldl -lpthread -lm
|
| +**
|
| +** Then run the compiled program. The exit status is non-zero if any tests
|
| +** failed (hopefully there is also some output to stdout to clarify what went
|
| +** wrong).
|
| +**
|
| +** There are three parts to the code in this file, in the following order:
|
| +**
|
| +** 1. Code for the SQL aggregate function md5sum() copied from
|
| +** tclsqlite.c in the SQLite distribution. The names of all the
|
| +** types and functions in this section begin with "MD5" or "md5".
|
| +**
|
| +** 2. A set of utility functions that may be used to implement
|
| +** multi-threaded test cases. These are all called by test code
|
| +** via macros that help with error reporting. The macros are defined
|
| +** immediately below this comment.
|
| +**
|
| +** 3. The test code itself. And a main() routine to drive the test
|
| +** code.
|
| +*/
|
| +
|
| +/*************************************************************************
|
| +** Start of test code/infrastructure interface macros.
|
| +**
|
| +** The following macros constitute the interface between the test
|
| +** programs and the test infrastructure. Test infrastructure code
|
| +** does not itself use any of these macros. Test code should not
|
| +** call any of the macroname_x() functions directly.
|
| +**
|
| +** See the header comments above the corresponding macroname_x()
|
| +** function for a description of each interface.
|
| +*/
|
| +
|
| +/* Database functions */
|
| +#define opendb(w,x,y,z) (SEL(w), opendb_x(w,x,y,z))
|
| +#define closedb(y,z) (SEL(y), closedb_x(y,z))
|
| +
|
| +/* Functions to execute SQL */
|
| +#define sql_script(x,y,z) (SEL(x), sql_script_x(x,y,z))
|
| +#define integrity_check(x,y) (SEL(x), integrity_check_x(x,y))
|
| +#define execsql_i64(x,y,...) (SEL(x), execsql_i64_x(x,y,__VA_ARGS__))
|
| +#define execsql_text(x,y,z,...) (SEL(x), execsql_text_x(x,y,z,__VA_ARGS__))
|
| +#define execsql(x,y,...) (SEL(x), (void)execsql_i64_x(x,y,__VA_ARGS__))
|
| +
|
| +/* Thread functions */
|
| +#define launch_thread(w,x,y,z) (SEL(w), launch_thread_x(w,x,y,z))
|
| +#define join_all_threads(y,z) (SEL(y), join_all_threads_x(y,z))
|
| +
|
| +/* Timer functions */
|
| +#define setstoptime(y,z) (SEL(y), setstoptime_x(y,z))
|
| +#define timetostop(z) (SEL(z), timetostop_x(z))
|
| +
|
| +/* Report/clear errors. */
|
| +#define test_error(z, ...) test_error_x(z, sqlite3_mprintf(__VA_ARGS__))
|
| +#define clear_error(y,z) clear_error_x(y, z)
|
| +
|
| +/* File-system operations */
|
| +#define filesize(y,z) (SEL(y), filesize_x(y,z))
|
| +#define filecopy(x,y,z) (SEL(x), filecopy_x(x,y,z))
|
| +
|
| +/*
|
| +** End of test code/infrastructure interface macros.
|
| +*************************************************************************/
|
| +
|
| +
|
| +
|
| +
|
| +#include <sqlite3.h>
|
| +#include <unistd.h>
|
| +#include <stdio.h>
|
| +#include <pthread.h>
|
| +#include <assert.h>
|
| +#include <sys/types.h>
|
| +#include <sys/stat.h>
|
| +#include <string.h>
|
| +#include <fcntl.h>
|
| +#include <errno.h>
|
| +
|
| +/*
|
| + * This code implements the MD5 message-digest algorithm.
|
| + * The algorithm is due to Ron Rivest. This code was
|
| + * written by Colin Plumb in 1993, no copyright is claimed.
|
| + * This code is in the public domain; do with it what you wish.
|
| + *
|
| + * Equivalent code is available from RSA Data Security, Inc.
|
| + * This code has been tested against that, and is equivalent,
|
| + * except that you don't need to include two pages of legalese
|
| + * with every copy.
|
| + *
|
| + * To compute the message digest of a chunk of bytes, declare an
|
| + * MD5Context structure, pass it to MD5Init, call MD5Update as
|
| + * needed on buffers full of bytes, and then call MD5Final, which
|
| + * will fill a supplied 16-byte array with the digest.
|
| + */
|
| +
|
| +/*
|
| + * If compiled on a machine that doesn't have a 32-bit integer,
|
| + * you just set "uint32" to the appropriate datatype for an
|
| + * unsigned 32-bit integer. For example:
|
| + *
|
| + * cc -Duint32='unsigned long' md5.c
|
| + *
|
| + */
|
| +#ifndef uint32
|
| +# define uint32 unsigned int
|
| +#endif
|
| +
|
| +struct MD5Context {
|
| + int isInit;
|
| + uint32 buf[4];
|
| + uint32 bits[2];
|
| + unsigned char in[64];
|
| +};
|
| +typedef struct MD5Context MD5Context;
|
| +
|
| +/*
|
| + * Note: this code is harmless on little-endian machines.
|
| + */
|
| +static void byteReverse (unsigned char *buf, unsigned longs){
|
| + uint32 t;
|
| + do {
|
| + t = (uint32)((unsigned)buf[3]<<8 | buf[2]) << 16 |
|
| + ((unsigned)buf[1]<<8 | buf[0]);
|
| + *(uint32 *)buf = t;
|
| + buf += 4;
|
| + } while (--longs);
|
| +}
|
| +/* The four core functions - F1 is optimized somewhat */
|
| +
|
| +/* #define F1(x, y, z) (x & y | ~x & z) */
|
| +#define F1(x, y, z) (z ^ (x & (y ^ z)))
|
| +#define F2(x, y, z) F1(z, x, y)
|
| +#define F3(x, y, z) (x ^ y ^ z)
|
| +#define F4(x, y, z) (y ^ (x | ~z))
|
| +
|
| +/* This is the central step in the MD5 algorithm. */
|
| +#define MD5STEP(f, w, x, y, z, data, s) \
|
| + ( w += f(x, y, z) + data, w = w<<s | w>>(32-s), w += x )
|
| +
|
| +/*
|
| + * The core of the MD5 algorithm, this alters an existing MD5 hash to
|
| + * reflect the addition of 16 longwords of new data. MD5Update blocks
|
| + * the data and converts bytes into longwords for this routine.
|
| + */
|
| +static void MD5Transform(uint32 buf[4], const uint32 in[16]){
|
| + register uint32 a, b, c, d;
|
| +
|
| + a = buf[0];
|
| + b = buf[1];
|
| + c = buf[2];
|
| + d = buf[3];
|
| +
|
| + MD5STEP(F1, a, b, c, d, in[ 0]+0xd76aa478, 7);
|
| + MD5STEP(F1, d, a, b, c, in[ 1]+0xe8c7b756, 12);
|
| + MD5STEP(F1, c, d, a, b, in[ 2]+0x242070db, 17);
|
| + MD5STEP(F1, b, c, d, a, in[ 3]+0xc1bdceee, 22);
|
| + MD5STEP(F1, a, b, c, d, in[ 4]+0xf57c0faf, 7);
|
| + MD5STEP(F1, d, a, b, c, in[ 5]+0x4787c62a, 12);
|
| + MD5STEP(F1, c, d, a, b, in[ 6]+0xa8304613, 17);
|
| + MD5STEP(F1, b, c, d, a, in[ 7]+0xfd469501, 22);
|
| + MD5STEP(F1, a, b, c, d, in[ 8]+0x698098d8, 7);
|
| + MD5STEP(F1, d, a, b, c, in[ 9]+0x8b44f7af, 12);
|
| + MD5STEP(F1, c, d, a, b, in[10]+0xffff5bb1, 17);
|
| + MD5STEP(F1, b, c, d, a, in[11]+0x895cd7be, 22);
|
| + MD5STEP(F1, a, b, c, d, in[12]+0x6b901122, 7);
|
| + MD5STEP(F1, d, a, b, c, in[13]+0xfd987193, 12);
|
| + MD5STEP(F1, c, d, a, b, in[14]+0xa679438e, 17);
|
| + MD5STEP(F1, b, c, d, a, in[15]+0x49b40821, 22);
|
| +
|
| + MD5STEP(F2, a, b, c, d, in[ 1]+0xf61e2562, 5);
|
| + MD5STEP(F2, d, a, b, c, in[ 6]+0xc040b340, 9);
|
| + MD5STEP(F2, c, d, a, b, in[11]+0x265e5a51, 14);
|
| + MD5STEP(F2, b, c, d, a, in[ 0]+0xe9b6c7aa, 20);
|
| + MD5STEP(F2, a, b, c, d, in[ 5]+0xd62f105d, 5);
|
| + MD5STEP(F2, d, a, b, c, in[10]+0x02441453, 9);
|
| + MD5STEP(F2, c, d, a, b, in[15]+0xd8a1e681, 14);
|
| + MD5STEP(F2, b, c, d, a, in[ 4]+0xe7d3fbc8, 20);
|
| + MD5STEP(F2, a, b, c, d, in[ 9]+0x21e1cde6, 5);
|
| + MD5STEP(F2, d, a, b, c, in[14]+0xc33707d6, 9);
|
| + MD5STEP(F2, c, d, a, b, in[ 3]+0xf4d50d87, 14);
|
| + MD5STEP(F2, b, c, d, a, in[ 8]+0x455a14ed, 20);
|
| + MD5STEP(F2, a, b, c, d, in[13]+0xa9e3e905, 5);
|
| + MD5STEP(F2, d, a, b, c, in[ 2]+0xfcefa3f8, 9);
|
| + MD5STEP(F2, c, d, a, b, in[ 7]+0x676f02d9, 14);
|
| + MD5STEP(F2, b, c, d, a, in[12]+0x8d2a4c8a, 20);
|
| +
|
| + MD5STEP(F3, a, b, c, d, in[ 5]+0xfffa3942, 4);
|
| + MD5STEP(F3, d, a, b, c, in[ 8]+0x8771f681, 11);
|
| + MD5STEP(F3, c, d, a, b, in[11]+0x6d9d6122, 16);
|
| + MD5STEP(F3, b, c, d, a, in[14]+0xfde5380c, 23);
|
| + MD5STEP(F3, a, b, c, d, in[ 1]+0xa4beea44, 4);
|
| + MD5STEP(F3, d, a, b, c, in[ 4]+0x4bdecfa9, 11);
|
| + MD5STEP(F3, c, d, a, b, in[ 7]+0xf6bb4b60, 16);
|
| + MD5STEP(F3, b, c, d, a, in[10]+0xbebfbc70, 23);
|
| + MD5STEP(F3, a, b, c, d, in[13]+0x289b7ec6, 4);
|
| + MD5STEP(F3, d, a, b, c, in[ 0]+0xeaa127fa, 11);
|
| + MD5STEP(F3, c, d, a, b, in[ 3]+0xd4ef3085, 16);
|
| + MD5STEP(F3, b, c, d, a, in[ 6]+0x04881d05, 23);
|
| + MD5STEP(F3, a, b, c, d, in[ 9]+0xd9d4d039, 4);
|
| + MD5STEP(F3, d, a, b, c, in[12]+0xe6db99e5, 11);
|
| + MD5STEP(F3, c, d, a, b, in[15]+0x1fa27cf8, 16);
|
| + MD5STEP(F3, b, c, d, a, in[ 2]+0xc4ac5665, 23);
|
| +
|
| + MD5STEP(F4, a, b, c, d, in[ 0]+0xf4292244, 6);
|
| + MD5STEP(F4, d, a, b, c, in[ 7]+0x432aff97, 10);
|
| + MD5STEP(F4, c, d, a, b, in[14]+0xab9423a7, 15);
|
| + MD5STEP(F4, b, c, d, a, in[ 5]+0xfc93a039, 21);
|
| + MD5STEP(F4, a, b, c, d, in[12]+0x655b59c3, 6);
|
| + MD5STEP(F4, d, a, b, c, in[ 3]+0x8f0ccc92, 10);
|
| + MD5STEP(F4, c, d, a, b, in[10]+0xffeff47d, 15);
|
| + MD5STEP(F4, b, c, d, a, in[ 1]+0x85845dd1, 21);
|
| + MD5STEP(F4, a, b, c, d, in[ 8]+0x6fa87e4f, 6);
|
| + MD5STEP(F4, d, a, b, c, in[15]+0xfe2ce6e0, 10);
|
| + MD5STEP(F4, c, d, a, b, in[ 6]+0xa3014314, 15);
|
| + MD5STEP(F4, b, c, d, a, in[13]+0x4e0811a1, 21);
|
| + MD5STEP(F4, a, b, c, d, in[ 4]+0xf7537e82, 6);
|
| + MD5STEP(F4, d, a, b, c, in[11]+0xbd3af235, 10);
|
| + MD5STEP(F4, c, d, a, b, in[ 2]+0x2ad7d2bb, 15);
|
| + MD5STEP(F4, b, c, d, a, in[ 9]+0xeb86d391, 21);
|
| +
|
| + buf[0] += a;
|
| + buf[1] += b;
|
| + buf[2] += c;
|
| + buf[3] += d;
|
| +}
|
| +
|
| +/*
|
| + * Start MD5 accumulation. Set bit count to 0 and buffer to mysterious
|
| + * initialization constants.
|
| + */
|
| +static void MD5Init(MD5Context *ctx){
|
| + ctx->isInit = 1;
|
| + ctx->buf[0] = 0x67452301;
|
| + ctx->buf[1] = 0xefcdab89;
|
| + ctx->buf[2] = 0x98badcfe;
|
| + ctx->buf[3] = 0x10325476;
|
| + ctx->bits[0] = 0;
|
| + ctx->bits[1] = 0;
|
| +}
|
| +
|
| +/*
|
| + * Update context to reflect the concatenation of another buffer full
|
| + * of bytes.
|
| + */
|
| +static
|
| +void MD5Update(MD5Context *ctx, const unsigned char *buf, unsigned int len){
|
| + uint32 t;
|
| +
|
| + /* Update bitcount */
|
| +
|
| + t = ctx->bits[0];
|
| + if ((ctx->bits[0] = t + ((uint32)len << 3)) < t)
|
| + ctx->bits[1]++; /* Carry from low to high */
|
| + ctx->bits[1] += len >> 29;
|
| +
|
| + t = (t >> 3) & 0x3f; /* Bytes already in shsInfo->data */
|
| +
|
| + /* Handle any leading odd-sized chunks */
|
| +
|
| + if ( t ) {
|
| + unsigned char *p = (unsigned char *)ctx->in + t;
|
| +
|
| + t = 64-t;
|
| + if (len < t) {
|
| + memcpy(p, buf, len);
|
| + return;
|
| + }
|
| + memcpy(p, buf, t);
|
| + byteReverse(ctx->in, 16);
|
| + MD5Transform(ctx->buf, (uint32 *)ctx->in);
|
| + buf += t;
|
| + len -= t;
|
| + }
|
| +
|
| + /* Process data in 64-byte chunks */
|
| +
|
| + while (len >= 64) {
|
| + memcpy(ctx->in, buf, 64);
|
| + byteReverse(ctx->in, 16);
|
| + MD5Transform(ctx->buf, (uint32 *)ctx->in);
|
| + buf += 64;
|
| + len -= 64;
|
| + }
|
| +
|
| + /* Handle any remaining bytes of data. */
|
| +
|
| + memcpy(ctx->in, buf, len);
|
| +}
|
| +
|
| +/*
|
| + * Final wrapup - pad to 64-byte boundary with the bit pattern
|
| + * 1 0* (64-bit count of bits processed, MSB-first)
|
| + */
|
| +static void MD5Final(unsigned char digest[16], MD5Context *ctx){
|
| + unsigned count;
|
| + unsigned char *p;
|
| +
|
| + /* Compute number of bytes mod 64 */
|
| + count = (ctx->bits[0] >> 3) & 0x3F;
|
| +
|
| + /* Set the first char of padding to 0x80. This is safe since there is
|
| + always at least one byte free */
|
| + p = ctx->in + count;
|
| + *p++ = 0x80;
|
| +
|
| + /* Bytes of padding needed to make 64 bytes */
|
| + count = 64 - 1 - count;
|
| +
|
| + /* Pad out to 56 mod 64 */
|
| + if (count < 8) {
|
| + /* Two lots of padding: Pad the first block to 64 bytes */
|
| + memset(p, 0, count);
|
| + byteReverse(ctx->in, 16);
|
| + MD5Transform(ctx->buf, (uint32 *)ctx->in);
|
| +
|
| + /* Now fill the next block with 56 bytes */
|
| + memset(ctx->in, 0, 56);
|
| + } else {
|
| + /* Pad block to 56 bytes */
|
| + memset(p, 0, count-8);
|
| + }
|
| + byteReverse(ctx->in, 14);
|
| +
|
| + /* Append length in bits and transform */
|
| + ((uint32 *)ctx->in)[ 14 ] = ctx->bits[0];
|
| + ((uint32 *)ctx->in)[ 15 ] = ctx->bits[1];
|
| +
|
| + MD5Transform(ctx->buf, (uint32 *)ctx->in);
|
| + byteReverse((unsigned char *)ctx->buf, 4);
|
| + memcpy(digest, ctx->buf, 16);
|
| + memset(ctx, 0, sizeof(ctx)); /* In case it is sensitive */
|
| +}
|
| +
|
| +/*
|
| +** Convert a 128-bit MD5 digest into a 32-digit base-16 number.
|
| +*/
|
| +static void MD5DigestToBase16(unsigned char *digest, char *zBuf){
|
| + static char const zEncode[] = "0123456789abcdef";
|
| + int i, j;
|
| +
|
| + for(j=i=0; i<16; i++){
|
| + int a = digest[i];
|
| + zBuf[j++] = zEncode[(a>>4)&0xf];
|
| + zBuf[j++] = zEncode[a & 0xf];
|
| + }
|
| + zBuf[j] = 0;
|
| +}
|
| +
|
| +/*
|
| +** During testing, the special md5sum() aggregate function is available.
|
| +** inside SQLite. The following routines implement that function.
|
| +*/
|
| +static void md5step(sqlite3_context *context, int argc, sqlite3_value **argv){
|
| + MD5Context *p;
|
| + int i;
|
| + if( argc<1 ) return;
|
| + p = sqlite3_aggregate_context(context, sizeof(*p));
|
| + if( p==0 ) return;
|
| + if( !p->isInit ){
|
| + MD5Init(p);
|
| + }
|
| + for(i=0; i<argc; i++){
|
| + const char *zData = (char*)sqlite3_value_text(argv[i]);
|
| + if( zData ){
|
| + MD5Update(p, (unsigned char*)zData, strlen(zData));
|
| + }
|
| + }
|
| +}
|
| +static void md5finalize(sqlite3_context *context){
|
| + MD5Context *p;
|
| + unsigned char digest[16];
|
| + char zBuf[33];
|
| + p = sqlite3_aggregate_context(context, sizeof(*p));
|
| + MD5Final(digest,p);
|
| + MD5DigestToBase16(digest, zBuf);
|
| + sqlite3_result_text(context, zBuf, -1, SQLITE_TRANSIENT);
|
| +}
|
| +
|
| +/*************************************************************************
|
| +** End of copied md5sum() code.
|
| +*/
|
| +
|
| +typedef sqlite3_int64 i64;
|
| +
|
| +typedef struct Error Error;
|
| +typedef struct Sqlite Sqlite;
|
| +typedef struct Statement Statement;
|
| +
|
| +typedef struct Threadset Threadset;
|
| +typedef struct Thread Thread;
|
| +
|
| +/* Total number of errors in this process so far. */
|
| +static int nGlobalErr = 0;
|
| +
|
| +/* Set to true to run in "process" instead of "thread" mode. */
|
| +static int bProcessMode = 0;
|
| +
|
| +struct Error {
|
| + int rc;
|
| + int iLine;
|
| + char *zErr;
|
| +};
|
| +
|
| +struct Sqlite {
|
| + sqlite3 *db; /* Database handle */
|
| + Statement *pCache; /* Linked list of cached statements */
|
| + int nText; /* Size of array at aText[] */
|
| + char **aText; /* Stored text results */
|
| +};
|
| +
|
| +struct Statement {
|
| + sqlite3_stmt *pStmt; /* Pre-compiled statement handle */
|
| + Statement *pNext; /* Next statement in linked-list */
|
| +};
|
| +
|
| +struct Thread {
|
| + int iTid; /* Thread number within test */
|
| + int iArg; /* Integer argument passed by caller */
|
| +
|
| + pthread_t tid; /* Thread id */
|
| + char *(*xProc)(int, int); /* Thread main proc */
|
| + Thread *pNext; /* Next in this list of threads */
|
| +};
|
| +
|
| +struct Threadset {
|
| + int iMaxTid; /* Largest iTid value allocated so far */
|
| + Thread *pThread; /* Linked list of threads */
|
| +};
|
| +
|
| +static void free_err(Error *p){
|
| + sqlite3_free(p->zErr);
|
| + p->zErr = 0;
|
| + p->rc = 0;
|
| +}
|
| +
|
| +static void print_err(Error *p){
|
| + if( p->rc!=SQLITE_OK ){
|
| + printf("Error: (%d) \"%s\" at line %d\n", p->rc, p->zErr, p->iLine);
|
| + nGlobalErr++;
|
| + }
|
| +}
|
| +
|
| +static void print_and_free_err(Error *p){
|
| + print_err(p);
|
| + free_err(p);
|
| +}
|
| +
|
| +static void system_error(Error *pErr, int iSys){
|
| + pErr->rc = iSys;
|
| + pErr->zErr = (char *)sqlite3_malloc(512);
|
| + strerror_r(iSys, pErr->zErr, 512);
|
| + pErr->zErr[511] = '\0';
|
| +}
|
| +
|
| +static void sqlite_error(
|
| + Error *pErr,
|
| + Sqlite *pDb,
|
| + const char *zFunc
|
| +){
|
| + pErr->rc = sqlite3_errcode(pDb->db);
|
| + pErr->zErr = sqlite3_mprintf(
|
| + "sqlite3_%s() - %s (%d)", zFunc, sqlite3_errmsg(pDb->db),
|
| + sqlite3_extended_errcode(pDb->db)
|
| + );
|
| +}
|
| +
|
| +static void test_error_x(
|
| + Error *pErr,
|
| + char *zErr
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + pErr->rc = 1;
|
| + pErr->zErr = zErr;
|
| + }else{
|
| + sqlite3_free(zErr);
|
| + }
|
| +}
|
| +
|
| +static void clear_error_x(
|
| + Error *pErr,
|
| + int rc
|
| +){
|
| + if( pErr->rc==rc ){
|
| + pErr->rc = SQLITE_OK;
|
| + sqlite3_free(pErr->zErr);
|
| + pErr->zErr = 0;
|
| + }
|
| +}
|
| +
|
| +static int busyhandler(void *pArg, int n){
|
| + usleep(10*1000);
|
| + return 1;
|
| +}
|
| +
|
| +static void opendb_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* OUT: Database handle */
|
| + const char *zFile, /* Database file name */
|
| + int bDelete /* True to delete db file before opening */
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + int rc;
|
| + if( bDelete ) unlink(zFile);
|
| + rc = sqlite3_open(zFile, &pDb->db);
|
| + if( rc ){
|
| + sqlite_error(pErr, pDb, "open");
|
| + sqlite3_close(pDb->db);
|
| + pDb->db = 0;
|
| + }else{
|
| + sqlite3_create_function(
|
| + pDb->db, "md5sum", -1, SQLITE_UTF8, 0, 0, md5step, md5finalize
|
| + );
|
| + sqlite3_busy_handler(pDb->db, busyhandler, 0);
|
| + sqlite3_exec(pDb->db, "PRAGMA synchronous=OFF", 0, 0, 0);
|
| + }
|
| + }
|
| +}
|
| +
|
| +static void closedb_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb /* OUT: Database handle */
|
| +){
|
| + int rc;
|
| + int i;
|
| + Statement *pIter;
|
| + Statement *pNext;
|
| + for(pIter=pDb->pCache; pIter; pIter=pNext){
|
| + pNext = pIter->pNext;
|
| + sqlite3_finalize(pIter->pStmt);
|
| + sqlite3_free(pIter);
|
| + }
|
| + for(i=0; i<pDb->nText; i++){
|
| + sqlite3_free(pDb->aText[i]);
|
| + }
|
| + sqlite3_free(pDb->aText);
|
| + rc = sqlite3_close(pDb->db);
|
| + if( rc && pErr->rc==SQLITE_OK ){
|
| + pErr->zErr = sqlite3_mprintf("%s", sqlite3_errmsg(pDb->db));
|
| + }
|
| + memset(pDb, 0, sizeof(Sqlite));
|
| +}
|
| +
|
| +static void sql_script_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* Database handle */
|
| + const char *zSql /* SQL script to execute */
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + pErr->rc = sqlite3_exec(pDb->db, zSql, 0, 0, &pErr->zErr);
|
| + }
|
| +}
|
| +
|
| +static Statement *getSqlStatement(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* Database handle */
|
| + const char *zSql /* SQL statement */
|
| +){
|
| + Statement *pRet;
|
| + int rc;
|
| +
|
| + for(pRet=pDb->pCache; pRet; pRet=pRet->pNext){
|
| + if( 0==strcmp(sqlite3_sql(pRet->pStmt), zSql) ){
|
| + return pRet;
|
| + }
|
| + }
|
| +
|
| + pRet = sqlite3_malloc(sizeof(Statement));
|
| + rc = sqlite3_prepare_v2(pDb->db, zSql, -1, &pRet->pStmt, 0);
|
| + if( rc!=SQLITE_OK ){
|
| + sqlite_error(pErr, pDb, "prepare_v2");
|
| + return 0;
|
| + }
|
| + assert( 0==strcmp(sqlite3_sql(pRet->pStmt), zSql) );
|
| +
|
| + pRet->pNext = pDb->pCache;
|
| + pDb->pCache = pRet;
|
| + return pRet;
|
| +}
|
| +
|
| +static sqlite3_stmt *getAndBindSqlStatement(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* Database handle */
|
| + va_list ap /* SQL followed by parameters */
|
| +){
|
| + Statement *pStatement; /* The SQLite statement wrapper */
|
| + sqlite3_stmt *pStmt; /* The SQLite statement to return */
|
| + int i; /* Used to iterate through parameters */
|
| +
|
| + pStatement = getSqlStatement(pErr, pDb, va_arg(ap, const char *));
|
| + if( !pStatement ) return 0;
|
| + pStmt = pStatement->pStmt;
|
| + for(i=1; i<=sqlite3_bind_parameter_count(pStmt); i++){
|
| + const char *zName = sqlite3_bind_parameter_name(pStmt, i);
|
| + void * pArg = va_arg(ap, void*);
|
| +
|
| + switch( zName[1] ){
|
| + case 'i':
|
| + sqlite3_bind_int64(pStmt, i, *(i64 *)pArg);
|
| + break;
|
| +
|
| + default:
|
| + pErr->rc = 1;
|
| + pErr->zErr = sqlite3_mprintf("Cannot discern type: \"%s\"", zName);
|
| + pStmt = 0;
|
| + break;
|
| + }
|
| + }
|
| +
|
| + return pStmt;
|
| +}
|
| +
|
| +static i64 execsql_i64_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* Database handle */
|
| + ... /* SQL and pointers to parameter values */
|
| +){
|
| + i64 iRet = 0;
|
| + if( pErr->rc==SQLITE_OK ){
|
| + sqlite3_stmt *pStmt; /* SQL statement to execute */
|
| + va_list ap; /* ... arguments */
|
| + int i; /* Used to iterate through parameters */
|
| + va_start(ap, pDb);
|
| + pStmt = getAndBindSqlStatement(pErr, pDb, ap);
|
| + if( pStmt ){
|
| + int rc;
|
| + int first = 1;
|
| + while( SQLITE_ROW==sqlite3_step(pStmt) ){
|
| + if( first && sqlite3_column_count(pStmt)>0 ){
|
| + iRet = sqlite3_column_int64(pStmt, 0);
|
| + }
|
| + first = 0;
|
| + }
|
| + if( SQLITE_OK!=sqlite3_reset(pStmt) ){
|
| + sqlite_error(pErr, pDb, "reset");
|
| + }
|
| + }
|
| + va_end(ap);
|
| + }
|
| + return iRet;
|
| +}
|
| +
|
| +static char * execsql_text_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb, /* Database handle */
|
| + int iSlot, /* Db handle slot to store text in */
|
| + ... /* SQL and pointers to parameter values */
|
| +){
|
| + char *zRet = 0;
|
| +
|
| + if( iSlot>=pDb->nText ){
|
| + int nByte = sizeof(char *)*(iSlot+1);
|
| + pDb->aText = (char **)sqlite3_realloc(pDb->aText, nByte);
|
| + memset(&pDb->aText[pDb->nText], 0, sizeof(char*)*(iSlot+1-pDb->nText));
|
| + pDb->nText = iSlot+1;
|
| + }
|
| +
|
| + if( pErr->rc==SQLITE_OK ){
|
| + sqlite3_stmt *pStmt; /* SQL statement to execute */
|
| + va_list ap; /* ... arguments */
|
| + int i; /* Used to iterate through parameters */
|
| + va_start(ap, iSlot);
|
| + pStmt = getAndBindSqlStatement(pErr, pDb, ap);
|
| + if( pStmt ){
|
| + int rc;
|
| + int first = 1;
|
| + while( SQLITE_ROW==sqlite3_step(pStmt) ){
|
| + if( first && sqlite3_column_count(pStmt)>0 ){
|
| + zRet = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
|
| + sqlite3_free(pDb->aText[iSlot]);
|
| + pDb->aText[iSlot] = zRet;
|
| + }
|
| + first = 0;
|
| + }
|
| + if( SQLITE_OK!=sqlite3_reset(pStmt) ){
|
| + sqlite_error(pErr, pDb, "reset");
|
| + }
|
| + }
|
| + va_end(ap);
|
| + }
|
| +
|
| + return zRet;
|
| +}
|
| +
|
| +static void integrity_check_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Sqlite *pDb /* Database handle */
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + Statement *pStatement; /* Statement to execute */
|
| + int rc; /* Return code */
|
| + char *zErr = 0; /* Integrity check error */
|
| +
|
| + pStatement = getSqlStatement(pErr, pDb, "PRAGMA integrity_check");
|
| + if( pStatement ){
|
| + sqlite3_stmt *pStmt = pStatement->pStmt;
|
| + while( SQLITE_ROW==sqlite3_step(pStmt) ){
|
| + const char *z = sqlite3_column_text(pStmt, 0);
|
| + if( strcmp(z, "ok") ){
|
| + if( zErr==0 ){
|
| + zErr = sqlite3_mprintf("%s", z);
|
| + }else{
|
| + zErr = sqlite3_mprintf("%z\n%s", zErr, z);
|
| + }
|
| + }
|
| + }
|
| + sqlite3_reset(pStmt);
|
| +
|
| + if( zErr ){
|
| + pErr->zErr = zErr;
|
| + pErr->rc = 1;
|
| + }
|
| + }
|
| + }
|
| +}
|
| +
|
| +static void *launch_thread_main(void *pArg){
|
| + Thread *p = (Thread *)pArg;
|
| + return (void *)p->xProc(p->iTid, p->iArg);
|
| +}
|
| +
|
| +static void launch_thread_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Threadset *pThreads, /* Thread set */
|
| + char *(*xProc)(int, int), /* Proc to run */
|
| + int iArg /* Argument passed to thread proc */
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + int iTid = ++pThreads->iMaxTid;
|
| + Thread *p;
|
| + int rc;
|
| +
|
| + p = (Thread *)sqlite3_malloc(sizeof(Thread));
|
| + memset(p, 0, sizeof(Thread));
|
| + p->iTid = iTid;
|
| + p->iArg = iArg;
|
| + p->xProc = xProc;
|
| +
|
| + rc = pthread_create(&p->tid, NULL, launch_thread_main, (void *)p);
|
| + if( rc!=0 ){
|
| + system_error(pErr, rc);
|
| + sqlite3_free(p);
|
| + }else{
|
| + p->pNext = pThreads->pThread;
|
| + pThreads->pThread = p;
|
| + }
|
| + }
|
| +}
|
| +
|
| +static void join_all_threads_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + Threadset *pThreads /* Thread set */
|
| +){
|
| + Thread *p;
|
| + Thread *pNext;
|
| + for(p=pThreads->pThread; p; p=pNext){
|
| + void *ret;
|
| + pNext = p->pNext;
|
| + int rc;
|
| + rc = pthread_join(p->tid, &ret);
|
| + if( rc!=0 ){
|
| + if( pErr->rc==SQLITE_OK ) system_error(pErr, rc);
|
| + }else{
|
| + printf("Thread %d says: %s\n", p->iTid, (ret==0 ? "..." : (char *)ret));
|
| + }
|
| + sqlite3_free(p);
|
| + }
|
| + pThreads->pThread = 0;
|
| +}
|
| +
|
| +static i64 filesize_x(
|
| + Error *pErr,
|
| + const char *zFile
|
| +){
|
| + i64 iRet = 0;
|
| + if( pErr->rc==SQLITE_OK ){
|
| + struct stat sStat;
|
| + if( stat(zFile, &sStat) ){
|
| + iRet = -1;
|
| + }else{
|
| + iRet = sStat.st_size;
|
| + }
|
| + }
|
| + return iRet;
|
| +}
|
| +
|
| +static void filecopy_x(
|
| + Error *pErr,
|
| + const char *zFrom,
|
| + const char *zTo
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + i64 nByte = filesize_x(pErr, zFrom);
|
| + if( nByte<0 ){
|
| + test_error_x(pErr, sqlite3_mprintf("no such file: %s", zFrom));
|
| + }else{
|
| + i64 iOff;
|
| + char aBuf[1024];
|
| + int fd1;
|
| + int fd2;
|
| + unlink(zTo);
|
| +
|
| + fd1 = open(zFrom, O_RDONLY);
|
| + if( fd1<0 ){
|
| + system_error(pErr, errno);
|
| + return;
|
| + }
|
| + fd2 = open(zTo, O_RDWR|O_CREAT|O_EXCL, 0644);
|
| + if( fd2<0 ){
|
| + system_error(pErr, errno);
|
| + close(fd1);
|
| + return;
|
| + }
|
| +
|
| + iOff = 0;
|
| + while( iOff<nByte ){
|
| + int nCopy = sizeof(aBuf);
|
| + if( nCopy+iOff>nByte ){
|
| + nCopy = nByte - iOff;
|
| + }
|
| + if( nCopy!=read(fd1, aBuf, nCopy) ){
|
| + system_error(pErr, errno);
|
| + break;
|
| + }
|
| + if( nCopy!=write(fd2, aBuf, nCopy) ){
|
| + system_error(pErr, errno);
|
| + break;
|
| + }
|
| + iOff += nCopy;
|
| + }
|
| +
|
| + close(fd1);
|
| + close(fd2);
|
| + }
|
| + }
|
| +}
|
| +
|
| +/*
|
| +** Used by setstoptime() and timetostop().
|
| +*/
|
| +static double timelimit = 0.0;
|
| +static sqlite3_vfs *pTimelimitVfs = 0;
|
| +
|
| +static void setstoptime_x(
|
| + Error *pErr, /* IN/OUT: Error code */
|
| + int nMs /* Milliseconds until "stop time" */
|
| +){
|
| + if( pErr->rc==SQLITE_OK ){
|
| + double t;
|
| + int rc;
|
| + pTimelimitVfs = sqlite3_vfs_find(0);
|
| + rc = pTimelimitVfs->xCurrentTime(pTimelimitVfs, &t);
|
| + if( rc!=SQLITE_OK ){
|
| + pErr->rc = rc;
|
| + }else{
|
| + timelimit = t + ((double)nMs)/(1000.0*60.0*60.0*24.0);
|
| + }
|
| + }
|
| +}
|
| +
|
| +static int timetostop_x(
|
| + Error *pErr /* IN/OUT: Error code */
|
| +){
|
| + int ret = 1;
|
| + if( pErr->rc==SQLITE_OK ){
|
| + double t;
|
| + int rc;
|
| + rc = pTimelimitVfs->xCurrentTime(pTimelimitVfs, &t);
|
| + if( rc!=SQLITE_OK ){
|
| + pErr->rc = rc;
|
| + }else{
|
| + ret = (t >= timelimit);
|
| + }
|
| + }
|
| + return ret;
|
| +}
|
| +
|
| +/*
|
| +** The "Set Error Line" macro.
|
| +*/
|
| +#define SEL(e) ((e)->iLine = ((e)->rc ? (e)->iLine : __LINE__))
|
| +
|
| +
|
| +/*************************************************************************
|
| +**************************************************************************
|
| +**************************************************************************
|
| +** End infrastructure. Begin tests.
|
| +*/
|
| +
|
| +#define WALTHREAD1_NTHREAD 10
|
| +#define WALTHREAD3_NTHREAD 6
|
| +
|
| +static char *walthread1_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + int nIter = 0; /* Iterations so far */
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + while( !timetostop(&err) ){
|
| + const char *azSql[] = {
|
| + "SELECT md5sum(x) FROM t1 WHERE rowid != (SELECT max(rowid) FROM t1)",
|
| + "SELECT x FROM t1 WHERE rowid = (SELECT max(rowid) FROM t1)",
|
| + };
|
| + char *z1, *z2, *z3;
|
| +
|
| + execsql(&err, &db, "BEGIN");
|
| + integrity_check(&err, &db);
|
| + z1 = execsql_text(&err, &db, 1, azSql[0]);
|
| + z2 = execsql_text(&err, &db, 2, azSql[1]);
|
| + z3 = execsql_text(&err, &db, 3, azSql[0]);
|
| + execsql(&err, &db, "COMMIT");
|
| +
|
| + if( strcmp(z1, z2) || strcmp(z1, z3) ){
|
| + test_error(&err, "Failed read: %s %s %s", z1, z2, z3);
|
| + }
|
| +
|
| + sql_script(&err, &db,
|
| + "BEGIN;"
|
| + "INSERT INTO t1 VALUES(randomblob(100));"
|
| + "INSERT INTO t1 VALUES(randomblob(100));"
|
| + "INSERT INTO t1 SELECT md5sum(x) FROM t1;"
|
| + "COMMIT;"
|
| + );
|
| + nIter++;
|
| + }
|
| + closedb(&err, &db);
|
| +
|
| + print_and_free_err(&err);
|
| + return sqlite3_mprintf("%d iterations", nIter);
|
| +}
|
| +
|
| +static char *walthread1_ckpt_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + int nCkpt = 0; /* Checkpoints so far */
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + while( !timetostop(&err) ){
|
| + usleep(500*1000);
|
| + execsql(&err, &db, "PRAGMA wal_checkpoint");
|
| + if( err.rc==SQLITE_OK ) nCkpt++;
|
| + clear_error(&err, SQLITE_BUSY);
|
| + }
|
| + closedb(&err, &db);
|
| +
|
| + print_and_free_err(&err);
|
| + return sqlite3_mprintf("%d checkpoints", nCkpt);
|
| +}
|
| +
|
| +static void walthread1(int nMs){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + Threadset threads = {0}; /* Test threads */
|
| + int i; /* Iterator variable */
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA journal_mode = WAL;"
|
| + "CREATE TABLE t1(x PRIMARY KEY);"
|
| + "INSERT INTO t1 VALUES(randomblob(100));"
|
| + "INSERT INTO t1 VALUES(randomblob(100));"
|
| + "INSERT INTO t1 SELECT md5sum(x) FROM t1;"
|
| + );
|
| +
|
| + setstoptime(&err, nMs);
|
| + for(i=0; i<WALTHREAD1_NTHREAD; i++){
|
| + launch_thread(&err, &threads, walthread1_thread, 0);
|
| + }
|
| + launch_thread(&err, &threads, walthread1_ckpt_thread, 0);
|
| + join_all_threads(&err, &threads);
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +static char *walthread2_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + int anTrans[2] = {0, 0}; /* Number of WAL and Rollback transactions */
|
| +
|
| + const char *zJournal = "PRAGMA journal_mode = WAL";
|
| + if( iArg ){ zJournal = "PRAGMA journal_mode = DELETE"; }
|
| +
|
| + while( !timetostop(&err) ){
|
| + int journal_exists = 0;
|
| + int wal_exists = 0;
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| +
|
| + sql_script(&err, &db, zJournal);
|
| + clear_error(&err, SQLITE_BUSY);
|
| + sql_script(&err, &db, "BEGIN");
|
| + sql_script(&err, &db, "INSERT INTO t1 VALUES(NULL, randomblob(100))");
|
| +
|
| + journal_exists = (filesize(&err, "test.db-journal") >= 0);
|
| + wal_exists = (filesize(&err, "test.db-wal") >= 0);
|
| + if( (journal_exists+wal_exists)!=1 ){
|
| + test_error(&err, "File system looks incorrect (%d, %d)",
|
| + journal_exists, wal_exists
|
| + );
|
| + }
|
| + anTrans[journal_exists]++;
|
| +
|
| + sql_script(&err, &db, "COMMIT");
|
| + integrity_check(&err, &db);
|
| + closedb(&err, &db);
|
| + }
|
| +
|
| + print_and_free_err(&err);
|
| + return sqlite3_mprintf("W %d R %d", anTrans[0], anTrans[1]);
|
| +}
|
| +
|
| +static void walthread2(int nMs){
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| + Threadset threads = {0};
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db, "CREATE TABLE t1(x INTEGER PRIMARY KEY, y UNIQUE)");
|
| + closedb(&err, &db);
|
| +
|
| + setstoptime(&err, nMs);
|
| + launch_thread(&err, &threads, walthread2_thread, 0);
|
| + launch_thread(&err, &threads, walthread2_thread, 0);
|
| + launch_thread(&err, &threads, walthread2_thread, 1);
|
| + launch_thread(&err, &threads, walthread2_thread, 1);
|
| + join_all_threads(&err, &threads);
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +static char *walthread3_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + i64 iNextWrite; /* Next value this thread will write */
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + sql_script(&err, &db, "PRAGMA wal_autocheckpoint = 10");
|
| +
|
| + iNextWrite = iArg+1;
|
| + while( 1 ){
|
| + i64 sum1;
|
| + i64 sum2;
|
| + int stop = 0; /* True to stop executing (test timed out) */
|
| +
|
| + while( 0==(stop = timetostop(&err)) ){
|
| + i64 iMax = execsql_i64(&err, &db, "SELECT max(cnt) FROM t1");
|
| + if( iMax+1==iNextWrite ) break;
|
| + }
|
| + if( stop ) break;
|
| +
|
| + sum1 = execsql_i64(&err, &db, "SELECT sum(cnt) FROM t1");
|
| + sum2 = execsql_i64(&err, &db, "SELECT sum(sum1) FROM t1");
|
| + execsql_i64(&err, &db,
|
| + "INSERT INTO t1 VALUES(:iNextWrite, :iSum1, :iSum2)",
|
| + &iNextWrite, &sum1, &sum2
|
| + );
|
| + integrity_check(&err, &db);
|
| +
|
| + iNextWrite += WALTHREAD3_NTHREAD;
|
| + }
|
| +
|
| + closedb(&err, &db);
|
| + print_and_free_err(&err);
|
| + return 0;
|
| +}
|
| +
|
| +static void walthread3(int nMs){
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| + Threadset threads = {0};
|
| + int i;
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA journal_mode = WAL;"
|
| + "CREATE TABLE t1(cnt PRIMARY KEY, sum1, sum2);"
|
| + "CREATE INDEX i1 ON t1(sum1);"
|
| + "CREATE INDEX i2 ON t1(sum2);"
|
| + "INSERT INTO t1 VALUES(0, 0, 0);"
|
| + );
|
| + closedb(&err, &db);
|
| +
|
| + setstoptime(&err, nMs);
|
| + for(i=0; i<WALTHREAD3_NTHREAD; i++){
|
| + launch_thread(&err, &threads, walthread3_thread, i);
|
| + }
|
| + join_all_threads(&err, &threads);
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +static char *walthread4_reader_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + while( !timetostop(&err) ){
|
| + integrity_check(&err, &db);
|
| + }
|
| + closedb(&err, &db);
|
| +
|
| + print_and_free_err(&err);
|
| + return 0;
|
| +}
|
| +
|
| +static char *walthread4_writer_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + i64 iRow = 1;
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + sql_script(&err, &db, "PRAGMA wal_autocheckpoint = 15;");
|
| + while( !timetostop(&err) ){
|
| + execsql_i64(
|
| + &err, &db, "REPLACE INTO t1 VALUES(:iRow, randomblob(300))", &iRow
|
| + );
|
| + iRow++;
|
| + if( iRow==10 ) iRow = 0;
|
| + }
|
| + closedb(&err, &db);
|
| +
|
| + print_and_free_err(&err);
|
| + return 0;
|
| +}
|
| +
|
| +static void walthread4(int nMs){
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| + Threadset threads = {0};
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA journal_mode = WAL;"
|
| + "CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE);"
|
| + );
|
| + closedb(&err, &db);
|
| +
|
| + setstoptime(&err, nMs);
|
| + launch_thread(&err, &threads, walthread4_reader_thread, 0);
|
| + launch_thread(&err, &threads, walthread4_writer_thread, 0);
|
| + join_all_threads(&err, &threads);
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +static char *walthread5_thread(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + i64 nRow;
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + nRow = execsql_i64(&err, &db, "SELECT count(*) FROM t1");
|
| + closedb(&err, &db);
|
| +
|
| + if( nRow!=65536 ) test_error(&err, "Bad row count: %d", (int)nRow);
|
| + print_and_free_err(&err);
|
| + return 0;
|
| +}
|
| +static void walthread5(int nMs){
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| + Threadset threads = {0};
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA wal_autocheckpoint = 0;"
|
| + "PRAGMA page_size = 1024;"
|
| + "PRAGMA journal_mode = WAL;"
|
| + "CREATE TABLE t1(x);"
|
| + "BEGIN;"
|
| + "INSERT INTO t1 VALUES(randomblob(900));"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 2 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 4 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 8 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 16 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 32 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 64 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 128 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 256 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 512 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 1024 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 2048 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 4096 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 8192 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 16384 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 32768 */"
|
| + "INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 65536 */"
|
| + "COMMIT;"
|
| + );
|
| + filecopy(&err, "test.db", "test_sv.db");
|
| + filecopy(&err, "test.db-wal", "test_sv.db-wal");
|
| + closedb(&err, &db);
|
| +
|
| + filecopy(&err, "test_sv.db", "test.db");
|
| + filecopy(&err, "test_sv.db-wal", "test.db-wal");
|
| +
|
| + if( err.rc==SQLITE_OK ){
|
| + printf(" WAL file is %d bytes,", (int)filesize(&err,"test.db-wal"));
|
| + printf(" DB file is %d.\n", (int)filesize(&err,"test.db"));
|
| + }
|
| +
|
| + setstoptime(&err, nMs);
|
| + launch_thread(&err, &threads, walthread5_thread, 0);
|
| + launch_thread(&err, &threads, walthread5_thread, 0);
|
| + launch_thread(&err, &threads, walthread5_thread, 0);
|
| + launch_thread(&err, &threads, walthread5_thread, 0);
|
| + launch_thread(&err, &threads, walthread5_thread, 0);
|
| + join_all_threads(&err, &threads);
|
| +
|
| + if( err.rc==SQLITE_OK ){
|
| + printf(" WAL file is %d bytes,", (int)filesize(&err,"test.db-wal"));
|
| + printf(" DB file is %d.\n", (int)filesize(&err,"test.db"));
|
| + }
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +/*------------------------------------------------------------------------
|
| +** Test case "cgt_pager_1"
|
| +*/
|
| +#define CALLGRINDTEST1_NROW 10000
|
| +static void cgt_pager_1_populate(Error *pErr, Sqlite *pDb){
|
| + const char *zInsert = "INSERT INTO t1 VALUES(:iRow, zeroblob(:iBlob))";
|
| + i64 iRow;
|
| + sql_script(pErr, pDb, "BEGIN");
|
| + for(iRow=1; iRow<=CALLGRINDTEST1_NROW; iRow++){
|
| + i64 iBlob = 600 + (iRow%300);
|
| + execsql(pErr, pDb, zInsert, &iRow, &iBlob);
|
| + }
|
| + sql_script(pErr, pDb, "COMMIT");
|
| +}
|
| +static void cgt_pager_1_update(Error *pErr, Sqlite *pDb){
|
| + const char *zUpdate = "UPDATE t1 SET b = zeroblob(:iBlob) WHERE a = :iRow";
|
| + i64 iRow;
|
| + sql_script(pErr, pDb, "BEGIN");
|
| + for(iRow=1; iRow<=CALLGRINDTEST1_NROW; iRow++){
|
| + i64 iBlob = 600 + ((iRow+100)%300);
|
| + execsql(pErr, pDb, zUpdate, &iBlob, &iRow);
|
| + }
|
| + sql_script(pErr, pDb, "COMMIT");
|
| +}
|
| +static void cgt_pager_1_read(Error *pErr, Sqlite *pDb){
|
| + i64 iRow;
|
| + sql_script(pErr, pDb, "BEGIN");
|
| + for(iRow=1; iRow<=CALLGRINDTEST1_NROW; iRow++){
|
| + execsql(pErr, pDb, "SELECT * FROM t1 WHERE a = :iRow", &iRow);
|
| + }
|
| + sql_script(pErr, pDb, "COMMIT");
|
| +}
|
| +static void cgt_pager_1(int nMs){
|
| + void (*xSub)(Error *, Sqlite *);
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA cache_size = 2000;"
|
| + "PRAGMA page_size = 1024;"
|
| + "CREATE TABLE t1(a INTEGER PRIMARY KEY, b BLOB);"
|
| + );
|
| +
|
| + xSub = cgt_pager_1_populate; xSub(&err, &db);
|
| + xSub = cgt_pager_1_update; xSub(&err, &db);
|
| + xSub = cgt_pager_1_read; xSub(&err, &db);
|
| +
|
| + closedb(&err, &db);
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +/*------------------------------------------------------------------------
|
| +** Test case "dynamic_triggers"
|
| +**
|
| +** Two threads executing statements that cause deeply nested triggers
|
| +** to fire. And one thread busily creating and deleting triggers. This
|
| +** is an attempt to find a bug reported to us.
|
| +*/
|
| +
|
| +static char *dynamic_triggers_1(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + int nDrop = 0;
|
| + int nCreate = 0;
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + while( !timetostop(&err) ){
|
| + int i;
|
| +
|
| + for(i=1; i<9; i++){
|
| + char *zSql = sqlite3_mprintf(
|
| + "CREATE TRIGGER itr%d BEFORE INSERT ON t%d BEGIN "
|
| + "INSERT INTO t%d VALUES(new.x, new.y);"
|
| + "END;", i, i, i+1
|
| + );
|
| + execsql(&err, &db, zSql);
|
| + sqlite3_free(zSql);
|
| + nCreate++;
|
| + }
|
| +
|
| + for(i=1; i<9; i++){
|
| + char *zSql = sqlite3_mprintf(
|
| + "CREATE TRIGGER dtr%d BEFORE DELETE ON t%d BEGIN "
|
| + "DELETE FROM t%d WHERE x = old.x; "
|
| + "END;", i, i, i+1
|
| + );
|
| + execsql(&err, &db, zSql);
|
| + sqlite3_free(zSql);
|
| + nCreate++;
|
| + }
|
| +
|
| + for(i=1; i<9; i++){
|
| + char *zSql = sqlite3_mprintf("DROP TRIGGER itr%d", i);
|
| + execsql(&err, &db, zSql);
|
| + sqlite3_free(zSql);
|
| + nDrop++;
|
| + }
|
| +
|
| + for(i=1; i<9; i++){
|
| + char *zSql = sqlite3_mprintf("DROP TRIGGER dtr%d", i);
|
| + execsql(&err, &db, zSql);
|
| + sqlite3_free(zSql);
|
| + nDrop++;
|
| + }
|
| + }
|
| +
|
| + print_and_free_err(&err);
|
| + return sqlite3_mprintf("%d created, %d dropped", nCreate, nDrop);
|
| +}
|
| +
|
| +static char *dynamic_triggers_2(int iTid, int iArg){
|
| + Error err = {0}; /* Error code and message */
|
| + Sqlite db = {0}; /* SQLite database connection */
|
| + i64 iVal = 0;
|
| + int nInsert = 0;
|
| + int nDelete = 0;
|
| +
|
| + opendb(&err, &db, "test.db", 0);
|
| + while( !timetostop(&err) ){
|
| + do {
|
| + iVal = (iVal+1)%100;
|
| + execsql(&err, &db, "INSERT INTO t1 VALUES(:iX, :iY+1)", &iVal, &iVal);
|
| + nInsert++;
|
| + } while( iVal );
|
| +
|
| + do {
|
| + iVal = (iVal+1)%100;
|
| + execsql(&err, &db, "DELETE FROM t1 WHERE x = :iX", &iVal);
|
| + nDelete++;
|
| + } while( iVal );
|
| + }
|
| +
|
| + print_and_free_err(&err);
|
| + return sqlite3_mprintf("%d inserts, %d deletes", nInsert, nDelete);
|
| +}
|
| +
|
| +static void dynamic_triggers(int nMs){
|
| + Error err = {0};
|
| + Sqlite db = {0};
|
| + Threadset threads = {0};
|
| +
|
| + opendb(&err, &db, "test.db", 1);
|
| + sql_script(&err, &db,
|
| + "PRAGMA page_size = 1024;"
|
| + "PRAGMA journal_mode = WAL;"
|
| + "CREATE TABLE t1(x, y);"
|
| + "CREATE TABLE t2(x, y);"
|
| + "CREATE TABLE t3(x, y);"
|
| + "CREATE TABLE t4(x, y);"
|
| + "CREATE TABLE t5(x, y);"
|
| + "CREATE TABLE t6(x, y);"
|
| + "CREATE TABLE t7(x, y);"
|
| + "CREATE TABLE t8(x, y);"
|
| + "CREATE TABLE t9(x, y);"
|
| + );
|
| +
|
| + setstoptime(&err, nMs);
|
| +
|
| + sqlite3_enable_shared_cache(1);
|
| + launch_thread(&err, &threads, dynamic_triggers_2, 0);
|
| + launch_thread(&err, &threads, dynamic_triggers_2, 0);
|
| + sqlite3_enable_shared_cache(0);
|
| +
|
| + sleep(2);
|
| +
|
| + launch_thread(&err, &threads, dynamic_triggers_2, 0);
|
| + launch_thread(&err, &threads, dynamic_triggers_1, 0);
|
| +
|
| + join_all_threads(&err, &threads);
|
| +
|
| + print_and_free_err(&err);
|
| +}
|
| +
|
| +#include "tt3_checkpoint.c"
|
| +
|
| +int main(int argc, char **argv){
|
| + struct ThreadTest {
|
| + void (*xTest)(int);
|
| + const char *zTest;
|
| + int nMs;
|
| + } aTest[] = {
|
| + { walthread1, "walthread1", 20000 },
|
| + { walthread2, "walthread2", 20000 },
|
| + { walthread3, "walthread3", 20000 },
|
| + { walthread4, "walthread4", 20000 },
|
| + { walthread5, "walthread5", 1000 },
|
| + { walthread5, "walthread5", 1000 },
|
| +
|
| + { cgt_pager_1, "cgt_pager_1", 0 },
|
| + { dynamic_triggers, "dynamic_triggers", 20000 },
|
| +
|
| + { checkpoint_starvation_1, "checkpoint_starvation_1", 10000 },
|
| + { checkpoint_starvation_2, "checkpoint_starvation_2", 10000 },
|
| + };
|
| +
|
| + int i;
|
| + char *zTest = 0;
|
| + int nTest = 0;
|
| + int bTestfound = 0;
|
| + int bPrefix = 0;
|
| +
|
| + if( argc>2 ) goto usage;
|
| + if( argc==2 ){
|
| + zTest = argv[1];
|
| + nTest = strlen(zTest);
|
| + if( zTest[nTest-1]=='*' ){
|
| + nTest--;
|
| + bPrefix = 1;
|
| + }
|
| + }
|
| +
|
| + sqlite3_config(SQLITE_CONFIG_MULTITHREAD);
|
| +
|
| + for(i=0; i<sizeof(aTest)/sizeof(aTest[0]); i++){
|
| + char const *z = aTest[i].zTest;
|
| + int n = strlen(z);
|
| + if( !zTest || ((bPrefix || n==nTest) && 0==strncmp(zTest, z, nTest)) ){
|
| + printf("Running %s for %d seconds...\n", z, aTest[i].nMs/1000);
|
| + aTest[i].xTest(aTest[i].nMs);
|
| + bTestfound++;
|
| + }
|
| + }
|
| + if( bTestfound==0 ) goto usage;
|
| +
|
| + printf("Total of %d errors across all tests\n", nGlobalErr);
|
| + return (nGlobalErr>0 ? 255 : 0);
|
| +
|
| + usage:
|
| + printf("Usage: %s [testname|testprefix*]\n", argv[0]);
|
| + printf("Available tests are:\n");
|
| + for(i=0; i<sizeof(aTest)/sizeof(aTest[0]); i++){
|
| + printf(" %s\n", aTest[i].zTest);
|
| + }
|
| +
|
| + return 254;
|
| +}
|
| +
|
| +
|
|
|
Chromium Code Reviews
