Database Errors

[PHAZE FM]

Hey Folks,

Can someone point me in the right direction to fix this issue, i have checked permissions and its not that so it has to be something from when i dumped the database and moved it to another server and re-imported it.

Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(8398,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]David Guetta[[:>:]]';UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Sia[[:>:]]';)

[PHAZE FM]

Hey,

The issue is the error keeps changing but it resolves all around "Database Insert Error: Illegal argument to a regular expression. "

What tipped me off to this is there is gaps in the audio, loike RDJ freezes and becomes unresponsive and then will continue. All of our tracks have been manually edited re cross fades etc (for the most part)

This seems to be only music tracks, every other file is fine.

Here is the latest error from this minutes ago

Code Select Expand

Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(9087,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Maroon 5[[:>:]]';)

[OnePlayRadio]

hello, we too have had and continue to present this error in the database:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

like you, all the songs have been edited in the cue points manually, but every so often we have generated this error. This last one corresponds to the 6th of January of this year.

regrads.

[Marius]

Which version of RadioDJ?

[PHAZE FM]

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'. (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

Your error is your file server / database server is out of system memory or the swap is full. Is your database server linux or Windows?

Which version of RadioDJ?

Hi Marius - 2.0.0.6, Windows 10 Pro x64 Netframework 4.5 (Patched), As you know we have made several adjustments to the database to get our now playing script to work properly with it, however it has been working flawlessly until we had to upgrade from CentOS6 to CentOS 7. I am presuming mysql was upgraded as well

[OnePlayRadio]

Which version of RadioDJ?

in my case is radiodj 2.0.0.1 on an inter i5-3470 equipment of 2,90 GHz and 8 GB of RAM with windows 7 professional and mariadb database of 64bits.

[OnePlayRadio]

This error would seem to be a DB error of some description and not a rdj error.
Have a look at the database logs, also have a look at the windows event logs.

is correct, the error is database and not radiodj, but affects the operation of rdj. We know the effect, but not the cause, in windows events (in my case) I have several errors but the one shown directly as database is:

PI001 ERROR: Can't connect to MySQL server on '127.0.0.1' (10061):
There was an exception of type 'System.OutOfMemoryException'.  (CALL UpdateTracks(1020,0,0,365,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[[:<:]]Evanescence[[:>:]]'; )

I have investigated before because it is not the first time that it happens to me, but I have not been able to find a solution. Some time ago Marius recommended me to use MariaDB and that's what I did, but I still have this kind of events from time to time.

[PHAZE FM]

Guys,

I have said form the start that my issue is with the database, however i am not sure what the error is exactly and how to fix it. I have tried to run a database check from MYSQL and all tables are reporting that they are fine.

I dont want to just overwrite the database as there is some customization for our web player in it.

I dont know how a SQL dump and a SQL import could cause this issue as its a straight export and import

[rkriggs]

Make sure the old system and new system have the exact same version of radio dj.

Randy

[Marius]

One thing I note is that there a 3 [[[.

I noticed too. What is confusing is that the query it doesn't have 3 items. It looks like this:

Code Select Expand

"UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]" & rdjInterface.Utils.QueryFixRegex(sWord.Trim) & "[[:>:]]';"

Even if the "sWord.Trim" variable would contain a bracket, it would not be placed there.

@PHAZE FM:
If you play the track from Maroon 5 which was caused the error, can you reproduce it again? Which version of MySQL do you use?

[PHAZE FM]

Evening Marius,

Please see the specs of our File Server / Database Server below. Admitted the server is overkill for what it does but its better to have to much then not enough for the 4 studios we operate:

CPU:
2x Intel Xeon D-2191 @ 1.60GHZ
18 Cores
36 Threads
24 MB Cache

RAM:
24GB DDR4 1633MHZ ECC

Disks:
10x Seagate Ironwolf Pro NAS 10TB Disks (Raid 10)

Operating System:
CentOS 7.5 x64

Network:
2x Intel Gigabit Ethernet Cards

Database Engine:
Server version: 8.0.13 MySQL Community Server - GPL

Its important that we did a dump from MYSQL 5.x and imported into this SQL version. Mysql is not natively supported on CentOS 7

P.S - It should be noted that we are streaming .wav files across the network live between file server and which ever studio is on air. All studios are spitting our the same error. All studios are on 2.0.0.6

Marius, If you would like me to send you a copy of the database for you to have a look at please let me know and i will send you a DM with a link to download the database to have a look at.

At a guess, i would say that RDJ is NOT compatible with MYSQL 8.X - MYSQL did change alot in this version, so i would not be suprised if the table struture or the way it handles its data has changed between version 5 and version 8.

I did message the MYSQL list and they said that it should not matter, it should be backwards compatible

[PHAZE FM]

Have you looked at the mysql server logs? and while there have you looked for any other logs?

There isnt any other errors, MYSQL on the linux server isnt reporting any of the issues.

Have you tried running the query from the mysql client on the linux server?

No i haven't. If you read my previous reply this issue only happened when we upgraded the database engine (mysql) or the exporting and importing of the database

I would more likely say that the issue is the MYSQL version thats causing issues.

Maruis do you have any ideas as this is a really serious issue that i need fixed

[PHAZE FM]

Marius that was all provided a few posts back....

[PHAZE FM]

Hi All,

Do we have any answers for this?

[PHAZE FM]

On every song change the following error gets spit out into the windows event log:

Code Select Expand

Database Insert Error: Illegal argument to a regular expression. (CALL UpdateTracks(8157,0,0,0,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Blink 182[[:>:]]';)

Where "Blink 182" is the only part that seems to change

There is nothing of significance in the mysql log, just complaining about dns resolution failure for the host name of a server at our backup studio which is switched off