[MonetDB-users] lose some datas of a table's one field, how can this happen?
Hi when execute sql : select * from td_ind_security_held where id = 1560000 in DbVisualizer 7.1.1,it appears "protocol violation: unexpected line in data block" td_ind_security_held has 30 columns(1 int,6 varchar, others decimal) and 7219618 rows. so i count field's records one by one , all fields's records are equal to 7219618 except the allgain's records, it is only 658337. it obviously lost some data. when program inserted the data into the table , the monet server carshed out some times, can this be the reson for the lose? I'm working with MonetDB Server v5.22.3, based on kernel 1.40.3 (downloaded msi from sourceforge) over Windows XP SP3.
Hi:
I don't know if this would help you or not. But, we have seen the same kind
of problem in older releases if there were any data updates or deletes in a
given table. So, we are using the Nov-2009SP2 release strictly as a
read-only database. I don't know if update/delete related bug has been fixed
or not since the Nov-2009SP2 release. So, I would be interested to know if
you are seeing the same bug that we saw in Nov-2009SP2 release.
By the way, we are testing the Feb-2010SP2 release on CentOS 5.4 and have
not seen any issues like the ones you are seeing. Again, we are running both
environements as read-only. Thanks.
Henry
2011/3/6 tangray
Hi when execute sql : select * from td_ind_security_held where id = 1560000 in DbVisualizer 7.1.1,it appears "protocol violation: unexpected line in data block"
td_ind_security_held has 30 columns(1 int,6 varchar, others decimal) and 7219618 rows. so i count field's records one by one , all fields's records are equal to 7219618 except the allgain's records, it is only 658337. it obviously lost some data. when program inserted the data into the table , the monet server carshed out some times, can this be the reson for the lose?
I'm working with MonetDB Server v5.22.3, based on kernel 1.40.3 (downloaded msi from sourceforge) over Windows XP SP3.
------------------------------------------------------------------------------ What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Henry Addington -
tangray