Query Error

3 posts / 0 new
Last post
sbalajirao
sbalajirao's picture
Offline
Last seen: 1 year 11 months ago
Joined: May 31 2012
Junior Boarder

Posts: 4

Balaji Rao
Query Error

I'm having problems with one table that has about 200+ million rows. The import worked fine, but I get an error for a simple count(*) from the table.

Aug 1 20:39:51 ip-10-84-97-19 ExeMgr[731]: 51.334057 |8|0|0| D 16 CAL0041: Start SQL statement: select count(*) from level1fields
Aug 1 20:40:02 ip-10-84-97-19 CRON[1850]: (root) CMD (/usr/local/Calpont/bin/transactionLogArchiver.sh)
Aug 1 20:40:02 ip-10-84-97-19 PrimProc[716]: 02.994493 |0|0|0| C 28 CAL0061: PrimProc error reading file for OID 3006; No remount performed
Aug 1 20:40:03 ip-10-84-97-19 PrimProc[716]: 03.026884 |0|0|0| C 28 CAL0000: thr_popper: Error opening file on R/W mount PM or single PM system pm1 for OID 3006; /usr/local/Calpont/data1/000.dir/000.dir/011.dir/190.dir/003.dir/FILE000.cdf; Success#012
Aug 1 20:40:03 ip-10-84-97-19 ExeMgr[731]: 03.041508 |8|0|0| D 16 CAL0042: End SQL statement
Aug 1 20:40:03 ip-10-84-97-19 PrimProc[716]: 03.062307 |0|0|0| C 28 CAL0061: PrimProc error reading file for OID 3006; No remount performed
Aug 1 20:40:03 ip-10-84-97-19 PrimProc[716]: 03.062528 |0|0|0| C 28 CAL0000: thr_popper: Error opening file on R/W mount PM or single PM system pm1 for OID 3006; /usr/local/Calpont/data1/000.dir/000.dir/011.dir/190.dir/003.dir/FILE000.cdf; Success#012

Any ideas?

radams
radams's picture
Offline
Last seen: 5 days 4 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re: Query Error

Hi,

Have you verified that you can access the file in the error message?

/usr/local/Calpont/data1/000.dir/000.dir/011.dir/190.dir/003.dir/FILE000.cdf

Thanks,

Robert
Calpont

sbalajirao
sbalajirao's picture
Offline
Last seen: 1 year 11 months ago
Joined: May 31 2012
Junior Boarder

Posts: 4

Balaji Rao
Re: Query Error

Hi Robert,
Yes, I'm able to access the file in the error message.

brao@ip-xx-xx-xx-xx:~$ sudo tail -f /var/log/syslog
Aug 6 14:11:07 ip-xx-xx-xx-xx oamcpp[19092]: 07.759969 |0|0|0| I 08 CAL0052: Startup Tests: test-004.sh: test validate-partition-size succeeded
Aug 6 14:11:07 ip-xx-xx-xx-xx oamcpp[19093]: 07.764879 |0|0|0| I 08 CAL0054: Startup Tests: all tests passed
Aug 6 14:12:30 ip-xx-xx-xx-xx ExeMgr[18674]: 30.716128 |2147483655|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='bigdata' and tablename='level1fields' --columnRIDs/FE
Aug 6 14:12:31 ip-xx-xx-xx-xx ExeMgr[18674]: 31.096721 |2147483655|0|0| D 16 CAL0042: End SQL statement
Aug 6 14:12:31 ip-xx-xx-xx-xx ExeMgr[18674]: 31.205773 |7|0|0| D 16 CAL0041: Start SQL statement: select count(*) from level1fields limit 10
Aug 6 14:12:38 ip-xx-xx-xx-xx PrimProc[18659]: 38.093194 |0|0|0| C 28 CAL0061: PrimProc error reading file for OID 3014; No remount performed
Aug 6 14:12:38 ip-xx-xx-xx-xx PrimProc[18659]: 38.104070 |0|0|0| C 28 CAL0000: thr_popper: Error opening file on R/W mount PM or single PM system pm1 for OID 3014; /usr/local/Calpont/data1/000.dir/000.dir/011.dir/198.dir/001.dir/FILE001.cdf; Success#012
Aug 6 14:12:38 ip-xx-xx-xx-xx PrimProc[18659]: 38.137646 |0|0|0| C 28 CAL0061: PrimProc error reading file for OID 3014; No remount performed
Aug 6 14:12:38 ip-xx-xx-xx-xx PrimProc[18659]: 38.137795 |0|0|0| C 28 CAL0000: thr_popper: Error opening file on R/W mount PM or single PM system pm1 for OID 3014; /usr/local/Calpont/data1/000.dir/000.dir/011.dir/198.dir/001.dir/FILE001.cdf; Success#012
Aug 6 14:12:38 ip-xx-xx-xx-xx ExeMgr[18674]: 38.140405 |7|0|0| D 16 CAL0042: End SQL statement
^C
brao@ip-xx-xx-xx-xx:~$ ls -l /usr/local/Calpont/data1/000.dir/000.dir/011.dir/198.dir/001.dir/FILE001.cdf
-rwxrwxrwx 1 root root 58006080 2012-08-03 18:53 /usr/local/Calpont/data1/000.dir/000.dir/011.dir/198.dir/001.dir/FILE001.cdf

-Balaji