While running a dbimport the following error ocurred:
$time dbimport db1 -d datadbs -i /mnt/ids2_data/20091024
19:10:21 shm_fe.c, line 933, shm wrong buffer status
*** put loadcur
25587 - Network receive failed.
-404 - The cursor or statement is not available.
-349 - Database not selected yet.
-349 - Database not selected yet.
real 45m50.013s
user 27m29.761s
sys 0m32.750s
$tail dbimport.out
log_ver char(20),
fec_obj date,
time_obj char(
,
log_obj char(20),
fec_reso date,
time_reso char(
,
log_reso char(20)
);
*** put loadcur
25587 - Network receive failed.
The engine was still running after that error. I had nothing else
running on the server besides the dbimport. The engine was bounced
just before starting the dbimport. Previous dbimports of the same
database have completed without errors.
What could have caused that error?
online.log:
10/25/09 18:23:48 IBM Informix Dynamic Server Stopped.
18:23:56 IBM Informix Dynamic Server Started.
18:23:56 Segment locked: addr=0x44000000, size=679391232
Sun Oct 25 18:23:58 2009
10/25/09 18:23:58 Event alarms enabled. ALARMPROG = '/home/informix/
etc/alarmprogram.sh'
10/25/09 18:23:58 Booting Language <c> from module
10/25/09 18:23:58 Loading Module <CNULL
10/25/09 18:23:58 Booting Language <builtin> from module
10/25/09 18:23:58 Loading Module <BUILTINNULL
10/25/09 18:24:03 DR: DRAUTO is 0 (Off)
10/25/09 18:24:03 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
10/25/09 18:24:03 Dynamically allocated new message shared memory
segment (size 2600KB)
10/25/09 18:24:03 Memory sizes:resident:663468 KB, virtual:1005200 KB,
no SHMTOTAL limit
10/25/09 18:24:03 Dynamically allocated new message shared memory
segment (size 2600KB)
10/25/09 18:24:03 Memory sizes:resident:663468 KB, virtual:1007800 KB,
no SHMTOTAL limit
10/25/09 18:24:03 Dynamically allocated new message shared memory
segment (size 2600KB)
10/25/09 18:24:03 Memory sizes:resident:663468 KB, virtual:1010400 KB,
no SHMTOTAL limit
10/25/09 18:24:03 Event notification facility epoll enabled.
10/25/09 18:24:03 IBM Informix Dynamic Server Version 11.50.UC1
Software Serial Number AAA#B000000
10/25/09 18:24:07 IBM Informix Dynamic Server Initialized -- Shared
Memory Initialized.
10/25/09 18:24:07 Started 1 btree scanners.
10/25/09 18:24:07 Btree scanner threshold set at 5000.
10/25/09 18:24:07 Btree scanner range scan size set to -1.
10/25/09 18:24:07 Btree scanner ALICE mode set to 6.
10/25/09 18:24:07 Physical Recovery Started at Page (13:835554).
10/25/09 18:24:07 Physical Recovery Complete: 0 Pages Examined, 0
Pages Restored.
10/25/09 18:24:07 Logical Recovery Started.
10/25/09 18:24:07 10 recovery worker threads will be started.
10/25/09 18:24:08 Logical Recovery has reached the transaction cleanup
phase.
10/25/09 18:24:08 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
10/25/09 18:24:09 Dataskip is now OFF for all dbspaces
10/25/09 18:24:09 Checkpoint Completed: duration was 0 seconds.
10/25/09 18:24:09 Sun Oct 25 - loguniq 14, logpos 0xf78018, timestamp:
0x76190026 Interval: 7479
10/25/09 18:24:09 Maximum server connections 0
10/25/09 18:24:09 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 0, Plog used 0, Llog used 1
10/25/09 18:24:09 On-Line Mode
10/25/09 18:24:11 SCHAPI: Started dbScheduler thread.
10/25/09 18:24:11 Booting Language <spl> from module
10/25/09 18:24:11 Loading Module <SPLNULL
10/25/09 18:24:11 SCHAPI: Started 2 dbWorker threads.
10/25/09 18:31:59 Checkpoint Completed: duration was 140 seconds.
10/25/09 18:31:59 Sun Oct 25 - loguniq 14, logpos 0x16f3018,
timestamp: 0x768aa741 Interval: 7480
10/25/09 18:31:59 Maximum server connections 1
10/25/09 18:31:59 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 386083, Llog used 1937
10/25/09 18:35:28 Checkpoint Completed: duration was 29 seconds.
10/25/09 18:35:28 Sun Oct 25 - loguniq 14, logpos 0x17c626c,
timestamp: 0x76ff605e Interval: 7481
10/25/09 18:35:28 Maximum server connections 1
10/25/09 18:35:28 Checkpoint Statistics - Avg. Txn Block Time 0.214, #
Txns blocked 1, Plog used 176760, Llog used 243
10/25/09 18:40:38 Checkpoint Completed: duration was 9 seconds.
10/25/09 18:40:38 Sun Oct 25 - loguniq 14, logpos 0x18b8018,
timestamp: 0x778cf1e5 Interval: 7482
10/25/09 18:40:38 Maximum server connections 1
10/25/09 18:40:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 285, Llog used 244
10/25/09 18:45:47 Checkpoint Completed: duration was 9 seconds.
10/25/09 18:45:47 Sun Oct 25 - loguniq 14, logpos 0x18ff018,
timestamp: 0x78165148 Interval: 7483
10/25/09 18:45:47 Maximum server connections 1
10/25/09 18:45:47 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 112, Llog used 73
10/25/09 18:50:56 Checkpoint Completed: duration was 9 seconds.
10/25/09 18:50:56 Sun Oct 25 - loguniq 14, logpos 0x1944018,
timestamp: 0x789b2f72 Interval: 7484
10/25/09 18:50:56 Maximum server connections 1
10/25/09 18:50:56 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 107, Llog used 71
10/25/09 18:56:06 Checkpoint Completed: duration was 9 seconds.
10/25/09 18:56:06 Sun Oct 25 - loguniq 14, logpos 0x1987018,
timestamp: 0x791c8e01 Interval: 7485
10/25/09 18:56:06 Maximum server connections 1
10/25/09 18:56:06 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 104, Llog used 69
10/25/09 19:01:22 Checkpoint Completed: duration was 16 seconds.
10/25/09 19:01:22 Sun Oct 25 - loguniq 14, logpos 0x19cc018,
timestamp: 0x79a3b12c Interval: 7486
10/25/09 19:01:22 Maximum server connections 1
10/25/09 19:01:22 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 1, Plog used 109, Llog used 73
10/25/09 19:06:44 Checkpoint Completed: duration was 21 seconds.
10/25/09 19:06:44 Sun Oct 25 - loguniq 14, logpos 0x1a2c26c,
timestamp: 0x7a279870 Interval: 7487
10/25/09 19:06:44 Maximum server connections 1
10/25/09 19:06:44 Checkpoint Statistics - Avg. Txn Block Time 0.972, #
Txns blocked 1, Plog used 396, Llog used 103
10/25/09 19:10:20 Adjusting LRU for bufferpool - id 0 size 2k
10/25/09 19:10:20 Old max 60.0 min 50.0 New max 59.4 min 49.5
10/25/09 19:12:19 Checkpoint Completed: duration was 35 seconds.
10/25/09 19:12:19 Sun Oct 25 - loguniq 14, logpos 0x1a35018,
timestamp: 0x7a719dd8 Interval: 7488
10/25/09 19:12:19 Maximum server connections 1
10/25/09 19:12:19 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 0, Plog used 184, Llog used 9
