Martin Simmons wrote:
On Fri, 07 Apr 2006 10:43:30 -0400, Emery Guevremont <[EMAIL PROTECTED]> said:
I have a weird problem. I'm trying to restore some files from a tape
backup taken a few months ago.
The problem is that the files aren't on the tape. If I use the query
command in bconsole to find out which tape has the files, it says the
files are on tape GKN079. If I check the "last date written" field for
tape GKN079 it says Dec. 23rd 2005. I can also confirm the files I'm
trying to restored when backed up on dec. 18 and dec. 20.
Now when I use the bls command to list the different jobs contained on
the tape, it stops at a job done on dec. 15. This is the last entry from
my bls command:
JobId : 9417
VerNum : 11
PoolName : BDDump
PoolType : Backup
JobName : VMDBDmaitre-BDDump
ClientName : vmdbdmaitre-fd
Job (unique name) : VMDBDmaitre-BDDump.2005-12-14_20.05.11
FileSet : BDDump-fs
JobType : B
JobLevel : I
JobFiles : 531
JobBytes : 5,129,941,915
StartBlock : 0
EndBlock : 4,463
StartFile : 55
EndFile : 54
JobErrors : 0
JobStatus : T
Date written : 15-Dec-2005 08:15
bls: Got EOF at file 61 on device /dev/nst0, Volume "GKN079"
bls: End of Volume at file 61 on device /dev/nst0, Volume "GKN079"
bls: End of all volumes.
End of physical tape.
What I'm wondering is where are the jobs that were done between dec. 15,
2005 and dec. 23, 2005?
I've also used the bls command to list the files on tape and the last
file on tape dates back to dec. 15. Here's how bls end after listing my
files:
End Session Record: VolSessionId=153 VolSessionTime=1134158972
JobId=9417 DataLen=209
bls: Got EOF at file 61 on device /dev/nst0, Volume "GKN079"
bls: End of Volume at file 61 on device /dev/nst0, Volume "GKN079"
bls: End of all volumes.
Unknown Record: VolSessionId=0 VolSessionTime=0 JobId=0 DataLen=0
4417 files found.
What does unknown record mean?
Whether I look at the logs or on bconsole, no errors ever happened with
the backups between dec. 15 and dec. 23. Everything indicates my backups
should be on tape GKN079, but I don't see it on the tape. Is the tape
dying? BTW I also tried reading the tape on a different drive, and I got
the same result.
I suggest you post the output of running
select * from jobmedia where mediaid=xx;
from the bconsole sql command, where xx is the mediaid of GKN079. Also, what
is the jobid of the job you are trying to restore?
__Martin
The jobid of the job in question is 9580. I've attached a file that
contains the output from the sql query. The problem starts from jobid
9435. Every jobs after 8435 aren't available. One thing I noticed is
that there's no start or end file number 61, it skips from 60 to 62.
Could this be causing the problem? If so, how do I force bextract to
skip fileid 61?
Entering SQL query mode.
Terminate each query with a semicolon.
Terminate query mode with a blank line.
Enter SQL query:
+------------+-------+---------+------------+-----------+-----------+---------+------------+----------+----------+
| JobMediaId | JobId | MediaId | FirstIndex | LastIndex | StartFile | EndFile |
StartBlock | EndBlock | VolIndex |
+------------+-------+---------+------------+-----------+-----------+---------+------------+----------+----------+
| 37,580 | 9,411 | 84 | 1 | 538 | 40 | 40 |
0 | 1,632 | 22,444 |
| 38,031 | 9,521 | 84 | 1 | 114 | 166 | 166 |
0 | 14,704 | 22,876 |
| 38,202 | 9,548 | 84 | 1 | 274 | 184 | 184 |
0 | 822 | 23,043 |
| 38,603 | 9,629 | 84 | 1 | 750 | 262 | 262 |
0 | 15,004 | 23,431 |
| 38,440 | 9,598 | 84 | 1 | 90 | 215 | 215 |
0 | 8,702 | 23,274 |
| 38,439 | 9,597 | 84 | 1 | 84 | 214 | 214 |
0 | 5,799 | 23,273 |
| 37,458 | 9,382 | 84 | 1 | 169 | 4 | 4 |
0 | 552 | 22,326 |
| 38,313 | 9,575 | 84 | 1 | 529 | 202 | 202 |
0 | 2,176 | 23,150 |
| 38,455 | 9,602 | 84 | 1 | 753 | 230 | 230 |
0 | 14,969 | 23,288 |
| 37,454 | 9,378 | 84 | 7 | 298 | 0 | 0 |
1 | 2,664 | 22,323 |
| 37,455 | 9,379 | 84 | 1 | 44 | 1 | 1 |
0 | 253 | 22,324 |
| 37,456 | 9,380 | 84 | 1 | 43 | 2 | 2 |
0 | 392 | 22,325 |
| 37,459 | 9,382 | 84 | 169 | 697 | 5 | 5 |
0 | 15,499 | 22,327 |
| 37,460 | 9,382 | 84 | 697 | 698 | 6 | 6 |
0 | 15,499 | 22,328 |
| 37,461 | 9,382 | 84 | 698 | 704 | 7 | 7 |
0 | 15,499 | 22,329 |
| 37,462 | 9,382 | 84 | 704 | 709 | 8 | 8 |
0 | 15,499 | 22,330 |
| 37,463 | 9,382 | 84 | 709 | 780 | 9 | 9 |
0 | 15,499 | 22,331 |
| 37,464 | 9,382 | 84 | 780 | 803 | 10 | 10 |
0 | 10,183 | 22,332 |
| 37,467 | 9,384 | 84 | 1 | 137 | 11 | 11 |
0 | 218 | 22,335 |
| 37,468 | 9,386 | 84 | 1 | 66 | 12 | 12 |
0 | 2,021 | 22,336 |
| 37,469 | 9,386 | 84 | 66 | 90 | 13 | 13 |
0 | 11,357 | 22,337 |
| 37,470 | 9,387 | 84 | 1 | 103 | 14 | 14 |
0 | 4,141 | 22,338 |
| 37,471 | 9,387 | 84 | 103 | 104 | 15 | 15 |
0 | 15,499 | 22,339 |
| 37,472 | 9,387 | 84 | 104 | 105 | 16 | 16 |
0 | 15,499 | 22,340 |
| 37,473 | 9,387 | 84 | 105 | 106 | 17 | 17 |
0 | 15,499 | 22,341 |
| 37,474 | 9,387 | 84 | 106 | 107 | 18 | 18 |
0 | 167 | 22,342 |
| 37,475 | 9,388 | 84 | 1 | 574 | 19 | 19 |
0 | 15,331 | 22,343 |
| 37,476 | 9,388 | 84 | 574 | 575 | 20 | 20 |
0 | 15,499 | 22,344 |
| 37,477 | 9,388 | 84 | 575 | 575 | 21 | 21 |
0 | 15,499 | 22,345 |
| 37,478 | 9,388 | 84 | 575 | 576 | 22 | 22 |
0 | 15,499 | 22,346 |
| 37,479 | 9,388 | 84 | 576 | 576 | 23 | 23 |
0 | 15,499 | 22,347 |
| 37,480 | 9,388 | 84 | 576 | 579 | 24 | 24 |
0 | 4,301 | 22,348 |
| 37,565 | 9,406 | 84 | 1 | 111 | 25 | 25 |
0 | 5,381 | 22,430 |
| 37,566 | 9,407 | 84 | 1 | 9 | 26 | 26 |
0 | 4,050 | 22,431 |
| 37,567 | 9,407 | 84 | 9 | 93 | 27 | 27 |
0 | 15,499 | 22,432 |
| 37,568 | 9,407 | 84 | 93 | 95 | 28 | 28 |
0 | 15,499 | 22,433 |
| 37,569 | 9,407 | 84 | 95 | 327 | 29 | 29 |
0 | 11,961 | 22,434 |
| 37,570 | 9,408 | 84 | 1 | 50 | 30 | 30 |
0 | 3,537 | 22,435 |
| 37,571 | 9,408 | 84 | 50 | 55 | 31 | 31 |
0 | 15,499 | 22,436 |
| 37,572 | 9,408 | 84 | 55 | 60 | 32 | 32 |
0 | 11,580 | 22,437 |
| 37,573 | 9,409 | 84 | 1 | 53 | 33 | 33 |
0 | 3,918 | 22,438 |
| 37,574 | 9,409 | 84 | 53 | 57 | 34 | 34 |
0 | 15,499 | 22,439 |
| 37,575 | 9,409 | 84 | 57 | 61 | 35 | 35 |
0 | 15,499 | 22,440 |
| 37,576 | 9,409 | 84 | 61 | 65 | 36 | 36 |
0 | 15,499 | 22,441 |
| 37,577 | 9,409 | 84 | 65 | 66 | 37 | 37 |
0 | 15,499 | 22,442 |
| 37,578 | 9,409 | 84 | 66 | 67 | 38 | 38 |
0 | 13,865 | 22,443 |
| 37,581 | 9,411 | 84 | 538 | 755 | 41 | 41 |
0 | 15,499 | 22,445 |
| 37,582 | 9,411 | 84 | 755 | 756 | 42 | 42 |
0 | 15,499 | 22,446 |
| 37,583 | 9,411 | 84 | 756 | 761 | 43 | 43 |
0 | 15,499 | 22,447 |
| 37,584 | 9,411 | 84 | 761 | 761 | 44 | 44 |
0 | 15,499 | 22,448 |
| 37,585 | 9,411 | 84 | 761 | 762 | 45 | 45 |
0 | 15,499 | 22,449 |
| 37,586 | 9,411 | 84 | 762 | 842 | 46 | 46 |
0 | 15,499 | 22,450 |
| 37,587 | 9,411 | 84 | 842 | 846 | 47 | 47 |
0 | 15,499 | 22,451 |
| 37,588 | 9,411 | 84 | 846 | 870 | 48 | 48 |
0 | 15,499 | 22,452 |
| 37,589 | 9,411 | 84 | 870 | 873 | 49 | 49 |
0 | 2,299 | 22,453 |
| 37,591 | 9,413 | 84 | 1 | 137 | 50 | 50 |
0 | 222 | 22,455 |
| 37,592 | 9,415 | 84 | 1 | 80 | 51 | 51 |
0 | 5,296 | 22,456 |
| 37,593 | 9,415 | 84 | 80 | 103 | 52 | 52 |
0 | 8,565 | 22,457 |
| 37,594 | 9,416 | 84 | 1 | 111 | 53 | 53 |
0 | 6,933 | 22,458 |
| 37,595 | 9,416 | 84 | 111 | 114 | 54 | 54 |
0 | 4,463 | 22,459 |
| 37,596 | 9,417 | 84 | 1 | 526 | 55 | 55 |
0 | 11,035 | 22,460 |
| 37,597 | 9,417 | 84 | 526 | 526 | 56 | 56 |
0 | 15,499 | 22,461 |
| 37,598 | 9,417 | 84 | 526 | 527 | 57 | 57 |
0 | 15,499 | 22,462 |
| 37,599 | 9,417 | 84 | 527 | 528 | 58 | 58 |
0 | 15,499 | 22,463 |
| 37,600 | 9,417 | 84 | 528 | 528 | 59 | 59 |
0 | 15,499 | 22,464 |
| 37,601 | 9,417 | 84 | 528 | 531 | 60 | 60 |
0 | 6,556 | 22,465 |
| 37,622 | 9,435 | 84 | 1 | 108 | 62 | 62 |
0 | 5,426 | 22,481 |
| 37,623 | 9,436 | 84 | 1 | 96 | 63 | 63 |
0 | 10,072 | 22,482 |
| 37,624 | 9,436 | 84 | 96 | 97 | 64 | 64 |
0 | 15,499 | 22,483 |
| 37,625 | 9,436 | 84 | 97 | 98 | 65 | 65 |
0 | 15,499 | 22,484 |
| 37,626 | 9,436 | 84 | 98 | 461 | 66 | 66 |
0 | 8,810 | 22,485 |
| 37,627 | 9,437 | 84 | 1 | 51 | 67 | 67 |
0 | 6,688 | 22,486 |
| 37,628 | 9,437 | 84 | 51 | 56 | 68 | 68 |
0 | 15,499 | 22,487 |
| 37,629 | 9,437 | 84 | 56 | 60 | 69 | 69 |
0 | 8,826 | 22,488 |
| 37,630 | 9,438 | 84 | 1 | 48 | 70 | 70 |
0 | 6,672 | 22,489 |
| 37,631 | 9,438 | 84 | 48 | 52 | 71 | 71 |
0 | 15,499 | 22,490 |
| 37,632 | 9,438 | 84 | 52 | 55 | 72 | 72 |
0 | 15,499 | 22,491 |
| 37,633 | 9,438 | 84 | 55 | 56 | 73 | 73 |
0 | 15,499 | 22,492 |
| 37,634 | 9,438 | 84 | 56 | 57 | 74 | 74 |
0 | 15,499 | 22,493 |
| 37,635 | 9,438 | 84 | 57 | 58 | 75 | 75 |
0 | 12,516 | 22,494 |
| 37,637 | 9,440 | 84 | 1 | 691 | 77 | 77 |
0 | 2,981 | 22,496 |
| 37,638 | 9,440 | 84 | 691 | 769 | 78 | 78 |
0 | 15,499 | 22,497 |
| 37,639 | 9,440 | 84 | 769 | 773 | 79 | 79 |
0 | 15,499 | 22,498 |
| 37,640 | 9,440 | 84 | 773 | 800 | 80 | 80 |
0 | 7,777 | 22,499 |
| 37,643 | 9,442 | 84 | 1 | 137 | 81 | 81 |
0 | 218 | 22,502 |
| 37,644 | 9,443 | 84 | 1 | 45 | 82 | 82 |
0 | 1 | 22,503 |
| 37,645 | 9,444 | 84 | 1 | 47 | 83 | 83 |
0 | 13 | 22,504 |
| 37,646 | 9,445 | 84 | 1 | 329 | 84 | 84 |
0 | 911 | 22,505 |
| 37,650 | 9,462 | 84 | 1 | 106 | 85 | 85 |
0 | 4,162 | 22,509 |
| 37,651 | 9,462 | 84 | 106 | 108 | 86 | 86 |
0 | 1,331 | 22,510 |
| 37,652 | 9,463 | 84 | 1 | 79 | 87 | 87 |
0 | 14,167 | 22,511 |
| 37,653 | 9,463 | 84 | 79 | 80 | 88 | 88 |
0 | 15,499 | 22,512 |
| 37,654 | 9,463 | 84 | 80 | 81 | 89 | 89 |
0 | 15,499 | 22,513 |
| 37,655 | 9,463 | 84 | 81 | 313 | 90 | 90 |
0 | 1,231 | 22,514 |
| 37,656 | 9,464 | 84 | 1 | 54 | 91 | 91 |
0 | 14,267 | 22,515 |
| 37,657 | 9,464 | 84 | 54 | 58 | 92 | 92 |
0 | 15,499 | 22,516 |
| 37,658 | 9,464 | 84 | 58 | 60 | 93 | 93 |
0 | 1,546 | 22,517 |
| 37,659 | 9,465 | 84 | 1 | 55 | 94 | 94 |
0 | 13,952 | 22,518 |
| 37,660 | 9,465 | 84 | 55 | 58 | 95 | 95 |
0 | 15,499 | 22,519 |
| 37,661 | 9,465 | 84 | 58 | 61 | 96 | 96 |
0 | 15,499 | 22,520 |
| 37,662 | 9,465 | 84 | 61 | 61 | 97 | 97 |
0 | 15,499 | 22,521 |
| 37,663 | 9,465 | 84 | 61 | 62 | 98 | 98 |
0 | 15,499 | 22,522 |
| 37,664 | 9,465 | 84 | 62 | 63 | 99 | 99 |
0 | 6,884 | 22,523 |
| 37,666 | 9,467 | 84 | 1 | 718 | 101 | 101 |
0 | 8,613 | 22,525 |
| 37,667 | 9,467 | 84 | 718 | 821 | 102 | 102 |
0 | 15,499 | 22,526 |
| 37,668 | 9,467 | 84 | 821 | 824 | 103 | 103 |
0 | 15,499 | 22,527 |
| 37,669 | 9,467 | 84 | 824 | 827 | 104 | 104 |
0 | 15,499 | 22,528 |
| 37,670 | 9,467 | 84 | 827 | 853 | 105 | 105 |
0 | 10,321 | 22,529 |
| 37,673 | 9,469 | 84 | 1 | 137 | 106 | 106 |
0 | 219 | 22,532 |
| 37,674 | 9,470 | 84 | 1 | 102 | 107 | 107 |
0 | 13,579 | 22,533 |
| 37,675 | 9,471 | 84 | 1 | 104 | 108 | 108 |
0 | 176 | 22,534 |
| 37,676 | 9,472 | 84 | 1 | 72 | 109 | 109 |
0 | 143 | 22,535 |
| 37,677 | 9,472 | 84 | 72 | 479 | 110 | 110 |
0 | 15,499 | 22,536 |
| 37,678 | 9,472 | 84 | 479 | 480 | 111 | 111 |
0 | 15,499 | 22,537 |
| 37,679 | 9,472 | 84 | 480 | 480 | 112 | 112 |
0 | 15,499 | 22,538 |
| 37,680 | 9,472 | 84 | 480 | 481 | 113 | 113 |
0 | 15,499 | 22,539 |
| 37,681 | 9,472 | 84 | 481 | 481 | 114 | 114 |
0 | 15,499 | 22,540 |
| 37,682 | 9,472 | 84 | 481 | 484 | 115 | 115 |
0 | 3,687 | 22,541 |
| 37,872 | 9,489 | 84 | 1 | 71 | 116 | 116 |
0 | 7,672 | 22,721 |
| 37,873 | 9,489 | 84 | 71 | 74 | 117 | 117 |
0 | 2,681 | 22,722 |
| 37,874 | 9,490 | 84 | 1 | 14 | 118 | 118 |
0 | 12,817 | 22,723 |
| 37,875 | 9,490 | 84 | 14 | 27 | 119 | 119 |
0 | 15,499 | 22,724 |
| 37,876 | 9,490 | 84 | 27 | 28 | 120 | 120 |
0 | 15,499 | 22,725 |
| 37,877 | 9,490 | 84 | 28 | 31 | 121 | 121 |
0 | 15,499 | 22,726 |
| 37,878 | 9,490 | 84 | 31 | 32 | 122 | 122 |
0 | 15,499 | 22,727 |
| 37,879 | 9,490 | 84 | 32 | 34 | 123 | 123 |
0 | 15,499 | 22,728 |
| 37,880 | 9,490 | 84 | 34 | 35 | 124 | 124 |
0 | 15,499 | 22,729 |
| 37,881 | 9,490 | 84 | 35 | 36 | 125 | 125 |
0 | 15,499 | 22,730 |
| 37,882 | 9,490 | 84 | 36 | 320 | 126 | 126 |
0 | 7,732 | 22,731 |
| 37,883 | 9,491 | 84 | 1 | 52 | 127 | 127 |
0 | 7,766 | 22,732 |
| 37,884 | 9,491 | 84 | 52 | 56 | 128 | 128 |
0 | 15,499 | 22,733 |
| 37,885 | 9,491 | 84 | 56 | 60 | 129 | 129 |
0 | 8,315 | 22,734 |
| 37,886 | 9,492 | 84 | 1 | 54 | 130 | 130 |
0 | 7,183 | 22,735 |
| 37,887 | 9,492 | 84 | 54 | 58 | 131 | 131 |
0 | 15,499 | 22,736 |
| 37,888 | 9,492 | 84 | 58 | 61 | 132 | 132 |
0 | 15,499 | 22,737 |
| 37,889 | 9,492 | 84 | 61 | 62 | 133 | 133 |
0 | 15,499 | 22,738 |
| 37,890 | 9,492 | 84 | 62 | 63 | 134 | 134 |
0 | 15,499 | 22,739 |
| 37,891 | 9,492 | 84 | 63 | 64 | 135 | 135 |
0 | 15,499 | 22,740 |
| 37,892 | 9,492 | 84 | 64 | 64 | 136 | 136 |
0 | 15,499 | 22,741 |
| 37,893 | 9,492 | 84 | 64 | 65 | 137 | 137 |
0 | 4,038 | 22,742 |
| 37,895 | 9,494 | 84 | 1 | 539 | 139 | 139 |
0 | 11,459 | 22,744 |
| 37,896 | 9,494 | 84 | 539 | 563 | 140 | 140 |
0 | 15,499 | 22,745 |
| 37,897 | 9,494 | 84 | 563 | 570 | 141 | 141 |
0 | 15,499 | 22,746 |
| 37,898 | 9,494 | 84 | 570 | 573 | 142 | 142 |
0 | 15,499 | 22,747 |
| 37,899 | 9,494 | 84 | 573 | 579 | 143 | 143 |
0 | 12,125 | 22,748 |
| 37,901 | 9,496 | 84 | 1 | 11 | 144 | 144 |
0 | 191 | 22,750 |
| 37,902 | 9,497 | 84 | 1 | 61 | 145 | 145 |
0 | 3,157 | 22,751 |
| 37,903 | 9,497 | 84 | 61 | 67 | 146 | 146 |
0 | 10,717 | 22,752 |
| 37,904 | 9,498 | 84 | 1 | 65 | 147 | 147 |
0 | 4,781 | 22,753 |
| 37,905 | 9,498 | 84 | 65 | 69 | 148 | 148 |
0 | 6,550 | 22,754 |
| 37,906 | 9,499 | 84 | 1 | 134 | 149 | 149 |
0 | 8,948 | 22,755 |
| 37,907 | 9,499 | 84 | 134 | 134 | 150 | 150 |
0 | 15,499 | 22,756 |
| 37,908 | 9,499 | 84 | 134 | 135 | 151 | 151 |
0 | 15,499 | 22,757 |
| 37,909 | 9,499 | 84 | 135 | 136 | 152 | 152 |
0 | 15,499 | 22,758 |
| 37,910 | 9,499 | 84 | 136 | 136 | 153 | 153 |
0 | 15,499 | 22,759 |
| 37,911 | 9,499 | 84 | 136 | 139 | 154 | 154 |
0 | 8,695 | 22,760 |
| 38,020 | 9,516 | 84 | 1 | 20 | 155 | 155 |
0 | 8 | 22,866 |
| 38,021 | 9,517 | 84 | 1 | 5 | 156 | 156 |
0 | 3,767 | 22,867 |
| 38,022 | 9,517 | 84 | 5 | 15 | 157 | 157 |
0 | 15,499 | 22,868 |
| 38,023 | 9,517 | 84 | 15 | 19 | 158 | 158 |
0 | 15,499 | 22,869 |
| 38,024 | 9,517 | 84 | 19 | 107 | 159 | 159 |
0 | 15,499 | 22,870 |
| 38,025 | 9,517 | 84 | 107 | 143 | 160 | 160 |
0 | 146 | 22,871 |
| 38,026 | 9,518 | 84 | 1 | 28 | 161 | 161 |
0 | 15,352 | 22,872 |
| 38,027 | 9,518 | 84 | 28 | 32 | 162 | 162 |
0 | 15,499 | 22,873 |
| 38,028 | 9,518 | 84 | 32 | 33 | 163 | 163 |
0 | 792 | 22,874 |
| 38,029 | 9,519 | 84 | 1 | 1 | 164 | 164 |
0 | 0 | 22,875 |
| 38,032 | 9,521 | 84 | 114 | 124 | 167 | 167 |
0 | 15,499 | 22,877 |
| 38,033 | 9,521 | 84 | 124 | 131 | 168 | 168 |
0 | 13,528 | 22,878 |
| 38,107 | 9,523 | 84 | 1 | 10 | 169 | 169 |
0 | 3,005 | 22,952 |
| 38,108 | 9,524 | 84 | 1 | 20 | 170 | 170 |
0 | 7,756 | 22,953 |
| 38,109 | 9,524 | 84 | 20 | 22 | 171 | 171 |
0 | 5,333 | 22,954 |
| 38,110 | 9,525 | 84 | 1 | 21 | 172 | 172 |
0 | 10,165 | 22,955 |
| 38,111 | 9,525 | 84 | 21 | 22 | 173 | 173 |
0 | 1,041 | 22,956 |
| 38,112 | 9,526 | 84 | 1 | 20 | 174 | 174 |
0 | 4,511 | 22,957 |
| 38,193 | 9,543 | 84 | 1 | 12 | 175 | 175 |
0 | 277 | 23,035 |
| 38,194 | 9,544 | 84 | 1 | 142 | 176 | 176 |
0 | 93 | 23,036 |
| 38,195 | 9,545 | 84 | 1 | 8 | 177 | 177 |
0 | 8,607 | 23,037 |
| 38,196 | 9,545 | 84 | 8 | 9 | 178 | 178 |
0 | 15,499 | 23,038 |
| 38,197 | 9,545 | 84 | 9 | 10 | 179 | 179 |
0 | 15,499 | 23,039 |
| 38,198 | 9,545 | 84 | 10 | 14 | 180 | 180 |
0 | 15,499 | 23,040 |
| 38,199 | 9,545 | 84 | 14 | 19 | 181 | 181 |
0 | 14,674 | 23,041 |
| 38,200 | 9,546 | 84 | 1 | 2 | 182 | 182 |
0 | 0 | 23,042 |
| 38,203 | 9,548 | 84 | 274 | 409 | 185 | 185 |
0 | 8,910 | 23,044 |
| 38,205 | 9,550 | 84 | 1 | 137 | 186 | 186 |
0 | 238 | 23,046 |
| 38,206 | 9,551 | 84 | 1 | 49 | 187 | 187 |
0 | 300 | 23,047 |
| 38,207 | 9,552 | 84 | 1 | 28 | 188 | 188 |
0 | 30 | 23,048 |
| 38,208 | 9,552 | 84 | 28 | 49 | 189 | 189 |
0 | 113 | 23,049 |
| 38,209 | 9,553 | 84 | 1 | 459 | 190 | 190 |
0 | 15,385 | 23,050 |
| 38,210 | 9,553 | 84 | 459 | 460 | 191 | 191 |
0 | 15,499 | 23,051 |
| 38,211 | 9,553 | 84 | 460 | 460 | 192 | 192 |
0 | 15,499 | 23,052 |
| 38,212 | 9,553 | 84 | 460 | 461 | 193 | 193 |
0 | 15,499 | 23,053 |
| 38,213 | 9,553 | 84 | 461 | 461 | 194 | 194 |
0 | 15,499 | 23,054 |
| 38,214 | 9,553 | 84 | 461 | 462 | 195 | 195 |
0 | 953 | 23,055 |
| 38,307 | 9,570 | 84 | 1 | 46 | 196 | 196 |
0 | 763 | 23,145 |
| 38,308 | 9,571 | 84 | 1 | 97 | 197 | 197 |
0 | 6,277 | 23,146 |
| 38,309 | 9,571 | 84 | 97 | 414 | 198 | 198 |
0 | 5,523 | 23,147 |
| 38,310 | 9,572 | 84 | 1 | 49 | 199 | 199 |
0 | 7,367 | 23,148 |
| 38,311 | 9,573 | 84 | 1 | 43 | 200 | 200 |
0 | 429 | 23,149 |
| 38,314 | 9,575 | 84 | 529 | 779 | 203 | 203 |
0 | 8,149 | 23,151 |
| 38,317 | 9,577 | 84 | 1 | 137 | 204 | 204 |
0 | 220 | 23,154 |
| 38,318 | 9,578 | 84 | 1 | 81 | 205 | 205 |
0 | 12,483 | 23,155 |
| 38,319 | 9,578 | 84 | 81 | 103 | 206 | 206 |
0 | 986 | 23,156 |
| 38,320 | 9,579 | 84 | 1 | 94 | 207 | 207 |
0 | 220 | 23,157 |
| 38,321 | 9,580 | 84 | 1 | 263 | 208 | 208 |
0 | 14,291 | 23,158 |
| 38,322 | 9,580 | 84 | 263 | 264 | 209 | 209 |
0 | 15,499 | 23,159 |
| 38,323 | 9,580 | 84 | 264 | 264 | 210 | 210 |
0 | 15,499 | 23,160 |
| 38,324 | 9,580 | 84 | 264 | 265 | 211 | 211 |
0 | 15,499 | 23,161 |
| 38,325 | 9,580 | 84 | 265 | 265 | 212 | 212 |
0 | 15,499 | 23,162 |
| 38,326 | 9,580 | 84 | 265 | 266 | 213 | 213 |
0 | 3,301 | 23,163 |
| 38,441 | 9,598 | 84 | 90 | 91 | 216 | 216 |
0 | 15,499 | 23,275 |
| 38,442 | 9,598 | 84 | 91 | 92 | 217 | 217 |
0 | 15,499 | 23,276 |
| 38,443 | 9,598 | 84 | 92 | 426 | 218 | 218 |
0 | 10,357 | 23,277 |
| 38,444 | 9,599 | 84 | 1 | 51 | 219 | 219 |
0 | 5,141 | 23,278 |
| 38,445 | 9,599 | 84 | 51 | 55 | 220 | 220 |
0 | 15,499 | 23,279 |
| 38,446 | 9,599 | 84 | 55 | 60 | 221 | 221 |
0 | 12,846 | 23,280 |
| 38,447 | 9,600 | 84 | 1 | 52 | 222 | 222 |
0 | 2,652 | 23,281 |
| 38,448 | 9,600 | 84 | 52 | 56 | 223 | 223 |
0 | 15,499 | 23,282 |
| 38,449 | 9,600 | 84 | 56 | 59 | 224 | 224 |
0 | 15,499 | 23,283 |
| 38,450 | 9,600 | 84 | 59 | 61 | 225 | 225 |
0 | 15,499 | 23,284 |
| 38,451 | 9,600 | 84 | 61 | 62 | 226 | 226 |
0 | 15,499 | 23,285 |
| 38,452 | 9,600 | 84 | 62 | 62 | 227 | 227 |
0 | 15,499 | 23,286 |
| 38,453 | 9,600 | 84 | 62 | 63 | 228 | 228 |
0 | 528 | 23,287 |
| 38,456 | 9,602 | 84 | 753 | 830 | 231 | 231 |
0 | 15,499 | 23,289 |
| 38,457 | 9,602 | 84 | 830 | 834 | 232 | 232 |
0 | 15,499 | 23,290 |
| 38,458 | 9,602 | 84 | 834 | 837 | 233 | 233 |
0 | 15,499 | 23,291 |
| 38,459 | 9,602 | 84 | 837 | 863 | 234 | 234 |
0 | 4,515 | 23,292 |
| 38,461 | 9,604 | 84 | 1 | 137 | 235 | 235 |
0 | 219 | 23,294 |
| 38,462 | 9,605 | 84 | 1 | 78 | 236 | 236 |
0 | 4,312 | 23,295 |
| 38,463 | 9,605 | 84 | 78 | 102 | 237 | 237 |
0 | 9,144 | 23,296 |
| 38,464 | 9,606 | 84 | 1 | 104 | 238 | 238 |
0 | 6,354 | 23,297 |
| 38,465 | 9,606 | 84 | 104 | 107 | 239 | 239 |
0 | 4,941 | 23,298 |
| 38,466 | 9,607 | 84 | 1 | 363 | 240 | 240 |
0 | 10,557 | 23,299 |
| 38,467 | 9,607 | 84 | 363 | 363 | 241 | 241 |
0 | 15,499 | 23,300 |
| 38,468 | 9,607 | 84 | 363 | 364 | 242 | 242 |
0 | 15,499 | 23,301 |
| 38,469 | 9,607 | 84 | 364 | 365 | 243 | 243 |
0 | 15,499 | 23,302 |
| 38,470 | 9,607 | 84 | 365 | 365 | 244 | 244 |
0 | 15,499 | 23,303 |
| 38,471 | 9,607 | 84 | 365 | 368 | 245 | 245 |
0 | 8,675 | 23,304 |
| 38,587 | 9,624 | 84 | 1 | 109 | 246 | 246 |
0 | 5,487 | 23,416 |
| 38,588 | 9,625 | 84 | 1 | 82 | 247 | 247 |
0 | 7,679 | 23,417 |
| 38,589 | 9,625 | 84 | 82 | 83 | 248 | 248 |
0 | 15,499 | 23,418 |
| 38,590 | 9,625 | 84 | 83 | 84 | 249 | 249 |
0 | 15,499 | 23,419 |
| 38,591 | 9,625 | 84 | 84 | 328 | 250 | 250 |
0 | 8,915 | 23,420 |
| 38,592 | 9,626 | 84 | 1 | 51 | 251 | 251 |
0 | 6,583 | 23,421 |
| 38,593 | 9,626 | 84 | 51 | 55 | 252 | 252 |
0 | 15,499 | 23,422 |
| 38,594 | 9,626 | 84 | 55 | 60 | 253 | 253 |
0 | 11,742 | 23,423 |
| 38,595 | 9,627 | 84 | 1 | 51 | 254 | 254 |
0 | 3,756 | 23,424 |
| 38,596 | 9,627 | 84 | 51 | 55 | 255 | 255 |
0 | 15,499 | 23,425 |
| 38,597 | 9,627 | 84 | 55 | 59 | 256 | 256 |
0 | 15,499 | 23,426 |
| 38,598 | 9,627 | 84 | 59 | 60 | 257 | 257 |
0 | 15,499 | 23,427 |
| 38,599 | 9,627 | 84 | 60 | 61 | 258 | 258 |
0 | 15,499 | 23,428 |
| 38,600 | 9,627 | 84 | 61 | 61 | 259 | 259 |
0 | 15,499 | 23,429 |
| 38,601 | 9,627 | 84 | 61 | 62 | 260 | 260 |
0 | 493 | 23,430 |
| 38,604 | 9,629 | 84 | 750 | 829 | 263 | 263 |
0 | 15,499 | 23,432 |
| 38,605 | 9,629 | 84 | 829 | 833 | 264 | 264 |
0 | 15,499 | 23,433 |
| 38,606 | 9,629 | 84 | 833 | 834 | 265 | 265 |
0 | 15,499 | 23,434 |
| 38,607 | 9,629 | 84 | 834 | 860 | 266 | 266 |
0 | 3,926 | 23,435 |
| 38,609 | 9,631 | 84 | 1 | 137 | 267 | 267 |
0 | 218 | 23,437 |
| 38,610 | 9,632 | 84 | 1 | 80 | 268 | 268 |
0 | 11,352 | 23,438 |
| 38,611 | 9,632 | 84 | 80 | 102 | 269 | 269 |
0 | 2,171 | 23,439 |
| 38,612 | 9,633 | 84 | 1 | 107 | 270 | 270 |
0 | 11,320 | 23,440 |
| 38,613 | 9,634 | 84 | 1 | 71 | 271 | 271 |
0 | 2,006 | 23,441 |
| 38,614 | 9,634 | 84 | 71 | 71 | 272 | 272 |
0 | 15,499 | 23,442 |
| 38,615 | 9,634 | 84 | 71 | 72 | 273 | 273 |
0 | 15,499 | 23,443 |
| 38,616 | 9,634 | 84 | 72 | 72 | 274 | 274 |
0 | 15,499 | 23,444 |
| 38,617 | 9,634 | 84 | 72 | 73 | 275 | 275 |
0 | 15,499 | 23,445 |
| 38,618 | 9,634 | 84 | 73 | 73 | 276 | 276 |
0 | 15,499 | 23,446 |
| 38,619 | 9,634 | 84 | 73 | 76 | 277 | 277 |
0 | 6,817 | 23,447 |
| 38,732 | 9,651 | 84 | 1 | 105 | 278 | 278 |
0 | 1,132 | 23,557 |
+------------+-------+---------+------------+-----------+-----------+---------+------------+----------+----------+
Enter SQL query: begin:vcard
fn;quoted-printable:Emery Gu=C3=A9vremont
n;quoted-printable:Gu=C3=A9vremont;Emery
org:Croesus Finansoft
adr:;;2 Place laval, Suite 510;Laval;PQ;H7N 5N6;Canada
email;internet:[EMAIL PROTECTED]
title;quoted-printable:Administrateur des syst=C3=A8mes
tel;work:450-662-6101
tel;cell:514-513-3416
x-mozilla-html:FALSE
version:2.1
end:vcard
