Restore fails

[atakanau]

Updates to fix errors when executing SQL lines starting with description line.

BUT; there are still bugs. TRIGGERs cannot be imported.

message | "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER $\rCREATE TRIGGER trigger_name AFTER INSERT ON table1 FOR ...' at line 1"

line_number | 386 query | "DELIMITER $\rCREATE TRIGGER trigger_name AFTER INSERT ON table1 FOR EACH ROW insert into table2 (id) values (new.id)\r$\rDELIMITER ;\r

MariaDB-10.4.27 mysqlnd 8.2.0 PHP version: 8.2.0

[joanjeremiah]

Can I work on this task? @jesperpedersen

[jesperpedersen]

@joanjeremiah Yes

[joanjeremiah]

I plan to:

1. Increment log level counters in the pgmoneta_log_line function.
2. Store these counters in the config struct as an array.
3. Use this array in prometheus.c's general_information function to log these metrics in the specified manner.

@jesperpedersen Could you confirm if this approach sounds good, or if there are any adjustments you'd recommend?

Thanks!

[jesperpedersen]

Yes, this sound good, so lets see how the patch looks

[jesperpedersen]

How is this going ?

[jesperpedersen]

@joanjeremiah Ping ?

[joanjeremiah]

I started working on this. Couldn't find the time to continue. Will work on it, this weekend.

[jesperpedersen]

@joanjeremiah Still ok on this ?

[joanjeremiah]

@joanjeremiah Still ok on this ?

Sorry, couldnt find time to complete this.

[jesperpedersen]

@joanjeremiah Do you want to be unassigned on it ? It isn't a big task so you should be able to complete it quickly - you can do it

[joanjeremiah]

@joanjeremiah Do you want to be unassigned on it ? It isn't a big task so you should be able to complete it quickly - you can do it

Kindly unassign me

[jesperpedersen]

@joanjeremiah No problem