mysql - Error adding index to mysqlcluster database table -


i using root user (on sql node) , cannot alter/modify database tables accessed remotely. database table accessed locally can modified though. view concurrently used database used show full processlist . below command/errors occured. how past these errors ?

 mysql> alter table `sks_staff_office` add index `pid_index` (pid);     error 1296 (hy000): got error 156 'unknown error code' ndbcluster      mysql> create online index pid_index on sks_staff_office(pid);     error 1296 (hy000): got error 156 'unknown error code' ndbcluster      mysql> alter online table `sks_staff_office` add index `pid_index` (pid);     error 1296 (hy000): got error 156 'unknown error code' ndbcluster

thank you.


-

Popular posts from this blog

python 3.x - PyQt5 - Signal : pyqtSignal no method connect -

following example in doc found on sourceforge faced error. from pyqt5.qtcore import pyqtsignal, pyqtslot def setsignal(): signal = pyqtsignal() signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered") results in attributeerror: 'pyqt5.qtcore.pyqtsignal' object has no attribute 'connect' as mentioned in docs linked, signal needs defined on class level: class foo(qobject): signal = pyqtsignal() def connectsignal(): self.signal.connect(self.myaction) @qtcore.pyqtslot() def myaction(): print("signal triggered")
Read more

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more