[MonetDB-users] duplicate tables in schema
Hi, repeatedly we get in a situation where tables end up duplicate in the sys.tables table: SELECT count(*) FROM tables WHERE name='mytable'; returns: 2 We think this should never be the case. It seems this gives problems with dumping the database and in other situations. This is an older version of MonetDB (Apr2011 SP1). We want to know whether someone knows this was/is a symptom of any known issue Sincerely, Bas
On 05-03-2012 05:17:12 -0800, Bas Kaptijn wrote:
repeatedly we get in a situation where tables end up duplicate in the sys.tables table:
SELECT count(*) FROM tables WHERE name=’mytable’;
returns: 2
We think this should never be the case.
It seems this gives problems with dumping the database and in other situations.
This is an older version of MonetDB (Apr2011 SP1). We want to know whether someone knows
this was/is a symptom of any known issue
I've seen this when the database is in readonly mode. Do you perhaps use that?
Hi Bas, On Mon, Mar 05, 2012 at 05:17:12AM -0800, Bas Kaptijn wrote:
Hi,
repeatedly we get in a situation where tables end up duplicate in the sys.tables table: SELECT count(*) FROM tables WHERE name='mytable'; returns: 2 We think this should never be the case.
IMHO, that can very well happen: the same table name can occur in multiple schemas; only once per schema, though ...
It seems this gives problems with dumping the database and in other situations.
Could you maybe be more precise about (1) what the exact problem are, (2) how you dump the database (using `mclient --dump` or `msqldump`, or in a "custom" way?), and (3) what the other situations are?
This is an older version of MonetDB (Apr2011 SP1). We want to know whether someone knows this was/is a symptom of any known issue
Sincerely, Bas
Stefan -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (3)
-
Bas Kaptijn -
Fabian Groffen -
Stefan Manegold