Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Preliminary fix for [b4a7ddc83f], shutdown the SQLite native interface when the AppDomain is being unloaded. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1d024437e53cdfbf99f3eb469440485c |
| User & Date: | mistachkin 2011-07-21 17:18:30 |
References
|
2011-07-21
| ||
| 21:48 | • Closed ticket [b4a7ddc83f]: Exception when reloading IIS application plus 4 other changes artifact: b2ecb59f9a user: mistachkin | |
Context
|
2011-07-21
| ||
| 21:46 | Add comment to warn about the nature of the current fix for [b4a7ddc83f]. check-in: f5c5f581dc user: mistachkin tags: trunk | |
| 17:18 | Preliminary fix for [b4a7ddc83f], shutdown the SQLite native interface when the AppDomain is being unloaded. check-in: 1d024437e5 user: mistachkin tags: trunk | |
| 17:15 | Update test case for [b4a7ddc83f]. check-in: 10f4be9ed4 user: mistachkin tags: trunk | |
Changes
Changes to System.Data.SQLite/SQLiteLog.cs.
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
...
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
/// Initializes the SQLite logging facilities.
/// </summary>
public static void Initialize()
{
lock (syncRoot)
{
//
// NOTE: Create a single "global"
//
if (_sql == null)
_sql = new SQLite3(SQLiteDateFormats.ISO8601);
//
// NOTE: Create a single "global" (i.e. per-process) callback
// to register with SQLite. This callback will pass the
// event on to any registered handler. We only want to
// do this once.
//
................................................................................
{
_callback = new SQLiteLogCallback(LogCallback);
int rc = _sql.SetLogCallback(_callback);
if (rc != 0)
throw new SQLiteException(rc,
"Failed to initialize logging interface.");
}
//
// NOTE: Logging is enabled by default.
//
_enabled = true;
//
// NOTE: For now, always setup the default log event handler.
//
AddDefaultHandler();
}
}
/// <summary>
/// This event is raised whenever SQLite raises a logging event.
/// Note that this should be set as one of the first things in the
/// application.
/// </summary>
public static event SQLiteLogEventHandler Log
|
>
>
>
>
>
>
>
>
>
|
|
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
...
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
|
/// Initializes the SQLite logging facilities.
/// </summary>
public static void Initialize()
{
lock (syncRoot)
{
//
// NOTE: Add an event handler for the DomainUnload event so
// that we can unhook our logging managed function
// pointer from the native SQLite code prior to it
// being invalidated.
//
AppDomain.CurrentDomain.DomainUnload +=
new EventHandler(DomainUnload);
//
// NOTE: Create an instance of the SQLite wrapper class.
//
if (_sql == null)
_sql = new SQLite3(SQLiteDateFormats.Default);
//
// NOTE: Create a single "global" (i.e. per-process) callback
// to register with SQLite. This callback will pass the
// event on to any registered handler. We only want to
// do this once.
//
................................................................................
{
_callback = new SQLiteLogCallback(LogCallback);
int rc = _sql.SetLogCallback(_callback);
if (rc != 0)
throw new SQLiteException(rc,
"Failed to initialize logging.");
}
//
// NOTE: Logging is enabled by default.
//
_enabled = true;
//
// NOTE: For now, always setup the default log event handler.
//
AddDefaultHandler();
}
}
/// <summary>
/// Handles the AppDomain being unloaded.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private static void DomainUnload(
object sender,
EventArgs e
)
{
if (_sql != null)
{
int rc = _sql.Shutdown();
if (rc != 0)
throw new SQLiteException(rc,
"Failed to shutdown interface.");
rc = _sql.SetLogCallback(null);
if (rc != 0)
throw new SQLiteException(rc,
"Failed to shutdown logging.");
}
}
/// <summary>
/// This event is raised whenever SQLite raises a logging event.
/// Note that this should be set as one of the first things in the
/// application.
/// </summary>
public static event SQLiteLogEventHandler Log
|
Changes to Tests/tkt-b4a7ddc83f.eagle.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
..
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
package require EagleLibrary package require EagleTest runTestPrologue ############################################################################### # set ::test_configuration Debug source [file join $path common.eagle] runSQLiteTestPrologue ############################################################################### runTest {test tkt-b4a7ddc83f-1.1 {initialization/shutdown} -setup [subst { set fileName tkt-b4a7ddc83f-1.1.db set ::path {$::path} set ::test_configuration {$::test_configuration} source [file join $::path common.eagle] }] -body { package require EagleTest tryLoadAssembly System.Data.SQLite.dll ................................................................................ unset -nocomplain db fileName } -constraints {eagle monoBug28 command.sql compile.DATA\ compile.ISOLATED_INTERPRETERS System.Data.SQLite} -isolationLevel AppDomain \ -match regexp -result {^SQLiteConnection#\d+$}} ############################################################################### runTest {test tkt-b4a7ddc83f-1.2 {initialization/shutdown} -setup [subst { set fileName tkt-b4a7ddc83f-1.2.db set ::path {$::path} set ::test_configuration {$::test_configuration} source [file join $::path common.eagle] }] -body { package require EagleTest tryLoadAssembly System.Data.SQLite.dll |
<
<
|
|
|
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
..
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
package require EagleLibrary
package require EagleTest
runTestPrologue
###############################################################################
source [file join $path common.eagle]
runSQLiteTestPrologue
###############################################################################
runTest {test tkt-b4a7ddc83f-1.1 {logging shutdown, step 1} -setup [subst {
set fileName tkt-b4a7ddc83f-1.1.db
set ::path {$::path}
set ::test_configuration {$::test_configuration}
source [file join $::path common.eagle]
}] -body {
package require EagleTest
tryLoadAssembly System.Data.SQLite.dll
................................................................................
unset -nocomplain db fileName
} -constraints {eagle monoBug28 command.sql compile.DATA\
compile.ISOLATED_INTERPRETERS System.Data.SQLite} -isolationLevel AppDomain \
-match regexp -result {^SQLiteConnection#\d+$}}
###############################################################################
runTest {test tkt-b4a7ddc83f-1.2 {logging shutdown, step 2} -setup [subst {
set fileName tkt-b4a7ddc83f-1.2.db
set ::path {$::path}
set ::test_configuration {$::test_configuration}
source [file join $::path common.eagle]
}] -body {
package require EagleTest
tryLoadAssembly System.Data.SQLite.dll
|