关于datebase，cursor的一些异常 android.database.CursorWindowAllocationException: Cursor window allocation of

原来测试的时候没有报错，现在出现好多蓝色提示，并且有时候程序会崩溃，我出现过以下几个错误

android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed even after closing cursor

android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open Cursors=705 (# cursors opened by this proc=705)

出现这个的话一般是以下几种情况

cursor是否为空没有判断

datebase没有关闭

cursor没有关闭

ok，下面上两段代码：

import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;/** * Created by fanyafeng on 2015/7/28/0028. */public class CollectTableCourse {    private static final String RECORDTABLE = "t_collect";    private SQLiteDatabase db = null;    public CollectTableCourse(SQLiteDatabase db) {        this.db = db;    }    public Boolean searchCollect(String v_id) {        String sql = "SELECT v_id FROM " + RECORDTABLE + " WHERE v_id = ?";        String searchField[] = new String[]{v_id};        Cursor result = this.db.rawQuery(sql, searchField);        if (result != null) {            result.moveToFirst();        }        if (result.getCount() == 0) {            result.close();            this.db.close();            return true;        } else {            result.close();            this.db.close();            return false;        }    }}

import android.content.Context;import android.graphics.Bitmap;import android.support.v4.util.LruCache;import android.support.v4.view.ViewPager;import android.util.Log;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.widget.ImageView;import android.widget.LinearLayout;import android.widget.TextView;import com.cj.dreams.video.R;import com.cj.dreams.video.bean.VideoListBean;import com.cj.dreams.video.dbhelper.CollectTableCourse;import com.cj.dreams.video.dbhelper.GoodTableCourse;import com.cj.dreams.video.dbhelper.LaughSQLiteOpenHelper;import com.cj.dreams.video.dbhelper.RecordTableCourse;import com.cj.dreams.video.dboperate.CollectOperate;import com.cj.dreams.video.dboperate.GoodOperate;import com.cj.dreams.video.dboperate.RecordOperate;import FanYaFeng.L;import com.cj.dreams.video.util.ListViewImageTaskUtil;import FanYaFeng.PostUtil;import com.cj.dreams.video.util.T;import java.io.IOException;import java.util.HashMap;import java.util.LinkedHashMap;import java.util.List;import java.util.Map;/** * Created by fanyafeng on 2015/7/7/0007. */public class VideoListAdapter extends ABaseAdapter {    private Context context;    private List<VideoListBean> videoListBeanList;    private LaughSQLiteOpenHelper laughSQLiteOpenHelper;    private RecordOperate recordOperate;    private CollectOperate collectOperate;    private GoodOperate goodOperate;    //用来记录播放状态的图标显示，测试    private ViewHolder holder;    // 获取当前应用程序所分配的最大内存    private final int maxMemory = (int) Runtime.getRuntime().maxMemory();    // 只用五分之一用来做图片缓存    private final int cacheSize = maxMemory / 5;    private LruCache<String, Bitmap> mLruCache = new LruCache<String, Bitmap>(            cacheSize) {        // 重写sizeof（）方法        @Override        protected int sizeOf(String key, Bitmap bitmap) {            // TODO Auto-generated method stub            // 这里用多少kb来计算            return bitmap.getRowBytes() * bitmap.getHeight() / 1024;        }    };    public VideoListAdapter(Context context, List<VideoListBean> videoListBeanList) {        this.context = context;        this.videoListBeanList = videoListBeanList;    }    public void update() {        notifyDataSetChanged();    }    @Override    public int getCount() {        return videoListBeanList.size();    }    @Override    public Object getItem(int position) {        return videoListBeanList.get(position);    }    @Override    public long getItemId(int position) {        return position;    }    @Override    public View getView(final int position, View convertView, final ViewGroup parent) {        View view = convertView;        if (view == null) {            view = LayoutInflater.from(context).inflate(R.layout.item_activity_video_list, null);            holder = new ViewHolder();            view.setTag(holder);            holder.item_background=(LinearLayout)view.findViewById(R.id.item_background);            holder.videoListIcon = (ImageView) view.findViewById(R.id.videolist_icon);            holder.videoListTitle = (TextView) view.findViewById(R.id.videolist_title);            holder.videoPlayTimes = (TextView) view.findViewById(R.id.videolist_play_times);            holder.videoCollectTimes = (TextView) view.findViewById(R.id.videolist_collect_times);            holder.videoGoodTimes = (TextView) view.findViewById(R.id.videolist_good_times);            holder.videoPlayIcon = (ImageView) view.findViewById(R.id.videolist_play_icon);            holder.videoCollectIcon = (ImageView) view.findViewById(R.id.videolist_collect_icon);            holder.videoGoodIcon = (ImageView) view.findViewById(R.id.videolist_good_icon);        } else {            holder = (ViewHolder) convertView.getTag();        }        laughSQLiteOpenHelper = new LaughSQLiteOpenHelper(context);        laughSQLiteOpenHelper.getWritableDatabase();        if (new RecordTableCourse(laughSQLiteOpenHelper.getReadableDatabase()).searchRecord(videoListBeanList.get(position).getVideoId())) {            holder.videoPlayIcon.setImageResource(R.drawable.icon_bof);        } else {            holder.videoPlayIcon.setImageResource(R.drawable.icon_bof_d);        }        holder.videoCollectIcon.setOnClickListener(new collectClick(position));        if (new CollectTableCourse(laughSQLiteOpenHelper.getReadableDatabase()).searchCollect(videoListBeanList.get(position).getVideoId())) {            holder.videoCollectIcon.setImageResource(R.drawable.icon_shouc);        } else {            holder.videoCollectIcon.setImageResource(R.drawable.icon_shouc_d);        }        holder.videoGoodIcon.setOnClickListener(new goodClick(position));        if (new GoodTableCourse(laughSQLiteOpenHelper.getReadableDatabase()).searchGood(videoListBeanList.get(position).getVideoId())) {            holder.videoGoodIcon.setImageResource(R.drawable.icon_z);        } else {            holder.videoGoodIcon.setImageResource(R.drawable.icon_z_d);        }        loadBitmap(videoListBeanList.get(position).getVideoImage(), holder.videoListIcon);        holder.item_background.getBackground().setAlpha(50);        holder.videoListTitle.setText(videoListBeanList.get(position).getVideoTitle());        holder.videoPlayTimes.setText(videoListBeanList.get(position).getVideoPlayTimes());        holder.videoCollectTimes.setText(videoListBeanList.get(position).getVideoCollectTimes());        holder.videoGoodTimes.setText(videoListBeanList.get(position).getVideoGoodTimes());        laughSQLiteOpenHelper.close();        return view;    }    class collectClick implements View.OnClickListener {        private int position;        collectClick(int position) {            this.position = position;        }        @Override        public void onClick(View v) {            Thread loadThread = new Thread(new LoadThread(videoListBeanList.get(position).getVideoId(), "collect"));            loadThread.start();            int collectId = v.getId();            if (collectId == holder.videoCollectIcon.getId()) {                if (new CollectTableCourse(laughSQLiteOpenHelper.getReadableDatabase()).searchCollect(videoListBeanList.get(position).getVideoId())) {                    collectOperate = new CollectOperate(laughSQLiteOpenHelper.getReadableDatabase());                    collectOperate.insert(videoListBeanList.get(position).getVideoId(), videoListBeanList.get(position).getVideoImage(), videoListBeanList.get(position).getVideoTitle(), videoListBeanList.get(position).getVideoUrl());                    holder.videoCollectIcon.setImageResource(R.drawable.icon_shouc_d);                } else {                    collectOperate = new CollectOperate(laughSQLiteOpenHelper.getReadableDatabase());                    collectOperate.delete(videoListBeanList.get(position).getVideoId());                    holder.videoCollectIcon.setImageResource(R.drawable.icon_shouc);                }                notifyDataSetChanged();                laughSQLiteOpenHelper.close();            }        }    }    class goodClick implements View.OnClickListener {        private int position;        goodClick(int position) {            this.position = position;        }        @Override        public void onClick(View v) {            Thread loadThread = new Thread(new LoadThread(videoListBeanList.get(position).getVideoId(), "praise"));            loadThread.start();            int playId = v.getId();            if (playId == holder.videoGoodIcon.getId()) {                if (new GoodTableCourse(laughSQLiteOpenHelper.getReadableDatabase()).searchGood(videoListBeanList.get(position).getVideoId())) {                    goodOperate = new GoodOperate(laughSQLiteOpenHelper.getReadableDatabase());                    goodOperate.insert(videoListBeanList.get(position).getVideoId());                    holder.videoGoodIcon.setImageResource(R.drawable.icon_z_d);                } else {                    goodOperate = new GoodOperate(laughSQLiteOpenHelper.getReadableDatabase());                    goodOperate.delete(videoListBeanList.get(position).getVideoId());                    holder.videoGoodIcon.setImageResource(R.drawable.icon_z);                }                notifyDataSetChanged();                laughSQLiteOpenHelper.close();            }        }    }    private void loadBitmap(String urlStr, ImageView image) {        ListViewImageTaskUtil asyncLoader = new ListViewImageTaskUtil(image, mLruCache);// 一个异步图片加载对象        Bitmap bitmap = asyncLoader.getBitmapFromMemoryCache(urlStr);// 首先从内存缓存中获取图片        if (bitmap != null) {            image.setImageBitmap(bitmap);// 如果缓存中存在这张图片则直接设置给ImageView        } else {            image.setImageResource(R.drawable.wait);// 否则先设置成默认的图片            asyncLoader.execute(urlStr);// 然后执行异步任务AsycnTask 去网上加载图片        }    }    class LoadThread implements Runnable {        private String id;        private String type;        LoadThread(String id, String type) {            this.id = id;            this.type = type;        }        @Override        public void run() {            loadData(id, type);        }    }    private void loadData(String videoId, String buttonType) {        Map<String, String> map = new LinkedHashMap<>();        map.put("videoid", videoId);        map.put("type", buttonType);        try {            String backMsg = PostUtil.postData(BaseUrl + PostVideoInfo, map);            L.d("运行到此，点赞，收藏加1");        } catch (IOException e) {            e.printStackTrace();        }    }    class ViewHolder {        LinearLayout item_background;        ImageView videoListIcon;        TextView videoListTitle;        TextView videoPlayTimes;        TextView videoCollectTimes;        TextView videoGoodTimes;        ImageView videoPlayIcon;        ImageView videoCollectIcon;        ImageView videoGoodIcon;    }}