[MCOL-5346] Excessive log messages converting NULL VARCHAR into INT Created: 2022-12-12  Updated: 2022-12-28  Resolved: 2022-12-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 22.08.4
Fix Version/s: 22.08.7

Type: Bug Priority: Major
Reporter: Roman Assignee: Roman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MCOL-4580 Extent's approximate range keeping fo... In Testing
Sprint: 2022-22
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Description   

There are lots of conversion error messages

error in int conversion from ''

in journalctl output running test001.
The MCOL-4580 patch replaced string to int conversion method with additional stderr message if conversion has a flaw or failed. The approach didn't take into account two facts: empty string represents VARCHAR NULL value, empty string conversion always fails. The combination of two causes excessive log messages.
As a temporary solution I will partially revert the original code that existed before MCOL-4580 and create an issue to start TreeNode refactoring in the context of string to integer types conversion.



 Comments   
Comment by Daniel Lee (Inactive) [ 2022-12-13 ]

Build verified: 22.08.7

engine: 57709ddc34021325b7fa6275e6c7df9550d2d000
server: d3049350bb5c61340f5a7518b155d3c9dacdcb33
buildNo: 6228

Tested with 1g ssb database. Verified that no reported errors in mcs-primproc journal.

Used the command "journalctl -u mcc-primproc" to view journal. It is not available in Docker containers since systemd was not installed. Test was done in VM.

Reproduced the issue in release 22.08.4

Dec 13 20:24:01 rocky8.localdomain env[9876]: error in int conversion from ''error in int conversion from ''error in int conversion>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: ersion from ''error in int conversion from ''error in int conversion from ''error in >
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: or in int conversion from ''error in int conversion from ''error in int conversion fr>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: ion from ''error in int conversion from ''error in int conversion from ''error in int>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: in int conversion from ''error in int conversion from ''error in int conversion from >
 
Dec 13 20:24:01 rocky8.localdomain env[9876]:  from ''error in int conversion from ''error in int conversion from ''error in int co>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: int conversion from ''error in int conversion from ''error in int conversion from ''e>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]: om ''error in int conversion from ''error in int conversion from ''error in int conve>
 
Dec 13 20:24:01 rocky8.localdomain env[9876]:  conversion from ''error in int conversion from ''error in int conversion from ''erro>

Generated at Thu Feb 08 02:57:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.