i can not cpimport a tempfs into my infinidb table

4 posts / 0 new
Last post
jypeng
jypeng's picture
Offline
Last seen: 2 years 6 months ago
Joined: Feb 15 2012
Junior Boarder

Posts: 4

jy peng
i can not cpimport a tempfs into my infinidb table

1?i create a tempfs in /dev/shm: mount tmpfs /dev/shm -t tmpfs -o size=512m
2?i write a file into /dev/shm/monitor.csv
3?call the cpimport command cpimport hsm_db monitor_table /dev/shm/monitor.csv

the error message:
### JobListFactory ses:2147483648 caught: pColStep: BRM error!
ExtentMap::getExtents(): OID not found: 1002

when i use load data infile:
mysql> load data infile '/dev/shm/monitor.csv.1' into table t_monitor_user_app_if_zone fields terminated by '|' lines terminated by 'rn';
ERROR 122 (HY000): CAL0001: Insert Failed: Error occured when calling makeJobList

bdempsey
bdempsey's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Oct 27 2009
Platinum Boarder

Posts: 194

Robert Dempsey
Re: i can not cpimport a tempfs into my infinidb table

InfiniDB uses /dev/shm to store database metadata. You cannot mount a filesystem on top of it.

jypeng
jypeng's picture
Offline
Last seen: 2 years 6 months ago
Joined: Feb 15 2012
Junior Boarder

Posts: 4

jy peng
Re: i can not cpimport a tempfs into my infinidb table

thanks for your quick response !
when i change a dir:/tmp/tmpfs
then i get a error: BRM is in read-only state. cpimport is terminating.

bdempsey
bdempsey's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Oct 27 2009
Platinum Boarder

Posts: 194

Robert Dempsey
Re: i can not cpimport a tempfs into my infinidb table

Because of the previous attempts to mount a filesystem on top of /dev/shm, the InfiniDB metadata is probably corrupt. You may be able to recover it by restarting the system, but you may have to reinstall and reload.