删除数据的原理是做delete操作吗？删除数据数据量受什么限制吗，我数据库表八千多条记录都卡的执行不了，还报错：警告:15:13:48 SocketListener0-1 WARN [root] [Vertica][VJDBC](5156) ERROR: Unavailable: initiator locks for query - Locking failure: Timed out I locking Table:ylods.TEST_LQ. X held by [user dbadmin (select * from (SELECT * FROM ylods.TEST_LQ where 1=2) t where 4 = 5)]. Your current transaction isolation level is SERIALIZABLE；
警告:15:13:48 SocketListener0-1 WARN [root] submiter error happens.
数据提交出错
[Vertica][VJDBC](5156) ERROR: Unavailable: initiator locks for query - Locking failure: Timed out I locking Table:ylods.TEST_LQ. X held by [user dbadmin (select * from (SELECT * FROM ylods.TEST_LQ where 1=2) t where 4 = 5)]. Your current transaction isolation level is SERIALIZABLE
67 评论
为什么导入excel 的时候确是显示已清空 可数据库里还是存在
赞 0 2019-03-06 15:42
可以实现删除现在已有的数据，但是怎么把我要提交的数据也给删除了？
赞 0 2019-02-16 16:54
我的数据也清除了，但是同时Excel提交的数据也清除了，请问有什么经验吗？
赞 1 2019-02-16 16:51
数据我是清理了，可是提交的时候，显示也是成功的，但是再次刷新还是没数据。
赞 2 2018-12-18 15:17
删除数据的原理是做delete操作吗？删除数据数据量受什么限制吗，我数据库表八千多条记录都卡的执行不了，还报错：警告:15:13:48 SocketListener0-1 WARN [root] [Vertica][VJDBC](5156) ERROR: Unavailable: initiator locks for query - Locking failure: Timed out I locking Table:ylods.TEST_LQ. X held by [user dbadmin (select * from (SELECT * FROM ylods.TEST_LQ where 1=2) t where 4 = 5)]. Your current transaction isolation level is SERIALIZABLE；
警告:15:13:48 SocketListener0-1 WARN [root] submiter error happens.
数据提交出错
[Vertica][VJDBC](5156) ERROR: Unavailable: initiator locks for query - Locking failure: Timed out I locking Table:ylods.TEST_LQ. X held by [user dbadmin (select * from (SELECT * FROM ylods.TEST_LQ where 1=2) t where 4 = 5)]. Your current transaction isolation level is SERIALIZABLE
赞 0 2018-10-31 15:09