Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
5.5.1
-
None
-
RHEL 7, Virtualized On Prem
Description
Customer often hit the following errors during DDL. This system is using S3 storage compatible object storage.
Feb 17 08:00:58 x01tfcdb2a writeengine[17168]: 58.397392 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed |
Feb 17 10:09:36 x01tfcdb2a ExeMgr[17145]: 36.976327 |2147483676|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test6' --columnRIDs/FE; || |
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.046950 |2147483676|0|0| D 16 CAL0042: End SQL statement |
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.073842 |28|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test6; |ofadev_db| |
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.087941 |28|0|0| D 16 CAL0042: End SQL statement |
Feb 17 10:22:13 x01tfcdb2a IDBFile[13591]: 13.462810 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so |
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: SessionManager Caught Signal 15 |
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Shutdown StorageManager... |
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Ownership: releasing ownership of data1 |
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: StorageManager Shutdown Complete. |
....
|
Feb 18 07:32:10 x01tfcdb2a writeengine[15283]: 10.768606 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed |
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.920154 |2147483692|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test8' --columnRIDs/FE; || |
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.941173 |2147483692|0|0| D 16 CAL0042: End SQL statement |
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.956631 |44|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test8; |ofadev_db| |
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.962278 |44|0|0| D 16 CAL0042: End SQL statement |
Feb 18 09:33:43 x01tfcdb2a IDBFile[18424]: 43.610045 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so |
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: SessionManager Caught Signal 15 |
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Shutdown StorageManager... |
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Ownership: releasing ownership of data1 |
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: StorageManager Shutdown Complete. |
Feb 18 09:35:49 x01tfcdb2a StorageManager[19815]: Using the config file found at /etc/columnstore/storagemanager.cnf |
Feb 18 09:35:50 x01tfcdb2a StorageManager[19815]: S3Storage: S3 connectivity & permissions are OK |
User can make this work again after stopping/starting the cluster, but it seems it is temporary workaround.
More details is the support ticket.